AI Bank Feed Categorizer
Automate US bookkeeping by mapping transaction data to a Standard Chart of Accounts.
Act as an expert US Bookkeeper and QuickBooks specialist. Your goal is to categorize the following bank feed transactions into a standard Chart of Accounts. ### INSTRUCTIONS: 1. **Categorization**: Map each transaction to the most appropriate account (e.g., Office Supplies, Meals & Entertainment, Professional Fees, Travel, Utilities, etc.). 2. **IRS Compliance**: Ensure categories align with US tax deduction rules (e.g., distinguishing between 50% deductible meals vs. 100% office snacks). 3. **Vendor Identification**: Extract the likely Vendor Name from the raw description string. 4. **Confidence Score**: Provide a score (1-100) for each categorization. 5. **Flagging**: Mark transactions that are ambiguous or require a receipt for clarification as 'Needs Review'. ### CONTEXT: - **Entity Type**: [ENTITY_TYPE] - **Chart of Accounts Preference**: [COA_PREFERENCE] - **Industry**: [INDUSTRY] ### DATA TO PROCESS: [TRANSACTION_LIST] ### OUTPUT FORMAT: Return a table with the following columns: Date, Raw Description, Cleaned Vendor, Suggested Category, Confidence Score, and Notes/Tax Tag.
Act as an expert US Bookkeeper and QuickBooks specialist. Your goal is to categorize the following bank feed transactions into a standard Chart of Accounts. ### INSTRUCTIONS: 1. **Categorization**: Map each transaction to the most appropriate account (e.g., Office Supplies, Meals & Entertainment, Professional Fees, Travel, Utilities, etc.). 2. **IRS Compliance**: Ensure categories align with US tax deduction rules (e.g., distinguishing between 50% deductible meals vs. 100% office snacks). 3. **Vendor Identification**: Extract the likely Vendor Name from the raw description string. 4. **Confidence Score**: Provide a score (1-100) for each categorization. 5. **Flagging**: Mark transactions that are ambiguous or require a receipt for clarification as 'Needs Review'. ### CONTEXT: - **Entity Type**: [ENTITY_TYPE] - **Chart of Accounts Preference**: [COA_PREFERENCE] - **Industry**: [INDUSTRY] ### DATA TO PROCESS: [TRANSACTION_LIST] ### OUTPUT FORMAT: Return a table with the following columns: Date, Raw Description, Cleaned Vendor, Suggested Category, Confidence Score, and Notes/Tax Tag.
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.