How to Reconcile Bank Transactions to Jobs (Bank-Truth Job Costing)

The short answer: Reconciling bank transactions to jobs means taking each real charge and deposit in your bank feed and assigning it to the job it belongs to, or to overhead if it is a cost of running the business. Do this and your job margins reflect money that actually left the account, not estimates you typed in. The rule is simple: every expense is either a job cost or overhead, and every deposit should match an open invoice. CRMb connects a read-only bank feed so you can tag each transaction to a job or overhead and feed true spend into each job's margin. It never moves money, the feed is read-only and visible to owners and managers only.

Most job costing is built on what you meant to spend. Bank-truth job costing is built on what you did spend. The difference shows up as the surprise at month-end: the supplier charge you forgot, the fuel that never made it onto a job, the deposit that was never matched to an invoice. Reconciling to jobs closes that gap.

---

What "reconciling to jobs" means

Traditional bank reconciliation checks that your books match your bank statement. Reconciling to jobs goes one step further: it asks, for every transaction, which job did this belong to?

• A $420 charge at the plumbing supply house is a job cost, assign it to the job it was bought for.
• A $180 fuel charge might be job (a long haul to one site) or overhead (general running around), your call, consistently applied.
• Monthly insurance is overhead, it is the cost of being open, not tied to one job.
• A $2,000 deposit is a payment, match it to the open invoice it settles.

When every line is tagged, each job carries the real dollars it consumed, and your overhead bucket holds everything that keeps the doors open. That is the foundation of a margin you can trust.

Why bank truth beats spreadsheet estimates

A spreadsheet job cost is a snapshot of intentions. It holds the numbers someone remembered to enter. Bank truth holds the numbers that actually happened, because a charge cannot hide, it hit the account.

Three leaks that bank-truth costing catches and estimates miss:

• The forgotten charge. A material run nobody logged still shows in the feed. Tagging it puts the cost back on the job.
• The creep. Small extras, a second trip, an add-on part, add up invisibly in estimates but appear as real transactions.
• The unmatched deposit. Money came in but was never tied to an invoice, so your receivables look wrong. Matching fixes both the cash and the accounts receivable picture.

None of this requires new data entry. The transactions already exist in your bank, reconciling to jobs is the act of pointing each one at the right place.

Reconciling to jobs is less an accounting chore than a way to see the business clearly. Once real spend sits on real jobs, the question every owner half-avoids, which work actually makes money, finally has an answer you can act on instead of a feeling.

Step by step: assign each transaction

1. Connect the feed. Link your business account through a read-only connection so transactions appear automatically. Read-only means the tool can see the activity but can never move, send, or withdraw money.
2. Work the list top down. For each transaction, decide: job cost, overhead, or a payment to match.
3. Tag job costs to the job. Assign supplier charges, subcontractor payments, and job-specific materials to the exact job.
4. Send the rest to overhead. Rent, insurance, software, general fuel, office costs, anything not tied to one job.
5. Match deposits to invoices. When a payment lands, tie it to the open invoice it settles so receivables clear.
6. Review the margin. As tagged spend lands on jobs, the reports view shows each job's margin moving on real money.

Do this weekly and it takes minutes. Let it pile up for a quarter and it becomes the dreaded catch-up session.

Job vs overhead: how to split

The one judgment call is whether a cost belongs to a job or to overhead. A working rule: if the cost exists because of one specific job, it is a job cost; if it exists whether or not that job happened, it is overhead.

Consistency matters more than getting every borderline fuel charge perfect. Pick a rule for the gray areas and apply it the same way every time, so your job margins are comparable across jobs.

Matching deposits to open invoices

Costs are only half of reconciliation. The deposits side keeps your cash and receivables honest.

When a customer pays, the money shows in the feed as a deposit. Matching it to the invoice it settles does two things: it marks that invoice paid, so you stop chasing money you already have, and it confirms the cash is real, not just an invoice you hope gets paid. Unmatched deposits are how a business ends up unsure who still owes them, tracking that gap is the heart of accounts receivable.

Avoid double-counting materials

The one trap to watch. If you already recorded a part as job material when you pulled it from inventory, and then also tag the supplier's bank charge to the same job, you have counted that cost twice, and the job looks worse than it is.

The fix is a clear rule: a cost lands on a job once. Either you track it as inventory material at average cost when it is used, or you tag the bank charge to the job, not both for the same items. CRMb flags likely double-counts so a receipt does not land twice on the same job. When materials flow through inventory, let inventory carry that cost and treat the bank charge as the stock replenishment it is.

Putting it together: true job cost

Reconciled to jobs, your cost picture finally closes the loop. A job's cost becomes:

• Labor from real punched hours through Punch.
• Materials from inventory at average cost.
• Direct spend tagged from the bank feed: subs, dump fees, job-specific buys.
• Overhead applied on your own rule.

Every one of those is a real number, and the margin on the reports view is built from money that actually moved. That is bank-truth job costing, and it is the difference between guessing your best jobs and knowing them. For the full method, see the job costing guide.

Frequently Asked Questions

What does it mean to reconcile bank transactions to jobs?

It means assigning each real charge and deposit in your bank feed to the job it belongs to, or to overhead if it is a general business cost. The result is job margins built on money that actually left the account, rather than estimates you entered by hand.

Does CRMb move money or pay bills?

No. CRMb's bank feed is read-only: it can see your transactions so you can assign them to jobs, but it can never move, send, or withdraw money. The bank data is visible to owners and managers only, so sensitive financial detail stays restricted.

How do I decide if an expense is a job cost or overhead?

Use one rule: if the cost exists because of one specific job, it is a job cost; if you would have paid it regardless of that job, it is overhead. Lumber for a named deck is a job cost; monthly insurance is overhead. Apply your rule for gray areas, like fuel, consistently so margins stay comparable.

How do I avoid counting a material cost twice?

Decide that each cost lands on a job once. If a part is tracked as inventory material when it is used, do not also tag the supplier's bank charge to the same job. CRMb flags likely double-counts so the same receipt does not hit a job twice.

How often should I reconcile transactions to jobs?

Weekly is ideal, it takes only minutes when the list is short and keeps job margins current while jobs are still open. Letting it build for a quarter turns a quick habit into a long catch-up session and delays the insight you could have acted on.

Getting started

Connect your account read-only, then spend ten minutes tagging this week's transactions to jobs or overhead, and match any deposits to their invoices. Your margins will shift to reflect what you actually spent.

CRMb pulls a read-only bank feed, lets you assign every expense to a job or overhead, matches deposits to open invoices, and feeds true spend into each job's margin, without ever moving a dollar. On Mac, iPad, and the web. Start free and cost your jobs on bank truth.