Reconciling a daily Stripe payout against the NetSuite bank deposit

Stripe

Open the Payouts page and click the payout marked Paid on yesterday's date.

Filter by status Paid and exclude payouts that are still in transit. There is normally one payout per business day; if two appear the second is usually a refund-only payout and needs the same treatment as the first.

Expected: The payout detail screen shows gross, fees and net amounts plus the underlying balance transactions.

Stripe

Export the payout using the unified balance transactions CSV with itemised fees.

The default summary export collapses every fee into a single row. Always pick the unified itemised version so each charge, refund and processor fee comes through as its own line. This is the only export that lets NetSuite split fees cleanly.

Expected: A CSV downloads with one row per balance transaction including separate fee, charge and refund lines.

NetSuite

Open the bank reconciliation screen for the operating account and locate the unmatched deposit by net amount and date.

Match by the net amount that hit the bank, not the gross. If two payouts settled the same day, sort the unmatched deposits by amount and pick the larger first to avoid splitting the wrong CSV across the wrong deposit.

Expected: The Stripe deposit row is highlighted as unmatched on the bank reconciliation screen.

NetSuite

Create a journal entry posting gross revenue to the deferred revenue accounts and Stripe processing fees as a separate expense to GL 6700-8.

Always split the fee out. Do not let NetSuite's auto-match collapse fees into the deposit. The fee total from the CSV goes to GL 6700-8 and the gross goes against the customer-specific deferred revenue account so that recognition continues at gross.

Expected: The journal entry totals match the gross payout and the fee total ties to the Stripe report.

NetSuite

Match the journal entry to the bank deposit and confirm the difference is zero.

The difference must be zero before saving. A non-zero difference is almost always a refund that landed inside the payout but was not coded; scan the CSV for negative-amount lines and add a credit memo if needed before saving.

Expected: Bank deposit and journal entry are matched with zero difference.

NetSuite

Tag any balance transaction without a matching customer or invoice with the Stripe payment intent ID and flag it for orphan investigation.

Never park unmatched lines in a suspense account. Suspense balances quietly accumulate and become impossible to clear at month-end. Flag the line the same morning so the AR specialist can investigate before the customer dispute window opens.

Expected: Unmatched lines are tagged with their Stripe IDs and added to the AR specialist's investigation queue.

NetSuite

Save the reconciliation, mark the period as bank-reconciled to date and append the payout ID to the close checklist.

The close checklist needs a daily marker so FP&A can confirm the period is current. Include the payout ID and the gross amount in the note so the audit trail carries the full history without anyone needing to reopen the reconciliation.

Expected: The reconciliation is saved, the close checklist shows today as reconciled and the audit log is updated.