Please enable JavaScript to view this site.

Mclowd User Guide for SMSF Trustees

Navigation: MCLOWD CONNECTIONS > Importing Bank Data Manually

Creating the Import File for Manual Import

Scroll Prev Top Next More

Most banks provide a statement export facility, accessed via their online banking portal. Please refer to instructions provided by your bank for downloading the export file.

Typically, a range of file formats are available for selection when exporting.

NOTE_small

For manual import into Mclowd™, you should choose the .CSV (Comma Separated Values) file format. This format can be readily opened with your spreadsheet application software (e.g. Microsoft Excel).

 

Export a bank statement for the period you wish to process.

Open the file in a spreadsheet application.

Mclowd™ requires that your file conforms to the following format:

Column 1:  Date (formatted as dd/mm/yyyy)

Column 2: Amount

Column 3: Description

Modify the exported file, if necessary, to match this format, then save the modified spreadsheet as a .CSV file:

BANKDA~1_img41

BANKDA~1_img42

 

Copyright Mclowd Pty Ltd 2018