QuickBooks Online Billable Time Reconciliation Control

August 23, 2026

Bottom line: tie every billable time entry to its invoice or explicit open status before billing goes to a client, and keep any unmatched, edited, or unapproved time as a visible exception with a named owner.

Sidebar: Preparation and approval stay separate. A VA prepares the reconciliation. An authorized reviewer decides billable treatment.

Why billable time reconciliation matters

Billable time sits at the intersection of operations and accounting. Field teams, project managers, or professional staff log hours in a time tracker, a payroll system, or directly in QuickBooks Online. Those hours need to become an invoice line that the client sees, or a documented decision not to bill. When the path from time entry to invoice is informal, three risks appear quickly. Hours are billed twice because two entries cover the same work. Hours are missed because an approved entry never moves to an invoice. Hours are billed at the wrong rate because a rate change was discussed but not documented.

For QBOAssistant clients, a virtual assistant often handles the daily plumbing: importing or reviewing time entries, linking them to customers and sub-customers, checking that service items and descriptions match the agreed scope, and preparing the queue that the owner reviews before invoicing. The assistant does not set rates, negotiate scope, or write off time unilaterally. A reconciliation control preserves that boundary. The VA shows what was entered, what is ready to bill, what is on hold pending information, and what needs the owner's eyes. The reviewer decides.

Without a control, the evidence for a client's invoice is scattered. The time entry says 4.5 hours for project setup, the invoice says 3 hours, and no note explains the difference. A month later the owner cannot answer whether the hour was reduced after a client call or simply missed. The reconciliation control prevents that drift by keeping the entry, the invoice, and the decision together in one reviewable table.

Define the population before you reconcile

Start with a report that shows all unbilled billable time as of the cutoff, plus all invoices created from time in the period. In QuickBooks Online this is typically the Unbilled Charges or Time Activities detail filtered by date, customer, and billable status, paired with the Invoices report filtered to show time linked. Export or save the population before changing anything. Record the report filters, the date range used for the pull, and the name of the preparer. If the business uses sub-customers, projects, or service items for granularity, state which level the reconciliation uses. That note prevents a later reviewer from assuming the review was at the parent customer when it was actually at the job level.

Group time entries by customer and then by service or project. The useful grouping shows one customer and one billing package beside its time lines. If the business bills in phases, the phase code or estimate line provides the grouping. Decide the grouping logic before testing so the reviewer can compare approved intent to recorded time without rebuild.

State what is excluded. For example, non-billable time, travel that is reimbursed as an expense rather than hourly, or time entered after the cutoff may be excluded from this pass but covered in a separate period review. That boundary keeps the exception list honest and prevents the perception that all time was verified when only a subset was.

Capture the evidence for each entry

For each time entry included, capture internal and external support side by side. Internal support starts in QuickBooks Online: time activity ID, employee or vendor who entered the time, customer and sub-customer, service item, date worked, hours, rate, billable or not billable status, and the current invoice link if the entry has been invoiced. Add the last modified date and the user who last edited the entry when that detail is available in history or audit notes.

External support is the source the team actually used to record the work: timesheet export, time tracker report, project management log, calendar entry, or the signed approval for a rate change. If a rate is governed by a contract, link the contract rate sheet or the approved change email. If hours are governed by a budget or estimate, link the active budget line.

Add the evidence location to the queue so the reviewer can open the source without asking for a second export. The queue is not a place to store full client contracts in broadly shared folders. Reference the controlled document location instead.

Check three links for each entry. First, the time entry hours should match the source document hours. Second, the invoice hours and amount should match the approved time entry, or the reason for a difference should be documented. Third, the customer and service item on the time entry should match the grouping the business agreed to use. Each check gets its own field so a partial match is not hidden as a full match.

Handle common exception patterns with consistency

Uninvoiced billable time past the expected billing date is the most frequent exception. An entry shows 6 hours billable from August 10 that is still unbilled on August 20. Record the entry ID, customer, hours, and the expected billing cycle the team uses. Do not invoice it silently to clear the queue. Hold it in the exception table with a question for the owner: bill now, hold per client request, amend description, or write off with documented approval.

