Revenue reconciliation for service businesses
Ledgerline checks every finished job against team time, supplier invoices and fuel, then shows you exactly what never made it onto the invoice. Import your export and see the gap in minutes.
No card required · Cancel any time · Your job data stays yours
Alvarez Residence · replacement assembly
Next action
Rebill the supplier cost at the standard material markup and send a supplemental invoice.
5
revenue gaps we check for
3
cost sources cross-checked
2 min
from import to first flags
14 days
free, no card needed
How Ledgerline works
Start with your jobs CSV — job number and customer are required, everything else is mapped as it appears, and fuel rides on the job row. Then add a team-time and a supplier-line export when you want the labor and material checks. Rows you already imported are skipped.
Hours on the ticket are priced at the bill rate, supplier invoices are matched to what the customer was charged, and fuel is counted as real cost. Anything that doesn't line up becomes a flag.
Each flag names the job, the customer, the amount at risk and the fix. Close it as recovered or written off, and watch the recovered total climb through the month.
Your jobs CSV carries the quote, the invoice and the job's cost totals, which is enough for the quote, invoice and margin checks. Two optional files add the detail underneath: a team-time export with hours, a billable flag and a bill rate for the unbilled-labor check, and a supplier-line export with each line's cost and what the customer was charged, for the missing-material and duplicate-charge checks.
Fuel stays a cost column on the job row. Job number and customer name are the only columns a jobs import needs; everything else is mapped as it appears, and a check whose line file has not been imported stays quiet instead of guessing.
6 jobs, 12 columns, in the layout the importer maps without renaming anything. Two of them carry gaps the checks catch: an unpaid estimate on J-10419 and an invoice short of its quote on J-10415. Team time and supplier lines import as their own files.
Required to import
Mapped when present
Minimum data per check
A check only runs on the data it needs. Where the data is missing the job is marked unchecked, never given a guessed number.
Unbilled labor
Billed workTeam-time file: job number, team member, hours, billable flag, bill rate
Hours on a finished job that were marked non-billable and never invoiced, priced at the job's bill rate. Fires at $50 or more.
Missing material charge
Billed workSupplier-line file: job number, supplier, line cost, amount charged to the customer
Supplier cost sitting in job cost with no matching charge on the customer invoice. Fires when a job's gap reaches $50.
Underbilled invoice
Billed workJobs file: quoted amount, invoiced amount, job status
An invoice more than 8% under the approved quote on a job marked invoiced or paid. The flag is the shortfall, not the whole invoice.
Duplicate charge
Billed workSupplier-line file: job number, supplier, invoice number, line cost
The same supplier invoice line posted twice against one job. The repeat is the amount at risk; the first copy is still counted once.
Aging estimate
Potential saleJobs file: quoted amount, invoiced amount, completed date, job status
The uninvoiced remainder of an approved quote, 30+ days after the work date, on a job not marked paid. Kept out of earned totals.
Job margin
Billed workJobs file: invoiced amount, labor cost, material cost, fuel cost
Not a flag: a per-job and per-service-line margin from invoiced minus the three cost columns. Miss a cost column and margin reads unknown, not zero.
A check whose file has not been imported reports nothing rather than a zero. Unbilled labor and missing material stay quiet until the team-time and supplier-line exports are loaded.
Show the arithmetic
A flag is subtraction, and you can repeat it on any row. These are two jobs from the sample queue, taken from the supplier-line and team-time files to the flags they raised.
J-10428 · Alvarez Residence
Install · completed Oct 30
Material gap: $1,412.60 − $1,000.00 = $412.60.
J-10426 · Brennan Duplex
Repair · completed Nov 1
Labor gap: 3.25 h × $88.00 = $286.00.
Flags raised
Missing material charge
$412.60
J-10428 — $1,412.60 of supplier material against $1,000.00 charged through. Rebill the $412.60 gap at your standard markup.
Unbilled labor
$286.00
J-10426 — 3.25 hours marked non-billable at $88.00. Add $286.00 to a supplemental invoice.
Work done, not billed
$698.60
Not flagged: J-10428's invoice matched its $2,480 approved quote, so the underbilled check stayed quiet. A check that finds nothing says nothing.
Both jobs belong to the fictional sample business. We publish a customer's numbers only with written permission — during onboarding we'll connect you with one that has agreed to be a reference.
Open both jobs in the sample queuePricing
Every plan starts with 14 days free, no card. Cancel from the billing page at any time.
One office, every job checked.
$149/ month
Up to 3 team members · 250 jobs a month
Checks unlocked
Included
The full margin picture across the team.
$349/ month
Up to 12 team members · unlimited jobs
Everything in Basic
Additional checks
Also included
Every location in one ledger.
$749/ month
Unlimited team members and locations
Everything in Pro
Additional checks
Also included
Questions
Import one month of jobs and work the queue once. If it doesn't find money you'd have missed, you've lost nothing but the import.