x

How do I create a monthly report that shows the total of processing fees collected?

Please help!

Tags (1)
21,879 Views
Message 1 of 21
Report
1 Best Answer
Super Seller

Best Answer

If you go to the Sales Summary part of your Dashboard, you can pull up an entire month's worth of sales and check the Fees line item toward the bottom. https://squareup.com/dashboard/sales/reports/sales-summary 

You could also pull up the whole year and choose Monthly instead of Summary from the dropdown to get each month's sales and fees pulled out separately.

View Best Answer >

27,468 Views
Message 2 of 21
Report
20 REPLIES 20
Super Seller

Best Answer

If you go to the Sales Summary part of your Dashboard, you can pull up an entire month's worth of sales and check the Fees line item toward the bottom. https://squareup.com/dashboard/sales/reports/sales-summary 

You could also pull up the whole year and choose Monthly instead of Summary from the dropdown to get each month's sales and fees pulled out separately.

27,469 Views
Message 2 of 21
Report

Is there a way to break down the fees by item?

 

Example:

March Summary

Milk, Gross Sales = 10.00, Fees Collected = 0.13

Bread, Gross Sales = 5.00, Fees Collected = 0.45

21,610 Views
Message 3 of 21
Report
Square

@ohiogoldfrg - None of our reports currently offer this granular of reporting on fees. You could consider exporting the .CSV and manipulating the data in a spreadsheet application. Excel, Numbers, or Quickbooks would easily be able to help you find this information.  


Sean
he/him/his
Product Manager | Square, Inc.
21,590 Views
Message 4 of 21
Report

I just want a report by month that shows total fees deducted?

 

20,199 Views
Message 5 of 21
Report

I have a Sales Summary Square report from 2016 that shows the fees collected from each item. Have you removed this level of granularity for some reason?

 

It would be very useful for tax purposes.

14,976 Views
Message 6 of 21
Report
Alumni

Hey @Brian66 - If you export your transactions list from your online Dashboard, there is a Fee column that shows how much was deducted from each transaction, but not each item. Is that what you were looking for?

Puka - She/They
Seller Community UX Designer
14,948 Views
Message 7 of 21
Report

I got the fees per item last month, but I am not seeing what you mean by it being on the transactions list. Is it still there?

14,432 Views
Message 8 of 21
Report
Admin

Hello @thehappylyon, yes you can still view fees for each transaction from the Transactions CSV:

  1. Sign in to your online Square Dashboard > navigate to Transactions
  2. Edit the date range to see transactions in a specific time.
  3. Click Export in the upper right.
  4. Select Transactions CSV.

The Transactions CSV is a list of all your payments in a particular timeframe. When you open the report you'll need to scroll to the right and there's a column called 'Fees'. 

️ Helen
Seller Community Manager

Did you find help in the Seller Community? Mark a Best Answer to help others.
14,337 Views
Message 9 of 21
Report

How do I create an itemized report for a month or the year?

10,753 Views
Message 10 of 21
Report
Square Community Moderator

Hi @jdampeer!

The details are outlined in @VanKalkerFarms post on the first page. 

Ashley C
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
8,175 Views
Message 11 of 21
Report

How do you select a monthly report?

17,635 Views
Message 12 of 21
Report
Super Seller

Screen Shot 2017-10-14 at 2.40.02 PM.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

When you click on the date on the Sales Dashboard a drop down appears allowing you to select a time frame.

14,467 Views
Message 13 of 21
Report

How do I print out monthly earning reports 

9,994 Views
Message 14 of 21
Report
Alumni

Hi @HerculesHLG -  I've merged your post with this thread on a similar topic. Check out the reply from VanKalkerFarms above for more information on how to pull your Sales Summary.

 

Let us know if you have any other questions!

Puka - She/They
Seller Community UX Designer
9,509 Views
Message 15 of 21
Report

  • Hello, how do I create a report of total monthly cc processing fees?
Tags (1)
8,184 Views
Message 16 of 21
Report
Square Community Moderator

Hey @skinspa! Welcome to the Community.

 

I searched your question and found an existing thread within the Community and merged your post here.

 

Check out @VanKalkerFarms post above!

Ashley C
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
8,153 Views
Message 17 of 21
Report

I need to be able to generate a Monthly statement as I would with a bank account.

All the reports I can find all seems to be incomplete.

6,818 Views
Message 18 of 21
Report
Square Community Moderator

Hi @pm74,

 

I moved your post to a thread where this question has been answered already.

Check out the Best Answer above for details. 

 

In the future, don't hesitate to search your question first here or on the Support Center for your quickest answer too!

Ashley C
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
6,813 Views
Message 19 of 21
Report

I agree and this is so basic, very frustrating!!

 

6,538 Views
Message 20 of 21
Report

Yes we should not have to poke around and create custom reports to try to achieve a simple monthly report. Square is like a bank and we should have monthly statement like we do at the bank. 

I'm also very frustrated with square.

6,530 Views
Message 21 of 21
Report