cancel
Showing results for 
Search instead for 
Did you mean: 
rabia.ben
Level 2

WIP tracking & accounting

We have multiple fee earners who bill time to a file each at his/her hourly rate.

 

The invoice with the fees earned by all fee earners may take 2-3 months before it can be sent out

 

In the interim, we need to recognize the fees (based on time billed and an hourly rate per employee) as sales or WIP.  Then once the file is done, that amount will be adjusted and turned into an actual invoice to send out to the client to be paid.

 

Currently, once we enter time against a job (project) that times sit idle not appearing anywhere until it is turned to an invoice at which time, it becomes sales.  This is creating incorrect financial reports as the sales only appear at the time of the invoice which maybe 2-9 months after the work is done. 

 

How do we track WIP and recognize it as sales, until it is then invoiced, and becomes an AR?

3 Comments 3
john-pero
Community Champion

WIP tracking & accounting

Do you presently work from Estimates? If not it is something to , along with Progress Billing (or Invoicing).

 

Even under accrual accounting, you would not be able to record the income, and thus any effect on financials without creating invoices along the way.  Is there any reason why you cannot issue monthly or even weekly invoices for work performed to that point?

 

You certainly can use WIP accounting to be able to review work performed to date and not yet billed.

Because it is not yet billed it cannot affect your P&L......yet. But once you convert any part of the WIP current asset into billed service it can (under accrual) become income.

 

There can be two parts to a WIP, one is the asset value you create by paying your employees. It can be an unbilled service item or even a physical product not yet complete.  The other part is if you receive money towards an ongoing project, this WIP is a current liability. Thus you could have two corresponding WIP accounts, one asset and one liability, and once complete and all dust settles, the WIP liability applied against the WIP asset should result in your (hopefully) profit on the job.

rabia.ben
Level 2

WIP tracking & accounting

Dear John,

 

Thank you for your answer.

Can you please share with me the steps of use WIP accounting to be able to review work performed to date and not yet billed?

I have created two accounts WIP Asset & WIP Liability, and when I run the P&L for a project a zero balance is showing, there must be a missing thing that I could not figure out.

 

Thanks  for your help in advance & best regards,

 

 

rabia.ben
Level 2

WIP tracking & accounting

Dear John,

 

Thank you for your answer.

 

This issue is not solved yet, as I have tried to use WIP accounting to be able to review work performed to date and not yet billed but did not work.

When I run a P&L report for a specific project a ZERO balance is showing, although two accounts were created (WIP Asset & WIP Current Liability), there must be a missing thing that I could not figure out.

Can you please share with me the process of tracking WIP from A to Z, please?

 

Thanks again and best regards, 

Need to get in touch?

Contact us