The Product Expenses tab allows you to track each expense associated with a product in order to assess overall profitability.
Note: The Product Expenses tab can be turned off by configuration. Go to Settings > Configuration and search for "expenses tab", then turn off the configuration "Shows the expenses tab on the products page in admin." to shut off the tab entirely.
On the Main tab, you can enter a Budget for total expenses:
After entering a Budget and saving, navigate to the Expenses tab. You will see a grid with Retail Sold, Discounts/Fee, Net Sold, Unpaid Balance, Revenue, and Total Budget:
- Retail Sold is the sum of all of the individual products sold retail prices. In most cases, this is simply Quantity Sold x Price. However, since Price can be changed at any time, you may have inconsistencies.
- Discounts/Fees is the total of all Discounts and Fees assessed on the ordered products.
- If Discounts/Fees is negative, Net Sold will be Retail Sold - Discounts/Fees. If Discounts/Fees is positive, Net Sold will be Retail Sold + Discounts/Fees.
- Unpaid Balance will reflect the total unpaid balances on the ordered products.
- Revenue is Net Sold less the Unpaid Balance - this is the amount that has been collected on the product.
- Total Budget reflects the Budget entered on the Main tab.
Note: All grid values on Master products are the sum of the values on the Variations below the Master. IE - if there are 4 variations with a budget of $100 each, and each have Revenue of $400, the Master would show $400 in Total Budget and $1600 in Revenue.
To record an Expense, click Add New Expense at the top right. This will open a modal requesting information about the expense to be added:
Note: The Expense Type and Payment Type lists are populated by the system lists "Expenses" and "Expense Payment Types". Both have default list items selected, but can be edited in Settings > Lists. See Managing Lists for more information on adding list items.
Note: When recording an expense on a Master product, you can choose to record the expense on each variation or on the master product using the checkbox at the top "Add expense to child products". If checked, the expense will be recorded once on each variation. If un-checked, the expense will be recorded once on the Master product only.
After completing the expense, click Save to close the modal and record the expense against the product.
Note: The fields available on the modal and in the grid of expense details are editable by configuration. Go to Settings > Configuration and see the Expenses section to turn on/off fields.
Note: On a Master Product, expenses for all variations will be listed in the expense grid, with the product name listed.
Now that an expense is recorded, you can also upload a copy of the receipt for this expense:
This will open a modal where you can choose an image file from your device to upload:
After choosing a file it is uploaded immediately and can be viewed as a thumbnail. To see the image in full-size, click the image itself.
Income (Relevant to Forecasting)
If you are going to use Event Forecasting, click ADD NEW INCOME ITEM. Enter a "Title" and check "Include in Forecast". Input the "Initial Budget" and the "Current Forecast" for the item. If the item is your anticipated ticket sales, then check "Exclude from actual sales forecast".