Import Bank Statement

There are number of reasons that you might want/need to import your bank transactions into Saasu from your online banking export files. This export/import file needs to be in the CSV (Comma Separated Value) format.

The bank transactions and the bank account you are importing into will need to be the same currency as your file base currency. Let’s say you have a file in AUD. You can only import transactions to bank accounts in AUD currency, and not in other foreign currencies such as EUR/USD.

  1. Go to Automate > Bank Feeds.
  2. Choose your Bank Account from the drop down.
  3. Click the Import link.
  4. Select the Bank and Select the format.
  5. Click Choose and select your file. Then click Import.
  6. Go to Automate > Bank Feeds to view the transactions.

Things to check before importing

  • Ensure that your file format remains as CSV and that if you open it in an application such as Excel before importing, the format of the fields or the file type hasn’t changed.
  • Compare the expected header row/column arrangement from the file you downloaded with the import format we are expecting for your bank (see list below). At times banks change the download format without notice. If this is the case please contact the Support Team and we can assist further.
  • Check the date format used and ensure no dollar sign are being used for amounts
  • If extra details such as account number and business name are being displayed in the top rows, please remove these before importing.
  • Some institutions will use a header row in the CSV file and some will not. Please refer to the table below to ensure that your data matches the format required.

Video Walkthrough

Bank CSV Header/Column Format

Bank Columns in data file Header Row Required
Amex Date, Amount, Summary, Reference Yes
ANZ (Australia) Date, Amount, Description No
ANZ (New Zealand) Date, Amount, Description No
Bendigo Date, Amount, Description No
Bank Of Queensland Date, Description, Account, Debit, Credit
BankWest BSB, Account Number, Transaction Date, Description, Cheque, Debit, Credit, Balance, Transaction Type
Banco Sabadell Operation Date, Item, Value Date, Amount, Balance, Reference 1, Reference 2
Citibank Date, Summary, Amount, Empty, Empty, Account
Commonwealth Bank of Australia Date, Amount, Description, Balance No
Heritage Building Society Date, Amount, Description Yes
Illawarra Mutual Building Society (IMB) Date, Description, Account, Debit, Credit
Lloyds TSB Misc, Account Number, Date, Type, Summary, Debit, Credit, Balance
Macquarie Bank Account Number, Account Name, Transaction Date, Transaction Description, Cheque/Reference Number, Debit Amount, Credit Amount
Macquarie Bank – Cash Management Date, Category, Description, Debit, Credit, Balance
Macquarie Bank – Transaction Transaction Date, Description, Product, Category, Subcategory, Notes, Debit, Credit
National Australia Bank – Transaction Date, Amount, Transaction Id, Transaction type, Transaction details, Balance*
National Australia Bank – Credit Card Date, Amount, Reference, , Empty,Transaction type, Transaction details, Balance* No
National Bank (New Zealand) Category, Description, Reference1, Reference2, Reference3, Amount, Date
PayPal Date, Time, Time Zone, Name, Type, Status, Currency, Amount, Receipt ID, Balance
Qantas Credit Union Effective Date, Entered Date, Summary, Amount
Royal Bank of Scotland, The Sort Code, Account Number, Account Alias, Account Short Name, Currency, Account Type, BIC, Bank Name, Branch Name, Date, Narrative #1, Narrative #2, Narrative #3, Narrative #4, Narrative #5, Type, Debit, Credit
Saasu CSV Date, Amount, Description, Reference Yes
Sabadell Operation Date, Item, Value Date , Amount, Balance, Reference 1, Reference 2
Savings and Loans Credit Union Effective Date, Entered Date, Summary, Amount
St George Date, Description, Debit, Credit, Balance
Suncorp Metway Date, Summary, Amount, Balance No
Victoria Teachers Credit Union Date, Amount, Description, Balance
Westpac Bank Account, Date, Narrative, Debit Amount, Credit Amount, Categories, Serial
Westpac PayWay PayWay ClientNumber, Merchant Id, Card PAN, Card CVN, Card Expiry, Customer Bank Account,Your Bank Account, Your Bank Reference, Transaction Source, Order Type, Principal Amount, Surcharge Amount, Amount, Currency, Order Number, Customer Reference Number, Customer Name, ECI, User, No Retries, Original Order Number, Original Customer Reference Number, Summary Code, Response Code, Response Text, Receipt Number, Settlement Date, Card Scheme Name, Credit Group, Transaction DateTime, Status, Authorisation Id, File Name,BPAY Ref, BPAY Ref for Excel
Westpac (New Zealand) Date, Amount, Other Party, Description, Reference, Particulars, Analysis Code

Create a Saasu CSV format

If you want to import data from your bank export file and it format for your bank doesn’t appear above, create a spreadsheet (CSV format) with these columns in the order listed. Note: Header row is required. Data/Descriptions must not contain commas.

  • Date– (dd/mm/yyyy i.e. 20/06/2007) NOTE: If you enter the month in letters, make sure they are three letter abbreviations of the English calendar. e.g. January = Jan.
  • Amount – Negative (-) for a purchase and positive (+) for sales. No dollar signs, commas, or period formats should be used.
  • Description – Transaction description e.g. Bank fees.
  • Reference – Transaction reference i.e. EFT123456.

PayPal Data

Saasu provides you the capability to import your merchant or personal PayPal statements. Before importing the statement, you need to setup an Account which is flagged as a bank account using the checkbox. This represents your PayPal account in Saasu.

Getting your PayPal data file

  1. Sign in to your Paypal account.
  2. Bring your mouse pointer over History in the Navigation Bar.
  3. Click on Download History.
  4. Enter the date range you need to import your statement for.
  5. Click on Comma Delimited – Completed Payments from the Files types for download pick list.
  6. Click on Download History.
  7. Save the statement onto a preferred location in your computer.

Note: Saasu only supports importing transaction in your base currency from PayPal at present. You will need to filter out and remove foreign currency transactions from your file.

Setting up a Bank Account for PayPal

A Paypal account is very similar to a day to day Bank Account, and regardless whether you are only receiving money into it or just using it for payments the running balance will never be a negative. To create a PayPal account:

  1. Go to Add > Bank Account
  2. Choose the Type to be Asset
  3. Enter the Account Name to be PayPal

For multi-currency PayPal accounts create one PayPal Bank Account in Saasu for each currency.

Importing your PayPal file

We will import the PayPal file via the Bank Import area:

  1. Go to View > Import or Export > Import Bank Data.
  2. Choose the PayPal bank account you set up earlier.
  3. Choose the bank for this import to be PayPal.
  4. Browse and load the file to bring in your transaction ready for finalising.

FAQ’s

Are these transactions now in my records?

No they are just in the Inbox of your bank feed (Automate > Bank Feeds). You need to match/reconcile them to existing transactions or create new transactions. You can find more information in this help note on Bank Feed Matching.

Why isn’t the first line of my CSV file importing?

The first line of any CSV file that you import is required for the header information for each column and will never be imported.