Adds a Tax Line Mapping tab with entity-specific mappings (Schedule C, 1120S, or 1065) — maps ~40 canonical categories to actual tax form lines
Adds TaxLine column to all sorted tabs using XLOOKUP formulas that reference the mapping sheet
Creates a Fed_TIS summary tab with SUMIFS formulas totaling each tax line across all sorted tabs (bank + CC)
Builds a Reconciliation Check comparing Fed_TIS totals against Bank & CC Summary amounts
Calculates out-of-period adjustments for bank and CC billing periods that extend outside the tax year
Generates a Super Reconciliation — detailed category-by-category bridge between sorted tab subtotals and Fed_TIS lines
Input: a Smart Labeler output file with sorted tabs. Output filename: TIS_ClientName_TaxYear_timestamp.xlsx
Revenue Forecast
A month-by-month P&L for the current year, which months are losing money and why,
and a projection of the months still to come. Add last year's workbook and it compares
the two and forecasts on the season rather than a flat average.
Monthly P&L
Solid bars are months that have closed. Faded bars are projections.
RevenueCostsNet
Month by month
Where the money went
For each month in the red, the categories furthest above their own typical month.
Click one to see the transactions behind it.
Minimum monthly survival number
Costs that turned up in at least three quarters of the months observed, each taken at
its median month so one annual payment is not read as a monthly obligation.
What a profit costs the owner, federal plus New York State and City,
under each entity type. Run a Tax Summary first and the net income
comes across on its own.
Quarterly Payments
Four equal installments — the safe harbour, and what
almost everyone pays. Pick a quarter to see what it covers
and when it is due.
How It Breaks Down
Where This Profit Came From
Every line of the Tax Summary this estimate was built on. The net
income at the bottom is the figure being taxed above.
The Same Profit, Every Entity
Cheapest first. A C‑corporation usually looks cheapest here because
only the company’s bill is in it — what the owner then takes out is
taxed again on their own return.
What This Leaves Out
An estimate is worth what its assumptions are worth. These are the
ones that matter for this profit.
Could not build the estimate
Generating Tax Summary...
Payment Required
TIS Generator — 1 Run
Pay with Crypto
Price: 0.1 SOL
Pay with Card
— OR join our Token Access Program by holding PnP tokens —
Buy $PNP