Drag and drop your County Money export, or click to browse. Only .xlsx and .xls files are accepted. The first sheet is read automatically.

The tool finds the header row for you: it scans the first 10 rows for a cell in column A that reads ACCOUNT (case-insensitive), ignoring any title rows above it. Columns A through I from that header are carried through to the output.

Upload a mapping file keyed by the full account string (column A). Each row supplies the Fund, Program, GL, Service Code, and Offset values for that account. Accepted formats are .xlsx, .xls, and .csv.

The mapping file may carry a title row before its header. The tool finds the header row by scanning the first 15 rows for one of these tokens (case-insensitive, punctuation ignored): Fund, Program, GL / GL Code, Service Code, or Offset.

For every revenue row in the County Money file, the account string in column A is matched exactly to the mapping. When a match is found, its Fund / Program / GL / Service Code / Offset are written to the output. Rows with a variance but no mapping match are kept with blank mapping values, so totals stay correct.

Choose the county the file is for:

• PIMA COUNTY
• PINAL COUNTY

The selection is required to process the file. It is also used as the prefix of the Document Number on every output row (County + Date + Fund).

Enter the session metadata written to every output row:

• Session ID — optional identifier (e.g. GRFD-2026-001).
• Session Description — optional short description of the session.
• Date — the session date (date picker). It is written to the Date column as m/d/yyyy and used in the Document Number.

Click Process File. The tool shows three counts: Rows Kept (rows with a non-zero variance), Offset Rows Added (one per Offset-code group), and Zero Variance Removed (rows dropped because their variance was zero, including 999-rows with no difference).

How variance is computed

Variance (B-I) = Column I (Ending Balance) minus Column B (Opening Balance). Rows whose variance is exactly zero are removed from the output.

Offset rows

An offset row is inserted whenever the Offset column (column O) changes value. The offset row is a copy of the last row of the group with two changes:

• Column M (GL) is set to the group's Offset code value.
• Column J (Variance / cash) is set to the negative sum of the group's Column J values, so the group nets to zero.

Document Number

Every output row gets a Document Number built as County + Date + Fund (for example, PIMA COUNTY10/15/2026100).

Output columns

The output keeps the source columns A–I, then appends: Variance (B-I), Fund, Program, GL, Service Code, Offset, Session ID, Session Description, Date, Document Number. A preview of the first 25 rows is shown before you download.

Click Download File to save the result. The file is named GRFD_{County}_{SessionID}.xlsx (or GRFD_Output.xlsx when no session ID is set). It contains a single Processed tab with an auto-filter across all columns and Column J formatted as a number.