Signal Check · free
Three numbers about your cash, from one invoice export
Export your invoice list from QuickBooks, Xero, or FreshBooks and drop it in. In a couple of minutes you’ll see how much cash is stuck past 60 days, how long customers take to pay you, and how much of your revenue rides on your five biggest customers.
Your file never leaves your computer.
It’s read and added up right here in this browser tab. Nothing is uploaded. If you ask for the one-page PDF afterward, only the finished numbers are sent.
Drag your invoice export here, or
CSV or Excel, up to 10 MB. You’ll check the columns before any numbers appear.
What you’ll see
Three numbers, each with the arithmetic behind it.
Cash stuck past 60 days
What customers still owe you on invoices more than 60 days past due, with the aging behind it and how many customers hold it.
Days to get paid
The typical time from invoice to payment. If your file has no paid dates, an estimate from what's open against recent invoicing, labeled as one.
Top-5 customer share
How much of the last 12 months' invoicing came from your five largest customers, and how much from the single largest.
I’m Rob Neal. I spent sixteen years in banking, where the numbers had to be right. This check is built the same way: every number comes from rows in your own file, and it tells you what it skipped and why.
Getting your file out
Export steps for each system
QuickBooks Online
Recommended · Invoice List by Date
- Go to Reports and search for "Invoice List". Open "Invoice List by Date".
- Set the report period to "All Dates", or at least the last 12 months.
- Select "Export/Print", then "Export to Excel".
Due dates and open balances are all the check needs. QuickBooks doesn't list paid dates here, so days to get paid will be an estimate.
Or · Accounts receivable aging detail
- Go to Reports and search for "aging detail". Open "Accounts receivable aging detail".
- Leave the date set to today.
- Select "Export/Print", then "Export to Excel".
Lists only what's still unpaid, so it shows cash stuck past 60 days but not how fast you get paid or your customer share.
QuickBooks Desktop
Recommended · Transaction Detail (invoices)
- Go to Reports, then Custom Reports, then Transaction Detail.
- On the Display tab, set the dates to at least the last 12 months, set Total by to None, and tick Name, Num, Due Date, Amount, and Open Balance. On the Filters tab, choose Transaction Type, then Invoice. Select OK.
- Select "Excel", then "Create New Worksheet", then "Export", and save the workbook.
Lists every invoice, paid or not, so all three numbers work. Days to get paid will be an estimate.
Or · A/R Aging Detail
- Go to Reports, then Customers & Receivables, then A/R Aging Detail.
- Leave the date set to today.
- Select "Excel", then "Create New Worksheet", then "Export", and save the workbook.
Lists only what's still unpaid, so it shows cash stuck past 60 days but not how fast you get paid or your customer share.
Xero
Recommended · Receivable Invoice Summary
- Go to Reporting, then All reports, and open Receivable Invoice Summary.
- Set the dates to cover at least the last 12 months. Under Columns, add Due Date, Status, Balance, and Last Payment Date, then select Update.
- Select "Export", then Excel.
One row per invoice with the date it was last paid, so days to get paid is measured rather than estimated.
Or · Invoices export
- Go to Sales, then Invoices, and open the All tab.
- Use Search to set a start and end date covering the last 12 months. One export holds up to 500 invoices.
- Select "Export" to download a CSV.
One row per invoice line, which the check adds up by invoice number. No paid dates, so days to get paid will be an estimate.
FreshBooks
Recommended · Invoice Details
- Go to Reports and open Invoice Details.
- Under Settings, then Filters, choose a custom date range covering at least the last 12 months, and keep every invoice status.
- Select "More Actions", then "Export for Excel". It downloads a CSV.
Includes the date each invoice was paid, so days to get paid is measured, not estimated.
Something else
Recommended · Your invoice list
- Export your invoices as a CSV or Excel file.
- It needs a customer, an invoice date, and an amount for each invoice.
- Add either an open balance or a paid date column if your system has one.
You'll confirm which column is which before any numbers appear.
Common questions
About the check
- Is my file uploaded?
- No. The check reads your file inside this browser tab and does the arithmetic there. You can watch your browser's network activity while it runs: the file never goes anywhere. If you ask for the one-page PDF, only the finished numbers are sent, never the file, its rows, or your customers' names.
- Which files work?
- A CSV or Excel export of your invoices. It needs a customer, an invoice date, and an amount for each invoice, plus either an open balance or a paid date. QuickBooks Online, QuickBooks Desktop, Xero, and FreshBooks reports are recognized automatically; anything else works once you confirm which column is which.
- My file has no due dates. Does it still work?
- Yes. You tell the check your usual payment terms (net 30 unless you change it), and each due date becomes the invoice date plus those terms. The results say so.
- Why do I have to confirm the columns?
- Because a wrong column gives a wrong number, and a confident wrong number is worse than none. The check pre-fills what it recognizes and flags anything it had to guess, and the results list every row it skipped and why.
- Is this accounting advice?
- No. It's plain arithmetic on one export, meant to show where to look. It doesn't know about payments that haven't been recorded yet, disputes, or anything outside the file.
Want the full picture, with jobs, quotes, and costs joined to your invoices? See what Summit Signal looks at.