Loading…
Loading…
Both NetSuite and Acumatica keep an audit trail you cannot edit. Neither assembles it into something you can hand over, and that is the actual work.
Start with the good news, because it is substantial and it is usually undersold.
NetSuite runs a dependency-aware period close checklist, locks subledgers, verifies gapless GL numbering, and keeps system notes that Oracle states cannot be edited by any user, script or app. Acumatica closes subledgers before the general ledger, blocks a period from closing if the prior one has not, forbids deleting a journal entry, and lets you drill from a GL balance to the document behind it.
Both are genuinely strong. If your close is painful, it is very unlikely that the ledger is the reason.
The gap is narrower and it sits in a specific place: the schedules that do not live in the ERP.
An auditor picks a journal. Not a hard one, just a line in deferred revenue for $50,000 in July. They ask what it was.
For a journal the ERP produced from its own subledger, this is a drill-down. Click through, see the invoice, done.
For a journal that came from a schedule maintained outside the ERP, the chain looks like this:
$50,000 modification traces to
Contract amendment, clause 4 source document
Reallocation across obligations calculation
Revised schedule, months 9 to 20 schedule
Journal entry posting
General ledger, July GL
Every one of those exists. The amendment is in a contract folder or a signing system. The reallocation is in a workbook. The revised schedule is a tab in that workbook. The journal is in the ERP. The balance is in the GL.
Five artifacts, four systems, and no link between them except somebody's memory of which file it was.
The pieces are individually findable. What is missing is the join.
The journal carries a description and maybe a reference. It does not carry a pointer to the workbook version that produced it, and the workbook has been edited eleven times since. The version that produced July's number is not necessarily the version sitting there now, and there is no way to tell from either end.
So fulfilling the request means reconstructing: find the amendment, work out which period it hit, rebuild the reallocation, check it against what was posted, and explain the difference if there is one. That is not retrieval, it is redoing the work under time pressure with someone waiting.
NetSuite's account reconciliation reports are documented for bank and credit card accounts. Acumatica's mark-and-clear reconciliation is documented for bank accounts. Both are appropriate to what they cover.
Neither documents a reconciliation control for a general GL account backed by a schedule held elsewhere. There is no preparer and reviewer state, no tie-out status, no reconciling item ageing for deferred commission, ROU assets, equity expense or a revenue schedule maintained in a workbook.
That is not a deficiency in either product. Those schedules are outside the system, so the system cannot reconcile them. It is simply the part that is still done by hand, and it is the part that costs a day per request.
Three things, and none of them is a replacement for the ERP.
A link that survives. The journal carries a reference to the schedule version that produced it, and that version is retained. Not the current workbook, the one that was live when the entry posted.
Reconciliation as a control, not a report. A statement with a preparer, a reviewer, a date, a status, and a list of reconciling items with ages. A report tells you the balance. A control tells you somebody checked it and who.
Assembly on request. Given a journal, produce the chain: amendment, calculation, schedule version, entry, balance. As a package, not as five lookups in four systems.
The pieces already exist in your business. What does not exist is anything that holds them together, which is why the request costs a day rather than a minute.
Not with a system. Count the schedules that live outside the ERP and produce a journal each period. Most companies find between three and eight, and are surprised by at least one of them.
That count is the size of the problem, and the ones nobody could name are the ones to look at first.
Not sure where your process sits?
Seven questions on the schedules outside your ERP, and what an auditor request costs today.