Managing project finances with thesheet’s financial overview

Learn how to track financial details, manage margins and monitor payments for all your project products using thesheet’s financial overview.

What is the financial overview?

The margin table, now available in Finances, gives you a comprehensive view of the commercial side of your project.

It lists all the products in your project with detailed pricing information, allowing you to:

track recommended retail prices (RRP) and trade discounts

calculate markup and profit margins

monitor client pricing and client discounts

track payment status for both you and your client

review supplier pricing and product totals in one place

Use Finances when you want to understand the numbers behind the whole project without opening every product one by one.

Open project finances

Open the project in thesheet.

Select Finances in the project header.

Review the finance table for the products in your project.

Finances now sit outside the project Overview. The Overview gives you a quick read on product progress, while Finances give you the margin table, pricing details and payment view.

The finance table pulls pricing information from the products in your sheet, including RRP and related product details. You do not need to manually rebuild the same information in a separate spreadsheet.

Input your supplier pricing

In Finances, you can enter the negotiated pricing you receive from suppliers.

You can either:

enter the supplier’s trade price directly, or

add a trade discount percentage.

thesheet then calculates the correct trade price or discount value for you, reducing manual maths and the risk of errors.

For example, if a product’s RRP is €1,000 and your supplier offers a 20% trade discount, enter 20% in the trade discount field. thesheet calculates the trade price as €800.

Customise product markups

You can customise the markup you apply to each product depending on your pricing strategy.

For example, if your studio passes more of the trade discount to the client, you may choose a smaller markup to keep the project profitable. Or you may keep the product closer to RRP, depending on the supplier, client agreement or project type.

You can adjust these values product by product, so the margin table works for both simple projects and more detailed commercial reviews.

Track product profits

As you add trade pricing and markups, thesheet shows the profit for each product.

Use this to test how changes in supplier pricing, trade discounts, markups or client discounts affect your profit margins before you commit to the numbers.

Red profit warnings help show where a product may create a negative profit margin and needs another look.

Calculate client discounts

Finances can also help you understand the discount you are passing on to the client.

You can review client discount percentages and client discount values, then use those figures to explain the value being offered through supplier discounts or your pricing approach.

Understand the finance table columns

The finance table includes the main financial fields for your project products, including:

RRP — recommended retail price

Trade discount % — your discount percentage from the supplier

Trade price — the price after trade discount is applied

Quantity — number of units

Total — total trade price, based on trade price and quantity

Markup — your added margin percentage

Client price — the price charged to your client per unit

Client total — total client price, based on client price and quantity

Client discount % — any discount percentage offered to your client

Client discount — the monetary value of the client discount

Profit — your profit on the product

These columns give you a clear view of the cost, client price and profit position for each product.

Track payments

The finance table includes payment tracking columns so you can monitor what has been paid.

Use Paid to track whether you have paid the supplier.

Use Client paid to track whether your client has paid you.

The payment icons show payment progress:

a grey icon means the payment has not been marked as paid

click once to mark 100% paid

click again for a partial payment state, shown with a half-green icon

This makes it easier to see what has been paid, what is partly paid and what still needs follow-up.

How finances connect to the project summary

Financial data from the margin table also supports the project summary figures, including:

Budget — the total project budget set when creating the project

Allocated — total cost of all main products past draft status

Remaining — budget minus allocated amount

Ordered — cost of everything past approved status

Paid — sum of items marked as paid

To be paid — ordered amount minus paid amount

Paid by client — sum of items marked as client paid

This gives you a project-level view as well as a product-by-product finance table.

Export financial summaries

You can export selected items from Finances to create a simple financial summary or invoice annex.

Select the checkmark icon to enable multi-select.

Choose the products you want to include.

Use the actions menu to export the selected products to PDF.

Review the preview that opens in a new tab.

Print or save the PDF.

The exported PDF can include product image, item name, RRP, client discount percentage, client price, quantity and client total.

Use this when you need a simplified cost annex for a client, invoice or internal record.

Who can edit finances?

Finances are available by plan:

Solo users can view project finances but cannot edit the finance table.

Studio users can view and edit project finances.

Agency users can view and edit project finances.

This means Solo users can still see the financial overview for a project, while Studio and Agency teams can actively manage and update the table.

Tips for using Finances

Review margins regularly so products do not sit with missing or negative profit.

Keep supplier pricing and trade discounts up to date.

Check payment status as products move from approved to ordered.

Use consistent currency formatting when entering values.

Remember that finance details and product sheet details stay connected, so updates in one place can support the other.

When to use the Overview instead

Use the project Overview when you want a quick read on project progress and product status.

Use Finances when you need pricing, margins, discounts, supplier costs, payment status or a commercial summary of the project.

Keeping these views separate makes it easier to move between project progress and project finances without mixing them together.

Managing project finances with thesheet’s financial overview