Hours, payroll, and invoices live in three systems. The bridge between them was a person retyping numbers that already existed. Now an agent reads the approved hours once, writes both sides of the week, and both sides tie before anyone opens the file.
What we removed
The seat existed because three systems could not agree on a number without a human in the middle. That is an integration problem, and integration is what we do.
One workbook, two sheets: the payroll import and the invoice run. Names, clients, and rates are invented. The arithmetic is real, computed live on this page.
| Record | Status | Name | Client | Code | Hours | Pay rate | Amount | Note |
|---|---|---|---|---|---|---|---|---|
| H-48210 | Approved | Dana Whitfield | Keystone Mutual Insurance | R1 | 40.0 | $68.00 | $2,720.00 | |
| H-48213 | Approved | Dana Whitfield | Keystone Mutual Insurance | O1 | 3.5 | $102.00 | $357.00 | Release window, approved |
| H-48214 | Approved | Marcus Ellery | Keystone Mutual Insurance | R1 | 40.0 | $52.50 | $2,100.00 | |
| H-48217 | Approved | Priya Raman | Keystone Mutual Insurance | R1 | 36.0 | $57.00 | $2,052.00 | Four day week, no assumed 40 |
| H-48220 | Approved | Neil Hargrove | Keystone Mutual Insurance | R1 | 40.0 | $63.00 | $2,520.00 | |
| H-48223 | Approved | Callie Rutherford | Keystone Mutual Insurance | R1 | 40.0 | $49.00 | $1,960.00 | |
| H-48226 | Approved | Curtis Nakamura | Harborline Logistics | R1 | 40.0 | $74.00 | $2,960.00 | |
| H-48229 | Approved | Alicia Fontaine | Harborline Logistics | R1 | 40.0 | $66.00 | $2,640.00 | |
| H-48232 | Approved | Alicia Fontaine | Harborline Logistics | O1 | 6.0 | $99.00 | $594.00 | Cutover weekend |
| H-48233 | Approved | Rosa Villalobos | Harborline Logistics | R1 | 40.0 | $48.00 | $1,920.00 | |
| H-48236 | Submitted | Dominique Sayles | Harborline Logistics | R1 | 40.0 | $55.00 | held | Submitted Saturday. Held. |
| H-48239 | Approved | Terrance Boyd | Cumberland Health Partners | R1 | 40.0 | $61.00 | $2,440.00 | |
| H-48242 | Approved | Simone Guerrero | Cumberland Health Partners | R1 | 32.0 | $44.00 | $1,408.00 | Part time on the placement |
| H-48245 | Approved | Wes Trimble | Cumberland Health Partners | R1 | 40.0 | $38.50 | $1,540.00 | |
| H-48248 | Approved | Yvette Karras | Cumberland Health Partners | R1 | 40.0 | $72.00 | $2,880.00 | |
| H-48251 | Approved | Yvette Karras | Cumberland Health Partners | O1 | 4.0 | $108.00 | $432.00 | Go live support |
| H-48252 | Approved | Omar Haddadi | Cumberland Health Partners | R1 | 40.0 | $64.00 | $2,560.00 | |
| H-48255 | Approved | Ingrid Solberg | Vantage Grid Systems | R1 | 40.0 | $79.00 | $3,160.00 | |
| H-48258 | Submitted | Joel Abernathy | Vantage Grid Systems | R1 | 38.0 | $41.00 | held | Approver out Friday. Held. |
| H-48261 | Approved | Martin Okafor | Vantage Grid Systems | R1 | 40.0 | $69.00 | $2,760.00 | |
| H-48264 | Approved | Isaac Lindqvist | Vantage Grid Systems | R1 | 40.0 | $73.00 | $2,920.00 | |
| H-48267 | Approved | Tabitha Oyelowo | Vantage Grid Systems | R1 | 36.0 | $45.00 | $1,620.00 | |
| H-48270 | Approved | Lena Brzezinski | Allegheny Precision Castings | R1 | 40.0 | $71.00 | $2,840.00 | |
| H-48273 | Approved | Lena Brzezinski | Allegheny Precision Castings | O1 | 8.0 | $106.50 | $852.00 | Line changeover |
| H-48274 | Approved | Dwight Castellano | Allegheny Precision Castings | R1 | 40.0 | $46.00 | $1,840.00 | |
| H-48277 | Approved | Fiona McArdle | Allegheny Precision Castings | R1 | 40.0 | $53.00 | $2,120.00 | |
| H-48280 | Approved | Elias Ruhland | Allegheny Precision Castings | R1 | 40.0 | $70.00 | $2,800.00 | |
| H-48283 | Approved | Arturo Delgado | Susquehanna Trust Bank | R1 | 40.0 | $81.00 | $3,240.00 | |
| H-48286 | Approved | Hannah Wexler | Susquehanna Trust Bank | R1 | 40.0 | $58.00 | $2,320.00 | |
| H-48289 | Approved | Bertram Oyelaran | Susquehanna Trust Bank | R1 | 24.0 | $77.00 | $1,848.00 | Wind down, three days |
| H-48292 | Approved | Peter Vandermeer | Susquehanna Trust Bank | R1 | 40.0 | $59.00 | $2,360.00 | |
| H-48295 | Approved | Naomi Strand | Susquehanna Trust Bank | R1 | 40.0 | $84.00 | $3,360.00 | |
| H-48298 | Approved | Sylvia Thorpe | Brightline Pharma Services | R1 | 40.0 | $76.00 | $3,040.00 | |
| H-48301 | Approved | Raj Bhattacharya | Brightline Pharma Services | R1 | 40.0 | $67.00 | $2,680.00 | |
| H-48304 | Approved | Raj Bhattacharya | Brightline Pharma Services | O1 | 2.5 | $100.50 | $251.25 | Batch record deadline |
| H-48305 | Approved | Georgia Pell | Brightline Pharma Services | R1 | 30.0 | $42.00 | $1,260.00 | Three quarter schedule |
| Held, not approved, not paid (2) | 78.0 | $0.00 | ||||||
| Approved, week ending 2026-09-18 | 1142.0 | $72,354.25 | ||||||
Green is approved and moves. Blue is submitted and waits.
1,142.0 hours paid, 1,142.0 hours billed. Identical by construction, not reconciled after.
78 unapproved hours sit on the sheet, tinted, out of both totals until someone signs.
Pay and bill rate share a row, so margin arrives with the invoices: 34.2 percent this week.
The arithmetic
Two numbers, both computable. Neither of them is a slide.
Market rate for a full charge bookkeeper whose Friday was mostly data entry.
Four days off every invoice. On $5.72M a year of billing, that is cash that stops waiting.
Annual billings, divided by 365, times the days you stopped waiting.
Why it holds up
Four rules. That is the whole design.
Unsigned time does not pay, does not bill, and never quietly becomes 40.
Two views of the same data, so drift between them cannot be created.
Change a rate once and both sides of the week move together.
A missing rate halts the run and names the row. Loud on Friday beats quiet in March.
Where the people went
The clerical work is gone. The accountability is not.
What it touches
Works with whatever ATS, payroll, and ledger you already pay for.
We run this on our own books every week. We will show it to you first.