ACSII (Format 2) File Layout

Use this format to create a file used to import data into the Skyline G/L system. If using this transfer format, each property must be transferred one at a time. Multi-entity accounting is not supported. This is a fixed length format without a carriage return/line feed between each record. It does not support auto-reversing prepaids.

Note

The first record contains the number of records in the file.

Field	Position	Length	Value
Ledger	1	2	AR
Transaction date	3	6	Date of Record* as MMDDYY
Description	9	20	Description/Income Code
JournalNo	29	5	Batch #*
GL Account	34	8	GL Account*
TransAmt	42	15	Transaction Amount

Example:

AR070105Lease Charge-Rent:028 4017000 -1020.00AR070105Lease Charge-Rent:028 1200000 1020.00AR070105Cash Receipts-Rent:07 1200000 -1020.00AR070105Cash Receipts-Rent 7 1010 1020.00