Click any date to preview that day's work for all customers mixed together — then download it from there. Days with entries show the job count and 💰 payment count. 🎉 purple border = festival/holiday, striped "CLOSED" = office closed — manage these from "Festivals & Holidays" above.
Select a date sheet file (e.g. 21-04-2026.xlsx) or a CDR folder named 21-04-2026.
■ PPP files = shown with their billed amount, but that amount never adds to the customer's due balance (balance stays 0 for these). Any customer with a PPP entry shows up under "Paid Customers".
■ Error rows = no colour or amount 0. ■ Yellow rows = edited by you / Previous Debt entries. ■ Green rows = Payments.
| Date | Party | Job / Description | Type | SC | DC | TC | Status | Amount | Running Balance | Actions |
|---|
| Date | Party | Description | Account | Amount | Actions |
|---|
Add recurring costs like staff salary, or one-time expenses. Monthly expenses auto-deduct every month — click "Adjust This Month" on any row to give a one-time bonus, apply a deduction, or override that month's amount.
Generate a password/access code for a client so they can download files at a given resolution and colour-count. Other sites can validate a code via this app's public checkAccessCode endpoint.
All your data is mirrored into a "CBD Backups" folder in your Google Drive, organised into subfolders: Customers (one sheet per customer), Payments (one sheet per month), Expenses (one sheet per year), and Full Snapshots — 3 rotating complete backups of everything, where the oldest of the 3 is automatically replaced after every single edit you make. Use "Full Resync Now" once after setup (or any time) to rebuild every folder from your current live data. For any snapshot below, click "⬇ Download Folder (Excel)" to get the whole Customers/Payments/Expenses folder — as real .xlsx Excel files — downloaded straight to your PC in one ZIP, exactly as it stood at that snapshot. This is completely read-only: it never touches your live data, unlike "↩ Restore".
When you merge two customers, the old name is remembered here. Next time an import sees that same wrong name, it's automatically routed to the correct customer instead of creating a duplicate.