DEV Community🇮🇩🇮🇳🇵🇭
Your client paid you less than the invoice. Here's where the money went (and how to get it back)
If you freelance for companies in India, Indonesia, the Philippines, Spain, most of Latin America, parts of Africa, or you do construction work in the UK, you have probably had this moment: you invoice 2,000, and 1,800 lands in your account. No dispute, no late fee, no explanation. The missing 200 is withholding tax (also called tax deducted at source, retención, PPh, TDS, CIS, or in the US "backup withholding"). Your client was legally required to keep part of your fee and pay it to the tax office in your name . It is not a cost — it is a prepayment of your own income tax. But it only counts as a prepayment if you can prove it. Most freelancers can't, so they pay the tax twice. This post is the bookkeeping system I use to make sure that never happens, plus the spreadsheet logic so you can build it yourself. 1. Three numbers per invoice, not one The core mistake is tracking only the invoice total. Every invoice actually has three amounts you care about: Amount What it is Who it belongs to Pre-tax fee What you charge for the work You (income) Sales tax / VAT / GST Added on top if you are registered The tax office (you are just collecting it) Withholding Deducted by the client You, but parked at the tax office until you file So the cash you should expect is: net cash = fee + sales tax − withholding In a spreadsheet, with the fee in F, withholding rate in H and the sales-tax toggle in Settings: I (withheld) = F * H J (sales tax) = IF(Settings!B10="YES", F * Settings!B11, 0) K (total) = F + J L (net cash) = K − I Note the order: withholding is usually calculated on the pre-tax fee, and sales tax is added on top of it.