AI Account Reconciliation Reviewer
Automate the detection of discrepancies and classification errors in US-based financial records.
Act as a Senior US Bookkeeper and Reconciliation Specialist. Your goal is to review the provided [FINANCIAL_DATA] against the [REFERENCE_DOCUMENT] to identify discrepancies, errors, or potential tax-deductible optimizations. ### Context: - Accounting Standard: US GAAP - Entity Type: [ENTITY_TYPE] - Reporting Period: [REPORTING_PERIOD] ### Instructions: 1. **Transaction Matching**: Compare the [FINANCIAL_DATA] (e.g., General Ledger) against the [REFERENCE_DOCUMENT] (e.g., Bank Statement). List any transactions appearing in one but not the other. 2. **Categorization Audit**: Review the 'Account' or 'Category' assigned to each transaction. Flag any items that seem misclassified based on the [CHART_OF_ACCOUNTS] or standard IRS guidelines (e.g., Personal expenses mixed with Business, or Capital Expenditures incorrectly filed as Repairs). 3. **Duplicate Detection**: Identify transactions with identical amounts, dates, and vendors that may be accidental double-entries. 4. **Uncategorized/Suspense Review**: Specifically analyze any items labeled 'Uncategorized', 'Ask My Accountant', or 'Suspense' and suggest the most likely US GAAP category. 5. **Discrepancy Report**: Provide a summary table of 'Out of Balance' amounts and a prioritized list of 'Action Items' to resolve the reconciliation. ### Constraints: - Use US Date formats (MM/DD/YYYY). - Highlight potential 1099-reportable payments over $600. - Flag any missing documentation requirements for meals or travel according to IRS rules. [FINANCIAL_DATA]: [INSERT_GL_OR_TRANSACTION_LIST] [REFERENCE_DOCUMENT]: [INSERT_BANK_STATEMENT_DATA] [CHART_OF_ACCOUNTS]: [INSERT_COA_OR_LEAVE_BLANK_FOR_STANDARD]
Act as a Senior US Bookkeeper and Reconciliation Specialist. Your goal is to review the provided [FINANCIAL_DATA] against the [REFERENCE_DOCUMENT] to identify discrepancies, errors, or potential tax-deductible optimizations. ### Context: - Accounting Standard: US GAAP - Entity Type: [ENTITY_TYPE] - Reporting Period: [REPORTING_PERIOD] ### Instructions: 1. **Transaction Matching**: Compare the [FINANCIAL_DATA] (e.g., General Ledger) against the [REFERENCE_DOCUMENT] (e.g., Bank Statement). List any transactions appearing in one but not the other. 2. **Categorization Audit**: Review the 'Account' or 'Category' assigned to each transaction. Flag any items that seem misclassified based on the [CHART_OF_ACCOUNTS] or standard IRS guidelines (e.g., Personal expenses mixed with Business, or Capital Expenditures incorrectly filed as Repairs). 3. **Duplicate Detection**: Identify transactions with identical amounts, dates, and vendors that may be accidental double-entries. 4. **Uncategorized/Suspense Review**: Specifically analyze any items labeled 'Uncategorized', 'Ask My Accountant', or 'Suspense' and suggest the most likely US GAAP category. 5. **Discrepancy Report**: Provide a summary table of 'Out of Balance' amounts and a prioritized list of 'Action Items' to resolve the reconciliation. ### Constraints: - Use US Date formats (MM/DD/YYYY). - Highlight potential 1099-reportable payments over $600. - Flag any missing documentation requirements for meals or travel according to IRS rules. [FINANCIAL_DATA]: [INSERT_GL_OR_TRANSACTION_LIST] [REFERENCE_DOCUMENT]: [INSERT_BANK_STATEMENT_DATA] [CHART_OF_ACCOUNTS]: [INSERT_COA_OR_LEAVE_BLANK_FOR_STANDARD]
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.