Dashboard: cash and receivables

A ServiceTitan Cash and Receivables Dashboard: Invoiced, Collected, Overdue by Age, and the Finished Jobs Nobody Billed

The best month on the revenue chart can be the month the owner leaned on the credit line. Revenue counts the work. Cash counts the checks. A receivables dashboard sits between them and shows, every morning, how much of the first has turned into the second.

November 12, 2026 · 10 min read

dash.acmeplumbingandair.com · receivables, Monday
Open balances by days past due, computed from invoices
$7,450 is past 60 days, and 11 finished jobs have no bill
Sample
Current, not yet due$41,700
1 to 30 days past due$18,900
31 to 60 days past due$12,300
Over 60 days past due$7,450
Completed, not billed11 jobs
Illustrative: a sample receivables screen for a fictional plumbing and HVAC company

The short answer

A ServiceTitan cash and receivables dashboard reads invoices and payments through the API and shows what was invoiced, what was collected, what is overdue by age, and which completed jobs have no bill. ServiceTitan's API has no aging endpoint, so aging is computed from invoice due dates and open balances, with known limits. DataCram builds one from $575, plus hosting from $55 a month.

On this page
  1. Revenue is a promise until the deposit clears
  2. Five numbers that say whether Friday's payroll is comfortable
  3. Aging, built without an aging endpoint
  4. What computing aging yourself costs in accuracy
  5. Finished work with nothing billed, and deposits that are not yours yet
  6. An invented Monday, bucket by bucket
  7. When your accountant's aging is enough, and when it is not

Revenue is a promise until the deposit clears

ServiceTitan is clear about when revenue counts. Its dashboard metrics article, read on the ServiceTitan help center in November 2026, says "Most of the metrics related to revenue share the date filter of Job Completion Date." That is the right rule for judging the work. It says nothing about whether the customer has paid, and a shop can finish a record month with less in the bank than the month before.

ServiceTitan has receivables tools, and many offices live in them. One limit shows up in its own help center index, read in November 2026: an article titled "Can't export the AR Management screen to Excel"; the article itself gives ServiceTitan's current workaround. What owners tell us is simpler. They want five numbers on one screen before the coffee is gone, and they want to click any of them and see the customers.

That screen is what this page describes: invoiced, collected, overdue by age, finished but unbilled, and deposits held. It sits beside the other screens in our ServiceTitan dashboards section, and the general manager's daily version, which folds receivables in with capacity and callbacks, is on our general manager dashboard page.

Five numbers that say whether Friday's payroll is comfortable

Invoiced

Invoice totals by invoice date, this week and month to date. Revenue views use the subtotal, because sales tax is collected for the government, not earned.

Collected

Payments received in the same period, read from ServiceTitan's payments records. Set beside invoiced, it shows whether the gap is widening.

Overdue by age

Open balances sorted into current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due. Each bucket opens a customer list with phone numbers.

Completed, not billed

Finished jobs whose invoice still shows nothing to collect. The cheapest money in the business, because the work is already done.

Deposits held

Money taken before the work is finished, so a large install deposit is not mistaken for spare cash. How it is found depends on how your office records deposits.

Every tile is a list in disguise, and the owner's summary of the same figures is on our owner dashboard page. The over-90 bucket is a call sheet. The unbilled tile is a to-do list for whoever closes out invoices. The point of the screen is that nobody has to build those lists by hand on a Monday, and that the definition behind each one is written on a page anyone can read.

Aging, built without an aging endpoint

Here is the fact that shapes this whole dashboard. ServiceTitan's Accounting OpenAPI document, downloaded from the ServiceTitan Developer Portal in November 2026, has no accounts-receivable aging endpoint among its paths. What it does have is the invoice. Each invoice record carries invoiceDate, dueDate, subTotal, salesTax, total, balance, invoiceType, businessUnit, adjustmentToId, job, membershipId, paidOn and its items. Aging gets computed from those.

  1. 1

    Pull every invoice with money still owed

    Through the invoices export feed, keeping those whose balance is above zero.

  2. 2

    Choose the clock

    If your office sets real terms, age from dueDate. If every invoice is due on receipt, age from invoiceDate. Write the choice on the screen.

  3. 3

    Count the days

    Today minus the chosen date gives days past due, and the open balance drops into its bucket.

  4. 4

    Decide what to do with adjustments

    An adjustment invoice points back to the original through adjustmentToId. We agree with your office whether to net it against the original before aging, and apply that rule every time.

  5. 5

    Group it the way you collect

    By customer, by business unit, or by residential and commercial, so each list lands with the person who chases it.

