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.
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 coin | Count | Amount |
|---|
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.
| Date | Description | Expense account | Amount |
|---|
The reconciliation appears here once the fund is typed.
What gets checked
- Each denomination line equals its count times the value of one bill or coin, and the cash counted equals the sum of the lines, worked out a second time with the bills and the coins added apart.
- The receipts re-add to the receipts total, and the totals by expense account add up to the same total, each account re-added from its own receipts.
- Cash counted plus receipts, less an overage or plus a shortage, equals the fund.
- The replenishment equals the fund minus the cash counted, and also the receipts minus an overage or plus a shortage.
- The journal entry balances: the debits equal the credits, and every line is rebuilt from a second calculation and compared.
- Four warnings that do not fail the result: an over or short of any size, more cash in the box than the fund, a receipt of zero, and a receipt on the cash account or the over-and-short account.
How it works
- 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.
- 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.
- 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.
- 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.
| Line | How it is built | Amount |
|---|---|---|
| $20 bills | 7 × $20.00 | $140.00 |
| $10 bills | 4 × $10.00 | $40.00 |
| $5 bills | 3 × $5.00 | $15.00 |
| $1 bills | 22 × $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 counted | Bills 217.00 + coins 4.12 | $221.12 |
| Postage | 1 receipt | $18.40 |
| Office supplies | 2 receipts: 32.15 + 21.48 | $53.63 |
| Parking and tolls | 1 receipt | $6.00 |
| Receipts | 18.40 + 53.63 + 6.00 | $78.03 |
| Cash plus receipts | 221.12 + 78.03 | $299.15 |
| Petty cash fund | The fixed amount of the fund | $300.00 |
| Short | 299.15 − 300.00 | -$0.85 |
| Replenishment: fund − cash counted | 300.00 − 221.12, the same as 78.03 + 0.85 | $78.88 |
| Journal: Postage | Debit | $18.40 |
| Journal: Office supplies | Debit | $53.63 |
| Journal: Parking and tolls | Debit | $6.00 |
| Journal: Cash over and short | Debit, the shortage | $0.85 |
| Journal: Cash | Credit, the replenishment | $78.88 |
| Debits and credits | 18.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.