Subscription Monitoring checks your clients' proposals against an export of your Xero or QuickBooks subscription charges, to highlight potential missed revenue or overcharged clients.
This feature needs the Pro Features add-on. Go to Subscription Settings to add it.
What you need
You'll need the export from Xero or QuickBooks that lists your monthly charges. It will look something like this.
Xero
QuickBooks
Getting your Xero export
In Xero, go to Practice Tools > My Xero > Billing accounts.
Find your main billing account and click the three dots menu.
Select 'View Invoices'.
Click into your latest invoice using the link under the 'Activity' column.
Scroll down the invoice to 'Attachments'.
Download the attachment with your Xero subscription data.
Setting up the data source
Open Monitor and select Analyse Pricing.
On the Xero Subscription Charges or QuickBooks Subscription Charges card, select Setup, or the Settings cog once it's been set up.
Choose the services it should check, so Socket can compare what the vendor charges you with what you charge clients, then save.
You'll see all services from your current and future pricing menus, as well as any services from older pricing menus that have been used in proposals.
You can change these settings at any time from the same cog.
Uploading your export and running the analysis
In the Analyse Pricing panel, drop your export onto the Xero Subscription Charges or QuickBooks Subscription Charges card, or select its Upload spreadsheet icon and choose the file.
Select Run Analysis.
The dashboard then compares the prices in your proposals with the vendor costs, client by client, showing each client's current price, new price, the variance and their status. Introduction to Price Monitoring explains the dashboard in full.
Investigating the results
Socket automatically tries to match the clients in your export to your clients in Socket. If it can't make a match, you'll see a grey warning triangle. Click the triangle to choose the correct client.
Each matched client gets one of four statuses:
OK: the proposal price and the price from your export are the same.
Undercharged: the proposal price is less than the price from your export.
Overcharged: the proposal price is more than the price from your export.
Missing Data: something is missing, so a calculation can't be made.
Hover over the Missing Data chip to see what's missing. A client could be missing data because:
The client name couldn't be matched.
The client in your export doesn't have an active proposal containing the monitored service.
A client has the monitored service but wasn't in your export.
Keeping the results up to date
If something changes after an analysis has run, such as a proposal or client becoming active or inactive, the Analyse Pricing panel shows Analysis may be out of date - run again to refresh. Select Run Analysis again to update the results.
Uploading a new export
When you have a newer export, upload it on the same card and select Run Analysis.




