Project Numbers table

The project numbers table offers numerical data based on allocations, expenses and given budgets. Some numbers come automatically from the system as you make resource allocations - some data is managed manually.

Income budget (eur) = estimated income budget for the project. Edited by clicking any of the slots in the table or by clicking the ellipsis icon.
Hour budget (hours) = budgeted hours for the project. Edited by clicking any of the slots in the table or by clicking the ellipsis icon.
Expense budget (eur) = estimated expense budget for the project. Edited by clicking any of the slots in the table.

Allocations (hours) = Cumulative sum of all the allocations for the project
Allocations (eur) = Cumulative sum of all the allocations * forecast price from task / role
Allocations, cost price (eur) = Cumulative sum of all the allocations * cost price from role

Allocations, profit (eur) = Allocations (eur) - Allocations, cost price (eur)

Realizations (hours) = Cumulative sum of all the actual hours registered for the project
Realizations (eur) =Cumulative sum of all the actual hours registered for the project * price from task / role

Fixed expenses (eur) = edited by clicking, explained below in this article
Payment positions (eur) = edited by clicking, explained below in this article
Invoiced (eur) = explained below in this article
Uninvoiced (eur) = edited by clicking, explained below in this article


Income Budget


You can add the income budget for your project through the basic information section or through the project numbers table. Afterwards you can divide it evenly for the project's months or sum the monthly values together into one budget.

One big number to keep an eye on or multiple monthly numbers

In the example above we have set the project's schedule to be 1st of June - 30th of September.

A) Distribute to monthly income budget (colored orange). We have set the Income budget as 10,000€. If we click on the ellipsis icon (blue circle) and choose Distribute to monthly income budget the budget will be divided evenly for all the slots depending on the project's schedule. In this example monthly income budget for each month will be 2,500€ (10,000€ divided for 4 months)

All the previous data added in the project numbers table will be erased. In this example the 2,500€ for May would be erased:
Result of dividing the basic info's income budget evenly based on the project's schedule


B) Sum to own income budget (colored green) takes all the current monthly income budgets and sets the total value as the new Own Income Budget in basic information. This will erase the previous value set in the basic information.

In the example above if we chose the option 'Sum to own income budget' the new Own Income Budget would be 2,500€ from May. Note that this will take all the months into account, so the TOTAL row in the right will always be the value transferred over to basic information.


Hour Budget


There are two ways to add the hour budget for your project.

A) You can add an hour budget for your projects in the basic info section:
The oranges-project has a thousand hours budgeted for it

B) You can add the monthly hour budget straight to the corresponding months in Project Numbers table
We are expecting 200+250+300 hour June - August


We also have two actions under the ellipsis icon in the Project Numbers table.
A few features under the ellipsis icon

Copy to project total hour budget gathers all the monthly hour budgets (set in the Project Numbers table) and sets them as the new Hour Budget in the project's basic information. In this case the new hour budget would be 750 hours (200h + 250h + 300h).
Note: any value set in the basic information will be overwritten.

Allocate a role allows you to immediately allocate the total hours from the Hour budget row to one specific role. In the screenshot below we have chosen the role 'Accountant':
More roles can be added by admins of Silverbucket

After we save the changes the unassigned role 'Accountant' will be allocated for 750 hours between the project's schedule, which is 1st of June - 30th of September.

Accountants are needed for this project


Fixed Expenses


You can add and monitor the fixed expenses of the project by clicking the blue hamburger icon which allows you to add & edit the project's expenses.

We have added one fixed expense for our project worth 111€

Afterwards they are shown in the corresponding month in Project Numbers table.:
Great.

Payment Positions


The hamburger icon on the payment positions row opens a modal in which you can create, edit or delete payment positions.

Invoiced


Invoiced row shows the total amount of invoices made for each month. The hamburger icon in this row gives a more detailed view of each invoice made, and allows editing and deleting of invoice rows.

Deleting an invoice row releases connected payments and they appear back on the uninvoiced row.

Uninvoiced


The Uninvoiced row's hamburger icon opens a window for invoice creation. This window automatically creates a row for uninvoiced payment positions and the actual hours for chosen time range if any exist. You can also manually add your own rows.
You can also create invoices by directly clicking an uninvoiced amount on the row. This is a handy way of invoicing your project for the month you clicked.

Clicking the number in Uninvoiced-row opens a Quick Invoice -modal


If you click the total value of the Invoiced row, invoicing is done from start of the project until the current date:

Clicking the total value
How did we do with this article?