Child pages
  • Importing a bank statement

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

Follow this procedure to If you haven't set up bank feeds to automatically bring your bank transactions into AccountRight, you can import bank statements downloaded from your financial institution’s online banking websitebank.

Here's how:

 

UI Expand
expandedtrue
titleTo import a bank statement
  1. Download the statement file from your bank. Your bank’s website should provide instructions on how to download this file, or speak to your bank. The following file formats are supported: OFX, QFX, QIF and OFC. Take note of where you save the downloaded statement.
  2. Go to the Banking command centre and click Reconcile Accounts. The Reconcile Accounts window appears.
    Reconcile accounts window with no transactions
  3. In the Account field, enter the account you want to reconcile.
  4. In the Closing Statement Balance field, type the closing balance that appears on the statement your bank sent you.
  5. In the Bank Statement Date field, enter the closing date that appears on your bank statement and then press Tab. Only unreconciled transactions dated on or before that date will appear.
  6. Click Get Statement. The Select a Bank Statement file window appears.
    Select a bank statement file window with a QIF file selected
  7. Locate and select the statement file you downloaded in step 1.
  8. Click Open. The Get Statement window appears.
  9. Click OK. The statement transactions are automatically matched with the transactions in your company file using the cheque number, date and amount as the criteria for matching withdrawals and deposits.
  10. If the Unmatched Statement Transactions window appears, choose what you want to do for each unmatched transaction:
    • Match: If you've already entered a transaction that matches a statement transaction, select the statement transaction and click Match Transaction. In the Match Transaction window, select the transaction that you want to match and click Match.
    • Add: If you want to add the statement transaction to your company file (spend money or receive money only), select it and click Add Transaction. The Spend Money window or the Receive Money window (depending on the type of transaction you're adding) appears. Enter the details of the transaction and record it.

  11. When you have finished matching and adding all statement transactions, click Done.The Reconcile Accounts window appears.
UI Text Box
typenote

Need to enter a different transaction type?

If you need to add a different type of transaction, such as a receive payment or pay bills, right-click anywhere on the Unmatched Statement Transactions window and choose Enter Transactions then choose the type of transaction you want to enter. Once you've recorded the transaction, you can then Match it on the Unmatched Statement Transactions window

HTML
<div style="display: none;" data-swiftype-name="keywords" data-swiftype-type="enum">import bank transactions</div>
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Create detail and header accounts

Spend money

Reconciling your bank accounts

Resolving out of balance bank reconciliations

Your first bank reconciliation

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max5
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?q=petty+cash&filter=labels%2Clocation%2CsolvedThreads&location=category%3AAccountRight&search_type=thread&solved=true

HTML Wrap
classmorelinks

More »

...