New tool
VoIP CDR Excel Macro for Monthly Billing
We built a macro that automates the boring work on your monthly VoIP CDR reports: formatting, sorting, calculations, and cleanup. Open your CDR in Excel, run the macro, and you are done.
Faster Billing
Automates repetitive Excel work on CDRs so you can invoice quicker.
Consistent Results
Same output every month: less human error, less manual formula drama.
Custom Tweaks
If your format differs, tell us what you need and we will adjust it.
How to activate and run the macro (Step-by-step)
- Download the macro file and the readme using the buttons above.
- Open your CDR report in Excel (the monthly report you want to process).
- Enable the Developer tab (one-time setup):
• Click File → Options• Click Customize Ribbon• Tick Developer on the right-hand side• Click OK
- Open the VBA Editor: press ALT + F11
If nothing happens, try holding FN and then press F11.
- Open the Project Explorer: press CTRL + R
You should see a panel listing open workbooks. Select your CDR workbook (the one you opened in step 2).
- Add a new module to your CDR workbook:
• In the Project Explorer, click your CDR workbook• Click Insert → Module
- Paste the macro code:
• Open the macro file you downloaded• Copy all the code• Paste it into the new module window in Excel
- Save the file as a macro-enabled workbook:
• Click File → Save As• Choose Excel Macro-Enabled Workbook (*.xlsm)• Save
- Close the VBA Editor: press ALT + F11 again.
- Run the macro: press ALT + F8, select the macro name, then click Run.
If Excel asks you to Enable Macros, click Enable.
If your CDR layout differs (columns, headings, totals, or currency format), we can tweak the macro for you. Contact us via the Client Portal and include an example CDR file (or screenshot) plus what output you want.
Need help getting it running? Log a ticket and we will guide you.
Go to PortaliTEAM • Tools that save you time every month
Friday, January 9, 2026