Prove Out Revenue Method W

You can prove out Revenue Method W for a set of projects. Revenue Method W = JTD Billings + WIP @ Billing.

To prove out revenue method W:

  1. Review the projects to use for this proving out procedure. Be sure that each project has its revenue method set to W, that all of its data is up-to-date, and that all related transactions have been posted.
  2. Run revenue generation with these projects selected.
  3. Post the Revenue Generation file.
  4. Generate the Office Earnings report for the projects and make a note of the job-to-date billed amount for each project. Alternative: To get more detailed data, run the AR Ledger report. Make a note of the total billed amount for each project. This amount is not the same as the job-to-date billed amount on the Office Earnings report if you selected the Enable Option to Update BTD for Journal Entries to Revenue option (General tab of Settings > Accounting > System) and any journal entry transactions were posted to the project.
  5. Generate the Unbilled Detail report at billing rates for the projects. On the report, mark the Work in Progress (WIP) amount for each project. The Work in Progress (WIP) at Billing part of the revenue calculation:
    • Does not use data for billable items with a status of Held. To match this part of the revenue calculation to the amount on the Unbilled Detail report, you must generate the report without Held items.
    • Uses multipliers that are specified in Billing Terms for add-ons. The Unbilled Detail report data does not show data for add-ons.

    Each project's revenue should be the same as the sum of the amounts from Steps 3 and Step 4.