Skip to main content

Keep formula on category total rows when exporting a budget to Excel

Description:

When we export a budget from BuilderPad Finance to Excel, the individual line items keep their formula, but the darker category total rows (the header rows that total each category) come through as static numbers instead of formula.

This means that if we update any line item in the exported file, the category totals don’t update with it. We have to go back and rebuild the SUM formula on every category row by hand each time we export, which takes time and makes it easy to miss one and end up with totals that don’t match.

What would help:

  1. Export the category total rows with live formula (for example, a SUM of the line items in that category) so they update automatically when line items change, the same way the line item formula already do.

  2. If there’s a reason to keep static values as the default, an option at export to include formula on all rows would work too.

Example: After exporting a budget to Excel, changing an amount on a line item updates that line’s own totals, but the darker category total row above it stays the same, so the category and overall totals in the file no longer add up.

Submitted on behalf of Toraye Izatt, Genova Construction.

Log in to comment and vote

No comments yet

Be the first to share your thoughts.