Build the analysis yourself from any columns: estimates for open rows, lag curves, formulas, weights, tables and projections.
Your file
Columns your file needs
Must have
At least one column of numbers
Adds detail
DatesProduct, customer or any names to group by
Any CSV or Excel export works; you choose what each column is used for.
Names don’t have to match exactly. CSV, Excel or PDF.
Works with any CSV or Excel file, or several with the same columns. You decide what to work out, which columns and conditions count, how similar rows are matched, and how much each method weighs. The answer updates as you go, every step shows its math, and the model can be saved and run again on next month's file.
Custom Model: Can I build the analysis myself?
Estimates for open rows, lag curves, totals, formulas, weighted blends, tables and projections from any columns, tested on your own history. You need any spreadsheet with numbers. Upload and the answer appears, in your browser with no account and nothing uploaded. Once the answer is up you can also download the report in Excel, with live formulas.
The ready-made models each answer one question. This one answers yours. Upload any spreadsheet, or several with the same columns, and add steps from six kinds: Summarize (a total, a table by group or a list of rows), Calculate (a formula or a number you set), Project, Mix by weight, Estimate open rows and Collections timing. Your steps sit in a list beside the one you are editing, each with its current value, the answer updates as you go, estimates are tested on your own settled rows, and the whole model can be saved and run again on next month’s file.
How to build a model
Upload a CSV or Excel file, or several with the same columns.
Add a step from the six kinds. It arrives with the usual choices made, ready to change, and the list on the left keeps every step and its value in view.
Mark the number that is your answer, save the model for next month, and download it in Excel with live formulas.
Frequently asked questions
What can I build with it?
Anything your columns support. Totals and averages with conditions, new columns worked out on every row, formulas over those numbers, assumptions with sliders, weighted blends, tables by one or two groups, lists of rows, projections to a future month, an estimate for every open row learned from similar settled rows, and a lag curve that says how fast money arrives after billing and what lands in a month you choose.
How does the estimate for open rows work?
You say which rows are settled (for example Status is Paid), what was received and billed on them, and which columns make two rows alike, most specific first (say payer, level of care and facility). Each open row takes the typical rate of the settled rows that match on all of those; if too few match, the next broader match is tried, down to everything settled. You choose the typical value: median, most common, average, trimmed average, a blend, the most recent, or pooled. The estimate is tested on your newest settled rows and the miss is shown.
What is the lag curve?
From rows that have both a billing date and a payment date, it measures what share of a month’s money arrives the same month, the next month and so on, and what share of billing is collected in all. It then projects a target month from each earlier month’s billing, and writes every row its own share for that month so you can combine it with an estimate.
Do I need to know Excel formulas?
No. Each step is a short sentence with the usual choice already made, like “Show the total of Charge Amount for each Payer”, and conditions are a tap on a value such as Open. Formulas are only needed for Calculate steps, and every column and step is a button that drops into the box.
Can I use more than one file?
Yes. Add files with the same columns, such as other locations or last month’s export, and they are read as one table with a Source file column, so an estimate can fall back to other locations when one has no history.
Can I run the same model next month?
Yes. Save the model on this device, or download it as a model file. When you drop in a file with the same columns, the saved model is offered and runs on the new rows.
Is the math checkable?
Every step shows how it was worked out, estimates carry a backtest, and the Excel download puts your rows on a Data sheet with every column the model made, each step as a live formula wherever Excel has one, and a sheet per table, estimate and lag curve.