Import of NAB Trade Data File

To successfully import a bank data file using Mclowd’s manual import method, you must ensure the file is in the correct import format:

  • Date   (dd/mm/yyy)
  • Amount
  • Description


Files exported from NAB Trade list amounts in Debit and Credit columns.

As well as deleting additional columns, you need to combine the amounts into a single column, converting all payments to negative numbers.


A file exported from NAB Trade appears as:



The steps to modify the file for import to Mclowd are:


  • Select Columns D and E and format as Currency
  • Delete Column F (Balance)
  • Delete Column B (Type)
  • Insert a new Column B after the date column. Format the new column as Currency.
  • In the new column B, in cell B2, type formula =IF(D2=0,E2,D2). This tells Excel to combine the Debit and Credit amounts into a single column, but convert debits to negative numbers.
  • Copy the formula from cell B2 and paste down into all filled rows.
  • Delete the top row (the headings)


DO NOT delete columns D and E. Mclowd will ignore these columns on import.


The new file now presents as:



Save the file as a CSV file.


This file is now ready to be imported to Mclowd using the MANUAL IMPORT function located on the DATA FEEDS tab.