Every dollar, accounted for.

A checkable path to OpenGov.

1. Load the daily LTS Cash Report PDF and CIT_DATA CSV. These are the two transaction inputs for the generated GL_JE Import.
2. Review the included account mappings. The earlier SS_JE_Number is a reference for account structure only; its amounts, date, fiscal year and JE number are not copied into daily transactions. A reference workbook can optionally update the mappings.
3. Reconcile pooled cash debits by Cash, Check/Money Order and Credit Card to Cash Report. Review each fund's claim-on-pooled-cash debit and due-to credit against CIT_DATA. Confirm both reports cover the same daily close.
4. Check receipt amounts and account credits, then enter preparer and reviewer checkoff. The generated entry must reconcile to both sources and balance by fund and overall.
5. Download the GL_JE Import CSV using the included 29-column JeDetails schema, along with the workpaper and print confirmation. Upload the import into OpenGov and record the resulting import reference.

Use Save draft to retain a daily batch in your staff workspace. Saved reports contain extracted receipt data. Uploaded PDF and CSV bytes stay on your device. A mapping profile saves account settings on this device. Download the JSON workpaper to keep source rows, file hashes, decisions, mappings and export hashes. The print report can be saved as a PDF.

ACH, bond applications, change, refunds, unsupported transaction types and report discrepancies block export until a posting rule is configured. Batch submission, authenticated approval and exports are recorded in the staff audit trail.