How to Reconcile Gross Sales, Processor Fees, and Net Payouts in QuickBooks
Understand the gross-minus-fee-equals-net check behind payment processor settlements and turn it into a balanced QuickBooks entry.
Payment processors commonly settle many customer charges into one payout. The bank sees the net deposit, while the processor report shows gross activity and fees. A reliable reconciliation starts with one equation:
gross amount - processor fees = net payout
Check the settlement before posting
Suppose a payout report shows gross 875.40, fees 26.26 and net 849.14. Those values reconcile exactly. If the reported net were 849.10, do not force the journal to balance by changing an account line. First investigate the four-cent difference in the source export: reserves, adjustments, refunds, taxes, currency conversion or a fee column you have not included may explain it.
| Value | Example | QuickBooks side |
|---|---|---|
| Net payout | 849.14 | Debit bank/clearing |
| Processor fee | 26.26 | Debit fee expense |
| Gross amount | 875.40 | Credit sales/clearing |
Choose the gross account intentionally
Some businesses credit Sales directly. Others already record sales from invoices, ecommerce orders or a POS and therefore use a processor clearing account for the gross side. The payout builder does not infer this choice because doing so could duplicate revenue. Enter the account that matches your bookkeeping workflow.
Fees are normally an expense line
The builder treats the fee amount by magnitude so exports that show fees as either 30.00 or -30.00 produce the same 30.00 debit to the fee expense account. The net check uses the absolute fee amount too.
Handle negative settlements
A refund-heavy or reserve adjustment can produce a negative gross payout. In that case the bank and gross sides reverse: the bank amount is credited and the gross account is debited. The fee remains an expense debit. The generated journal must still balance.
Keep reconciliation separate from import format
A structurally valid QuickBooks journal can still be wrong for your books if the selected accounts are wrong. Use the builder to validate arithmetic and create import-ready rows, then use QuickBooks reconciliation to match the bank-side line to the actual settlement.
quickbooks-processor-payout-csv-import-builderSee the transformation
Awkward source headers become import-ready columns.
Rename the columns you need while keeping every value under the correct header.
cust_idcustomer_idgiven_namefirst_namemailemail✓ Values stay with the right column
Need to do this now?
How to Reconcile Gross Sales, Processor Fees, and Net Payouts in QuickBooksRelated tools
Open the tool this guide is about, or explore a related one.
- QuickBooks Journal Entry CSV PreparerMap recurring accounting exports to QuickBooks Online journal-entry columns, validate dates and balanced debits/credits locally, then download a prepared CSV.
- CSV column mapper and renamerRename, reorder, and remove CSV columns before importing data into a CRM, store, database, or accounting system — without uploading your file.
- Clean and fix CSV files — no uploadRepair common CSV problems including wrong delimiters, uneven rows, empty lines, whitespace, BOM markers, and duplicate headers.