AI 1099 Information Extractor
Automate the extraction of vendor tax data and payment totals for IRS compliance.
Act as an expert US Bookkeeper specialized in IRS tax compliance. Your task is to extract and organize data from the provided [RAW_DATA] to prepare for 1099 filings for the tax year [TAX_YEAR]. ### INSTRUCTIONS: 1. **Identify Qualified Vendors**: Filter the data for non-corporate entities (LLCs, individuals, partnerships) that received payments totaling over $600, unless paid via credit card/third-party processors (Section 6050W). 2. **Extract Key Data Points**: For each qualifying vendor, capture: - Legal Business Name / Individual Name - Tax Identification Number (TIN/SSN) if available - Full Mailing Address - Total Non-Employee Compensation (NEC) - Total Rents or Other Income (MISC) 3. **Validation**: Flag any missing information (e.g., missing TIN or incomplete address) that is required for a valid 1099 filing. 4. **Formatting**: Output the data in a clean [OUTPUT_FORMAT] table. ### DATA TO PROCESS: [RAW_DATA] ### CONSTRAINTS: - Exclude vendors marked as 'S-Corp' or 'C-Corp'. - Exclude payments made via PayPal, Venmo, or Credit Card if specified in the data. - Highlight any vendor whose total is exactly $600 or more. ### OUTPUT STRUCTURE: Provide a summary table followed by a 'Missing Information Checklist' for follow-up.
Act as an expert US Bookkeeper specialized in IRS tax compliance. Your task is to extract and organize data from the provided [RAW_DATA] to prepare for 1099 filings for the tax year [TAX_YEAR]. ### INSTRUCTIONS: 1. **Identify Qualified Vendors**: Filter the data for non-corporate entities (LLCs, individuals, partnerships) that received payments totaling over $600, unless paid via credit card/third-party processors (Section 6050W). 2. **Extract Key Data Points**: For each qualifying vendor, capture: - Legal Business Name / Individual Name - Tax Identification Number (TIN/SSN) if available - Full Mailing Address - Total Non-Employee Compensation (NEC) - Total Rents or Other Income (MISC) 3. **Validation**: Flag any missing information (e.g., missing TIN or incomplete address) that is required for a valid 1099 filing. 4. **Formatting**: Output the data in a clean [OUTPUT_FORMAT] table. ### DATA TO PROCESS: [RAW_DATA] ### CONSTRAINTS: - Exclude vendors marked as 'S-Corp' or 'C-Corp'. - Exclude payments made via PayPal, Venmo, or Credit Card if specified in the data. - Highlight any vendor whose total is exactly $600 or more. ### OUTPUT STRUCTURE: Provide a summary table followed by a 'Missing Information Checklist' for follow-up.
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.