8.1 Books Review / Month-End Review Workflow

Books Review / Month-End Review Workflow

Quick Answer: Books Review (formerly known as Month-End Review) is a specialized workflow command center inside QuickBooks Online Accountant (QBOA) designed to guide bookkeepers and accounting professionals through a rigorous, repeatable period-end closing process. Located on the left navigation bar within any client company file, Books Review organizes month-end procedures into four structured phases: Transaction Review (diagnosing uncategorized items, missing payees, and unapplied payments), Account Reconciliation (monitoring bank and credit card reconciliation statuses and beginning balance discrepancies), Final Review (auditing balance sheet and profit & loss balances for abnormal balances like negative inventory or negative bank registers), and Wrap-up (setting closing date locks and preparing management report packages). Progress is tracked dynamically using status indicators (To Do, Waiting, Done) and customizable firm-level checklist items.

---

Overview & Architecture of Books Review in QBOA

Maintaining data integrity across dozens of client files requires structured standardization. Prior to the introduction of Books Review, accounting professionals relied on external spreadsheets, paper checklists, or memory to ensure that all accounts were reconciled and all unclassified transactions resolved before generating period-end financials.

┌──────────────────────────────────────────────────────────────────────────────────┐
│                     BOOKS REVIEW COMMAND CENTER (QBOA)                           │
├──────────────────┬──────────────────────┬───────────────────┬────────────────────┤
│ 1. Transaction   │ 2. Account           │ 3. Final Review   │ 4. Wrap-up         │
│    Review        │    Reconciliation    │                   │                    │
├──────────────────┼──────────────────────┼───────────────────┼────────────────────┤
│ • Uncategorized  │ • Bank Accounts      │ • Unusual Balances│ • Close the Books  │
│   Transactions   │ • Credit Cards       │ • Negative Assets │ • Report Packets   │
│ • Missing Payees │ • Unreconciled Days  │ • Negative Liab.  │ • Client Updates   │
│ • Unapplied Pymts│ • Discrepancy Alerts │ • Period Variance │ • Archive Work     │
│ • Ask Client     │ • Auto-Detection     │ • Retained Earn.  │                    │
└──────────────────┴──────────────────────┴───────────────────┴────────────────────┘

Books Review embeds an interactive, auditable closing methodology directly into the QuickBooks Online Accountant platform. It operates on a monthly cadence (selectable by calendar month and year via a header dropdown) and automatically aggregates data from the client's general ledger into actionable diagnostic categories.

Accessing Books Review:

• Log into QuickBooks Online Accountant.
• Open a client company file from the Client List.
• In the left navigation menu, navigate to Bookkeeping > Books Review (or Books Review directly in accountant navigation layouts).

---

Phase 1: Transaction Review

The Transaction Review phase serves as the first line of defense in the month-end close. Its primary objective is to clean up data entry omissions, ambiguous postings, and incomplete transaction records before any reconciliations or financial reviews take place.

1. Uncategorized Transactions

QuickBooks Online automatically scans the general ledger for transactions posted to default holding accounts that lack proper business classification:

• Uncategorized Expense: Outflows created when bank feed rules or end-users post expenses without choosing an expense account.
• Uncategorized Income: Inflows deposited without identifying the revenue stream or sales item.
• Uncategorized Asset: Balance sheet debit entries resulting from ambiguous purchases or initial opening balance entries.

Clicking on any category in Transaction Review opens a slide-out drawer or inline editing table, allowing the ProAdvisor to assign the correct Chart of Accounts category, class, and location directly without opening each transaction individually.

2. Transactions Without Payees

A common data hygiene defect in small business bookkeeping is recording checks, expenses, or debit card charges without populating the Payee (Vendor or Customer) field.

• Tax Compliance Risk: Unassigned payees break Form 1099-NEC and 1099-MISC tracking. Even if an expense is coded to an eligible 1099 account (e.g., Subcontractor Labor), QBO cannot generate a 1099 without an identified vendor profile.
• Auditability: Transactions without payees obscure vendor history and make expense searching and historical vendor reporting impossible.
• Diagnostic: Transaction Review aggregates all payee-less transactions into a dedicated review table where bookkeepers can assign vendor profiles in bulk.

3. Unapplied Customer Payments and Bill Payments

When client users receive customer payments or write vendor bill payment checks without explicitly linking them to open invoices or bills, unapplied payments occur:

