← Support Home

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 the base currency of you file. 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

Video Walkthrough

Bank CSV Header/Column Format

BankColumns in data fileHeader Row Required
AmexDate, Amount, Summary, ReferenceYes
ANZ (Australia)Date, Amount, DescriptionNo
ANZ (New Zealand)Date, Amount, DescriptionNo
BendigoDate, Amount, DescriptionNo
Bank Of QueenslandDate, Description, Account, Debit, Credit
BankWestBSB, Account Number, Transaction Date, Description, Cheque, Debit, Credit, Balance, Transaction Type
Banco SabadellOperation Date, Item, Value Date, Amount, Balance, Reference 1, Reference 2
CitibankDate, Summary, Amount, Empty, Empty, Account
Commonwealth Bank of AustraliaDate, Amount, Description, BalanceNo
Heritage Building SocietyDate, Amount, DescriptionYes
Illawarra Mutual Building Society (IMB)Date, Description, Account, Debit, Credit
Lloyds TSBMisc, Account Number, Date, Type, Summary, Debit, Credit, Balance
Macquarie BankAccount Number, Account Name, Transaction Date, Transaction Description, Cheque/Reference Number, Debit Amount, Credit Amount
Macquarie Bank - Cash ManagementDate, Category, Description, Debit, Credit, Balance
Macquarie Bank - TransactionTransaction Date, Description, Product, Category, Subcategory, Notes, Debit, Credit
National Australia Bank - TransactionDate, Amount, Transaction Id, Transaction type, Transaction details, Balance*
National Australia Bank - Credit CardDate, Amount, Reference, , Empty,Transaction type, Transaction details, Balance*No
National Bank (New Zealand)Category, Description, Reference1, Reference2, Reference3, Amount, Date
PayPalDate, Time, Time Zone, Name, Type, Status, Currency, Amount, Receipt ID, Balance
Qantas Credit UnionEffective Date, Entered Date, Summary, Amount
Royal Bank of Scotland, TheSort 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 CSVDate, Amount, Description, ReferenceYes
SabadellOperation Date, Item, Value Date , Amount, Balance, Reference 1, Reference 2
Savings and Loans Credit UnionEffective Date, Entered Date, Summary, Amount
St GeorgeDate, Description, Debit, Credit, Balance
Suncorp MetwayDate, Summary, Amount, BalanceNo
Victoria Teachers Credit UnionDate, Amount, Description, Balance
WestpacBank Account, Date, Narrative, Debit Amount, Credit Amount, Categories, Serial
Westpac PayWayPayWay 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.

Download CSV



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.