Rate mismatch is a second pattern. The entry carries 125 per hour while the approved rate for that customer and service is 110. Look for a rate change approval, a service item update, or an entry keyed to the wrong service. If an approval exists, link it and mark the entry as rate approved. If not, raise a question that asks for the correct rate and whether the entry should be corrected before invoicing. Never change the rate on the time entry just to make it look clean.

Edited hours after initial entry appears when a time entry is changed from 5 hours to 3 hours after the first review began. Preserve both values by recording the original hours, the edited hours, the edit date, and the editor. Ask the owner whether the edit reflects a correction, a scope adjustment, or a pending client negotiation. The VA documents the edit trail. The reviewer decides the billing treatment.

Duplicate time risk shows up when a mobile app and a manual entry both capture the same site visit. The reconciliation catches it because two time entries map to the same date, customer, and description, or because two entries were moved to the same invoice line. Keep both entry IDs visible and escalate for duplicate review rather than deleting one to shorten the list.

Billable to non-billable reclassification is another pattern that needs control. An entry was first marked billable and later switched to non-billable without a reason note. Record the current status, the previous status if known, and the supporting approval. The owner can then confirm whether the change reflects an agreement to absorb the cost or a data entry correction.

Build a review packet an owner can actually use

An effective packet fits in one working file with links. Include a cover sheet with business name, review date, cutoff, preparer, and reviewer. Add the population summary: opening unbilled billable hours, hours added during the period, hours invoiced, hours currently held as not invoiced, and hours marked not billable pending approval. Add the exception table with one row per time entry that is uninvoiced beyond tolerance, rate mismatched, edited, duplicate suspected, or reclassified.

Each row should carry the time entry reference, customer and project, date worked, recorded hours, current rate, current billable status, linked invoice number when present, evidence location, exception type, impact statement, and owner. Keep fact, exception, and decision in separate fields. The fact field records what QuickBooks and the source show. The exception field names the pattern. The decision field stays blank until the authorized reviewer completes it.

Include a billing cutoff statement that defines which hours belong to this invoice cycle and which will ride to the next cycle. That single sentence often prevents a scramble to explain why a recent entry did not appear on the last invoice.

Add a handoff section with resolved items, items waiting on information, and items waiting on approval. Use simple statuses such as invoiced and linked, ready to invoice, held for description update, held for rate confirmation, duplicate suspected, or awaiting owner decision. Close an item only when the invoice link or the approved hold reason is documented.

Set the cadence and the follow through

For weekly billing clients, run the tie-out before each invoice batch. For monthly billing, run it twice: once mid month to keep the queue small and once at the end of month with the billing cutoff. The VA prepares the population and the exception table each time. The owner or billing manager reviews the exceptions, approves invoice creation, and notes any write off. Before a financial close, run the same packet with a period cutoff so unbilled time does not cross periods without being visible.

Archive the packet with the invoices and the time source file so a later reviewer can repeat the tie-out. Keep the archive location consistent and limit access to the approved billing team.

A reviewer should be able to answer five questions quickly after reading the packet: how many billable hours were available, how many were invoiced, what remains unbilled and why, what rate or hour questions are open, and who owns each exception. That clarity keeps invoicing accurate while keeping authority where it belongs.

Simple quality checks help. Ask whether every unbilled billable hour was either tied to an invoice or raised as an exception, whether every invoiced hour ties back to an approved time entry, whether every rate or hour change has an approver, and whether any write off bypassed the approval queue.

The QuickBooks bookkeeping VA service outlines preparation boundaries for billing support work. For period close context, use the QuickBooks month-end close packet.

What good looks like

Good looks like a billing review that takes ten minutes because the evidence is lined up, exceptions are named, and decisions are documented. Invoices go out consistently. Missed billable time drops. Rate changes do not drift into invoices without approval. And the VA never has to guess how to treat time that does not cleanly map to an invoice.

Next step

Pilot the control on one customer that represents recurring billable work. Pull its unbilled time and recent invoices, group by project, record evidence locations, and name one owner for exceptions. Review the first exception table for clarity. Keep the fields that drove a decision, remove the fields that added noise, and reuse the approved template for the next billing cycle. This measured start turns billable time from a loose source into a reviewable flow without changing the approval model inside QuickBooks Online.