How do i print a yearly report for an individual customer

How do I print a report for an individual customer showing their year end totals they paid.  I have customers asking for yearly statements and I don't know how to find that

73 Views
Message 1 of 2
Report
1 Best Answer
Square Community Moderator

Best Answer

Hi @Aloenterprises ! 


While we do not have a specific report for this, I am going to provide below a workaround that a fellow Seller has provided here in the Community. You can also find the link to the original thread here. 

 

"Export your years Transactions Details.csv file.

Then Open in Excel.

Click on a cell.

Then click Insert - Pivot Table to a new sheet.

On the Right side select Date

Customer Name

Item

Quantity

Gross Sale

 

Put the Customer Name as a Filter

Date and Item should auto pupulate in Rows

Quantity or QTY put as a Column 

Gross sales as a Value

 

Then in the Left side there will be a Filter type Icon near the top and select the customer.

 

Now you sales for that time frame must collect the customers name at the time of sale, some auto generate based on cards and alot do not.  So at the Time of the sale you or your employee would have needed their name. 

 

You should end up with a Pivot table that you can print as a pdf.  You can also tap the - signe to minimize the chart by date etc."

 

@Candlestore 

View Best Answer >

64 Views
Message 2 of 2
Report
1 REPLY 1
Square Community Moderator

Best Answer

Hi @Aloenterprises ! 


While we do not have a specific report for this, I am going to provide below a workaround that a fellow Seller has provided here in the Community. You can also find the link to the original thread here. 

 

"Export your years Transactions Details.csv file.

Then Open in Excel.

Click on a cell.

Then click Insert - Pivot Table to a new sheet.

On the Right side select Date

Customer Name

Item

Quantity

Gross Sale

 

Put the Customer Name as a Filter

Date and Item should auto pupulate in Rows

Quantity or QTY put as a Column 

Gross sales as a Value

 

Then in the Left side there will be a Filter type Icon near the top and select the customer.

 

Now you sales for that time frame must collect the customers name at the time of sale, some auto generate based on cards and alot do not.  So at the Time of the sale you or your employee would have needed their name. 

 

You should end up with a Pivot table that you can print as a pdf.  You can also tap the - signe to minimize the chart by date etc."

 

@Candlestore 

65 Views
Message 2 of 2
Report