xero-exportslisted

# Working With Xero Exports The other skills in this pack assume clean inputs. This skill is how you specify what to export and how you spot a broken export before it poisons a workpaper. ## The core exports and what they're for | Report | Use | Gotchas | |---|---|---| | Trial Balance | Every workpaper starts here | Check cash vs accrual toggle matches the engagement basis; export as at the exact cut-off date | | Account Transactions | GL detail per account | Large date ranges paginate/truncate in some formats; verify row counts; includes system journals | | Aged Receivables / Payables | Control account support | Run **as at** the period end, not "current"; aging buckets are settings-dependent | | GST Audit Report / Activity Statement | BAS support | Basis follows the GST settings, not the TB toggle; confirm both | | Payroll Activity Summary | Payroll recs | Financial-year runs; per-employee detail needs the detailed variant | | Fixed Asset Reconciliation | FA workpapers | Draft vs registered assets differ; registered only | ## Parsing conventions (CSV) 1. Dates commonly export as `DD MMM YYYY`; parse explicitly; never let a tool guess US format. 2. Header rows: Xero CSVs carry title/entity/date rows above the real header, so skip to the actual column row programmatically, don't hardcode row counts across report types. 3. Negatives are minus-signed, but presentation reports (P&L) sign by natural balance, so reconcile sign conventions before combining reports. 4. Tracking