How to Automate Accruals in QuickBooks Online

QuickBooks Online runs accrual accounting natively. What it does not do is automate the recurring journal entries that accrual produces every period. For more than a handful of prepaid schedules, deferred revenue contracts, or payroll cycles, the manual entries become the limiting factor on close speed.

What needs automating, and what does not

Not every journal entry should be automated. The work that benefits from automation has three features: it repeats every period, the calculation logic is deterministic, and the entry posts to the same accounts each time. Work that lacks any of those features — judgment-based accruals, one-off transactions, error corrections — should stay manual.

The entries that fit all three criteria, and that consume the bulk of accrual close time:

• Prepaid expense amortization. A schedule defined once at contract signing produces the same monthly entry across the period of benefit.
• Deferred revenue recognition. Once a contract is set up with a recognition schedule, the monthly entry follows a fixed formula.
• Fixed-asset depreciation. Useful life and method determine the schedule; the monthly entry is mechanical.
• Payroll accruals. Days between the last pay date and period-end times daily wage cost, with employer payroll taxes calculated against the wage base.
• Recurring vendor accruals. Estimated amounts based on prior invoices or contract rates, posted at period-end and reversed at the start of the next period.

What should stay manual: judgment-based accruals where the amount requires investigation, one-off correcting entries, complex bonus calculations that depend on multiple variables, and any entry that has not been recurring long enough to characterize.

What QuickBooks Online does on its own

QBO supports accrual accounting natively for reporting. The accrual-basis financial statements come out of the box, the chart of accounts supports all the working-capital accounts, and journal entries can be created, edited, and reversed.

QBO's recurring transaction feature can carry a small number of fixed-amount recurring entries — useful for monthly rent that does not change, a flat-rate subscription, simple amortization of a single prepaid item. The feature posts entries on a schedule but does not handle anything calculated, anything with locked-period awareness, anything that needs to be reconciled against an external schedule, or any entry whose underlying parameters change over time.

For one or two recurring items, the feature is adequate. For a portfolio of accruals, it falls short on every dimension where automation matters most.

Where the manual bottleneck shows up

The bottleneck reveals itself in the structure of the close. A typical manual monthly close looks like this:

• Days 1–3. Pull data, reconcile bank accounts, post cash transactions, review AP and AR aging.
• Days 4–7. Recurring journal entries: prepaid amortizations, deferred revenue recognition, depreciation, payroll accruals, vendor accruals. Reverse prior period accruals where applicable.
• Days 8–10. Review, judgment entries, financial statement preparation, manager review.

The middle block — days four through seven — is almost entirely repeating work. The schedules are defined; the calculations are deterministic; the entries post to the same accounts every month. None of it requires accountant judgment. All of it requires accountant attention.

Compressing the close means automating that middle block. When the recurring entries post on their own before the close even starts, the close shrinks to its first and last segments. The first segment is faster because there is less data to organize; the last segment is faster because there are fewer entries to review.

What Accruer does inside QBO

Accruer is an accrual automation app for QuickBooks Online. It runs alongside QBO, reads the chart of accounts and the existing journal entries, and posts recurring accrual entries on a schedule defined once at setup.

The schedules cover all of the recurring entry types: prepaid amortization, deferred revenue recognition, fixed-asset depreciation, payroll accruals, and recurring vendor accruals. Each schedule has a start date, an end date or duration, a total amount, and an account mapping. Once set, the schedule runs on its own.

Two features make Accruer different from a generic recurring transaction tool: locked-period awareness, and mid-stream recalculation.

Locked-period awareness and mid-stream recalculation

Locked-period awareness is what separates accrual automation from generic transaction automation. When a period is closed in QBO, no entry should post to it. Accruer knows which periods are locked and adjusts behavior accordingly:

• New schedule created after a period is locked. Accruer skips the locked months and starts the schedule in the first open period. If the user wants the locked months recognized, the user can post a catch-up entry in the first open period rather than reopening the closed period.
• Schedule correction made after one or more periods have closed. Accruer leaves the locked periods untouched and applies the correction starting from the first open period.
• Mid-stream change to a contract. A 12-month deal that turns out to be a 9-month deal, with two months already posted in locked periods, is handled by recalculating the remaining 7 months against the revised total minus what has already been recognized. The locked months stay untouched.

