Tax Preparation
Prepare corporate tax documents and supporting materials for AceEngineer Inc.
Description
This skill automates the preparation of corporate tax documents including federal Form 1120, Texas franchise tax, and supporting documentation for CPA review.
Trigger Conditions
Activate when the user mentions:
- Tax preparation or tax documents
- Corporate tax forms (1120)
- Texas franchise tax
- Tax year preparation
- Tax filing package
Core Capabilities
- Expense Categorization: Automatically categorize expenses for tax purposes
- Income Summarization: Aggregate revenue by client and category
- Form Data Preparation: Prepare data for Form 1120 fields
- Supporting Documentation: Compile supporting schedules and documentation
- CPA Package Generation: Create organized package for CPA review
Usage Examples
# Prepare tax documents for a year
aceengineer tax prepare --year 2024
# Generate draft forms only
aceengineer tax prepare --year 2024 --draft
# Create filing package with checklist
aceengineer tax file --year 2024
# Generate checklist only
aceengineer tax file --year 2024 --checklist-only
Tax Categories
Deductible Expenses
- Professional services and consulting fees
- Office supplies and equipment
- Software and technology
- Travel and transportation
- Professional development and training
- Insurance premiums
- Bank fees and charges
Revenue Categories
- Engineering consulting services
- Design review fees
- Technical support services
Output Structure
tax_output/
├── 2024/
│ ├── income_summary.xlsx
│ ├── expense_summary.xlsx
│ ├── form_1120_data.xlsx
│ ├── texas_franchise_data.xlsx
│ ├── supporting_schedules/
│ └── cpa_package/
│ ├── checklist.md
│ ├── instructions.pdf
│ └── all_documents.zip
Dependencies
- pandas: Financial data processing
- openpyxl: Excel report generation
- PyPDF2: PDF document handling
- reportlab: PDF generation
Related Files
aceengineer_admin/tax/: Tax module sourceaceengineer_admin/cli.py: CLI commandstax_data/: Historical tax datatax_output/: Generated tax documents
Workflow
- Load expense and revenue data for tax year
- Categorize transactions for tax purposes
- Calculate totals and prepare form data
- Generate summary reports in Excel
- Compile supporting documentation
- Create CPA review package with checklist