Download User Guide - EZPZ Software

For example, if the date line contained "16-02-09" then the date format used appears to be British of
type "dd-mm-yy". If we were to select the date format "mm/dd/yy" (American), where the first
number indicates the month, the resulting dates would be invalid as there is no 16th month.
If you find that there are transactions with blank dates on the next page, simply click the [Back]
button to return to page 2 and select a different date format.
Each line in the file represents a field in the transactions table. Not all fields may be present.






A line beginning with the letter "D" indicates a date. Pay particular attention to how the date
is formatted as different banks use different date formats.
A line beginning with the letter "P" indicates the payee. This information is used for the
payee field.
A line beginning with the letter "N" indicates the reference, for example the cheque number.
A line beginning with the letter "L" indicates the category. If the line contains a colon (:) this
indicates a category followed by a sub-category. This line will not usually be present in files
downloaded from banking sites. It is often present in transaction files exported from
Microsoft Money or Quicken. If a category is present in the file but does not already exist in
your category list you will be asked if you want to add the category, and the sub-category if
applicable, in Step 3 below.
A line beginning with the letter "T" indicates the amount. A negative amount indicates a
payment; a positive amount indicates a receipt.
A line with the carat character "^" indicates the end of a transaction.
Where the file being imported is a CSV file, use the Field order list provided to indicate the order that
the fields listed appear in the data.
Use the grey button at the left of the field name to move the field up and down the list by clicking
and holding down the button as you drag. If one of the fields is not included in the CSV file try
dragging the field to the bottom of the list.
Home Accounts 3 User Guide
52
© EZPZ Software Limited 2013