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, downloaded from your internet banking platform.

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 and choose your Bank Account from the drop down.
  2. Click the Import link.
  3. Select the Bank and Select the format.
  4. Click Choose and select your file. Then click Import.
  5. 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

∗ Denotes that the file requires a header row.

Amex * – Date, Amount, Summary, Reference ANZ (Australia) – Date, Amount, Description ANZ (New Zealand) – Date, Amount, Description

Bendigo – Date, Amount, Description

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

Heritage Building Society * – Date, Amount, Description

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

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

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

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.