Retail Business Manager (Excel) - Step by Step User Guide
Modified on: Tue, 5 May, 2020 at 6:37 PM
The template takes a simple approach where the user will enter data in these key areas: Products, Prices, Partners, Order Headers, Order Details and Expenses. Then, it automatically calculates the Invoice, Purchase Order and Report sheets.
5 types of orders (Purchase, Sale, Estimate, Quote and Adjust) are handled. Customer returns and Supplier returns can be easily handled.
The template can handle tax rates at order level and taxability at product level.
Discounts can be entered for each product on the order as well as order level discounts.
Additional order charges such as shipping charges can be entered as well.
Profitability of the business is calculated
Gross Profit = Sales Amount – Cost of Goods Sold COGS
Net profit = Gross Profit – Operating Expenses
Payments made on orders can be entered and the template will calculate the amount due on each order.
Current status of Inventory and Money will be automatically calculated and displayed.
Report can be customized for a time window by choosing start and end dates.
Monthly breakdown of 10 metrics are shown. Sales Amount, Cost of Goods Sold, Gross Profit, Operating Expenses, Net profit, Sales Quantity, Purchase Quantity, Purchase Amount, Quantity Returned by Customers and Quantity Returned to Suppliers.
We can see which product categories and products are among the top 10 and bottom 10. We can also choose our Sales metric to be Quantity, Amount or Margin to truly understand the best contributing products.
We can also choose one specific product and see its performance and current inventory levels.
Similar to products, we can understand the performance of our partners (customers and suppliers).