Invoice Import Error: "Either Tax or Tax Exemption Reason is required" - Recurring Across All Attempts
Issue Description:
I'm experiencing a critical issue with invoice imports in Zoho Books. Every import attempt fails with the same error message, regardless of the tax data provided:
Either Tax or Tax Exemption Reason is required.
This error is blocking my ability to import invoices and occurs consistently across multiple file variations.
What I've Tried:
I've created and tested 5 different invoice files with varying tax configurations:
| Attempt | Configuration | Result |
|---|
| 1 | No tax information | ❌ Same error |
| 2 | Tax exemption only (GST FREE) | ❌ Same error |
| 3 | Tax with rate (ON HST - 13%) | ❌ Same error |
| 4 | Using EXEMPT exemption reason | ❌ Same error |
| 5 | Exact copy of manually created invoice | ❌ Same error |
What I've Verified:
✅ Tax data exists in account:
- GST tax rate configured
- HST tax rate configured
- ON HST tax rate configured
- Zero Rate tax configured
- EXEMPT exemption reason available
✅ The data is correct:
- I can manually create the same invoice in Zoho Books successfully
- The manually created invoice contains identical tax information
- Manual invoice saves without any errors
❌ Import still fails:
- Even the exact same invoice exported and re-imported fails with the same error
Additional Details:
- The error occurs during the import mapping stage
- The error is specific and consistent - it doesn't vary based on file content
- The error appears for each invoice line item in the batch
- I've tested with different file formats (XLSX)
Questions:
- Is there a strict tax requirement setting that enforces tax/exemption on all imports?
- Is there a known issue with the import validation logic?
- Are there specific field mapping requirements I'm missing?
- Is there an alternative import method available?
System Information:
- Zoho Books (Canada account)
- Testing Date: April 4, 2025
- Invoice lines tested: 10+
- Error consistency: 100%
Attached Files:
I can provide sample invoice files demonstrating each variation tested if that would help with troubleshooting.
Any guidance or suggestions would be greatly appreciated. This is blocking my workflow significantly.