Bill Codes Report

The Bill Codes report produces a summary or detailed listing of Bill Codes configured in AR. Filter by Department and Application, control the Bill Code range, include Active/Inactive items, and choose how the results are sorted. Use this report for periodic audits, mapping reviews (Revenue/Payout accounts), and cleanup projects. Access it from the Bill Codes Menu.

Input Parameters

Sorting Options: Enter A, B, C, or D (see Sorting Options).
Department# or (A)ll: Specify a department number or use A for all departments.
Appl. Code or (A)ll: Enter an application code or A for all applications.
Starting Bill Code: First code in the range (blank = first available).
Ending Bill Code: Last code in the range (blank = through end).
(S)ummary or (D)etail: S = concise listing; D = includes mapped Revenue/Payout accounts and flags.
(A)ctive, (I)n-Active, or (B)oth: Choose which status to include.
(R)eport or (S)preadSheet: R = formatted report; S = Excel-friendly output.

Sorting Options

A — Bill Code: Alphabetical by Bill Code.
B — Description: Alphabetical by description.
C — Revenue Acct#: By GL Revenue account.
D — Payout Acct#: By GL Payout account.

Tip: Sort by account numbers (C or D) to quickly find duplicates or gaps in mapping.

Report Output

Report (R): On-screen/printable format using the ATS standard renderer.
Spreadsheet (S): Export for Excel; best for audits, filters, and pivots.

Choose Detail with Spreadsheet when you need to audit GL mappings across many Bill Codes. Click to view sample.

Helpful Tips

Quick inventory: Active + Summary + sort by Bill Code.
Mapping review: Detail + sort by Revenue or Payout account.
Cleanup: Run once for Inactive only to identify codes safe to retire or repurpose.
Range filters are inclusive; leave blank to include the full set.