Importing a Bank Statement into MYOB Ledger
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
Importing a bank or credit card statement
You can import bank statements into an 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.
Follow the instructions below to first nominate a bank account, then import transactions into the nominated account.
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 Settings and from the drop-down menu, choose Account List.
- Click on the bank account you wish to import the bank statement to and select the Bank account checkbox.
You can now import bank statements to this account.
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.
Don't have any accounts to choose from? Make sure you've specified a bank account. See the previous task for details.
- 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.
Un-importing a bank or credit card statement
You may need to "undo" the import for a number of reasons, for example – where you've imported the wrong statement or imported the same statement multiple times.
When you undo the import, all transactions imported in that batch will be removed.
You can undo a bank or credit card statement import from the cashbook (AE/AO ledger) website as follows:
To delete imported bank or credit card statements
From your client's Client Accounting > Trial Balance (Workpapers) tab, click Launch AE/AO Ledger.
In the cashbook website, click Banking and from the drop-down menu, choose Import bank statement.
Click on the drop-down arrow next to the imported statement you wish to delete.
Click Undo.
The statements disappears from the list of imported bank statements and all transactions imported are removed from the ledger.