QuickBooks Online Automation: 6 Settings to Switch On

QuickBooks Online automation settings: bank rules, recurring transactions, and approvals

QuickBooks Online ships with more automation than most businesses switch on. The typical file is paying for cloud accounting and being run like a paper ledger: bank lines coded by hand, invoices chased from memory, receipts in a drawer.

Most of the fix is configuration, not purchasing. The six settings below remove manual work in roughly the order that pays back fastest. Features and limits vary by plan, so check what your subscription includes before building around any of them.

This is a practical list of QuickBooks Online automation settings, what each one saves, and what to watch so automation doesn’t quietly produce errors faster.

QuickBooks Online Automation: 6 Settings Worth Switching On

01  Bank feeds and bank rules

Connect every bank and credit card feed, then build rules for payees that repeat. The goal is a team that reviews exceptions instead of coding every line. Our month-end close guide names this as the single biggest lever on close time.

02  Recurring transactions

Set up recurring invoices, bills, and journal entries for what repeats: depreciation, prepaid amortization, accrual reversals. They post on schedule instead of waiting to be remembered.

03  Automatic invoice reminders

Schedule reminders for overdue invoices so collections follow-up happens consistently. Receivables aging is cleaner when month-end arrives, and nobody has to remember who to chase.

04  Receipt capture

Photograph or forward receipts so they attach to the transaction when the purchase happens, instead of being gathered at month-end.

05  Approval workflows

On plans that include custom workflows, route bills or purchases for approval and set reminders for pending items. It puts a control inside the process without adding a meeting.

06  App connections for payables and expenses

Tools such as Dext, Hubdoc, and Bill.com read supplier bills and push them into QuickBooks already coded, which removes the retyping. Choose one flow and document it.

What to Switch On First

If you do one thing, set up bank feeds and rules properly. That is where most manual time sits. Add recurring entries and invoice reminders next, because they’re low risk and easy to check. Leave approval workflows and app connections for last, once the process they sit on is written down. See documented procedures for why that order matters. Once a period is reviewed, set a closing date so it can’t be changed by accident. It isn’t automation, but it protects the output of every setting above.

5–8 hrs
per close from using the cloud
features you already pay for,
per our month-end guide

Exceptions
what your team
should be reviewing

Quarterly
how often to
audit your rules

Want your QuickBooks file doing more of the work?

Book a free 30-minute discovery call. We’ll look at your file, tell you which settings would save the most time, and be clear about what isn’t ready to automate.

Book a Free Discovery Call →

How to Build a Bank Rule That Holds Up

Rules are where most of the time is saved and where most of the quiet errors start. Build them deliberately:

01Pick payees that never change category. Start with software subscriptions, bank fees, fuel, and payroll providers. A payee that is sometimes one category and sometimes another isn’t ready for a rule.
02Match on something specific. Use the payee name or a distinctive part of the description as the condition. Add an amount condition only when the amount is reliably stable.
03Suggest first, auto-add later. Set new rules to propose the coding for a person to confirm. Switch to automatic only after the rule has been right for several months.
04Write the rules down. Keep a short list: the payee, the account, who set it, and when. When someone leaves, the logic stays.
05Audit on a schedule. Review the rule list every quarter and after any change in the business, such as a new product line or supplier.

What Changes at Close

The effect shows up in the weeks before month-end, not on the last day. Here is the typical shift when these settings are working:

Task Before After
Coding bank lines Every line coded by hand at month-end. Rules propose the coding; a person reviews the exceptions.
Chasing receivables Done from memory when someone has time. Reminders go out on schedule, so aging is cleaner at close.
Supplier bills Typed in from PDFs. Arrive coded from the connected app and are approved, not retyped.
Depreciation and accruals Remembered, or missed, each month. Recurring entries post on schedule and get reviewed.
Receipts Gathered in a batch at month-end. Attached to the transaction when the purchase happens.

A Sensible 90-Day Plan

You don’t need to switch everything on at once. Spreading it out keeps each change reviewable:

01Month one: bank feeds and rules. Connect the feeds, build rules for the repeat payees, and review exceptions weekly.
02Month two: recurring entries and reminders. Schedule depreciation, prepaid, and accrual entries, and turn on invoice reminders.
03Month three: receipts and app connections. Add receipt capture and connect one app for supplier bills, then document how each flow works.
04After that: workflows and a quarterly audit. Add approval workflows if your plan includes them, and put the rule review on the calendar.

Where QuickBooks Automation Goes Wrong

  • ✗Rules nobody audits. A rule that categorizes a payee wrongly will do it every time. Review your rules quarterly and after any change in the business.
  • ✗Posting without review. Let the feed suggest and a person confirm until a rule has earned trust.
  • ✗Recurring entries that never get updated. A depreciation entry built for last year’s assets is wrong this year.
  • ✗Automating an undocumented process. If nobody can say what correct looks like, automation just reaches the wrong answer faster.
  • ✗No named owner. Someone has to be responsible for reviewing exceptions. Otherwise they pile up in a suspense account.

Automation also works best on current, reconciled books. If your file is months behind, start with accounting catch-up, then automate.

Before You Automate: A Short Checklist

  • ✓The books are reconciled up to date.
  • ✓The chart of accounts is clean, with no duplicate or overlapping accounts.
  • ✓One person owns the exceptions and reviews them on a set day each week.
  • ✓A closing date is set on reviewed periods.
  • ✓The process the automation will follow is written down.

Frequently Asked Questions

Is QuickBooks Online automation safe?

Yes, when automation proposes and a person confirms, rules are audited on a schedule, and someone owns the exceptions. The risk comes from unreviewed rules and entries that post without a check.

Do I need a higher QuickBooks plan?

Many of these settings are available across plans, but availability varies, and custom workflows sit on higher tiers. Check your plan on the QuickBooks Canada site before you build around a feature.

How many hours can automation save?

It depends on transaction volume and how much is manual today. In our month-end close guide we estimate that fully using the cloud accounting features you already pay for saves 5–8 hours per close.

Does this apply to Xero too?

Yes. Xero has equivalents such as bank rules and repeating transactions, and the same principles hold: automate what repeats, document the process, and name a reviewer.

Should we use AI for this?

Rules-based automation comes first, because it is predictable and easy to audit. AI tools can add value on top of it, with a human reviewing the output. See our guide to AI agents in accounting.

The Bottom Line

QuickBooks Online automation isn’t about buying more software. It’s about using what you already pay for, in the right order, with a person reviewing what it produces.

  • ✓Start with bank feeds and rules: that’s where most manual time sits
  • ✓Document before you automate: automation executes whatever process you give it
  • ✓Audit your rules quarterly: a wrong rule repeats its mistake every time

Put your QuickBooks Online file to work

Book a free 30-minute discovery call. We’ll review your setup and show you where automation would remove the most manual work, with a CPA reviewing the result.

📞 1-888-339-9975  ·  ✉️ info@canadiancloudaccounting.ca