Issue/Symptom/Question

The Earned YTD balance doesn't match the Sales Acct Balance YTD on the WIP Subledger, why?

Applies To

WIP Subledger

Resolution/Fix/Answer

The Earned Amount YTD on the WIP Subledger is not the same as Sales Acct Balance YTD (or current period since that is the first period in the example above), because of the Status.

If the Job/WO/MC is in a complete/delete status, the rev rec process excludes recognizing (aka Earning) revenue for them. If after the rev rec date the Job/WO/MC is activated and an additional billing is made and posted back to the first rev rec date, the Sales Acct Balance is updated. The Earned and Sales Acct Balance will sync up in the following periods rev rec when the Job/WO/MC is marked complete again.

To prevent, when activating a complete/delete Job/WO/MC to enter billing changes, use the same date for the Active entry as the Posting Date entry of the billings.

For other reasons why the Earned Supporting reports might not match the general ledger balance, see: WIP Subledger Report Does Not Match OU Balance from Account Balance Query

Browser not supported