Upload reports

The backbone of the whole dashboard. Every P&L, balance sheet and cash flow figure is derived from this one file, and each number stays clickable back to the transactions behind it. Export the full financial year; re-uploading a period simply replaces it.

In Zoho Books: Reports → Accountant → General Ledger → Export as XLSX

Last upload: Detailed General Ledger-26-08-2026.xlsx · 11,253 rows · 01 Apr 2026 to 26 Aug 2026

The closing trial balance of the previous financial year. The ledger alone cannot tell us what the balance sheet opened at, so this seeds it. Needed once a year.

In Zoho Books: Reports → Accountant → Trial Balance → Export as XLSX

Drives the revenue view: billing by month, client, vertical and salesperson, plus client concentration.

In Zoho Books: Reports → Sales → Invoice Details → Export as XLSX

Last upload: Invoice Details -26-08-2026.xlsx · 1,347 rows · 01 Apr 2026 to 26 Aug 2026

Credit notes reduce revenue in the ledger but never appear in Invoice Details, so without this file the Revenue page reads high against the P&L. One credit note applied to several invoices is exported once per invoice; it is counted once.

In Zoho Books: Reports → Sales → Credit Note Details → Export as XLSX

Splits revenue between the monthly retainer and one-off professional work — the split shown on the Revenue page and in Budget vs Actual. Two shapes are read: one row per customer per month (customer_name, amount, Month), or the hand-kept table with one column per month. Re-uploading replaces every month the file covers, so a corrected list fixes itself.

In Zoho Books: Reports → Sales → Sales by Item → Export as XLSX

Drives collections and DSO — what was billed against what actually came in.

In Zoho Books: Reports → Sales → Customer Payments → Export as XLSX

A snapshot of what is outstanding and how old it is. Each upload is a dated snapshot, so the trend builds up over time.

In Zoho Books: Reports → Receivables → AR Aging Details → Export as XLSX