Importing Transactions

To save you manually typing in all your transactions, Home Credit Card Manager Lite 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 Import Transactions 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:
  1. Click on the Import Transactions button on the toolbar (or from the Action menu choose Import Transactions).
  2. Check that the "Statement To Update" is set to the statement you wish to load the transactions into.
  3. Enter the filename containing the transactions, or Click on the Browse... button to locate the file.
  4. If the statement already contains transactions, decide if you wish to replace them or append to them.
  5. Click on the Import Transactions button (The Import Transaction Wizard will be displayed).
  6. 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.
  7. Click on the Next button.
  8. The next three steps of the wizard allow you to define the amount, the date and the description 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.
  9. 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.
  10. Continue to click the Next button until you reach the final step. This step will list any important information before the file is imported.
  11. 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.


Importing Transactions From a Spreadsheet

If you have been monitoring your credit cards using a spreadsheet, then you can easily transfer the transactions into Home Credit Card Manager Lite. 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 Credit Card Manager Lite 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.