Table - GL#

The GL# Table (or General Ledger Account Number Table) contains settings for the current tax year and General Ledger Account Numbers.  These values are used to determine how to post transactions to the correct General Ledger Account Number and which buckets to update for the balances.

Notes:

• The setting for Itemize by Year? in the Company Control Options for the Tax System controls whether the year (YY) is used for the General Ledger Account Number suffix.  To see details, click More.

  If the setting is...

  • (N)o, then the entire General Ledger Account Number in this table, including the YY suffix, is used for the transaction General Ledger Account Number.
    Example:  If the General Ledger Account Number in this table is 1103, then the transaction posts to General Ledger Account Number 1103.

  • (Y)es, then the YY suffix of the General Ledger Account Number in this table is replaced by the year portion of the Due Date entered for the transaction.
    Example:  If the General Ledger Account Number in this table is 1103, and the Due Date is 0104, then the transaction posts to General Ledger Account Number 1104.

  Note:  The Itemize by Year? setting applies to transactions for the following Tax Type Codes:

  • 02 Tax Payments

  • 03 Abatement

  • 04 Refund

  • 05 Interest Payment

  • 08 Lien Payment

  • 09 Lien Credit

  • 14 Lien Cost Payment

  • 16 Discount

   

• You can also maintain this table in the Assessing and Tax Billing modules.

• For additional instructions about maintaining Cash Receipts tables, refer to the printed documentation, Invision Cash Receipts User's Manual.

Directions

• To see directions for entering the table information, click More.

  General Notes:

  • The sequence of Rows 1 through 3 is critical, however the sequence of Rows 4 through 11 can vary.

  • The General Ledger Account Number format is GLYY, where...

  • GL represents the General Ledger Account Number prefix.  Your municipality determines the numbering scheme according to the General Ledger Chart of Accounts.

  • YY represents the last two digits of the tax year for the General Ledger Account Number suffix.

  • You can see the General Ledger Account Numbers on the Tax Receipt Journal report in the Cash Receipts module.

  GL# Table Field Descriptions
  Row	Column 1 GL Acct #	Column 2	Column 3
  1	GLYY (Taxes Receivable)	blank	blank
  	Notes: This General Ledger Account Number usually matches the Taxes Receivable General Ledger Account Number in Row 1 of the TB-GL table. Each year, after performing the Year End Roll in Tax Billing, change this number by increasing the YY suffix by 1.  Create the corresponding General Ledger Account Number in the General Ledger module. The YY suffix determines which buckets to update for the account balances. The following programs use this General Ledger Account Number when... Post Tax Bills in Tax Billing creates the detail transaction for the 02 Tax Charge. Convert Taxes to Lien in Tax Billing changes detail transactions for the 02 Tax Charges to 07 Lien Charges and credits this General Ledger Account Number. Cash Receipts creates the detail transactions for the following Tax Type Codes during Tax Receipt Entry: 02 Tax Payment 03 Abatement 04 Refund 16 Discount 17 Write-Off
  2	GLYY (Liens Receivable)	blank	blank
  	Notes: The YY suffix for the Liens Receivable General Ledger Account Number is frequently one or more years earlier than the Taxes Receivables account suffix in Row 1. Each year, after performing the Year End Roll in Tax Billing, change this number by increasing the YY suffix by 1.  Create the corresponding General Ledger Account Number in the General Ledger module. The following programs use this General Ledger Account Number when... Convert Taxes to Lien in Tax Billing changes detail transactions for the 02 Tax Charges to 07 Lien Charges and debits this General Ledger Account Number. Cash Receipts creates the detail transactions for the following Tax Type Codes during Tax Receipt Entry: 08 Lien Payment 09 Lien Credit
  3	0404	blank	blank
  	Note:  Although this row is obsolete for newer versions of Tax Billing, leave 0404 in place to accommodate older versions.
  Notes for Rows 4 - 10 The Cash Receipts module applies the following General Ledger Account Numbers to transactions during Tax Receipt Entry. Reminder:  Several transactions use the General Ledger Account Numbers on Rows 1 and 2, instead. The descriptions in Column 2 simply make it easier to maintain the table.  Your descriptions can vary from the examples. You can omit rows for any Transaction Type Codes that are not used by your municipality.
  Row	Column 1 Description	Column 2 Tax Type Code	Column 3 G/L Acct #
  4	INTEREST PMT	05	GLYY
  5	INTEREST CR	06	GLYY
  6	30-DAY PMT	11	GLYY
  7	30-DAY CR	12	GLYY
  8	LIEN CST PMT	14	GLYY
  9	LIEN CST CR	15	GLYY
  10	TX ACQUIRED	20	GLYY
  11	SUPPL PMT	21	GLYY

• To see an example of the table, click More.

  Example: