Campaign profit & loss (multi view) [report]
Similar to the Project profit & loss (multi view) [report], however the data is rolled up to one line per Campaign. Shows profitability across multiple campaigns with the ability to allocate overhead from the GL.
NOTE: Due to the amount of data this report can pull, it may take time for the report to fully run.
How it works
The Profitability By Campaign report is different from the Company Profitability reports in that it includes an overhead allocation from the GL. It is based upon posted GL transactions and is not intended to tie to the budget analysis reports which are based upon actual transactions. The overhead allocation includes any transactions entered against expense accounts that are not associated with a client. Any entry tied to a client specified as an overhead client will be included in the overhead calculation and these clients will not show up in the profitability reporting. The percentage of overhead can be allocated using one of four methods.
- Labor Hours - This is the total approved hours on time sheets charged to the client or project divided by the total approved hours for the date range.
- Labor Cost - This is the total approved hours * standard cost charged to the client or project divided by the total approved hours * standard cost for the date range.
- Total Billing - This is the total of all revenue posted for the client divided by the all revenue in the date range
- No Allocation - This would still show the standard labor costs and inside costs, but would not have a bottom overhead number.
NOTE - GL Company Considerations: If a specific GL company is NOT selected prior to running the Campaign P&L report, 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.
Campaign calculations
- Revenue - Revenue billed on Projects
- Campaign Revenue - Revenue billed on the Campaign when no project is on the line
- Total Revenue - (Project) Revenue + Campaign Revenue
- Allocated COGS - Determines an allocated amount of any expenses not tied to a client or tied to an overhead client.
- Direct COGS - Direct COGS includes all of the vendor invoices and looks at the project on the invoice line. It also adds in any payments coded directly to the client or project and prebill accruals. This is only for expenses coded to COGS type accounts.
- Agency Gross Income - (Project) Revenue - Allocated COGS - Direct COGS
- Campaign Agency Gross Income - Campaign Revenue - Allocated COGS - COGS Direct
- Total Agency Gross Income = (Project) Revenue + Campaign Revenue - Allocated COGS - Direct COGS
- Labor Hours - Total hours on approved time sheets
- Inside Labor Cost - Total Hours * standard cost
- Inside Misc Cost - Total net amount from Misc Costs and Approved Expense reports
- Total Inside Costs - Total Outside Other Expenses + Labor + Misc Costs + Overhead Allocation. This should tie to the Expenses section on the Profit and Loss Statement.
- Ordinary Income - (Project) AGI - Total Inside Costs
- Campaign Ordinary Income - Campaign AGI - Total Inside Costs
- Total Ordinary Income - (Project) Ordinary Income + Campaign Ordinary Income
- Overhead Allocation - This is the allocated portion of all expenses coded to Expense type accounts that are not coded to a billable client less the Inside Labor Costs and Inside Expense Costs
- Net profit - (Project) AGI - Other Expense Allocated - Total Inside Costs + Other Income
- Campaign Net profit - Campaign AGI - Other Expense Allocated - Total Inside Costs + Other Income
- Total Net Profit - Campaign AGI + Project AGI - Other Expense Allocated - Total Inside Costs + Other Income