Testing a Revenue Method

You should consider testing a revenue method (either standard or user-defined) on a few projects before assigning the method to many projects.

It is easier to test a project's revenue if the project data is posted and you can view all elements of the formula. If you select Post revenue as it is generated (do not create transaction file) in Settings > Accounting > Revenue, DPS posts the Revenue Generation file immediately after you run Revenue Generation.

To test a revenue method, you should run Revenue Generation for the selected projects, and then:

  • Post the Revenue Generation file.
  • Run the appropriate report for the revenue method at the lowest level of work breakdown structure for your projects.
  • Review each project's revenue amount as it appears in the appropriate report location to confirm that it is consistent with your expectations.

If a project's reported revenue does not seem accurate:

  • Verify that all data used by the revenue method formula has been entered and posted for the project.
  • Modify the method's formula or specify a different Revenue Type for the project.
  • Repeat the test.

When you are certain that your revenue method is accruing revenue accurately, you can assign it to other projects.

Example

This is how you might test Revenue Method W: JTD Billings + WIP @ Billing.

  1. Decide which projects to use in your test.
    • Confirm that Method W is the revenue type for each of these projects.
    • Confirm that all project data is entered and all transactions posted.
  2. Run Revenue Generation with these projects selected, and post the Revenue Generation file.
  3. Run the Office Earnings Report for the projects and note the JTD Billed amount for each.

    For more detail, you can run the AR Ledger Report instead and note the Total Billed amount. This amount will not match the JTD Billed on the Office Earnings Report if you have Enable option to update BTD for journal entries to revenue selected in Settings > Accounting > Transactions and you have made journal entries for the project.

  4. Run the Unbilled Detail Report at billing rates for the projects and note the Work in Progress amount for each.
    DPS's calculation of WIP @ Billing:
    • Excludes held items. To match the WIP calculation to the amount on the Unbilled Detail Report, you must run the report without held items.
    • May include a multiplier from billing terms specified as an add-on. The Unbilled Detail report does not show add-ons.
  5. To determine each project's revenue, add the amount in Step 3 to the amount in Step 4.
Parent Topic: Revenue Generation