Gumroad payouts to a QuickBooks journal entry

1. Export the file from Gumroad

1. Best for your books: open Payouts in Gumroad and click the download button next to a paid payout; the CSV is emailed to you.
2. For several payouts, use the download button at the top right of the Payouts page.
3. Sales CSV: open Sales, click the Export icon, choose the date range, and download.

Why a raw Gumroad export fails in QuickBooks Online (journal entry import)

The deposit from Gumroad is a payout of net sales for a period. A journal entry per payout records gross sales, Gumroad fees and refunds and nets to the deposit.

Importing every sale from a payment platform straight into the bank account never matches the bank, because the platform pays out one net amount after taking its fees and refunds. The usual fix is one summary journal entry per payout (or per month when the export does not link sales to payouts): gross sales counts only money received, payments you sent get their own line, fees on a payout or instant transfer are expensed so the bank line is only what arrived, payments the export clearly marks as funded by a card go to a card account instead of the bank (unclear funding labels go to the bank, with a note), and a chargeback you win reduces refunds. You then match the bank line against the deposit in your bank feed.

What is unusual about the Gumroad file

• The payout CSV ends with "Subtotal" and "Totals" rows, which we skip and use as a check.
• Refunds, chargebacks and payout fees are their own dated rows in the payout CSV.
• The sales CSV only flags refunds on the original sale, with no refund date.
• All dollar columns are USD; dates are UTC.
• Text that starts with =, +, - or @ is prefixed with an apostrophe by Gumroad; it is kept, and CSV outputs add one to any text cell that starts that way.

What QuickBooks Online (journal entry import) requires

• Each entry shares one Journal No. and date, and its debits equal its credits.
• Lines show gross sales (money received), refunds, fees, taxes, payments you sent (on their own line, not deducted from sales), transfers between the platform and your bank (booked as transfers, never as income or expense), and the deposit that hit your bank.
• Account names must match your chart of accounts exactly; subaccounts as Parent:Sub.
• Up to 1,000 lines per file (we split bigger files without breaking an entry).

2. Before and after

Type,Date,Purchase ID,Item Name,Buyer Name,Buyer Email,Taxes ($),Shipping ($),Sale Price ($),Gumroad Fees ($),Net Total ($)
Sale,2026-03-02,uzP3TestPurchase001==,Notion Budget Template,Jesse Example,jesse@example.com,1.71,0.0,19.0,3.25,15.75
Sale,2026-03-03,uzP3TestPurchase002==,"Icon Pack, Vol. 2",,buyer2@example.com,0.0,0.0,9.0,1.6,7.4
Sale,2026-03-05,uzP3TestPurchase003==,Notion Budget Template,Morgan Example,morgan@example.com,0.0,0.0,19.0,3.25,15.75
Full Refund,2026-03-08,uzP3TestPurchase003==,Notion Budget Template,Morgan Example,morgan@example.com,0.0,0.0,-19.0,-3.25,-15.75
Payout Fee,2026-03-10,,,,,0.0,0.0,0.0,0.5,-0.5
Subtotal - activity paid out by Gumroad,,,,,,1.71,0.0,28.0,5.35,22.65
Totals,,,,,,1.71,0.0,28.0,5.35,22.65

3. Import the converted file into QuickBooks Online (journal entry import)

1. Make sure every account named in the file exists in your chart of accounts (or change the account names before downloading).
2. In QuickBooks Online go to Settings (gear) > Import data > Journal entries.
3. Upload this CSV and map Journal No., Journal Date, Account Name, Debits, Credits, Description and Name.
4. Review and import. Each payout (or month) becomes one balanced entry.

Questions

How do I record Gumroad sales in Xero or QuickBooks?

Either import the payout CSV into a separate Gumroad account (sales in, fees and payouts out), or record one journal entry per payout: gross sales to income, fees to an expense account and the payout amount to the bank.

Why record payouts as a journal entry instead of importing every sale?

Your bank receives one deposit per payout, already reduced by fees and refunds. If each sale goes into the bank account separately, the bank feed shows one deposit you cannot match to dozens of entries. A journal entry per payout records gross sales, fees and refunds in their own accounts, and a bank line of exactly the deposit amount.

Why is my Gumroad payout smaller than my sales?

Gumroad deducts its fees, plus any refunds and chargebacks, before paying out. The converter lists each deduction and checks its total against the Totals row in the file.

Which accounts should the journal entry use?

Every account named in the file has to exist in your QuickBooks chart of accounts already, so set the account names in the options to the ones you use: sales, fees, payments you sent, the clearing account for money still held by the platform, the bank account that receives transfers, and the card account for payments the export clearly marks as paid from a card. This is not accounting advice; ask whoever prepares your return if you are unsure.

Other ways to convert Gumroad

• Import a Gumroad payout CSV into Xero
• Convert a Gumroad payout CSV to QuickBooks Online

Other exports to QuickBooks journal entry

• Stripe payouts to a QuickBooks journal entry
• Etsy payouts to a QuickBooks journal entry
• Airbnb payouts to a QuickBooks journal entry
• Square payouts to a QuickBooks journal entry
• Shopify Payments payouts to a QuickBooks journal entry
• Amazon settlement report to QuickBooks
• eBay transaction report to a QuickBooks journal entry

Common import problems

• Your Stripe payout does not match your sales
• Your Etsy deposit does not match your sales
• Your Airbnb payout does not match your reservations