Mathproven

Petty cash reconciliation

Type the fund, how many of each bill and coin are in the box, and the receipts paid out since the last replenishment, each with its expense account. The page multiplies out the count, totals the receipts by account, and proves cash plus receipts against the fund to the cent: what is over or short, the replenishment that brings the cash back up to the fund, and the journal entry lines that record it, debits equal to credits. It reports arithmetic on the figures and account names typed.

Everything is calculated in your browser. Nothing typed here is uploaded; a draft is kept in this browser's own storage until you clear the form. This page works from typed figures. It does not read photos of receipts, PDF files, or scans.

Petty cash fundCash countedReceiptsShortProves cash plus receipts against the fund
The fund, made up of the cash counted, the receipts, and any over or short.

The fund is the fixed amount the box holds in cash and receipts together. The two account names are used on the journal entry lines as typed.

Count the box

How many of each bill and coin are in the box. A blank count is zero; a roll of coins is counted as the coins inside it.

Bill or coinCountAmount

Receipts

One row for each receipt or voucher paid out of the box since the last replenishment, typed as a positive amount, with its expense account.

DateDescriptionExpense accountAmount

The reconciliation appears here once the fund is typed.

What gets checked

Your numbersThe mathThe checksVerifiedNot verified
A result that fails a check is marked not verified. It is never shown as correct.

How it works

  1. Enter the fund. Type the fund (the fixed amount the box holds in cash and receipts), the date of the count, and the names of the two accounts the journal entry uses: the one the replenishment is paid from and the one for an over or short. Both names are filled in as Cash and Cash over and short and can be changed to the names in your own chart of accounts.
  2. Count the box. Type how many of each bill and coin are in the box. A blank count is zero. Each line is multiplied out as you type, and the bills, the coins, and the cash counted are shown.
  3. List the receipts. Add one row for each receipt or voucher paid out of the box since the last replenishment: the date, what it was for, the expense account, and the amount. Receipts with the same account, in any mix of capitals, are totalled together.
  4. Read the proof and the entry. The page shows cash plus receipts against the fund, the amount over or short, the replenishment, and the journal entry lines with their totals. Print the page or save it as a PDF, or download Excel or CSV with the count, the receipts, the entry, and the certificate.

Worked example

A made-up petty cash fund of $300.00 at Example Print Shop, counted on April 30, 2026. The box holds 7 twenties, 4 tens, 3 fives, 22 ones, 13 quarters, 6 dimes, 4 nickels, and 7 pennies, and four receipts: postage 18.40 on April 3, printer paper 32.15 on April 8, parking at the bank 6.00 on April 15, and cleaning supplies 21.48 on April 22.

LineHow it is builtAmount
$20 bills7 × $20.00$140.00
$10 bills4 × $10.00$40.00
$5 bills3 × $5.00$15.00
$1 bills22 × $1.00$22.00
Quarters (25¢)13 × $0.25$3.25
Dimes (10¢)6 × $0.10$0.60
Nickels (5¢)4 × $0.05$0.20
Pennies (1¢)7 × $0.01$0.07
Cash countedBills 217.00 + coins 4.12$221.12
Postage1 receipt$18.40
Office supplies2 receipts: 32.15 + 21.48$53.63
Parking and tolls1 receipt$6.00
Receipts18.40 + 53.63 + 6.00$78.03
Cash plus receipts221.12 + 78.03$299.15
Petty cash fundThe fixed amount of the fund$300.00
Short299.15 − 300.00-$0.85
Replenishment: fund − cash counted300.00 − 221.12, the same as 78.03 + 0.85$78.88
Journal: PostageDebit$18.40
Journal: Office suppliesDebit$53.63
Journal: Parking and tollsDebit$6.00
Journal: Cash over and shortDebit, the shortage$0.85
Journal: CashCredit, the replenishment$78.88
Debits and credits18.40 + 53.63 + 6.00 + 0.85 = 78.88$78.88

Cash of $221.12 plus receipts of $78.03 comes to $299.15, so the box is short $0.85 against the $300.00 fund. The replenishment is $78.88, which brings the cash back to $300.00, and the journal entry debits the three expense accounts and Cash over and short and credits Cash, $78.88 on each side. Had the box held one more $1 bill, the cash would be $222.12, the box would be over $0.15, the replenishment would be $77.88, and the $0.15 would be a credit to Cash over and short.

The example uses made-up names and numbers.

Questions

What does over or short mean here?

It is cash counted plus receipts, minus the fund. When the box holds more than the fund accounts for, the difference is an overage; when it holds less, a shortage. The page shows the amount to the cent and warns about any amount, however small. It does not say why the cash differs.

Why is the replenishment not the same as the receipts?

The replenishment is what brings the cash back up to the fund: the fund minus the cash counted. With no over or short it equals the receipts. A shortage adds to it and an overage takes from it, so the receipts plus the shortage, or minus the overage, is the same amount. The page works it out both ways and checks they agree.

Where do the journal entry lines come from?

Each expense account typed on the receipts is a debit of its receipts total. A shortage is a debit to the over-and-short account and an overage a credit to it. The replenishment is a credit to the cash account. The names are the ones typed on the page, and the entry is arithmetic on the figures typed: it is not accounting advice about which account an expense belongs in.

What if the box holds more cash than the fund?

Then the fund minus the cash counted is below zero, the cash account line is a debit instead of a credit, and the certificate carries a warning. The arithmetic is shown as it comes out.

Can a coin roll or a voucher be counted?

A roll of coins is counted as the coins inside it, on that coin's line. A voucher or an advance slip paid out of the box is typed as a receipt row with the account its amount is recorded in.

Is anything I type uploaded?

No. Everything typed on this page is worked out in this browser tab and nothing is sent anywhere. A draft is kept in this browser only; the Clear the form button removes it.

This tool calculates and checks numbers. It is not legal, tax, or medical advice.

Template updates by email

At most four emails a year, when the free templates and rate tables for bookkeepers and accountants are updated for a new quarter. Each has a one-click unsubscribe link.

Only the address typed here is sent, never anything from a file opened on this page. Nothing is added until the link in the confirm email is opened. Mathproven is a product of OpenSlot LLC, PO Box 96, Paintsville, KY 41240, USA. Privacy.