Home > Managing Banking Information > Using Electronic Bank Statements > Matching Transactions

Matching Transactions

Reconciling your Bookkeeper transactions with the transactions in a downloaded OFX file doesn’t replace monthly account reconciliation with you regular bank statements. It’s meant to serve as an interim reconciliation so that missed transactions can be added or other transactions adjusted, if necessary.

After you click Process in the Electronic Download File Selection dialog box, Bookkeeper attempts to match the transactions in the download file to the account that is currently active in Bookkeeper. Matched transaction have a check mark in the Match column on the left side of the dialog box.

To match bank account transactions:
  1. In the Electronic Download File Reconciliation dialog box, make sure that the bank account showing in the For Account list corresponds to the account for the downloaded file. If it doesn't match, select the corresponding account from the For Account list.
  2. If needed, specify a transaction type for either list.
  3. If needed, specify a date range for the Unreconciled Database list.
  4. To include previously reconciled items in the Unreconciled Database list, select the check box at the bottom of the dialog box.
    If you’ve already reconciled your account with a monthly statement, the reconciled transactions don’t appear in the Unreconciled Database list. If some of the reconciled transactions are in the Items On Downloaded list, you can view and match them by selecting the check box.
  5. If you wish, to help you find specific transactions, click a column heading to re-sort items in either list.
  6. Review the matched transactions to make sure that they are the correct matches.
    If you need to unmatch a pair of transactions, select one of the matched pair and click Unmatch. To remove all the matches, click Clear Matches.
  7. To reconcile unmatched transactions, select an item in the Items on Downloaded list and the corresponding item in the Unreconciled Database list. Then click Match.
  8. If you need to add a transaction to Bookkeeper that appears in the downloaded file, select the transaction  in the Items On Downloaded list, Then, select the type of transaction in the Add Missing Transaction list.
    Bookkeeper opens the relevant dialog box for you to create a new transaction. After the new transaction appears in the Unreconciled Database Transactions list, you can match it to the transaction in the Items On Downloaded list.
  9. Make sure all the transactions in the Items On Downloaded list are matched to transactions in the Unreconciled Database Transactions list before clicking OK to close the dialog box.
  10. After you've reconciled the statement, click OK.