How to reconcile Square transfers to bank deposits

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.

Export files with enough overlap

From the Square Dashboard, go to Banking, choose the location, then View all transfers, then Export CSV. 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. Transfers are not sent on Saturdays. 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.

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. 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. Use the bank description, which often includes SQ or Square plus the last three digits of the destination account, when either source exposes a useful reference.
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. Same-day transfers at or above $10,000 can be split across more than one bank posting. 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. 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.

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

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.