Background
There will often be times when you have entered activity slips for work you've performed for your clients, for which you have not yet billed them at the end of the month. In an accrual accounting system, you have earned income when the task is performed or the goods are delivered, even if you have not billed your client or received payment.
You will need to go through a few different steps to be able to track this.
Create Accounts
Create two new accounts in your accounts list: an income account called "Work in Progress - Income" and an asset account called "Work in Progress - Accrued"
To do this:
Go to the Accounts module
Click on the Accounts List button
Click on the New button
Set the Account as a Detail Account
Set the Account Type as Income
Type in an Account Number that hasn't been used and hit tab
Type in the Account Name Work in Progress - Income
Hit okay.
Click on the New button
Set the Account as a Detail Account
Set the Account Type as Other Asset
Type in an Account Number that hasn't been used and hit tab
Type in the Account Name Work in Progress - Accrued
Hit okay
Print Reports
At the end of every month, print an Activity Slip [Activity Summary] Report.
To do this:
Go to Reports from the menu bar at the top of the screen
Click on Index to Reports from the drop-down menu
Click on the Time Billing tab
Select the Activity Slip summary report and hit Customize
Using report customizations, be sure to include all activities on the report and enter the dates of the first and last day of the current month in the 'Dated From' and 'Date To' fields.
Print the report with this information, the total in the Balance $ column is your month-end Work in Progress amount.
Create Journal Entry
Create a general journal entry to enter the value of this month's work in progress in your books:
Go to the Accounts module
Click on the Record Journal Entry Button
Enter the date of the last day of the current month in the Date field
Enter the month-end work in progress amount from the report you printed in step 2 as a credit to the Work in Progress - Income account
On the next line, balance the transaction by entering the same amount as a debit to the Work in Progress - Accrued account
Click record
This entry increases your income on your profit & loss statement and increases the value of your assets on your balance sheet to reflect the month-end value of your work in progress.
Hint: Save the WIP general journal entry as a recurring transaction by clicking on the action button from the bottom left of the journal entry screen - that way you can use this each month.
Reverse the Journal Entry
At the beginning of the next month:
Go to Setup from the menu bar at the top of the screen
Choose Preferences from the drop-down menu
Click the Security tab
Make sure there is a check mark in the box that reads Transactions CAN'T be Changed, They Must be Reversed [System-Wide]. Click OK.
Go to the Accounts module
Click on the Transaction Journal button
Click on the arrow next to the month-end journal entry
Select Edit from the menu bar at the top of the screen
Choose Reverse General Journal Entry from the drop-down menu
Enter the date of the first day of the current month in the Date field
Click Record
If you would like to turn off the preference to make it so that you can change transactions - go back to Setup > Preferences from the menu bar at the top of the screen and click on the Security tab. Uncheck the first box.