Troubleshooting an unreconciled amount in bank account reconciliation

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

There are a variety of reasons why you might have an unreconciled amount on your bank reconciliation in Accounting CS. Use the following steps to troubleshoot where the unreconciled amount is coming from and how you can fix data to reconcile the bank account.

Verify the bank reconciliation

See also: Bank account reconciliation workflow

  1. Choose Actions > Reconcile Bank Accounts and click the General Information tab.
  2. Verify that the amounts you entered in the Statement Information section match the statement from the bank.
  3. On the Deposits & Additions tab, verify that the Cleared total matches the Statement Amount.
    1. If necessary, clear, unclear, or clear additional items for a different amount.
  4. On the Checks & Payments tab, verify that the Cleared total matches the Statement Amount.
    1. If necessary, clear, unclear, or clear additional items for a different amount.
  5. Verify that all of the transactions on the bank statement appear on both the Reconcile Bank Accounts and Enter Transactions screens in Accounting CS. 
    1. Verify that the transaction date falls within the statement period on the General Information tab.

      Transactions are listed on the Reconcile Bank Accounts screen based on the transaction date and not the posting period.

      1. Choose Actions > Enter Transactions and highlight the transaction in the list.
      2. Verify that the Date field has a date that falls within the Statement dates on the Actions > Reconcile Bank Accounts screen on the General Information tab.
    2. Verify that the transaction is distributed to the correct bank account.
      1. Choose Actions > Enter Transactions and click on the Edit Multiple Transactions link.
      2. In the dialog, choose Transfer from the Action field.
      3. Select the transactions to transfer to the proper bank account.
      4. Modify the bank account field on the transaction by selecting the transaction from the list.
    3. Verify that the transaction was not previously cleared on a different reconciliation.
      1. Choose Actions > Enter Transactions and highlight the transaction in the list.
      2. On the status bar, verify that there is not an item saying "Cleared on date".
  6. If this is the first bank reconciliation for a client converted from Creative Solutions Accounting (CSA), all of the transactions were converted as cleared. Use the following steps to enter the transactions that were still open when you completed the final Bank Reconciliation without re-posting them to the General Ledger.
    1. Choose Actions > Reconcile Bank Accounts.
    2. Choose Edit > Initial Open Items.
    3. Enter all of the "in transit" items from the last CSA bank reconciliation, regardless if they are cleared on this reconciliation. Tip: If you have a lot of transactions to enter, you can enter the sum of the transactions that are cleared on this reconciliation, and then enter the rest of the transactions individually.

Additional troubleshooting

  1. If the statement is still unreconciled, use the Reconciliation Analysis tab to start determining where the unreconciled amount is coming from. Skip this step if this is the first reconciliation for the client.
  2. A transaction may have a date that falls outside of the posting period.
    1. Choose Actions > Enter Transactions and click the Bank Account Mode Bank Account Mode button on the toolbar. To display the running balance in the Balance column (when the Bank Account method is selected in the Enter Transactions Options dialog), you must sort the transactions by date and remove any Searching or Filtering that may eliminate bank transactions.
    2. Click the Date column to sort the list of transactions by date. You should see a Balance column and a running bank balance.
    3. Choose Actions > Analyze Client Activity > General Ledger.
    4. Locate the account assigned to the bank account, and compare the balance on the GL to the balance on the Enter Transactions screen.
    5. If the balances are the same, skip to step 3. If they are different, click here for the steps to resolve.
      1. Download the Transaction Date and Posting Period Mismatch Worksheet from the Accounting CS Library.

        Note: This report works best for clients with a monthly processing period frequency. If you have a client with a different period frequency, you may not need to edit all of the items that appear on the report.

      2. Choose File > Print Reports and preview the report.
      3. Any transactions that appear have dates that do not fall within the same month and year as the posting period. Print this report, or move it to another monitor so you can easily reference it.
      4. Choose Actions > Enter Transactions.
      5. Find and fix any transactions that appear on the report.

      See also: Potential reasons that certain transactions are not available to be modified

  3. Verify that transactions are correctly distributed.
    1. Choose Actions > Analyze Client Activity > General Ledger.
    2. Locate the 999 (Undistributed) account and click to drill down to see if there are transactions crediting or debiting this account.
    3. If there are transactions listed under the 999 account, click the amount to go directly to that transaction on the Enter Transactions screen and correct the distribution.
  4. If this client was converted from CSA, go to Enter Transactions and look for a transaction with the reference of BalAdj. If this is the amount of the unreconciled amount, delete it. Note that you may need to change your posting period to delete a BalAdj entry from a prior year.
  5. Verify that the ending balances match the beginning balances for the following year.
    1. Choose Actions > Enter Trial Balance.
    2. Click the View Maintenance link.
    3. Add columns for the adjusted balance of a year followed by the beginning balance of the following year for as many years as you have data for the client.
    4. If you find a mismatch, choose Actions > Enter Transactions in Bank Account Mode. To display the running balance in the Balance column (when the Bank Account method is selected in the Enter Transactions Options dialog), you must sort the transactions by date and remove any Searching or Filtering that may eliminate bank transactions.
    5. Sort the list of transactions by date, and then scroll to the earliest dated transaction. Make a note of what year this transaction is dated for.
    6. Choose Actions > Change Posting Period and move to the earliest year with transactions (noted in the step above).
    7. Choose Actions > Change Posting Period again and close to the next year. Repeat this step until you are in the current processing year.
  6. If this client was converted from CSA, it is possible in rare cases that a transaction did not convert. Compare the Bank account reconciled amount on the Account Summary tab to the GL. If the amount is different, look for a transaction in CSA with that amount that may not have converted to Accounting CS.

Related topics

Unfinalizing a reconciled bank account

Bank account reconciliation workflow

Bank account reconciliation overview

Reconciling the first bank reconciliation

Internal notes


Bank account toggle

In rare cases, a transaction may not have saved correctly to the database, and does not tie to the bank's GL account. This is NOT a recommended troubleshooting step unless all of the above steps have been taken. It is EXTREMELY important to follow these steps exactly. Note that this process may take a fair amount of time, depending on how many transactions exist that affect this bank account.

  1. Choose Setup > Chart of Accounts and add a new account.
  2. Choose Setup > Bank Accounts and edit the bank account.
  3. Change the GL account to the new account you just added.
  4. Click Enter to save the change. This will take some time because it is reassigning all existing transactions in the database for this client.
  5. Edit the bank account and change the GL account back to the original account. Again, this will take some time.
  6. Choose Setup > Chart of Accounts and mark the new account inactive.
  7. Choose Actions > Reconcile Bank Accounts and verify that the unreconciled amount is zero.

Share This