Shiftmate
Food platform commission and net profit Excel
Calculate the net contribution per order from list price, commission, campaign, packaging and product cost.
Prepared by:Shiftmate Product and Operations Team · Son kontrol:
Actual file previews
The images below are the actual data entry and executive summary pages of the workbook to be downloaded.
Step by step usage
Prepare the file according to your business
Enter the platform list price, platform commission rate, campaign covered by the business, payment deduction, packaging and product cost on an order basis.
Run formulas and checks
Net income is calculated by deducting commissions, campaigns and other deductions from the list price; Net contribution is found by subtracting product and packaging costs from net income.
Turn results into action
Review the indicators on the summary page. Enter the commission according to the basis in the contract. Separate who bears the campaign burden. Find the negative contribution by product.
What does this Excel file solve?
Calculate the net contribution per order from list price, commission, campaign, packaging and product cost. Enter the platform list price, platform commission rate, campaign covered by the business, payment deduction, packaging and product cost on an order basis.
What's inside the file?
Platform commission, Campaign cost, Net income, Order contribution margin. The file contains sample rows, canned formulas, data validation fields, risk colorings, and executive summary.
Calculation and control logic
Net income is calculated by deducting commissions, campaigns and other deductions from the list price; Net contribution is found by subtracting product and packaging costs from net income.
Worked example: Platform order profitability
List price: 420 TL. Commission: 32%. Campaign: 35 TL. Product + package: 126 TL. Result: Net contribution is 420 - 134.40 - 35 - 126 = 124.60 TL; Although it may appear the same as the in-store price, channel profitability is tracked separately.
Decisions that can be taken as a result of this
Enter the commission according to the basis in the contract. Separate who bears the campaign burden. Find the negative contribution by product
Common usage mistakes
Recalculating the commission based on net income. Excluding packaging and courier disruption. Mixing VAT and price definition between channels
Limits and proper use
Platform agreements and deduction items are subject to change. Regularly verify the account with the actual progress report.
Compatibility and quality control
All 67 workbooks underwent formula error scanning, recalculation checking, and page-by-page visual inspection. Standard .xlsx file; Does not contain macros or external links. Formulas and data validation fields run inside the file. It is recommended that you keep the original file and work on a separate copy for your business.
Transitioning from Excel to automation
Use the file to solve restaurant operation needs immediately. When registration and approval traffic grows, move the same process to the Shiftmate workspace.
Frequently asked questions
Should the platform price be the same as the store price?
This is a business decision. Calculate the cost and demand impact of each channel and evaluate it together with the contract terms.
What should I write if the platform pays for the campaign?
Do not add the part that the business does not cover to the cost field; Take the actual deduction in the progress report as basis.