Journal entry is missing from reconciliation

Learn about why one or more journal entries are missing from your reconciliation.

• The transaction currency of the journal entry does not match the currency of the bank account.

  This can occur when the currency of the bank account is different from the base currency of the company.

• The incorrect GL account was used for the journal entry.
• An incompatible beginning balance cut-off date was used in the first reconciliation.

Transaction currency and currency of the bank account differ

The currency of the bank account might differ from the base currency of the company. Make sure that the journal entry currency matches the currency of the account; otherwise the transaction does not appear up in the reconciliation.

Edit the journal entry and update the transaction currency to match the bank account currency. The journal entry can be in the base currency of the company, but the transaction currency field must match the bank account currency.

Step 1: View the journal entry

1. Go to General Ledger > All > Journal entries.

2. Find the appropriate journal and select Transactions.
3. Find the appropriate journal entry.

4. Select More actions > View at the end of the row.

5. View the transaction currency for the entries.

1. Go to General Ledger > All > Journal entries.

2. Find the appropriate journal and select View transactions.
3. Find the appropriate journal entry and select View.
4. View the transaction currency for the entries.

Step 2: View the base currency of the bank account

1. Go to Cash Management > All or Setup > Accounts and select the required account type.

2. Find the required account.

3. Select More actions > Edit at the end of the row.

4. Find the Currency field.

1. Go to Cash Management > All or Setup > Accounts and select the required account type.

2. Select View beside the account.
3. Find the Currency field.

Does the currency defined on the account match the currency defined for the journal entry?

The GL account for the journal entry is different from the GL account of the bank account

If the GL account for the bank account and the journal entry are different, the journal entry will not appear in the reconciliation.

Step 1. Determine the GL account used for the account

1. Go to Cash Management > All or Setup > Accounts and select the required account type.

2. Find the required account.

3. Select More actions > Edit at the end of the row.

4. Find the GL account in the Accounting information section.

1. Go to Cash Management > All or Setup > Accounts and select the required account type.

2. Select View beside the account.
3. Find the GL account in the Accounting information section.

Step 2. Determine the GL account used for the journal entry

1. Go to General Ledger > All > Journal entries.

2. Find the appropriate journal and select Transactions.
3. Find the appropriate journal entry.

4. Select More actions > View at the end of the row.

1. Go to General Ledger > All > Journal entries.

2. Find the appropriate journal and select View transactions.
3. Find the appropriate journal entry and select View.

Does the GL account used for the bank account match the account used for the journal entry?

The beginning balance cut-off date is inaccurate

If you have journal entries transacted before the beginning balance cut-off date, those transactions will not appear in the reconciliation.

If this is your first time reconciling:

1. Go to Cash Management > All > Reconciliation > Bank.

2. Select the Account to reconcile.

   View the Beginning balance cut-off date.

To view details for a closed reconciliation:

1. Go to Cash Management > All > Reconciliation > View reconciliation histories.

2. Select the type of output for download.
3. Open the downloaded file and view the Beginning balance cut-off date.

Do the journal entries have a date that precedes the beginning balance cut-off date?