Warm shallow-focus desk of an office manager, a dark tablet screen beside a stack of plain paper, a coffee mug and a clipboard, hands holding a pen
Aging starts from the same paper trail the office already keeps, sorted by how long each balance has waited.

What computing aging yourself costs in accuracy

A computed aging report is useful and imperfect, and you should know where before you trust it. The table lists what we have to decide, and what each choice costs.

Accuracy limits of aging computed from ServiceTitan invoice records, and how our dashboard handles each
LimitWhy it happensHow we handle it
Today's balance onlyThe invoice's balance is what is owed now, not what was owed at last month's closeAging as of a past date means replaying payments by date; we confirm what your payment records carry before promising it
A short delayServiceTitan's export API page says data appears 15 minutes after a change unless includeRecentChanges is set, as of November 2026Every screen shows when it last refreshed
AdjustmentsCredits and corrections live on separate invoices linked by adjustmentToIdOne netting rule, agreed in writing, applied everywhere
Sales taxtotal and balance include tax; subTotal does notReceivables use what the customer owes; revenue views use the subtotal
Partial paymentsA customer pays half; the balance drops but the due date staysThe remaining balance keeps aging from the original date
Not ServiceTitan's own reportOur arithmetic is ours, so totals can differ from ServiceTitan's AR screensReconcile against ServiceTitan's AR Transactions By Customer report at each month end

History is the hard part. A trend line of total overdue, month by month, means keeping yesterday's figures. ServiceTitan's API Terms of Use, last updated April 15, 2026, say Content from the APIs must not be stored or cached "for longer than 24 hours," except as the Terms or documentation permit, and what we read does not settle whether a stored daily total counts as Content. We do not interpret that clause for you. Confirm with your agreement and with ServiceTitan before asking for history. The terms also say ServiceTitan "does not promise any particular uptime or provide SLAs," which is why the refresh time is always on screen.

An aging report you computed yourself is worth having, as long as it says so on the label.

Finished work with nothing billed, and deposits that are not yours yet

The unbilled tile is where a dashboard pays for itself fastest, because the money is already earned. Our definition, which is DataCram's and not ServiceTitan's, starts from the job record: jobs with a completed jobStatus and a completedOn date, whose linked invoice still shows a total of zero. The details matter, so we settle them with the office first.

  • No Charge jobs are left out. ServiceTitan's glossary, read November 2026, says "Recall and warranty jobs are marked as No charge by default," and the job record has a noCharge field. A recall with no bill is not a mistake.
  • Progress-billed projects need their own rule. ServiceTitan files progress billing under Non-Job Revenue, so a large install may be billed in stages that a single-job check misreads.
  • A grace period applies. A job finished at 4 p.m. and invoiced the next morning is not a problem. We flag jobs left unbilled past a window the owner sets.
  • Each flag shows who. Technician, business unit and completion date, so the list goes to the person who can fix it.

Deposits work the other way: money in the bank that still owes work. Payments are readable through ServiceTitan's payments endpoint and export feed, but how your office records a deposit, against which invoice and job, decides how the dashboard finds it. We read a month of your own records before writing that rule. Customers paying online can pay part of a balance; ServiceTitan's online payments guide, read October 2026, says customers can pay part of the balance, "at least $1." Our customer portal page covers putting those links on your website.

An invented Monday, bucket by bucket

These figures belong to a made-up plumbing and HVAC company. They show the shape of the screen, not anyone's results, and nothing here suggests what a normal receivables balance looks like.

