Bookings created by drag & drop through the Scheduling Mode, get automatically attached to the corresponding Budget line.
Bookings created in the traditional mode, as well as Media Orders, Work Orders, Project Objects and Time Reported Extras, end up in the Actuals pane at the bottom of the Budget window.
Actuals created using the Scheduling Mode
Once Bookings are added using the Scheduling Mode, the new Bookings get automatically attached to the corresponding Budget Detail. Use the Arrow icon to the left of the corresponding Budget Detail to expand or collapse the Actuals details.
If Booking Global Status is not set to Confirmed, the Actuals will not be attached to the Budget lines. Only once they are Confirmed, they will appear in the Actuals pane at the bottom of the Budget window waiting to be attached to the corresponding Budget Detail.
The orange and turquoise columns show the numbers for two different Time Report Modes:
Booking Lines Attached To Budget Details
- The To Date numbers (orange columns) are from the To Invoice / Used mode.
- The Forecast numbers (turquoise columns) are from the To Invoice / Used / Booked mode.
In this example, no Time Reports are filled out yet, so the To Date numbers are still 0.
Manually attach Actuals
Actuals created in the traditional mode are added to the Actuals pane, at the bottom of the Budget window.
Select the Actuals manually (by clicking on them) and drag & drop onto the corresponding lines in the Budget:
The 'DigiBeta 6 min' Budget Detail now gets an arrow icon next to it, showing that it can be expanded. When clicking on this icon, the Actual is revealed with the To Date and Forecast columns now filled with the data from the Actual. It is now easy to see that 2 pieces of this material were budgeted, but only 1 has been used so far.
Drag-and-drop Actuals onto Budget Details
As more time reports are filled in, the Actuals table gets more numbers in the To Date column.
A Budget Detail with attached Actuals
Multi-Attach Actuals by selecting Accounts first
Another way of attaching Actuals is to type the appropriate account number in the Account (Entry) column, or choose an Account in the selector of the Account column:
To commit to the selected accounts, scroll to the bottom of the Actuals list and press the Attach Actuals button.
Attaching Actuals by typing Account Number
farmerswife will then pair up the Actuals and Budget Details by looking inside each of the specified Accounts and trying to match the Actuals with the same Object or Object Class in that Account, using the same Activity.
For example, if the Actual (in the Booking) is 'Flame 1' with Activity 'Compositing SD - Hour' and goes into Account '302 Online' where there is a Budget Detail with Object Class 'VFX' and Activity 'Compositing SD - Hour' in that Account, then it is a good guess that the Object will be attached to that Object Class Budget Detail.
Attach Actuals using predefined Auto Assignment Steps
Auto Assignment Steps are rules to define which Actuals are to connect to which Account.
To configure Auto Assignment Steps click on the fourth icon at the top left of the Budget window, and select Edit Global Budget Settings.
Note that this can also be configured in the Server Setup > Financial Tab > Budget Settings.There is a green plus icon under the label Auto Assignment Steps. Click on it to add a new one.
The Auto Assignment Step window contains the following combine options:
- Object Class: You can select one or more Object Class that will be affected by the rule.
- Activity Name: You can select one or more Activities that will be affected by the rule.
- Object Name: Click on Add Objects to add one or more Objects that will be affected by the rule; use the Remove Objects to remove selected ones.
- Binder and Sub Binder Name: You can select to which Binder and/or Sub Binder, the Booking containing the Object / Object Class should belong to, for the rule to apply.
Here some example rules:
- All Objects belonging to a specific Object Class are to be attached to a specific Account, regardless the Activity.
Auto Assign Step for all Sound Studios
- Only certain Objects belonging to a specific Object Class are to be attached to a specific Account, depending on the Activity.
In this case, what decides the appropriate Account is the Activity that the Editor is booked with.
Auto Assign Step for Editors when doing Offline jobs
Auto Assign Step for Editors when doing Online jobs
- Some Objects are to be attached to a specific Account, regardless their Object Class or Activity, if any.
Here an example of a rule applying on many Objects, in this case a combination of Services and Media Orders that are to be attached to Account '306 Deliverables - Files'.
Auto Assign Step for all Services and Media Orders related to file deliverables
- Some Object Classes are to be attached to a specific Account, if the Booking they belong to is part of a specific Binder.
In this case, what decides the appropriate Account is the Binder where the Producer is booked in.
Auto Assign Step for Producers when booked on Pre Production phase
After creating some steps, the Budget Settings window looks like this:
Auto Assign Step for Producers when booked on Production phase
The order of the Auto Assignment Steps is important, which is why there is a green plus between every Auto Assignment Step. For example, consider the difference between these two examples:
Auto Assignement Steps in Budget Settings window
0.) Assign To Account 401 (Administration) If Object Class Is Any Of: “Producer” And Activity Name Is Any Of: “Administration”.
1.) Assign To Account 201 (Producer) If Object Class Is Any Of: “Producer”.
0.) Assign To Account 201 (Producer) If Object Class Is Any Of: “Producer”.
1.) Assign To Account 401 (Administration) If Object Class Is Any Of: “Producer” And Activity Name Is Any Of: “Administration”.
Forward Budget Details to Actuals
Actuals with auto assigned accounts
When there is no need to schedule a Budget Line because e.g. it is an outsourced service, you can use the Forward Budget Details To Actuals option. Click on the Budget Line to highlight it in yellow, next right-click on it and from the Budget Details menu select Forward Budget Details To Actuals. This will create a Project Object under your Actuals Project View, with the same price (buy and sell) and quantity, and at the same time will get attached to the Budget Line.
Forward Budget Details To Actuals
Project Object under Actuals View
When using this option on a Budget Detail that already has one or more Actuals attached to it, there is a warning dialog 'An Actual Is Already Attached To This Budget Detail. Are You Sure?'. This is to avoid creating duplicate Actuals by mistake. But you can still click Confirm to get the Actual created again.If you need to reverse this process and delete that Actual, you can click on the Actual line to highlight it in yellow, next right-click on it and from the Actuals menu select Delete Actuals.
Note that this is different from 'Detach Actuals' which only detaches the Actual from the Budget Line but does not delete the Actual.