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)
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.