When a buyer consolidates staffing charges, forecast the open customer receivable once at the controlling invoice level. Preserve the underlying time-sheet, expense, and source-invoice references as a reconciliation schedule, but do not add them again to the four-week total.
SAP Fieldglass documentation explains that approved time and expense sheets can create invoices automatically or support supplier-created invoices, depending on buyer configuration. Its invoice billing schedule guidance says schedules can govern when suppliers submit invoices and notes that automatic invoicing can occur when time sheets are approved. The operational records and the receivable therefore have a traceable relationship, but they are not additive cash claims.
Build a parent-child reconciliation
Use one parent row for the buyer-facing invoice that carries the legal or source-system open balance. Beneath it, preserve child references for the time sheets, expense sheets, individual invoices, sites, labor types, or billing periods that explain the amount.
| Parent control | Child detail | | --- | --- | | Buyer invoice ID | Time-sheet or expense-sheet ID | | Invoice date and due date | Work period and approval date | | Original and open amount | Underlying billed amount | | Buyer status and payment evidence | Source-document status | | Expected collection week | Exception or adjustment reference |
The sum of the included child amounts should reconcile to the parent invoice under the buyer's documented rules. Differences should remain visible as exceptions rather than being forced into an unexplained adjustment.
Choose one forecast grain
If QuickBooks contains only the consolidated buyer invoice, that invoice is the forecast row. If it contains individual invoices and a separate consolidation reference outside the ledger, forecast the actual open invoice rows and use the consolidation document as grouping evidence. Do not invent a parent balance that the accounting source does not contain.
The key is one controlling grain for cash totals. Reporting can still group by buyer, site, worker, or week, but those views must roll back to the same open balance.
Handle changes without overwriting the bridge
Late approvals, corrected time sheets, credits, debits, or rejected lines can change the relationship between source documents and the buyer invoice. Preserve the prior mapping, the change date, the adjustment reference, and the new supported balance. The staffing adjustment guide covers paired correction documents.
Use the timesheet-readiness guide before an invoice exists. After submission, the VMS invoice-status guide helps separate portal status from payment evidence.
AR Pulse analyzes an authorized QuickBooks receivables export. It does not access a VMS, create consolidated invoices, or change source records. Staffing finance teams that need a controlled invoice-level action and four-week forecast layer can apply for AR Pulse.