Cash Receipt Reports

Receipt Transaction Detail Reports 

Report Name

Description

DAFR6850

Monthly Transaction Register by PCA/Index

Lists the majority of the detail information of the transactions processed during the month. This report page breaks by transaction register then PCA. It sorts by Index within the PCA.

DAFR6860

Monthly Transaction Register by Index/PCA

Lists the majority of the detail information of the transactions processed during the month. This report page breaks by transaction register then Index. It sorts by PCA within the Index.

DAFR8200

Monthly Transaction Register by Document Number

Lists the majority of the detail information of the transactions processed during the month. This report page breaks by transaction register then sorts by Current Document Number.

DAFR8230

Grant Transaction Analysis

Lists the majority of the detail information of the grant transactions processed during the month. This report page breaks by fund and grant/phase. If you want the grant regardless of fund, request no fund. Shows revenue and expenditure transactions by subobject, totaled by all object levels. Shows transaction detail grouped and totaled by budgetary/other, encumbrance/expenditure, and receipts/revenue by grant/phase.

DAFR8260

Project Transaction Analysis

Lists the majority of the detail information of the project transactions processed during the month. This report page breaks by fund and project/phase. If you want the project regardless of fund, request no fund. Shows revenue and expenditure transactions by subobject, totaled by all object levels. Shows transaction detail grouped and totaled by budgetary/other, encumbrance/expenditure, and receipts/revenue by project/phase.


 

Revenue and Expenditure Reports

Report Name

Description

DAFR0115

Transfers Out by Fund, Rev, Transfers In, Expend

List revenues, transfers-in, expenditures and transfers-out by BFY, Fund, G/L account, and Second Agency (on transfers). Shows current and year-to-date balances by subobject/dtl. Subtotals by object level, second agency, G/L account, and fund. Fund totals show Revenue and Transfers In total, Expenditures and Transfers Out total, and the difference between these two totals.

DAFR0235

Grant Revenues and Expenditures by Grant/Fund

Lists grant revenues and expenditures by grant/phase then fund. Shows subobjects then summarizes all object levels. Shows budget, actual, encumbrance balances. Computes budget minus actual as well as the difference between revenues and expenditures. Lists a grant recap of all balances for the grant.

DAFR0245 (w/-- for no dtl)

DAFR8330

Revenues and Expenditures by Fund

Shows Revenue and Financial Plans, current and YTD, encumbrances, then Unrealized Revenue/Available Balances. Computes difference between revenues and expenditures. You cannot request at any organization or program level. Also shows Percent of Year Elapsed XX% but not in detail.

DAFR6930

Statewide Revenues and Expenditures (can order for an individual agency)

Lists revenues and expenditures by G/L account. Shows a statewide total of revenues and expenditures by subobject then totals by all object levels. Shows current month and year-to-date totals per subobject of all funds, with a separate column for the general fund.

DAFR7850

Grant Revenue and Expenditures by Fund/Grant

Lists grant revenues and expenditures by fund then grant/phase. Shows subobjects then summarizes all object levels. Shows budget, actual, encumbrance balances. Computes budget minus actual as well as the difference between revenues and expenditures. Lists a grant recap of all balances for the grant.

DAFR8130

Active Project Revenues and Expenditures

Lists project revenues and expenditures by fund then project/phase. Shows subobjects then summarizes all object levels. Shows budget, actual, encumbrance balances. Computes budget minus actual as well as the difference between revenues and expenditures. Lists a project recap of all balances for the project.


 

Cash Transactions / Cash Position Reports

Report Name

Description

DAFR6830

Cash Transactions by Fund

Lists all documents that post to cash for the month. Shows by fund and document number with a total by document number. This lists each transaction’s batch header information and transaction code. It shows the amount, whether the amount debits or credits cash, and the net effect to cash for the document.

DAFR8190

Statement of Cash Position by Fund

Lists each fund/dtl and grant, if requested, by month. Shows the beginning balance, advances made, advances received, receipts & collections, disbursement, transfers made, transfers received, and an ending balance. You can find this information on the online Cash Control File along with a borrowing limit field that is not on the report.


 

Trial Balance Reports

NOTE: All trial balance reports show all G/L categories (assets, liabilities, etc.) and list each subsidiary under the respective G/L account.

 

Report Name

Description

DAFR0104

Trial Balance by Grant

Lists trial balance by Transaction Year, by fund/dtl, and by grant/ph. Totals by grant then fund.

DAFR6960

Statewide Trial Balance by Fund

Lists trial balance by Transaction Year and by fund. Shows each G/L account and subsidiaries accumulated statewide. It shows the beginning balance, debits, credits, and ending balance.

