cash transaction on report

I'd like to pull a transaction report that also lists which transactions are cash and which are credit. Is this possible to pull an item sales report with this info? Thanks!

2,239 Views
Message 1 of 9
Report
8 REPLIES 8

From your PC's Dashboard, click on Transactions and set the selecter to the date range you need.  Then click on Export in the upper right-hand corner, then click on Transactions CSV.  Square will export a file with all the information you need, and you can open the file in a spreadsheet program and sort the data the way you need to.  You'll get a lot of information you probably don't need too, but I can't find another way to get the cash/credit notes that you want.

Judy T Shumway
2,229 Views
Message 2 of 9
Report

Thank you. This is how I have been pulling the data but it does not list cash or credit for each transaction.

2,214 Views
Message 3 of 9
Report

Are you using the Transactions CSV choice on the Export menu? Because neither of the other two will give you the cash/credit figures, but the transactions CSV will. At least that’s how it works on my system.

Judy T Shumway
2,212 Views
Message 4 of 9
Report

Here's a screen shot of part of our recent sales:

 

Credit-Cash Transactions.jpg

 

Judy T Shumway
2,206 Views
Message 5 of 9
Report

Thank you! That is what I am looking for. Which report are you looking under?

2,183 Views
Message 6 of 9
Report

From your PC's Dashboard, click on Transactions Transactions.jpg

 

 

Then set the date range (upper left-hand corner)to what you need it to be.  Then click on Export in the upper right hand corner, and click on Transactions CSV:

Transactions CSV.jpg

 

 

You'll be asked to choose the location to which the file should be saved.  Once it's been downloaded, open it with Excel and you'll see way more information than you need.

 

Good luck.

Judy T Shumway
2,178 Views
Message 7 of 9
Report

Thanks for posting the steps for me! I appreciate the insight! This detail will help tremendously.

2,169 Views
Message 8 of 9
Report

You're welcome.  You'll find lots of people eager to answer any questions you have, here in the user community.

Judy T Shumway
2,164 Views
Message 9 of 9
Report