Home Money Manager Home Money Manager
Home Money Manager

Home Loan Manager - User Manual

Table of Contents > Importing Transactions
Beat Your Bank Beat Your Bank

Importing Transactions

To save you manually typing in all your transactions, Home Loan Manager Pro provides you with an import wizard so that you can automatically load your transactions into your statements. For more information on importing transactions please select from the following topics:
  1. Overview
  2. Step-by-Step Instructions
  3. What type of files can I import?
  4. What is a CSV file?
  5. How do I get my transactions into an import file?
  6. How do I import my transactions from a spreadsheet?


1. Overview

The first part to the import process allows you to the select the statement you want to update, and to choose the import file that contains your transactions (1).

The import wizard will then take you through the steps needed to specify the layout of your import file, and to map the columns in your file to the information required to create the transactions (eg the amount, date, description, etc) (2).

The final step is to physically import the file, where your transactions are automatically loaded into the nominated statement (3).


2. Step-by-Step Instructions

This section contains step-by-step instructions on importing a CSV file into a statement.

 

2.1. Importing Transactions

To start the import process click on the Import Transactions button on the toolbar (or from the Action menu choose Import Transactions).

 

2.2. Select a Statement and Choose a File

The Import Transactions screen requires that you:

  1. Check the "Statement to Update" is set to the statement you wish to load your transactions into. NOTE: If you want to add your transactions to a new statement, you will need to create it before starting the import process (1).
  2. Enter the filename (including the full directory path) of the import file that contains your transactions, or Click on the Browse... button to locate the file (2).
  3. If you are updating an existing statement and it already contains transactions, decide if you wish to delete them or append to them (3).
  4. Click on the Start Import Wizard button to start working with your file (4).

 

2.3. Using the Import Wizard

As you work through the import wizard steps you will notice that each step has the following screen components:

  1. Instructions for the current step (1).
  2. Input fields allowing you to enter the requested information (2).
  3. A File Sample panel that displays the contents of your import file (3).
  4. Navigation buttons allowing you to move between the different steps (4).

 

2.4. Step 1 - Specify the File Layout

The first step of the Wizard requires that you to specify the layout of the file you wish to import. If your file contains unwanted header or footer information then you can exclude them by changing the start and end row fields.

 

Adjust the Column Delimiters and Text Delimiter fields until your information appears in columns in the File Sample table. The most common file formats are Comma Separated Values (CSV) files where the information is separated by commas, and Text files where the information is separated by Tab characters.

For CSV (.csv) files select the comma delimiter, for Text (.txt) files select the Tab delimiter.

 

As the information in our sample file is in CSV format, selecting the comma delimiter places the information neatly into columns.

 

Click on the Next button.

 

2.5. Step 2 - Select the Transaction Amount

Once your import file is being displayed as columns in the File Sample panel, select the column that contains the transaction amounts. If you have two columns with transaction amounts (for example, debits and credits), select the first column. You can do this by typing in the column number into the field provided (1), or by clicking on the column in the File Sample panel (2).

 

If the amounts in your file contain a currency symbol (for example $, £, ¥, A$, Z$, Rp, etc) then type it into the currency symbol field.

 

IMPORTANT - If you are importing transactions into a Loan or Mortgage statement, then deposits should be displayed as positive numbers, and the interest charges and fees should be displayed as negative numbers in the File Sample panel.

 

If they are currently being displayed incorrectly then select the "Reverse the sign on the amount" field to change them.

 

Click on the Next button.

 

2.6. Step 3 - Select the Second Transaction Amount

If all your transaction amounts are displayed in the one column, then you can skip this step. If you have two columns with transaction amounts in them, then choose the second column. If required, enter the currency symbol and change the signs on the amounts (+/-).

 

Tip - If you have two columns with amounts (for example, debits and credits) it doesn't matter in which order you assign them to Amount and Amount 2. The important thing to check is that the numbers in each column have the correct sign (+/-), adjusting them with the "Reverse the sign on the amount" field if required.

 

Click on the Next button.

 

2.7. Step 4 - Select the Transaction Date

Select the column that contains the transaction dates.

 

Select the Date Format (1) and Date Separator (2) to match the dates in the column (for example, given a date of "20/03/2008" select a date format of "DMY" and a date separator of "/")

 

Click on the Next button.

 

2.8. Step 5 - Select the Transaction Description

Select the column that contains the transaction descriptions.

 

Click on the Next button.

 

2.9. Step 6 - Import the Transactions into the Statement

If you have correctly specified a column for each of the required fields, step 5 will show you the Ready to Import message (1). Start the import by clicking on the Finish button (2), and if everything is valid the transactions will be loaded into the statement.

 

2.10. Import Failed Message

If any of the values you have selected are incompatible with the import file, then you will see the Import Failed message (1). To find out why the import failed, review the errors in the File Sample panel by clicking on the fields with the red borders (2). Once you have reviewed the errors and gone back and addressed the problems, you can re-start the import.

 

Top of page

 


3. What type of files can I import?

The import wizard allows you to import delimitered text files (where the information in your file is separated by a delimiter). Your import file can contain one of more delimiters, including commas, tabs, semicolons, spaces, etc.

The most common file formats are Comma Separated Values (CSV) files where the information is separated by commas, and plain text files where the information is separated by Tab characters.

 

Top of page


4. What is a CSV file?

A CSV file is simply a text file where the information is separated by commas. The format dates back to the early days of business computing, is very simple and widespread, and is supported by almost all spreadsheets and financial software packages. In addition most Internet banking sites provide the option of downloading information in CSV format.

You can find an example of a CSV file in the samples directory of the software. If you open this file in a text editor you will notice that commas separate the transaction information.

 

If you want to import a CSV file into the software you need to select the Comma as the Column Delimiter. This will allow the wizard to put each value into a separate column ready for importing.

 

Top of page


5. How do I get my transactions into an import file?

Most banks allow you to view your transactions online via their Internet banking site, and provide you with the option to download your transactions to a CSV file.

When viewing your transactions online, look for the download or export option and select the CSV format (other names for the CSV file format include: CSV text file, Comma Separated Values (CSV), Spreadsheet file, Plain Text file). If you can't see any of these options please contact your lender for more information on how to download your transactions into a CSV file.

Once you have downloaded your transactions and stored the file on your computer, it is ready to load directly into the software using the import wizard.

 

Top of page


6. How do I import my transactions from a spreadsheet?

Most spreadsheet packages provide you with the option of saving your work as a Comma Separated Values (CSV) file. Therefore all you have to do is save your spreadsheet as a CSV file, and then you can load it directly into the software using the import wizard.

 

Top of page