The Current Bank Balance on the Bank Reconciliation Summary Report does not match the Check Register, Bank Account Balance List, or General Ledger.  This can be caused by any of the following:

1.     The Bank Reconciliation Summary is a mathematical report: It is only valid at the time it is reconciled and printed.  If you view a prior month AFTER creating a new bank rec and cleared items, the total for cleared and uncleared items changes the total of the Checkbook balance as of ‘m/d/y’ and the Current Checkbook balance.  When balancing, you should always print a hardcopy or save an electronic copy of the balances at that point in time for future reference.

2.     Tenant Payments and Misc Bank Transactions dated in one month and the Deposit of those funds dated in a future month will cause this issue.   For example, if a tenant payment made 12/28/09 is deposited on 1/3/10, the Bank Balance Summary Report, the Check Register, and the Bank Statement Reconciliation Summary as of 12/31/09 will not include the deposit and therefore will not match the General Ledger, Balance Sheet and Trial Balance cash account balance for the same date.  The General Ledger displays as of the payment transaction date, not the deposit date.

 3.     When selecting "All Properties" on the report selection criteria, it does not include Inactive Properties by default, but the check register will include all property balances including Inactives.  In order to arrive at the same number, you would have to choose "Select Properties,' then go in and choose "Select All" and "Include Inactives."

4.     Transactions with a Bank Account as the offset to another Bank Account will not display in the Bank Reconciliation.  For example, if a user mistakenly enters a Misc. Bank Transaction to account 1000 as an increase and uses the offset account of 1000, on the Increase half of that transaction shows on the bank rec.  That means that the bank statement could be in balance, but it wouldn’t match the GL because the GL will show both a debit AND a credit to the same account.  This also occurs if a bill or a check is written and inadvertently uses the 1000 account as the offset account.

 5.     Verify that all Tenant Payment Credits use a Revenue or Liability account in the Acc to Apply Credit field. Using a Bank Account in the Acc to Apply Credit field will also cause this issue to occur.  To locate these Credits, create a new Bank Reconciliation, and click the Select All button.  This will clear all transactions except Credits applied to Bank Accounts.  You can then search the Check Register for uncleared transactions.

6.     Migrated cash Beginning Balances from Tenant Pro 6.0 can cause the Bank Statement Reconciliation balance to differ from the General Ledger because without the individual outstanding checks being brought over from Tenant Pro 6.0 to Tenant Pro 7, the only way to fix this is for the beginning balance on the bank statement to be edited to take into account those transactions that were recording originally in Tenant Pro 6.0.

7.        Verify that the NSF Bank/Tenant Charges Account are set to a Revenue account and not a Bank Account.

8.       Verify that the Opening Balance of the very first Bank Rec match4es the Beginning Balance of the Bank account.

9.       Verify that the Opening Balance of each Bank Rec matches the Ending Balance on the previous Bank Rec.

10.   Verify that the Ending Balance Matches the Cleared Balance on each Bank Rec.