Platform Payout Fee Log: Gross Billed to Net Deposit
A freelancer who invoices through a marketplace or client platform often sees three different numbers for the same job: the amount the client approved, the fees the platform withheld, and the cash that finally landed in the business bank account. When those three figures live only in email notifications, the year-end books, Form 1099-K or 1099-NEC matching, and bank reconciliation all become harder than they need to be. A platform payout fee log does a narrow job. It records each payout with a stable ID, states gross billed (or gross earnings for that payout), itemizes platform fees and other withholdings you choose to track, states net deposit, and ties the net line to bank evidence. The log is not a determination of taxable income, not advice about deducting platform fees, and not a substitute for reading the information returns the platform or client may issue.
This guide is US federal recordkeeping education as of the source-check date, 2026-11-05. It is a bookkeeping illustration, not tax advice, not a method election, and not advice about state conformity. Every platform name, client, and dollar below is synthetic. The IRS page What is taxable and nontaxable income? sits upstream of classification questions: clean books come first. Recordkeeping expectations for small businesses and self-employed taxpayers are summarized on Recordkeeping. Marketplace payment reporting context appears on Understanding your Form 1099-K; this sheet still only tracks payout math and evidence. Read the disclaimer before treating any page here as a filing instruction. Neighboring trails include the 1099-NEC and 1099-K matching worksheet and the bank reconciliation trail.
Why gross-to-net needs its own sheet
Bank feeds show deposits, not the story above the deposit. A $1,850 deposit might be $2,000 of approved billings minus $150 of platform service fees—or $2,100 of billings minus fees and a client credit. Without a payout log, monthly revenue in the books can silently equal net deposits, which understates gross earnings and hides fee expense (or fee reduction of revenue, depending how you post). Either posting pattern can be valid for management books; what fails is having no document that shows gross, fees, and net for each payout ID.
Keep direct client ACH or check payments that never touch a marketplace on a separate invoice-to-bank trail. This sheet is for platform-mediated payouts: freelance marketplaces, app-store style seller payouts, or similar intermediaries that show gross earnings and fees before sending net cash. Mixing pure direct deposits into this log creates rows with zero fees that belong elsewhere and clutter the residual checks.
Fields: one payout header, fee lines, bank match
A usable payout log needs a payout ID, platform name, platform account or seller ID, payout or transfer ID from the platform UI, payout date, currency, gross billed or gross earnings for that payout, fee total, other adjustments (tips to you, refunds clawed back, reserves released—each in its own column or child row), net expected, bank deposit date, bank reference, net deposited, match status, and an evidence link (platform payout CSV or PDF plus bank line export ID).
Fee child rows (optional but useful) carry: fee line ID, payout ID, fee type label (service fee, payment processing, membership withheld, withdrawal fee), amount, and platform description text copied exactly. The sum of fee lines plus other signed adjustments must explain the bridge from gross to net: gross − fees ± adjustments = net expected. If that identity fails, stop. Find a missing refund clawback, a withheld tax line, or a currency conversion difference—do not plug.
Write the inclusion rule once in the header. The example rule is: include platform payouts for the trade or business when the platform shows a gross earnings figure and a net transfer; exclude direct client wires; exclude owner capital transfers; exclude loan draws. Your facts may differ. The sheet applies one written rule consistently.
Worked example: one synthetic freelancer month
The figures in this section are synthetic. They are not a real taxpayer, not a recommended platform mix, and not a finding about income inclusion, fee deductibility, or information-return thresholds.
Assume sole proprietor Jordan runs cash-basis management books and receives Upwork-style and similar marketplace payouts into one business checking account. Opening rule on the sheet: calendar month 2026-10, USD, business payouts only, fees posted as a separate expense account for management reporting (the log itself only stores amounts).
Payout PO-26-10-01 on 2026-10-08: platform "NorthGig", transfer ID NG-88421, gross earnings $2,000.00 for two fixed-price contracts, service fees $200.00 (itemized as two fee lines $120.00 and $80.00), no other adjustments, net expected $1,800.00. Bank deposit 2026-10-09 ref ACH-26-4418 for $1,800.00. Match status: matched.
Payout PO-26-10-02 on 2026-10-22: platform "NorthGig", transfer ID NG-89102, gross earnings $950.00, service fee $95.00, withdrawal fee $2.99, net expected $852.01. Bank deposit 2026-10-23 ref ACH-26-4502 for $852.01. Match status: matched.
Payout PO-26-10-03 on 2026-10-29: platform "SketchCart", transfer ID SC-22011, gross earnings $1,400.00, marketplace commission $140.00, client-funded bonus included in gross $0.00 extra (already inside gross), reserve holdback released as adjustment +$50.00 (prior job reserve), net expected $1,310.00. Bank deposit still pending as of the sheet's close date 2026-11-05. Match status: open—net expected recorded, bank ref blank.
Jordan's October bank deposits that cleared are $2,652.01. Gross platform earnings on the log are $4,350.00. Fee and adjustment bridge is $387.99. Cleared net plus open net equals $3,962.01, which equals gross minus net fees/adjustments. Anyone posting only bank deposits as "income" would book $2,652.01 in October and miss both the open SketchCart payout and the fee story. Anyone posting gross without fees would overstate cash.
Residual check on 2026-11-05: sum of net expected for matched rows equals sum of bank nets for those rows; open rows have blank bank refs; month gross minus fee/adjustment bridge equals sum of net expected. All three identities hold without a plug figure.
Gross definitions, refunds, and reserves
Platforms label "gross" differently: client billings, earnings after client discounts, or earnings after some fees. Copy the platform's payout statement definition into the header for that platform account. If NorthGig's CSV column is "Assignment earnings" before service fees, use that as gross on this sheet and keep service fees in the fee columns. Do not invent a second gross that matches your invoice PDF unless you also keep a reconciliation column between invoice total and platform gross.
Refunds and chargebacks that reduce a later payout should appear as signed adjustments (or negative gross lines) linked to the original job ID. Silent edits to an older payout row destroy the audit trail. Prefer a new adjustment line on the payout that actually moved cash.
Reserves held and later released need two events: a hold that reduced an earlier net, and a release that increases a later net. If your earlier sheet already recorded the reduced net, the release is a positive adjustment on the later payout—not new gross sales.
Common log failures
Booking bank deposits as income and never recording gross or fees. That collapses three facts into one and breaks later 1099-K or 1099-NEC matching.
Using the marketing platform name without the payout transfer ID. Store both: human nickname and the immutable transfer ID from the export.
Combining two payouts that cleared as one ACH. Rare, but when it happens, split using the platform export; do not leave a single bank line matched to two payout IDs without a split worksheet.
Treating platform fee VAT or sales tax lines as service fees without a note. Keep tax-like lines in their own adjustment column so fee totals stay comparable month to month.
Closing an open payout by forcing bank net to equal expected when the ACH is short. Investigate short pays (extra withdrawal fee, currency FX, partial reserve). Record the true bank net and an explicit variance line.
How this sheet connects to 1099 matching and bank reconciliation
Year-end platform totals on this log should feed the 1099-NEC and 1099-K matching worksheet. Form 1099-K reporting rules and what the form means for payees are summarized by the IRS on Understanding your Form 1099-K; thresholds and payer practices can change by tax year, so the match worksheet—not this payout log—owns the return-side comparison. This log only supplies gross, fees, and net trails with stable IDs.
Each matched bank reference should survive the month-end bank reconciliation. If a payout sits in a platform wallet for days before withdrawal, record wallet transfer and bank arrival as linked events so reconciliation does not invent a missing deposit.
When a personal bank account accidentally receives a platform payout, resolve ownership on the books first, then still preserve the payout ID and evidence. The payout log is not a substitute for separating personal and business accounts over time; see also the one-card personal/business split for card-side mixing.
A one-page template to copy
Header: calendar month or year, inclusion rule, platforms in scope, fee posting note (expense vs contra-revenue for management books), owner name. Payout columns: payout ID, platform, transfer ID, payout date, gross, fee total, adjustments, net expected, bank date, bank ref, net deposited, match status, evidence link. Fee child columns: fee line ID, payout ID, type, amount, platform text. Period close line: for matched rows, net expected minus net deposited equals zero; for all rows, gross − fees ± adjustments − net expected equals zero; list any break.
Assumptions and limits
All examples are hypothetical. Whether platform fees are deductible, how gross income is measured for federal income tax, self-employment tax treatment, and how Forms 1099-NEC or 1099-K relate to your books can change by tax year and by facts. This page does not determine taxable income, does not prepare a return, does not set a material participation or contractor classification position, and does not replace the IRS pages linked below or a qualified professional when your facts are nonstandard. Check the stated assumptions and current IRS guidance before using the log in a filing workflow.
Sources and method
- IRS: Recordkeeping — retrieved 2026-11-05
- IRS: What is taxable and nontaxable income? — retrieved 2026-11-05
- IRS: Understanding your Form 1099-K — retrieved 2026-11-05
- IRS: Small Business and Self-Employed Tax Center — retrieved 2026-11-05
AI-assisted writing with automated source, calculation and editorial checks. No hands-on testing or professional certification is claimed. Check the stated assumptions before applying this guide.