You know the feeling. It's the 5th of the month, your accountant is asking for last month's numbers, and you're sitting there with a Razorpay dashboard on one tab, a WhatsApp thread from a client on another, and a notebook where you scribbled "Sharma advance 50k" three weeks ago. Somewhere in that mess, the numbers are supposed to add up. Usually they don't. Not because you're bad with money, but because the money came in five different ways, in bits, from people who paid however they felt like paying.
This is the part of running a studio nobody warns you about. You got into interiors to design beautiful homes, not to spend the first week of every month playing detective with your own bank account. So let's fix it. Here's how to reconcile payments properly so your books stay clean and your accountant stops sighing at you.
Why reconciliation is a nightmare for design studios specifically
Most reconciliation advice is written for shops that sell one thing at one price. That's not us. A design studio's money is messy for real, structural reasons.
You take advances before work starts. A client pays 40% to book you, another 30% when the drawings are approved, the rest on handover. That single project generates three or four inflows spread across months, and each one has to land against the right invoice at the right stage.
Then there's the mix of payment methods. One client does a clean NEFT. Another pays through Razorpay because you sent a payment link. A third hands you a UPI transfer at 11pm with no note. A fourth deducts TDS and sends you a smaller amount than the invoice, and you're left wondering why 90,000 arrived against a 1,00,000 bill.
And the payout timing. When someone pays you 1,00,000 through Razorpay, 1,00,000 does not hit your bank. A gateway fee comes off, GST sits on that fee, and the money lands a day or two later, often clubbed together with two other clients' payments in a single settlement. So your bank statement says "Razorpay settlement 2,64,320" and you have to work backwards to figure out which clients that even covers.
Every one of these is a place where money quietly goes missing from your books. Not stolen, just untracked. I've written before about how untracked advances become a payment leak nobody notices, and reconciliation is where those leaks finally show up, usually at the worst possible time.
The four things you're actually matching
Reconciliation sounds technical but it's really just answering one question for every rupee: where did this come from, and what was it for. To answer it cleanly, you're matching four things against each other.
- The advance the client agreed to pay, and at which milestone.
- The invoice you raised for that stage, with the correct GST.
- The TDS the client deducted, if they're a company or deducting under contract.
- The actual payout that landed in your bank, after gateway fees and settlement clubbing.
When all four line up, that project's accounts are clean. When they don't, you have a gap, and the gap is either money you're owed, a fee you forgot to record, or a TDS credit you're about to lose. Let's go through the traps one by one.
Trap one: the advance that has no home
A client pays you 50,000 to lock the project. You haven't raised an invoice yet because work hasn't started. So where does that 50,000 sit? In too many studios it sits nowhere. It's just "money that came in," and by the time you raise the first bill, you've half-forgotten whether it was adjusted or not.
The clean way is to treat every advance as a liability until it's adjusted against a real invoice. You received the money, but you haven't earned it yet, so it's not income, it's an advance you owe work against. When you raise the stage invoice, you knock the advance off it. If you're on Designa, an advance is logged the moment it comes in and stays visibly linked to the project, so when you invoice that stage the advance is sitting right there waiting to be adjusted. No mental math, no scribbled note.
Trap two: the TDS gap
This one costs studios real money every year. Your invoice says 1,00,000 plus GST. A corporate client pays you and deducts 10,000 as TDS under 194J or 2,000 under 194C, depending on how they classify the work. So you receive less than you billed.
Here's the mistake. Studios record the smaller amount as the payment and treat the difference as a discount or, worse, as bad debt. It isn't. That deducted amount is tax already paid on your behalf. It shows up in your Form 26AS and you claim it against your own tax liability. If you don't track it invoice by invoice, you either can't claim it or you spend a painful evening in March trying to reconcile 26AS against forty invoices from memory.
The fix is to record the deduction against the specific invoice at the time of payment, so the invoice shows: billed 1,00,000, TDS 10,000, received 90,000, and all three tie out. If TDS still feels fuzzy, the basics every interior designer should know about TDS is worth ten minutes of your time before your next corporate project.
Trap three: the Razorpay settlement puzzle
Payment gateways are wonderful for getting paid fast and terrible for clean books, because the number in your bank never matches the number the client paid.
Say three clients pay you through Razorpay links on the same day: 1,00,000, 75,000, and 90,000. Total collected, 2,65,000. But Razorpay takes its fee plus GST on that fee, and settles the net amount, often a day later, as one lump sum. Your bank shows something like 2,60,600 and clubs all three together. Now match that to three separate invoices. Fun.
To reconcile this properly you have to do three things every time. Split the settlement back into the individual client payments it represents. Book the gateway fee as an expense, and book the GST on that fee separately, because that GST is input credit you can claim. And match each split payment to its invoice. Do this by hand and it's an hour a week. This is exactly the kind of grind Designa handles by keeping each Razorpay payment tied to the invoice it paid, so the settlement reconciles itself and the fee and its GST land in the right buckets. That fee-GST matters more than people think, and it connects directly to how you claim GST input credit in your design studio at filing time.
Trap four: books that don't talk to your accounting software
You can reconcile beautifully inside your project tool and still hand your accountant a mess, if the two systems don't sync. Then someone re-types every invoice into Tally, makes typos, misses a credit note, and the "clean" books drift apart from what your CA actually files.
The whole point of reconciliation is one version of the truth. So your project and invoicing data has to flow into your accounting software without manual re-entry. If you run Tally, syncing your studio invoices with Tally closes that gap. On Zoho Books, connecting Designa with Zoho Books does the same job. Either way, the invoice you raised, the advance you adjusted, the TDS you recorded, and the payout you received all arrive in your accounts already matched.
A simple month-end routine that actually holds
You don't need a finance team. You need a routine you run the same way every month, on the 1st, before things pile up.
- Open your bank statement for the month and every inflow gets a name and an invoice. Nothing stays as "unknown credit."
- For every Razorpay settlement, split it back into individual client payments, and book the fee plus the GST on the fee.
- For every corporate payment that came in short, record the TDS against the exact invoice, so billed minus TDS equals received.
- Adjust every advance against the stage invoice it belongs to, and check nothing is sitting as an orphan advance.
- Push the reconciled month into Tally or Zoho Books so your accountant works off matched data, not a pile of screenshots.
Do this and the 5th of the month stops being a dreaded day. Your accountant gets clean, tied-out numbers, your GST filing is defensible, and you actually know which projects have money still due.
The honest truth is that this is boring, repetitive work, and boring repetitive work is exactly what software should do for you. That's the whole reason Designa keeps advances, invoices, GST, TDS, and Razorpay payouts in one connected place, so reconciliation is mostly a matter of checking that what's already matched looks right, instead of building it from scratch every month.
Stop dreading month-end
If your reconciliation today means a spreadsheet, a notebook, and a prayer, give yourself a cleaner setup. Designa runs your whole studio, leads to invoices to payments, for one flat founding price of ₹2,299 plus GST a year, the entire studio, up to 10 members, with unlimited free client logins and done-for-you onboarding that migrates your existing data. See how the advances, invoices, TDS, and Razorpay reconciliation actually work at go.designa.work, or poke around a live studio first at demo.designa.work. Your accountant will notice the difference next month.