Child pages
  • Import bank and credit card statements

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

If you haven't set up bank feeds for any of your bank accounts or credit cards, you can import an electronic bank statement instead. This will let you work with the bank transactions in the same way you would if you had bank feeds. See Working with bank transactions.

If you've got bank feeds, you don't need to import statements unless you want to import bank transactions from before your bank feed was activated. See Bank feeds.

Downloading statements from your bank

Before you can import a bank statement, you'll need to download it from your internet banking website. Log in to your bank account and save the bank statement as a .QIF or .OFX file. If you have a choice of date formats, choose dd/mm/yy

Tips for importing statements:

  • You don't need to import statements in date order. You can import statements from earlier or later than the last one imported.
  • If you're importing several months’ worth of statements, it's best to import and reconcile them one month at a time. This will make it easier to manage a large backlog of transactions.
  • If you’re not sure what statements you’ve already imported, click the Import History button. See Viewing your bank statement import history.
  • Transactions dated earlier than the date you started using MYOB Essentials your opening balance date can't be imported.

 

UI Expand
expandedtrue
titleImport a bank or credit card statement

Once you’ve downloaded the electronic statements from your online banking website, you can import them into MYOB Essentials on the Bank transactions page.

  1. Go to the Banking menu and choose Bank transactions. The Bank transactions page appears.
  2. Click the Import statements button at the top right of the page.

    The Import bank or credit card statement section appears.
  3. In the Bank/Credit Card Account field, choose which account you want the imported transactions to go into. 
  4. Click Choose file
  5. Find the statement file you want to import and click Open. The Bank transactions window reappears, showing the file name of the statement you chose.
  6. If you’re importing a .QIF format statement, select a Date format if using QIF from the list.

    UI Text Box
    typenote

    .QIF date format

    The date format (dd/MM/yy or MM/dd/yy) must match the format used in the imported statement. If it doesn’t, the statement won't be imported. If this happens, check what format your bank uses when creating the statement file, or open it in a plain text editor and look at the dates, then try importing again.

  7. Click Import Now to import the statement data into the account.
    A message appears at the top of the screen, telling you how many statement lines were imported successfully.
  8. If you want to:
HTML
<h2><i class="fa fa-comments"></i>&nbsp;&nbsp;FAQs</h2><br>
UI Expand
titleI've imported a bank statement and now I have duplicated transactions in MYOB Essentials - what can I do?

This can occur if you've imported a bank statement which includes transactions which have already been brought into MYOB Essentials via bank feeds.

To fix this:

  1. Delete the imported bank statement.
  2. Download a new bank statement from your bank, ensuring the date range doesn't include transactions already in MYOB Essentials.
  3. Import the new bank statement as described above.
UI Expand
titleWhy are some transactions not imported due to their date?

If your imported statement contains transactions which are dated prior to the date you started using MYOB Essentialsyour opening balance date, you'll receive a message similar to this:

"XX statement lines were ignored as the transaction dates are prior to the start date for entering transactions into the system."

Statement transactions will only be imported if they are dated on or after your opening balance date (this is typically the date you started using MYOB Essentials).

HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namemagenta
titleRelated topics
HTML Wrap
classsidebarlinks

Bank statements

Viewing your bank statement import history

Deleting imported bank statements

Working with bank transactions

Bank feeds

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max5
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?q=bank+statements&filter=labels%2Clocation&location=forum-board%3AEssentialsAccounting&search_type=thread

HTML Wrap
classmorelinks
More »