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.
Note: You can only import transactions into AUD bank accounts.
- Go to Automate > Bank Feeds and 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
∗ 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.
Import your merchant or personal PayPal statements. First 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 and you will be at the Dashboard.
- Go to Activity tab and then select All Reports
- From the left menu choose Activity Download
- Choose the data set you would like to Export using the filters and click Create Report
- In the Activity Reports List click the Download option to the right of the report you just ran.
- The file should download to your local computer. If not, you may need to permission downloads from PayPal when your operating system pops up a check to “Allow downloads from PayPal?”
Note: Saasu only supports importing transaction in AUD 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?
Not quite, they are in your Bank Feed’s Inbox (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 is required for header information for each column and will never be imported.