Bad debts
How much was lost to customers who will not pay, set against the business they brought in the same period.
What it shows
One row per customer with a debt written off in the period and not undone. Written off is what was left on their invoices when they were written off; Net sales before tax is what the same customer was invoiced in the period before tax, less the credit notes issued to them in it. The output VAT on a written-off invoice stays in the books; any relief on it is an adjustment on the VAT return.
How it ties to the books
A write-off is posted to the bad debts expense account against receivables, so the Written off total is what that account took in the period in the Profit and loss, unless something else was posted there.
Written off in the period and not undone. Output VAT stays in the books as it was; any relief on it is an adjustment on the VAT return.
| Group | Receivables |
|---|---|
| Period | takes a date range |
| Filters | — |
| Columns | 3 |
Columns
| Column | Kind | Totalled |
|---|---|---|
| Name | text | — |
| Net sales before tax | amount | Yes |
| Written off | amount | Yes |
A sample from the demo data
Drawn by the program’s report engine on the demo company, 30 July 2026 to 28 October 2026, in SAR.
The demo data holds nothing this report draws, so there is no sample here.
Sample data, for illustration only.
Reports read with it
- Customer balancesWhat each customer still owes from the sales of a period, and how much of it has been collected.
- Invoice ageingWhich customers are late and by how long, so collection can start with the oldest debts.
- Profit and lossWhether the business made money in a period, and which revenues and expenses made it so.
- VAT returnWhat VAT the books say is due for a period, set beside what the documents say.
Sources
The definition and the sample come from the program’s report library (books/reports.rs) on the demo data; the explanation from its engine.