GL 3.0 Reports

The Account folder was removed in August 2023. The reports in that folder were distributed to the following two folders:

The following accounting standard reports are available in the GL_3.0 folder:

List of GL 3.0 Reports
Report Description

13 Month AR Ledger Report

Shows GL 3.0 information for 13 months prior to the date selected by Ledger, Original Currency, Account Type, Designation, and Number. May be filtered on Data Type (Activity or Balance), Date Type (Posted, Occurred, or Created on), Currency Type (Original or Converted), Ledger ID, Billing Account Number, Service ID, GL Account Type, Designation, and Number.

Chart of Accounts Detail Listing

Shows the GL 3.0 Chart of Accounts detail for the tenant by Chart of Accounts Name, including GL Accounts, GL Account Categories, and AR Ledger associated with the Chart of Accounts. May be filtered by Posting Account (Yes, No), Type (GL Account Types), Designation (GL Account Designation), Chart of Accounts Name, and Object Type (GL Accounts, GL Account Categories and AR Ledger (shows as General Ledger).

Deferred Revenue Rollforward Report by Service with Converted Currency

 

Deferred Revenue Rollfoward Summary by Billing Account

 

Deferred Revenue Rollfoward Report by Billing Account with Converted Currency

 
Deferred Revenue Waterfall Report by Service-Daily Revenue Recognition

 

General Ledger Account Listing

Shows GL 3.0 accounts and their attributes by GL Account Number. May be filtered on Status, Posting Account, Type, and Designation with an option to exclude the Chart of Account Name.

GL Category Listing

Shows GL 3.0 categories and their attributes by GL Category Name. May be filtered by Type with an option to exclude the Chart of Account Name.

GL Entry-Detail

Provides a detail view of general ledger entries without aggregation. Refer to GL Entry Reports Details for more information.

GL Entry-Extended Detail

Provides a detail view of general ledger entries without aggregation. The report includes extended Gotransverse source object information. Refer to GL Entry Reports Details for more information.

Journal Entry Review by Service Report

Shows a list of GL 3.0 accounting entries by Ledger, Currency, Billing Account, Service, and Service Period for six months from the Start Month and Start Year. May be filtered on Ledger ID, Start Year, Start Month, and GL Account Designation with an option to include or exclude Converted Currency and a selection of Date Type (Posted On, Occurred On, or Created On). Refer to Journal Entry Review by Service Report Details for more information.

Posting Rule Listing

 

Posting Rule Set Listing

 

Recognized Revenue By Customer

 

Revenue Statistics Report

 

Trial Balance

 

Unbilled AR GL Validation Report

 

Unbilled Usage Report

 

Unpaid Deferred Revenue Report

Presents the amount of deferred revenue represented by unpaid invoices, which is the amount by which deferred revenue and unbilled accounts receivable should be reduced. This report will support a manual journal entry.

 

 

 

Topic updated: 04/2024.