Sales recorded by the POS, tax collected from customers, tax reported on a return and cash remitted are separate figures. Reconcile each on a matched basis before using the records in an acquisition. This workbook organizes entered classifications and differences; it does not decide taxability, calculate a filing liability or establish tax clearance.
Define the entity, locality and filing period
Start with a specific operator, site, period and accounting record set. Obtain detailed POS exports, the category/tax configuration, refunds, prepaid-product records, exemption support, filed returns and schedules, ledger accounts and payments. A deposit or merchant payout is not a substitute for this map: deposits can be net of fees and contain receipts from another reporting period.
New York’s recordkeeping bulletin describes records that connect source transactions to books and returns and support their tax treatment. Preserve the underlying detail and audit trail, including when systems change. This public worksheet is an index and arithmetic aid; it is not the underlying auditable record set.
Describe the actual service and payment arrangement
Do not classify a category from a label such as “automatic,” “self-service” or “fleet.” Record what was supplied, any personnel assistance, how equipment was activated and paid for, and the evidence supporting the treatment. Enter the rate applicable to the actual locality and period after review. The tool supplies no current rate, default exemption or legal classification.
New York’s car-wash bulletin distinguishes service assistance, payment/activation and prepaid arrangements. It also addresses particular resale situations. A commercial customer is not automatically exempt. Keep a service certificate, face-value gift product and membership arrangement distinct; do not transfer a tax conclusion from one product to another.
Ask the tax adviser how sales, redemptions, credits and purchased supplies should be treated. Use the separate transaction-tax and allocation guide for the business sale. That transaction analysis does not replace the operator’s sales-tax record review.
Build a traceable sales-category map
Each row contains a unique category ID, description, net sales excluding collected tax, entered treatment, recorded tax and evidence. A taxable row also needs an entered rate. Missing rate or evidence prevents a supported mapped expectation. An unresolved row stays in the sales population and is reported separately.
Use signed refund rows and preserve their source periods. The sum of absolute unresolved net-row amounts can still hide transactions that were netted before entry, so separate positive sales and refunds when gross exposure matters. Do not count the same prepaid sale and its later redemption as two new sales without the applicable accounting and tax explanation.
Mapped tax expectation = Σ entered taxable base × entered rate ÷ 100 Mapped collection difference = recorded tax on mapped rows − mapped expectation Closing payable = opening payable + booked tax + signed adjustments − remittances
Aggregate multiplication may differ from transaction-level rounding. Record the reason and retain source-level support rather than declare an arbitrary tolerance acceptable. A complete-population declaration is your statement of scope, not verification by the website.
Work the fictional sales-tax example
This invented case uses an 8% teaching input that is not a quoted New York jurisdiction rate. Mapped taxable sales of $80,000 imply $6,400. Recorded tax on those rows is $6,200, leaving a −$200 collection comparison. Another $10,000 is entered as exempt with fictional evidence, and $5,000 remains unresolved. The workbook withholds a complete expectation even though all rows have been entered.
Separately, opening payable of $2,000 plus $6,200 booked tax less $6,000 remitted gives a $2,200 closing balance. That matches the fictional ledger. The payable tie-out does not resolve the category difference or prove that the return is correct. It simply explains the movement in that account under the entered definitions.
Review filed figures without manufacturing a return
The optional comparison table accepts a labeled field from the books, an equivalent filed figure and an explained adjustment. Identify the actual schedule, field and period. Credits, use tax, amendments, multiple locations and tax-inclusive reporting may require additional schedules outside this model. Never compare an all-in return total with one narrow POS category and call the difference an underpayment.
For each open item, state the amount known, evidence missing, adviser responsible and next action. A negative payable can be an entered credit balance; the tool does not establish entitlement to a refund. Blank figures remain unknown rather than becoming zero.
Connect the review to diligence and closing
Use the revenue verification case for settlement timing and the merchant tool for fees and reserves. Coordinate unresolved tax matters with the New York bulk-sale review. A balanced workbook does not satisfy that process or authorize payment or possession.
The editor checks official sources quarterly and before release. Actual classifications, rates, filing treatment and transaction consequences require the tax adviser’s current review.
Download the fictional case v1
Sources and scope
Official and original sources checked October 31, 2026. These sources support the identified rules and methods; they do not verify a particular business or property.
- New York Tax — New York Tax — Car Wash Services, TB-ST-105The bulletin distinguishes assistance, equipment activation/payment, prepaid products and resale arrangements. An automated-wash label alone does not resolve tax treatment. General published guidance, not a ruling on a particular service or current contract. Recheck developments and obtain adviser classification before publication or reliance.
- New York Tax — New York Tax — Recordkeeping Requirements, TB-ST-770Detailed records should connect source transactions with books and returns and support tax status. POS summaries alone do not replace transaction evidence. A balanced worksheet does not prove the underlying records are complete or that tax treatment is correct.
Continue your review
Verify the revenue · Normalize earnings · Model the cash flow