We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

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. 

   Transactions must have the appropriate bank account selected in the Transactions detail field of Actions > Enter Transactions in order for them to appear in the Bank Reconciliation screen.

   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  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).

      Before you move the general ledger to the earliest year with transactions, consider creating a backup of the client data using the Client Data Management Utility. The utility creates a backup of just the client you are working with.

   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, and then enter the transaction on the Enter Transactions screen.

Was this article helpful?

Yes No

Submit