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.
- Go to Automate > Bank Feeds.
- Choose your Bank Account from the drop down.
- Click the Import link.
- Select the Bank and Select the format.
- Click Choose and select your file. Then click Import.
- 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.
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.
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
- Sign in to your Paypal account.
- Bring your mouse pointer over History in the Navigation Bar.
- Click on Download History.
- Enter the date range you need to import your statement for.
- Click on Comma Delimited - Completed Payments from the Files types for download pick list.
- Click on Download History.
- 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:
- Go to Add > Bank Account
- Choose the Type to be Asset
- 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:
- Go to View > Import or Export > Import Bank Data.
- Choose the PayPal bank account you set up earlier.
- Choose the bank for this import to be PayPal.
- Browse and load the file to bring in your transaction ready for finalising.
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.