A suite of tools for staff supporting school business offices.
Chart of accounts
Which codes fit this expenditure?
Describe what you're buying or paying for. The codes update as you type, using the function, object, and program rules in the UCOA manual.
Check an account string
Paste a fund-function-object-program string, with location and job class if it has them.
Try:
NM PED Quarterly Cash Report
Cash Report Tie-Out
Follows Lines 1, 2 and 5 of the PED Cash Report back through the OBMS Actuals Rollup Reports to the GL Detail, names which link in that chain breaks, and points at the object codes and transactions behind it.
New to the tie-out? Watch the walkthrough or follow the step-by-step guide: which reports to pull from OBMS and AptaFund, how to upload them, and how to read and save the results.
Demo data loaded. Figures below are from a fictional school (Mesa Ridge, 099-002) so you can see how the tie-out reads. Upload your own three files to replace it.
Sources
Accepts .xlsx and .csv · parsed in this browser — no file leaves your machine
Method. Line 2 compares Cash Report revenue against GL rows typed Revenue; Line 5 compares against rows typed Expenditure. Line 1 compares against the Final Cash Report column of the Estimated Cash Position Report, which PED rounds to whole dollars — hence the separate Line 1 tolerance. When the audit is not available, choose Prior FY Q4 Cash Report, Line 7 as the Line 1 benchmark in source 03: Line 1 is then compared fund by fund against Line 7 (Total Cash) of that report, to the penny. Fund roll-up. Funds in the GL Detail and the Estimated Cash Position Report are taken from the first segment of the account code and rolled into the Cash Report’s columns. A fund that has its own column keeps it (31100, 31200, 31400, 31700, 31701, 31703). Everything else combines into its series total — 24101, 24106, 24154 and 24189 into 24000; 25153 into 25000; 26156 and 26222 into 26000; 27107, 27109 and 27536 into 27000; 28211 and 28221 into 28000; 29102 into 29000. Open any Line 1 row to see the funds that rolled in and how each one foots. The chain. PED builds Line 2 and Line 5 from the OBMS Actuals Rollup Reports, which are themselves built from the general ledger. So the tie-out follows that chain in both directions — Cash Report against rollup, rollup against GL — and names whichever leg breaks. A fund where the form and the rollup agree but the GL does not is a ledger question; a fund where the rollup and the GL agree but the form does not is a keying question. Rollup columns.YTD is cumulative through the quarter end and is what Lines 2 and 5 must equal. Actuals is that quarter’s activity alone, which is why each rollup upload carries its own quarter tag — comparing it against the GL for the same three months tells you which quarter a year-to-date break entered in. Scope. Year to date runs July 1 through the selected quarter end, matching how the Cash Report accumulates. Quarter only isolates a single quarter for period-level review. Privacy. Every file is read with the browser’s FileReader and parsed in page memory. Nothing is uploaded, stored, or transmitted.
ERB Reconciliation
Checks an NMERB W1 financial work report against the Form 100 contribution rates: what each employee was charged, what the rates expect, and where the two part company. The file is read in this browser and nothing is uploaded.
W1 work reportNo file loadedThe W1 financial work report from AptaFund or Visions — the fixed-width text upload, usually named like CLIENT092026W1.txt
Employees
—
ERB basis
—
Derived from reported wages
Collected
—
Employee plus employer
Expected less collected
—
At Form 100 rates
By contribution category
Expected amounts are rounded at the category level, the way Form 100 computes them.
By employee
Every record in source order. Differences are carried unrounded and rounded once at the end, so they can differ by a cent from the category view.
Rate differences
Records where what was withheld does not match the category rate. The implied rate is the contribution divided by the ERB basis — useful for telling a wrong rate apart from a wrong wage.
Items needing a decision
Everything the reconciliation could not resolve on its own. Clear these before relying on the figures.
What can each federal fund pay for?
Every 24000-series flow-through fund in the PED chart, with the expenditure objects and functions set up for it. A check mark means the fund, function and object combination exists in the chart line listing; it does not mean the grant's own budget allows it.
NMPSIA Bill Reconciliation
Coverage month
—
1 · NMPSIA billMonthly BillCarrier billing CSV from NMPSIA — no header row
2 · Payroll liabilitiesPayroll Liabilities For Date Range ReportRun it in AptaFund over the month's pay dates and save it as a CSV file
3 · Payroll register — optionalPayroll Register Payments ReportAdds the per-employee views: who was withheld the wrong amount. CSV from AptaFund.
Example data — not your files.Fictional employees and 900-series placeholder SSNs, shown to demonstrate how the reconciliation reads. Drop your own files above to replace it.
Tie-out
—
Invoice total
—
NMPSIA bill
Withheld by payroll
—
Payroll liabilities
Difference
—
Invoice less payroll
Payment to remit
—
Voucher plus adjustment
The bill against payroll, coverage by coverage
What the carrier billed against what payroll actually withheld for NMPSIA, from the liabilities report's own rows. Any gap is the reconciling item to chase.
Invoice against payroll, by employee
One row per person on either side. Rows are flagged where the invoice and payroll disagree on any coverage.
Employee share against employer share
The employee's correct share is 20% of the invoiced premium — voluntary life is fully employee-paid, basic life fully employer-paid. Comparing that to what payroll actually withheld separates a deduction error from a premium error.
Adjusting entry
The employer variance posts by account code against the benefit object for each coverage. The employee variance is collected from — or refunded to — the employee through payroll.
Employee collect / refund
Positive collects from the employee on a future check; negative refunds to them.
Items needing a decision
Everything the reconciliation could not resolve on its own. Clear these before you sign off — an unmatched name silently becomes a variance.
Settings — employee share, deduction mapping, name matching
Employee / employer split
Medical, dental, vision and long-term disability are split 80/20 for every employee — the employer pays 80% of the premium and the employee 20%, whatever the salary. Change the share here only if NMPSIA changes the schedule. Voluntary life stays fully employee-paid and basic life fully employer-paid.
Deduction mapping
How each payroll deduction is placed on a coverage line of the bill. Districts name the same plan differently — "Davis Vision", "Davis Vision PRE TAX", "C. Vision - Davis Vision" — so names are matched by the carrier and coverage they mention, and on the register by whether the amounts equal the bill. Each row says how it was matched. Override any of them here; the choice covers every pre-tax and adjustment variant of that plan and is remembered.
Name matching
The bill identifies people by social security number. Name matching applies when an employee-level source is loaded. Matches are made automatically; anything ambiguous is listed here and remembered for next month.
Invoice generator
For billing an outside party: another district, a REC, a community group, or any organization that owes the school money. Fill in the form and download a PDF. Nothing is saved to the site.
Your school
A PNG or JPEG. It appears at the top of the invoice and is kept in this browser.
Your school's details are remembered in this browser for next time.
Bill to
Invoice details
Lines
Totals and notes
Boredom Buster
Roadrunner Run
Waiting on a report to load? Sprint across the high desert. Clear the cactus, mind the rattlers, and grab every chile on the way.
Space or ↑ jump · ↓ duck · tap the desert to jump
On the ground
Prickly pear, cholla, yucca and coiled rattlesnakes. Jump them. Tumbleweeds roll in faster than they look.
In the air
Red-tailed hawks fly at three heights. Hop the low ones, duck the middle ones, and stay grounded under the high ones.
Red or green?
Each chile is worth 25 points. Collect both red and green in one run and you finish Christmas style.
Loading lessons…
Links
Coming soon
A collection of useful links for school business offices is on the way.
Calendar
Coming soon
A calendar of deadlines and reporting dates is on the way.