Billing Worksheets: Overview
Your current billing workflow may consist of printing reports that provide budget, transactions and prior billing amounts, then going over these with the AE/PM to decide what to bill during the current period. Others may be creating invoices and sending these to the project AE/PM for approval which may trigger rounds of deletes/adjustments/reprints before arriving at the final invoice to send to the client. Workamajig provides a billing workflow that can be adjusted to best fit your team's needs with the end result being a "printed once" invoice for your client. Billing Worksheets allow you to route project transactions and information to the AE/PM for feedback and approval prior to creating the invoice or use it as an action list management for the billing period. The AE/PM is able to control when projects are available for a billing cycle, how projects are billed and invoices layouts at the project level and client level, to provide a smoother billing cycle and decrease instances of lost income due to tracking the billing cycle outside of Workamajig.
A typical billing cycle would be for the Billing Dept to generate Worksheets. The worksheet will be directed to a specific person, usually the AE. Whether billing transactions or a percent of budget, the worksheet provides all of the project information along with transactions and prior billings to evaluate what to do in the current cycle. Once completed, the AE will submit the Worksheet for approval, where it can be evaluated/edited/approved and thus an invoice created based upon client needs. The worksheet will allow the team to mark up/down, transfer, mark as billed, or write off transactions. These will not be committed to the system until the Worksheet is approved and invoice created.
Since the billing worksheet workflow may be new to your team, we recommend that you try a small run of invoices or with a specific Account Executive first. This will allow you to identify specific workflow needs and any areas that need adjusting prior to release to the entire team.
Contents
Setup
Client Level Settings
The client record allows you to setup a default billing method, invoice style and invoice printing layout. These can be adjusted on the individual projects and during the billing cycle. The purpose is the AE can setup defaults based upon client needs that will then flow into the project and through to invoicing.
Billing Method: This defines how a billing worksheet will be generated
Fixed Fee: billing is based upon percentage of budget. You can define if expenses are included or not included in the budget percentage for billing.
Time & Materials: billing is based upon project transactions
Retainer: billing is based upon a predefined retainer. This is typically not setup at the client level
Invoice Style: This defines how the client invoice and invoice lines are created
One Invoice Per-
Project - Each project will generate one billing worksheet leading to one client invoice for each project
Client - Each project will generate one billing worksheet plus one "Master" worksheet used for grouping all worksheets together leading to one client invoice for each client
Parent Client- Each project will generate one billing worksheet plus one "Master" worksheet used for grouping all worksheets together leading to one invoice for the Parent client.
Division - Each project will generate one billing worksheet plus one "Master" worksheet used for grouping all worksheets together leading to one invoice for the client division.
Product - Each project will generate one billing worksheet plus one "Master" worksheet used for grouping all worksheets together leading to one invoice for the client project.
Campaign - Each project will generate one billing worksheet plus one "Master" worksheet used for grouping all worksheets together leading to one invoice for the client Campaign.
Invoice Layout / Template: this defines the how the client invoice will print
Project Level Settings
Though defaulted in via the client record, an individual project can be setup with a different billing method and invoice printing layout based upon the specific needs of the project.
Billing Schedule: each project can be setup with a billing schedule that allow the AE/PM to define when a Fixed Fee project will be available for billing or if a revenue or advance bill invoice is created. For a T&M project the timing of an Advance Bill invoice can be created.
Campaign Level Settings
Typically the project defines the billing method and the client record defines the invoice style and invoice printing. However, the campaign may allow you to override the client settings and group things by campaign or bill using the campaign estimate.
Bill By: The following defines how worksheets will be created if connected to a campaign
Campaign Fixed-Fee (Based on the Campaign set to Bill Campaign with Bill Campaign Budget checked):
Projects Connected to Campaign: This will will create a Fixed-Fee worksheet for the Campaign budget and one worksheet for each project. If Projects are linked to the Campaign, there will be a Master worksheet. The Campaign will generate a Fixed Fee worksheet, and each project will generate one billing worksheet . A "Master" worksheet will be added for grouping all worksheets together leading to one client invoice for each client.
No Projects Connected to Campaign: This will create a single Fixed-Fee worksheet.
Campaign Project (Based on the Campaign set to Bill By Project): This setting will not create a Master Worksheet, unless Client is set to One Invoice Per Client or Campaign.
Campaign Campaign (Based on the Campaign set to Bill Campaign with Bill Campaign Budget unchecked): This setting will create a Master Worksheet, individual worksheets will be based upon project setting.
Worksheet Types
Once worksheets are generated, you may see the following labels associated with the worksheet:
Master - This is used for grouping together individual worksheet to generate a single client invoice. This will be generated based upon the setup from the Client record>Billing>Defaults: One Invoice Per = Client | Parent Client | Division | Product | Campaign.
Fixed Fee - generated when project billing method = Fixed Fee or Campaign billing method = Bill by Campaign plus Bill Campaign Budget checked.
Time and Materials - generated when project billing method = Time and Materials
Retainer - generated when retainer is created in system. If retainer has extras, the projects will create a Time and Materials worksheet and potentially a Master worksheet depending on retainer settings.
NOTE: For a campaign set to Bill By: Project, the projects will generate worksheets based on the billing method of the individual projects.
The Unbilled Amount is calculated differently on Fixed Fee versus Time and Material Projects.
- Fixed Fee Project: the Unbilled Amount is calculated as Budget Amount - Invoiced Amount.
- Time and Material Project: the Unbilled Amount is calculated as Unbilled Amount.
- Campaign Budget: the Unbilled Amount is calculated as Campaign Budget Amount - Invoiced Amount.
Workflow
Our integrated billing process allows you to complete the review process faster and with fewer mistakes and missed billing opportunities. The billing process goes through the following steps.
1. Generate Billing Worksheets
- Typically the accounting department (has the security right to Create and Edit Client Invoices) would be the ones to generate Billing Worksheets.
- Only one active Worksheet can be open for each project or campaign.
- Worksheets are sent for review to the Account Manager designated on each project or campaign. If generated, a master worksheet is sent to the Account Manager defined on the client record or Campaign.
2. Review Billing Worksheets
- Worksheets that are sent for review will appear in each user's My Items To Approve Widget.
- Based on security rights, the review might only have the ability to Add Comments vs. Editing Transactions.
- There are a variety of options when editing transactions via the Form Actions menu.
- Reviewers can also see the project snapshot, which includes the overall budget and profitability.
- Once a reviewer is done commenting or making changes, they Send For Approval.
3. Approve Billing Worksheets
- Any person with the right to Create and Edit Client Invoices can approve a billing worksheet. Or just the Billing Manager set on the client/project.
- Approvers have access to the same screens as in the review process. With the additional option to Reject or Approve.
- Once a worksheet has been approved an invoice can be created.
4. Create Invoices From Worksheets
- This step shows all worksheets that have been Approved and are ready to be turned into client invoices.
- Select the worksheets and create client invoices. The line format and other settings are controlled by the client setup or campaign.
- Afterward, you then move on to the processes of reviewing and approving client invoices that were generated, sending the invoice to the client and posting them to the GL to run your financial reports.
Items For Consideration
A project or campaign can provides additional settings to determine how the project or campaign is to be billed.
Billing Method
The Billing Method is usually defined on the client record. However, once created, the project or campaign can be adjusted to fit the needs of that specific project/campaign agreement. From the Project Settings>Billing Options or Campaign Settings>Billing: the billing method can be changed from the client default settings.
Billing Schedule
Typically used for Fixed Fee Project/Campaign billing, the billing schedule can be used to define the timing as to when a Billing Worksheet will be generated.
Keep in mind that a Billing Worksheet will NOT be available to Generate unless the defined date in the Billing Schedule has been met.
Fixed Fee Project: An entry can be tied to a Date (User Determined) or Task (Plan Complete Date) or Both (uses the earlier of the two dates). You can also designate a dollar amount or percentage of the budget to create the invoice for. The Billing Schedule can also designate if the invoice generated will be an Advance Bill Invoice or a Revenue invoice.
Fixed Fee Campaign: An entry can only be tied to a Date (User Determined). You can also designate a dollar amount or percentage of the campaign budget to create the invoice for. The Billing Schedule can also designate if the invoice generated will be an Advance Bill Invoice or a Revenue invoice.
Time and Materials Project: Only Used to create an Advanced Billing Invoice. An entry can be tied to a Date (User Determined) or Task (Plan Complete Date) or Both (uses the earlier of the two dates). You can designate a percentage of budget to create the Advance Billing invoice for.
NOTE: A normal Time and Materials worksheet will be available to generate anytime there are approved/unbilled transactions on the project. If you have approved/unbilled transactions and the billing schedule date is ready to create an Advance Bill Invoice, then you will see two worksheets to generate for the same project. The one listed under (Time and Material) is for the Approved/Unbilled transactions, and the one under (Fixed Fee/Time and Material with Advance Billing) is for the Advance Bill Invoice.
For clarity in your billing cycle, generate worksheets in the Fixed Fee/Time and Material with Advance Billing section first. Then select All for the remaining worksheets and generate.
Next Steps
- Generate Billing Worksheets
- Review Billing Worksheets
- Approve Billing Worksheets
- Create Invoices From Worksheets