Billing Worksheets: Generate
In this step, the accounting department generates the billing worksheets. These worksheets are broken up depending on how you have set up the system. On each client, you can specify how invoices should be grouped (One per project, client, division, product, parent client) as well as other default options. Each project is identified by how it should be billed (Time and Materials, Fixed-Fee or Retainers). These two components tell the system how to generate a billing worksheet. If you have specified an invoice grouping option other than One per Project, the system will create a separate worksheet for each project and one master billing worksheet that ties the detailed worksheets together for one invoice. During the generation process, the system determines what should be billed or marked as billed based on the project settings. When the billing worksheet is generated, it is assigned to the project's Account Executive for review.
Steps to Generate Billing Worksheets
From Menu>Billing>Today-Billing: top left corner, click on +Generate icon
This will bring you to the search screen. Select the appropriate filter options:
Through Date: include transaction dates on or prior to date selected
Review Date: date when approval of worksheet will be considered late and notifications sent
Through date looks at: Invoice Date or Posting Date NOTE: for transactions that do not have a posting/invoice date the transaction date will be used. Ex. Misc Cost, Expense Reports, Purchase Orders.
Production Transactions: select the appropriate categories to be included in billing
- Time
- Expenses: includes Vendor Invoices, Misc Costs, Expense Reports converted to Vendor Invoices.
- Expense Reports
- Purchase Orders
- Include T&M Zero Amounts: for time & materials projects>if the transaction has Gross = 0, or if there are no transactions on the project, include in worksheet.
- Mark T&M Zero As Billed: for time & materials projects>when generating worksheets, mark transactions with Gross = 0 as "Mark As Billed"
- Include FF Zero Unbilled: for Fixed Fee projects> if there are no transactions on the project, include in worksheet
- Open Orders Only
Media Transactions: select appropriate media order types. Vendor invoices will be part of the above Expenses selection.
- Insertion Orders
- Broadcast Orders
Project Options: select appropriate filters to limit worksheet results. Typically all are left set to ALL.
Once selections are made, click on Search at top of page
This will then display a list of all projects, etc, that fit the selected search parameters.
The screen is divided into 5 possible tabs based upon the project Billing settings
- Time & Materials = Projects set to Billing Method: Time & Materials
- Fixed Fee = Projects set to Billing Method: Fixed Fee
- Campaign = Campaign set to Bill By Campaign
- Campaigns Fixed Fee = Campaign set to Bill By Campaign + Bill Campaign Budget checked
- Retainer = only Retainer name is displayed. Projects set to Billing Method: Retainer
check the box to the left of each line or the select all box at the top of the grid
Once all selections have been made, click Generate
When you return to the Today-Billing screen, you will see Worksheets In Review with the number of worksheets that have been created or are currently in this status.
NOTE: When Billing by Campaigns. The Unbilled Amount is calculated differently on Fixed Fee versus Time and Material Projects.
- Fixed Fee Project: Unbilled Amount is calculated as Budget Amount - Invoiced Amount.
- Time and Material Project: Unbilled Amount is calculated as Unbilled Amount.