Pick the app the file came from
- Stripe payout reconciliationStripe payouts to a QuickBooks journal entry
- Etsy statement, sold orders or depositsEtsy payouts to a QuickBooks journal entry
- Airbnb earnings (transaction history)Airbnb payouts to a QuickBooks journal entry
- Gumroad payout or sales CSVGumroad payouts to a QuickBooks journal entry
- Square transactions CSVSquare payouts to a QuickBooks journal entry
- Shopify Payments payouts CSVShopify Payments payouts to a QuickBooks journal entry
- Amazon settlement report (Flat File V2)Amazon settlement report to QuickBooks
- eBay transaction report CSVeBay transaction report to a QuickBooks journal entry
From a bank CSV
Bank CSV exports differ from bank to bank: some use one signed amount, some separate debit and credit columns, dates may be day-first or month-first, and many add header or total rows. Choose "Bank CSV" as the source (it is picked automatically when the file is not from a known app).
- In your online banking, find Download or Export transactions.
- Choose CSV (sometimes called Excel CSV or Comma separated).
- Pick the date range and download.
- We look for the header row even if the file starts with account details.
- We map Date, Description and Amount, or separate Debit and Credit columns, automatically, and show the result in the preview.
- We work out whether dates are month/day or day/month and whether "," or "." is the decimal point from the file itself; when the file cannot tell, we ask you instead of guessing. Dotted dates (31.01.2025) are read day first.
- Card exports that show purchases as positive numbers can be flipped with the "invert sign" option.
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).
How to import it
- Make sure every account named in the file exists in your chart of accounts (or change the account names before downloading).
- In QuickBooks Online go to Settings (gear) > Import data > Journal entries.
- Upload this CSV and map Journal No., Journal Date, Account Name, Debits, Credits, Description and Name.
- Review and import. Each payout (or month) becomes one balanced entry.
Questions
- 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.
- 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.
- Does each journal entry balance?
- Yes. The debits and credits of every entry are equal to the cent. Money that stays in the platform balance, or activity not yet paid out, is booked to the clearing account so each entry still balances, and the notes say when that happens.
- Why do some descriptions start with an apostrophe?
- A text cell that begins with =, +, - or @ could be run as a formula if the CSV is opened in a spreadsheet. The converter puts an apostrophe in front of such cells, which is the usual protection; the preview shows each cell exactly as it is written.