BizGen shows the profit on each client and each project in the Client and project profitability report. It takes what you invoiced, then subtracts the vendor bills, staff claims and staff time recorded against that client or project. Open it from Reports › Reports.
Open the report
- Go to Reports › Reports.
- Under Profitability, choose Client and project profitability.
- Set the period.
- Under Show by, choose Client or Project.
Each row shows Vendor bills, Claims, Hours, Staff time, Costs, Profit and Margin. A tile counts the Clients at a loss or Projects at a loss.
How profit is worked out
Revenue: invoices and debit notes issued in the period, less credit notes, before SST. Drafts and cancelled documents don’t count. Revenue counts when you issue the invoice, not when the client pays.
Costs:
- Vendor bills recorded against the project, with SST. Voided bills don’t count.
- Staff claims that are approved or paid, with SST, where the claim is for the project or a receipt on it names the client.
- Staff time, if the Projects feature is on (Settings › Company settings › Business mode & features): the hours logged on the project, times each person’s hourly cost. The hourly cost is monthly basic pay ÷ 26 days ÷ 8 hours, a daily rate ÷ 8, or the hourly rate, using the pay in force on the last day of the period.
Profit is revenue minus these costs. Margin is profit as a share of revenue.
Only people allowed to read salaries see the staff-time cost. For everyone else, the hours still show but their cost is left out, so profit looks higher.
The report doesn’t share out rent, general payroll or other overheads. A client can show a profit here and still lose money once those are counted.
Make the figures more accurate
- Record each vendor bill against its project.
- Have staff choose the project on the claim, or name the client on each receipt.
- Ask staff to log project time in My timesheet.
See who pays and how fast
The Client collections report shows money in rather than profit. Open it from Reports › Reports, under Sales.
- For each client it shows Total Invoiced, Total Paid, Outstanding, Overdue, Collection %, Avg Days to pay and Last Invoice.
- Choose This Month, This Quarter, This Year or All Time, or pick dates.
- Sort by any column. Select a client’s name to open the client.
- Select Export PDF to save it.
An invoice is overdue when its due date has passed and it isn’t fully paid. Average days to pay counts fully paid invoices only, from the issue date to the last payment. The report reads up to 500 invoices at a time; with more, it tells you so.
Part of Sales & Billing →