The format of the disbursement file to import is a .TXT file. Examples are: 30/5/2004 VALUE/ACC Fax 0.10 58 0.70 Photocopying 30/5/2004 VALUE/ACC AC 0.0 0 100.00 Accommodation The columns in the table below represent the fields from left to right. They must be in this order and each field is separated by a tab and the import file should not include column headings. Column | Mandatory/Optional |
---|
Date in dd/mm/yyyy format | Mandatory | (AE) Client code/assignment code (AO) Client code/job code/Year | Mandatory (where Year is optional) Example: Client Client/[None] adds the entry to the Client. Client/Tax/2017 adds the entry to the 2017 year. | (AE) AE disbursement code (AO) AO disbursement code | Mandatory The alphanumeric value is left justified up to 10 characters and is case sensitive. | Rate | Must contain a value of zero (0) as a minimum. It cannot be blank. | Quantity | Must contain a value of zero (0) as a minimum, cannot be blank. | Charge amount | Mandatory and must be entered as a number with 2 decimal places and without a $ sign. Any entries with 0.00 amounts must be removed from the file before importing. | Narration | Optional—but must be replaced with a tab if no value is entered. Maximum of 255 characters allowed |
At the end of the import disbursement file there must be a carriage return after the last line to create a blank record. |