Use the PSA quantity as the billing baseline
The PSA usually holds the quantity that will appear on a recurring invoice. That number may come from an agreement, addition, service item, product line, or invoice line.
To reconcile it, start by treating the PSA quantity as the billing baseline and then compare it against operational sources that show real usage.
Match license products to license counts
For license-based services, compare the PSA invoice quantity against active licenses, seats, subscriptions, or users from the relevant vendor or cloud platform.
A mismatch may show underbilling, overbilling, inactive seats, stale agreement quantities, or a client account that needs mapping cleanup.
Match device products to device counts
For device-based services, compare the PSA invoice quantity against managed endpoints, protected devices, servers, workstations, backup devices, or security agents.
The exact source depends on the integration and the billing model. The key is to compare the PSA billing item against the count that actually drives the service.
Connect counts to the correct client account
License and device counts only matter if they are attached to the right client billing account. Client mapping should connect vendor-side or integration-side records to the matching PSA client.
This prevents usage from being missed, duplicated, or assigned to the wrong customer during invoice review.
Simple comparison workflow
A practical workflow is to start with the PSA billing item, identify whether it is seat-based, device-based, user-based, or product-based, then choose the connected system that best represents the real count.
For example, a PSA line for Microsoft 365 should usually be compared against active license seats, while a managed endpoint service should be compared against devices from an RMM or endpoint security tool. Once the two counts are matched to the same client account, the difference can be reviewed before invoicing.
Review exceptions before invoicing
After the PSA quantity and connected count are compared, review the exceptions before month-end invoices are sent. Focus on the largest differences, the clearest evidence, and the services most likely to affect recurring revenue.
BillingReconcile gives MSP teams a structured way to compare PSA invoice quantities against licenses, devices, products, and client accounts without rebuilding the process in spreadsheets each month.
Written by BillingReconcile
BillingReconcile builds billing reconciliation software for MSPs that need to compare invoice quantities against licenses, devices, products, and client accounts before month-end invoicing.
BillingReconcile