FinanceFormula-based · Runs in your browser

Checkbook Balance Calculator

Reconcile a bank statement balance with outstanding checks, deposits in transit, fees, interest, and the check register.

Preparing saved example…

Inputs

Enter the values you know. Optional fields may be left empty.

Local save controls below
Required
$
Required
$
Required
$
Required
$
Required
$
Required
$

Result

Updates as valid inputs change.

Calculated locally
Adjusted bank balance
Adjusted register balance
Reconciliation difference
Reconciliation status

Saved locally, explained clearly

Drafts, calculations, scenarios, and workflow progress stay in this browser unless you export them.

Opening local database…

Calculation steps

Follow what happened from the selected formula to the displayed answer.

Show substituted values and intermediate working
Calculate current inputs to see the working.
  1. 1

    Formula selected

    The calculator uses the following formula or method.

    adjusted bank = statement + deposits in transit − outstanding checks; adjusted register = register + credits − fees

  2. 2

    Values entered

    Your values are placed into the calculation.

    Enter values to see what is used in this step.

  3. 3

    Result calculated

    The formula or method produces the following result values.

    Results will appear after a successful calculation.

  4. 4

    Answer formatted

    Displayed values are rounded and formatted using each output’s configured precision.

Scenario comparison

Save working scenarios, then select two or three to compare. Formula versions and inputs remain visible.

No scenarios saved for this calculator yet.

Recent calculations

Successful calculations are retained locally according to your privacy settings.

No local history for this calculator yet.

Data and privacy

What this calculator does

Reconcile a bank statement balance with outstanding checks, deposits in transit, fees, interest, and the check register.

How it works

The calculator evaluates adjusted bank = statement + deposits in transit − outstanding checks; adjusted register = register + credits − fees. Inputs are checked before calculation, and invalid values such as zero denominators or out-of-range selections produce a clear error instead of a misleading result.

Input query strings and outputs

Use an input name in this page’s URL as ?name=value, and join additional inputs with &. Portable shared links may instead use the compact ?ac= state parameter.

Input query strings

6
  • ?statementBalance= Bank statement ending balance

    Money · Required · Default: 2,500

  • ?depositsInTransit= Deposits not on statement

    Money · Required · Default: 750

  • ?outstandingChecks= Checks not cleared

    Money · Required · Default: 425

  • ?bankInterest= Interest or credits not in register

    Money · Required · Default: 5

  • ?bankFees= Fees or debits not in register

    Money · Required · Default: 12

  • ?registerBalance= Check register balance before adjustments

    Money · Required · Default: 2,820

Outputs

4
  • adjustedBankBalance Adjusted bank balance

    Currency · Primary output

  • adjustedRegisterBalance Adjusted register balance

    Currency

  • difference Reconciliation difference

    Currency

  • status Reconciliation status

    Text

Inputs and results

The inputs are Bank statement ending balance, Deposits not on statement, Checks not cleared, Interest or credits not in register, Fees or debits not in register, Check register balance before adjustments. Results include Adjusted bank balance, Adjusted register balance, Reconciliation difference, Reconciliation status.

Sources
  • No external reference is listed for this calculator. Its formula and variable definitions are shown above.
Limitations
  • Estimates use the rates, timing, and assumptions entered. Fees, taxes, lender rules, and future changes are included only where explicitly shown.