IRIS + Sales Tax Reporting: Complete Workflow
Preparing for sales tax reporting and using IRIS? Businesses selling across multiple states need to reconcile bank deposits with sales tax collected, analyze economic nexus thresholds, and prepare multi-state filings. BankScan AI bridges the gap between your bank's PDF statements and IRIS's import feature.
BankScan AI → IRIS for Sales Tax Reporting
Convert bank statement PDFs to CSV formatted for IRIS import. Convert bank statements to Excel to reconcile sales deposits across states, verify tax collected amounts, and prepare accurate multi-state sales tax returns.
How It Works
Upload your bank statement PDF
Supports all major banks. Upload Monthly, quarterly, or annually depending on the state and filing frequency assigned based on sales volume of statements.
AI formats for IRIS
Output as CSV with Date, Narrative, Debit, Credit — IRIS uses Narrative instead of Description and requires separate Debit/Credit columns — dates in DD/MM/YYYY.
Import and use for sales tax reporting
Upload into IRIS and use the reconciled data for sales tax reporting.
Supported Banks
BankScan AI works with all major UK and US banks, including:
IRIS + Sales Tax Reporting Features
- IRIS ready — Output formatted as CSV matching IRIS's expected column structure
- Smart integration — IRIS links bank transactions directly to tax computations, so imported statements feed into both bookkeeping and tax return preparation simultaneously.
- Built for Sales Tax Reporting — Convert bank statements to Excel to reconcile sales deposits across states, verify tax collected amounts, and prepare accurate multi-state sales tax returns.
Import for Sales Tax Reporting into IRIS
After converting your bank statements for sales tax reporting:
- In IRIS Accountancy Suite, open the client file, go to Bank > Import Transactions
- Select the CSV file, map columns to Date, Narrative, Debit, Credit, and import
Common Import Issues
IRIS is strict about column naming — use 'Narrative' not 'Description'. Also requires the CSV to not contain any currency symbols in amount columns.
IRIS Import for Sales Tax Reporting
Filing frequencies vary by state; California and Texas returns are due by the last day of the month following the reporting period; late filing penalties typically 5-25% of tax due
Convert for IRIS + Sales Tax Reporting