Match transfers to bank statement

[NeilStevens]

When I export transfers as CSV, I get multiple lines per deposit in my bank statement.

They need to be aggregated by depositid before they match the entries on the receiving bank account.

Is there way of getting consolidated figures? 

[tranguyen]

Hi @NeilStevens, welcome to the Seller Community!

Rather than download your transfer as CSV, you can see a breakdown for each transfer from Balance > View all transfers on your Square Dashboard. Each reports will include your gross sales (what you collected), total fees charged, and what was actually transferred on the the day. This should make it easier to match transfers to bank statements.

If needed, you can also opt to print the transfer report from your browser rather than exporting them. 

• Here's how to print from Chrome
• Here's how to print from Firefox
• Here's how to print from Safari

I hope this will help!

[NeilStevens]

Thanks for your help, but  I wanted a CSV for import into Xero. I have done the transactions CSV (once for sales and again for fees).

The Square to Xero integration failed when I tried it last year.

[tranguyen]

Thanks for the additional information @NeilStevens! I had a further look on my end and we don't have a CSV report for just the consolidated figures at the moment. When you export your transfer report, it'll always break it down by transaction and the fee per transaction.

I will definitely share this as a feature request for our team to look into developing. 

[NeilStevens · Accepted solution]

I loaded the CSV into Google sheets, added a second sheet, and entered a query formula into the first cell as follows 

=query (transfers,!A2:Z620, "select I, max (A), sum(H) *-1 group by I")

This sums the amount by each unique value of deposit Id and makes the amount negative. 

Then do file, download, comma-separated values.

The resultant file will load into Xero. I chose to map the deposit Id to reference.

I hope this helps someone 😉