Split Billing is used to generate a percentage split invoice for multiple clients from a single project
based invoice. This is often used when advertising costs will be shared between a number clients.
The costs will be tracked via a project setup for the "main" client. When an invoice is generated for
the project, Workamajig will automatically generate a master "tracking" invoice plus individual
invoices for each designated client split. Each invoice is tracked separately in Account Receivables
towards the designated client, however each split invoice is connected back to the master.
Menu > Admin > System Setup > Account Information > Transaction Preferences > Client
Invoice Setup > Enable Split Billing
Once selected, a new field will be available in the Project:Setup:Accounting area to setup the splits.
Project Setup: Accounting>Split Billing
Click on the Split Billing
Enter the Client and Percentage of the Total Invoice each client will pay.
NOTE: The percentages entered must total 100%. Be aware that the more splits you enter, the
chances of a rounding value being applied to one split is increased.
The billing method used for creating split billing invoices can be Billing Worksheets, Mass Billing
or from the Project. For Billing Worksheets and Mass Billing, the setting must be One Invoice Per
Project in order to create a split billing for the project. NOTE: Split Billing will not work for projects
set to Billing Method: Retainer, as Retainer billing is technically not controlled by the project.
If you are billing by Campaign, and the campaign is set to bill by project, split billing will only occur
for projects that have been setup with split billing.
The splits are not displayed on the Worksheet. Once the invoice is created, the project setting for the
Split Billing will be applied to the generated invoices.
Below is an example of a Billing Worksheet to demonstrate the splits. We will use the project SBS-
001 with the given splits of 20, 40, 35 and 5, as seen above.
The project has $1000 to bill. Following the standard workflow, the worksheet is approved.
and an invoice is generated.
This action has now created 5 invoices in the system: 1 Master Invoice and 4 Split Invoices.
NOTE: the $0 invoice for Bob Co is the master invoice. There are no invoice numbers as the invoices
have not been approved yet.
Once the invoices are approved and posted, you will see
The line will show the detail of all of the transactions.
The Splits tab will show the Splits/Split Invoices, along with the percentage and $ amount of each
If you double click on one of the split invoice lines, it will open that specific invoice.
NOTE: The Split invoice will only show the connection to the receipt, credits or Advance Billing. All Line Transaction detail is contained in the Master Invoice.
Adjusting the amount billed
If the $ value of the invoice needs to be adjusted, this must be done on the Master Invoice. Once the
total amount of the master is changed, this will cascade to the split invoices. It does not matter if the
split invoices are posted or not, the value of each split will be auto adjusted.
In this case a new line for $2000 was added to the Master:
The Split invoices were updated with the new $ values.
Tracking And Reporting
All invoice must be posted.
The Master will have no posting information. All posting information is contained in the splits.
Below is an example of one of the splits.
Each split will have the split amount that is pointing to the designated Account Receivable GL
account and the lines will point to the Sales account(s) designated by the transactions contained on
the Master invoice.
NOTE: The line information will be associated with the Project as designated on the Master invoice.
Because the individual split invoices are what will be tracked to AR Aging, only the splits will be
visible in this report. As each split client pays their split invoice, the invoice will be removed from the
AR Aging report, just like any other normal invoice. The Master Invoice will not appear on this report.
Because the Master is associated with a specific project, the Sales and Expenses are tracked to the
This is seen as the $2200 in Total Revenue and $1000 in Expenses and defined by billing worksheet
example from above.
This is a bit different. The expenses are associated with the Master invoice/Project but the revenue is
associated with the split invoices. Because of this, the Client P&L may appear a bit confusing:
Master Invoice/Project Client: Client P&L
In our example, the project is associated with Bob Co. So the Expense of $1000 is associated to Bob
Co. However, Bob Co is only associated with a 20% split, so the revenue associated with Bob Co is
only $600 of the total $2200.
Split Invoice: Client P&L
As the Expenses are tracked through the project, the split client invoice will only show Revenue.
In this example, the Split Client was only accountable for 5% or $150 of the total $2200.