PreciseBankFlowPreciseBankFlow home

Payment and deposit reconciliations

Most bank deposits are not single payments. They are processor payouts, card batches, lockbox files or ACH batches with fees, refunds and chargebacks netted out. This category covers reconciling those payments to the bank and the ledger: Stripe, PayPal, Square, Shopify and marketplace payouts, merchant deposits, cash drawers and daily sales, undeposited funds and matching deposits to invoices. Start with Payment Reconciliation: Processor, Ledger and Bank, then move to the processor you use.

  1. Three Way Match Accounts Payable Teams Can Rely On

    Three way match for accounts payable: purchase order, receipt and invoice, tolerances, exceptions, and how it ties to the payment that leaves the bank.

    Published October 7, 2026accounts payablepurchase orderspayment controls

  2. ACH Batch Deposit Reconciliation to Customer Payments

    ACH batch deposit reconciliation: split one bank credit into the customer payments inside it using the addenda or report, and resolve unknowns.

    Published September 25, 2026ACHbatch depositsreceivables

  3. Recurring Billing Reconciliation for Subscriptions

    Recurring billing reconciliation for subscriptions: billing system to processor to bank, failed payments, retries, refunds and the revenue ledger.

    Published September 4, 2026subscriptionsrecurring revenuepayment processors

  4. Ecommerce Reconciliation Across Platforms and Banks

    Ecommerce reconciliation across platforms: orders, payouts, fees, returns and taxes, a monthly routine and how to tie several channels to one bank.

    Published August 10, 2026ecommercemarketplacesmonthly close

  5. Amazon Settlement Reconciliation for Sellers

    Amazon settlement reconciliation for sellers: reading the settlement report, fees, reserves and reimbursements, and tying each disbursement to the bank.

    Published July 26, 2026amazonmarketplace sellerssettlements

  6. How to Reconcile Chargebacks and Reversals

    How to reconcile chargebacks: the debit, the dispute fee, a won reversal, and keeping receivables and revenue correct while the dispute is open.

    Published May 3, 2026chargebacksdisputescard payments

  7. How to Clear Undeposited Funds That Never Hit the Bank

    How to clear undeposited funds: group payments into the real bank deposits, find payments recorded twice and fix balances that built up for years.

    Published May 1, 2026undeposited fundsquickbookscleanup

  8. Food Delivery App Payout Reconciliation for Restaurants

    Food delivery app payout reconciliation for restaurants: order reports, commissions, promotions, adjustments and tying weekly payouts to the bank.

    Published April 20, 2026restaurantsdelivery appspayouts

  9. Customer Overpayment Reconciliation and Refunds

    Customer overpayment reconciliation: spot it in the deposit, hold it as a credit, refund or apply it, and keep unclaimed credits from growing old.

    Published April 13, 2026overpaymentscustomer creditsrefunds

  10. Lockbox Reconciliation: Bank File to Receivables

    Lockbox reconciliation: match the bank's lockbox file to the deposit and to receivables, handle unidentified payments and short-paid invoices.

    Published April 7, 2026lockboxaccounts receivablecash application

  11. How to Reconcile Multi Currency Payments

    How to reconcile multi currency payments: invoice rate versus settlement rate, conversion fees, realized gains and losses and tying to the bank.

    Published March 10, 2026foreign exchangerealized gainsconversion fees

  12. Gift Card Liability Reconciliation to Sales and Bank

    Gift card liability reconciliation: tie cards sold and redeemed to the liability account, card program reports and the bank, plus breakage and expiry.

    Published March 5, 2026gift cardsliabilitiesretail

  13. How to Reconcile Square Deposits to Sales

    How to reconcile Square deposits: match daily transfers to sales reports, separate fees, refunds and instant transfer charges, and find missing days.

    Published December 3, 2025squarecard depositssales tie-out

  14. How to Record Merchant Processing Fees Correctly

    How to record merchant processing fees: gross versus net deposits, daily or monthly fee debits, the monthly statement and why net recording hides revenue.

    Published August 10, 2025merchant feesjournal entriescard processing

  15. How to Reconcile Zelle Payments in a Business Account

    How to reconcile Zelle payments in a business account: vague descriptions, matching to customers and vendors, and keeping personal transfers out.

    Published August 7, 2025zellebank transferssmall business

  16. How to Reconcile Merchant Deposits From Card Sales

    How to reconcile merchant deposits from card sales: batch reports to deposits, card brands paid separately, settlement delays and month-end timing.

    Published July 12, 2025card processingmerchant depositssettlement

  17. Daily Sales Reconciliation From POS to Bank

    Daily sales reconciliation from the POS report to the bank: cash, cards, gift cards and delivery apps, with a template and how to chase a short day.

    Published June 26, 2025point of salecash drawercard batches

  18. How to Reconcile Payroll Bank Account Activity

    How to reconcile a payroll bank account: funding transfers, net pay debits, tax debits, uncashed paychecks and why the balance should end near zero.

    Published May 26, 2025payrollimprest accountoutstanding checks

  19. Payment Processor Reserve Accounting and Release

    Payment processor reserve accounting: record the held amount as an asset, track releases against the bank, and reconcile the reserve each month.

    Published April 29, 2025processor reservesheld fundsrollforward

  20. ACH Return Reconciliation and Return Codes

    ACH return reconciliation: reading return codes, reversing the receipt or payment, re-presenting and tracking returns that land after month-end.

    Published March 23, 2025ach returnsreturn codesreceivables

  21. Remittance Advice Reconciliation to Payments

    Remittance advice reconciliation: read the remittance, apply the payment to the right invoices, record deductions and follow up on missing advice.

    Published February 28, 2025remittance advicecash applicationdeductions

  22. How to Reconcile Shopify Payouts to Orders

    How to reconcile Shopify payouts: payout reports to orders, fees, refunds and chargebacks, other gateways, and tying each payout to the bank deposit.

    Published January 28, 2025shopifyecommercepayouts

  23. How to Reconcile Customer Refunds to the Bank

    How to reconcile customer refunds: card refunds netted from payouts, check and ACH refunds, approval evidence and refunds that never reached a customer.

    Published January 27, 2025refundspayoutsrefund fraud

  24. How to Match Bank Deposits to Invoices

    How to match bank deposits to invoices when one deposit pays several invoices, short-pays one or arrives with no remittance, step by step.

    Published January 26, 2025receivablescash applicationdeposits

  25. How to Reconcile PayPal Transactions Each Month

    How to reconcile PayPal transactions: treat PayPal as a bank account, use the activity report, record fees and holds, and tie transfers to the bank.

    Published January 26, 2025PayPalpayment processorsclearing accounts

  26. Partial Payment Reconciliation for Open Invoices

    Partial payment reconciliation: apply the amount received, keep the invoice open, track short-pays and agree the balance with the customer.

    Published January 8, 2025receivablesinvoicesshort pays

  27. Payment Reconciliation: Processor, Ledger and Bank

    What payment reconciliation involves: processor reports, the ledger and the bank deposit, the fees and timing in between, and a three-way tie-out.

    Published November 15, 2024payment processorsthree-way tie-outdeposits

  28. Stripe Payout Reconciliation to the Bank and Ledger

    Stripe payout reconciliation: break each payout into charges, refunds, fees and disputes, tie it to the bank deposit and book the net correctly.

    Published November 9, 2024stripepayoutsprocessor fees

  29. Reconcile Cash Receipts to Bank Deposits Daily

    How to reconcile cash receipts to bank deposits: receipt logs against deposit slips, combined deposits, delays and the gaps that point to skimming.

    Published October 20, 2024cash receiptsdeposit slipsdaily tie-out