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

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.

 

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. Here's our example:
    Example work in progress income accountImage Modified
  2. Create a new Asset account called 'Work In Progress - Accrual'. Here's our example:
    Example work in progress asset accountImage Modified
  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:
      Example activity slip detail reportImage Modified
  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:
      Journal entry crediting the income account and debiting the asset accountImage Modified
  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
      Journal entry debiting the income account and crediting the asset accountImage Modified
UI Text Box
typetip

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).

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)