How do I create a transaction report showing customer name, address, phone, email, amount paid (all collected at time of sale)? I want to use this info to add to our membership list which is kept in Excel.
The Transactions CSV might be the best report for you to.
Head to your Squareup.com Dashboard > Transactions > Export > Transactions CSV
Most of the information you'd like to include is in this CSV - but check out the Item Detail CSV as well if you need other information that isn't in the Transaction CSV.
Square Community