Overhead Allocation
Types Of Overhead | Overhead Client | Overhead Project | How Is Allocation Of Overhead Calculated | Distribution Of Allocated Overhead | Overhead Expense And Labor Considerations | Overhead Expense And Labor Considerations | Reports | Advanced Reporting | Non-Billable Projects | Multiple GL Companies
The simplest definition of overhead is the ongoing expense of operating your business. Workamajig allows you to track this overhead and distribute/allocate a percentage of the amount against a Client or Client Project based upon the number of hours worked for the client/project, the labor cost associated with the hours worked for the client/project or the amount billed to the client/project.
Expenses to your business are tracked using Vendor Invoices, Expense Reports converted to Vendor Invoices for Payment, Misc Costs, Journal Entries, and Labor Cost. Where an overhead expense differs from a client expense is the overhead expense is not related to a client or client project or is entered against a client that has been designated as an overhead client. Workamajig will total these transactions which becomes the Overhead Allocation pool. The amount contained in the Overhead Allocation pool at any given time is based upon the posting date or transaction date, in the case of Labor and Misc Costs. This pool can then be distributed to the Client or Project based upon the dates selected when you look at the Client P&L or Project P&L.
Types Of Overhead
COGS - Vendor Invoice, Misc Cost, Expense Report converted to Vendor Invoice: Typically COGS expenses are connected to the client and would not be considered, however, there are occasions, such as Printing, Color Fiery, where you have purchased the items in bulk and use them internally.
Expense - Vendor Invoice, Expense Report converted to Vendor Invoice, Journal Entry: these would be an expense, such as Rent, Utilities, Payroll, that were purchased for use internally.
Other Expense - Journal Entry: these would be an expense that you have classified as other expense
Labor - time entries against projects with no client associated with it or the client has been designated as an Overhead Client: Labor is handled a bit differently. The actual cost of labor is entered via your Payroll journal entry. However, we allow you to enter an hourly cost on each employee record. The hourly cost is a per hour value. It is up to you to decide what is included in this figure. Some agencies will only take the employees base salary and divide by the yearly number of hours, an unloaded value. Others will calculate the amount of overhead, divide this up by employee and add it to the base hourly cost, a loaded value. To ensure accuracy the way you arrive at an hourly cost for your employees should remain consistent across your entire staff. Workamajig will take into account this hourly cost when allocating overhead to the client/project.
Overhead Client
From the Company Record: Client Setup>check Overhead Client
The Overhead Client designation is typically used for your company client record. Workamajig regards any expense entered against this client or client project to be overheard. NOTE: Any labor hours entered against an overhead client project are not considered as part of the Total Agency Hours or Total Agency Hourly Cost when calculating Overhead Allocation percentage.
Projects created for an overhead client that have billable items will be available for billing when using Mass Billing or Billing Worksheets.
Overhead Project
An Overhead Project is typically set up to make it easier to report, track and budget for your agency expenses. Typical projects would be PTO/Vacation, Sales (Travel and Expenses) and Internal Marketing (corp website, media). The projects should be created using your agency as the client.
There are a few considerations when setting up these projects:
I do not want the project to show up for billing: create the project, as usual, this will assign a project number. You can then blank out the client ID/Name. Any project with no client designated will not be available to the billing process.
I do not want my staff's charge ability to go down due to work on internal projects: create the project, as usual, consider if you want it to show up for billing. From Project Setup: Accounting, make sure Non-Billable is unchecked.
I want the time entered on the project to be considered non-billable: create the project as usual. From Project Setup: Accounting>check Non-Billable.
How Is Allocation Of Overhead Calculated
Overhead Pool
The overhead pool is calculated by the sum of all expense transactions (Vendor Invoices, Expense Reports converted to vendor invoices, and Journal Entries) that have posted to the GL Account Types: COGS, Expense, and Other Expense and are not associated with any Client, Client Project or are associated with an Overhead Client / Overhead Client Project.
NOTE - GL Company Considerations: If a specific GL company is NOT selected prior to running the Client/Project P&L reports, the Overhead Pool will consist of all overhead transactions from all GL companies. When you specify a GL company prior to running the reports, only overhead transactions for that specific GL Company will be used to calculate the Overhead Pool amount.
Hours
This will divvy up the overhead "pool" among the lines being reported, based on the total number of hours entered against the client project(s) / total agency hours. This percentage is then applied to the pool amount to arrive at an amount to allocate to the Client or Project.
Calculation: (Hours Worked For Client or Project / Total Agency Hours Worked) = Pct of Overhead to be Allocated to Client or Project
Labor Cost
This will divvy up the overhead "pool" among the lines being reported, based on the employee records hourly cost field for all time entered against the client project(s) / the total cost of all hours entered across the agency. This percentage is then applied to the pool amount to arrive at an amount to allocate to the Client or Project.
Calculation: (Total Cost from Hours Worked For Client or Project / Total Cost from Total Agency Hours Worked) = Pct of Overhead to be Allocated to Client or Project
Total Bill
This will divvy up the overhead "pool" among the lines being reported, based on the total dollars billed on client invoices for the client or project(s) / total dollars billed towards all client projects. This percentage is then applied to the pool amount to arrive at an amount to allocate to the Client or Project.
Calculation: (Total Amount Invoiced to Client or Project / Total Amount Invoiced across Agency) = Pct of Overhead to be Allocated to Client or Project
None
No allocation of overhead will be applied and all profitability is purely based on the costs and sales of the transaction directly linked to the client and/or project only.
Distribution Of Allocated Overhead
When you run the Overhead Allocations Detail report, you will see that the overhead pool may be categorized into 3 groups: COGS, Expense, and Other Expense. The system will distribute the overhead into these areas of the Client/Project P&L.
The initial calculation made above is to arrive at the percent of the overhead pool to allocate to the client. The value of this overhead is what the system is trying to match when it comes to distributing the overhead pool. In the case of Expense, there is an additional calculation made to subtract out Labor Cost, which comes from the hourly cost setup on the employee record, and Misc Cost, which is a way of accounting for things purchased in bulk and then distributed to the client/client project, such as photocopies, stock photos, etc. Giving the following calculation:
COGS Calculation
(Allocation Pool * pct to allocate) = allocated Amount of COGS Overhead
Expense Calculation
(Allocation Pool * pct to allocate) - Labor Cost - Misc Cost = allocated Amount of Expense Overhead
Other Expense Calculation
(Allocation Pool * pct to allocate) = allocated Amount of Other Expense Overhead
Overhead Expense And Labor Considerations
The above Expense calculation often brings up the question: What should I use for the hourly cost on the employee record? Should I use just the base salary per hour or a loaded hourly cost?
Either is fine, as the system will take this into account when arriving at the allocated amount of expense overhead. Here is a couple of examples to show you: We will assume that the person only worked 1 hr for the client.
Base or Unloaded: I set the hourly cost to be the base salary divided by yearly hours.
Let's say this is $10. My expense overhead pool comes up to $200. Revenue = 1000. Pct to allocate = 10%
So if my overhead pool is 200 and the client has 10%, this means the client should have a cost of $20. This becomes the Target allocation the system is trying to reach. So it will make a further calculation to make sure the allocation will act as if it was adding $20 in expenses.
Expense Allocated Amount - Labor Cost - Misc Cost = amount to allocate>> 20 - 10 - 0 = 10
So in the Client P&L>>Revenue - Expenses - Overhead = Profit>> $1000 - $10 reported labor cost - $10 expense overhead allocation = $980
Loaded: I set the hourly cost to be base salary plus calculation of hourly overhead
Let's say this is $40. The overhead pool is $200. Revenue = 1000. Pct to allocate = 10%
Allocated Amount - Labor Cost - Misc Cost = amount to allocate>> 20 - 40 - 0 = -20
So in the Client P&L>>Revenue - Expenses - Overhead = Profit>> 1000 - 40 labor cost - (-20) overhead allocation = $980
As you can see, in either case, the profit is the same. and it appears that your loaded hourly cost is a bit overstated as the system needed to put in a negative allocation to bring it back to the "true" $20 of overhead. This is why you can use a base or loaded hourly cost on the employee record, as in either case, the system will take it into account. You just need to be consistent across all employees so the calculations will remain true.
Reports
All reports are located under Menu > Everyone > Report Center > Financial Reports.
Overhead Allocations Detail
This report is designed to show you all the transactions that make up the Overhead "pool" based on the date range supplied. This is a very useful report and should be run at least once a month to see if there are any transaction in here that should have been billed to a client.
Client P and L (Detail) (Multi)
This shows you the client level numbers of profitability based on data entered against the client or client projects listed
Project P and L (Detail) (Multi)
This shows you the project level numbers of profitability based on data entered against the projects listed.
Other
Project Dashboard
While there are the above reports, you can give your account managers access to the Project Dashboard which will calculate the profitability using the same methods.
Advanced Reporting
To get a 1=1 match of the total from the Allocated Overhead Detail report and the Client P&L Multi or Project P&L Multi for the same date range, you will need to add the following fields and alternatively make a calculated column for a total of all three fields. NOTE: The Project P&L only shows project-related transactions. The transaction associated with a client but not a project will not be shown.
Overhead Allocation Detail report = Field Names in PnL Multi reports.
- Total for Cost of Goods Sold = [Allocated COGS]
- Total for Expense = [Overhead Allocation] + [Inside Misc Cost] + [Inside Labor Cost]
- Total for Other Expense = [Other Expense Allocated]
- Grand Total = [Allocated COGS] + [Overhead Allocation] + [Inside Misc Cost] + [Inside Labor Cost] + [Other Expense Allocated]
NOTE: When allocating by hours, you must have actual hours entered on the project(s) within the desired date range to see an allocation amount appear.
Non-Billable Projects
If a transaction is linked to a non-billable project, but the client of the project is a billable client, then the transaction on the project is flagged as non-billable, however, the costs go against that project and client and do NOT go into the overhead "pool".
Multiple GL Companies
If you are one company and do not have GL Companies enabled, then ignore this section. However if you have Multiple GL Companies enabled, then you MUST select a GL Company for every transaction you enter. So while the GL Company of the transaction can be determined by the project, in the case of overhead, you are generally not choosing a project, which means you must enter the GL Company in the header of the transaction being entered. In many areas of Workamajig reporting, you can filter by No GL Company to catch any transaction that may have slipped through your process that needs to be corrected.