Receipt Import Specifications

Previous  Top  Next

The external receipt import can be run from the Utilities menu using the button called Import Receipt File.

Once you have clicked it you will be asked to specify the file that is to be imported.

Locate and select that file to begin the import function.

Specification of Receipt file layout

The file format should be a standard ASCI text file, each field is a fixed length – there is NO delimiter between fields.

Account Number = File position 1 to 12 (RMS internal account number to apply receipt)

Receipt Amount = File position 26 to 40 (no $ symbol allowed, * see note) i.e. 40.10

External Receipt Date = File position 41 to 48 (YYYYMMDD)

External Receipt Number = File position 55 – 65

* The receipt amount is normally a positive figure, however in the case of a receipt reversal it may be negative but the External Receipt number for that record must match with an External Receipt number belonging to a receipt that has already been processed.

For Example:

1         2         3         4         5         6         7

12345676890123456789012345678901234567890123456789012345678901234567890

7                         1585.00        20040319      56644

2                         55.00          20040319      556644

2                         3850.01        20040326      98765432

7                         2265.01        20040326      98765432

2                         30.00          20040326      98765432

16                        3080.00        20040319      556644

21                        3080.00        20040319      556644

The CHM file was converted to HTML by chm2web software.