Troubleshoot an unreconciled amount in bank account reconciliation

Double-check the bank reconciliation

Select
Actions
,
Reconcile Bank Accounts
, then the
General Information
tab.
Make sure that the amounts you entered in the
Statement Information
section match the statement from the bank.
On the Deposits & Additions tab, make sure that the Cleared Total matches the Statement Amount.
On the Checks & Payments tab, make sure that the Cleared Total matches the Statement Amount.
Make sure that all of the transactions on the bank statement appear on both the Reconcile Bank Accounts and Enter Transactions screens in the application.

Double-check the transaction date falls within the bank statement period

Double-check that the transaction is distributed correctly

Double-check that the transaction hasn't been previously cleared

Select
Actions
, then
Enter Transactions
. Select the transaction on the list.
On the status bar, make sure that there is not an item saying "Cleared on [date]."

Double-check if this is the 1st bank reconciliation for a client

Select
Actions
, then
Reconcile Bank Accounts
.
Select
Edit
, then
Initial Open Items
.
Enter all of the "in transit" items from the last bank reconciliation, regardless if they are cleared on this reconciliation.

Double-check where unreconciled amount is coming from

Double-check if transaction date is outside posting period

Select
Actions
, then
Enter Transactions
. Select
Bank Account Mode
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), sort the transactions by date and remove any Searching or Filtering that eliminates bank transactions.
Select the Date column to sort the list of transactions by date. There should be a Balance column and a running bank balance.
Select
Actions
,
Analyze Client Activity
, and
General Ledger
.
Locate the account assigned to the bank account, and compare the balance on the GL to the balance on the Enter Transactions screen.

Download the Transaction Date and Posting Period Mismatch Worksheet from the Accounting CS Custom Report Library.
Select
File
then
Print Reports
to preview the report.
Any transactions that show on the report have dates that don't fall in the same month and year as the posting period. Print this report or move it to another monitor so you can reference it.
Select
Actions
then
Enter Transactions
.
Find and fix any transactions that show on the report.

Make sure transactions are distributed correctly

Select
Actions
,
Analyze Client Activity
, then
General Ledger
.
Locate the 999 (Undistributed) account and locate any transactions that are crediting or debiting this account.
If there are transactions listed under the 999 account, select the amount to go directly to that transaction on the Enter Transactions screen and correct the distribution.

Make sure that the ending balances match

Select
Actions
, then
Enter Trial Balance
.
Select the
View Maintenance
.
Add columns for the adjusted balance of a year followed by the beginning of the following year for as many years as you have data for the client.
If you find a mismatch, select
Actions
, then
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 window), sort the transactions by date and remove any Searching or Filtering that may eliminate bank transactions.
Sort the list of transactions by date, and then go to the earliest dated transaction. Make a note of what year this transaction is dated.
Select
Actions
, then
Change Posting Period
. Move to the earliest year with transactions.
Select
Actions
, then
Change Posting Period
again and close to the next year. Repeat this step until you're in the current processing year.

Bank makes an error