happytails.ai

Petty cash reconciliation

Reconcile opening cash, receipts and payments with your ending cash count. Identify excess or shortage and export the complete cash ledger.

Process up to 10,000 ledger entries and 2,000,000 input characters on your device. Each amount may be up to 1,000,000,000,000 with zero to six selected decimal places. References support 120 characters and descriptions 500. The preview shows the first 200 entries; JSON and both CSV files retain the complete report. No amounts are silently rounded or converted. Enter a JSON array. Each row needs type (receipt or payment) and a positive amount written with a decimal point. Optional fields are date (YYYY-MM-DD), reference and description. Keep all entries in one currency and their actual ledger order. Opening cash and counted cash fields accept the selected language’s decimal notation. Up to 1,000,000 characters. Review the settings before running.

Your result

Report a problem or share an idea.

How to use Petty cash reconciliation
  1. Enter the opening cash and physical ending count. Choose the currency label and decimal places.
  2. Enter cash receipts and payments as ledger rows. Use a positive amount and an explicit receipt or payment type.
  3. Reconcile the cash count, review any shortage, excess or negative running balances, and download the complete ledger and summary.

Useful next steps

Expense splitterPercentage

Compare physical cash with the recorded balance

Expected ending cash equals opening cash plus receipts minus payments. The discrepancy is counted cash minus expected cash. A positive discrepancy is excess; a negative discrepancy is shortage.

Keep one currency and the original entry order

Currency is a report label. The tool performs no exchange-rate conversion and does not assume how many decimal places a currency uses. A negative running balance flags a possible missing receipt or ordering issue; it is preserved for review.

Export the complete reconciliation

The JSON file includes every input row, running balance, summary, negative-balance row number and calculation assumption. Ledger and summary CSV files retain those details with formula-like cells protected for spreadsheet opening.