Importing a Bank Statement into MYOB Ledger

https://help.myob.com/wiki/x/tkHnAQ

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0

1

2

3

4

5

Very dissatisfied

Very satisfied

Why did you give this rating?

It's hard to find information

Instructions are hard to follow

Content isn't detailed enough

It doesn't fix my software problems

Anything else you want to tell us about the help?

You can import bank statements into MYOB Ledger via the Cashbook website.

Before you can import a bank statement, you'll need to download the from your internet banking website. Save the bank statement as a .QIF file, and if you have a choice of date formats, choose dd/mm/yy.

For instructions on how to download bank statements from your bank, refer to the help in your online banking website. You can also search Google for your bank's instructions, e.g. search for "download bank statement ANZ" or "download QIF file westpac", etc.

This article relates to MYOB ledger and Cashbook.

For information on importing a bank statement in Essentials Accounting or AccountRight, refer to:

MYOB Essentials: Import bank and credit card statements
MYOB AccountRight: Importing a bank statement

To import transacations from a bank or credit card statement

To import bank transactions

From within AE/AO, navigate to your client's Client Accounting > Trial Balance (or Workpapers) tab.
On the Tasks bar, click Launch AE/AO Ledger. The cashbook.myob.com.au or cashbook.myob.co.nz website opens in a new web browser.
Click Banking and from the drop-down menu, choose Import bank statement.
Select the bank or credit-card account to import transactions to.
Click Import button. A file window appears.
Select the .QIF file you want to upload, and click Open. The import process begins

If the import is successful, the View and match transactions page appears, displaying the status of the import and the imported transactions. Allocate these transactions to the appropriate account.

All previously imported bank statements are listed in the Import Bank Statement page. If you need to "undo" the import, click the drop-down arrow Bank Statement in the Import Bank Statement page and click Undo.

Related topics

Selecting account mapping options

Previewing mapped accounts

Using the Opening Review Wizard

Page tree

Was this information helpful?

Why not?

How would you improve this page?

Thanks! Anything you'd like to add?