Pro-rata WIP entry method

https://help.myob.com/wiki/x/YTCEAQ

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0

1

2

3

4

5

Very dissatisfied

Very satisfied

Why did you give this rating?

It's hard to find information

Instructions are hard to follow

Content isn't detailed enough

It doesn't fix my software problems

Anything else you want to tell us about the help?

Practice Manager only

The pro-rata method allocates amounts against WIP entries, based on the percentage of the total WIP balance that the bill amount represents. This method is ideal if you are clearing the WIP balance totally.

This is illustrated in the table below where the bill amount is $1,000 and the total WIP is $1,500. Each WIP entry balance is reduced by two-thirds leaving one-third as the WIP entry balance.

The pro-rata method spreads a write-off across all employees who worked on the (AE) assignment / (AO) job.

Date	Employee	Amount	Allocation	WIP Entry Balance
30-11-08	Tom	150.00	66.67	33.33
01-12-08	Dick	200.00	133.33	66.67
02-12-08	Harry	300.00	200.00	100.00
03-12-08	Tom	400.00	266.67	133.33
04-12-08	Dick	500.00	333.33	166.67
04-12-08	INVOICE 122	-1,000.00

Bill		1,000.00
Write off		0.00
Total WIP		1,500.00
Proportion		.67
Closing WIP		500.00

Advantages

The major advantage of using the pro-rata method is in measuring employee recoverability. If at the end of an assignment/job, 10% is written off, all employees will proportionately have 10% written off against their WIP contribution. Whereas, if the practice was billing at the assignment/job level and using the FIFO method, the employees who worked on the assignment/job last would have the write-off allocated against their entries.

Disadvantages

A disadvantage of using the pro-rata method is where the practice is partially billing a client on a regular basis. The table above illustrates this where two additional WIP entries have been input and a new bill is raised for $1,125. As the WIP is being carried forward at the time of billing, the pro-rata allocation reduces each WIP entry balance by 75% (that is, $1125/$1500). This results in the previous partially billed WIP entries having a balance and still needing to either be billed or written off (on) in a future period.

Related topics

FIFO WIP entry method

Entering write ups/write offs

Stage Two—Add bill amounts

Page tree

Was this information helpful?

Why not?

How would you improve this page?

Thanks! Anything you'd like to add?

Overview

Using Practice Manager

Clients and contacts

Employees

Suppliers

Assignments (AE)

Timesheets, disbursements
and expenses

Billing

Debtors

Bookkeeping

Other topics