Importing Transactions
To save you manually typing in all your transactions, Home Loan Interest Manager provides you with an import wizard that allows you to load your transactions electronically.
Note: Before you can use the import wizard you must manually create the statement you wish to import the transactions into. The option will remain disabled until the account contains at least one statement.
To load transactions into a workbook from a Comma Separated Values (CSV) file, or other delimited text file, you need to:
- Click on the Import Transactions button on the toolbar (or from the menu choose ).
- Check that the "Statement To Update" is set to the statement you wish to load the transactions into.
- Enter the filename containing the transactions, or Click on the Browse... button to locate the file.
- If the statement already contains transactions, decide if you wish to replace them or append to them.
- Click on the Import Transactions button (The Import Transaction Wizard will be displayed).
- The first step of the Wizard allows you to define the characteristics of the file. By default the wizard is set to comma separated and to start on the first row of the file. Change the values as required until your file is displayed correctly in the table provided.
- Click on the Next button.
- The next four steps of the wizard allow you to define the amount, the date, the description and optional balance fields in the file. You can select the required column by clicking on the column in the table or by typing in the column number.
- If the amounts in your file contain a currency symbol (for example $, £, ¥, A$, Z$, Rp, etc) then you need to enter it in the currency symbol field.
- Continue to click the Next button until you reach the final step. This step will list any important information before the file is imported.
- Click on the Finish button. If everything is ok, then the transactions will be loaded into the statement. If everything is not ok, then you will be shown where the errors are in the file and you will need to go back through the steps and correct the problems.
Note: Home Loan Interest Manager only allows negative balances to be imported. If the balances in your file are positive values, then select to have them multiplied by -1 as they are loaded. If you reverse the sign of the balance field, you may also need to reverse the sign of the amount field.
Importing Transactions From a Spreadsheet
If you have been monitoring your loans using a spreadsheet, then you can easily transfer the transactions into Home Loan Interest Manager. Save the spreadsheet as a Comma Separated Values (CSV) file then use the Import Wizard to load them into the correct statements.
If you wish to continue using your spreadsheet as well as using Home Loan Interest Manager you can easily export the workbook at any time to load back into your spreadsheet. Alternatively you can cut and paste the values directly from the screens and reports into your spreadsheet.