Period-end tasks

Using downloaded statements when reconciling accounts


If you download bank or credit card statement files from the Internet to your computer, MYOB AccountEdge will automatically match transactions from the downloaded statement file to those within your company file.

Note:  Do not use the `Send Credit Card Payments for Authorization Using the Record Button' preference if you use the Get Statement feature

File formats

The file formats that are supported by AccountEdge for automatic matching are: OFX, OFC, QFX, QIF. Contact your bank or credit card company for instructions about the actual downloading procedures.

Once the file is downloaded to your computer, use the Get Statement button to find the statement and automatically match your transactions. You'll find the Get Statement button in the Reconcile Accounts window and the Bank Register window. When transactions in the downloaded statement file are matched to transactions in your company file, they are marked as cleared in the Reconcile Accounts window.

Get Statement Log

When you click the Get Statement button, transactions are matched and the Get Statement Log opens. This alert will tell you the number of transactions in the bank statement, the number of transactions read by AccountEdge and if any transactions were skipped. A transaction may be skipped by AccountEdge if it doesn't contain a valid date or amount. The Get Statement Log file, found in your data file, is called the AccountEdge Statement Log.

Unmatched Statement Transactions window

The Unmatched Statement Transactions window opens after the Get Statement log.

If all of the transactions in the downloaded statement file match transactions in your company file, no transactions appear in the Unmatched Statement Transactions window.

Note: What are the criteria for a match between the company and statement files?

If any statement transaction cannot be matched to a transaction in your company file, the statement transaction remains on the Unmatched Transactions window. You can select an unmatched transaction in this window and either:

Warning:  Add or match every unmatched transaction in a single session!

Step by step

Related topics