If your Bank Reconciliation doesn’t balance, there are several things you could look for. The following is a checklist of possible causes:
-
- The General Ledger may have been corrupted due to a system crash. If this is the case, you should view the General Ledger report for ALL months in the list. This recalculates the GL and should bring the correct balances into the Bank Rec.
-
- An incorrect starting balance was entered for your cash account. If this is the case, you can correct the beginning balance on the Account Balances window. For details, see your MultiLedger User Manual. The balance you enter on the Account Balances window should be your actual cash account balance as of your Start Month.
-
- The amount entered in the Bank Statement Balance edit box on the Bank Reconciliation window contains the beginning balance on your bank statement and not the ending balance on your bank statement. The balance you enter should be the amount that your bank statement shows as the ending balance.
-
- You have an incorrect amount entered in the Outstanding Not Entered edit box on the Bank Reconciliation window. The only items that should be entered in the Outstanding Not Entered edit box are checks and deposits that were written in a period prior to your Start Month with MultiLedger. As these items clear, you should subtract them out of the amount in the Outstanding Not Entered edit box.
-
- You have not entered all cash transactions for the period that you are trying to reconcile. If you have any cash transactions, such as bank service charges, finance charges, credit card fees, or interest, you should record these using the General Journal.
-
- A transaction amount in MultiLedger does not match an amount on the bank statement. You should verify that all amounts on the Bank Reconciliation window match the amounts that appear on your bank statement.
-
- You are using an incorrect Cutoff Date.
-
- You recorded a cash transaction to a different cash account. When you open the Bank Reconciliation window the cash account shown is the one that was set up for the “Cash Account” category on the Interface Accounts window. To change accounts, click the account shown and choose another from the pop-up list of accounts.
-
- While entering a transaction, you recorded a debit and a credit to the cash account. If a positive amount and a negative amount appear on the Bank Reconciliation window with the same reference number and date, you have probably recorded a debit and a credit to the cash account. You can modify the transaction in the journal in which it was entered.
-
- You inadvertently cleared something that shouldn’t have been cleared. You can check Show Cleared Items before clicking Show Transactions. This will show you a list of uncleared transactions as well as transactions that have been marked as cleared. Click a transaction to un-clear it and remove the check mark.