Short answer
ERP Sync keeps prepaid, accrual and balance-sheet reconciliation schedules next to the ledger. It auto-matches each expected entry to actual GL activity (within a date tolerance, to the penny), shows actual vs expected balance, and runs a gap check that flags any month where an expected entry was never posted.
Two kinds of schedule
- Amortization schedules for prepaids and accruals: the premium or basis, payments, monthly amortization, adjustments and renewals across fiscal years.
- Composition schedules for balance-sheet reconciliations: the open items that make up an account balance, with a proof that must tie to the GL to the penny.
How matching and gap checks work
- The agent builds the schedule from the contract, invoice or prior workpaper.
- ERP Sync matches each expected row to GL activity within a few days and to the penny, and pairs equal-and-opposite entries as netting pairs.
- The schedule shows actual vs expected balance; any difference is missed activity.
- At close, the gap check lists every elapsed month whose expected entry never posted.
What to ask your AI agent
With ERP Sync connected to Claude, ChatGPT, or another MCP-capable agent, requests like these work as written:
Build a prepaid schedule for the 12-month Hartford policy starting 7/1 for $14,400 and match it to the GL.
Run the gap check on all prepaid schedules through September.
The ERP Sync tools behind it
These are the MCP tools an agent calls. Each one is switched on or off per user, and read-only versus read-write is set per feature.
| Tool | What it does |
|---|---|
| erp_schedule_create / erp_schedule_rows_upsert | Creates schedules and manages their rows. |
| erp_schedule_match | Auto-matches expected rows to GL activity. |
| erp_schedule_gap | Finds elapsed months with no posted entry. |
Limits and requirements
- Schedules read the synced ledger; the agent is instructed not to post the amortization entries itself — you post or approve them.
Frequently asked questions
Does it post the monthly entry?
Schedules track and verify. Posting stays a deliberate step — by you, or by an approved batch.