QuickBooks Online Advanced Operating Manual: Day-to-Day Workflow
Operating Manual: The Daily QBO Advanced Routine for Finance Teams
For Operating Manual, a clean QBO Advanced file is the result of small daily habits, not heroic monthly cleanups. The bookkeepers who keep the calmest files are the ones who spend 20 to 40 minutes every morning on a fixed routine and then close the tab. The ones whose files are a constant fire drill skip the routine and try to fix everything at month-end. Don’t be that person.
Here is the daily routine we hand to every new bookkeeper on a Reed Corporation client engagement. It starts in the same place every day — the dashboard — and ends in the same place every day — an empty QBO Tasks queue.
The 30-minute daily checklist.
- Open the QBO dashboard. Glance at the cash balance, the AR aging summary, and the bills due. Two seconds each. If anything looks wrong, that is your first investigation of the day.
- Bank feed (10 minutes). Open For Review. Categorize new transactions. Accept any that bank rules already classified. Anything weird (new vendor, off-pattern amount, transfer that does not look right) gets parked in a “needs follow-up”. Project or saved as a Task for the controller.
- Tasks queue (5 minutes). Clear anything that workflows or coworkers have pushed into your queue overnight — bill approvals, JE reviews, customer questions. If you can’t act on it in two minutes, leave a comment with a clear next step.
- AR follow-up (5 minutes). Look at the AR aging. Anything that hit a new bucket overnight (now 30 days, now 60, now 90) gets a follow-up email or a flag for the AR person. If you have automated reminder workflows running, this step is mostly a sanity check.
- AP today (5 minutes). Open the bills-due-today view. Confirm anything paying out today is correct. If you use an AP tool like Bill or Ramp, this is where you eyeball the queue before payments hit.
- Inbox (5 minutes). Customer questions, vendor invoices that came in by email, controller messages. Action what you can in two minutes, schedule the rest.
That is it. 30 minutes if the day is normal, 45 if there is a real issue. Most of the day-to-day chaos in QBO files comes from skipping this routine for a few days and then coming back to a 200-item For Review list, a stale AR aging, and a Tasks queue full of stuff that needed action three days ago.
One sharp point worth saying: do this in the morning, not the afternoon. The afternoon-routine bookkeeper always pushes it to tomorrow when something urgent comes up. The morning-routine bookkeeper gets it done before urgent things happen. We see this play out at every client. It is not about discipline, it is about scheduling.
For the controller or finance manager, the daily routine is shorter but more strategic. Five minutes on cash, AR aging, and the workflow queue. Five minutes reviewing any JEs the bookkeeper flagged. Five minutes on anything escalated from yesterday. The controller is not doing the bookkeeping, but they are checking that the bookkeeping is happening.
Weekly Tasks That Keep the Books Clean
Weekly tasks are the layer above daily hygiene. They catch things the daily routine cannot — patterns, exceptions, items that need a slower second look. We run these every Friday afternoon on every client file, and we run them whether or not anything looks broken.
The Friday afternoon weekly checklist.
- Bank reconciliation (running). Open Reconciliation. Pick the current period. Match what you can. The goal is not to finish the reconciliation — the goal is to know how close you are. If you find unreconciled items more than 14 days old, escalate.
- AR aging deep look. Pull the AR aging detail. Look at anything 60+ days. Look at customers with multiple open invoices. Look at the largest open balance. Decide what to do with each. We typically write down the customer, the amount, and the action (call, email, write off, escalate) in a shared doc.
- AP aging deep look. Pull the AP aging detail. Look at anything 30+ days unpaid. Make sure nothing critical is past due. Confirm there are no duplicates or vendor billing errors hiding in the older balances.
- Uncategorized expenses audit. Pull a report of any transactions sitting in Uncategorized Income or Uncategorized Expense. There should be zero. If there are more than three, fix them now.
- Bank feed exceptions. Pull a report of transactions excluded from bank feed or marked as transfers without matching pair. Anything weird gets investigated.
- Class and location consistency check. If you use class or location tracking, pull a report of transactions missing a class or location. There should be very few. If you see a pattern (one customer always missing class, one vendor always missing location), fix the bank-feed rule.
- Workflow check. Open Manage Workflows. Confirm everything is enabled and firing. Spot-check the history of one or two workflows. If a workflow has not fired in a week that should have, investigate.
The whole weekly review takes 60 to 90 minutes on a clean file. Above $5M in revenue or with multiple entities, expect 2 to 3 hours. Friday is the right day because anything you find can be fixed before Monday and because the bank feeds have caught up by Friday afternoon for almost every bank.
One habit that saves a lot of pain: keep a running log of every weird thing you find in the weekly review. Don’t fix it on the spot and forget about it. Write it down with the date, the description, and the resolution. When the same kind of weirdness shows up three weeks in a row, you have a real problem that needs a process change, not a one-off fix. We have a Google Sheet on every client engagement that does exactly this. It is the single most useful document in the whole engagement.
Weekly is also when we recommend running batch reclassify if you find systematic categorization errors. Reclassify is one of the standout Advanced features — it is faster to fix 40 transactions on Friday than to wait for them to compound through the rest of the month. We cover the batch reclassify mechanics in detail in our reclassify transactions guide.
The Monthly Close in QBO Advanced (vs. Plus)
The monthly close is where Advanced earns its price. The close is faster and more controllable than the equivalent Plus close, mostly because of four features Plus does not have: batch reclassify, custom fields and reports tied to management reporting, workflows that route JE approvals automatically, and revenue recognition automation. If you do not use those features, you are paying Advanced prices for Plus capabilities.
The 7-step Advanced monthly close.
- Bank and credit card reconciliation. Reconcile every account. Anything that does not match gets investigated, not forced. Forcing reconciliations is how books get quietly broken.
- AR review. Walk the aging. Write off uncollectibles with appropriate documentation. Reclassify any AR that has become a related-party loan. Confirm all customer payments have been applied.
- AP review. Walk the AP aging. Confirm accruals are appropriate. Catch any vendor bills that should have hit this month but did not arrive. Accrue them with a journal entry if the amount is material.
- Inventory adjustment. If you carry inventory, run the inventory valuation report, compare to physical, post the adjustment.
- Payroll accruals. If the pay period crosses month-end, accrue the portion that belongs to this month. This is one of the most commonly missed monthly close steps in QBO and one of the easiest to forget.
- Revenue recognition. If you use Advanced’s revenue recognition feature, run the schedule, post the recognition entries. If you don’t, but you should (recurring revenue, multi-month contracts), this is where you should adopt it.
- Management reporting. Pull the P&L, balance sheet, and cash flow. Run any custom reports you have set up in Advanced. Compare to budget. Note variances and explain.
What is different in Plus. In Plus, you do all of the above except you have to reclassify mistakes one at a time. You have to build management reports off the standard P&L instead of off custom-tagged data. JE approval routing has to happen manually through email. And revenue recognition requires a separate schedule maintained outside QBO. The total time delta between a Plus close and an Advanced close, on a $3M revenue company, is roughly two to three business days. On a $10M company, it is closer to four to six days.
Closing the books. Once the close steps are done, set the closing date in QBO under Account and Settings → Advanced → Accounting → Closing date. Set the password. This locks the period from accidental edits. We see clients skip this step constantly and then wonder why their prior period numbers keep changing. Set the closing date every month. It is a 30-second step that prevents hours of variance investigation later.
The AICPA’s guidance on close cycles and segregation of duties is worth reading if you are formalizing your monthly close. The AICPA audit and assurance resources set the bar for what a well-controlled close looks like. Not every small business needs to hit that bar, but knowing where the bar is helps you choose where to land.
For clients on our client accounting services engagement, we run the full Advanced close for them. For clients on bookkeeping only, we run the close steps and hand off the management reporting to the client’s controller or CFO. Either way, the steps above are the script.
Bank Feed Hygiene at Advanced Volume (>500 Transactions/Month)
Bank feeds are the single biggest source of bookkeeping rot. They are also the area where the time saved by good habits compounds the fastest. At 500 transactions a month, sloppy bank-feed handling costs you maybe two hours a week. At 2000 transactions a month, it costs you a person.
The four rules of bank-feed hygiene at scale.
1. Every recurring vendor gets a rule. Open Banking → Rules. For every vendor you see more than twice a month, create a rule that auto-categorizes the transaction to the right account, applies the right class, and assigns the right customer if applicable. The rule should pre-fill enough fields that the bookkeeper just clicks Accept. We typically set up 40 to 80 rules for a new client during onboarding and add 5 to 10 per quarter as new vendors appear.
2. Match rules tighter than the default. QBO’s default match logic is loose — it will sometimes match a Starbucks transaction to a different Starbucks rule. Tighten the rule by adding a description contains condition that includes a more specific string. For example, instead of “description contains starbucks,”. Use “description contains starbucks 1234”. Where 1234 is the store number that appears on the bank feed. The narrower the rule, the fewer wrong matches.
3. Review the rules quarterly. Bank-feed rules go stale. Vendors change their billing names. New stores open. The vendor merges with another vendor and the description changes. Once a quarter, open the rules list and audit. Anything that has not fired in 90 days gets evaluated. Anything that fired but matched the wrong vendor gets tightened or deleted.
4. Use the For Review list as your daily punch list, not as a holding pen. The For Review list should be near-empty at the end of every day. If you find 300 items in For Review at the end of a week, you are not running a daily routine. Fix the cause, not the symptom.
What breaks at volume. At 1000+ transactions per month, four things start to break that did not break at lower volumes. The default bank-feed connection times out more often (refresh manually if you see a gap). Duplicate transactions appear when QBO retries a connection (use the duplicate detection report in Banking to catch them). Bank rules can conflict when two rules both match the same transaction (the one created first wins, but the outcome is rarely what you want). And the categorization throughput becomes the bottleneck on the bookkeeper’s day, which is why bank-feed rules are the single highest-use thing you can invest time in.
The 14-day backstop. Every two weeks, pull a transaction list for the last 14 days, sorted by amount descending. Eyeball the top 50 transactions. Anything that looks miscategorized gets reclassified now, not at month-end. This is the safety net that catches the bank-feed rule errors you didn’t notice on the daily.
For more on cleanup mechanics when bank feeds have gone sideways, see our QuickBooks Online bookkeeping guide and our reclassify transactions guide.
Year-End Close Specific to QBO Advanced
The year-end close is the monthly close plus six things that only happen once a year. Most clients underestimate the time required by about 50%. A clean year-end close on a $3M revenue Advanced file takes 12 to 20 hours of focused work after a clean December monthly close. If December was a fire drill, double it.
The Advanced year-end checklist.
- Finish a normal December monthly close first. Every step from the monthly section above. No shortcuts. The year-end close lives on top of a clean December.
- Run depreciation and amortization for the full year. If you have not been posting monthly D&A entries, this is your last chance. We always recommend monthly D&A, but most small businesses post it annually. Pull the fixed asset schedule, calculate D&A by asset, post the JE.
- Inventory count and valuation. Physical count if applicable. Post any adjustment. Compare to the perpetual inventory in QBO.
- Owner draws and contributions. Walk every entry hitting owner equity. Confirm classification. Reclassify anything that should have been a different account (loan, expense, distribution). This is one of the most common cleanup areas at year-end for small businesses, and it has direct tax consequences.
- 1099 prep. Pull the 1099 vendor report. Confirm every vendor over $2,000 has a W-9 on file. Confirm every contractor is flagged as 1099-eligible. File 1099-NEC by January 31. The IRS rules on contractor classification and reporting are at irs.gov.
- Sales tax reconciliation. If you collect sales tax, reconcile what QBO shows you collected against what you remitted. Investigate any difference. Sales tax reconciliations are the single most-flagged area in state audits.
- Estimate the tax position. Pull a P&L for the year. Compare to last year. Note major variances. Send to the tax CPA with context. This is the handoff that determines how smooth tax season is.
- Backup and lock. Run a backup using QBO’s backup feature. Set the year-end closing date. Lock it with a password that you will remember (we keep a closing-date password log in our practice management tool).
One Advanced-specific year-end task: review your custom fields and custom reports. Things that made sense in January often do not make sense by December. Retire the custom fields that nobody used. Update the custom reports that have grown stale. Document the ones that survive so the next bookkeeper knows what they were for. We do this every December and it keeps the file from accreting unused complexity.
Another Advanced-specific item: revenue recognition. If you adopted the revenue recognition feature mid-year, your year-end RevRec needs to be reconciled against your contract base and against the income statement. We cover this in detail in our revenue recognition guide.
The single biggest year-end mistake we see: not setting the closing date. Books reopen during tax season because the CPA needs to ask a question, and then someone edits a January-of-prior-year transaction without realizing it. Set the closing date with a password and only the controller or CPA has the password. The IRS recordkeeping rules at irs.gov/businesses/small-businesses-self-employed/recordkeeping assume the books reflect the period they say they reflect — if a January-of-last-year transaction can be edited today, that assumption breaks.
Owner/CFO Quarterly Review Routine
The quarterly review is the one routine that should not be delegated. It is the moment where the owner or CFO actually looks at the numbers and decides whether the plan is working. Done well, it takes 90 minutes a quarter. Done badly, it does not happen and the owner finds out the business has been bleeding cash six months later.
The 90-minute quarterly review agenda.
- Cash position and runway (10 minutes). Open the balance sheet. Look at the cash balance. Look at the next 13 weeks of expected cash flow. If runway is less than 12 months, that is the meeting.
- P&L vs. budget by department or class (20 minutes). Pull the P&L by class. Compare actual to budget. Identify the three biggest variances. Discuss the cause of each. This is where Advanced’s class tracking and custom reporting actually earn their price — in Plus, you can do this, but it is slower and less detailed.
- Gross margin trend (10 minutes). Pull a quarterly gross margin trend chart. If margin is moving the wrong way, that is the second item on the meeting agenda.
- Customer concentration and AR health (10 minutes). What % of revenue comes from the top three customers? What is the AR aging look like for those customers? If concentration is over 30% or aging is creeping, that is a discussion.
- Tax position (15 minutes). What is the rough tax bill at current run-rate? Are estimated payments tracking? Is there a need for a tax-strategy intervention before year-end? This is also the moment to flag any tax-credit opportunities (R&D, work opportunity, etc.) that need documentation before the year closes.
- Capital plan (10 minutes). Any planned big purchases? Any debt service coming due? Any planned equity raises or distributions? Does the cash position support them?
- Decisions and next-quarter actions (15 minutes). What are we going to do differently next quarter? Pricing? Hiring? Spending cuts? Investment? Write it down. Review at the start of next quarter’s meeting.
The discipline that makes this work is consistency. Same week of the quarter, same agenda, same reports. The owner who skips the quarterly review for two quarters in a row is the owner who calls us in a panic six months later. We do a version of this every quarter for our business management clients, and it is genuinely the highest-use hour we spend with them all year.
For owners who hate reports, we sometimes flip the format. Instead of pulling reports and walking through them, we ask three questions and look up the answers as we go: Are we making money? Are we collecting it? Are we spending it on the right things? Those three questions cover 90% of what a quarterly review is actually for. The reports are how you find the answers, not the point of the meeting.
One last point worth saying. The quarterly review is not optional just because the business is doing well. We see this with growing companies all the time — Revenue is up, cash looks fine, owner skips the review. Six months later, AR has ballooned, gross margin has slipped because the new revenue is lower-quality, and the tax bill is twice what was expected. The review is what catches all three before they compound. Skip it at your peril.
Related Services from The Reed Corporation
Helpful Guides You Might Also Like
Sources & References
Frequently Asked Questions
What does a typical week look like for a bookkeeper running QBO Advanced?
A typical week for a bookkeeper running QBO Advanced has a strong rhythm if the file is set up well, and looks like chaos if it isn’t. The shape we recommend, and the shape we run for our own client engagements, breaks the week into five distinct days with different focus.
Monday: catch up on the weekend. Monday is the heaviest day of the week, especially for files where the business operates over the weekend (restaurants, retail, service businesses). The morning starts with a longer-than-normal daily routine — the bank feeds have caught three days of transactions, the inbox has a backlog of vendor invoices, the AR queue has a few customers who tried to pay over the weekend and want confirmation. Plan on 90 minutes Monday morning instead of the usual 30. Also, Monday is the day to review any internal alerts that fired over the weekend — large deposit alerts, bill approval requests that went out Friday and got acted on Saturday or Sunday, anything customers emailed in. The shape of Monday is: catch up, triage, set the week’s priorities.
Tuesday and Wednesday: production days. These are the heads-down categorization days. Bank feeds are caught up, AR is current, AP is being processed. Tuesday is usually customer invoicing day — pull the list of work completed in the prior week, generate invoices, send them. Wednesday is usually vendor bill day — process the invoices that came in by email or paper, enter them into QBO or push them through Bill or Ramp, route the ones above the approval threshold to the right approver via workflows. Both days also include the daily routine: 30 minutes of bank feed, Tasks queue, AR and AP checks. Total time Tuesday and Wednesday is usually 3 to 5 hours each.
Thursday: close-the-loop day. Thursday is the day we use to clean up anything that fell through the cracks Monday through Wednesday. Did all the customer invoices go out? Did all the vendor bills get entered? Are there any open questions waiting on a response? Anything in the Tasks queue that has been sitting too long? Thursday is also a good day for batch reclassify on anything systematic that we noticed earlier in the week. Plan 2 to 3 hours.
Friday: weekly review and prep for next week. Friday afternoon is the weekly review checklist from the section above. Pull the AR and AP aging detail. Audit uncategorized expenses. Spot-check workflows. Run any class or location consistency reports. Write down the findings in the running issues log. Friday is also when the bookkeeper preps anything the controller needs for their weekend or Monday morning review — a weekly P&L snapshot, a cash position note, anything flagged for follow-up. Total time Friday is usually 2 to 3 hours.
Total weekly time investment. For a clean Advanced file at $1M to $3M in annual revenue with normal transaction volume (200 to 500 transactions per month), the full week takes 12 to 18 hours. For a $3M to $10M file with 500 to 1500 transactions, 18 to 28 hours. For $10M+ with 1500+ transactions, the bookkeeper is approaching full-time and you should be thinking about adding an AP clerk or AR clerk to specialize.
What changes when the file is not clean. The numbers above assume bank-feed rules are tight, custom fields are stable, workflows are firing reliably, and the chart of accounts is appropriate to the business. If any of those are broken, weekly time goes up by 30 to 70%. The single biggest time-eater is bad bank-feed rules — if the bookkeeper is hand-categorizing 80% of transactions instead of 20%, the daily routine doubles in length.
What changes when the file is multi-entity. If you run multiple companies in QBO Advanced (each its own file, since Advanced does not do true multi-entity in one file), expect the time per entity to be 60 to 80% of the per-entity time of a standalone file — some habits and templates carry over. So three small entities in three Advanced files is closer to 24 hours a week than 36.
The weekly rhythm changes around month-end. The last week of the month is heavier on every day. Bank reconciliation gets serious instead of casual. Accrual entries need to be planned. The bookkeeper needs to coordinate with the controller on what is closing and when. Plan 50% more time the week of month-end than a normal week.
The non-time costs of poor weekly rhythm. The cost of skipping the weekly rhythm is not just time. The bigger cost is that the books get progressively less reliable. Decisions get made on stale numbers. The CFO is looking at a P&L that is missing two weeks of expenses. The owner thinks cash is fine because AR is supposedly current, but actually three of the largest customers are 60 days late. The weekly rhythm is the discipline that keeps this from happening. Skipping it is the most expensive habit in bookkeeping.
How we structure it on our engagements. For clients on our bookkeeping or client accounting services engagements, we follow the rhythm above with daily and weekly notes saved into our practice management system so any team member can pick up if the primary bookkeeper is out. We also share a weekly status email to the client every Friday afternoon with the key issues from the weekly review. The email forces the discipline and makes the work visible to the client so the relationship stays tight.
The one habit that matters most. If you only do one thing differently, do the daily 30-minute morning routine. Everything else flows from that. The bookkeepers who skip the morning routine are the ones who end up working until 7 PM on Friday trying to catch up. The bookkeepers who do the morning routine are home by 5 PM with clean books. That gap is the difference between a sustainable engagement and a burnout engagement.
What a Monday catastrophe looks like (and how to prevent it). The classic high-stress Monday at a small finance team starts with the bookkeeper opening QBO at 9 AM and finding 180 items in the bank feed For Review list, six unread customer emails about invoice questions, four bills that were due Friday and did not get paid, and a Slack message from the CFO asking why the AR aging looks worse than it did last week. None of those problems are caused by the weekend. They are caused by the prior week’s daily routine being skipped two or three times. The prevention is upstream: keep the daily routine running last week, and Monday is a 90-minute morning instead of a six-hour fire drill. We have rebuilt our Monday-morning recovery process for so many new clients that we now treat the first 90 days of every engagement as the time it takes to drop the recovery routine and lock in the prevention routine.
The role of the controller in setting the weekly rhythm. Bookkeepers default to whatever rhythm the controller (or in our case, the engagement lead) sets. If the controller checks in every Friday, the bookkeeper runs a tight Friday review. If the controller only checks in at month-end, the bookkeeper’s discipline slips throughout the month and tightens up in the last three days. The single most effective lever for a clean weekly rhythm is a controller who shows up at the same time every week and asks the same questions every week. Predictability creates discipline. Surprise inspections do not.
How is the monthly close different in QBO Advanced vs. QBO Plus?
The short answer is that an Advanced close is meaningfully faster and produces better management reporting, but the steps are mostly the same. The difference is in four specific features that change the use of the close steps: batch reclassify, custom fields and reports, workflow-based approvals, and revenue recognition. We will walk through each of those, then talk about the time and quality delta.
Batch reclassify. In Plus, if you find that 40 transactions hit the wrong account during the month, you have to fix them one at a time. Open transaction, change account, save, next. At 30 seconds a transaction, that is 20 minutes of clicking. In Advanced, the Reclassify Transactions tool lets you select all 40 at once and reclassify them in a single action. Time goes from 20 minutes to about 90 seconds. For a clean monthly close, this might save 30 minutes. For a messy close where the bookkeeper has been letting categorization errors compound, it can save 4 to 6 hours. The cleaner habit is to use batch reclassify weekly, not just at month-end, but it lives in the close-cycle toolkit.
Custom fields and reports. Plus lets you build reports off the standard transaction fields. Advanced lets you tag transactions with custom fields and then build reports that aggregate by those fields. The practical difference: in Advanced, you can tag every invoice with a project code, a salesperson, a referral source, or anything else, and then build a custom P&L that segments by those tags. In Plus, you can do this only with the standard Class and Location fields, which are limited. For a management reporting package that the CFO actually finds useful, this is a major upgrade. The close gets the same data, but the reporting from that data is dramatically more flexible.
Workflow-based approvals. In Plus, journal entry approval (if you run it) happens via email. Bookkeeper posts the JE, emails the controller, controller replies with approval, bookkeeper marks it as approved in some external log. In Advanced, you set up a workflow: trigger on JE created, condition on amount, action route to controller for approval. The approval lives in QBO, gets logged in the audit log, and shows up with the workflow name attached. For a close cycle where you might post 30 to 80 JEs, the time saved is real, but the bigger benefit is the audit trail. We cover the mechanics in our workflows guide.
Revenue recognition. If your business has recurring revenue, multi-month contracts, or any kind of deferred revenue, the monthly close has to include a revenue recognition calculation. In Plus, you maintain this in a separate spreadsheet, calculate the recognition entry each month, and post it as a JE. In Advanced, the Revenue Recognition feature automates the schedule, posts the entry, and reconciles. For a SaaS or service business with 50+ active contracts, this can save 4 to 8 hours per month. For a transactional business that recognizes revenue at point of sale, it does not matter. We have a separate guide on this at qbo-advanced-revenue-recognition.
The time delta in practice. For a $3M revenue company with normal complexity, a Plus close takes 6 to 8 business days from period end to fully closed and reported. An Advanced close takes 3 to 5 business days. The delta is mostly in the reporting phase and in the reclassify-related cleanup. For a $10M revenue company with class tracking, project tracking, and deferred revenue, the delta is bigger — Plus 10 to 14 days, Advanced 6 to 8 days. Above $20M, most businesses outgrow both and move to a mid-market system like NetSuite or Sage Intacct, but a well-tuned Advanced file can carry a $25M business if the bookkeeping discipline is there.
The quality delta. Time is only part of the story. The bigger benefit of the Advanced close is reporting quality. The management package that comes out of an Advanced close has class-level P&L, project-level margin, customer-level profitability, and any other dimension you have set up custom fields for. The Plus close produces a standard P&L and balance sheet, full stop. For owners who want to actually understand where their business is making money, this is a real upgrade.
The audit trail delta. Advanced’s audit log is the same as Plus’s audit log for transaction-level changes, but workflow-routed approvals add an extra layer. Every JE that went through approval shows the workflow that routed it, the user who approved it, and the timestamp. For SOX-adjacent or SOC 2 environments, this matters. For most small businesses, it does not, but it is good practice anyway.
What does not change between Plus and Advanced. The core close steps are identical: bank reconciliation, AR review, AP review, accruals, depreciation, period close. The features above accelerate certain steps and add reporting depth, but they do not change the underlying close discipline. A team that runs a bad Plus close will run a bad Advanced close. Advanced does not fix process. It accelerates a working process.
The price math. Advanced is roughly $100 to $130 a month more than Plus at retail. For a small business with $1M to $5M in revenue and a part-time bookkeeper, the Advanced features save 4 to 8 hours per month. At $35 to $60 an hour for a bookkeeper, that is $140 to $480 saved per month. The math works almost always — we have only seen one or two clients where Plus was genuinely the right choice on cost grounds, and both of those clients were under $1M in revenue with very simple operations.
The closing-date discipline applies equally. Both Plus and Advanced let you set a closing date with a password. Both will warn you when a user tries to edit a closed transaction. Both will let you override if you have admin permissions. The discipline of setting the closing date every month after the close is locked is the same in both tiers, and it is the single highest-use habit in any QBO file. We have a dedicated paragraph on this in our pillar QBO Advanced guide.
What we recommend. If you are on Plus and your close consistently runs longer than a week, upgrade to Advanced. If you have multi-month revenue contracts, upgrade to Advanced. If you have multiple departments or business lines you want to report on separately, upgrade to Advanced. If you are running a $1M business on a single P&L with no class tracking and a clean close, Plus is fine. If you are doing tax-only bookkeeping with no real management reporting, Plus is fine. Above those simple cases, Advanced is the right tool.
What metrics should I review in QBO Advanced weekly vs. monthly vs. quarterly?
The right cadence for each metric depends on how fast the metric can change and how expensive a mistake on that metric would be. Some things you should be looking at every week because they can swing fast and a missed swing is expensive. Other things you should look at once a quarter because the noise on shorter time frames is more misleading than the signal. Here is the split we use with clients.
Weekly metrics — the operating dashboard.
- Cash balance. Look once a week, plus any day you are about to make a major payment. Cash can move fast and cash going wrong is the single most expensive mistake a small business can make.
- AR aging by bucket (current, 30, 60, 90+). What is moving the wrong direction. Anything new in the 90+ bucket. AR aging is a leading indicator of cash problems — you see AR slip 30 days before the cash crunch.
- AP coming due in the next 14 days. Are there any cash mismatches? Are there bills that need approval before they can pay? Are there any duplicate bills that should be canceled?
- Unreconciled bank feed items older than 7 days. Should be near zero. If it’s not, the bookkeeping discipline is slipping.
- Open Tasks in QBO. How many are waiting on you. How many are waiting on someone else. Anything stuck.
- Workflow firing status. Are the routine workflows actually firing? Spot-check one or two each week.
Most of these can be glanced at in 10 minutes if you have a saved dashboard. The point is not deep analysis — it is catching anything that has changed in the last seven days that you should know about.
Monthly metrics — the management report.
- P&L vs. budget, total and by class or department. Where are we hitting plan? Where are we missing? Why? This is the centerpiece of the monthly review.
- Gross margin %. Compared to last month and to the same month last year. Gross margin is the single best lagging indicator of business health.
- Operating cash flow. Net income plus or minus working capital changes. This is the cleanest signal of whether the business is actually generating cash.
- AR turnover (DSO). How fast are you collecting? Is it getting better or worse? If DSO is slipping by 3 to 5 days a month, you have a collections problem that will become a cash problem in a quarter.
- AP turnover (DPO). How fast are you paying? If you are paying significantly faster than your terms, you are giving away free working capital. If you are paying significantly slower than your terms, you are damaging vendor relationships.
- Customer concentration. What % of revenue came from the top 5 customers this month? If it is over 50%, that is a discussion item.
- Employee labor as % of revenue. Especially in service businesses. Drift on this metric is invisible week to week and very visible quarter to quarter.
- Inventory turnover. If you carry inventory. Tracks how efficiently you are converting inventory to revenue.
The monthly review should be presented as a written narrative on top of the numbers, not just the numbers themselves. The narrative explains what changed and why. We typically write a one-page memo to the client every month that walks through the numbers and points to the three things that matter most.
Quarterly metrics — the strategic review.
- Full management reporting package. P&L, balance sheet, cash flow, KPIs. By class. By project. By customer if relevant.
- Tax position vs. estimated payments. Are estimates tracking the actual tax liability? Is there a need for an extra payment or for a strategy change before year-end?
- Revenue retention or customer cohort analysis. For businesses with recurring revenue. What % of last-quarter revenue is still on the books? What is the gross and net retention?
- Capital plan. Planned big purchases, debt service, equity events. Does cash support the plan?
- 13-week cash forecast (forward looking). A real forecast, not a guess. Built off the AR and AP aging plus expected new sales and expected new bills.
- Customer profitability ranking. Which customers actually make money for you. Often surprising. Sometimes uncomfortable.
- Operating expense per employee. Drift on this metric is invisible quarter to quarter and very visible year to year, but every quarter is the right cadence to set a baseline.
The quarterly review is also where we ask the bigger questions that do not fit on a metric: Is the business model still working? Are the right people in the right seats? Is the pricing right? Are we serving the right customers? Those are strategic questions, but they show up in the metrics if you know where to look.
Year-end metrics. Year-end is just the quarterly review with one extra page: comparison to the full prior year, full-year tax position, full-year owner compensation, and any items that need attention before the books close. Most of what should be in the year-end review has already been seen in the quarterly reviews.
Why this cadence works. Weekly metrics are operational — they tell you if anything is breaking right now. Monthly metrics are tactical — they tell you if the plan is working. Quarterly metrics are strategic — they tell you if the plan is right. Looking at strategic metrics weekly is noise. Looking at operational metrics quarterly is too late. The cadence matters as much as the metrics themselves.
What to skip. A surprising amount of standard accounting reporting is not worth your time at the small-business level. Detailed budget variance reports for accounts that consistently land within 5% of plan. AR aging detail for customers who always pay on time. Subledger reports that do not connect to a decision. If a metric never changes the decision you make, stop looking at it. Free up the attention for the metrics that do change decisions.
Where Advanced helps. The Advanced custom reports feature is what makes this cadence practical. You build the weekly dashboard once. You build the monthly management package once. You build the quarterly review once. Then you run the same reports each cycle and the consistency is what produces the insight. Plus can do most of this, but it is more manual and more brittle. We have built the standard cadence above into a set of QBO Advanced custom report templates that we deploy on every client engagement. If you want to see how we structure it, talk to us about our business management service.
How do I keep QBO Advanced clean when transaction volume gets high (1000+/month)?
At 1000+ transactions a month, the habits that worked fine at 200 transactions a month start to break. Hand-categorization stops scaling. Manual reconciliations turn into multi-hour exercises. Bank-feed errors compound faster than the bookkeeper can catch them. The file gets messy in proportion to volume unless you actively engineer against the mess.
We have run Advanced files at volumes from 200 to 8000 transactions a month. Here is what actually works as volume scales.
Layer 1: Bank-feed rules are non-negotiable. The first and biggest use point is bank-feed rule coverage. At 1000+ transactions a month, you should have rules covering 70 to 85% of the bank feed. The bookkeeper is only hand-categorizing the long tail. To get there: every vendor you see more than twice in a month gets a rule. Every customer who pays you more than twice in a month gets a payment rule. Every recurring expense pattern (subscriptions, payroll, taxes) gets a rule. The first month of a high-volume client engagement is mostly rule-building. After that, the rules pay for themselves every day.
Layer 2: Naming conventions on vendors and customers. At high volume, you will have multiple records for the same vendor unless you enforce naming. Amazon Web Services, AWS, Amazon Web Services Inc., aws.amazon.com — QBO will happily create four separate vendor records if you let it. The fix is a naming standard that the team follows consistently and a periodic cleanup pass. We use the legal entity name with no suffixes (so “Amazon Web Services,”. Not “Amazon Web Services Inc.”). We do a vendor cleanup pass once a quarter to merge duplicates. The same applies to customers.
Layer 3: Class and location consistency. If you are using class or location tracking, every transaction needs a class or location for the reporting to work. At high volume, missing classes pile up fast. The fix is two-part: bank-feed rules that pre-fill the class for known vendors, and a weekly missing-class report that catches the exceptions. We run a saved custom report every Friday that lists every transaction in the last 30 days missing a class. The bookkeeper clears it. Without this report, the missing classes accumulate and the class-level P&L becomes unreliable.
Layer 4: Daily 30-minute routine, religious adherence. The daily routine matters more at high volume than at low volume because the cost of falling behind compounds. Miss the daily routine for three days at 200 transactions a month and you have 60 transactions to clean up. Miss it for three days at 2000 transactions a month and you have 600. We have seen high-volume bookkeepers fall behind for a single week and need 25 to 40 hours to catch up. The daily routine is the prevention.
Layer 5: Stand up an AP tool. At 1000+ bills a month (separate from total transactions), processing bills inside QBO becomes the bottleneck on the bookkeeper’s day. Tools like Bill, Ramp and Tipalti pre-process the bills, extract the data, route for approval, and sync the result into QBO as a clean bill record. The bookkeeper is no longer typing vendor names. They are reviewing what the tool extracted and approving. For our clients above 500 bills a month, the AP tool typically pays for itself in saved bookkeeper hours within two months.
Layer 6: Use the audit log as a quality control. At high volume, mistakes hide. The fix is a weekly audit-log review where the controller looks at the bookkeeper’s activity for anything unusual. Mass edits to a class, large JEs that did not go through approval, transactions deleted in batch. None of this is a sign of dishonesty, but it is a sign of process drift. The controller catches the drift in a 15-minute weekly review and corrects it before it accumulates.
Layer 7: Reconciliation discipline. At low volume, you can reconcile at month-end and find any problems quickly. At high volume, you cannot. Reconcile every week, ideally on Friday. The goal is not to finish — the goal is to know how close you are. By the time month-end arrives, the reconciliation is 90% done and the last 10% is the items that need real investigation.
Layer 8: Stop using QBO for things it is not good at. At high volume, QBO is fine as a general ledger and as a reporting tool. It is not great as an inventory system, an order management system, a CRM, or a payroll engine. The right architecture at high volume is to keep those functions in purpose-built tools and feed the summary results into QBO. Trying to do everything in QBO at high volume is how files break.
Layer 9: Reclassify weekly, not monthly. The Advanced reclassify feature is the highest-use cleanup tool in the product. At high volume, run it every Friday on anything you noticed earlier in the week. Do not wait for month-end. By month-end, the cleanup is bigger and harder. Weekly cleanup keeps it small.
Layer 10: Volume-based staffing. Past about 1500 to 2000 transactions a month, one bookkeeper is no longer enough even with good process. We see clients try to push past this with one bookkeeper working 50-hour weeks, and the file always degrades. The right answer is to split the work — one bookkeeper on AR, another on AP, a controller on review — before the burnout cycle starts.
The compounding effect of these layers. Each layer above contributes maybe 10 to 20% to overall file cleanliness. Layered together, they compound. A high-volume file with all 10 layers in place feels just as clean as a low-volume file. A high-volume file missing 3 or 4 of these layers feels like a constant fire drill. We have done the cleanup work on enough chaotic high-volume files to know that the issue is almost never the volume itself. It is the missing layers.
Where Advanced specifically helps. Three Advanced features are most useful at high volume. Batch reclassify, for fast cleanup. Custom roles, so you can split work across multiple bookkeepers without giving everyone admin. And workflows, for routing approvals automatically so the controller is not the bottleneck on every JE or large bill. Plus has none of those, which is why we recommend Advanced for any business above 500 transactions a month. We cover custom roles in detail in our custom roles guide.
Outsourcing as a layer. Some clients reach the volume threshold and decide to outsource the bookkeeping rather than scaling the internal team. This is often the right call — a CAS firm running multiple files has economies of scale that an internal solo bookkeeper does not. Our CAS engagement handles high-volume files for clients who do not want to staff finance internally.
What is the right cadence for inviting outside reviewers (CPA, auditor) into a QBO Advanced file?
The right cadence depends on what the outside reviewer is going to do. A tax-only CPA does not need the same access or frequency as a quarterly review CPA, who does not need the same access or frequency as an external auditor. Getting the cadence wrong is mildly expensive on the low end (you pay the CPA to spend more time cleaning up because they had bad access) and very expensive on the high end (an auditor with the wrong access creates a scope problem in the audit). Here is the breakdown we use.
Tax preparation CPA. If the CPA is only doing the annual tax return, invite them once a year, in early January, with a target to deliver the books by January 31. The right access level is Accountant role — this gives them the ability to view all the books, post adjusting entries, and run any reports they need without you having to grant individual permissions. They should be able to set their own closing date for the prior year so that they can lock things down after they are done. Revoke their access after the return is filed if they are not doing any other work for you.
The Reed Corporation runs tax preparation for many small-business clients and we standardize this cadence. We get accountant access in early January, we work through the file in mid-to-late January, we file the return in February or March (or earlier if state deadlines require it), and we maintain accountant access for the year so that we can answer questions and post any adjusting entries that show up after filing. For clients on our tax preparation service alone, the access is light-touch outside of the January-March window.
Quarterly tax planning CPA. If the CPA is doing quarterly tax planning — reviewing the books each quarter to estimate the tax position and make any planning adjustments — invite them once a quarter, ideally two weeks after quarter-end so the books are closed. The right access level is again Accountant. They will want to see the actuals against budget, run a year-to-date P&L, and probably post one or two adjusting entries for things like depreciation or accruals that did not happen in the monthly close. Plan on the CPA spending 4 to 8 hours per quarter on the review for a typical small business.
Monthly close review CPA. If you have a CPA reviewing the monthly close, give them standing accountant-level access. They should be in the file every month, reviewing the close, posting any necessary adjustments, and signing off before the period locks. This is the highest-touch CPA relationship and requires the most coordination. It is also the most valuable for businesses that want a strong second pair of eyes on the books. For our business management clients, this is essentially the engagement — we run the full monthly close as the CPA.
External auditor. Auditors are different. They are not adjusting the books. They are testing them. The right access level is view-only or auditor-specific. QBO does not have a built-in auditor role, but you can build a custom role in Advanced that gives view-only access to all transactions and reports without the ability to edit anything. The auditor should also be able to export everything they need without your help — if they have to ask the bookkeeper to pull every report, the audit takes twice as long and costs twice as much. Invite the auditor two to four weeks before fieldwork starts. Revoke access when the audit is complete and the final report is delivered.
One key rule: an auditor should never have edit access to the books they are auditing. That is a fundamental independence issue. We have seen clients accidentally give auditors full access and it creates real problems with the auditor’s ability to sign off without scope qualifications.
Bookkeeping reviewer or fractional CFO. If you have a fractional CFO or external reviewer who is checking the bookkeeper’s work but not doing the bookkeeping or the tax work, give them a custom role with read access to everything plus the ability to leave comments or set Tasks. They do not need to be able to post transactions, and giving them that ability blurs the role boundary in a way that always ends up causing problems. Invite them as needed, typically on a weekly or biweekly cadence.
Lender or investor. If a lender or investor wants direct access to the books (rare but happens), grant view-only access via a custom role and time-box it. They should see the same management reports the owner sees, nothing more, and the access should expire when the diligence period or the loan covenant review is complete.
The custom role play. Advanced’s custom role feature is what makes most of the above practical. In Plus, your access controls are coarse — full admin or limited bookkeeper or sales rep. In Advanced, you can build a role with exactly the permissions a specific outside reviewer needs. Auditor view-only with full report access. Fractional CFO read-plus-comments. Lender review with P&L and balance sheet only. We cover the mechanics of custom roles in detail in our custom roles guide.
Cadence summary by role. Tax-only CPA: once a year, January to filing date. Quarterly planning CPA: four times a year, two weeks after quarter-end. Monthly close CPA: standing access, in the file every month. Auditor: standing access for the audit window, view-only via custom role. Fractional CFO or reviewer: as needed, custom read-plus-comment role. Lender or investor: time-boxed, view-only.
Cleanup and access hygiene. Every quarter, audit your user list in QBO. Anyone who should not have access anymore gets removed. Anyone whose role does not match what they actually need today gets adjusted. This sounds tedious but it is a major control gap at most small businesses — old CPAs, former employees, and one-off consultants accumulate in the user list and represent a quiet security problem. Five minutes a quarter prevents the problem.
Documentation discipline. Keep a log of every outside reviewer who has been in the file, when they had access, what role they had, and when access was revoked. This is useful for compliance, useful for audits, and useful when an issue surfaces three years later and you need to know who was in the file when the issue was created. We maintain this log in our practice management tool for every client engagement — it is one of the documents auditors and regulators ask for most often.
The wrong-cadence costs. Inviting outside reviewers too rarely costs you in the form of stale data, missed planning opportunities, and surprise tax bills. Inviting them too often costs you in real billable hours and in distracting the bookkeeper from production work. The right cadence sits in the middle — just often enough that the reviewer is current, not so often that they are reading every transaction. The cadences above are our defaults. Adjust as needed for the specifics of your business and your reviewer relationship.