Revenue reconciliation for service businesses

Stop leaving billable work behind.

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

Missing material chargeJ-10428

Alvarez Residence · replacement assembly

Supplier invoice · #88417
$412.60
Charged to customer
$0.00
Amount at risk
$412.60

Next action

Rebill the supplier cost at the standard material markup and send a supplemental invoice.

Open the sample queue

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

Three steps between your export and the money you already earned.

  1. 01

    Bring your jobs in

    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.

  2. 02

    Every job gets checked

    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.

  3. 03

    Work the recovery queue

    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.

Jobs first, then the lines

One jobs file to start. Two line files for the checks that need lines.

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

  • Job number
  • Customer name

Mapped when present

  • Service line or business unit
  • Job status
  • Team member
  • Completed date
  • Quoted amount
  • Invoiced amount
  • Labor cost
  • Material cost
  • Fuel cost
  • Notes

Minimum data per check

Two columns import a job. The line checks need their own file.

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 work

    Team-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 work

    Supplier-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 work

    Jobs 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 work

    Supplier-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 sale

    Jobs 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 work

    Jobs 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

Two jobs, line by line.

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

Replacement assembly
$148.00
Connectors and fittings
$214.60
Specialty material, 6 units
$1,050.00
Supplier cost on the job$1,412.60
Charged to the customer$1,000.00

Material gap: $1,412.60 − $1,000.00 = $412.60.

J-10426 · Brennan Duplex

Repair · completed Nov 1

Hours on the ticket
3.25 h
Bill rate
$88.00 / h
Hours marked non-billable
3.25 h
Invoiced labor$0.00

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 queue

Pricing

Priced per business, not per invoice recovered.

Every plan starts with 14 days free, no card. Cancel from the billing page at any time.

Basic

One office, every job checked.

$149/ month

Up to 3 team members · 250 jobs a month

Checks unlocked

  • Unbilled labor on finished jobs
  • Missing material charge
  • Margin on every job

Included

  • CSV import from your existing system's export
  • Recovery queue with CSV export
Start free trial

Pro

Most businesses

The full margin picture across the team.

$349/ month

Up to 12 team members · unlimited jobs

Everything in Basic

Additional checks

  • Underbilled invoice against the approved quote
  • Aging estimate 30+ days from the work date
  • Duplicate charge on a supplier line

Also included

  • Margin by service line and by team member
  • Monthly revenue reporting
Start free trial

Enterprise

Every location in one ledger.

$749/ month

Unlimited team members and locations

Everything in Pro

Additional checks

  • Every check, rolled up per branch

Also included

  • Priority onboarding and data cleanup
  • Quarterly margin review with our team
Start free trial

Questions

The things owners ask before they connect anything.

See what your last quarter left behind.

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.

Start 14-day free trial