Reconcile bank and Stripe payouts with your ledger automatically
How do I reconcile bank and Stripe payouts with my ledger without doing it by hand?
The problem, in your words
Money comes in through the bank and through Stripe. A Stripe payout is one amount, but inside it are many payments, minus fees, minus refunds. Someone has to split it back into the invoices it pays, then match it to the ledger. At month end it takes days. Whatever does not match gets pushed to next month.
What we build
A tool that matches the money that arrived with what your ledger says should have arrived.
- It reads your bank lines and your Stripe payouts.
- It splits each payout into the payments, fees and refunds inside it.
- It matches each payment to the invoice it pays, using the amount, the date, the customer and the reference.
- It suggests the entry for each fee and refund, using your rules.
- What it cannot match goes on a leftover list. Each line has a reason, like "no open invoice with this amount" or "more than one invoice could fit".
- A person works through the leftover list. The tool does not post anything to your ledger unless your rules allow it.
- It logs every match, so your accountant can see why each payment went where it did.
What we need from you
- Read-only access to your bank exports and your Stripe account.
- Read access to your ledger or accounting system.
- Your rules for fees and refunds. If they are not written down, we write them with you on the first day.
- One person who can say yes.
How you know it works
On the first day we write 3 to 5 tests with you. For example: a payout with a refund inside it is split, and every part is matched to the right invoice. A payment with no open invoice lands on the leftover list with its reason. The tool is done when it passes your tests on your real payouts.
What this page is
We build this to order. We have built tools that check data against written rules, like the delivery order operator. Fixed price, 5 working days.
Contact