Trouble-Shooting an Out-of-Balance Bank Reconciliation

 

When printing the bank reconciliation, the Summary screen may show out of balance:

Screen_Shot_2019-01-11_at_11.15.02_AM.png

If out of balance, click Cancel to be returned to the Bank Reconciliation screen.

Take the following steps to review an out of balance bank reconciliation:

Review the Cleared Checks vs. the Bank Statement:

Select the Clear Checks tab > Cleared side menu option.

The total of the cleared checks is displayed at the bottom of the screen:

Screen_Shot_2019-01-11_at_11.22.38_AM.png

The above total should match the total withdrawals on the Bank Statement:

Screen_Shot_2019-01-11_at_11.26.50_AM.png

If the totals in Brief Accounting and the Bank Statement are NOT equal, it means that either additional checks must be cleared OR that cleared items must be uncleared (see Unclearing Transactions below).

To clear additional items, select the "Bank Rec" option from the side menu and proceed to clear addition checks.

If the totals in Brief Accounting and on the Bank Statement are the same, proceed to review the Cleared Receipts.

Review the Cleared Receipts vs. the Bank Statement:

Select the Clear Receipts tab > Cleared side menu option.

The total of the cleared checks is displayed at the bottom of the screen:

Screen_Shot_2019-01-11_at_11.34.39_AM.png

The above total should match the total withdrawals on the Bank Statement:

Screen_Shot_2019-01-11_at_11.26.50_AM_2.png

If the totals in Brief Accounting and the Bank Statement are NOT equal, it means that either additional receipts must be cleared OR that cleared items must be uncleared (see Unclearing Transactions below).

To clear additional items, select the "Bank Rec" option from the side menu and proceed to clear addition receipts:

Screen_Shot_2019-01-11_at_11.52.06_AM.png

If the totals in Brief Accounting and on the Bank Statement are the same, proceed to check the Cleared Dates of the transactions.

Look at the Cleared Date of Transactions:

When transactions are cleared in the Bank Rec module, it's important that the correct month is listed:

Screen_Shot_2019-01-11_at_12.00.26_PM.png

If items were cleared within the incorrect month, the Bank Reconciliation will not balance. To check  the month in which the transaction was cleared:

Select the Trust module > Journal tab (or for general banking transactions, select the Office module > Journal tab).

Double-click on the month in which the transaction was dated.

Double-Click on the transaction to view the the detail.

The transaction detail screen contains a "Cleared Bank" checkbox. If the checkbox is selected, the month in which the transaction is cleared is displayed:

Screen_Shot_2019-01-11_at_12.38.39_PM.png

 

If cleared in the incorrect month, it can be uncleared, then re-cleared in the correct month.

Unclearing Transactions:

On the above detail screen, a single transaction can be uncleared by clicking in the "Cleared Bank" checkbox to remove the checkmark.

Re-clicking in the box after a transaction is uncleared will allow it to be re-cleared in the correct month:

Screen_Shot_2019-01-11_at_12.56.56_PM.png

In the case that transactions were uncleared in the incorrect month, or just to unclear transactions to start a bank reconciliation over, transactions may be uncleared in a batch:

Select the Bank Rec module > Clear Receipts (or Clear Checks) tab.

Make sure the month selected is the month in which the transactions were cleared (may be different than the actual date of the transactions).

Select the "Cleared" side menu option:

Screen_Shot_2019-01-11_at_1.02.00_PM.png

Click in the UnClear column beside the items to UnClear then click the UnClear button at the bottom:

Screen_Shot_2019-01-11_at_1.07.26_PM.png

This will allow the transactions to be cleared again.

Reprint the Previous Month's Bank Reconciliation:

In the case that a transactions was uncleared or cleared in a previous month after the bank reconciliation has been completed, it will cause an imbalance in all subsequent month's bank reconciliations.

In this case, it is necessary to work backwards, reprinting previous month's bank reconciliations until the most recent bank reconciliation that is in balance is found.

To reprint a previous month's bank reconciliation:

Select the Bank Rec module > Clear Receipts (or Clear Checks) tab.

Enter the Account and the month.

Click the Print icon.

Enter the ending bank balance as per the bank statement for that month.

Click the tab key to see if the bank reconciliation is in balance:

Screen_Shot_2019-01-11_at_1.43.57_PM.png

Please contact Brief Legal Software if a discrepancy in a previous month's bank reconciliation is found and assistance is required.

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk