Payout to journal entry
A payout from a marketplace such as Shopify is sales, shipping, and tax collected, less fees and refunds. Type the components or open the rows that make up the payout, name the account for each, and enter the bank deposit. The tool builds one journal entry and proves the components add up to the payout, the payout equals the deposit, and debits equal credits.
Any file you open is read in your browser and stays on this device. Nothing is uploaded. The typed entry is kept as a draft in this browser only.
Or paste the rows, with the header row first:
Columns are matched from the header words. Check them and change any that are wrong.
What each row type counts as:
The rows are read in this browser and are not uploaded.
Payout
Optional: open a bank statement export to pick the deposit from it.
Components
One row per part of the payout. Amounts that add to the payout (sales, shipping, tax collected) are positive; amounts that take away from it (fees, refunds) are negative. Type the account name you use for each.
| Component | Account | Amount |
|---|
Journal entry
This tool is independent. It is not affiliated with, endorsed by, or sponsored by Etsy, Shopify, Amazon, eBay, or any other marketplace. Marketplace names are used only to describe the exports people bring to it.
What gets checked
- The components add up to the payout amount the marketplace reports.
- The payout equals the bank deposit, to the cent. With no deposit entered this is shown as a warning, never as a pass.
- The journal entry balances: debits equal credits.
- The journal lines re-add to the components, worked out a second way.
How it works
- Enter the components. Type one row per part of the payout with its amount: positive for what adds to the payout, negative for what takes away from it. Or open the payout's rows (.csv or .xlsx) exported from the marketplace, check the column mapping and what each row type counts as, and fill the components from them.
- Name the accounts. Each component starts with a plain label as its account. Type the account name used in your own books for each one, and for the bank deposit.
- Enter the payout and the deposit. Type the payout amount the marketplace reports and the deposit that reached the bank, or open a bank statement export and pick the deposit from it.
- Review and download. The journal entry is shown with the certificate. Download Excel or CSV, or print.
Worked example
A made-up payout of $136.00 on June 5, 2026, built from six rows: two sales with fees, shipping, tax collected, and a partial refund that hands back part of a fee. The bank statement shows a deposit of $136.00.
| Component | Account | Debit | Credit |
|---|---|---|---|
| Payout | Checking | $136.00 | |
| Sales | Sales | $165.50 | |
| Shipping charged to buyers | Shipping income | $6.00 | |
| Tax collected | Sales tax collected | $3.61 | |
| Fees on Refund rows | Marketplace fees | $1.95 | |
| Fees on Sale rows | Marketplace fees | $11.06 | |
| Refunds | Refunds | $30.00 | |
| Total | $177.06 | $177.06 |
The components add up to $165.50 + $6.00 + $3.61 + $1.95 − $11.06 − $30.00 = $136.00, the payout. The payout equals the $136.00 bank deposit. Debits and credits are $177.06 each. All 4 checks pass.
The example uses made-up names and numbers.
Questions
What if the components do not add up to the payout?
The difference is shown as payout not explained by the components, the first check fails with the amount it is off by, and the journal entry does not balance. A reserve held back, a fee that was missed, or a row from another payout are common causes.
What if the deposit has not reached the bank yet?
Leave the bank deposit blank. The entry is still built and balanced, and the certificate carries a warning that the payout was not matched to the bank.
Which accounts are right for sales tax, fees, or refunds?
That depends on the books in question and is a decision for the seller or their accountant. The tool posts each component to whatever account is typed for it and checks the arithmetic.
Which payout exports does it read?
Any .csv or .xlsx with a header row and columns for date, row type, and amount. No marketplace's layout is assumed: header words are matched, the choices are shown, and each one can be changed. Components can also be typed by hand with no file at all.
Is this tool connected to Shopify, Amazon, eBay, or Etsy?
No. It is independent and is not affiliated with, endorsed by, or sponsored by any marketplace or bank. It never signs in anywhere; it only reads the files you open, in your browser.
This tool calculates and checks numbers. It is not legal, tax, or medical advice.