Home / Templates / Shopify
Shopify to QBO
Shopify payouts CSV → QuickBooks .QBO for clean bookkeeping.
Step-by-step
- 1In Shopify Admin → Finances → Payouts → Export.
- 2Upload the CSV here.
- 3Map Transaction Date → Date, Type → Description, Amount → Amount.
Column mapping
| Shopify CSV column | QuickBooks .QBO field |
|---|---|
| Transaction Date | DTPOSTED |
| Type / Order | NAME |
| Amount | TRNAMT |
Tips
- Fees and refunds appear as separate rows — that's expected.