How to Run a Quarterly SaaS Cost Audit Without External Tools

SaaS costs can grow fast, especially when no one’s watching. Small things, like new apps quietly added over time and unused licenses left behind by former employees, can quickly rack up your spending.

However, the real challenge lies in finding a way to audit these expenses without adding another tool to your existing tech stack.

In this guide, we’ll show you how to run a quarterly audit of SaaS costs without the help of a dedicated SaaS management platform.

Running quarterly SaaS cost audits without specialized tools

Instead of investing in a new tool that would probably complicate your tech stack further, you can leverage your vendor dashboards and simple reporting tools to conduct quarterly SaaS cost audits. This method aligns well with lean SaaS cost management practices while maintaining audit consistency.

📌 Prerequisites 

• Access to SaaS admin dashboards such as Microsoft 365 Admin Center, Google Admin Console, Zoom, and Salesforce
• Quarterly billing statements or invoices from each SaaS vendor.
• Spreadsheet or a simple BI tool for consolidating data.
• Defined license policies and assignment documentation for reclaiming unused licenses.
• Alignment with finance or procurement teams for reconciliation and contract validation.

Step 1: Collect SaaS billing data

First, you need to establish a centralized view of all your SaaS-related expenses. This step will make cost tracking and optimization easier.

1. Log in to your vendor portals and download all invoices or billing reports.
2. Take note of license counts, unit costs, and renewal cycles.
3. Use Excel or Google Sheets to create a consolidated spreadsheet and organize your data based on:
   1. Vendor Name
   2. License Type
   3. Assigned/Unassigned Licenses
   4. Monthly Costs
   5. Renewal Date and Contract Owner

Step 2: Cross-check license assignments

Next, you need to check if all billed licenses are assigned and are being actively used.

1. Navigate to the admin console of your SaaS platforms and export current user license assignments.
   1. Here’s an example PowerShell script you can use to pull license data from Microsoft 365

Get-MsolUser -All | Where-Object {$_.isLicensed -eq $true} | Select DisplayName, Licenses

2. Compare the active licenses to your billing records.
3. Flag unassigned licenses for cleanup.
4. Document ownership for each license group to improve accountability.

Step 3: Identify redundancies and underutilization

In addition to unassigned licenses, you should also look for redundant tools and underused licenses.

1. Check if users have multiple licenses across similar SaaS apps (e.g., Teams and Zoom).
2. Review login and activity logs for inactive accounts.
3. Flag licenses that haven’t been used for >90 days as candidates for reassignment or removal.
4. Assess whether overlapping tools can be consolidated at renewal time.

Step 4: Create a quarterly SaaS cost audit report

Once you’ve gathered all the data you need, you can build an audit report summarizing all your findings. Clear reporting ensures SaaS cost management efforts translate into action.

1. Compile the following key metrics:
   1. Total SaaS spend for the quarter
   2. Number of unused licenses
   3. Potential savings for reclamation
   4. Recommendations for consolidations
2. Use pie charts and tables to visualize your findings.
3. Package the report for stakeholder presentation.

💡 Tip: You can use historical comparisons to showcase your progress.

Step 5: Integrate audit findings into QBRs

Finally, you must include your audit findings in your quarterly business reviews (QBRs) to demonstrate the value of optimizing SaaS spending.

• Highlight your wins. Share with your clients how many licenses you’ve reclaimed and how much money you’ve saved.
• Connect savings to strategy. Explain how these savings support your organization’s long-term goals, like budgeting, procurement, or operational efficiency.
• Predict smarter. Use trends to justify future SaaS vendor management decisions.

📌 Best practices summary table:

Automation touchpoint: Simplifying tracking SaaS license assignments

Manually tracking SaaS licenses every month can be time-consuming and error-prone. To make the process easier, we recommend automating where possible.

Here’s an example:

• Use PowerShell or Google Admin SDK scripts to export license assignment reports monthly from your SaaS platforms.
• Automate sending reminders for finance and IT teams to review the audit and take action.
• Store all SaaS audit reports in a shared folder or a centralized hub like NinjaOne Documentation.

These automations strengthen SaaS license management while reducing administrative overhead.

Why auditing SaaS costs matters

Cost optimization has become a priority for many organizations, but achieving it has not been easy.

Recent studies show that visibility on organizational technology stacks has declined from 47% to 43%, meaning that more companies are having difficulty tracking and reducing their SaaS spending. After all, you can’t optimize what you can’t see.

This is why conducting quarterly SaaS cost audits is important. These reviews will give the visibility needed to make cost-effective decisions.

By consolidating all your billing statements from each SaaS vendor and comparing them with licensing assignments, you can identify which are being used and reclaim or reassign those not in use.

More importantly, these audits demonstrate responsible financial governance. It shows that your organization is actively tracking and managing its software investments, instead of simply reacting to budget pressures.

This proactive oversight assures stakeholders and clients that your organization is making every dollar count.

How NinjaOne helps MSPs cut SaaS costs

NinjaOne empowers MSPs to optimize SaaS spending by:

• Automating offboarding workflows that include license cleanup tasks.
• Storing SaaS cost audit reports in NinjaOne Documentation for redundancy.
• Tracking tickets tied to unused license reclamation.
• Including SaaS license metrics in client-facing QBR dashboards.
• Generating reminders for quarterly audit cycles.

With NinjaOne, MSPs can gain clear visibility of their tech stack and reduce SaaS waste.

Increasing savings by conducting quarterly SaaS cost audits

Complete visibility over your tech stack is the foundation of making cost-efficient investments. Software will continue to evolve and new features will always emerge, but by consistently auditing your SaaS costs each quarter, you can stay in control of your spending.

By using native dashboards and simple reporting tools, you can track your SaaS usage, reduce waste, and increase savings without the additional cost of a new management platform.

Related topics:

• What is IT Asset Management: A Comprehensive Overview
• A Guide to Managing Hardware & Software Assets
• Cost Guide: Managing IT Costs Effectively
• IT Budgeting: Tips and Best Practices
• IT Department Guide: How to Reduce IT Expenses Without Compromising Service