Can I create a spreadsheet from my square terminal to show which customers bought what items?

I need to record what club members paid for what items on spreadsheets. Can I create a spreadsheet from my square terminal to show which customers bought what items? And can I send that information to me by email? We're a small club and members pay dues, or pay for an event, and I need to keep track of what members paid for items.

Or can I send that information to square online so I can download it from my pc?

677 Views
Message 1 of 3
Report
1 Best Answer
Square Champion

Best Answer

Hi @treasurer58.  There is no standard functionality in Square Terminal (or any Square POS) to do this. However, you can go to your online dashboard > Reports > Item Sales.  Select the date range you are interested in and any other filtering you might want.  Then you can export the CSV that includes customer names by clicking on 

 

IMG_4930.jpeg

(Which mean export) and selecting Detail CSV.  You can then open this CSV in a spreadsheet like Excel and build whatever reports you need for your purposes.

Chip
Piper’s Ice Cream Bar, Covington KY USA
Square Champion, Expert & Innovator
Website Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!
If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps other sellers who find this thread in the future.

View Best Answer >

644 Views
Message 2 of 3
Report
2 REPLIES 2
Square Champion

Best Answer

Hi @treasurer58.  There is no standard functionality in Square Terminal (or any Square POS) to do this. However, you can go to your online dashboard > Reports > Item Sales.  Select the date range you are interested in and any other filtering you might want.  Then you can export the CSV that includes customer names by clicking on 

 

IMG_4930.jpeg

(Which mean export) and selecting Detail CSV.  You can then open this CSV in a spreadsheet like Excel and build whatever reports you need for your purposes.

Chip
Piper’s Ice Cream Bar, Covington KY USA
Square Champion, Expert & Innovator
Website Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!
If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps other sellers who find this thread in the future.
645 Views
Message 2 of 3
Report

Thanks. I stumbled on it this morning. I was too impatient, transactions don't show up online day of sale. And it took me a while to figure out how to find your answer

640 Views
Message 3 of 3
Report
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.