DAFR8160

Trial Balance by Fund/Grant

List trial balance by Transaction Year, by fund/dtl, and by grant/ph. Accumulates by grant then fund

DAFR8180

Trial Balance by Fund, GL Acct, & Transaction Code

Lists a trial balance by fund, G/L account, then transaction codes. Shows the beginning balance, debits, credits, and ending balance for each transaction code posted to the G/L account.


 

Revenue Budgeting Reports

See the Budgeting documentation for more information.

 

Report Name

Description

DAFR8300

Revenue Plan Status by Fund/Org

Subtotals at subobject and summary object. Totals by object, organization levels, and then fund.

DAFR8310

Revenue Status by Fund/Pgm

Subtotals at subobject and summary object. Totals by object, program levels, and then fund.


 

Subsidiary Reports

Report Name

Description

DAFR6980

Subsidiary Transaction Analysis Report

Shows individual subsidiary transactions processed during the month.

DAFR8750 (SS1: D32)

Descriptor Table Report – D32 Subsidiary Table

Lists all subsidiaries on the Subsidiary Table by G/L account, subsidiary number, and subsidiary title.


 

Transaction Code Reports

See the Transaction Code Decision Table documentation for more information.

 

Report Name

Description

DAFR8640

Transaction Code Decision Table List – Autodoc

Lists all of the transaction codes for data entry, the general ledger accounts, data entry requirements, how the transaction posts to different files, the approval level, and a brief explanation of the transaction code usage.

DAFR8740

GLA vs. Tran Code Cross Reference

Lists all of the STARS general ledger accounts and the transaction codes that post to each G/L account. It shows if the TCs debit or credit the general ledger account and provides the title of each transaction code.


 

SCO ONLY - Cash Receipt and Revenue Reports

Report Name

Description

DAFR0045

Treasurer Cash Activities (SCO Only)

Lists daily cash increases (2) and cash decreases (5) that STARS is sending to STO for update to their cash files. Summarizes by effective date, by fund, by agency, and by grant, if applicable.

NOTE: See DAFR0500 for a breakdown of summarized amounts that are in batch type J or I batches.

DAFR0147

Treasurer Cash Receipt (SCO only)

Summary count and amount of records sent to STO. Shows records in, input rejected, records processed, header records out, header records amount, cash receipt records out, and cash receipt amount.

DAFR0148

Auditors Cash Activity Detail Listing (SCO/H&W Only)

Lists detail of the (2) and (5) in the DAFR0045. Due to the creation of a balancing program, SCO no longer uses this. Health & Welfare does use this report for balancing their system.

DAFR0200

Revenue & Expenditure Adjustments & Rotary Reimbur (SCO only)

Lists the revenue, expenditure, and rotary reimbursement transaction codes by agency on a daily basis and accumulative for the month. SCO uses this report to locate adjusting transactions that only have one side of the adjustment posted. All adjustment transaction codes must have offsetting TCs to keep cash in balance. SCO may contact agencies when this report shows them out-of-balance.

DAFR0201

Generated Transaction Register (SCO Only)

Lists generated transactions that have an outstanding offset not processed. This report has a one-day delay for the original generated “Z” batch to process. On the following day, the system matches the original TC with its’ generated TC to be sure both sides process and no one has deleted them. SCO may contact your agency if the offset is outstanding for a period of time.

DAFR0203

Statutory Transfer Transaction Register (SCO only)

Lists the daily statutory transfer transaction codes for all agencies. SCO uses this report to locate statutory transfers that only have one side of the transfer posted. All transfers must have offsetting TCs to keep cash in balance. SCO may contact transfer personnel when this report shows them out-of-balance.

DAFR0205

Proration Receipts Transaction Register (SCO only)

Lists all batch type B proration receipts by agency on a daily basis and accumulative for the month. SCO uses this report to be sure all proration receipt batches have processed for the month. SCO uses this report to verify that all cash nets to zero across all agencies involved. All proration batches must have offsetting batches to keep cash in balance. SCO may contact agencies when this report shows them out-of-balance.

DAFR0500

Treasurer Receipt Activity Reconciliation (SCO only)

Lists daily “J” and “I” batch type transactions that STARS is sending to STO for update to their cash files. Shows by effective date, by fund, by agency, and by grant, if applicable. This breaks down the DAFR0045 total for “J” and “I” batches by current document number, Index, PCA, and TC.

DAFR7110

Generated Transactions (SCO only)

Daily report of transactions generated by STARS. Lists by transaction ID.