Cash balancing and shift closing

Enter coin and banknote quantities to calculate cash on hand, variance from ledger and estimated sales.

If calculation UI does not appear, reload with JavaScript enabled. Related context links below remain available.

Calculation specification

Reviewed on:

Formula basis

denominationTotalYen=Σ(denomination×count for that denomination), countedCashYen=denominationTotalYen+otherYen, differenceYen=countedCashYen−expectedCashYen, and estimatedCashSalesYen=countedCashYen−openingFloatYen+cashPaidOutYen. Amounts are rounded to whole yen, and counts are truncated to nonnegative integers.

Calculation method

This arithmetic cash-register closing tool totals the counts of every denomination from ¥1 to ¥10,000 plus otherYen, calculates the difference from expectedCashYen, and estimates cash sales from openingFloatYen and cashPaidOutYen.

Exclusions and checks required

  • Because expectedCashYen is not retrieved automatically from the ledger and the entered value is compared as-is, the tool cannot detect cash inflows, outflows, or opening-float entries omitted from the ledger.
  • estimatedCashSalesYen does not separately handle cash received during business, change exchanges, bank deposits, refunds, or tips; it uses only countedCashYen−openingFloatYen+cashPaidOutYen.
  • The tool does not support authenticating banknotes or coins, foreign currencies, gift certificates, electronic money, or reconciliation by safe or staff member.

Example input:：Counting every denomination to produce a ¥0 ledger difference

count1
5
count5
1
count10
2
count50
1
count100
3
count500
2
count1000
10
count2000
0
count5000
1
count10000
10
otherYen
500
expectedCashYen
116880
openingFloatYen
30000
cashPaidOutYen
2000

The cash on hand is ¥116,880, the ledger difference is ¥0, and estimated cash sales are ¥88,880, but this does not prove that the ledger entries are correct or that accounting has been completed.

FAQ

Who is this calculator for? Cash balancing and shift closing

Enter coin and banknote quantities to calculate cash on hand, variance from ledger and estimated sales.

What values should I enter?

Applies to: Cash & trading / Cash on hand = Σ(denomination × count) + other amount. Estimated sales = cash on hand − float + cash paid out during business.

How should I interpret this estimate?

This arithmetic cash-register closing tool totals the counts of every denomination from ¥1 to ¥10,000 plus otherYen, calculates the difference from expectedCashYen, and estimates cash sales from openingFloatYen and cashPaidOutYen.

How to use

  1. Enter your input values and press Calculate.
  2. Review the result and compare it with expected context.
  3. denominationTotalYen=Σ(denomination×count for that denomination), countedCashYen=denominationTotalYen+otherYen, differenceYen=countedCashYen−expectedCashYen, and estimatedCashSalesYen=countedCashYen−openingFloatYen+cashPaidOutYen. Amounts are rounded to whole yen, and counts are truncated to nonnegative integers.