The Reconcile Account window is split into two sections. At the top is the Local Ledger Transactions where your unreconciled transaction records entered in Express Accounts are displayed. At the bottom is where your bank statement is displayed, if loaded.
Local Ledger Transactions
Account
Select the account you wish to reconcile from the pull down list of accounts.
Last Reconciled Date
The last date the selected account was reconciled will appear here.
Bank Statement Date
Enter the statement date that appears on your bank statement, or select a date from the calendar drop-down.
New Statement Balance
Enter the ending balance that appears on your bank statement.
Calculated Statement Balance
The number that appears here is the account's balance before reconciliation.
Out of Balance
If this field contains a value other than zero, you may have errors in your records. As you compare your entries with the bank statement, those errors will probably become apparent.
List of account entries
This is the list of account entries that have not yet been reconciled. For manual reconciliation, tick the checkbox of each entry that has a matching entry on your bank statement to reconcile the entry. For electronic reconciliation, you'll need to load your bank statement into the reconciliation window (see below). Entries that match up automatically will be checked off and will appear in green. To match an entry to an entry in the bank statement transaction's list, click in the Bank's Memo column for the local entry and select the bank entry that matches from the drop menu that appears.
If, during reconciliation, you find errors in your local ledger transactions list, double click the entry to view the entry on the journal, then select the entry and click Edit.
Add a new payment transaction
Click here to add a new payment transaction. If you discover a missing payment entry, clicking this button will allow you to enter the transaction without exiting the reconciliation session.
Add a new receipt transaction
Click this button to add a new receipt transaction. If you discover a missing receipt entry, clicking this button will allow you to enter the transaction without exiting the reconciliation session.
Bank Statement's Transactions
This is the list of bank statement transactions. Entries will not appear in this list until you load a bank statement into the current reconciliation. Entries that match automatically will be checked off and displayed in green. To match an entry to an entry in the local ledger transactions list, click in the Ledger's Ref column for the bank entry and select the local ledger entry that matches. Entries that appear in red are highlighted as possible recurring fee transactions. If you select the entry and click Add Transaction, the entry will be added to the local ledger list, and will be automatically added to the local ledger list every time a bank statement containing the entry is loaded to the Reconcile Account dialog.
Load a bank statement
Click the Load a bank statement to load an external bank statement in CSV or OFX format.
You can use either one of the following formats:
Add Transaction
This button allows you to quickly add an entry from your bank statement to your local ledger. Select an entry in the bank transactions list and click the Add Transaction button to open the Payment or the Receipts dialog.
Rollback to Previous
This button allows you to undo the last reconcile for the selected account. You may want to rollback if you have done a reconciliation by mistake or you have received more transactions that should have been included in the last reconcile.
Please note that this button will only be enabled when there is a valid reconciliation to rollback to and you will only be able to go back at most one reconciliation.