Data Feeds

10.3.2 Bank Data Feeds: Manual Import Method – Importing a File

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.

Bank data feeds manual import

Mclowd displays a list of your bank accounts, and IMPORT and ALLOCATE buttons.

Bank accounts list for import


 

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. Mclowd file import 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.

Click UPLOAD.


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)

NAB Trade export

Save the file to your Desktop.

Log out of NAB Trade.


NOTE:

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.

Exported file opened in 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.


NOTE:

Do not delete the Debit (D) and Credit (C) columns. Mclowd will ignore these columns.


Your spreadsheet should now appear as:

Modified spreadsheet for import

 

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

Save spreadsheet as CSV file

 

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.

Mclowd file import dialog

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.

Click UPLOAD.

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.

Manual bank data import Allocate buttons

If you selected a Suspense account to allocate to, Mclowd will now display:

imported file autoallocated to suspense

If you selected ”No allocation”, Mclowd should display:

 

Bank data feeds trx allocationYou can now commence allocating transactions. Refer to Section 10.3.3,


about the author:

Lorraine Cobcroft

With a background in accounting and financial management, followed by two decades writing software documentation, Lorraine joined the Mclowd team in mid-2016 and is enjoying working with a dynamic team to enhance an innovative product that has the potential to revolutionize the way Australians manage their retirement funding.
Lorraine is also an accomplished business writer, ghost-writer, novelist and short-story writer and poet.

Leave a Reply