Update one formula. Every price follows.
Define pricing formulas with cost components, markup percentages, and labor rates. When material costs change, update the formula once and let cascade recalculation keep your entire price book in sync.
Formulas built from real cost components
Each formula is a structured calculation — not a single static number. Define the inputs that drive your pricing and let the system compute the result for every linked item.
Base Cost
Fixed cost foundation for the item or service
Product Cost
Cost of materials or products used
Material Cost
Additional material and supply costs
Labor Hours
Estimated labor time multiplied by hourly rate
Markup Percentage
Profit margin applied to the calculated subtotal
Sample Formula
Default12 price book items linked to this formula
Pricing that stays consistent
Define your pricing logic once and apply it across your entire catalog. When costs change, your prices update automatically.
JSON-Based Definitions
Formulas are structured data, not free-text. Each component is typed and validated before saving.
Cascade Recalculation
Update a formula value and every linked price book item recalculates automatically.
Full Audit Trail
Every change is logged with who, what, old/new values, items affected, and total price impact.
Rollback Support
Reverse a formula change if the results are not what you expected. Rollback history is tracked.
Per-Item Change Logging
Each price book item tracks its own price change history with old value, new value, and difference.
Default Formula
Set one formula as the company default. New price book items inherit it automatically.
One change, every price updated
When you update a formula value — say your material supplier raises copper prices — every linked price book item recalculates automatically. No spreadsheet, no manual edits, no missed items.
How cascade works
Update a formula value
Change material cost, labor rate, or markup percentage in the formula.
System identifies linked items
All price book items using this formula are queued for recalculation.
Prices recalculate in bulk
New prices are computed and saved. Excluded items are skipped.
Audit entry created
The change is logged with item count, total price impact, and who made the change.
One default formula per company
Set a company-wide default formula that applies to new price book items automatically. Override it on individual items when you need different logic.
Opt out of cascade per item
Some items have negotiated or fixed pricing. Flag them with the exclude-from-cascade option and they stay untouched when formulas recalculate.
Per-item price change logging
Every price book item tracks its own change history with old value, new value, and price difference. See exactly how a formula update affected each item.
Audit trail events
Global Value Update
A formula component value was changed across the board.
Bulk Recalculate
All linked items were recalculated after a formula change.
Formula Assignment
A price book item was linked to or unlinked from a formula.
Manual Override
A specific item price was set manually, bypassing the formula.
Know who changed what, and why
Every formula change is logged with the user who made it, the old and new values, the number of items affected, and the total price impact. Visible in the UI and available for review at any time.
Made a mistake? Roll it back.
If a formula change produces unexpected results, reverse it. Pillar tracks who rolled back the change and when, so there is a clear record even for corrections.
Connected features
Pricing formulas feed into the broader Pillar revenue pipeline.
Price Book
The catalog of items that formulas calculate prices for.
Learn moreEstimates & Quoting
Line items pull prices from the price book, keeping quotes accurate.
Learn moreInvoicing & Payments
Invoices reference the same catalog items with formula-driven pricing.
Learn moreAnalytics & Reporting
Profitability reports use accurate cost data from your formulas.
Learn moreSee formula-driven pricing in action
Walk through the formula builder, cascade recalculation, and audit trail with our team. We will tailor the demo to your pricing model.