CSP Reconciliation in Dynamics 365 using Work 365

Work 365 is a Billing automation system.

One very important question we get very often from Finance and Account teams is how does Work 365 help with CSP reconciliation?

CSP Reconciliation is a very important accounting function and in the Microsoft CSP partner world, that means reconciling your customer billing with your invoices from Microsoft or your distributor.

The above video will show a brief demonstration of how you can use Work 365 from within your Dynamics 365 system to do some basic audits and review the data from a visual perspective to perform a high-level reconciliation.

This graphic above shows in one Work 365 Table :

  1. The customer selling price on the billing side (revenue)
  2. The cost of information from the provider (cost)
  3. The quantities in the billing system (revenue)
  4. The quantities from the Provider Invoice (cost)

Using this simple table/view it’s easy to visually spot any discrepancies. However just because the quantities don’t match it doesn’t indicate that there is an actual discrepancy. This can happen if there was a change made to a subscription after the provider invoice was received.

So the subscription count in the table may show the current subscription, however, the provider invoice will show the subscription count for when the bill was generated. Having the context and history of the subscription (through change License Change Logs) helps to further clarify any such reconciliation concerns.

Work 365 provides bi-directional sync between Partner Center and Work 365. If your system is healthy and functioning correctly every customer subscription in Partner Center will sync into Work 365 and Work 365 Subscriptions will sync with Partner Center.

Learn more- Watch our video webinars!