To successfully import a bank data file using Mclowd’s manual import method, you must ensure the file is in the correct import format:
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:
- Delete Column B (Type)
- Delete Column F (Balance)
- Delete the top row (the headings)
- Insert a new Column B after the date column
- In the new column B, in cell B1, 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 B1 and paste down into all filled rows.
- DO NOT delete columns D and E. Mclowd will ignore these columns on import.
- Save the file as a CSV file.
The file now presents as:
This file is now ready to be imported to Mclowd using the MANUAL IMPORT function located on the DATA FEEDS tab.