AutoActuals is the bidding and actualizing template for professional AICP producers, production managers and coordinators. Built on Excel, AutoActuals is intuitive, easy-to-use and will save you tons of time.
Use the industry-standard AICP bidding template with 311 lines or even set it up to use your own bid. From the bidding process through the wrapping phase, AutoActuals is a must-have budgeting tool for commercial coordinators.
Beyond bidding flexibility, the power of AutoActuals is in the actualizing. Simply enter PO's into the log and then select AutoActualize from the custom menu. Each AICP line item from the purchase order log and the timesheet is totaled and placed in the bidding template. Includes a TimeSheet module to compute and actualize crew payroll. Used around the world for easy and instant actualizing of commercial productions. Know exactly 'where you are' with your budget as your production continues.
Customization is available for your production company. We've created many custom versions to include AICP, AICE and integrate directly with various accounting systems. Contact us to have a version specially designed for your company's workflow. Now you can save time beyond the Excel workbooks.
AutoActuals is the affordable bidding, budgeting and actualizing software application that will save your commercial production company time and money. Used by thousands of commercial producers around the world.
Actualize to ALL sections on your bid from your PO/PC Log and Time Sheet
Actualize all payroll data, including OT hours and amounts
Track Petty Cash and print out reports
Keep track Grand Totals on the bottom line as you bid your job
Shortcuts menu: instantly navigate to any part or line number!
Powerful Search and Find features
Quick Sort to view or print
Worksheets are independent documents and can be shared
AutoActuals can be used with your own bid template
Now available for download!
AutoActuals Features
AutoActuals’ easy-to-use features make actualizing your next job a snap!
Cuts down end-of-show wrap time significantly
Stay on top of expenses minute to minute while on the set
Quickly search and find items and totals
Helps you organize production costs and expenses
Prints out professional, organized reports
One minute learning curve!
The Bid
The standard eight-page AICP bidding template provided by AutoActuals is set up to let you bid your job quickly
Formulas included in open worksheets, you can change formulas to suit you
Totals automatically calculated and entered into the estimated and updated into the actuals columns on demand
After entering information in the PO log, the bid can be AutoActualized. The total for each AICP line number will appear in the actual column on the summary page as well as on the pages of your bid
The PO Log
Enter the important information into the AutoActuals PO log and keep track of what's spent: line-by-line and moment-to-moment
Check log
Track PC disbursements and accountings
Sort by PO#, Issued To, Date, Note, AICP# or Amount
Find item totals instantly
The Timesheet
Automatically calculates overtime based on in and out times.
All totals, kit rentals, OT hours and amounts actualize back into the bid
Adjust lunch: calculate time out of total time or time out of time-and-a-half
AutoActuals comes with a standard AICP bid form which is eight pages in length. The pictured screenshot is a portion of the top Summary Page (page one. When bidding or actualizing, your totals are entered on the cover sheet and in the section total areas. Pages 2-8 are detail sections where bid information and production costs (estimated and actuals) are detailed.
The PO Log is a simple list using a standard Excel worksheet. It's quick and easy to log in the appropriate information (AICP#; PO#; description; $amount) as PO's are assigned. The register of PO information can be searched, sorted and actualized. Use it while on the set and you'll know where you stand as the project progresses. Or assign copies of the log form to various crew members and the information can later be combined and even dynamically linked to any bid form. Or log the information in at the end of the job to cut your wrap time.
The Time Sheet is where you input each crew member's In and Out times and your total payroll is automatically calculated with separate categories of Overtime, Double Time, and variable Lunch rules to accommodate Union and non-union jobs.
AutoActuals System Requirements
Macintosh
macOS X 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 10.12, 10.13, 10.14, 10.15
Requires one of the following versions of Microsoft Excel: 2001, Excel X, 2004, 2008, 2011, 2014, 2016, Excel 365
Windows
Windows XP, Vista, 7, 8, 10
Requires one of the following versions of Microsoft Excel: 2000, 2002, 2003, 2007, 2010, 2013, Excel 365