Reconciliation calculation

Expected vs actual cash balance

Understand the calculation CloseBook uses to classify a book as balanced, short or over.

Expected balance actual balance and difference in CloseBook
CloseBook keeps the working interface focused on books, transactions, reconciliation and closeout.

Expected balance

The expected balance is the amount that should remain according to the recorded funds and expenses. In CloseBook, the calculation includes the starting balance plus later Money In transactions, minus Money Out transactions.

Expected balance = starting balance + additional money in − total money outThe calculation is based on the transactions recorded in the book.

Actual balance

The actual balance is the amount physically counted or otherwise confirmed at the time of reconciliation. It is an observed amount, not a calculated amount. Entering the expected balance without counting defeats the purpose of reconciliation.

Difference

Difference = actual remaining cash − expected balanceCloseBook uses this direction when classifying the result.
DifferenceCloseBook statusInterpretation
$0.00BalancedActual and expected balances match.
NegativeShortageActual cash is lower than expected.
PositiveSurplusActual cash is higher than expected.

Example calculation

Worked example

Starting balance$1,000.00
Money In$300.00
Money Out$845.00
Expected$455.00

Reconciliation

Actual$450.00
Difference−$5.00
StatusShortage
Next stepDocument cause

Why a difference can appear

  • An expense was paid but not recorded.
  • A transaction amount was entered incorrectly.
  • Additional funding was received but not recorded.
  • Cash was returned, transferred or exchanged without a matching entry.
  • A bank or service fee affected the available amount.
  • The cash count itself was incorrect.

How to investigate a difference

Recount the cash

Repeat the physical count before changing transactions.

Review recent entries

Check dates, amounts, direction and duplicate transactions.

Check funding changes

Confirm that every top-up or returned amount is recorded correctly.

Review documentation

Use invoices, receipts and alternative evidence to identify omitted expenses.

Document the remaining difference

If the difference remains, record a factual explanation without guessing.

Turn a cash advance into a clear closeout report.

Record funds received and spent, compare the expected balance with the actual cash remaining, document shortages or surpluses, and export a clear closeout report.