How to Track Client Dues and Advance Payments

Stop chasing payments with spreadsheets — see who owes what, instantly.

Ask most print shop owners how much a given client owes right now, and you'll get a pause, a flip through a register, or a scroll through three different Excel tabs before an answer shows up — and even then, it's often a guess. Multiply that across dozens of regular clients, some who paid an advance for a bulk job, some who are mid-way through payment, some who just haven't paid at all, and it's easy to see why dues quietly slip through the cracks.

Why spreadsheets break down here

A spreadsheet works fine for a handful of clients. The trouble starts once you're juggling invoices, partial payments, and advances at the same time:

• Someone forgets to update it. A payment gets collected at the counter and the sheet gets updated "later" — which sometimes means never.
• Advances get lost. A client pays ₹2,000 upfront for a job quoted at ₹5,000, and unless that advance is linked to the final invoice, it's easy to either double-count it or forget to adjust it.
• There's no single "status." Is this client paid, partially paid, unpaid, or sitting on an advance for their next order? In a spreadsheet, that's a manual judgment call every time, not a fact you can just look up.
• Filtering is painful. Finding every due payment from the last 30 days, or everything owed by one client across multiple invoices, usually means manually scanning rows.

The three numbers you should always know

Whatever system you use, you should be able to answer these for any client in seconds:

1. Total invoiced — everything you've billed them, GST and Non-GST combined.
2. Total received — everything they've actually paid, including advances.
3. Net due or advance — the difference, and which direction it goes.

From those three numbers, every client naturally falls into one of four states:

Advance Partial Paid Unpaid

If you're still tracking this manually

1. Give every client one running balance, not one row per invoice

It's far easier to reconcile "Client X owes ₹1,240 net" than to mentally total five separate invoice rows and three payment rows scattered across a sheet.

2. Record advances against the client, not the job

An advance is money in hand before the invoice exists. Log it as a payment against the client first, then adjust it against the invoice once the job is billed — that way nothing gets double-counted.

3. Reconcile weekly, not monthly

A week's worth of missed entries is easy to track down from memory. A month's worth usually isn't.

How PrintKhata does this automatically

This is exactly the kind of bookkeeping that's tedious by hand and trivial for software to keep straight. In PrintKhata, every payment is logged against a client you search by name or contact, a receipt is emailed the moment you save it, and the total paid and due for that client are shown right there — no separate calculation needed. Zoom out to the Client Account Summary and you get total invoiced, total received, due, advance, and a status tag (advance, partial, paid, or unpaid) for every client at a glance, filterable by name or contact. Need the full history for one client? A Client Account Statement, filterable by date range, can be generated and emailed directly from the app.

This article covers general bookkeeping practices for print shop owners and isn't formal accounting advice. For statutory books, reconciliation, and tax filings, it's worth having a qualified accountant review your process alongside whatever system — spreadsheet or software — you use to track dues.