Azure Billing - How to identify Checksum errors

Overview

The Checksum Error Identifier tool is an Excel file equipped with macros designed to facilitate the identification of errors during the checksum process in your Azure billing. This article provides step-by-step instructions on how to use this tool effectively. 

Prerequisites

1. Access to the Partner Center to obtain the required data files. (Reconciliation and the Daily Rated Usage file)
2. Microsoft Excel installed on your PC

Procedure

1. Log in to your Partner Center account and download the Reconciliation file and the Daily Rated Usage file. https://learn.microsoft.com/en-us/partner-center/read-your-bill
2. Download a copy of the Error Identifier tool: Here
3. In the Excel file, you will find multiple tabs, each corresponding to a specific type of data. The tabs are labeled according to the data they contain.
   1. Make sure to properly select and paste the data to avoid any malfunction 
      1. Go to the Excel file and click at the top left corner of the spreadsheet
      2. After all items gray out you can simply press Ctrl +C in your keyboard or right-click on them and copy the information.
4. For the Reconciliation file, locate the corresponding tab within the Excel file and paste the data from the Reconciliation file into the designated area.
   1. This is how it's usually named by MS
      
   2. Needs to be pasted inside this Tab
      
5. Similarly, for the Daily Rated Usage file, navigate to the relevant tab and paste the data from the Daily Rated Usage file into the designated area.
   1. This is how it's usualy named by MS
      
   2. Needs to be pased inside this Tab
      
6. After pasting the data, go to the 'Menu' tab locate and click on the "Start Process" button within the Excel file. This will initiate the checksum comparison process.
   
7. The tool will generate two pivot tables with filters to help you identify any differences between the Reconciliation file and the Daily Rated Usage file. These tables will highlight discrepancies will appear in the H Column, this will allow you to focus on areas that require further investigation.
   
8. Examine the generated pivot tables to identify errors the ones that could be discrepancies are marked in light red. 
9. Use the filters and sorting options within the pivot tables to isolate specific records or discrepancies for further review.
10. Once you've identified discrepancies, take appropriate action to resolve any billing errors or inconsistencies. This may involve adjustments, communication with relevant parties, or making necessary updates in your billing records

If you find some discrepancies don't hesitate to contact us at support@work365apps.com