Illustration only: a fictional company's receivables screen on a Monday morning
LineCountAmountWhat happens next
Invoiced last week142 invoices$96,400Compare with collected
Collected last week131 payments$81,250A $15,150 gap; check the large commercial invoices
Current, not yet due38 invoices$41,700Nothing yet
1 to 30 days past due22 invoices$18,900Reminder emails from the office
31 to 60 days past due9 invoices$12,300Phone calls this week
Over 60 days past due6 invoices$7,450Owner decides on each one
Completed, not billed11 jobsUnknown until invoicedClose out today

Read the last row first. Eleven finished jobs with no invoice is a process problem, and it is fixed by lunch. Then the gap between invoiced and collected: one week means little, a gap that widens for six weeks means something. Revenue per job lives on our average ticket explainer, and whether those jobs made money once costs come out is on our gross margin per job guide.

When your accountant's aging is enough, and when it is not

We price the receivables screen from $575 to build, as of November 2026, with complexity setting the final figure and that figure fixed in writing before work starts. Hosting follows at $55 a month and up. The ServiceTitan API connection is switched on the same day. One company and one aging clock sit near the floor; several business units, progress billing rules or month-end history push the price up. See the full offer on our custom ServiceTitan dashboards page; the work is part of our API integrations service. How the data moves is on our API data guide.

Access depends on ServiceTitan's package rules. Its Developer Portal's integration paths page, read October 2026, says customer-built apps require being "on the Works or Ent Plus package." Ask your account manager which applies to you. DataCram has no affiliation or partnership with ServiceTitan.

Your books may already cover it if

  • Your accounting system holds receivables and someone reviews its aging weekly
  • Your accountant's aging is the number the bank asks for, and a second one would confuse things
  • You bill few invoices on terms and most customers pay on site
  • Unbilled jobs are already caught at day's end

Build the screen if

  • Nobody can say what is over 60 days without running a report
  • Finished jobs sit unbilled for days
  • Commercial invoices on terms are growing
  • You want collected and invoiced side by side every morning

If your books live in QuickBooks, our QuickBooks integration page covers how that side connects, and our invoicing and payments module shows billing built from scratch, for companies replacing ServiceTitan rather than keeping it. Owners who want a second pair of eyes on the cash each month can add our monthly numbers review, from $575 a month with no long contract. DataCram is a San Antonio, Texas studio, building for the web since 1999; see who we are and what we have built, or call (210) 346-0848.

Questions owners ask about ServiceTitan dashboards and numbers

Not in the Accounting OpenAPI document we downloaded in November 2026. The API does expose invoices, with invoice date, due date, subtotal, sales tax, total, balance and adjustment links, and payments. A custom dashboard computes aging from those records, sorting open balances into buckets by days past the due or invoice date.

Not always to the dollar. Our arithmetic uses our written rules for adjustments, partial payments and which date starts the clock, so totals can differ. We reconcile against ServiceTitan's AR Transactions By Customer report at month end and show any difference, rather than claiming the two are identical.

Only with care. An invoice's balance is what is owed now, so a past date means replaying payments by date or keeping month-end figures. ServiceTitan's API Terms limit storing Content to 24 hours except as permitted, and whether a stored total counts is not settled in what we read. Confirm with your agreement first.

By our definition: completed jobs whose linked invoice still shows a zero total, excluding No Charge jobs such as recalls and warranty work, after a grace window the owner sets. Progress-billed projects get their own rule. Each flagged job shows the technician and business unit, so the list goes to someone who can fix it.

No. Your accounting system remains the record your accountant and bank rely on. A dashboard on ServiceTitan data is an operating screen: what was invoiced, collected, overdue and unbilled this week, with lists to act on. If your books already give you that weekly, you may not need it.

Builds begin at $575 as of November 2026, with the final figure set by complexity and fixed in writing before work starts. Hosting is from $55 a month. The API connection is live the same day. Month-end history, progress billing rules and several business units are what raise the price.

Keep reading

Free · No obligation

See what is owed before the coffee goes cold

Tell us how you bill and how you chase payment today. Someone at DataCram writes back with the aging rules we would use, the limits, and a fixed estimate.

Which of these sounds like you? (pick any)

Rather talk now? Call (210) 346-0848.

CallGet a quote