AI Petty Cash Reconciler
Automate the reconciliation of petty cash funds with US GAAP-compliant categorization and discrepancy reporting.
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.
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.
More Like This
Back to LibraryAI-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.
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.
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.