Child pages
  • Import bank and credit card statements

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »


 

 

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?

Anything else you want to tell us about the help?

Import bank and credit card statements

note :  Do you need to do this task?

You only need to import statements if you have bank or credit card accounts that you haven’t set up a bank feed for. See Bank feeds.

After you’ve downloaded your bank and credit card statements from your bank’s online banking site, you can import all the transaction details in these statements into LiveAccounts from the Banking page.

You can then use these details to allocate and match your bank transactions to your LiveAccounts transactions, and reconcile the bank’s figures against those in LiveAccounts.

As an added benefit, it provides an automatic check of the bank’s figures, fees and interest.

Downloading bank and credit card statements from your bank

Before you can import your statements in LiveAccounts’s Import Bank or Credit Card Statement window, download the statement files from your internet banking site, and save them on your computer or network.

You can import bank and credit card statements into LiveAccounts in two formats: .OFX and .QIF. Make sure you download your statements in one of these formats.

If you don’t use internet banking, you usually need to register to do so. Contact your bank or financial institution for more information.

To download bank and credit card statements from your bank

        1. Go to your online banking website for this account and log in.
        2. Download your statements in .OFX or .QIF format, saving them to a new folder on your computer or network.

note :  Date format

If you have a choice of date format when downloading statements, choose dd/mm/yy.

Ensure that each statement has a unique, easily identifiable name. Also make a note of the location your statements were saved to, so you can find them easily.

        1. To import your downloaded statements into LiveAccounts, see Importing bank and credit card statements into MYOB Essentials.
          Importing bank and credit card statements into MYOB Essentials

note :  Do you need to do this task?

You only need to import statements if you have bank or credit card accounts that you haven’t set up a bank feed for. See Bank feeds.

Once you’ve downloaded the electronic statements from your online banking website, you’re ready to import them into LiveAccounts from the Banking page.

Before importing your bank and credit card statements

Before you import your statements, take note of the following:

n You can import statements that are earlier or later than the last one imported.

n If you want to import several months’ worth of statements, we suggest you import and then reconcile them one month at a time. This should make it easier to manage a large backlog of transactions.

n If you’re unsure which statements you’ve imported previously, go to the Import History page for this account. For more information see Viewing your bank statement import history.

To import bank and credit card statements

        1. Click Banking. The Bank transactions page appears.
        2. Click the Import Bank or Credit Card Statement link above the Bank transactions list. The Import bank or credit card statement window appears.
        3. In the Bank/Credit Card Account field, select the account you want to import statements for.

Details of the last statement and transaction you imported for this account appear. Check these details to make sure you don’t import a statement twice, or skip a statement.

        1. In the Statement file field, click Browse. The Windows File Upload window appears.
        2. Locate the statement file you want to import and click Open. The Import bank or credit card statement window reappears, with the file path listed in the Statement file field.
        3. If you’re importing a .QIF format statement, select a Date format if using QIF from the list.

note :  .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, a message will appear after you click Import Now, and the statement will fail to import. If necessary, change the date format, or edit the date(s) in the statement using a plain text editor and re-import the statement.

        1. Click Import Now to import the statement data into the account.

A message appears, telling you how many statement lines were imported successfully.

        1. Click OK to confirm.
        2. If you want to:

n import more statements to this or other accounts, repeat from step 1.

n continue processing this statement, go to Working with bank transactions.