Follow the instructions provided in Section 10.3.1 for creating a suitable file of bank transactions to import into Mclowd.
NOTE: The format of a file exported from some banks may not suit Mclowd’s specifications. Section 10.3.1 provides instructions for modifying files to suit.
Go to the Bank Data Feeds page (via the button on the BANK tab, or the menu option on the Settings Menu) and click the MANUAL IMPORT button.
Mclowd displays a list of your bank accounts, and IMPORT and ALLOCATE buttons.
NOTE: Buttons at top left provide instructions for preparing your import file, and a sample spreadsheet showing the correct import file format.
Click the IMPORT button next to the file you wish to process.
Mclowd displays the Import File dialog.
Click the Browse button and locate the CSV file you prepared for import.
Below the File selection field, an Allocate option field is provided. Selecting one of the three Suspense Accounts shown in the option list results in all imported transactions being autosaved to that Suspense account and Verified. If you leave this field set to ”No allocations” you will be able to allocate all transactions manually. Transactions allocated to Suspense Accounts, either individually or in bulk by selecting an account here, must later be re-allocated from Suspense using the Suspense Allocation feature described in Section 10.4.
NOTE: If there are any problems with the uploaded data, an error message will be displayed. Mclowd may display an error message noting particular line numbers if, for example, a line contains a blank field, or a message line is included in the file. Any blanks need to be filled and message lines deleted in the file preparation process.
EXAMPLE: Creating a Manual Import File from a NAB Trade Account
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)
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.
To Modify the File
Open the saved file with Microsoft Excel.
Delete Column B: Type and Column F: Balance.
Insert a new column B titled ‘’Amount’’.
In the first empty cell of your new column B (Cell B2), type the formula: =D1-D2
Copy Cell B2 (the formula you just entered) and paste to populate all rows of Column B that have values in the Date and Description columns. You should now have all Debits showing in Column B as positive numbers and all Credits showing in Column B as negative numbers.
Scan down the rows to find any that contain a note and have a zero value in the Amount columns and delete those rows.
Do not delete the Debit (D) and Credit (C) columns. Mclowd will ignore these columns.
Your spreadsheet should now appear as:
Use Excel’s SAVE AS function to save the file as a CSV file (Comma Delimited).
If you haven’t already, log in to your Mclowd account.
Select BANK and click BANK DATA FEEDS (or choose Bank Data Feeds from the Drop down Settings Menu.)
Locate the NAB Trade bank account in your list. Click the IMPORT button.
Click the Browse button to locate and select the CSV file you just saved.
Optionally, select a Suspense account to auto-allocate to. Doing this will assign all imported transactions automatically to that account and verify them. You will not be able to manually assign any transactions except via that SUSPENSE ACCOUNT ALLOCATION function (See section 10.4). If you wish to manually assign selected transactions, choose No allocation in the Allocate selection list.
If the file was correctly prepared, you will see a message telling you the file imported successfully.
Click the ALLOCATE button to view and process the imported transactions.
If you selected a Suspense account to allocate to, Mclowd will now display:
If you selected ”No allocation”, Mclowd should display:
You can now commence allocating transactions. Refer to Section 10.3.3,