Skyline 2005 File Layout

Use this format to create a file to import data into the Skyline 2005 G/L system. If using this transfer format, each property must be transferred one at a time and multi-entity accounting is not supported.

This is a fixed length format without a carriage return/line feed between each record. This format 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	9	GL Account in format 4-4 (if profit centers used this will be the first 3 digits of second 4.)*
TransAmt	43	16	Transaction Amount
Unused	59	2	Padding

Example:

AR070105Lease Charge-Rent:028 4017-000 -1020.00 AR070105Lease Charge-Rent:028 1200-000 1020.00 AR070105Cash Receipts-Rent:07 1200-000 -1020.00 AR070105Cash Receipts-Rent 7 1010- 1020.00