FINANCIAL REPORTING
REPORT ID: CSA 403CD
REPORT TITLE: Daily General Ledger Activity.
FILE(S) ACCESSED: History File, General Ledger File.
USER AGENCIES: Lump-sum agencies upon request.
FREQUENCY: Daily. On a given day, the report is generated only for those lump-sum agencies having activity posted that day who have specifically requested this report.
REPORT TYPE/PURPOSE: This is a financial accounting report which shows the detail posted daily to each general ledger account. It can be used by lump-sum agencies who submit tapes more often than monthly to reconcile differences between the agency's balances and STARS on a daily basis. It can help the agency to determine whether all transactions submitted to STARS have been processed.
COLUMN HEADINGS AND DESCRIPTION OF DATA IN EACH COLUMN:
(No heading): STARS general ledger account number. See General Ledger Account Codes and Titles.
SFDT: Subfund detail code. See Fund Component - Subfund Detail.
FDT: Fund detail code. See Fund Component - Fund Detail.
FD: Fund code. See Fund Component - Fund and Fund Codes.
SFDT TITLE: Subfund detail code title.
DEBIT: Debit amounts posted that day.
CREDIT: Credit amounts posted that day.
ENDING BALANCE: Balance at the end of the day (debits are positive, credits are negative).
AGY-VOU: Agency voucher number.
TRANSACTION-ID:
"STARS TRANSACTION IDENTIFIER"
Subelements are:
AGY: (First three characters) Agency code of the batching agency.
For more details see Organizational Components,
an alphabetical list by Agency Titles with Codes,
and also an alphabetical list by Agency Codes with Titles.VOU: (Next six digits): Agency's batch processing date in YY/MM/DD format.
Blank space: Used only to visually separate the subelements within the transaction identifier.
Next digit: Batch type code. These codes are explained at the end of each daily report and listed on the STARS Form 100, the Transmittal Control Sheet.
Next six digits: A number needed to make the transaction identifier unique. This is sometimes called the warrant number and consists of a combination of the batch number and the batch sequence, each of which is three digits.
Next three digits: The three-digit computer-assigned sequence number for each transaction on the document.
Last character: Duplicate number indicator. If the same transaction identifier has been used in the past two months, a character is added here to make the identifier unique. An "A" appears in this column for agency computer tape vouchers.
TC: Transaction code and reverse posting indicator.
See Stars Transaction Codes. An "R" following the three-digit transaction code indicates reversal of transaction code posting. (The normal debit account is credited and the normal credit account is debited).MINI: Mini code. See part A. of Coding Requirements.
OBJ: Revenue or expenditure major, minor, and detail object code with a hyphen between the major/minor and the detail codes.
See the following for further details:
Object Components,
Revenue Object Codes and Titles, and also
Expenditure Object Codes and Titles..PROJ: Project code. See Project Component.
PH: Project phase code. See Project Component - Project Phase.
MULTI PURP: Multipurpose code. This is a ten-digit field which the agency may use as it desires. For example, an agency that maintains its own independent accounting system may wish to use this field to enter their account numbers. See Multipurpose Code.
PRDTE: Date processed in STARS in MM/DD format.
FM: A two-digit number indicating the fiscal month (01 = July, 02 = August, , 12 = June, and 13 = July payment date of a June invoice.)
SORT ORDER: Agency, fund group, general ledger account, subfund detail, project, phase, agency voucher, and transaction identifier.
OTHER FORMAT FEATURES: The agency code, agency name, fund group code, and fund group title are printed at the upper left of each page. This report prints subtotals by agency, fund group, and general ledger account. It also subtotals within each fund group's general ledger account by project and by subfund detail.
RELATED STARS REPORTS: The CSA 403CM Trial Balance report is arranged in the same order as this report and shows balances of all accounts at the end of the month. The CSA 403CM General Ledger report is basically a monthly version of this daily report.
DAILY GENERAL LEDGER ACTIVITY (CSA 403CD)
The example for this page was intentionally removed for the CD-ROM and Internet versions of the manual. Please refer to the paper version of the manual to see examples.