Square Card Fees

How do I get Square fees shown in my bank feed. All I receive is the amount deposited for the day.

93 Views
Message 1 of 3
Report
2 REPLIES 2

@Yosheen 

 

Square takes its fees before sending the deposit, so your bank feed only shows what’s left. I’d start in Square Dashboard > Reports > Accounting > Fees. Choose your dates to see the fee totals.

https://squareup.com/help/au/en/article/8360-view-tax-fee-and-service-charge-reports 

 

To check a particular deposit, go to Money > Balance > View all transfers and open the matching transfer. You can see the included card payments and export the details. That helps you check which payments and fees belong to that deposit, since a day’s sales can cross transfer dates.

https://squareup.com/help/au/en/article/3813-match-deposits-to-sales

 

Longer term, I’d look at connecting Square directly to your accounting software. Since it looks like you’re in Australia, Xero and MYOB both have connections through Amaka that record Square fees and help match deposits. QuickBooks Online also has Square connections.

 

https://amaka.com/integrations/square/xero/ 

https://amaka.com/integrations/square/myob/ 

 

Get your Square services into a spreadsheet. Get on with the work you need to do.
Use Service Catalog Manager to get your services into Excel or CSV. Keep a copy, review prices, or make updates in bulk. Check your work, then save it back to Square. No need to create a new account; use your existing Square account

For free.

See how it works, from your first export to saving your changes back to Square.
See how to bulk edit your Square services
88 Views
Message 2 of 3
Report

To build on the fee report above: the bank feed will never show the fees, because Square deducts them before the transfer. The usual fix is to stop matching the deposit straight to sales and run it through a clearing account instead.

For each transfer (Money > Balance > View all transfers):

  • Record the gross card sales in that transfer as income, into an account called something like "Square clearing"
  • Record the Square fees for the same payments as an expense (merchant or bank fees), out of that clearing account
  • Match the bank-feed deposit as a transfer from Square clearing to the bank. It will then agree to the cent

At month end the clearing account should be zero. If it isn't, something is missing, usually a refund, a chargeback, or a payment that settled into the next day's transfer.

If your accounting software has a Square connection, check whether it posts gross sales plus fees like this or only the net deposit. Net-only posting understates both income and expenses, and for your BAS it's gross sales that count, not what lands in the bank.

14 Views
Message 3 of 3
Report