Free reconciliation checklist
A repeatable Stripe payout reconciliation template
Use this checklist before every QuickBooks import. It is intentionally narrow: one supported automatic-payout report, one reviewed account mapping, and one journal that balances to the cent.
1. Confirm the source
- The file is payout_reconciliation.itemized.7.
- The payout is automatic, not manual or instant.
- The currency is CAD or USD.
- The CSV comes directly from Stripe and has not been edited in a spreadsheet.
2. Validate the settlement
- Every required column is present.
- Every row satisfies gross + fee = net.
- The report contains at least one supported payout.
- Each payout total agrees with the expected bank settlement.
3. Review account mappings
- Each payout currency has the correct bank account.
- The Stripe fee account is correct.
- Every activity category has a reviewed account name.
- Tax and classification decisions have been made outside the converter.
4. Approve the import
- The journal date and payout identifier are correct.
- Total debits equal total credits.
- The QuickBooks CSV contains only the intended payout.
- The audit receipt contains no unexpected validation warning.
Frequently asked questions
- Can I use the checklist without giving an email?
- Yes. The checklist and synthetic sample workflow are available without an account or email address.
- Is the template a spreadsheet?
- It is a review checklist paired with PayoutBridge’s synthetic browser sample. The production output is a QuickBooks journal CSV.
- What happens when a check fails?
- Do not import. Correct the source or mapping, or stop if the report is outside the supported scope.