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.