Skip to main content

Subscription Monitoring

How to use Subscription Monitoring in Price Monitor to check your Xero and QuickBooks subscription charges against what you charge clients.

Written by Si Evans

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

An example Xero subscription charges export.

QuickBooks

An example QuickBooks subscription charges export.

Getting your Xero export

  1. In Xero, go to Practice Tools > My Xero > Billing accounts.

  2. Find your main billing account and click the three dots menu.

  3. Select 'View Invoices'.

  4. Click into your latest invoice using the link under the 'Activity' column.

  5. Scroll down the invoice to 'Attachments'.

  6. Download the attachment with your Xero subscription data.

Setting up the data source

  1. Open Monitor and select Analyse Pricing.

  2. On the Xero Subscription Charges or QuickBooks Subscription Charges card, select Setup, or the Settings cog once it's been set up.

  3. 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.

The Xero Subscription Charges Settings window, with Xero selected under Relevant Service(s).

You can change these settings at any time from the same cog.

Uploading your export and running the analysis

  1. 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.

  2. 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.

The Price Monitor dashboard with its filters, totals and client list.

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.

Related articles

Did this answer your question?