How do I generate the total photo sales by day?

To find the total value of purchases per day to dispense the staff commissions.

Filter the Time Range

Set the date field to the time range you would like a report on

Download the Report File

The file will download as an Excel file (.xls)

Go to the All Transactions Tab

This example is in Google Sheets, but you can also use Excel

Screen Shot 2021-01-22 at 11.59.26 AM

Format the Total Price Column

Format it as currency, so it looks better

Create a Pivot Table

Highlight the whole spreadsheet, go to the Data tab and choose Pivot Table

Click Create

Edit the Pivot Table

To get the Total Purchased Value by Day
  • Add a Row and choose Date
  • Add a Value and choose Total Price

If your Date is in a format that is not recognized you need to change the format.

Change the Date Format

For example, 2021-01-01T00:00:022 you only need the first 10 characters

  • Add a column and name it 'Actual Date'

  • Take the left 10 characters from the first column using this formula =left(A2,10)
    • Change the number 10 based on how many characters you need
  • Copy that formula for all of the rows
  • Adjust the Pivot Table Rows to use the Actual Date column instead of the Date column