Recurring monthly close

Monthly Deposit vs Final Payment Reconcile Routine

If you take a deposit when a job is booked and bill the rest when it's done, the two halves of the money rarely land in the same month. A deposit comes in March; the final balance might clear in May, or not at all. Once a month, this routine has you walk down your list of jobs, set each one's deposit beside its invoiced and received final balance, and decide one thing per job: is the balance settled for this period, or still outstanding? Jobs that are square get closed for the month; jobs that still owe get flagged so you can see them at a glance. This is an organizational close you run on a cadence — a snapshot of where each job stood at month-end — not a live tracker that updates itself. Cash Workspace gives you records to hold the deposit and final-payment proofs per job and a place to mark the period's outstanding flag. It does not sync with your bank, read your documents, or reconcile anything automatically; you do the matching, and the workspace keeps it organized. This is organizational guidance, not accounting or collections advice.

The problem

Why deposit-to-final-balance gets messy

The trouble with deposit-then-balance jobs is that the timeline is split and the proofs scatter. The deposit receipt sits in one place, the final invoice in another, and the payment confirmation in a third — often weeks apart. Without a deliberate monthly pass, it's easy to lose track of which jobs were collected in full and which are still carrying a balance. A once-a-month walk-through closes that gap: you look at every job once, set deposit against final balance, and record the verdict for the period.

  • The deposit lands in one month and the final balance in another, so neither side tells the whole story on its own.
  • Proof of the deposit, the final invoice, and the final payment often live in three different places and are hard to line up at close.
  • Without a fixed monthly pass, a job that paid its deposit but never paid the balance can sit unnoticed for months.
  • "Done" on the calendar and "paid in full" in the records are not the same thing, and only a deliberate comparison catches the difference.
  • A spreadsheet cell can say "balance due" but cannot hold the deposit slip and the final-payment proof beside it.

The month-end pass

Running the monthly reconcile, job by job

Set aside a short block at month-end. Open your reconcile folder for the period and walk down the list of jobs that had a deposit and a final balance this month. For each one, compare the two figures, attach the proofs, and mark whether the balance is settled or still outstanding for the period. The goal is one clear verdict per job, captured in a dated month-end snapshot.

  1. 1

    Open the period folder and list the jobs in scope

    Create or open a folder like 2026-06-Deposit-vs-Final. List every job that had a deposit on file and a final balance due or received in this period, e.g. "Job 318 - Hendricks Patio" and "Job 322 - Riverside Wedding." Jobs with no deposit-and-balance split this month stay out of scope.

  2. 2

    Set deposit beside final balance for each job

    In each job's record, write the deposit amount, the invoiced final balance, and the amount actually received. Example for Job 318: deposit $1,200, final invoice $4,800, balance due $3,600, received $3,600. The three numbers together tell you instantly whether the job squared.

  3. 3

    Attach the proofs per job

    Attach the deposit receipt, the final invoice, and the final-payment confirmation to that job's record. For Job 322: deposit-slip-2026-04.pdf, invoice-322-final.pdf, and payment-322-cleared.pdf all live in the one record, so the full deposit-to-balance trail is in one place.

  4. 4

    Mark the per-period outstanding flag

    Set each job's status for this period: Settled if the final balance is fully received, or Outstanding if any of it is still owed. Job 318 received $3,600 of $3,600 - mark Settled. If Job 322 received only the deposit and still owes $5,400, mark Outstanding and note the amount.

  5. 5

    List the flagged jobs and close the month

    Gather the Outstanding jobs into the period's summary note - job name, final balance, amount still owed - so the month's open items are visible at a glance. Date the folder, note that the pass was completed, and stop adding to it. Next month is a fresh pass; this is a point-in-time snapshot, not a running ledger you keep editing.

Record structure

What to record per job

Each job in the monthly reconcile carries a small set of fields so the deposit-versus-final-balance picture is complete and the outstanding flag is unambiguous. Keep them consistent across jobs so the month-end pass goes quickly.

Job name / number
A stable label that matches your job folder, e.g. "Job 318 - Hendricks Patio." This ties the reconcile record back to the rest of the job's documents.
Deposit amount and date
What was taken up front and when, e.g. $1,200 on 2026-03-14. This is the first half of the comparison.
Invoiced final balance
The final balance billed after the deposit, e.g. $3,600. Pull this from the final invoice, not from memory.
Amount received against final balance
How much of the final balance has actually come in for this period, e.g. $3,600 received or $0 received. The gap between this and the invoiced balance is what drives the flag.
Period outstanding flag
Settled or Outstanding for this month-end. If Outstanding, record the amount still owed (e.g. $5,400 outstanding).
Attached proofs
Deposit receipt, final invoice, and final-payment confirmation attached to the record so the full trail sits in one place.
Period and pass date
Which month this snapshot belongs to and the date you ran the pass, e.g. period 2026-06, reconciled 2026-07-02.

