Tax Reports
Tax reports generate comprehensive tax data for filing, compliance, and analysis purposes. This guide covers report generation and filing preparation.
Overview
Tax reports enable you to:
- Generate filing reports
- Prepare tax returns
- Analyze tax data
- Export for filing
- Track submissions
- Support audits
Accessing Tax Reports
Navigate to Tax Management → Tax Reports to generate reports.
Understanding Reports
Report Types
| Type | Description |
|---|---|
| Sales Tax | State/local sales tax |
| VAT Return | Value added tax |
| Exemption | Exempt sales summary |
| Audit | Detailed transaction log |
| Jurisdiction | By-jurisdiction detail |
Report Periods
| Period | Description |
|---|---|
| Monthly | Single month |
| Quarterly | Three months |
| Annual | Full year |
| Custom | Date range |
Report Status
| Status | Description |
|---|---|
| Draft | Generated, not filed |
| Filed | Submitted to authority |
| Amended | Corrected filing |
| Audited | Under review |
How-To Guides
How to Generate Sales Tax Report
Report Generation
- Go to Tax Reports → Sales Tax
- Select parameters:
- Filing period
- Jurisdiction(s)
- Report type
- Click Generate
- Review report
- Export or file
Sales Tax Report
Sales Tax Report
Filing Period: January 2026
Jurisdiction: California
Authority: CA CDTFA
Due Date: February 28, 2026
Summary:
┌────────────────────────────────────────────────────────────┐
│ Total Gross Sales: $1,234,567.89 │
│ Non-Taxable Sales: -$234,567.89 │
│ Exempt Sales: -$156,789.00 │
│ Taxable Sales: $843,211.00 │
│ │
│ State Tax (7.25%): $61,132.80 │
│ County Tax (0.25%): $2,108.03 │
│ District Tax (0.50%): $4,216.06 │
│ │
│ Total Tax Collected: $67,456.89 │
│ Previously Remitted: $0.00 │
│ Tax Due: $67,456.89 │
└────────────────────────────────────────────────────────────┘
Deductions:
├─ Resale Exemptions: $156,789.00
├─ Government Sales: $45,678.89
├─ Non-Profit Sales: $32,100.00
└─ Other Exemptions: $0.00How to Generate Jurisdiction Detail
By-Jurisdiction Report
Jurisdiction Detail Report - January 2026
California:
├─ State Tax: $61,132.80
├─ Los Angeles County: $12,456.78
├─ Orange County: $8,234.56
├─ San Diego County: $6,123.45
└─ Other Counties: $2,108.03
By City (Los Angeles County):
├─ Los Angeles: $8,234.56
├─ Long Beach: $2,345.67
├─ Glendale: $1,234.56
└─ Other Cities: $641.99
By District:
├─ LA Metro Transit: $4,567.89
├─ BART (SF): $2,345.67
└─ Other Districts: $1,234.56How to Prepare Filing
Filing Preparation
- Generate report for period
- Review for accuracy
- Compare to prior periods
- Check exemptions
- Verify totals
- Export in filing format
Filing Checklist
Filing Checklist - CA January 2026
Pre-Filing:
- [ ] Generate sales tax report
- [ ] Verify gross sales match GL
- [ ] Confirm exempt sales documented
- [ ] Review exemption certificates current
- [ ] Compare to prior period
- [ ] Check for unusual variances
Filing:
- [ ] Export in CDTFA format
- [ ] Log into CDTFA portal
- [ ] Upload/enter return data
- [ ] Review online calculation
- [ ] Submit return
- [ ] Remit payment
Post-Filing:
- [ ] Save confirmation number
- [ ] Record filing in system
- [ ] Archive supporting docs
- [ ] Update filing calendarHow to Generate Exemption Reports
Exemption Summary
Exemption Report - January 2026
By Exemption Type:
┌────────────────────────────────────────────────────────────┐
│ Type │ Sales │ Tax Exempted │ Count │
├────────────────────────────────────────────────────────────┤
│ Resale │ $156,789.00 │ $12,855.70 │ 89 │
│ Government │ $45,678.89 │ $3,745.67 │ 23 │
│ Non-Profit │ $32,100.00 │ $2,632.20 │ 15 │
│ Manufacturing │ $0.00 │ $0.00 │ 0 │
├────────────────────────────────────────────────────────────┤
│ Total │ $234,567.89 │ $19,233.57 │ 127 │
└────────────────────────────────────────────────────────────┘
Top Exempt Customers:
├─ ABC Wholesale: $78,901.23
├─ State University: $34,567.89
├─ County Schools: $23,456.78
└─ XYZ Resellers: $19,876.54How to Generate Audit Report
Audit Detail Report
Audit Detail Report
Period: January 2026
Jurisdiction: California
Transaction Detail:
┌──────────────────────────────────────────────────────────────────┐
│ Date │ Invoice │ Customer │ Taxable │ Tax │ Rate │
├──────────────────────────────────────────────────────────────────┤
│ 01/02 │ INV-0001 │ Acme Corp │ $1,234.56 │ $104.94 │ 8.5% │
│ 01/02 │ INV-0002 │ ABC Wholesale │ $0.00 │ $0.00 │ EX │
│ 01/03 │ INV-0003 │ XYZ Inc │ $2,345.67 │ $199.38 │ 8.5% │
│ 01/03 │ INV-0004 │ State Univ │ $0.00 │ $0.00 │ EX │
│ ... │ ... │ ... │ ... │ ... │ ... │
└──────────────────────────────────────────────────────────────────┘
Export Options:
├─ Full Detail: All transactions
├─ Summary: By customer/day
├─ Exemptions: Exempt transactions only
└─ Format: CSV, Excel, PDFHow to Compare Periods
Period Comparison
Period Comparison Report
│ Dec 2025 │ Jan 2026 │ Change
───────────────────────────────────────────────────────────
Gross Sales │ $1,456,789 │ $1,234,568 │ -15.2%
Taxable Sales │ $998,765 │ $843,211 │ -15.6%
Exempt Sales │ $458,024 │ $391,357 │ -14.6%
Tax Collected │ $81,899 │ $67,457 │ -17.6%
Effective Rate │ 8.20% │ 8.00% │ -0.20%
Variance Analysis:
├─ Seasonal decline (expected)
├─ One fewer business day
├─ Large exempt order in Dec
└─ No rate changesHow to Schedule Reports
Report Scheduling
- Go to Tax Reports → Schedules
- Click New Schedule
- Configure:
- Report type
- Frequency
- Recipients
- Format
- Save schedule
Schedule Configuration
Scheduled Report: Monthly Sales Tax
Report: Sales Tax Summary
Frequency: Monthly
Generate: 3rd business day of month
Period: Prior month
Jurisdictions:
├─ California
├─ Texas
├─ New York
└─ Florida
Recipients:
├─ [email protected]
├─ [email protected]
└─ [email protected]
Format: PDF + Excel attachment
Delivery: EmailAdvanced Features
E-Filing Integration
Direct submission:
- State portal integration
- Automatic filing
- Confirmation tracking
- Payment scheduling
Multi-Entity Reporting
Consolidated reports:
- Combined reporting
- Separate entity detail
- Intercompany elimination
- Group summary
Audit Support
Examination tools:
- Complete transaction detail
- Supporting documents
- Exemption certificates
- Communication logs
Variance Analysis
Trend identification:
- Period comparison
- Anomaly detection
- Forecasting
- Benchmark comparison
Best Practices
Report Generation
- Generate early
- Allow review time
- Compare to prior
- Document variances
Filing
- File on time
- Double-check amounts
- Keep confirmations
- Track deadlines
Documentation
- Archive all reports
- Keep supporting docs
- Maintain audit trail
- Organize by period
Review Process
- Multi-person review
- Reconcile to GL
- Verify exemptions
- Sign-off process
Configuration
Report Settings
Navigate to Settings → Tax → Reports:
- Templates - Report formats
- Schedules - Auto-generation
- Distribution - Recipients
- Archive - Retention
Filing Settings
- Credentials - Portal logins
- E-File - Electronic filing
- Payment - Remittance options
- Notifications - Filing alerts
Troubleshooting
Common Issues
Report totals don't match
- Check date range
- Verify jurisdiction
- Review adjustments
- Reconcile to GL
Cannot generate report
- Check permissions
- Verify data exists
- Review filters
- Contact support
E-file rejected
- Check format
- Verify credentials
- Review errors
- Retry submission
Missing transactions
- Check posting dates
- Verify invoice status
- Review filters
- Check jurisdiction
Related Documentation
Learn about Tax Reconciliation to reconcile tax collected with tax payable.