Friday’s supplier bill is C$7,000. The sales dashboard shows C$8,000 in captured card payments. If the bank makes the matching C$5,600 payout available by the 3 p.m. deadline, the bill fits and there’s C$700 to spare above the business’s chosen cash minimum. If the credit becomes usable at 4 p.m., the business is C$3,900 short at 3 p.m.
The difference comes down to which transactions belong to the payout, how much that batch carries, and when the business can use the money. The fictional Friday below shows how to check all three for one Canadian business with an automatic CAD payout to its own operating account.
Follow the money from Stripe to the bank
Stripe’s payout schedule governs when it sends funds that are available in Stripe. Settlement governs when payment proceeds reach that available Stripe balance. Your bank can take additional time to make the deposit usable. Stripe also describes how a payout initially marked paid can later fail. Stripe’s payout documentation
Start with the bill. Write down the amount, which business and account will pay it, the latest time the payment can be made, and the time zone. If the deadline depends on when a supplier receives the payment, confirm the time you need to initiate it and use that earlier time in the worksheet. Decide how much the business wants left in the account after paying.
Then work through the records in order. Use captured card sales to identify potential receipts. Check what has reached the available Stripe balance, then find the smallest unit you can trace all the way to the bank: the one payout you are counting on. Record its estimate and current status, then find the actual bank deposit and check when the bank made it usable for this payment. Keep the bank posting time and availability time in separate fields when they differ.
Until the bank confirms usable cash for the matching credit, keep the amount in the expected column.
Work out how much the selected batch carries
Stripe’s itemized payout reconciliation report groups transactions for automatic payouts using its estimated arrival date. Find the payout ID within Stripe and check the included charges, refunds, disputes, fees and other balance activity against the reported net. The report’s available_on field refers to the Stripe balance. Report data can become available after the bank receives the deposit. Stripe’s payout reconciliation report
Keep each row in the payout’s currency. As you reconcile the batch, choose one starting point. If you start from included gross charges, account for each listed adjustment once. If you start from the net rows, sum those rows without deducting the fees or refunds again. Record any unexplained difference alongside the batch ID so the next person knows which amount still needs checking.
The bank record may show a different reference from Stripe’s internal payout ID. Compare the bank evidence you have with the processor record, including the amount, currency, destination account and timing. If two credits could match, or the amounts disagree, keep the reconciliation open. A similar amount provides a lead for the next check. An available bank balance can still be used as a cash snapshot, provided each receipt already included in it stays out of the additions column.
Check the same bill at 3 p.m. in three scenarios
It’s Friday, November 20, 2026. Everything in this example is fictional, including the dates, amounts and processor charges. All times are Toronto time and all amounts are Canadian dollars. One C$7,000 supplier bill is due at 3 p.m. The owner wants at least C$1,000 left after paying it. The 9 a.m. available bank balance is C$4,200 and excludes the payout. A separate C$1,100 payment leaves at noon. These are the only other cash movements before the deadline.
The sales view shows C$8,000 in captured card sales. The itemized records are available for this example. They assign C$6,400 of those sales to the selected payout, with the other C$1,600 still unassigned in the owner’s worksheet. The selected batch includes a C$450 refund debit, a C$160 dispute debit and C$190 in processing fees. That leaves C$5,600 net (C$6,400 − C$450 − C$160 − C$190). The C$1,600 outside the batch stays on the reconciliation list until there’s evidence of where it went.
The credit is usable at 11 a.m.
The bank confirms C$5,600 of available credit that matches the selected batch. At 3 p.m. the business has C$8,700 before the supplier payment (C$4,200 + C$5,600 − C$1,100). Paying C$7,000 leaves C$1,700, which is C$700 above the chosen minimum. Both the payment and the cash minimum fit.
The credit is usable at 4 p.m.
Friday is still the expected arrival day, but at 3 p.m. the matching bank credit is unavailable. The business has C$3,100 at the deadline (C$4,200 − C$1,100). It needs C$3,900 more to make the payment, or C$4,900 more to make it and keep the C$1,000 minimum. If the bill is still unpaid and nothing else moves before 4 p.m., the available balance rises to C$8,700 once the credit is usable. That updates the next decision. The recorded 3 p.m. shortfall still stands.
The transfer fails
There is no usable matching credit at 3 p.m. and a later Stripe record shows the failure. The 3 p.m. calculation is the same as in the late scenario. The 4 p.m. calculation now depends on new evidence. If a replacement enters the expected column, keep it there until the bank confirms it is usable.
Copy this worksheet for one payment
Use one row per payment commitment and attach the payout and bank evidence you consulted. Use a single currency and one clock. Copy these five lines into your working file.
Bill and cutoff. Paying entity ___ / operating account ___ / currency ___ / supplier and bill reference ___ / amount ___ / send-by time, date and time zone ___ / cash floor after paying ___.
Batch reconciliation. Card sales period and gross ___ / Stripe payout ID ___ / included charges ___ / captured sales outside this batch ___ / refunds, disputes, fees and other adjustments ___ / calculated and reported net ___ / report as-of time ___.
Transfer and bank credit. Stripe balance availability time ___ / status and checked time ___ / estimated arrival ___ / bank reference and matched amount ___ / destination ___ / posting time ___ / bank-confirmed availability or unresolved item ___.
Cash at the cutoff. Opening available bank balance and timestamp ___ / verified credits since that snapshot ___ / other confirmed outflows since that snapshot ___ / available before the bill ___ / amount short to pay ___ / amount short to pay and keep the floor ___.
Follow-through. Decision and time ___ / open discrepancy ___ / person checking the next update ___ / next check time ___.
For the cash line, add verified available credits since your opening snapshot and subtract other outflows through the cutoff. If your bank snapshot already includes the payout, count it there once. Subtract the available cash from the bill to find the payment gap. Add the chosen cash floor to the bill first to find the gap while preserving that floor. Enter zero in either gap field when the corresponding amount is covered.
If the worksheet shows a gap before the deadline, flag the amount and cutoff for the person responsible for the supplier payment. Give the next check an owner and a time. If the bank confirms the credit later, add a new line with the later timestamp and keep the original cutoff calculation.
Related reading
If you’re comparing a different incoming receipt with a bill, our guide to reconciling financing proceeds to available cash shows how to track deductions and restricted proceeds. If the supplier payment is part of a custom job, our guide to deposits and the cash gap on a custom order shows how to compare payment terms across the whole order.
This guide is for general information and education. The fictional example illustrates how to check one payment and does not establish when your funds will be available.
Subscribe to Deal Flow Canada for practical owner guides and Canadian deal updates.


