A consulting firm’s weekly accounts receivable review should connect invoice status to project reality. The goal is not to read every aging row aloud. It is to identify the client approvals, scope questions, procurement steps, missed commitments, and concentrated balances that could change near-term cash.
Begin with an invoice-level aging detail report. QuickBooks documents both summary and detail aging reports; the detail report is the more useful base when different invoices for the same client have different blockers or payment expectations.
Prepare a stable source file
Export the report for one entity and one review date. Preserve invoice number, client, invoice date, due date, original amount, and open balance. QuickBooks supports exporting reports to Excel, which makes it possible to create a separate operating view without changing the books.
Reconcile the exported total before adding judgments. Keep the untouched export as the source of truth. Add review fields in separate columns so that assumptions are visible and reversible.
Add consulting-specific evidence
- Engagement or project name
- Billing model: retainer, time and materials, milestone, or fixed fee
- Client acceptance or approval status
- Purchase-order or vendor-portal requirement
- Submitted-to-payables date
- Dispute or scope question
- Executive sponsor and operational contact status
- Promised payment date
- Internal delivery owner
- Next action and due date
This context helps distinguish a normal payment cycle from a preventable blocker. An invoice may be only a few days past due but still deserve attention if the client has not accepted the milestone or the invoice never reached the required portal.
Review exceptions in a deliberate order
First, resolve data conflicts: credits, duplicate invoices, incorrect due dates, or balances that do not reconcile. Second, review broken promises and active disputes. Third, look at concentration—one client may represent a large portion of the next four weeks of expected collections. Fourth, review missing follow-up and administrative blockers. Last, scan the remaining aging detail for new material changes.
This order prevents the team from spending most of the meeting on the oldest invoice merely because it appears first in a standard report.
Separate delivery actions from collection actions
Consulting invoices often depend on people outside finance. A client may need a corrected deliverable, a signed acceptance, a purchase-order reference, or an explanation from the engagement lead. Assign the next action to the person who can remove the blocker—not automatically to the accounts receivable owner.
Use one owner, one action, and one date. “Follow up” is too vague. “Engagement lead confirms milestone acceptance with the client sponsor by Thursday” can be reviewed.
Translate the queue into a four-week range
For material invoices, assign an expected collection week and a confidence label based on current evidence. A verified payables date may support higher confidence. A missed promise, disputed scope, or unknown approval status should widen the range or move the invoice into a downside case.
Avoid representing every open invoice as cash in its contractual due-date week. The due date is an accounting fact; the collection week is a management assumption. Preserve both.
Keep project billing pipeline outside this receivables queue. The invoice-proposal boundary guide shows when approved time, expenses, milestones, and proposal documents become a posted open invoice that is eligible for collection review.
End with decisions, not status
The review is complete when every material exception has a named owner and next action, the forecast range reflects current evidence, and the team can explain what changed since last week. Archive resolved items so the decision history remains available.
AR Pulse applies this exception-first workflow to an authorized QuickBooks receivables export and returns a ranked cash-action list plus a four-week collections forecast. It does not contact clients, request QuickBooks credentials, perform bookkeeping, or promise a collections outcome.