• Unapplied Customer Payments: Cash is received and credited to Accounts Receivable, but because it is not linked to an open invoice, both the invoice and payment remain open on the A/R Aging Detail report, artificially inflating gross customer balances.
• Unapplied Bill Payments: A bill payment check or debit is recorded against Accounts Payable without being matched to an existing vendor bill, distorting the A/P Aging Detail report.
• Resolution: ProAdvisors review these items directly from the Transaction Review screen and apply payments to their matching open source documents.

4. Personal Expenses Charged to Business Accounts

When business owners use corporate debit or credit cards for non-business personal purchases, these transactions must be identified and segregated. Rather than leaving them in operational expense accounts, the ProAdvisor reclassifies them to equity accounts (e.g., Owner's Draws, Partner Distributions, or Shareholder Distributions), preventing illegitimate tax deductions.

5. Client Collaboration: The "Ask Client" Feature

When a ProAdvisor encounters ambiguous transactions that require client clarification, Books Review provides an integrated communication channel:

• In the Transaction Review queue, clicking Ask client on any transaction opens a query modal.
• The ProAdvisor writes a question (e.g., "Please explain the business purpose of the $1,250 check #1042 written on Sept 3, or attach a receipt.").
• The request automatically posts to the client's My Accountant tab inside their standard QuickBooks Online company file, and an automated email notification is sent.
• The client responds and attaches receipts or documents directly through the secure portal.
• Once answered, the status in Books Review automatically updates to Client Answered, allowing the ProAdvisor to finalize the transaction classification without leaving the screen.

---

Phase 2: Account Reconciliation

Once raw transaction records are cleaned and categorized, the ProAdvisor progresses to Account Reconciliation. Reconciling all balance sheet cash and debt accounts is the single most critical procedural control in accounting.

Operational Capabilities of the Reconciliation Phase:

1. Comprehensive Account Coverage: Auto-surfaces every bank, savings, money market, credit card, and line-of-credit account, preventing bookkeepers from inadvertently skipping auxiliary accounts (e.g., secondary PayPal or petty cash registers).
2. Direct Workspace Navigation: Clicking Reconcile on any account card launches the reconciliation module directly with the target account pre-selected, eliminating manual menu searches.
3. Historical Reconciliation Auditing: ProAdvisors can immediately view the date of the last successful reconciliation, ensuring that multi-month backlogs are addressed sequentially (earliest unreconciled month to latest).

---

Phase 3: Final Review

The Final Review phase shifts focus from transaction mechanics to high-level general ledger financial health. In this phase, the ProAdvisor scrutinizes the Balance Sheet and Profit and Loss statements for structural anomalies, abnormal balances, and timing distortions.

1. Diagnosing Abnormal / Negative Account Balances

Under standard accounting principles, accounts have natural debit or credit balances. When an account exhibits a balance opposite its normal orientation, it signals a systemic bookkeeping error:

┌───────────────────────────┬─────────────────────┬────────────────────────────────────────────────────────┐
│ Account Type              │ Normal Balance      │ Cause of Abnormal (Negative) Balance                   │
├───────────────────────────┼─────────────────────┼────────────────────────────────────────────────────────┤
│ Cash / Bank Accounts      │ Debit (Asset)       │ • Overdrafts at bank                                   │
│                           │                     │ • Recording checks without sufficient ledger cash      │
│                           │                     │ • Duplicate expense recording via feeds                │
├───────────────────────────┼─────────────────────┼────────────────────────────────────────────────────────┤
│ Inventory Asset           │ Debit (Asset)       │ • Recording sales invoices before purchase bills       │
│                           │                     │ • Backdated sales transactions depleting FIFO pool     │
│                           │                     │ • Inventory count adjustment entered with wrong sign   │
├───────────────────────────┼─────────────────────┼────────────────────────────────────────────────────────┤
│ Accounts Receivable       │ Debit (Asset)       │ • Customer overpayments not matched to invoices        │
│                           │                     │ • Unapplied credit memos                               │
├───────────────────────────┼─────────────────────┼────────────────────────────────────────────────────────┤
│ Accounts Payable          │ Credit (Liability)  │ • Vendor prepayments recorded without vendor bills     │
│                           │                     │ • Unapplied vendor credits                             │
├───────────────────────────┼─────────────────────┼────────────────────────────────────────────────────────┤
│ Payroll Liabilities       │ Credit (Liability)  │ • Overpaying tax agencies                              │
│                           │                     │ • Coding tax payments to liability instead of expense  │
│                           │                     │ • Paying liabilities outside QBO Payroll module        │
├───────────────────────────┼─────────────────────┼────────────────────────────────────────────────────────┤
│ Undeposited Funds         │ Debit (Asset)       │ • Creating manual deposits instead of selecting        │
│ (Payments to Deposit)     │                     │   payments from the Undeposited Funds queue            │
└───────────────────────────┴─────────────────────┴────────────────────────────────────────────────────────┘

[!CAUTION] The Negative Inventory Asset Trap: If a client sells 50 units of an inventory item before entering the vendor bill for the purchase of those units, QuickBooks Online allows the sale to post, driving the quantity on hand to -50. Because QBO calculates Cost of Goods Sold dynamically via First-In, First-Out (FIFO), it assigns an estimated or zero cost to those sales. When the vendor bill is finally entered weeks later at a different cost, QBO must post severe retroactive cost adjustments, corrupting monthly gross margin reports.

2. Comparative Period-over-Period Variance Analysis

Final Review displays side-by-side comparative views of the Balance Sheet and Profit and Loss:

• Current Month vs. Prior Month: Identifies sudden unexplained spikes or drops in recurring operating expenses (e.g., Rent Expense missing for the current month, or Utilities doubling due to duplicate posting).
• Current Year-to-Date vs. Prior Year-to-Date: Reveals structural shifts in margins, unrecorded depreciation, or misclassified capital asset purchases that were improperly expensed.
• Retained Earnings Validation: Verifies that current beginning Retained Earnings exactly equals the prior year's ending balance sheet Retained Earnings plus prior-period net income, confirming that no backdated transactions were posted to closed historical periods.

---

Phase 4: Wrap-up

The Wrap-up phase represents the formal conclusion of the monthly close. In this phase, the accounting professional secures the file, compiles deliverables, and archives communications.

1. Closing the Books (Security Lock)

To safeguard the completed work against accidental alterations by the client or their staff, the ProAdvisor accesses Close the books directly from the Wrap-up screen:

• Sets the closing date to the final day of the reviewed month (e.g., 09/30/2026).
• Establishes a closing date password to prevent unauthorized backdating or edits (detailed extensively in Section 8.3).

2. Creating Management Report Packages

The ProAdvisor compiles a standardized financial report packet for presentation to client leadership:

• Navigates to Reports > Management reports.
• Utilizes or customizes professional report templates (e.g., Company Overview or Sales Performance).
• Packages include a stylized Cover Page, Table of Contents, Executive Summary narrative, Balance Sheet, Profit and Loss, and Statement of Cash Flows.

3. Client Updates and Workpaper Sign-Off

The ProAdvisor records internal sign-offs, archives month-end notes, and delivers the finalized financial reports to client stakeholders alongside a summary of key performance indicators (KPIs).

---

Team Collaboration, Customization & Progress Tracking

Books Review is designed for multi-tiered accounting practices where bookkeeping tasks are distributed among staff, senior accountants, and partner-level reviewers.

1. Progress Status Flags

Each section and individual checklist item within Books Review features a dropdown status flag:

• To Do (Not Started): Default state indicating the task has not been initiated.
• Waiting: Selected when work is blocked by external dependencies (e.g., waiting for the client to provide the monthly loan statement, or waiting on an answer to a transaction query).
• Done: Marked when the procedure is completed and verified.

As items transition to Done, progress bars at the top of each phase card fill dynamically, providing firm managers with instant visual telemetry across all client engagements.

2. Task Assignment and Delegation

Within each phase, firm administrators can assign individual checklist items or entire phases to specific team members:

• A staff accountant may be assigned Transaction Review and Account Reconciliation.
• A senior manager or CPA is assigned Final Review and Wrap-up to execute final quality control.

3. Adding Custom Checklist Items

Because standard operating procedures vary across industries, ProAdvisors can customize the Books Review template:

• Click + Add task within any phase.
• Define the task name (e.g., "Reconcile Stripe Clearing Account", "Verify State Sales Tax Return Filing", or "Review Construction Job WIP Schedules").
• Set a due date, assign a team member, and optionally embed a hyperlink to external workpapers or SOP documentation.