Child pages
  • Displaying time billing work in progress on reports

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

This information applies to MYOB AccountRight version 19. For later versions, see our help centre.


 

 

ANSWER ID:9329

AccountRight records work in progress but does not automatically adjust your accounts to reflect the value of any work in progress. Rather, AccountRight waits until the work is billed before making accounting entries.

This support note has a workaround to show your work in progress in financial reports. This is achieved by setting up an income and an accrual account, then posting your work in progress to these accounts each month.

You should check with your accounting advisor about the suitability of this workaround for your needs.

 

To show work in progress on reports
  1. Create a new Income account called 'Work In Progress - Income'. To do this: Go to the Accounts command centre and click Accounts List then click New. Here's our example:
    Image
  2. Create a new Asset account called 'Work In Progress - Accrual'. Here's our example:
    Image
  3. At the end of every month, run the Activity Slip Detail report (Reports > Index to Reports > Time Billing > Activity Slip Detail).
    • In the report filters, select a date in the From field that will include all open activities.
    • Enter the last day of the current month as the To field.
    • The grand total of the Balance column is your month end work in progress amount. Here's our example:
      Image
  4. At the end of the current month, create a general journal entry for the value of the work in progress amount (as determined in the previous step).
    • Credit the Work in Progress - Income account
    • Debit the Work in Progress - Accrual account. Here's our example:
      Image
  5. On the first day of the following month, create a general journal entry for the value of the work in progress amount. This transaction will clear out the prior month's work in progress amounts. If you don't enter this reversing entry, the work in progress will be double counted when entering this month's work in progress amount in to the general ledger.
    • Credit the Work in Progress - Accrual account
    • Debit the Work in Progress - Income account
      Image

Save time!

Save these general journal entries as recurring transactions. You can then use these recurring transactions each month and only the amounts will need to be changed. For help with recurring transactions, see the AccountRight help (Australia | New Zealand).