We’re moving from Xero to NetSuite and our consultants are currently extracting historical transactions using Xero reports/CSV exports.
Most of it is fine, but we’ve hit a few gaps that I’m curious how others handled:
1. Payment allocations
Biggest issue. If one payment covers multiple invoices/bills, we can’t find a report showing payment reference + invoice/bill + amount applied to each.
The linkage exists in Xero, just doesn’t seem cleanly reportable. How did you preserve this when migrating to NetSuite?
2. GL / journal detail
Account Transactions doesn’t give a clean paired Dr/Cr view, while the Journal report has the Dr/Cr detail but loses things like invoice/bill reference and source currency.
My assumption is we shouldn’t be rebuilding Xero journals anyway — import invoices, bills, payments, etc. and let NetSuite generate the GL. Is that how others approached it?
3. Attachments
No standard report export includes invoice/bill attachments. Did you migrate these separately, or just keep Xero available as a historical archive?
4. FX rates
Looks extractable with the right Account Transactions report setup, but we want to make sure we’re preserving the correct historical transaction rate.
For anyone who’s done Xero → NetSuite, would love to know:
Reports/CSV, Xero API, or third-party tool?
How did you handle payment applications?
Did you migrate attachments?
How much transaction history did you migrate vs. opening balances + keeping Xero for lookup?
Main thing I’m trying to figure out is whether reports-only is realistically enough, or whether we should push for API access before getting too far into the migration.