Work sample · Creative agency
Northline Creative
July at a glance
Six measures: the month, the receivable, and what the next thirteen weeks of cash look like. Every change carries a sign and a word, so favorable and unfavorable never depend on the color.
Where the month came from
Every series here is drawn from the same invoices as the tables below.
Ask this report
Demo: preset questions. On an engagement this box answers anything, from the tied facts only.
Profit, receivables and cash
Revenue split two ways, the aging behind it, and the thirteen weeks in front. Open any client to follow the money down to the invoice and its lines.
Revenue and gross margin by service line
Profitability by client
AR aging by client at 7/31/2026
Thirteen weeks of cash from 8/1/2026
What if
The two largest open balances are also two of the slower payers. Turn the toggle to push both of them out and watch the low week move.
Notes
Written from the numbers on this page and stored with them, so a note cannot disagree with the schedule behind it.
Tie-out checks
Each check names both sides and shows whether they agree. The script that builds this data refuses to write a file when any of them fails.
How this was built
Source
System exports: rent roll, GL detail, trial balance, invoices. Nothing hand-keyed.
Pipeline
A script loads the exports, checks them, and computes every figure once. The same script runs every month.
Tie-out
Rent roll to revenue, subledgers to GL, entity totals to consolidated. Shown on the page, not assumed.
Presentation
An interactive page you can open on a phone, plus a PDF for the board or the lender.
Data
The data behind this page: Northline Creative JSONnorthline-invoices.csvnorthline-payments.csv