ReconcileCSVUnlock full export · $39 once

Processor-specific workflow

Square payout to bank: match the transfer, not each sale

A Square payout on the bank is one transfer from the Square balance, not each card payment. Square groups card payments, settled tips, refunds, fees, and adjustments into that transfer. The bank usually records only the resulting deposit or debit. Match the transfer net to the bank line; timing, instant fees, refunds, tips and loans are the detail behind the amount.

Use the transfer as the bridge

Reconciling each Square sale directly to the bank is usually the wrong level of detail. Card payments, settled tips, refunds, fees, and adjustments first change the Square balance. Square then sends available funds to a linked bank as a transfer. Square names this movement a transfer, not a payout. The transfer identifier and transfer net provide the bridge from detailed Square activity to cash.

Your reconciliation therefore has two related checks. First, confirm that the payments and adjustments assigned to a transfer explain its net amount. Second, match that transfer net to the bank deposit or debit. If the export already isolates sent transfer rows with a reliable net, begin with the second check and retain the surrounding activity as support.

Control point: reconcile each location or transfer tag, destination bank account, and transfer mechanism separately.

Export files with enough overlap

From the Square Dashboard, go to Banking, choose the location, then View all transfers, then Export CSV (match deposits to sales, read 2026-10-17). Official Square help does not publish a fixed list of CSV column names. Keep whatever columns you receive that identify the transfer date, currency, net amount, destination, and the payments included in the transfer. From the bank, export statement lines with posting date, description, debit, credit, and currency.

Build a working set of sent transfer rows rather than matching every card payment. Include several business days on both sides of month end. Square can send a transfer in one accounting period and the bank can post it in the next. An overlap prevents ordinary clearing from appearing as missing.

Standard next-business-day transfers follow Square cutoff rules. Payments completed before 5:00 PM PT, which is 8:00 PM ET, are typically sent the next business day. Payments after that cutoff are typically sent by the second business day (deposit options, read 2026-10-17). Next-business-day transfers are not sent on Saturdays, and Square says payments accepted on Friday and Saturday arrive Monday morning (deposit options, missing transfers, read 2026-10-17). Same-day funds are sent 15 minutes after your close of day (5:15 PM PT / 8:15 PM ET with the default close of day) (deposit options, read 2026-10-17). Instant transfers, same-day transfers, and manual transfers change both expected timing and the amount that should reach the bank. Transfer tags are not available for instant or same-day transfers, so those rows need destination and date support instead of a tag (match deposits to sales, read 2026-10-17).

Confirm that the Square transfer destination matches the bank account under review. Businesses with more than one location, more than one transfer tag, or more than one linked bank can compare a valid transfer with the wrong statement. Also note whether the period includes instant or same-day transfers, because those choices change both expected timing and fees.

Normalize dates, signs, and currencies

The transfer export supplies a Square date. The bank supplies a posting date. Choose the date that best represents transfer initiation, retain the other dates as reference, and compare within a documented business-day window. Do not rewrite dates to make records match.

Normalize the sign convention before matching. A positive Square transfer should normally correspond to a bank credit. Refunds and some loan repayments can post as bank debits. Verify both conventions with a known deposit and a known debit. Handle reversals as separate records rather than deleting both sides.

Keep currencies separate. A USD transfer and a CAD deposit are not an amount match, even if the numbers agree. Instant transfers and same-day transfers each cost 1.95 percent per transfer in addition to ordinary card processing fees (deposit options, read 2026-10-17). When the bank receives an amount different from the transfer net, investigate that extra transfer fee before classifying the variance as a card fee or a missing payment.

Match exact transfers first

  1. Filter to sent Square transfers and bank credits or debits in the expected destination account.
  2. Match exact currency and amount within the normal posting window.
  3. Open the transfer in Square Dashboard; its details show the transfer mechanism, the last three digits of the destination bank account, the card payments included, and trace details (match deposits to sales, read 2026-10-17). Use those with the bank posting date and amount; don't rely on the bank description wording alone (match deposits to sales, read 2026-10-17).
  4. Remove confirmed pairs from the open list.
  5. Review repeated daily totals carefully so date proximity does not create a false match.

Square card processing fees are normally reflected in the Square balance before the transfer amount is created. In that common setup, the transfer net should equal the bank deposit without subtracting the same card fees again. Instant and same-day transfers add the extra 1.95 percent fee. If the bank receives an amount different from the transfer net, investigate that transfer fee, a refund debit, a loan withholding, a split posting, or an incorrect source column before classifying the variance.

Explain common Square differences

Transfer still in transit

A sent status means Square has processed the transfer and sent it out of the Square balance. It does not mean the bank has posted the funds. Record the transfer identifier or tag when present, net amount, initiation date, transfer mechanism (standard, instant, same-day, or manual), and destination. Carry it forward and confirm the bank posting in the next period. If the transfer later fails or returns, update the classification rather than leaving it as in transit.

Refunds, tips, and Square loans

Refunds reduce the Square balance before the next transfer, so they change composition rather than creating a separate bank credit. Square does not return the original processing fee on a refund, and a refund can produce a bank debit when it exceeds available balance. Settled tips belong in the transfer composition when they were included in the settled sales that funded the transfer. Square loan repayments are often withheld as a fixed percentage of daily card sales and can appear as a smaller transfer or as a bank debit. Use the transfer detail and any loan withholding evidence to support these movements. Do not assume every amount difference is a processing fee.

Multiple transfers or combined bank lines

