Depending on the format of the file your bank provides, you may need to modify the file to suit Mclowd™'s import specifications.
Mclowd™ programmers have adapted code to import Combank and ANZ export files without modification.
For users exporting files from other banks, please contact Mclowd™ Support if you have import issues, providing a sample export file.
Modifying exported files: Examples:
National Australia Bank's export file contains a column for the transaction date, amount (shown as positive for deposits and a negative number for payments), two blank columns, two columns containing the transaction description, and a column displaying the running balance.
• To combine the two description columns into one:
oIn cell C1, insert the formula =CONCATENATE(E1,F1).
oHighlight cell C1 and click COPY
oPlace the cursor in cell C2 and hold the mouse button down while dragging to highlight all cells in the column
oClick PASTE.
oThere is no need to delete columns after C as they will be ignored.
ING Direct lists debits and credits in separate columns.
oInsert a new column after the Date column and type =IF(D2 = '''',E2,D2).
oCopy this formula and fill down to paste this formula into all filled rows.
Click here for detailed instructions for importing files from NAB Trade.
For all banks:
oCheck that the date format is dd/mm/yyyy. Reformat the dates if necessary. (Excel may display a single digit day or month. This does not create any issues.)
oCheck for any rows that do not contain standard-format transaction data. For example, some banks export statements that contain messages. These rows should be deleted.
