Timberline File Layout

Use this format to create a .txt file to import data into Timberline. This is a comma delimited format.

Field	Max Length	Value
Transtype	3	GLT
Account	25	EntityID+GLAccountno (maximum of 25 characters)
Trans Date		Date of Record* (MM/DD/YYYY)
Timberline Journal #	2	92 (Hard coded)
Check #		Reference*
Reference		Bank Book ID + Batch #*
Description	30	GL Description (30 characters maximum)
Debit amount		Transaction amount, if a debit.
Credit amount		Transaction amount, if a credit (with sign reversed).
Acct Method		1 for Accrual. 2 for Cash.

Example:

GLT,01MEA4017,07/01/2005,92,AUTO07,8,Lease Charge-Rent:02-201,,1020.00,1

GLT,01MEA1200,07/01/2005,92,AUTO07,8,Lease Charge-Rent:02-201,1020.00,,1

GLT,01MEA1200,07/01/2005,92,AUTO07,Meadow7,Cash Receipts-Rent:02-201,,1020.00,1

GLT,01MEA1010,07/01/2005,92,AUTO07,Meadow7,Cash Receipts-Rent,1020.00,,1