DOWNLOAD BANK STATEMENTS FROM THE INTERNET

If your bank offers downloadable statements via the internet, you can use the Get Statement function to bring these statements into MYOB and, by automatically matching identical statement transactions against those in MYOB, save time and effort.

Matched transactions are marked as cleared in the Reconcile Accounts window. If MYOB cannot find a match you have the option of matching the transactions manually, adding them to MYOB or skipping them.

To download statements from the internet:

  1. Log-on to your internet bank account and select the appropriate export function
  2. Specify the appropriate export format for MYOB (OFX, OFC, QFX, or QIF)
  3. If you are asked to Open or Save the downloaded file select Save
  4. Save with a suitable file name in a suitable location

To use statements downloaded from the internet:

  1. Go to the Banking Command Centre
  2. Choose Reconcile Accounts
  3. Enter the Bank Statement Date
  4. Click the Get Statement button
  5. Locate the bank statement file downloaded from the internet and click Open
  6. Confirm downloaded transactions by clicking OK
  7. Transactions in the downloaded file are automatically matched to transactions in MYOB and are marked as cleared in the Reconcile Accounts window
  8. If no match is made between a statement transaction and a transaction in the MYOB file, these transactions will appear in the Unmatched Statement Transactions window
  9. You can select any transaction and either Match the statement transaction to a previously recorded transaction or Add the statement transaction to your MYOB data file
  10. To Match the statement transaction, highlight the transaction you wish to match
  11. Click the Match Transaction button to open the Match Transaction window
  12. In the Match Transaction window highlight the uncleared transaction that matches the selected statement transaction
  13. Click Match
  14. To Add the statement transaction to your MYOB file highlight the transaction you wish to add
  15. Click the Add Transaction button to open the appropriate MYOB transaction screen
  16. Complete the transaction and click Record
  17. Click Done

It is recommended that every unmatched transaction is matched or added before you click the Done button.

For further assistance: Contact Melanie Jenkins
Download this MYOB Help Sheet with accompanying images to assist you with each step below…

DOWNLOAD BANK STATEMENTS FROM THE INTERNET

Recent Comments

No Comment.

Awards

Our Location

MJA Business Solutions
Suite 3/24 Edgar Street,
Coffs Harbour NSW 2450

The Big Red Building
Cnr Mildura & Edgar St

PO Box 4504
Coffs Harbour Jetty NSW 2450

Make Appointment

Please fill up the form below.