Accounting Reports
Learn about the various Accounting related reports in CIS.
The list provides the name of accounting reports and a brief description of the reports:
| Report name | Description |
|---|---|
| 820 Payment Report | This report provides a list of 820 payments sent to the utilities when the billing type for a Customer is Supplier Consolidated. |
| 820 Payment Report Extended | This report provides a summary list of 820 payments made by the given date range. There is a hyperlink for each payment file that provides an extended report of the payment details. Suppliers who bill Customers under a Supplier consolidated billing type utilize this report. |
| Account Manager Revenue Report | This report provides a list of Summary Customer invoices by Account Manager for a given date range. An Account Manager is a role in the Retail organization whose purpose is to support Commercial Customers. |
| Adjustment Report | This report provides a list of Customers who received AR Adjustments during a given date range. AR Adjustments are primarily used for writing off account balances due to bad debt. |
| Aged AR Summary Report | This report provides a list of the Aging of each Customer’s account. The view version of this report also has a hyperlink to the Customer’s account located on the left side of the screen and highlighted in blue. Clicking on the link takes you to the Customer’s Account Summary page. |
| Aged AR Summary History Report | This report is similar to the AR Aged Summary Report in that it provides the same results. The difference in this report is that it allows you to get report on the AR Aging balances for a given time. |
| Aggregator Fee by ESIID Report | This report provides a list by Customer and ESI ID/Utility the aggregator fee (rate) and amount due as a result of the invoice generated. This report is used by Suppliers who record the Aggregator Fee information in the Aggregator table. |
| Aggregator Fee Report | This report provides a list by Customer the Aggregator fee associated with the invoice generated. This report is used by Supplier who record the Aggregator Fee information in the Aggregator table. |
| Alternate Aged AR Summary Report | This report provides a list of AR Aging balances by Customer based upon the day the report is generated. This report is unique and allows the user to define the dates of the aging buckets. |
| Budget Billing Detail Report |
This report provides the Budget Billing Detail invoice-level information on Customers who are either currently in the Budget Billing Plan or were during the time period selected for the report. The report lists following Customer information:
|
| Budget Billing Summary Report | This report provides a list of the Budget Billing Summary information on all Customers who are currently in the Budget Billing Plan. The report lists the Customer’s Budget Billing Amount, True-up Period, how many invoices that have been billed during the period and the current True-Up balance. |
| CCH Special Charges Tax Report | This report provides a list of tax detail report of taxable amount of special charges listed by county, city, state and local taxing authorities. This report is used to file quarterly taxes. |
| CCH Tax Liability | This report provides a list of tax details by Location Code. It includes taxable revenue for each county, city, state and local taxing authorities. This report is used to file quarterly taxes. |
| CCH Tax Report | This report provides a list of tax details. It includes taxable revenue by county, city, state and local taxing authorities. This report is used to file quarterly taxes. |
| CCH Tax Report by Service To | This report provides a list of tax details. It includes taxable revenue by county, city, state and local taxing authorities. This report is filtered by the Service To Date rather than by the Invoice Date. |
| Direct Debit Cards near Expiration | This report provides a list of Customers with credit cards used in the auto-drafting payment process and that are nearing their expiration date. Report is only used by Supplier that are using the Credit Card and Direct Debit payment functionality. |
| Direct Debit Payment List | This report is the same as the Payment List Report. It includes a list of electronic payment details by Customer filtered by payment type (ACH or Credit Card). |
| ESI ID with Associated Taxes | This report provides a list of Daily Billing Report invoices by ESIID/Utility. |
| General Ledger by Category | This report provides a list of real-time presentment of financial transactions summed by GL Accounts for a given period selected. |
| GL Account Code | This report displays GL Mapping by utility. It includes a list of the GL Mappings to Rate Descriptions and Invoice Categories. The report is filtered by utility. |
| GL Mapping by Division | This report displays GL Mappings to Invoice Details, Payments, and Adjustments. The report is filtered by Division. |
| GL Mapping by TDSP | This report displays GL Mapping by utility. It includes a list of the GL Mappings to Rate Descriptions and Invoice Categories. The report is filtered by utility. |
| GL Recon Report | This report provides a list by GL Description listing total GL items by day for a given date range. |
| Invoiced TDSP Charges | This report provides a list of 810 Charges invoiced to the Customer. |
| Payment List | This report provides a list of electronic payment details by Customer filtered by payment type (ACH or Credit Card). |
| Payments Posted Report by Payment | This report provides a list of payments that have been posted for a given date range by payment ID. |
| Payments Posted Report by Payment Detail | This report also provides a list of payments that have been posted for a given date range by payment ID, but also provides more details of the payments such as Customer Name, Customer Number and Invoice Number. This report is typically used to reconcile against the bank statement. |
| Payments Unapplied Report | This report provides a list of payments that are applied to a Customer's account but not specifically applied to an invoice. |
| Revenue and Receipts Summary Report | This report provides a list of all invoicing details by Customer for a given date range. Report has a 35-day range limitation. |
| Security Deposit Refunds | This report provides a list of Customers whose deposits were applied and/or refunded. |
| Security Deposit Summary Report | This report provides a list of Summary version of security deposits refunded for a given period of time selected. |
| Security Deposits Terminating (Over 360 Days Old) | This report provides a list of Customers’ security deposits that have been held for at least 361 days. |
| Special Charges Report | This report is a list of all Customers who have had received adjustments to
their invoices (Special Charges). The report can be filtered by Billed or Unbilled
charges. Note: Special Charges is a CIS term for Customer
Adjustments.
|
| Taxable Report | This report is a list by Customer, the value of the Customer Taxable Flag and Premise tax Assessment value. |
| Taxable Report by Customer Type | This is the same report as the Taxable Report, but contains a filter by Customer Type. In includes a listing by Customer the value of the Customer Taxable Flag and Premise tax Assessment value. |
| Taxes by Customer | This report is filtered by Customer and lists by Premise the taxes applicable to the service address. Report includes tax rate and effective dates. |
| TDSP Charges Invoiced Detail | This report is a list by Utility, the 810 charges that have been invoiced to the Customer and paid by the Customer. |
| Unbilled Special Charges | This report is a list of all unbilled Special Charges. This report is replaced with the Special Charges report, which can be filtered by Billed or Unbilled Special Charges. |