Set up GL account reconciliations

Use GL account reconciliations to match debits and credits manually using unique lettering codes.

Create a document sequence

Create a document numbering sequence to use for the lettering codes. Use a length that ensures the codes do not get reused within a fiscal year.

For example, select the following options when you create the document sequence:

• Sequence type: Alpha

• Primary sequence maximum: zzz

• Next primary sequence: aaa

To create the sequence: 

1. At the top level, go to Company > Setup > Settings and select Add (circle) next to Document sequences.

2. Enter the required fields, and any other information that you want to include in your sequence.

   The required fields are:

   • Sequence ID

     Cannot be changed after save.

   • Sequence name

   • Sequence status

   • Sequence type

     Cannot be changed after save.

   • Primary sequence

     Cannot be changed after save.

   • Next primary sequence

     Automatically generated, but can be edited.

3. Select Save.

Enable GL account reconciliations

GL account reconciliations is enabled at the top level for all entities.

1. At the top level, go to General Ledger > Setup > Configuration.

2. In the Accounting settings section, under Transactions, select Enable GL account reconciliations.

3. Select a default GL account reconciliations sequence.

   This will be used as the default sequence for all accounts that are set up for GL account reconciliations. But you can select a different sequence when you enable GL account reconciliations for an individual account.

4. Select Save.

Enable GL account reconciliations for specific accounts

GL account reconciliations can be enabled for General Ledger accounts that meet the following conditions: 

• The account is a balance sheet account

• The account is not mapped to a checking, savings, or credit card account record set up in Cash Management.

• The account is not an offset account on the Configure Accounts Payable or Configure Accounts Receivable pages.

• The account is not designated as a General Ledger alternative account for Accounts Payable or Accounts Receivable.

For more information about offset and alternative accounts see the following articles: 

• Override the GL account in AP transactions

• Override the GL account in AR transactions

Start by identifying which General Ledger accounts require GL account reconciliations. Then, follow these steps to set up the accounts: 

1. Go to General Ledger > All > Accounts > General Ledger accounts.

2. Find the account that you're updating.

3. Select Edit at the end of the row.

4. Select Enable GL account reconciliations for this account.

5. Optionally, select a GL account reconciliations sequence.

   The default GL account reconciliations sequence selected in Configure General Ledger will be used if you do not select one here.

6. Select Save.

1. Go to General Ledger > All > Accounts > General Ledger accounts.

2. Find the account that you're updating and select Edit.

3. Select Enable GL account reconciliations for this account.

4. Optionally, select a GL account reconciliations sequence.

   The default GL account reconciliations sequence selected in Configure General Ledger will be used if you do not select one here.

5. Select Save.