Example setup

An example folder layout

A practical way to organize the monthly reconcile is one folder per period, each holding a record per job plus a short summary note listing the flagged jobs. Here is how a single month might look.

2026-06-Deposit-vs-Final/

The month's reconcile folder. Holds one record per in-scope job plus the period summary note. Dated and closed once the pass is done.

Job-318-Hendricks-Patio/

Deposit $1,200, final invoice $4,800, balance $3,600, received $3,600. Flag: Settled. Attachments: deposit-slip-2026-03.pdf, invoice-318-final.pdf, payment-318-cleared.pdf.

Job-322-Riverside-Wedding/

Deposit $2,000, final invoice $7,400, balance $5,400, received $0. Flag: Outstanding ($5,400). Attachments: deposit-slip-2026-04.pdf, invoice-322-final.pdf.

Job-327-Maple-Cafe-Signage/

Deposit $500, final invoice $1,900, balance $1,400, received $1,400. Flag: Settled. Attachments: deposit-receipt-327.jpg, invoice-327-final.pdf, payment-327-confirm.pdf.

_2026-06-summary-outstanding.txt

Period summary listing the flagged jobs only: Job 322 - Riverside Wedding - $5,400 final balance outstanding as of 2026-06-30. Pass completed 2026-07-02.

Common mistakes

Mistakes to avoid

  • Treating the deposit as the whole payment and never circling back to confirm the final balance came in.
  • Letting the folder run as a live tracker you keep editing all month - this is a dated month-end snapshot; start a fresh pass next period.
  • Marking a job Settled because the work is finished, when the final balance is still partly or wholly unpaid.
  • Recording the figures but not attaching the deposit, invoice, and payment proofs, so the trail can't be verified later.
  • Pulling in jobs with no deposit-and-balance split this month and bloating the pass beyond its scope.
  • Expecting the workspace to match payments for you - the comparison is yours to make; it only keeps the records and the flag organized.

How it helps

How Cash Workspace helps

A record per job, with both halves in view

Keep the deposit amount, the invoiced final balance, and the amount received together in one job record, so the comparison is right in front of you when you run the pass.

Attach the proofs to the job

Attach the deposit receipt, final invoice, and payment confirmation directly to each job's record. The full deposit-to-final trail lives in one place instead of three.

Period folders for each month's snapshot

Organize each month-end pass into its own dated folder so the reconcile stays a point-in-time snapshot you can close, not an ever-changing list.

A place to mark the outstanding flag

Record Settled or Outstanding per job and gather the flagged jobs into a short summary note - your at-a-glance view of what still owes for the period.

Export the period when you need to share it

Export the month's reconcile records and proofs to hand to a bookkeeper or accountant. Cash Workspace is free and keeps the records accountant-ready; it is not accounting software and gives no tax advice.

FAQ

Common questions

Does this routine track every payment, or just deposits and final balances?
Just the deposit-versus-final-balance pairing per job. It is scoped to jobs that took a deposit up front and have a final balance billed or received. Other money movements - everyday expenses, payouts, general receivables - belong on their own pages. Keeping this pass narrow is what makes it quick to run each month.
Is this a live tracker that updates as payments come in?
No. It is a recurring month-end snapshot. You run the pass once per period, record where each job stood, mark the outstanding flag, then date and close the folder. Next month you start a fresh pass. Cash Workspace does not sync with your bank or update balances on its own.
How does Cash Workspace know if a job's balance is paid?
It doesn't decide that for you - you do. Cash Workspace does not read your documents, sync with your bank, or reconcile automatically. You compare the invoiced final balance against what was received, then record Settled or Outstanding yourself. The workspace keeps those records and proofs organized.
What do I do with the jobs I flag as outstanding?
List them in the period's summary note - job name, final balance, amount still owed - so they're visible at a glance. From there you might track them on the unpaid invoice tracker or payment status tracker. This page is about flagging and filing at close; it doesn't script collections or give advice on chasing payment.

What this page is and isn't

This is organizational guidance for running a monthly deposit-versus-final-balance pass - not accounting, bookkeeping, tax, or collections advice. Cash Workspace is a free tool for organizing records and attaching documents. It does not sync with your bank, read or extract data from your documents, reconcile payments automatically, or process payments. You do the comparing and the flagging; the workspace keeps the records, proofs, and per-period snapshots organized. For decisions about your books or taxes, consult a qualified professional.

Start your free deposit-vs-final reconcile

Set up a free workspace and create your first month-end period folder. Add a record per job, attach the deposit and final-payment proofs, and mark which balances are settled and which are still outstanding. Cash Workspace is free, organized, and ready when you are - no bank connection, no automation, just a clean place to run the pass each month.