When it is time to reconcile your Express Accounts records with your bank statement, use the Account Reconciliation. You can reconcile manually, or upload your electronic bank statement into Express Accounts for faster reconciliation. To open the Reconcile Account window, click the Transactions menu and select Reconcile Account, or press Ctrl+E. 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: - DATE - JOURNAL MEMO - AMOUNT. Wherein a negative amount corresponds to Payments, and Deposits otherwise.
- DATE - JOURNAL MEMO - DEPOSITS - PAYMENTS. Using this format requires a zero (0) value for blank entries (either deposit or payment).
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. |