How do I print a monthly report that shows itemized merchant fees

[lshanard]

How do I print a monthly report that shows each transaction, along with the merchant fee deducted for each transaction? This is being requested by our Accountant and all I can find is a report that gives one lump sum that the merchant is deducting for the whole month. 

[Joe · Accepted solution]

Hi there, @Ishanard 👋 Thanks for reaching out to us here on the Seller Commuunity! And congrats on making your first post! We are happy to have you.

A detailed transaction report with each transactions processing fee can be found by doing the following:

• Log into your Online Dashboard
• Select Transactions from the left-hand navigation bar
• Edit the date for a more refined search
• Select Export from the upper right hand bar
• Select Transactions CSV
  • This exported CSV will give you a list of each transaction with its own breakdown of fees

I hope this gets you where you need to be! Feel free to shoot me a response if you have any remaining clarifying questions. We are here to help!

[lshanard]

Thank you, Joe! 🙂

[Joe]

No problem, @lshanard! Let us know if anything else comes up! 🍻📈🙌

[willlong]

My CVS report ha no fees breakouts.

[SonjaGregory]

Neither does mine.  Only shows amount my client paid.  I want square fees charged. How to get that?

[virginiap]

yes but how do i get a yearly summary of all my own expenses off my Square debit card?

[blackswanks]

I would like to retrieve a report with a transaction list for an entire year. Is that possible?

[SonjaGregory]

Yes, I can print a monthly report, but I'm looking for the amount square charged me as fees.  This does not show that info

[AshleyK]

@SonjaGregory You can view the fees charges by either exporting the transaction detail CSV under Transactions on your Square Dashboard, or visiting Reports on the Dashboard and viewing the fees for that time frame. 

Here is what it looks like to export your transaction CSV:

In that CSV, scroll over to the left until you see fees. You will need to ask the sheet to add the total of all fees, because this will break down the fees for each transaction. My screenshot shows $0 because the first two transactions on my list were cash.

The best way to do this is to visit Reports on the Square Dashboard. You can filter your timeframe by month (by clicking on the date in the top left of the screen), and then scrolling down until you see fees. In my screenshot below, you will see the fees taken out of my $1 credit card sale.

[SonjaGregory]

Thank you!

[Jeanette2]

I still cannot get fees for each transaction on the transaction CSV, or anywhere else I have tried.  I do not want total fees.

[Kassi_]

Welcome to the Community, @Jeanette2 - 

Could you give me some more insight on the paths you've already taken to get the fee breakdown?

I don't want to have you repeat any steps you've already tried that were unsuccessful. 

I will keep an eye out for your reply👀. 

[homeprogreen]

I’ve never found a way in the Square reports to get a breakdown of transaction fees by transaction instead of total. Couple of ways to do it though. 1st is by looking at each transaction separately in Square. It will show you the fee for each transaction. I am including a screenshot that shows it. 2nd way is to use the new Square sync with QuickBooks. The new sync gives you the option to import each days sales in Square into QuickBooks either has a batch or as separate transactions. If you choose separate transactions then it will automatically create invoice, track fees and taxes on each invoice and you can print out that report from QuickBooks 

[Candlestore]

@Jeanette2 ;

If from a computer you go to : dashboard/sales/transactions 

Select the Date or Dates or Time Frame then,

Select Export on the right side of the screen

From the drop down select Transactions CSV

You should be able to get a csv file that shows the information you are looking for.

The Grey column "U"  with RED numbers are Squares Fees, The highlighted Blue Column "W" is the different Transactions and the Payment ID "X" is Different types of payments which could be different from a Transaction ID if you do Split Tenders.  The coloring of the columns I did to help explain this.  The Net Total column is what Square sends to my bank the following day for each Transaction.