Contractor finance · Supplier accounts

Reconcile supply-house statements to your job records

If you run a house account at the lumberyard, the electrical supply, or the plumbing wholesaler, you get one monthly statement listing every charge across every job. Matching those line charges back to the right job is where it falls apart — purchases blur together and a charge for the wrong job slips through. Cash Workspace lets you file each monthly statement as a document and match its line charges to your individual job-tagged expense records so the account reconciles at month-end.

The problem

Why house-account statements are hard to reconcile

A house account bundles purchases for many jobs onto one statement, but your costs are recorded per job. Without matching them, charges go untagged or land on the wrong job.

  • One statement lists twenty charges across five jobs, and tying each back to a job is manual.
  • A charge appears on the statement that you don't have a recorded receipt for.
  • A counter pickup got tagged to the wrong job and nobody caught it.
  • Returns and credits on the statement don't line up with what you recorded.
  • Month-end arrives and the statement total doesn't match the sum of your job records.

The workflow

Match a monthly statement to job records

File the statement, then walk its line charges against your recorded, job-tagged expenses until they agree.

  1. 1

    File the statement

    Attach the supplier's monthly account statement as a document under that supplier for the month.

  2. 2

    Walk the line charges

    Go down the statement and find each charge's matching job-tagged expense record in your workspace.

  3. 3

    Flag any unmatched charges

    Note any statement line with no recorded receipt, or any recorded purchase missing from the statement, to chase.

  4. 4

    Check returns and credits

    Confirm any credit memos on the statement match the returns you recorded against their jobs.

  5. 5

    Confirm the totals

    Compare the statement total to the sum of your matched records and note that the account reconciles for the month.

Record structure

What to record for each statement and charge

Consistent fields on the statement and on each expense make the month-end match straightforward.

Supplier
The supply house the account is with, as a consistent vendor name.
Statement period
The month the statement covers, so it's filed in the right place.
Statement document
The attached monthly statement PDF or printout.
Charge / line item
Each charge on the statement, matched to a recorded expense.
Job tag
The job each charge belongs to, so house-account spend maps back to jobs.
Matched receipt
The recorded receipt that corresponds to each statement line.
Credits / returns
Any credit memos on the statement matched to recorded returns.
Unmatched flag
A note on charges or receipts that don't line up yet, to resolve.
Reconciled note
A note that the statement total agrees with the matched records for the month.

Example setup

An example supplier statement setup

One way to organize a single supply-house account across months.

Supplier statements

Each monthly statement filed by period under the supplier.

Matched charges by job

The job-tagged expense records that correspond to the statement lines.

Credits & returns

Credit memos from the statement matched to recorded returns.

Unmatched / to chase

A short list of charges or receipts that don't line up yet.

Common mistakes

Mistakes to avoid

  • Filing the statement without matching its lines to job records.
  • Letting a charge with no recorded receipt slide instead of chasing it.
  • Tagging a counter pickup to the wrong job and never reconciling.
  • Ignoring credits and returns on the statement, so totals never agree.
  • Skipping a month, so the next reconciliation has to untangle two periods.

How it helps

How Cash Workspace helps

Statements filed by month

Attach each supply-house statement as a document, organized by supplier and period.

Charges matched to jobs

Match each statement line to a recorded, job-tagged expense so house-account spend maps back to the right job.

Month-end reconciliation

Flag unmatched charges and confirm the statement total agrees with your recorded records for the month.

FAQ

Supplier statement FAQ

How do I match a statement to my records?
File the monthly statement as a document, then walk each line charge against your recorded, job-tagged expense for that supplier. Flag anything that doesn't match and confirm the totals agree at month-end.
What about credits and returns on the statement?
Match each credit memo on the statement to the return you recorded against its job, so credits reduce the right job's recorded cost and the statement still reconciles.
Does Cash Workspace pull my statement in automatically?
No. You attach the statement as a document and match its lines yourself. Cash Workspace does not sync with your supplier or bank, and it does not automatically read or extract data from statements.

Organizing help — not tax, accounting, or legal guidance

Cash Workspace is a free workspace for organizing invoices, expenses, receipts, clients, and documents. This page is organizing guidance only — not tax, accounting, legal, or bookkeeping guidance. Cash Workspace does not connect to your bank, does not scan or read your receipts for you, and does not move or collect payments. Whether an expense is deductible depends on your situation, so confirm it with a qualified accountant or tax professional.

Reconcile every house account at month-end

Start a free workspace, file each supply-house statement, and match its line charges to your job-tagged records so the account reconciles every month.