Profit Worksheet Selection

Budget Area – Contracted Totals

The first parts of the Job Profit Worksheet are totals taken directly from Bid/Budget amounts A-K through the Contracted Total:

Click on the image to zoom in on it.

 

Accounting Activity – Income

From the accounting activities area, LAjit starts with reporting first on income starting with:

  • Production Income – Reports all billings to the Job and should tie to the Trial Balance (Income)
  • Overage Billing – Reports the difference between the Contracted Total and what was actually billed to the Job. This is a reference column parsed from the Production Income column
  • Other Income – Reports on all billings from Jobs who’s Sales are classified as Other Income on the Trial Balance
  • Total Income – summarizes the Production Income and Other Income

 

Accounting Activity – Production Expenses

Following the Accounting Production Income are the Production Expense Columns using the AICP Top Sheet Format starting with:

  • Production A-K
  • Production M-N
  • Production O-P
  • Production Other Expenses
  • Production Sub-total

 

Accounting Activity – Production Expenses

Next section of Production Expense covers and breaks down the below the line costs including:

  • Insurance – will pick up any line number classified as Insurance on the AICP Budget Format
  • Director Expenses – picks up all line numbers coded to category “L”
    • Directors Expenses can be broken out further:
      • Director/Creative Fees – line numbers must be classified as DIR/Creative Fees on the AICP Budget Format
      • DGA Fringes – line numbers must be classified as DGA Fringes on the AICP Budget Format
  • Cost Accruals – Free Fill column to enter cost not yet booked through accounting
  • Committed PO’s – picks up all open PO’s
  • Petty Cash – reports on line numbers classified as Petty Cash in the AICP Budget Format
  • Total Production – Calculates the Production Sub-Total, Insurance, Director Expense, Cost Accruals, and Committed PO’s. Your Total Production column should tie to your Trial Balance for Job Expenses.
    • Total Production breaks down further to the:
      • Accounting Actuals –  line numbers without account rollups set up in the AICP Budget Format
      • Accounting Other – line numbers that have account rollup over-rides set up in the AICP Budget Format
      • Accounting Actuals + Accounting Other = Total Production

 

Accounting Activity – Production Expenses

Next section after Total Production Expenses includes:

  • Gross Profit – Total Income minus Total Production plus; Sales Commissions and Director’s Profit
  • Budgeted Markup % – is calculated by dividing the Budgeted Markup column by the Budgeted A to K column
  • Budgeted Markup – is pulling from the Budget Software Upload
  • Under/(Over) Markup – calculated by the Gross Profit column minus the Budgeted Markup column
  • Sales Commissions – pulls from lines classified as Sales Commission in the AICP Budget Format
  • Adj Gross Profit – is calculated by Gross Profit column minus Sales Commission’s column
  • Director Profits – pulls from lines classified as Director Profit in the AICP Budget Format
  • Net Profit – is calculated by the Adj Gross Profit column minus the Director Profit column
  • Net Profit % – is calculated dividing the Net Profit column by the Total Income column

 

Accounting Activity – Production Expenses

The last section of Job Profit Worksheet report pulls from the Project Detail page under Job setup: