Additional troubleshooting steps

Show expandable text

Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

If several checks or deposits are missing from the Bank Reconciliation window

  • Verify that the checkbook has the correct GL account number in the G/L Account # field on the General tab of the Setup > Checkbook dialog.
  • Verify that each checkbook is using a unique GL account number.
  • Verify that transactions affecting bank reconciliation have been posted for all periods.
  • Preview a General Ledger report with a Current Year data range. An account displays with a **Chart of accounts notation if the total transactions entered do not match the balance in the Chart of Accounts. Move the GL period back and repost the transactions for each period.

    Note: Unmatched balances may also be caused by creating bank reconciliation adjustments with the GL period to adjust field (on the Summary tab of the Bank Reconciliation window) set to a period in the previous year. To correct this, move the GL period to that period in the previous year and re-post.

    Always verify the GL period to adjust field (on the Summary tab of the Bank Reconciliation window) is set to the correct period before clicking the Post to G/L button.

  • If transactions were entered prior to setting up a checkbook (or entering a checkbook GL account number), they will not be displayed in Bank Reconciliation. Choose Edit > Assign Orphan Checks and determine if there are checks not assigned to any checkbook. Mark each check that should appear in this checkbook and then click the Assign button.

Top of page

If payroll checks are missing from the Bank Reconciliation window

Do the following:

  1. Choose File > Client Properties, click the Payroll tab, and then click the Payroll Journal Entry button.
  2. Mark the Create payroll journal entry checkbox, click OK, and click OK again to close the Client Properties dialog.
  3. From the Payroll Check Entry window, press F3, and choose the Regenerate Payroll Journal Entries command.

Top of page

If missing transaction(s) were converted from another application

All converted transactions are marked as cleared and must be manually entered for bank reconciliation in the Initial Open Items dialog.

Top of page

If future-period transactions appear in the Bank Reconciliation window

If future-period transactions and/or payroll checks displayed in the Bank Reconciliation window are forcing the reconciliation out of balance, move the GL period and the Payroll period back (one period at a time) to the period being reconciled.

  1. Choose File > Client Properties, click the Payroll tab, and then click the Payroll Journal Entry button.
  2. Mark the Prompt for posting date checkbox, click OK to return to the Client Properties dialog, and click OK to close the dialog.
  3. From the CSA main window, choose File > Select Period to Process and change both the GL period and Payroll period back one month.
    1. In the Payroll Check Entry window, choose Edit > Regenerate Payroll Journal Entries.
    2. In the Vendor Check Entry window, choose Edit > Regenerate Vendor Entries.
    3. In the Transactions window, press F5 to post the transactions.

    Repeat this step as you move back one period at a time through the period being reconciled.

  4. Open the Bank Reconciliation window and choose Edit > Rebuild Uncleared Transactions.

Top of page

If you need to remove transactions from the Bank Reconciliation window

Transactions and orphan checks can be permanently deleted from Bank Reconciliation only by selecting the row number or a range of row numbers to the left of the item you want to delete and pressing the Delete key on the keyboard. Transactions deleted from bank reconciliation are not deleted from the data-entry window, although a deleted transaction will not reappear in the Bank Reconciliation window.

To remove a transaction from the client database, delete the transaction from the Tasks > Transaction Entry window.

Top of page

If you need to rebuild the list of uncleared transactions

If you have completed all troubleshooting steps but transactions are still missing from the Bank Reconciliation window, first create a backup of the client data and then choose Edit > Rebuild Uncleared Transactions to have the application completely refresh the transactions listed.

Rebuilding the list of transactions when a Bank Reconciliation is in process will unclear any items that have already been cleared, so you should first create a backup of the client data.

Return to main troubleshooting topic

Top of page

Related topics

Bank Reconciliation WalkThrough (PDF)

Tips for successful bank reconciliation

Bank Reconciliation Troubleshooter

Top of page

Was this article helpful?

Thank you for the feedback!