Manual journal entries as a share of all journals. High manual share signals automation gaps, control risk, and audit scrutiny.
At a glance
The proportion of all journal entries in the period that were keyed by hand rather than posted automatically by a sub-ledger or connector. This is one of the most watched control metrics in finance, because every manual journal is a judgement call with no system control behind it: it can be wrong, it can be unauthorised, and it is the first place an auditor looks for earnings management. A low, stable manual share means your automation is carrying the load and your controls are sound. A rising share means the automated machine is failing somewhere and humans are patching the gap, which is slower, riskier, and more expensive. Sage Intacct stamps each batch with its source; the card divides the manual-JE count by the total to render the share.
Calculation
Calculated automatically from your Sage data by dividing the count of manual journal entries by the total journal count for the period. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK ecommerce group on Sage Intacct, two entities (UK Trading Ltd in GBP, EU Trading BV in EUR), consolidated monthly. Annual revenue ~£22M across Shopify and a BigCommerce B2B portal. Snapshot taken 9 Jun 26 covering the trailing 30 days. Default alert threshold of 25%. The card renders a gauge.
Five things to notice:
- 24.9% sits right under the 25% alert, and the proximity to the line is itself the story. A manual share approaching a quarter of all journals is high for an ecommerce business that should be running mostly on automation. The card has not technically fired, but a Controller who waits for it to cross 25% is missing the point: the trend is what matters, and a share this close to the threshold means the automated posting machine is leaking somewhere significant. The right read is not “we are still under the limit” but “why is a quarter of our ledger being keyed by hand.” That question is what this card exists to provoke.
- The fix is almost always at the mapping layer, not in a control crackdown on the finance team. A high manual share is usually a symptom of unmapped transactions, not undisciplined accountants. On this account the manual slice cut by GL account showed that most of the 1,790 manual entries were daily PSP fee journals and marketplace settlement reclasses, both of which should post automatically once the fee descriptors and settlement formats are mapped. Telling the team to do fewer manual journals would just delay the work; mapping the PSP fees and the marketplace settlements eliminated about 1,400 of the 1,790 entries, dropping the share from 24.9% to roughly 5%. The lesson is that this card is a pointer to an automation gap, and the cure is engineering and configuration, not exhortation.
- High manual share is the single biggest red flag for an external auditor. Auditors sample manual journals heavily because they are the entries most exposed to error and to manipulation: a manual JE can move revenue between periods, reclassify an expense to capital, or plug a number to hit a target, and none of those have a system control stopping them. A business carrying a 25% manual share will face more audit sampling, more questions, and more documentation requests than one at 5%. Reducing the manual share is therefore not just operational tidiness; it materially reduces audit friction and the risk of a finding.
- A rising trend is more alarming than a high-but-stable level. A business that has always sat at 18% because of genuine consolidation complexity is in a different position from one that has climbed from 8% to 18% over three months. The trailing comparison on the card is what distinguishes the two. A climbing share means something that used to automate has stopped: a feed broke, a new channel was added without mapping, a new PSP appeared, or a vendor changed its invoice format. On this account the share had crept up over two months as a new Amazon marketplace settlement type started arriving unmapped, which the trailing view caught before it became structural.
- Pair with Journals by Source Module for the full mix and Smart Coding Queue Depth (24h) for the upstream cause. This card is the alert; the source-module card shows the whole distribution; the Smart Coding queue shows the uncoded transactions that force the manual entries in the first place. Read as a trio they form a clean causal chain: the queue backs up because something is unrecognised, finance clears it by hand-keying journals, and the manual share rises. Fix the recognition rule at the top of the chain and all three cards improve together. On this account that is exactly how the fix played out.
Sibling cards merchants should reference together
Reconciling against Sage
Where to look in Sage Intacct: The native Sage Intacct views to run side by side with this card:General Ledger → All → Journal Entries filtered to manual entries for the period, counted against the total journal count General Ledger → All → Manual Journal Entries (the dedicated manual-JE list) for the numerator Audit Trail on the manual entries to attribute them to preparers and to see the create/approve/post chain Reports → General Ledger → GL Detail grouped by source, exported to compute the manual share against the total Interactive Custom Report (ICR) on the GL data source counting manual-source batches divided by total batches over the trailing window, grouped by GL account to reveal what is being manually postedIntacct distinguishes manual journals from sub-ledger and connector postings via the batch source stamp, which is what makes this ratio reliable. The card’s numerator matches a native Manual Journal Entries count for the same period, and the denominator matches a native total-journal count, as long as both use batch-level counting and the same period boundary. For Multi-Entity Console accounts compute the share per entity at the dashboard scope, because manual reliance often concentrates in the entity with the most complex consolidation work. Common reconciliation pitfalls:
- What counts as manual: Intacct’s adjustment journals, statistical journals, and inter-entity journals can each be classified as manual or not depending on configuration. The card uses the source stamp; a native report that filters differently will produce a different numerator.
- Recurring journals: a recurring template that posts automatically should not count as manual even though a person designed it. The card classifies by posting source; a naive filter on “created by a user” would over-count.
- Approval-routed manual JEs: a manual JE that went through Intacct’s approval workflow is still a manual entry for this ratio. Some teams mentally exclude approved ones as “controlled”; the card counts them, because the control is approval, not automation.
Cross-connector reconciliation:
The cross-connector value is that the manual share is usually a downstream symptom of an upstream recognition gap that lives at the connector boundary. When a PSP changes its fee descriptor, a marketplace adds a new settlement format, or a new vendor appears, the transactions arrive unrecognised, pile into the Smart Coding queue, and finance clears them by hand. Reading this card against the Smart Coding queue and the commerce connectors shows the cause, not just the symptom, which means the fix is a one-time mapping change at the top of the chain rather than an endless stream of manual journals at the bottom.