GL Export - Revision history

Jgreco: Initial proofread pass - docs

2021-11-30T18:03:37Z

Initial proofread pass - docs

Lsilverman at 18:08, 6 February 2014

2014-02-06T18:08:22Z

Jwolbert at 15:25, 18 July 2012

2012-07-18T15:25:43Z

Admin at 16:08, 16 December 2010

2010-12-16T16:08:49Z

Tfusco: /* Example Data */

2010-05-07T18:29:51Z

Example Data

Tfusco: /* Example Data */

2010-05-07T18:29:38Z

Example Data

Tfusco: Created page with '=GL Export= This export contains General Ledger (GL) data for TrackAbout generated rental invoices. == Transfer Mechanism == This export is kicked off at the end of a rental …'

2010-05-07T18:28:46Z

Created page with '=GL Export= *This export contains General Ledger (GL) data for TrackAbout generated rental invoices. == Transfer Mechanism == *This export is kicked off at the end of a rental …'

New page

=GL Export=
*This export contains General Ledger (GL) data for TrackAbout generated rental invoices.

== Transfer Mechanism ==
*This export is kicked off at the end of a rental run. Typically once a month.
*A file is dropped into a TrackAbout hosted FTP site in a designated folder.

== File Name ==
Here is an example file name: GL_2010.05.03.20.57.16_85_18051.08.txt

The file name is built up of these components separated by underscore delimeters:
*Prefix: GL
*Date: 2010.05.03.20.57.16 (This is equivalent to 5/3/2010 20:57:16)
*Number of rows: 85
*Grand total for all of the ''positive'' numbers in the "Amount" column: $18,051.08
**''Note that the total for the entire Amount column always sums to zero. So this total is just the sum of the positive values in the column. In other words the total amount of money represented in this GL file.''
*File type: .txt

This creates a unique file name and also provides total fields that can be used by the business system to ensure that it read in all rows in the file.

== File Format ==
* File is a comma delimited ASCII text file
* Fields in file

{| class="wikitable" border="1" cellpadding="5" cellspacing="0"
|-
! Field
! Example
! Format
! Notes
|-
| Location
| 3
| Text, Max 12 char
| This is the code used in the business system for a given location. The data is rolled up based on the GL Code as well as the location that gets credit for the rental for each customer.
|-
| GL Code
| TACR
| Text, Max 255 char
| This is the GL Code. Any kind of charge configured in TrackAbout will have a corresponding GL code setup. There is also a code setup for all AR entries. These codes must exist in the business system.
|-
| Amount
| 100.00
| Numeric, Two decimal places
| This is the amount of the GL entry. To be consistent with double entry book keeping, the totals in this column in the file always add up to zero. Customer invoices are entered as negative numbers. The only positive numbers are for AR entries. There is no thousands separator and no currency symbol, just the number.
|}

== Example Data ==
Here is an example of the rows in the file.
1,1201,100.00
1,2041,-70.25
1,2045,-29.75

← Older revision		Revision as of 18:08, 6 February 2014
Line 53:		Line 53:
	1,2041,-70.25		1,2041,-70.25
	1,2045,-23.75		1,2045,-23.75
		+	[[Category:Rental]]

← Older revision		Revision as of 15:25, 18 July 2012
Line 1:		Line 1:
		+	[[Rental\|<< Back to Rental Module]]
		+
	=GL Export=		=GL Export=
	*This export contains General Ledger (GL) data for TrackAbout generated rental invoices.		*This export contains General Ledger (GL) data for TrackAbout generated rental invoices.

← Older revision		Revision as of 18:29, 7 May 2010
Line 55:		Line 55:
	1,2041,-70.25		1,2041,-70.25
	1,2045,-23.75		1,2045,-23.75
−	~~1,2045,-6.00~~

@@ Line 11: / Line 11: @@
 Here is an example file name: GL_2010.05.03.20.57.16_85_18051.08.txt
-The file name is built up of these components separated by underscore delimeters:
+The file name is automatically generated, and made up of the following, with separated by underscores. This creates a unique file name and also provides total fields that can be used by the business system to ensure that it read in all rows in the file.
 *Prefix: GL
 *Date: 2010.05.03.20.57.16 (This is equivalent to 5/3/2010 20:57:16)
@@ Line 19: / Line 20: @@
 *File type: .txt
-This creates a unique file name and also provides total fields that can be used by the business system to ensure that it read in all rows in the file.
 == File Format ==
-* File is a comma delimited ASCII text file
+* File is a comma delimited ASCII text file.
-* Fields in file
+* Fields in file:
 {| class="wikitable" border="1" cellpadding="5" cellspacing="0"

@@ Line 1: / Line 1: @@
 =GL Export=
 *This export contains General Ledger (GL) data for TrackAbout generated rental invoices.
 == Transfer Mechanism ==
 *This export is kicked off at the end of a rental run. Typically once a month.
 *A file is dropped into a TrackAbout hosted FTP site in a designated folder.
 == File Name ==
@@ Line 20: / Line 18: @@
 This creates a unique file name and also provides total fields that can be used by the business system to ensure that it read in all rows in the file.
 == File Format ==
@@ Line 48: / Line 45: @@
 | This is the amount of the GL entry. To be consistent with double entry book keeping, the totals in this column in the file always add up to zero. Customer invoices are entered as negative numbers. The only positive numbers are for AR entries. There is no thousands separator and no currency symbol, just the number.
 |}
 == Example Data ==

@@ Line 51: / Line 51: @@
 == Example Data ==
-Here is an example of the rows in the file.
+Here is an example of the rows in the file. (Where "1201" is the special code used for AR entries)
 ,1201,100.00
 ,2041,-70.25
-,2045,-29.75
+,2045,-23.75

GL Export - Revision history

Jgreco: Initial proofread pass - docs

Lsilverman at 18:08, 6 February 2014

Jwolbert at 15:25, 18 July 2012

Admin at 16:08, 16 December 2010

Tfusco: /* Example Data */

Tfusco: /* Example Data */

Tfusco: Created page with '=GL Export= *This export contains General Ledger (GL) data for TrackAbout generated rental invoices. == Transfer Mechanism == *This export is kicked off at the end of a rental …'

Tfusco: Created page with '=GL Export= This export contains General Ledger (GL) data for TrackAbout generated rental invoices. == Transfer Mechanism == This export is kicked off at the end of a rental …'