How can get a report of item sales per sale per day

I can get a report of item sales per day total.  I need the total sale broken down to individual sale within the total.

4,936 Views
Message 1 of 9
Report
2 Best Answers
Square Champion
Solution

Hi there @SWmanager.. Assuming that I am understand your question above, the easiest way I know of is to go to your web dashboard > Reports > Sales > Sales Summary.  Choose your date range to see the summary report.

 

Under Gross sales/Items you'll see "xx transactions."  That is a hot link you can click on to display a report of each transaction.  You can even drill down further into transactions to see transaction details.

 

And, if I misunderstood your question, please clarify for me and I'll try again.

 

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!

View Solution >

4,933 Views
Message 2 of 9
Report
Square Champion
Solution

@SWmanager If you are looking for a list of ITEMS sold, however, go to your web dashboard > Reports > Sales > Item Sales

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!

View Solution >

4,931 Views
Message 3 of 9
Report
8 REPLIES 8
Square Champion
Solution

Hi there @SWmanager.. Assuming that I am understand your question above, the easiest way I know of is to go to your web dashboard > Reports > Sales > Sales Summary.  Choose your date range to see the summary report.

 

Under Gross sales/Items you'll see "xx transactions."  That is a hot link you can click on to display a report of each transaction.  You can even drill down further into transactions to see transaction details.

 

And, if I misunderstood your question, please clarify for me and I'll try again.

 

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
4,933 Views
Message 2 of 9
Report
Square Champion
Solution

@SWmanager If you are looking for a list of ITEMS sold, however, go to your web dashboard > Reports > Sales > Item Sales

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
4,931 Views
Message 3 of 9
Report

Thank you, I will give it a try.   To clarify: we are a non profit and when one of our clients donates I simply put the donation in as an item of the sale.   Now I need to go back and open the sale of the day and extract the donation amount of that client to tabulate how much they donated throughout the year.

4,929 Views
Message 4 of 9
Report
Square Champion

@SWmanager Ah.  Honestly, Square makes it difficult to determine amounts spent by customer over a period.  If you are recording/attaching customer information to transactions, your best bet here would be to download a transaction CSV for the period in question.  Then import that to a spreadsheet and make a pivot table to summarize donations by customer.  Just a thought.  Otherwise, what you are trying to do is a highly manual process at the moment.  Even Square AI recognizes the limitations of the data sets.

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
4,927 Views
Message 5 of 9
Report

Thank you, I am finding it to be spreadsheet headache but I am getting there.

4,918 Views
Message 6 of 9
Report

It used to be simple to pull a report that was by item, by customer.  export to excel.  I have an event tomorrow and can no longer pull a report that lists everyone that pre-purchased a ticket.  I cannot believe they screwed the reporting up so badly.

2,741 Views
Message 7 of 9
Report
Alumni

Thanks for jumping in here @TheRealChipA ! @SWmanager Please let us know if you have any other questions. 

4,809 Views
Message 8 of 9
Report

If you install the Spark app from the Square App Market, you would just ask it to "Provide a CSV report of item sales per day total.  Break out each order by individual item." (or words to that effect if I didn't capture it correctly).

https://squareup.com/us/en/app-marketplace/app/spark-business-intelligence

579 Views
Message 9 of 9
Report