EXTERNAL RECEIPT IMPORT SPECIFICATIONS

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