The Scenario
Your company sells SaaS into 12 EU countries and your finance director just got a letter from your auditor. The annual compliance audit requires a complete listing of every tax ID your company has registered across all jurisdictions — the jurisdiction name, the ID number, and the validity dates. The data lives in Quaderno. The auditor wants it in an Excel workbook by Friday.
You didn't even know Quaderno stored registration data that way. You opened the Quaderno settings panel, found the Tax IDs section, and counted: 17 entries across 12 jurisdictions. Copying them by hand would take 20 minutes. But the auditor also wants this to be repeatable going forward, and doing it manually every year guarantees someone will forget a row.
The bad version:
- Open Quaderno's Tax IDs settings, click the first entry, note the jurisdiction, the ID value, and the validity dates, switch to the workbook, type them into columns A through D
- Repeat for each of the 17 entries
- Realize you skipped the validity end date for three entries because the Quaderno UI shows it as a tooltip on hover, not in the main view, and you didn't notice
The auditor is not interested in a workbook with gaps in the validity columns.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can pull your Quaderno registered tax IDs directly into the workbook.
Fetch every registered tax ID in Quaderno and paste the jurisdiction name, country, ID value, and registered date into this Excel sheet
What You Get
- Every tax ID registration in Quaderno lands in the workbook with the full set of fields
- Validity start and end dates are written as YYYY-MM-DD values so they sort correctly
- The list includes all jurisdictions — you don't need to page through anything manually
- The workbook is ready to hand to the auditor as-is, or to filter and annotate as needed
What If the Data Is Not Quite Ready
I need the country name spelled out, not just the jurisdiction code
List all registered tax IDs from Quaderno and write jurisdiction code, full country name, tax ID type (VAT, GST, etc.), ID number, validity start date, and validity end date into columns A through F
I need to cross-reference these against a list of countries we actively invoice in
Fetch all registered tax IDs from Quaderno and write jurisdiction, ID number, and validity dates into columns A through D; then for each row, check if the country appears in column A of the ActiveMarkets worksheet — write Yes or No to column E
Some registrations have expired — I need to flag those separately
List all registered tax IDs from Quaderno and write jurisdiction, ID number, start date, and end date into columns A through D; for any registration where the end date is before today, write Expired to column E; for active registrations, write Active
Pull the full registry, flag expirations, cross-reference active markets, and compute coverage gaps in one pass
Fetch all registered tax IDs from Quaderno and write jurisdiction, ID number, start date, end date into columns A through D; flag Expired or Active in column E based on today's date; check if each jurisdiction appears in the ActiveMarkets worksheet and write Registered or Not Registered to column F; then list any countries from ActiveMarkets that have no Quaderno registration in the Gap Analysis worksheet
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you're staging the audit documentation, then ask it to pull your full Quaderno tax ID registry into the workbook. Also see: bulk validating customer tax IDs from an Excel workbook, and the hub overview of all Quaderno connection methods.