The mid-stream recalculation case is one of the most common operational gotchas in accrual accounting. Doing it manually requires figuring out what has been posted, what is left, and how to split the difference correctly across the remaining periods. Accruer does it automatically.

Real-world use cases

The use cases we see most often:

Annual insurance premiums. A general liability policy paid in January for the full year. Accruer creates the prepaid schedule once with the start and end dates, and posts the twelve monthly amortizations automatically.

Annual or quarterly software subscriptions. Whether the term is twelve months, quarterly, or some non-standard length, the schedule is defined once and runs on its own. Multi-vendor environments where dozens of these run concurrently benefit most.

Event sponsorships and deposits. A $30,000 conference sponsorship paid in June for an October event sits in prepaid expenses until the event happens, then expenses all at once on the event date. Wedding deposits, conference registrations, and trade show deposits follow the same pattern.

Deferred revenue on SaaS contracts. Annual contracts collected upfront create a deferred revenue schedule that recognizes monthly across the contract term. Multi-tier pricing and add-ons can be handled as separate schedules or as a single combined schedule.

Payroll accruals. Bi-weekly pay cycles that drift relative to calendar months produce a payroll accrual at every period-end. Accruer reads the pay-period detail and posts both the wage accrual and the employer payroll tax accrual against the right expense accounts.

Recurring vendor accruals. Utilities, contractor relationships with predictable monthly engagement, and ongoing professional services that invoice on a delayed cycle all produce recurring accruals at period-end.

How implementation actually works

Setup runs in four steps:

1. Connect Accruer to QuickBooks Online. OAuth connection; no data leaves QBO that does not need to.
2. Identify existing schedules. For active prepaids, deferred revenue items, and ongoing accruals, Accruer reads the existing GL balances and the supporting schedules. New schedules are entered through Accruer's UI.
3. Define account mappings. For each schedule type, specify the source expense account, the prepaid or accrued liability account, and any class or department tagging.
4. Set the posting schedule. Most teams run accruals on the first business day after period-end, with reversals on the first business day of the new period.

After setup, the day-to-day workflow is exception management. The schedules run on their own; the accountant reviews the posted entries against the supporting schedules and investigates anything that does not reconcile.

What automation pays back

The most direct payback is close-time compression. Most teams that move from manual recurring entries to automated ones shave three to four days off their monthly close. For a controller whose loaded cost is $X per hour, that is direct labor savings.

The less direct payback is accuracy. Manual recurring entries accumulate small errors over time — a rounding inconsistency, a missed schedule, a reversal that was forgotten last period. Automated schedules compound less error per period and the errors that do appear are easier to find because the schedule itself is the audit trail.

The least direct payback, but often the most valuable, is what happens to the close window. A close that takes three days instead of ten changes what the finance team can do with the rest of the month. Forward-looking analysis, FP&A work, and operational support replace data entry.

Accruer vs the QBO recurring transaction feature

The honest comparison: QBO's recurring transaction feature is fine for a small number of fixed-amount entries that never change. It posts on schedule and creates the journal entry as defined.

What it does not do: handle locked-period mechanics, recalculate when a schedule changes, reconcile against an external schedule, post both an accrual and a reversal as a paired entry, calculate amounts from external data, or surface variance against expected outcomes.

For one or two simple prepaids, the QBO recurring feature is enough. For a portfolio of accruals with mid-stream changes, locked-period concerns, and reconciliation requirements, it is not designed for the job.

"The middle four days of a manual close are exactly the work nobody wants to do, and exactly the work that nobody needs an accountant for. Automating it does not eliminate the accountant. It moves the accountant out of data entry and into review." — Tom Zehentner, CPA · Product & Growth, FinOptimal

Common mistakes

Frequently asked questions

Where to go next

Read these next:

1. Accrual Accounting: the complete operational guide
2. Prepaid expenses: the most common automation use case
3. Payroll accruals: end-to-end mechanics

Related Resources

• Deferred revenue accounting: schedules and worked examples
• Accrued liabilities: a controller's working guide