Skip to main content
Loopfour
Workflow templates

PAYMENT RECONCILIATION & CASH APPLICATION

Every Stripe payout reconciled to the general ledger, fees and all.

Pull the balance transactions behind each Stripe payout, break them into charges, fees, refunds, and chargebacks, match them to invoices and the clearing account, and post the journal entry, routing only true exceptions to a person.

StripeNetSuiteCodeSlack
How it is built
1

Webhook trigger fires on a new Stripe payout

2

Stripe block lists the balance transactions that make up the payout

3

Code block decomposes them into charges, fees, refunds, and chargebacks

4

Loop block matches each charge to its invoice

5

Condition block routes unmatched items to an exception path

6

NetSuite block posts the clearing-account journal entry

7

Slack block lists any exceptions for review

01

The problem

The problem

A Stripe payout is not one number. It is a net of charges, processing fees, refunds, and chargebacks, and the general ledger needs each piece booked correctly against a clearing account. Doing that by hand means an accountant ties out every payout in a spreadsheet, which is slow and easy to get wrong at volume.

02

How it is built

How it is built
  1. 1Webhook trigger fires when Stripe reports a new payout.
  2. 2Stripe block lists the balance transactions that make up the payout, so the decomposition works from the real underlying records.
  3. 3Code block breaks them into their component charges, fees, refunds, and chargebacks.
  4. 4Loop block matches each charge to its originating invoice.
  5. 5Condition block routes anything that does not match cleanly to an exception path, and lets matched items continue.
  6. 6NetSuite block posts the clearing-account journal entry with every component broken out.
  7. 7Slack block lists the exceptions so a person handles only what actually needs judgment.

03

The payoff

The payoff
ComponentManual reconciliationWith this template
Charge to invoice matchLine by line in a sheetMatched in a loop
FeesOften booked in a lumpBroken out per payout
Refunds and chargebacksReconciled laterBooked in the same entry
ExceptionsBuried in the sheetSurfaced to Slack

Want this workflow built and maintained for your finance stack?

Book a demo