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: From page [Invoices], Actions, Export Allocations. However, this file is using an API Token, therefore, there is no need to export any data from Kompass.

Uploading method: API Token

The File: There are three tabs on this spreadsheet, in [Departments], you will have to list all the departments along with their department code. You can find them in your API Admin site, "/api/admin/company/department/". In the [Budget] tab, you can add the monthly targeted budgets by department. Make sure you're using the correct department ID.

Tab [Analysis] contains the the data visualised.

You will have to set the start and end date of your analysis. Typically, we would need to include the entire running year. You can set it in cells F2, and G2. The pivot table will list the invoiced amount, the budgeted value and a percentage of meeting the targeted budget. The graph shows this percentage by department on a monthly base.

Further analysis: Please note that there might be discrepancies due to a shift of budgeted / invoiced date. For example if the invoices have a beginning of the month date for works carried out in the previous month, the percentage will not be accurate. Please contact Kompass helpdesk to correct this error.