Skip to main content

QuickBooks Processor Payout CSV Import Builder

Nothing uploadedTested up to 200 MB

Turn payment processor payout CSV rows into balanced QuickBooks Online journal-entry splits for the bank deposit, processor fees, and gross sales or clearing account — locally in your browser.

Processed locally in your browser

Processor payout to QuickBooks journal CSV

Map a processor payout export, validate each gross/fee/net relationship, and generate balanced QuickBooks journal-entry rows locally in your browser up to 200 MiB.

Choose the processor payout CSV

Use a payout or settlement export with one row per processor payout.

One CSV up to 200 MiB. File contents stay on this device.

Download example CSVBrowser-local processing; payout and accounting data are not uploaded to Nablyx.

Set QuickBooks accounts

Enter account names exactly as they exist in QuickBooks. Subaccounts can use Parent account: Sub Account.

For a normal positive payout, the net amount is debited to the bank or clearing account, fees are debited to the expense account, and gross is credited to sales or clearing. Negative payouts reverse the bank and gross sides while fees remain an expense.

How each payout is split

The output uses QuickBooks Online journal-entry import because the bank-transaction CSV upload cannot carry a split transaction. Each source payout becomes one balanced journal number.

Net bank debit + processor-fee debit = gross sales/clearing credit (with debit/credit sides reversed for a negative gross payout).

Build a QuickBooks-ready journal import from processor payouts

  1. 1

    Choose the processor payout CSV from your device.

  2. 2

    Map payout ID, payout date, gross amount, and optional fee, net, and description columns.

  3. 3

    Set the QuickBooks bank, processor-fee, and gross sales or clearing accounts.

  4. 4

    Run the preflight to verify dates, amounts, gross-minus-fee equals net, and balanced journal splits.

  5. 5

    Download the six-column QuickBooks journal-entry CSV and import it through QuickBooks Online Journal Entries.

Built for the real task

  • Gross, fee, and net payout reconciliation
  • Balanced two- or three-line journal splits
  • QuickBooks journal-entry CSV output
  • Browser-local processing

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

Browser limits

Files are limited to 200 MB to protect browser stability, especially on phones. Processing stays on this device.

Gross, fee, and net payout reconciliation

Turn payment processor payout CSV rows into balanced QuickBooks Online journal-entry splits for the bank deposit, processor fees, and gross sales or clearing account — locally in your browser.

Private by design

The selected file is not uploaded to Nablyx.

Processed locally in your browser

No. This tool reads and transforms the file locally in your browser.

Common uses

  • Gross, fee, and net payout reconciliation
  • Balanced two- or three-line journal splits
  • QuickBooks journal-entry CSV output
  • Browser-local processing

Why does the tool create journal-entry rows instead of a bank-transaction CSV?

QuickBooks Online bank CSV upload accepts transaction rows but does not encode accounting splits. Journal-entry CSV import supports multiple debit and credit lines under one journal number, so it can represent a net bank deposit, processor-fee expense, and gross sales or clearing amount in one balanced payout entry.

Ready to work on your file?

Return to the workspace and process it locally.

Build QuickBooks payout journal CSV