Please enable JavaScript to view this site.

Mclowd User Guide for SMSF Trustees

Go to www.nabtrade.com.au and login with your User ID and password.

Select Accounts:  Cash account

A list of your transactions displays:

Click the DOWNLOAD link at top right (green down arrow)

BANKDA~1_img48

Save the file to your Desktop.

Log out of NAB Trade.

The saved file is not in the correct format for importing to Mclowd™™. It will need some minor modification. The data must be arranged in three columns:  Date (dd/mm/yyyy), Amount (withdrawals shown as negative amounts), Description.

 

Open the saved file with Microsoft Excel.

BANKDA~1_img49

 

BANKDA~1_img49A

 

You should now have all Debits showing in Column B as negative numbers and all Credits showing in Column B as positive numbers.

NOTE_small

You do not need to delete the Debit (D) and Credit (C) columns. Mclowd™ will ignore these columns.

Your spreadsheet should now appear as:

BANKDA~CorrectImportDataFile

Use Excel’s SAVE AS function to save the file as a CSV file (Comma Delimited).

BANKDA~1_img51

Go to Manual Import: Importing the file for instructions on importing your saved file.

 

Copyright Mclowd Pty Ltd 2018