1 | |||||||
---|---|---|---|---|---|---|---|
2 | ENTER VALUES | METHOD | EXCEL | BUDGYT | |||
3 | Users | 10 | Labor Hours | 1,769 | 147 | ||
4 | Departments | 67 | Cost of Labor | $114,807 | $9,526 | ||
5 | $ / Hour | $64.90 | Annual License Fee | $990 | $12,420 | ||
6 | Versions | 2 | Total Labor Cost & Fee | $115,797 | $21,946 | ||
7 | Cost Savings | $93,851 | 81% | ||||
8 | |||||||
9 | BUDGET TASK | EXCEL | LABOR HOURS | LABOR COST | BUDGYT | LABOR HOURS | LABOR COST |
10 | 1,769 | $114,807 | 147 | $9,526 | |||
11 | Edit Data in Budget Templates | Users must navigate to the proper tab and file and be sure not to delete or edit wrong data. Very easy to delete with the stroke of a key. No double checking data entry. Accuracy is hard to ensure. Reconsolidating data and verifying links still work and all formulas were not tampered with. | 740.4 | $48,052 | Cloud solution makes editing easy and double data entry verification ensures increased accuracy. Built in spreading tools and formulas can't be adjusted | 120.6 | $7,827 |
12 | Create formulas and ensure numbers are calculated properly each time | Time consuming setup of formulas that are often hard to follow. Users can maintain inputs but not the code for the formula. Creating color coded data entry cells. Ensuring enough data rows are there to meet all needs for all users. Must be an excel pro to create formulas and train users. | 268.0 | $17,394 | Managed thru Manage Formulas, time spent building formulas is low as it is seamless across any number of P&Ls. Users can be limited to data entry of inputs and admins only can edit formula structure. | 13.4 | $870 |
13 | Create Monthly Budget to Actual reporting with Summary and Detail information. 12 times a year | Summary data is entered manually or with advanced vlookup formulas and then shared with each user decided by you. Manually controlling access to data. Getting detailed information is nearly impossible. | 160.8 | $10,437 | Within minutes import data from any Accounting software and all budget to actual reporting is immediate and accurate. No manual data entry. | 1.0 | $65 |
14 | Verify that no rows were inserted that throw off any links | Verify each formula is still working and accessing the right data every time a user touches the file. | 111.7 | $7,248 | Rows can't be thrown off. No need to verify because the program is built to protect against this. | 1.0 | $65 |
15 | Working the budget drilling down and navigating to see your underlying conclusions. Audit your numbers quickly and find data fast. | Searching for data in excel is hard. No search function and hard to audit or trace formulas expecially if you are in a Board meeting. Verifying numbers and proving them is time consuming. | 84.8 | $5,505 | Find Data Instantly in Budgyt as they are all clickable Hyperlinks. Drill down and navigation are a breeze to see what underlying schedule is backing up your number. Or use our Search feature to search by any description term. | 1.0 | $65 |
16 | Create Consolidated reporting for all categories for all P&Ls | Link all tabs and rows manually. Very difficult to audit if forgot to link one tab. Manual audit takes a lot of time but very important for data integrity. Any user can break the link as well. | 84.4 | $5,479 | Manage Departments allows admin to roll up any group of P&Ls instantly. Adding any new department or P&L takes seconds and no formulas have to be recreated. Consolidated reports are automatically maintained dynamically. | 1.0 | $65 |
17 | Version Control. Label each excel template carefully to know version. Is it Version 1, 2 or Version 20? | With many emails and attachments and teaching users to ensure they label properly the excel files or this is managed properly by you. Meticulous attention to detail required or wrong data is saved. Very difficult to see before and after on changes. | 53.6 | $3,479 | Activity Audit Trail allows users to see who made what changes and when and no need for version control. | 0.1 | $6 |
18 | Password protect key cells and formulas | Manually select categories across all tabs to create passwords. Ensure you remember password and make sure only the right user accesses the category and tab. | 46.9 | $3,044 | User management tools make access to categories, Departments or P&Ls effortless | 4.5 | $290 |
19 | Add categories on all rows across Excel tabs to match your chart of accounts | Align each row properly across all P&L tabs. If a new category is created the user has to select all tabs and ensure all categories are on the same row by inserting the same row across every tab. Very dangerous process if accidently forget to select all the tabs. Maintaining tabs that have different categories is nearly impossible to globally add categories using this method. | 46.9 | $3,044 | Through Manage settings users automatically have every P&L set up perfectly. Row management is automatic. Management of different categories in different P&Ls is seamless. | 1.0 | $65 |
20 | Add a new Department to match all your reporting units | Insert another Tab. Copy Columns and Rows from existing Tabs. Label Tab appropriately, align in Excel file properly, color code if necessary to demarcate better. | 46.9 | $3,044 | Through Manage Departments, new P&Ls are created dynamically instantly. | 1.0 | $65 |
21 | Create exportable file for Accounting Software for reporting | Align all categories and copy and paste to new file values by month. Create pivot table to summarize by category and P&L. Ensure proper code for all. | 46.9 | $3,044 | Automatic with Export feature | 0.1 | $6 |
22 | Input Historical Data for easy comparison to LY and LLY | All manual as have to create new rows and duplicate efforts above. Accessing detail information is even more time consuming creating groupings for expanding and collapsing data. | 44.2 | $2,870 | Easy import tools allow detail or summary data to be compared to any month or year for any category, department or P&L | 1.0 | $65 |
23 | Train all users to login to folder and access their excel file and make updates to appropriate file | Manage email inquiries and lost emails or training on which file they should access, phone calls etc… | 6.6 | $428 | One time 30 minute training session plus some inquiries for clarification | 1.0 | $65 |
24 | Create a folder of all worksheets and create permissions for access | Manually create a central access point for all files. Could use email to distribute files but all links get broken via email. Dropbox or Google Sheet set up is also time consuming to give proper people access and ensure the wrong file is not shared with the wrong user. | 26.8 | $1,739 | Automatic with setup of Budgyt | 0.1 | $6 |
25 |