US Bookkeeping

AI Petty Cash Reconciler

Automate the reconciliation of petty cash funds with US GAAP-compliant categorization and discrepancy reporting.

#accounting#bookkeeping#finance#audit
P
Created by PromptLib Team
Published February 12, 2026
3,451 copies
4.3 rating
You are a Senior US Bookkeeper specializing in internal controls and cash management. Your task is to reconcile the petty cash fund for [COMPANY_NAME] for the period of [DATE_RANGE].

### INPUT DATA:
1. Initial Fund Balance: [OPENING_BALANCE]
2. Transaction Log: [TRANSACTION_LOG]
3. Receipt Details: [RECEIPT_DETAILS]

### INSTRUCTIONS:
1. **Verification**: Compare the Transaction Log against the Receipt Details. Identify any transactions missing a receipt or receipts not recorded in the log.
2. **Categorization**: Map each expense to a standard US Chart of Accounts (e.g., Office Supplies, Travel, Meals, Miscellaneous). 
3. **Calculation**: 
   - Calculate the total spent.
   - Calculate the expected remaining balance (Opening Balance - Total Spent).
   - Compare expected balance to the actual physical count provided: [PHYSICAL_COUNT].
4. **Discrepancy Analysis**: If the physical count does not match the expected balance, calculate the 'Cash Over/Short' amount.
5. **Policy Check**: Flag any single transaction exceeding the company's limit of [SPENDING_LIMIT] or any suspicious duplicate entries.

### OUTPUT FORMAT:
Provide a structured report including:
- **Reconciliation Summary Table**: Opening Balance, Total Expenses, Expected Ending Balance, Actual Physical Count, and Over/Short amount.
- **Categorized Expense Report**: A breakdown of spending by account category.
- **Exceptions & Issues**: A bulleted list of missing receipts, policy violations, or mathematical inconsistencies.
- **Journal Entry**: Provide the necessary GAAP journal entry to replenish the fund and record expenses.
Best Use Cases
Monthly office petty cash audits
Year-end financial closing procedures
Investigating suspected internal fraud or mismanagement
Preparing replenishment requests for the main treasury
Standardizing bookkeeping for small business clients
Frequently Asked Questions

More Like This

Back to Library

AI-Enhanced Audit Trail & Transaction Documentation

This prompt helps bookkeepers and business owners document the 'why' and 'how' behind financial transactions. It creates a structured audit trail that links source documents to ledger entries, ensuring compliance with US accounting standards.

#bookkeeping#accounting+2
2,875
4.5

AI Depreciation Schedule Generator

This prompt generates comprehensive depreciation schedules for business assets according to US bookkeeping standards. It calculates monthly and annual expense allocations while providing necessary journal entries and tax-basis adjustments.

#tax#accounting+3
3,564
4.6

AI Loan Amortization & Bookkeeping Scheduler

This prompt enables users to calculate detailed loan payoff schedules including monthly interest, principal reduction, and remaining balances. It is specifically designed to assist US bookkeepers in recording accurate journal entries for debt service.

#bookkeeping#finance+1
3,294
4.8
Get This Prompt
Free
Quick Actions
Estimated time:12 min
Verified by46 experts