x

Looking for a summary (total count) of transactions (aka payments) by day for sales reporting?

I'm looking for a summary (total count) of transactions (aka payments) by day for reporting. I would have thought it would be included in the Sales Summary report.

 

I'm looking to have the sales summary, by month, to include daily total transaction count.

 

I don't need a complete listing of every transaction. I need a total - by day. The Sales Summary report you would think include such. It has a data field for Payments but that does not export data to .csv file.

 

I understand I could download every transaction for a day, date range. However that's not useful and I shouldn't have to write a pivot table or otherwise aggregate all that data and then import or combine it into the sales summary report to get a daily transaction (aka payment) total number.

 

The information is there. If you hover over a monthly sales report by day it will show you the number of payments. However that number doesn't download with the CSV file. It doesn't indicate the that transaction/payment data in the online report when it displays nor in the .csv file when downloaded.

 

This is the Sales Summary report for July - by day (aka Daily). <<<I'm trying to insert a screen shot to indicate the above
 
If I were to hover over the days in the chart at the top - for which I've circled (in red) one of those days, July 4 - it will show me the number of payments received that day.
 
However, if I were to scroll down and look at the detail there is no row or line item for payments (or transactions ) by day either on this online version or one that is download.
 
Case Number: 73693460
 
923 Views
Message 1 of 3
Report
2 REPLIES 2

If I were to hover over the days in the chart at the top - for which I've circled (in red) one of those days, July 4 - it will show me the number of payments received that day.
 
However, if I were to scroll down and look at the detail there is no row or line item for payments (or transactions ) by day either on this online version or one that is download.

 

Screen Shot 2022-08-17 at 2.32.54 PM.jpg

917 Views
Message 2 of 3
Report
Square Community Moderator

Hello @abird the information on how many payments/transactions happened per day will be found in the Payment Methods Report. This found two reports down from the left side navigation. Once there you will be able to filter by day/month/year and also by type of payment.  

 

I hope this information is helpful!

JJ
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
834 Views
Message 3 of 3
Report