Hero Banner

Reseller Discussions

The Cloud Solution Provider program puts the partner in the center of the customer relationship – learn more

Visitor 1

How to match dates in Reconciliation files to Invoices?

I can match our monthly CSP invoice and reconciliation files fine. Now I want to concatenate all the reconciliation files so we can do various analysis and reporting activities (using Power BI)

Our September invoice for example shows the following billing period (international format): 28/8/2018 - 27/9/2018

However in the merged reconciliation file, I can't figure out how to find the records that match that billing period.

Here are the range of date values in the September reconciliation file (dd-mm-yyyy):

Field                                       Oldest             Newest
SubscriptionStartDate           02/07/2018     28/09/2018
SubscriptionEndDate            02/07/2019     28/09/2019
ChargeStartDate                    31/07/2018    28/09/2018
ChargeEndDate                     31/07/2018     27/10/2018

If I merge all my reconciliation files, is there a date search I can do that will return a set of records to match a specific MS invoice?