Does Square have a report for time of day of sales for a specified day of the week over time?

[TPT_Amanda]

I'm trying to determine hours I should be open on Monday's in 2017 based on time of day of sales on Monday's in 2016. Is there a way I can drill the report down to only show me aggregate info on Monday's in 2016? Currently I get time of day of sales averaged for the entire week, for the entire year. I'd like it to be just a little more specific if possible.

[floyd1]

Ditto to all of the above, this is both basic and critical. It sort of exists in our montly report emails (average sales on our best day of the week), why can't we generate it ourselves? We need to know what sales are like on Wednesdays vs. Mondays in a given period, for example. 

[ButcherFarmer]

Any progress on this feature?  One of the features Square advertises is it's portability, which is great for use at different locations on different days.  When will we be able to see the data generated on a specific day of the week? We do business at farmers markets and would like to be able to see a breakdown of sales for that market venue over the duration of a growing season.  

[Joe]

Hi there, @ButcherFarmer - thanks so much for adding your voice here to this thread. We appreciate you being a part of the Seller Community!

While we don't have any shareable update in regards to this feature just yet, we will be sure to actively update everyone here when there is more info to share. We appreciate your patience! 

[CafeRed98118]

@Joe this feature is so critical. You literally have posts going back over two years saying we need this. And this isn't even the only thread asking about this feature. No one is joking when they say we need this.

Since you upped our rates, our business is now paying you THOUSANDS of dollars per year in extra merchant fees while receiving NO added benefit whatsoever.

Please make this feature a priority and show us you're worth the money.

[crema_c_s]

Same thing here, and would love to see the chart in this way to help with scheduling. We have variability in our business based on day of the week for sure. It is noticeable just by paying attention to the daily sales reports, but I would really like to see it more granularly as the average sales in each hour on each day of the week.

[AshleyK]

@crema_c_s thank you for sharing your feedback regarding the reporting. I think this is a great feature request because while we do report sales by the hour and show a graph in Sales Summary for peak sales hours, I can see how it would be useful to break those numbers down even further in some of our reporting. 

As a workaround, you can always visit Transactions in the Square Dashboard and filter by the hour there, viewing which hours had higher sales. From there, you can export your transactions CSV and view each sale that happened by the minute and create your own reports in the CSV file based on those peak hours.

Thanks for your time and I hope this helps! 

[amberdarland]

I'm trying to pull a report by day of the week, for the entire year.  I want to know how Mondays look hour by hour for sales for all of 2019, or 2020 to date, etc.  Tuesday hour by hour, etc.  I'm only finding a way to see hour by hour as a total for the week, or for a specific day.  That ends up blending Friday and Saturday nights in to the hourly sales and skews the numbers hard.  Thanks.

[ashc]

Hey @amberdarland,

I moved your post to an existing thread in the Community where another seller had the same question.

@sciabica1936 answered this one above. 

[amberdarland]

While I appreciate moving the post to an existing thread, I would rather find the solution!  Looks like people have been asking for this for years with no movement by Square.  The data is already there, just let us pull it.  Not sure why they haven't solved the issue yet????

[crema_c_s]

I know that Shopkeep has this ability built in. I think VendPOS does too. The other weird thing is that I get emails from Square telling me my averages on certain days of the week during each month. That's using the exact data we're looking to be able to pull ourselves. You already have it built in to your automated emails!!!