- Subscribe to RSS Feed
- Mark Thread as New
- Mark Thread as Read
- Float this Thread for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
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

- Subscribe to RSS Feed
- Mark Thread as New
- Mark Thread as Read
- Float this Thread for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
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."

- Subscribe to RSS Feed
- Mark Thread as New
- Mark Thread as Read
- Float this Thread for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
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."