Finance/ Operations_Budgeting

Intro: In this file you can add your annual targeted budget per department. Then the file will retrieve the invoiced amount per department and compare against the budget.

In Kompass: Even though Kompass can easily show the invoiced amount by department in its dashboard, it currently has no budgeting module to record each year's budget.

File Needed: This file uses an API token to retrieve the invoiced amounts, so there is no need to export any data from Kompass.

Updating method: API Token

The File: The file has three tabs. In [Departments], list all the departments along with their department ID. You can find them in Kompass Admin under Company > Departments. In the [Budget] tab, add the monthly targeted budgets by department. Make sure you use the correct department ID.

The [Analysis] tab shows the data visualized.

You set the start and end date of your analysis in cells F2 and G2. Typically, include the entire current year. The pivot table lists the invoiced amount, the budgeted value and the percentage of the targeted budget met. The graph shows this percentage by department on a monthly basis.

Further analysis: Please note that discrepancies can arise from a shift between the budgeted and invoiced dates. For example, if invoices are dated at the beginning of the month for work carried out in the previous month, the percentage will not be accurate. In such cases, make sure you use the billing start and end dates. See this article for more info.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us