US Bookkeeping

AI Account Reconciliation Reviewer

Automate the detection of discrepancies and classification errors in US-based financial records.

#finance#bookkeeping#accounting#reconciliation
P
Created by PromptLib Team
Published February 12, 2026
2,516 copies
4.4 rating
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]
Best Use Cases
Monthly bank-to-ledger reconciliation for small businesses.
Cleaning up books at year-end before sending to a CPA for tax filing.
Auditing 'Ask My Accountant' folders to reduce billable hours from external firms.
Finding duplicate software subscriptions or accidental double-billings.
Ensuring compliance with US IRS rules for meals, entertainment, and asset capitalization.
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:10 min
Verified by37 experts