How to See Billed, Collected, and Outstanding for Service Jobs

Owners cannot tell what was billed, what came in, and what is still out

A services firm on spreadsheets keeps a sheet for jobs, another for payments, and a third someone updates on Fridays. When the owner asks how much is outstanding, the answer depends on which sheet is newer.

Totals by month hide the shape of the problem: which service type earns, which collector brings in cash, and which clients have owed money for ninety days.

Opening balances from before go-live distort the first months, so the period numbers look wrong and nobody trusts them.

Why this happens

• Billed and collected live in different files.
• Outstanding is typed instead of computed.
• Opening balances are mixed into the current period.
• There is no aging view, so old debts look the same as new ones.

Biznsbook addresses this through Collections dashboard, outstanding by age, client statement when Service Billing & Collections is licensed. Clients are the parties you already keep, and collectors record what they received without seeing the fee or the outstanding.

Services firms lose money in the gap between the work done and the payment recorded. Keeping the fee on the job, the payment against the job, and the collector away from the numbers closes that gap without turning the firm into an accounting office.

Step-by-step: See Billed, Collected, and Outstanding for Service Jobs

Built for owners of services firms and the staff who collect client payments in Biznsbook Collections.

1. Finish the getting-started checklist. Until the basics are done, the dashboard shows a Getting started checklist: a service type, a client, a job with a fee, and optional ledger posting.
2. Pick the date range. The dashboard shows billed, collected, and outstanding for the range you choose, in the company currency.
3. Read collections by mode and by person. Collected is split by payment mode, such as cash, UPI, and bank transfer, and by the person who entered each payment.
4. Read billing by service type. Billed is split by service type, so you see which services earn the most in the period.
5. Read outstanding by age. Outstanding is grouped by how long it has been owed. Old debts stand apart from this month’s billing.
6. Clear the attention items. The dashboard counts payments still waiting to be allocated, corrections waiting, not reconciled payments, and over-payments. Each chip opens the list already filtered.
7. Open a client statement. From the list of clients who still owe money, open the statement: every job and payment, with outstanding. Print it or create a client portal link.

Review results after the first full weekly cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Screen names in this guide match Collections in the product: Record a payment, My entries, Dashboard, Jobs, Payments, Payment links, Corrections, Service types, Settings, and Guide. Every screen has a ? help button.

Common mistakes to avoid

• Mistake 1: Billed and collected live in different files. Repeating this each month usually shows up first in billed, collected, or outstanding for the period.
• Mistake 2: Outstanding is typed instead of computed. Repeating this each month usually shows up first in billed, collected, or outstanding for the period.
• Mistake 3: Opening balances are mixed into the current period. Repeating this each month usually shows up first in billed, collected, or outstanding for the period.
• Mistake 4: There is no aging view, so old debts look the same as new ones. Repeating this each month usually shows up first in billed, collected, or outstanding for the period.

Note each recurring gap in the weekly review; each should map to a step in this guide.

Best practices that hold up as you scale

• Finish the getting-started checklist — Until the basics are done, the dashboard shows a Getting started checklist: a service type, a client, a job with a fee, and optional ledger posting.
• Pick the date range — The dashboard shows billed, collected, and outstanding for the range you choose, in the company currency.
• Read collections by mode and by person — Collected is split by payment mode, such as cash, UPI, and bank transfer, and by the person who entered each payment.
• Read billing by service type — Billed is split by service type, so you see which services earn the most in the period.
• Read outstanding by age — Outstanding is grouped by how long it has been owed.

Firms that keep the fee on the job, let Collections compute outstanding, and correct by reversal instead of editing a row keep their period totals and their trail intact.

How Biznsbook supports this workflow

Collections dashboard is part of Biznsbook Service Billing & Collections. Each client is a party you already keep, each job holds its fee, and each payment keeps who entered it, when, and how the client paid.

outstanding by age is part of Biznsbook Service Billing & Collections. Each client is a party you already keep, each job holds its fee, and each payment keeps who entered it, when, and how the client paid.

client statement is part of Biznsbook Service Billing & Collections. Each client is a party you already keep, each job holds its fee, and each payment keeps who entered it, when, and how the client paid.

Ledger posting is off until Collections settings turn it on, and only when Accounting or Finance is licensed. Outstanding is the fee plus any tax, minus the payments on the job. Collectors do not see fees, outstanding, other people’s entries, the dashboard, statements, the correction queue, or a journal.

Suggested implementation timeline

1. Week 1: Add your service types, check that clients exist as parties, and open jobs with fees.
2. Week 2: Start Collections dashboard with one collector and a handful of clients.
3. Week 3: Add the rest of the collectors and clear the dashboard attention items daily.
4. Week 4: Review billed, collected, and outstanding by age with the client statements.
5. Ongoing: Weekly review using what makes the numbers trustworthy and the dashboard.

Related guides

Start with track a service job and fee and record a client payment without showing the fee. Then bill a monthly retainer, split a fee into installments, and read billed, collected, and outstanding.

All guides: service billing & collections. Decision page: service billing software vs spreadsheets. Product page: Service Billing & Collections.

Billed, collected, and outstanding defined

Billed is the fees plus tax on jobs whose service date falls in the range, excluding cancelled jobs and opening-balance jobs. Collected is the payments dated in the range, excluding reversed payments and opening credits.

Outstanding is not limited to the range. It is every job’s fee plus tax minus the payments on it, minus unallocated advances per client. Jobs without a fee are left out until a fee is set.

Turning the dashboard into a weekly routine

Start with the attention chips: allocate waiting advances, decide corrections, and tick what reached the bank. Then read outstanding by age and open the statement of each client in the oldest bucket.

Compare collections by person week to week. A collector whose collections drop may simply have fewer visits, or may have a client who has stopped paying.

Use billing by service type when you set next year’s prices. It shows which services carry the firm.

From the dashboard to one client

The list of clients who still owe money is sorted by the amount outstanding. Opening a client gives the statement: every job with its fee or Fee not set, every payment with its reference and status, the outstanding, and any unallocated advance.

Print the statement for a meeting; the menus and buttons are hidden on paper. Or create a client portal link and copy it, so the client can see their own jobs and payments without a call.

A job without a fee shows Fee not set and stays out of the client total until you price it. That keeps outstanding honest while the price is still being agreed.

Who sees these numbers

The dashboard, statements, and payment register belong to people with the amounts or reports permission. A collector who records payments never reaches them; after login they land on Record a payment instead.

Every figure on the dashboard is built from the same jobs and payments the collectors record, so there is no separate report to keep in step.

Metrics to track monthly

• Billed for the date range
• Collected for the date range
• Outstanding, and outstanding older than 90 days
• Collections by payment mode
• Payments not yet reconciled

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Spreadsheets and notebooks vs Biznsbook Collections

Compare running this on spreadsheets with Biznsbook Collections dashboard and related capabilities.

What makes the numbers trustworthy

Outstanding is never typed. Payments are append-only: a correction reverses the original and writes a new entry, so a figure cannot change silently. Opening balances stay in outstanding without inflating the period, and every payment keeps who entered it and when.

Write this into your weekly owner routine and revisit it when you add collectors or new services.

Frequently asked questions

How this differs by industry