Home > Managing Banking Information > Using Electronic Bank Statements > Selecting a Downloaded OFX File


Selecting the Downloaded File

When you download an OFX file from your bank or credit card company, save it in one of the special folders that Bookkeeper monitors. These folders are located in the Documents folder (or My Documents folder) on your computer. (See Downloading OFX Files.)

To start the process of matching the electronic file to Bookkeeper transactions, click Yes when Bookkeeper notifies you that it found a new downloaded file. If you click No, you can start the process from the Banking menu.

Note: You don't have to delete any files after processing them. You may want to retain them for a historical record. However, if you rename a file after processing it, Bookkeeper will detect it as a new unprocessed file and prompt you to process it.

To reconcile accounts based on OFX files:
  1. To reconcile a bank account’s downloaded file, choose Banking > Reconcile Bank Account > Electronic Download File.
    To reconcile a credit card account’s downloaded file, choose Banking > Reconcile Credit Card Transactions > Electronic Download File.
  2. In the Electronic Download File Selection dialog box, review the list at the top with the downloaded files that haven’t been processed.
    The list at the bottom display files that have already been processed. You can reduce the number of files that appear in the Processed Files list by selecting a filter from the Show files processed in the last list.
  3. If the file you downloaded doesn’t appear in the Files Awaiting Processing list, to have Bookkeeper move it to the correct folder, click Add File to List. In the Electronic Download File dialog box, locate and select the downloaded file. Then click Open.
    If you haven’t downloaded the most current file, click the Go To Bank Website link to download the file now. Then click Add File To List to locate and select the newly downloaded file in the Electronic Download File dialog box. Click Open.
  4. To begin processing the file, select it in the Files Awaiting Processing list and click Process.
  5. If a message box appears, read the message and click OK.
  6. Reconcile the transactions. (See Matching Transactions or Matching Credit Card Transactions.)
  7. After reconciling the transactions, in the Electronic Download File Selection dialog box, to view the processing history of a previously processed file, click the Details link next to the file. (See Viewing the History of Processed Files.)
  8. Click OK.