User Tools

Site Tools

Action unknown: copypageplugin__copy

Import Cash Receipt Transactions File Layout

Field Length
Cash Receipt Number6
Cash Receipt Number Description30
Account Code20
Cash Receipt Amount11
Contra Offset Object4
Contra Offset Sub Object2
Cash Receipt Source/Description30


This is a comma-delimited file format, which means that commas are not allowed within a field. For example, there should not be any commas in the JV Number Description or the GL Account Description fields.

For amounts, decimal places not implied. For example, 6789 indicates $6,789, and 67.89 indicates $67.89. Eleven numeric characters can be entered with two decimal places, or when whole numbers are entered, nine numeric characters are allowed.

Credit amounts should start with a minus sign (e.g., -).

Amount fields with no data should be empty in the file; do not use zeros.

business/import_cash_receipt.txt · Last modified: 2021/04/09 07:31 by emoreno