What Mappd does for this workflow

Mappd converts USD-denominated Stripe payout CSVs into UK Xero GBP bank-statement import format by converting every amount at live FX (USD → GBP), trimming the datetime to DD/MM/YYYY, lowercasing customer_email to Payee, and renaming id to Reference. Processing is client-side. Typical run time: 3 minutes.

6 source columns handled
6 transforms applied
3 min typical run time
Free to use
Ops · NetSuite to Excel

Stripe USD → Xero GBP. Live FX, no spreadsheet maths.

Upload your USD Stripe payout CSV. The recipe converts every amount to GBP at live FX, formats the date for UK Xero, and gives you an import-ready file in 3 min.

"Your Stripe account collects USD, your accountant reconciles in Xero GBP. Every payout is a spreadsheet =A1*0.79 you do by hand because last week's rate isn't this week's rate."

Free · No signup needed for files under 5 MB · All processing in your browser

45 min
manual time per run
3 min
with this recipe
720
runs this month
01
02
03
04

Scroll to continue ↓
v2.4
Change summary
6 columns mapped to Xero's bank-statement schema
3 amounts converted USD → GBP at live FX
Datetime trimmed to DD/MM/YYYY (UK Xero)
Download stripe-usd-to-xero-gbp.csv

Column transformations applied

created_utc → Date (DD/MM/YYYY for UK Xero)
amount_captured → Amount (Convert to GBP at live FX)
description → Description (trimmed)
id → Reference
type → Type
customer_email → Payee (lowercased)

Frequently asked questions

How do I convert a NetSuite export to Excel format?

Upload your NetSuite CSV or Excel file to Mappd. The NetSuite to Excel recipe loads automatically and maps your columns. Review the changes and download the converted file. The process takes under 5 min.

What columns does this recipe rename?

TRANDOC.TRANDATE → Date (ISO format). TRANDOC.TRANID → Reference. AMOUNT.DEBIT → Debit (GBP prefix + commas stripped). AMOUNT.CREDIT → Credit.

Does my file get uploaded to a server?

No. All processing happens entirely in your browser using client-side JavaScript. Your file data never leaves your computer and is never transmitted to Mappd's servers.

Is this free?

Yes. Mappd is free to use for files under 5 MB without signing up. The free tier includes 3 saved recipes and unlimited rows. Pro (£15/month) adds currency conversion, Excel export, and AI column matching.

What file formats does Mappd support?

CSV, TSV, XLSX, XLS, and ODS. Mappd handles encoding issues common in NetSuite exports, including Latin-1 encoding, title rows above the header, and blank rows in the data.

Try it on your actual file.

The NetSuite to Excel recipe loads automatically. Drop your file and it maps in 5 min.

Open Mappd with this recipe →

No signup · Free for files under 5 MB · See pricing