Manual journals as a percentage of all journals. The higher it climbs, the more your close runs on hand-keying instead of automation.
At a glance
Manual JEs as % of Total expresses the count of manually entered General Ledger journals as a percentage of all journals posted in the window. It is the distilled controls signal from the broader Journals by Source mix. A low ratio means automation (Receivables, Payables, Inventory via Subledger Accounting) is doing the work. A high or rising ratio means humans are hand-keying entries the system should generate, which is the classic audit red flag for both control weakness and error risk. The gauge makes the trend obvious at a glance and fires when the manual share gets uncomfortable.
Calculation
Calculated automatically from your Oracle ERP Cloud data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A Fortune 500 omnichannel retailer runs Oracle ERP Cloud across three Business Units. The controller reviews the manual ratio over two consecutive 30-day windows: 14 Feb 26 to 15 Mar 26, then 16 Mar 26 to 14 Apr 26.
Four things to notice:
- The ratio jumped from 7.5% to 26.8% in one period and crossed the alert line. The total journal count barely moved (3,200 to 3,400), but the manual count nearly quadrupled. That tells you the rise is real hand-keying, not just higher overall volume.
- The cause was a Receivables integration outage. For nine days, AutoInvoice failed to post a batch of ecommerce revenue automatically, so the close team booked the revenue by hand to keep the period on track. The manual journals were the symptom; the broken automation was the disease.
- The right fix is to repair automation, not to celebrate the manual heroics. Reopening the integration and letting AutoInvoice and Subledger Accounting reprocess the backlog removes the need for the manual entries going forward. The controller can then reverse or supersede the hand-keyed journals as the automated ones land, keeping the GL clean.
- At quarter-end this would have been an audit finding. A manual ratio near 27% with a cluster of large revenue journals keyed by hand is exactly the population an auditor samples. Catching it in real time, with the cause identified, turns a potential finding into a documented and resolved incident.
Sibling cards merchants should reference together
Manual JEs as % of Total is the alarm; the cards below are the diagnosis and the surrounding pipeline.Reconciling against Oracle ERP Cloud
Where to look in Oracle ERP Cloud: The closest native equivalents in the Oracle Fusion UI are:Navigator → General Accounting → Journals → Manage Journals (filter Source = Manual, count headers, compare to all sources) Reports and Analytics → OTBI → Financials → General Ledger - Journals Real Time (build a Manual-count over Total-count ratio) Navigator → General Accounting → Period Close → Close Status (journal counts feeding the close)The simplest reconciliation is to run the OTBI Journals Real Time subject area, count journal headers where Source is Manual, divide by total journal headers for the same period and scope, and compare to the gauge. They should match to within rounding when the period, Business Unit, and Ledger scope are identical. Common mistakes when comparing against Oracle’s own reports:
- Counting lines instead of headers. A single manual journal can have many lines. Decide whether you are counting headers or lines and apply the same basis to both numerator and denominator. The card counts journal headers.
- Including or excluding Spreadsheet inconsistently. Some controllers treat ADFdi Spreadsheet uploads as manual; others keep them separate. Confirm which convention the card uses and match it in Oracle.
- Different windows. A trailing 30-day window and a fiscal period rarely line up exactly. Compare like for like.
Known limitations / merchant FAQs
What manual ratio is normal? It varies by business and by where you are in the close cycle, but for most large-enterprise commerce-connected ledgers a healthy steady-state sits in the single digits to low teens as a percentage. The alert line of>25% is set above typical normal so it fires on genuine elevation, not on a busy but ordinary close. The trend matters as much as the level: a doubling from a low base is a signal even before it crosses the threshold.
Does a high ratio always mean something is wrong?
Not always. Some periods legitimately carry more manual entries: a complex month-end with many accruals and reclasses, an acquisition integration, or a one-off restatement. The card flags the elevation so a human can judge whether it is explained. The danger is a high ratio that nobody can account for, which is when it becomes an automation gap or a controls weakness.
Why do auditors care so much about manual journals?
Because manual journals are where financial-statement misstatement is most likely to be introduced, either by error or intentionally. They bypass the validations and approvals that automated subledger posting enforces. External auditors routinely extract the full manual journal population and test a sample, looking at who posted, the account combinations, round-number amounts, and entries posted near period-end. A consistently low manual ratio is evidence of strong automated controls.
Should I count Spreadsheet (ADFdi) uploads as manual?
Many controllers do, because an ADFdi upload is still a human deciding the amounts and accounts, just loaded in bulk rather than keyed one at a time. The card’s convention is documented in the source mix; if you prefer to treat Spreadsheet separately, read this card alongside Journals by Source, which keeps the slices distinct.
The ratio spiked but our automation is fine. What else causes it?
Two common benign causes: a quiet automation period (fewer Receivables and Payables journals because of a seasonal lull) mathematically lifts the manual share even if the manual count is flat; and a deliberate batch of reclasses or corrections at period-end. Read this card with Journals by Source to tell whether the manual count rose or the automated denominator fell.
How do I bring the ratio down?
Fix the automation gaps, not the symptom. Repair broken integrations so Receivables, Payables, and Inventory journals post automatically again; build Subledger Accounting rules for recurring event types people currently key by hand; and convert standing manual accruals into automated allocation or recurring-journal definitions in Oracle. The ratio falls as the system reclaims the work.