You'll find the 'Budget Vs Actual' via your project's Budget sub-tab under the Project Reporting dropdown.
RAVE Financial Management System's 'Budget Vs Actual' report allows you to easily view ALL of your project's Key approved cost and sell data fields all in one place across Categories and sub-categories.
We break the information down into "Raw Cost" and "Client Price".
The export function allows you to choose which side of the information you want to export or ALL of it into one report.
Raw Cost Side (in blue)
The Raw Cost Side displays all of your Approved Quotes per Category, and if you use the sub categories, we then break down any additional costs, which are Variations.
Next is the Total Cost column, giving you a sub-total including variation costs.
The next field gives you the Billed to date information (this is approved bills only, not drafts).
You can then see the projected costs and a calculation of the total costs that have been less billed to date.
If you are using the Cost to complete column to zero out any extra budget this will be displayed as either 0 or the same data as the projected costs column.
The Client Price Side (in green)
The Client price side displays the client project value from the estimate page, excluding Variations, and then the Variation value. Then a total project value for your clients including Variations and Markup.
The expected Gross profit which is total project value Less Total cost is displayed as both a $ value and %.
We then display the total invoiced to the client to date.
If you are using the client cost to complete to zero out any extra client budget on the charge up report this will be displayed as $0 or it will be displayed as the Total project value Less Invoiced to Date.
The last column is your running gross profit which is a calculation of client invoices less billed to date.
These are actual figures based on approved documents.
You can then add notes to each Category or Sub Category using the 3 dot ellipses under the notes column.
To the top right of the page is the export to Excel button.
Here you can choose to export:
The entire Display - "Both",
Just the Raw Costs (Blue Side)
Just the Client Price (Green side).
You can also choose to export with or without Notes.
For both and Client Price you can also choose to include Profit Columns both expected and actual running Profit
