The first step is to create a Project for this job. Fill in all details in the New Project window and click OK to save the Project.
Once done, re-open the Project and access the Budget module by clicking on the Budget icon (the pig icon) to the right of the View Filters:
The Budget window opens. The top main area displays the Project's Budgets and the area at the bottom displays the Project's Actuals. So far, since there are no Budgets or Actuals, both areas are empty.
Accessing Budget window through Edit Project window
To create a new Budget, click on the Pig icon and give it a name.
The Budget list now contains one Budget/Quote. A Project may contain as many budgets/quotes as needed.
Child Budgets can be created by dragging a budget/quote onto the main one. This way a Child Budget is related to a Parent Budget.
E.g.: Main Budget 'Production' showing the total, and having 3 Child Budgets:
- 'Munich Shoot' - totals per sub-production
- 'Madrid Shoot' - totals per sub-production
- 'Vienna Shoot' - totals per sub-production
The initial grey color indicates that it is still not the 'Active Budget'. Click on it to see the following information:
- Created By: Shows the User who created it and the creation date and time.
- Modified By: Shows the User who last modified it and the last modification date and time.
- Budget Type: There are three options to choose from: Budget, Quote, Current Quote.
- Quote Nr: This is a consecutive counter for the Quotes within a Project, and it is reset on every Project.
- Active Budget: To activate/deactivate it.
- Discounts: This refers to the Per Category Discounts (the ones in the Edit Project header, e.g. "Users: 10%") which by default are inherited from the Project into the Budget. This makes sense when the Budget is work in progress. But when a Quote is sent to the customer, it can be useful to lock these discounts so the Quote remains as when it was sent. This is done by changing this selector to "From Budget".
If you have your prices on Object Classes and use these when quoting/budgeting, then this setting will not be useful.
- Comparison Budget: See the corresponding chapter further down for detailed information.
- Budget Operators: See the corresponding chapter further down for detailed information.
- Price Agreements: See the corresponding chapter further down for detailed information.
- Custom Fields: Your customized fields show to the right of the above mentioned standard fields.
Creating a new Quote
Right below the header containing the described fields, there is a Filter to expand or collapse the different levels of your Budget Structure. It contains the following options:
- Categories: Everything is collapsed and only the Categories are displayed.
- Accounts: Only the Categories level is expanded, so the Accounts are displayed, but not the details in the Accounts.
- All: Everything is expanded.
- All Containing Data: Only the Categories and Accounts that contain any Budget Details are expanded.
You can also expand or collapse a Category or Account by double clicking directly on it or by clicking on the arrow icon on its left.
To add a Budget Detail, click on the green Plus icon next to an Account or Category. The Object Browser window opens, for you to select an Object/User or the Object Class it belongs to, or else a Service, Material or Expense.
If your Objects/Users belong to a specific Object Class and the price is defined in the Object Class, you might prefer selecting the Object Class itself to later decide what Object or who will be doing the job.
The Object Browser
If your Objects/Users belong to a specific Object Class and the price is defined in the Object Class, you might prefer selecting the Object Class itself to later decide what object (room, workstation etc.) or who will be doing the job. And also because in the quote to be sent to the client, you prefer not displaying the specific room or operator, but the Object Class they belong to.
Use the Search field on the top right corner of the Object Browser to search for the service you need to add. It will search on Name (name of Object), Activity and Type (Object Category, Object Class and Menu Group).
Make sure to set the View to All to search on all types of objects (Object Class, Service, Material…) when not sure where the service you are looking for belongs.
You can select Day or Hour under Rates to see the price in that specific unit.
As a search value is being typed, the search results are updated and helpers with known results are shown in the auto complete window.
The results area displays the Objects with details on the following columns:
Name: Under this column you can see the name of the Object, and the Activities connected to it (if the Show Activities option is enabled at the bottom right corner).
Type: It displays the Object Category (Users, Resources, Rooms, etc), Object Class and Menu Group (from Services, Materials and Expenses).
Buy: Show the buy price in relation to the selected unit.
Sell: Show the sell price in relation to the selected unit.
Unit: Shows the unit. It can be changed with the Rates filter on the top of the window.
Click on the Object that you need to add to the quote. If the Object has an Activity, a window pops up to select one. And a final window pops up to type the Quantity. Once done, the Object Browser window will reopen remembering the previous filters and settings so you can keep adding details to the same Account. Once done, click on Done at the bottom of the window to close it.
In this example, part of this Project is to do some digitizing, so the Object Class 'Offline' is added with activity 'Digitizing - Hour'.
At this point the '2 hours' of digitizing are just an estimate since the actual work has not begun yet. The unit can be changed from Hours to Days under the “Qty (Budget)” column, by clicking directly on the unit name or on the drop-down arrow next to the unit name .
A note can be added for a Budget Detail, by clicking on the balloon next to the Object name.
Adding a Budget Detail
To complete the Quote, more Budget Details are added.
The complete Quote
Keyboard Navigation: Show Entries On All Accounts
Another way of adding Budget Details is by enabling the option "Show Entries On All Accounts", which is the second button on the top left corner of the window. Once enabled, empty Entries will be added to each Account and Category.
Instead of clicking on the green Plus icon to open the Object Browser, use this Entry field to type the Object name or Object Class name. A drop-down list will display the possibilities according to the typed characters. Use the up/down arrows on your keyboard to navigate to the Object you want to select and hit Enter to select it.
Navigate from cell to cell by using the left/right arrows on your keyboard.
While on the Quantity column, when the quantity selector is highlighted hit the Space bar and use the up/down arrows to change between Hour/Day/Fixed Rate.
If the 'Allow Adding Directly To Budget Categories' setting was set to No in the Budget Settings in the Server Setup, you will not be able to add Budget Details to a Category.
Show Entries In All Accounts
It is possible to modify the Description of a Budget Detail. When clicking on the specific Description cell you need to modify, it gets highlighted in grey. If you start typing then, the description gets replaced by the new value. If, instead, you need to add further information after that description, then double click on it to get rid of the grey selection, then you can type after it.
Reordering & Deleting
Budget Details can be reordered by drag & drop - also across accounts.
Use the bin icon to the left of the Budget Detail to delete that line.
Cut, Copy & Paste
By selecting one or more Budget Details, you can right-click and select Cut or Copy from the menu - or simply press Command-x/Command-c on Mac, or Control-x/Control-c on Windows.
This will place the selected Budget Details on an internal clipboard.
When you have cut/copied some items to the clipboard, you can select one or more Accounts or Categories and paste the items there, by right-clicking and selecting Paste - or by simply pressing Command-v on Mac, or Control-v on Windows.
If you have selected multiple Accounts when pasting the items, the Budget Details will be copied into ALL those Accounts.
If you have selected a Budget Detail instead of an Account when pasting the items, they will be inserted directly AFTER the selected Budget Detail. This makes it easy to control exactly at which position in the Account the copied items are added.
While editing a Budget, you can use Undo (and then Redo) by pressing the Tools menu at the top, or by pressing Command-z to Undo and Command-Shift-z to Redo on Mac, or Control-z to Undo and Control-y to Redo on Windows.
The 'undo/redo' functionality is made possible with a variable-steps undo buffer. It will keep a maximum of 5MB of Budget data in the buffer. That means the bigger your Budgets are, the fewer steps are kept. For small Budgets it is virtually infinite.
- When raising a Purchase Order from a Budget Detail (or editing it in a way that affects the Budget), the undo buffer will be emptied. This is to prevent the PO from unintentionally getting out of sync with the Budget.- When forwarding Budget Details to Actuals, the undo buffer will be emptied. This is to prevent the Actuals from unintentionally getting out of sync with the Budget.
- When selecting a different Budget, the undo buffer will be emptied. In other words, you will no longer be able to undo your recent changes.
A status label at the bottom-left of the Budget window indicates when an action has been performed on the current Budget. The label lasts for a few seconds.
To hide or show columns in the Budget table, click on the Eye icon (the third button on the top left corner of the window - also found at the top right corner of the Budget table) and select Edit View. As the Edit View window opens, columns can be selected to show by clicking on them in the Hide area, and they can be hidden by dragging them from the Show to the Hide area. The order of appearance can also be modified by clicking on the up/down arrow next to each column name or by dragging it to a new position.
Here a description of the available columns related to the Budget:
For details on the columns related to the Actuals see View Options in the Reporting and comparing chapter.
- Account Nr: Displays the number of the Category, Account, Sub-Account, etc.
- Description: The name of the Category, Account, Sub-Account, etc.
- Budget Name: The name of the Budget being visualized.
- Multiplier & Quantity After Multiplier: The Multiplier column allows defining a number to multiply the Quantity column. E.g. you need a camera for 5 hours for 3 days: in the Quantity column you define 5 hours (if the price is hour-based) and in the Multiplier column you define 3. As a result, you will get 15 hours in the Quantity After Multiplier column.
- Qty: Displays the quantity, either Hours, Days or Fixed.
- Sell Rate: Shows the sell rate and the option to add a discount per line.
- Sell: Shows the total sell rate for the line, according to the quantity and the discount (if any).
- Budget Operators: For selecting to which line the Budget Operator applies.
- Price Agreement: Shows the Price Agreement affecting the line.
- Buy Rate: Shows the buy rate.
- Buy: Shows the total buy rate for the line, according to the quantity.
When working on a Budget for a long time, it is important to save the work in progress. Hit the 'Save'' button at the bottom of the Budget window.
Printing a Budget/Quote
To print out a quote, the Financial Reports Designer is used. In the bottom-right corner of the Budget window, there is an icon for quick access. If some print templates have been created already and the option 'For Budgeting' has been enabled on them, they can also be directly accessed from this icon:
Print Quote using Financial Reports Designer
Currently there are up to 3 grouping levels for generating Financial Reports, and there are 6 Budget-related groupings to choose from:
- Budget: Select this option to group by Budget title.
- Budget Category: Select this option to group by Budget Category, e.g. Category name such
- as Post Production.
- Budget Account (Main): Select this option to group by the Account, e.g. main Account number and name such as Deliverables.
- Budget Account (Assigned): An Account may have multiple Sub-Accounts. Use this option to show the Budget Account Assigned (=Sub-Account) instead of the main Account. E.g. Files, could be a Sub-Account for Account Deliverables.
- Budget Details: Select this option to group info per Budget Detail, which have the Objects or Object Classes added to the Quote. This grouping makes it possible to compare Budgeted vs Actualized info, since it collects all the lines belonging to one Budget Detail (e.g. multiple Actuals can be attached to a single Budget Detail).
- Custom Fields (Budget): Group by Custom Fields created at Budget level.
"Budget", "Budget Category", "Budget Account (Main)" and "Budget Account (Assigned)" groupings have access to the Budget information, such as Quote Number and Budget Custom Fields, as well as Project information, such as Client, Note, Project Custom Fields, necessary for designing the header of the Quote.Please refer to the Financial Reports Manual for details on how to design reports.
See below for an example of the finished Quote:
Quote Versioning & Current Quote
Quote in the Financial Reports Designer
After the Quote has been printed and sent off to the Client, there might be some rounds of changing the Quote before it is finally approved. This can be done by modifying the first Quote. But sometimes it is useful to have a history trail of all the sent Quotes and unique number for each Quote, so you and your client know you are discussing the same Quote. This is achieved by selecting the Quote, clicking on the drop-down arrow and selecting Duplicate. The new Quote will automatically get the next number in the series – in this case “2”.
This second quote can be set as the Current Quote, to clearly see that it is the latest version being discussed with your client.
When a Quote has been approved by the client, enable the checkbox next to Active Budget. This has the following effects:
- An Active Budget can have Actuals attached to it.
- The Scheduling Mode is only active on Active Budgets.
- The Active Budget is the one included when generating a Financial Report over multiple Projects.
- The Budget Details of an Active Budget can be invoiced: they need to be included in the Project View filter for invoicing, typically called "To Invoice/Invoiced". See more details in chapter Invoicing the Budgeted.