Instant, same-day, and manual transfers can produce several bank credits on one day. Instant and same-day transfers have a $10,000 maximum per transfer and a minimum of $25 (instant) or $1 (same-day) after Square's fees (missing transfers, deposit options, read 2026-10-17). Amounts outside those limits are not available for instant or same-day transfer, and any balance not transferred instantly goes on the normal schedule (missing transfers, deposit options, read 2026-10-17). Conversely, some bank feeds combine or summarize postings. Preserve the individual Square transfer rows, list every bank component, and document any one-to-many relationship. The sum should agree by currency, and the grouping should be supported by dates and references rather than amount alone.

Failed, canceled, or returned transfers

A failed or returned transfer should not be matched to an unrelated bank deposit. Square states that a bounced transfer can return to the Square balance in up to seven business days (missing transfers, read 2026-10-17). Trace the original transfer, the bounce-back, and the replacement transfer. If the bank posted and returned the funds, retain both bank lines. This preserves the cash trail and avoids hiding a failed settlement inside a later successful batch.

Limit: a CSV workflow cannot confirm facts missing from the exports. When status, destination, or transfer composition is unclear, return to Square Banking and the bank for source evidence.

Prepare review-ready support

A completed file should show the Square transfer identifier or tag when present, settlement currency, transfer net, relevant Square date, bank posting date, bank description, match status, and exception explanation. Attach or retain the original transfer CSV and bank files. For open items, include an owner and next action. Reviewers should be able to distinguish ordinary bank clearing from an instant-fee difference, a refund debit, a loan withholding, or an item that requires Square or bank follow-up.

Compare the total of matched and open Square transfers with the filtered source report, then compare matched and unexplained bank deposits and debits with the statement. These completeness checks catch records omitted by filters or import ranges. The goal is a supported zero difference after timing and other documented items, not a spreadsheet made to balance through plugs.

Using ReconcileCSV for the comparison

To see the match on sample files before using your own export, open the Stripe worked example (two sample CSVs; the same date-and-amount mapping applies to a PayPal, Square or Shopify export).

ReconcileCSV accepts a Square transfer CSV and a bank statement CSV as generic date and amount files, lets you map those columns, proposes deterministic matches inside a date window, and surfaces ambiguous or unmatched rows. Square is not a named source type in the live picker. The preview is free. Full ledger, print, and exception exports are available after a one-time $39 purchase. There is no account and no OAuth. CSV processing and matching run in the browser; files never leave the browser.

ReconcileCSV does not connect to Square, retrieve live transfer status, save Square mapping profiles, post entries to accounting software, or determine the proper account for card fees, instant or same-day transfer fees, refunds, tips, or Square loans. It cannot repair incomplete exports. A preparer must review ambiguous matches and support every accounting conclusion with the original source data.

FAQ

Why reconcile Square transfers to the bank instead of each Square sale?

Card payments, settled tips, refunds, fees, and adjustments first change the Square balance. Square then sends available funds to a linked bank as a transfer, and the bank usually records only the resulting deposit or debit. Match the transfer net to the bank and keep the payments as support for what made up the net.

When should a standard Square transfer reach the bank?

Payments completed before 5:00 PM PT, which is 8:00 PM ET, are typically sent the next business day. Payments after that cutoff are typically sent by the second business day. Square says payments accepted on Friday and Saturday arrive Monday morning. Same-day funds are sent 15 minutes after your close of day (5:15 PM PT / 8:15 PM ET with the default close of day).

Square shows the transfer as sent. Why isn't it on my bank statement?

A sent status means Square has processed the transfer and sent it out of the Square balance. It does not mean the bank has posted the funds. Record the transfer identifier or tag when present, net amount, initiation date, transfer mechanism, and destination. Carry it forward as in transit and confirm the bank posting in the next period.

Should the bank deposit equal the Square transfer net?

In the common setup, yes. Square card processing fees are normally reflected in the Square balance before the transfer amount is created, so don't subtract the same card fees again. If the bank amount differs, investigate an instant or same-day transfer fee, a refund debit, a loan withholding, a split posting, or an incorrect source column before classifying the variance.

What do instant and same-day transfers change?

Instant transfers and same-day transfers each cost 1.95 percent per transfer in addition to ordinary card processing fees, so the bank amount can differ from what you expect. They have a $10,000 maximum per transfer and a minimum of $25 (instant) or $1 (same-day) after Square's fees. Transfer tags are not available for instant or same-day transfers, so those rows need destination and date support instead of a tag.

How do refunds, tips, and Square loans affect a transfer?

Refunds reduce the Square balance before the next transfer, so they change composition rather than creating a separate bank credit. Square does not return the original processing fee on a refund, and a refund can produce a bank debit when it exceeds available balance. Settled tips belong in the transfer composition when they were included in the settled sales that funded the transfer. Square loan repayments are often withheld as a fixed percentage of daily card sales and can appear as a smaller transfer or as a bank debit.

How do I confirm a transfer went to the bank account I'm reconciling?

Reconcile each location or transfer tag, destination bank account, and transfer mechanism separately. Open the transfer in Square Dashboard; its details show the transfer mechanism, the last three digits of the destination bank account, the card payments included, and trace details. Use those with the bank posting date and amount, and don't rely on the bank description wording alone.

What happens if a Square transfer bounces?

Square states that a bounced transfer can return to the Square balance in up to seven business days. Don't match a failed or returned transfer to an unrelated bank deposit. Trace the original transfer, the bounce-back, and the replacement transfer, and keep both bank lines if the bank posted and returned the funds.

Sources (read 2026-10-17)