Use this format to create a .txt file to import data into Timberline. The Timberline Format Accrual as Cash file format creates a file in the standard Timberline format, but flags all transactions as Cash (Type 2), regardless of source type. 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 |
|
2 for Cash. |
Example:
GLT,01MEA4017,07/01/2005,92,AUTO07,8,Lease Charge-Rent:02-201,,1020.00,2
GLT,01MEA1200,07/01/2005,92,AUTO07,8,Lease Charge-Rent:02-201,1020.00,,2
GLT,01MEA1200,07/01/2005,92,AUTO07,Meadow7,Cash Receipts-Rent:02-201,,1020.00,2
GLT,01MEA1010,07/01/2005,92,AUTO07,Meadow7,Cash Receipts-Rent,1020.00,,2
See Also
AME, Interface Tab
Transaction Descriptions for Transfer to GL Files