How to Use Margin Tables in thesheet

Working with margins and markups in your orders 

Learn how to manage your product margins and pricing strategies with the new interactive margin tables in thesheet. These tables help interior designers calculate product markups, trade discounts, and potential profits without the need for multiple spreadsheets or complicated formulas.

Step-by-step guide to using margin tables

1. Access the margin tables:

• After approving a quote in the quoting phase: How to Request a Quote from a Supplier in thesheet. 
• You will then be prompted to Move to order, this will create a new order in the orders view. 
• Navigate to orders to view your new order request.
• Margin tables will automatically pull the (RRP) Recommended Retail Price from the product details you’ve entered.
• No need to manually re-enter data; the system links this information seamlessly between your quote request and spec sheet.

2. Input your supplier pricing:

• In the margin table, you’ll find fields to input your negotiated price with the supplier. 
• Choose to either:
  • Enter the supplier’s trade price directly, or
  • Add a trade discount percentage.

• thesheet will automatically calculate the correct trade price or discount value for you, minimising errors and manual maths.

Example: If a product's RRP is €1000, and your supplier offers you a 20% trade discount, simply input “20%” in the trade discount field, and thesheet will calculate that your trade price is €800.

3. Customise product markups:

• You can customise how much markup you apply to each product depending on your pricing strategy.
• For example, if your studio offers clients the full trade discount, you might apply a smaller markup to maintain profitability.
• Alternatively, you could stick with the RRP or adjust the markup for individual products or suppliers based on negotiation.

4. Track product profits:

• As you input trade pricing and markups, thesheet will show you the profit for each product.
• You can adjust these values dynamically to see how changes in your pricing affect your profit margins.

5. Client discount breakdown:

• thesheet provides an easy way to calculate the total and average discounts you’re passing on to your client. This allows you to clearly communicate the value you’re offering them through your trade discounts.

Example: If you’re giving a client an average 25% discount across several products, thesheet will generate this figure for you, so you can include it in your client presentation.