How to Record Payment Processor Payouts in QuickBooks

A processor payout is usually one bank deposit, but the accounting behind it has several parts: gross customer payments, processing fees, and the net amount that reaches the bank. Recording only the net deposit hides the fee and understates gross activity.

Use a balanced journal for the split

For a positive payout of 1,000.00 with a 30.00 processor fee and a 970.00 bank deposit, the accounting split is:

The debits equal the credits. If you use a processor clearing account instead of posting gross activity directly to Sales, select that clearing account as the gross account.

Why a bank CSV is not enough

QuickBooks Online's manual bank CSV upload is transaction-shaped: it accepts the date, description and amount (or separate credit/debit columns). It does not carry multiple accounting lines for one bank transaction. QuickBooks' journal-entry CSV import does support repeated journal numbers with debit and credit lines, which is why it fits a processor payout split.

Build the journal from your payout export

Use the payout ID as the journal number, the payout date as the journal date, and map gross, fee and net columns from the processor export. The builder checks that gross minus the absolute fee equals the reported net before it creates the journal rows. If your export does not include net, the tool derives it.

Import and reconcile

After downloading the prepared CSV, open QuickBooks Online's Journal Entries import, map the six columns, review the preview, and import. Then reconcile the generated bank-side amount against the payout that actually appears in the bank feed. The tool prepares the split; your chart of accounts and reconciliation policy remain yours.

quickbooks-processor-payout-csv-import-builder

See the transformation

Awkward source headers become import-ready columns.

Rename the columns you need while keeping every value under the correct header.

cust_idcustomer_id

given_namefirst_name

mailemail

✓ Values stay with the right column