How to include average return rate in Payment Cost

In order to account for returns, we offer a manual workaround that can be used to include the return rate in the Profit Calculation

Part 1: Make a copy of the Google Sheets template

1. Go to https://docs.google.com/spreadsheets/d/1kClaJp5oDyQeB73xcKCud8Xi2APNMJx81hReESAOzcA/edit?usp=sharing
2. Click "File"
   
3. Click "Make a copy"
   
4. Change the name of the file
   
5. Click "Make a copy"
   

Part 2: Gather revenue and profit data

1. Log in to https://my.profitmetrics.io and make sure you are on the Dashboard page
2. Click the date selector
   
3. Select the longest time frame you have accurate profit data for in ProfitMetrics (eg click "Last 30 days" if you only have one month of data)
   
4. Click "Apply"
   
5. Make a note of the Revenue and Gross Profit values

Part 3: Fill out template

1. Go back to your copy of the Returns template
2. Add your local VAT rate
   
   
3. Add your Revenue from the ProfitMetrics dashboard
   
4. Add your Profit from the ProfitMetrics dashboard
   
5. Add your Return rate as a percentage of total revenue (this needs to be calculated based on your existing return rate and total Revenue, value is not available in ProfitMetrics)
   
6. Add your current Fallback Payment cost (ProfitMetrics > Expenses > Fallback Costs)
   
   
   
7. Add each payment method currently listed in ProfitMetrics > Expenses > Payment Costs
   
   

   This step requires that you have added accurate Payment method costs in ProfitMetrics > Expenses > Payment Methods already!

8. For each payment method used, add the current Payment Fee
   
9. The 'Add in ProfitMetrics' fields in Green should automatically update. Keep this tab open
   
   
   

Part 4: Update ProfitMetrics Expenses

1. Go to ProfitMetrics > Expenses > Payment Costs
2. Edit Payment Costs to replace the original Transaction fee with the updated 'Add in ProfitMetrics' values from the green column in the other document.
   
3. Click "Save Changes"