How do I reconcile my Genesys Cloud Voice invoice when the billing detail file is too large for Excel?

If your Genesys Cloud Voice billing detail file is too large for Excel, there are several alternative methods that you can use to reconcile your invoice.

Excel file size limitations

Genesys Cloud Voice billing detail files, also known as Telco usage reports or Call Detail Records (CDRs) can be extremely large, often containing millions of rows. Excel supports a maximum of 1,048,576 rows. If your billing detail file exceeds this limit, Excel truncates the data. When that happens, not all records are visible or included in your analysis.

Any reconciliation or analysis performed in Excel on truncated data is incomplete and results in discrepancies when compared with your actual invoice.

Alternative methods for handling large billing detail files

To accurately reconcile your invoice when your billing detail file is too large for Excel, consider using one of these alternative methods for handling large datasets:

1. Database systems
   Import the file into a database such as Microsoft SQL Server, PostgreSQL, or MySQL for efficient querying and analysis.
2. Data visualization tools
   Use platforms like Microsoft Power BI, Tableau, or other analytics tools that support large datasets and offer advanced filtering and visualization capabilities.
3. Text editors 
   Tools like Notepad++ or UltraEdit can open large files but only for viewing. They are not suitable for calculations or analysis.
4. File-splitting tools
   Tools like HJSplit or GSplit can break the file into smaller pieces. You can then analyze each piece separately or load them incrementally into your preferred tool.

For more information, see Reconcile your Genesys Cloud Voice invoice against your usage report.