Search Ctrl K
Home / Tools
THE FEUTEX TOOLKIT

Cash Till Reconciliation

Reconcile opening float, cash sales, refunds, payouts and counted closing cash.

Ecommerce workspace● Runs in your browser
01 Your input
02 Your result
View or copy raw result data
FormulaExpected = opening+sales-refunds-payouts; Variance = counted-opening-sales+refunds+payouts

Made for real tasks

  • Reconcile opening float, cash sales, refunds, payouts and counted closing cash.
  • Compare a revised operating scenario with the current plan.
Explore step-by-step workflows →

Worked example

Inputs

Opening
100 currency
Sales
500 currency
Refunds
30 currency
Payouts
20 currency
Counted
545 currency

Expected results

Expected
550 currency
Variance
-5 currency

Load the example in the workspace to reproduce these results. Display rounding does not change the underlying calculation.

How to use this tool

  1. Enter the measured quantities and planning assumptions in the displayed units.
  2. Run the calculation, then compare the result with your available capacity or actual records.
  3. Change one assumption at a time to compare operating scenarios.

Try this example

{
  "opening": 100,
  "sales": 500,
  "refunds": 30,
  "payouts": 20,
  "counted": 545
}

Accuracy and scope

All movements must use the same till and reconciliation period. Sales, refunds and payouts are cash-only; negative variance is a shortage.

Is my data uploaded?

This tool runs locally in your browser. Input and output are not sent to a processing server. Copy or download your result before leaving the page.