Child pages
  • Displaying time billing work in progress on reports

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

ANSWER ID:9329

ImageImage Removed

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

This support note provides a method that enables you to reflect has a workaround to show your work in progress in the meantime.

What is work in progress?

Work in progress are the activities that have been performed by a business that are yet to be billed. From an accounting perspective, this should be recognised in the financial statements at the end of the month, as the activities conducted should result in future cash flow.

How do I adjust my general ledger to reflect work in progress?

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.

 

UI Expand
expandedtrue
titleTo 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.
See
  1. Here's our example
Income account below.
  1. :
    Example work in progress income account setupImage Modified
 
  1. Create a new Asset account called 'Work In Progress - Accrual'.
See
  1. Here's our example
Asset account below.
  1. :
    Example work in progress asset account setupImage Modified
  2. At the end of every month, run the Activity
Slip [Activity Detail] report.
  1. Slip Detail report (Reports > Index to Reports > Time Billing > Activity Slip Detail).
    • In the report filters,
be sure to select
    •  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.
See
    • Here's our example
report below.
    • :
      Example activity slip detail reportImage Modified
Create a general journal entry at
  1. At the end of the current month
for
  1. , create a general journal entry for the value of the work in progress amount
. A credit should be applied to Work
  1. (as determined in the previous step).
    • Credit the Work in Progress - Income
and a debit should be applied to Work
    • account
    • Debit the Work in Progress - Accrual
. We have assumed the amount in this example is $1,470. Record the transaction. See our example transaction below.
ImageImage RemovedCreate a general journal entry for
    • account. Here's our example:
      Journal entry crediting the income account and debiting the asset accountImage Added
  1. On the first day of the following month
for
  1. , create a general journal entry for the value of the work in progress amount.
This transaction
  1. 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.
A credit should be applied to Work
    • Credit the Work in Progress - Accrual
and a debit should be applied to Work
    • account
    • Debit the Work in Progress - Income
. Record the transaction. See our example transaction below. ImageImage Removed
Hint: You may want to save the two general
    • account
      Journal entry debiting the income account and crediting the asset accountImage Added
UI Text Box
typetip

Save time!

Save these general journal entries as recurring transactions. You can then use

the

these recurring transactions

every month

each month and only the amounts will need to be changed.

Our support note Recurring transactions has more information on this

For help with recurring transactions, see the AccountRight help (Australia | New Zealand).

HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Billing for time (Australia)

Billing for time (New Zealand)

Recurring transactions (Australia)

Recurring transactions (New Zealand)