---
title: Best practices in managing CRM data for finance - ScaleXP
description: Suezann Holmes, CEO of ScaleXP, and Hugh McNulty, HubSpot, explore best practices with CRM data for finance professionals.
canonical: https://www.scalexp.com/blog/best-practices-crm-data-finance/
---
# Best practices in managing CRM data for finance

Suezann Holmes, CEO of ScaleXP, and Hugh McNulty, HubSpot, explore best practices with CRM data for finance professionals.

This webinar is for finance teams at small and mid-sized businesses with recurring revenue. Suezann Holmes (CEO, ScaleXP) and Hugh McNulty (HubSpot) show how to get your CRM data into a state finance can rely on, and what to do with it once it is.

Topics covered:

- how to use CRM data in forecasting,
- practical tips to manage contracts and renewals, and
- best practices to [eliminate revenue leakage](https://www.scalexp.com/revenue-leakage/).

Introduction (0:00)

Suezann, Founder and CEO, ScaleXP: …In terms of today, we're going to be focusing on three topics. The first topic is forecasting, and how finance teams can use CRM data for forecasting. We'll then focus on some practical tips for how to manage contracts and renewals, and then we're going to look at best practices to eliminate revenue leakage.

Before we jump into the details, we would love for everyone to type into the chat your top-of-mind thoughts on two questions. The first one is: what is the quality of your CRM data? On a scale of 1 to 10, with 1 being low and 10 being high, how would you rate the quality of your CRM data? And the second one: if you can tell us in just a few words, what is the biggest issue that you're dealing with in terms of your CRM data? We're going to be monitoring the answers in the chat as we go, and we're going to try to pick up questions and integrate them into the answers. Your thoughts and your feedback will be very helpful. Once we talk through the best practices for our three topics, we're going to come to Q&A. We're going to make sure that we leave at least 10 minutes for Q&A at the end, and we're going to take Q&A through the chat, so make sure you keep your chat window open.

Hugh, do you want to just share for a minute or two your experience working with companies, in terms of why this is so important?

Hugh, HubSpot: Sure. The customers I work with directly are roughly 25 to 30, a mixture of SMBs up to enterprise customers who have large HubSpot integrations, mainly Sales Hub. So they're tracking their commercial data in there, and I really often find that they have spent a huge amount of time, effort and resources making sure their commercial data is right. They're tracking every move salespeople make, they're tracking the deal values, all of that. And then their finance data sits over here in a dark room that nobody should ever talk to or look at.

That's the key part of why we're here and what we want to get out today: those two things should be connected. Bad CRM data, while it's annoying and a drag on your business, probably won't shut down your business. But a bad collections policy, or not getting invoices out the door, or having cash flow problems will tank your business. That will shutter a firm. So we have to think about this stuff. And the other part of this is you can have salespeople closing deals worth millions of dollars in your portal, but unless that money hits your bank account, it doesn't matter. So you need to have a source of truth that you can rely on by connecting these two. I realize that's difficult. If it was easy, we wouldn't bother having tools like ScaleXP and, to be honest, HubSpot. It is difficult, but there are certain things we can do that make it worthwhile. It is absolutely key, and for the firms that nail it, everything else becomes easier and their businesses run better.

Suezann, Founder and CEO, ScaleXP: In short, absolutely. And I think one of the things that we'd love for people to take away from this webinar is that it doesn't have to be hard, and it is possible for companies to get started early in their life cycle, as they're building toward success.

Topic 1: Revenue forecasting (3:20)

Suezann, Founder and CEO, ScaleXP: Our first topic is revenue forecasting. This is very close to most finance teams' hearts, and in fact to companies' understanding of what's going to happen in the future. But there are a few reasons that it's hard. The first reason is that the data for a revenue forecast sits in multiple systems, and it is always changing. Many people feel like they need to import the entire sales funnel in order to get a view of future revenue, and they then need to work to remove certain deals: any that are stagnant, any that are old, any that are unlikely to close. And of course there are some renewals that need to be pulled in as well. So there are lots of different data sources. Too often I hear people talking about a revenue forecast like it's a crystal ball. While there is always an element of the unknown in the future, it doesn't need to be such voodoo. It can be a very structured process, and there are some best practices in terms of the data that should come in, and how the data should come in, to make this process as straightforward as possible.

Hugh, HubSpot: Yes. So I'll talk you through a very simple revenue forecast: what is the minimum viable product we can do to get a decent revenue forecast? I understand some of the companies on this call will have already surpassed this, and that's great. I can see in the chat there are data problems, and everybody has those; I can maybe cover those in the questions at the end. But for the people who are probably struggling, who still have a spreadsheet for this that is super manual to run their sales process and get a forecast, I'll just tell you what the very basics are.

There are four key pieces of data that you need to capture in order to have a forecast. The first is you need to have an object in your CRM, or a line item in your spreadsheet, or some sort of object that captures every piece of additional revenue that you're going to close. You can't have, "Okay, this is our B2B pipeline and that's really well forecasted, but our B2C stuff, we don't really capture that, or it's about four grand next month or something like that." Everything needs to have a specific object. Every deal, whether it's at zero percent or 100, needs to be captured at some point.

For each of those, you need to have an amount. Whether that is, for a SaaS business, a recurring subscription amount, or for an e-commerce business, how much you're selling it for, there needs to be a dollar, pound or euro value for every single one of those. Often I see salespeople putting in one pound for deals because they haven't scoped them yet, or zero, or leaving it blank. There are ways in CRMs, and HubSpot is the same as Salesforce is the same as Zoho for this, to make that mandatory, and you can alert on anything that is one or zero, for example. So there are ways of tackling data problems, but at a minimum, have a deal amount.

The next piece of data is a close date. At the very least you need to have something that largely represents the period of time in which these deals will close. Even if the salesperson is like, "I have no idea when it's going to close," make an educated guess. Otherwise the revenue is never going to come in, and you shouldn't be counting it in the first place. So ensure it's mandatory to have an estimated close date for every deal, and be aware that it will get closer to the pin as the deal travels along the pipeline.

And then lastly, tools like HubSpot or Salesforce do this automatically as a deal travels along your pipeline; usually they have a kanban view of objects that travel from left to right. Have a deal probability. If something is at scoping, right at the start, or you've just got a warm lead, give it 10%. As it moves through and you've sent a quote, or you've sent a contract, or you're at negotiations, 50 or 60%. And then if it's out for signature, 80 or 90%, depending on how confident you are.

So: deal amount, close date, probability. That's enough. Those are three numbers that you can estimate and get a revenue forecast from. The better and more accurate those numbers are, the better your revenue forecast will be. That sounds too simple to be true, but when you boil it down, that's pretty much all you need, if you're capturing all parts of it and your data is reasonably clean.

The big gap in process that I see people leave is that closed-won or closed-lost is the end of the process. Sales walk away, management walk away, and everybody's happy, or not so happy. What I've seen really good businesses do is that closed-won is really only three quarters of the way through. […] Now, there's a little bit of setup in that, and a little bit of connecting different tools, but with technology now it is not as difficult as it used to be. You don't have to hire somebody, you don't need an agency, anything like that. […] You have to ensure that the invoice is paid, and only when the invoice is paid does everybody walk away happy, because the money's in the bank and the salespeople get paid their commission. So you have to think about it as a slightly longer process, but with small pieces of key data that go all the way through. That's how we can build a basic forecast. I'll discuss renewals as we go through, which some people put at the end of that process in a SaaS business, but then it goes in a circle all the way around. Suezann, does that make sense? Is that what you see? Does that sound like a useful or accurate process on the CFO side?

Suezann, Founder and CEO, ScaleXP: 100%, absolutely. And interestingly, some of the comments that came in through the chat were all about revenue recognition. I think it's worth taking a minute to touch on how revenue recognition can feed into this, because there's a very clear feed in terms of invoiced revenue. What we always recommend is that when your invoices are sent out, you are pulling 100% of the deferred income into your sales pipeline. So you're looking at any invoice sent and how that revenue is going to be recognized in the future. That's a critical component of the forecast as well.

Shall we have a look at how best practice looks in an example? What we're aiming for is a graph that looks a little bit like this. For context, here we have about 12 or 13 months of historical data, ending in April of this year. We then have a view of the future, and you can see the components that are coming in. There's invoiced revenue: revenue that's been invoiced but is yet to be recognized, so deferred income. We then have contracted revenue: deals closed in the CRM system that are not yet invoiced. If you're closing a three-year deal and you've issued one invoice, then year two and year three obviously need to come into your forecast. There are some straightforward ways to pick up renewals: you can pick these up either based on a historical renewal or retention rate, or on a deal-by-deal basis. And finally, you have your new sales deals in progress. I think that covers a very high-level snapshot of revenue forecasting.

Topic 2: Contract renewals (11:40)

Suezann, Founder and CEO, ScaleXP: To jump into the second topic: contract renewals. Contract renewals are something that we hear about from finance teams quite a lot, and there are a few reasons that it is a little bit hard and can make you feel like you're a dog chasing its tail. The first one is the data sits in multiple systems. You will certainly have some data in your CRM system, and you will also have some data in your accounting system, and this has to come together in order to create a seamless renewals pipeline. For renewals it is critical to track upsells, downgrades and cancellations, and that can be a little bit hard. There are shared responsibilities across teams: customer success obviously has responsibility for making sure that the deals are renewed, and finance has responsibility for making sure that the value of the contract renewal is as clear as possible. And of course those values are always changing. In terms of best practice, you're best suited to talk through this. Hugh, do you want to take it away?

Hugh, HubSpot: Yes, thank you very much. This is actually probably my day job at HubSpot: ensuring that customers see value, use the tools, and then hopefully renew. What I'll say is that the companies that track renewals well treat it as another sales pipeline. The customers you've already sold to, happy or unhappy, are still the easiest revenue you will ever get, far more than new business. So treat your existing customer base and their renewals as a different pipeline, and that's just the same in your CRM. The same way you have an online sales pipeline, or a regional model, or whatever, have another one called renewals. Each existing customer with a contract that's ending or renewing on a certain date has that date as the estimated close date, and their current run rate as the deal amount. So my job becomes basically a salesperson to the internal customers, and my job is to close that renewal before their contract runs out. And then I'm usually responsible for the amount: if they're upselling or upgrading at renewal, or they're removing some software, I will price that and edit my deal amount up or down. So all of a sudden, quite a complex thing, where customer success, finance and sales are involved and it's everybody's problem, is boiled down to one little pipeline with an object for each, and again three or four data properties.

The other thing here is that it's important to define who's responsible for this. Too often the salespeople who have sold the account stay involved with it and have to jump in when it's contract renewal time, or somebody in customer success who maybe isn't that commercial has to jump in, or finance are involved in negotiating contracts. In renewals particularly, you have to name one person who's responsible for moving that deal through the pipeline and closing that renewal. Now, that's not always possible in a scale-up, where people wear different hats, but at least make it part of somebody's job role.

And the last thing I'll say: just as we talked about in the sales pipeline, closed-won is only three quarters of the way through. Once we've got the closed-won on a renewal pipeline deal, it's then invoiced, or the bill is issued, and then paid. Just like it's the salesperson's responsibility to get the company's money in the bank, the renewal manager's or the CSM's job is to get the customer closed, invoiced and paid, and if they have to work with finance to do that and collaborate, even better.

That makes it sound very easy, and with HubSpot or Salesforce or any sort of CRM you can probably build something like that quite easily. The more complicated part is sometimes tracking the revenue. A lot of these tools, HubSpot included, work really nicely when you're selling a product for a value. They don't track recurring revenue as well, and that's something HubSpot's working on, and we're getting better at that. […] So the business end of it can be run in your CRM, and your CSM or whoever tracks it all the way through, but the data and the heavy lifting really is ScaleXP into your accounting software. And I think we've maybe got a screenshot of that next, Suezann?

Suezann, Founder and CEO, ScaleXP: Yes, absolutely. This is the renewal schedule in ScaleXP. For someone who's never looked at it, it probably looks a little bit busy to start with, but on the left-hand side what you have is renewals due. ScaleXP is raising these automatically from the data and the text on the invoice. We're then tracking these through the CRM pipeline. I can see that someone typed into the chat that the best practice is basically to create that renewal as soon as the deal is closed. […] This is very nice because you can just look down this page and see if there's a deal that's missing, and that can be flagged early to the customer success team. And then of course all the latest contract values can automatically feed into your revenue forecast as well. So this is a good way to make sure that nothing falls through the cracks, and that everything is being picked up and works systematically.

Topic 3: Revenue leakage (18:20)

Suezann, Founder and CEO, ScaleXP: To jump into the third topic: revenue leakage. What do we mean by revenue leakage? Some people have a very clear view of what it is, others not so much. From a finance standpoint, what it means to me is the unintentional delay in invoicing or in getting paid, and it comes in a lot of different guises.

The most common one that everyone thinks about is invoices that are sent late: maybe they're delayed a week, or a month, or sometimes even several months. A second one that people sometimes don't think about is a high invoicing error rate. For context, a week or so ago we onboarded a customer. These are the kinds of things that we love to talk about up front, because it gives us very clear targets in terms of improvement. This customer mentioned that they had an error rate of about 20%. That means one of every five invoices being sent out has incorrect data, and it's because the sales team closed the deal and then sent a Slack message to the finance team, who picks that up and prepares the invoices as well as they can. But it's not comprehensive data, so it goes out with an error, and then of course the customer gets annoyed and they talk to finance, and then finance is chasing their tail trying to correct the errors. In just a second we're going to walk through some simple solutions that can be put in place to fix that.

Another example of revenue leakage is forgotten or delayed renewals. People just aren't tracking the renewals, or the renewals are tracked in a spreadsheet and then the person who's tracking them leaves, and someone forgets to update the spreadsheet. Or three deals close in quick succession and one of them doesn't go into the spreadsheet, and no one picks it up for months.

And then the last one, which is probably the least considered but very important, is the amount of time that the finance team spend reconciling, literally with a tick list, how many deals have been closed and how many invoices have been sent. To underline this problem: someone said to me yesterday, a new customer onboarding to ScaleXP, that their fiscal year end is now, and the finance person is going back through basically all the deals closed in the last 12 months. So far she's spent three full business days literally ticking off whether all her invoices have been sent, and she estimates it's going to take another two days. I would categorically say that is an example of revenue leakage, because there will be some invoices that weren't sent, and a week of time to manually check this is a process that belongs in the last decade, or certainly not in the last year. So in terms of best practice, what do you see, Hugh, on your side, in terms of what works best to get rid of these problems?

Hugh, HubSpot: Spoiler alert: collaboration really is the answer here. I have been on both sides of this. I've been the customer success manager in small, growing firms, and I never once thought, early in my career, about how anything in finance would work. I didn't speak to finance; I was scared of CFOs and things like that. And I've been on the other side of that, where you're at a management level, trying to work out why we've got all this revenue in the CRM and none of it in our financial accounts.

What I'll say is that in the past this was hard to sort. The tools that we used for this were NetSuite, Sage, huge on-premise financial and accounting software that took a team of accountants even to make it work, and probably ran on diesel in the back of your office. Nowadays we have the technical tools to solve this. It is not that complicated if we agree the processes. You have CRMs that you can get for free, HubSpot being one, and there are plenty of others. You can get integrations like ScaleXP, and then you can get accounting software that's cheap to start with as well, whatever your opinion of Xero or the different ones. There are plenty of options, they are reasonably easy to work out with somebody who's familiar with them, and they will start sending out accurate invoices without much effort. So I don't think technology is the blocker any more for most of the businesses here. It will be people and process.

So the first thing I would do is bring in whoever is sending out your invoices, whoever cares what your Xero or your bank accounts look like, and have them sit beside the person who's selling the deals, and get them to feel each other's pain. So when the finance person says, "Well, you've closed that and it says $2,000 a month, but actually it's 1,500, or it's moving to 4,000 in six months and we haven't tracked that," then you can work that out. If they don't have to speak to each other, you will never know, they will probably dislike each other, and it makes for a very bad process. So just by involving finance in sales, and sales in how finance works (I realize that's probably often the last thing you want to do, but as a manager that's what you should do), have them work through a process end to end. Don't get them in a room and say, "We're figuring this out, we have 60 minutes, what are your problems?" Literally have a finance person watch what a salesperson does end to end, and watch how that appears in your invoicing and your accountancy software. Because you have to make sales and customer success responsible: the money in the bank for the company is actually their problem. If a salesperson says, "Well, I sold that deal; it doesn't matter to me if they didn't pay," especially at SMBs and scale-ups, if they keep that approach, the company won't be there in six months to pay them anything. So it is important to get them to feel they have skin in the game, that getting money in the bank is part of everybody's process, that they're responsible for it, and that they can help each other do it. Because the faster we fix this, the faster the flywheel spins: they can sell more deals, they earn more commission, finance are happier, the business can pay more money, and everything works better. Everybody has data problems and CRM problems; I spend half of my day job every day working with people on that. But often the bigger, easier thing to progress is the people and process stuff, which you can solve just by sitting on a Zoom call for a couple of hours, or getting in the same office, and getting them to work together.

Suezann, Founder and CEO, ScaleXP: So, to walk through a very pragmatic example of what we see working as best practice, let's take the invoicing process. The ideal thing to do for invoicing is, when a deal is closed-won in HubSpot or any CRM system, to have the sales team fill in the key fields of what the invoice needs to look like. They know that data; they've just negotiated the deal. And it is very easy to set up, in the CRM platform, the fields that need to be captured to feed into the invoicing.

ScaleXP now has an invoicing tool that works with HubSpot, and we're able to take all that data from HubSpot and sync it into Xero or into QuickBooks, as a final invoice or as a draft invoice which is ready for the finance team to review. There's quite a lot of sophistication in this functionality. That can include creating multiple future invoices. To go back to what you mentioned a minute ago about subscriptions and recurring invoices: both Xero and QuickBooks have very nice functionality for that, and what ScaleXP is doing is letting Xero and QuickBooks know that those recurring invoices need to be sent out, with the data coming in directly from HubSpot with really no retyping. It is possible to issue invoices across multiple business entities. Naturally, as a British company, we work with businesses, even small businesses, that have multiple legal entities, in the UK, in Ireland, in Canada and in the United States, and the invoices can pass from HubSpot into any one of those Xero or QuickBooks entities. FX rates can be integrated. And then, critically, there is a two-way sync back into HubSpot, so the sales team can go into HubSpot and see if those invoices have been paid, if they're late, if there are credit notes, if there's any problem. The sales team will be aware without leaving HubSpot, and it makes them more responsible and more willing to jump in when there are problems.

As a holistic process, the goal is to arrive at something that looks like this, where your systems are seamlessly woven together with really no gaps. From the time that you close-win a deal, you're creating the invoice schedule, including the future invoices, and what we would call the contracts. […] […] I think this is what everyone is aiming for in terms of a seamless process. So often people have in mind that it's possible to arrive at this process in a few years, with a few more people. As a company, what we're pushing for is to enable this process early, for as many businesses as possible.

That brings us to the end, and we're almost exactly on time. We were aiming to finish the presentation at 35 past, and we have exactly a minute to go. So I think we're ready to jump into… oh, key takeaways. Hugh, do you want to do the key takeaways?

Key takeaways (29:20)

Hugh, HubSpot: Yes, very quickly. As I was saying, if you're joining this webinar, it's probably a problem for you. I think Suezann and I both want to really get across that this problem is fixable, and so much more flexible than it was five years ago. There are technologies like HubSpot, like ScaleXP, and many others that can solve this for you with a little bit of effort. So don't panic, I think, is what I'm trying to say.

Secondly, the data model and the technology can be implemented, but collaboration is going to make this work, probably above all other things. Get your finance teams to speak to sales, speak to customer success, probably even speak to support.

And then finally, if you're wondering where to start, run a few scenarios end to end. Take the key pieces of data I've discussed here: your deal amount, your close date, your deal probability. Even if you don't have any of that, if you don't have a CRM, if you don't have anything, build that in a spreadsheet and walk through it with a salesperson, or if you're the salesperson, walk through it in the sheet, and build it out step by step: one deal, two deals, your probability, your forecasting, things like that. That's how you can build the process and decide how it could fit into technology. I'm going to say: don't start with the technology first and work backwards; decide how your process is going to work. I say that working for HubSpot. As long as you're buying HubSpot, that's fine. So those are my three key takeaways: this is fixable, get the collaboration, and run a few processes end to end.

Q&A (30:50)

Suezann, Founder and CEO, ScaleXP: Perfect. Okay, I think we're ready to jump to Q&A. By the way, there are some really amazing comments in the chat. If you have questions, type them into the chat and we'll pick them up. I just want to pick up one that someone mentioned in terms of revenue leakage, because I think it's a really great hint and tip. Kevin typed into the chat that one of the things they did to stop revenue leakage is use the HubSpot quote functionality. That forced people to put in the line items for the quotes, and those line items can then feed into the invoices and go directly into your accounting system. That is a really great tip. Thank you so much, Kevin.

Matt, Head of Customer Success, ScaleXP: Can I add more to that, just because I work with our customers on it? I think that's a really good shout-out, Kevin. Further up in the chat, someone also called out using workflows or automation in HubSpot. There's a lot of opportunity, as you mentioned, to use the tools that you have access to, that are relatively inexpensive or free, or that you're already paying for, to make this process that much smoother. The combination that Kevin talks about, using quotes, which forces you to use line items, and then tools like ScaleXP Invoicing, where it can take that quote information, create the invoices straight out of your CRM, keep them in sync with your accounting platform, come through to ScaleXP, defer the revenue, and build your contract and renewal schedule: you start to see how you can reduce the number of clunky spreadsheets and the amount of time your teams are spending to do all of this. I saw the thumbs up there, so I'm really looking forward to talking to you about it as well. Take advantage of those tools and of the automation across the platform, and when you tie that together with the end-to-end flow that Hugh was just talking about, you really start to see those benefits compound. I'm Matt, by the way. I'm head of customer success at ScaleXP, in case you're wondering why I'm chiming in. I talk to our customers on a regular basis about how they can use all of these end-to-end processes to drive those results.

Suezann, Founder and CEO, ScaleXP: Okay, so we're just going to take questions from the chat. If you have questions, just type them in, and Hugh, I think you and I should glance back through the chat, and we'll cover as many questions as we can.

Hugh, HubSpot: I can jump in on one for Paul. Paul, I understand: low deal volume, so you have a small number of very high-value deals, and your forecast is often lumpy. You're either going to be a millionaire by the end of the quarter, or the business goes bust; I know, I've been there. There's only so much you can do. I would make your probability very, very exact, and even better if you design formal reasons why. With salespeople there's always an aspect of sandbagging: until they're getting to the end of the quarter or the end of the month, they'll say, "Oh, it's not going to land," and then at the end it goes to 90% out of nowhere. Try to formalize what the probability ratings are. If you've sent a quote and that quote has been looked at, which you can see in email-tracking software or something, or you've had a call in the last five days and certain words were used, try to really drill down into what makes a deal likely to close, and then try to give super-accurate probabilities. Other than that, my only suggestion from a data-model point of view is to split it out into different deals for different products that are linked in your data model or CRM. If you're selling four different products under one deal, maybe have four different deals, if different parts are less likely to close. Otherwise, I appreciate it is difficult, and forecasting is going to be lumpy over time.

Suezann, Founder and CEO, ScaleXP: Perfect. I think there's a question from Emma, and it looks like it's specifically related to revenue forecasting: making sure that the data is being captured as accurately as possible. Emma, I would say take a quick screenshot of the slide. By setting up these parameters, all deals with a close date, a contract value and a probability, your data will improve and your forecast will improve almost immediately. We're happy to work with you to make sure that gets set up, and anyone else on here who's a ScaleXP customer, we're happy to work with you to make sure it's set up exactly as it needs to be in HubSpot. These parameters are what will drive the accuracy of your forecast for your new business.

ScaleXP team: I also see Maria's point about sales reps not entering data correctly. Having been on both sides of the coin on that, I know about not entering data correctly, and I know about receiving data that's not been entered correctly. One of the things that we try to do from a ScaleXP perspective is give you the option of consuming that data as the salesperson has entered it, but not treating it as gospel, so giving you opportunities to override at certain points throughout. Obviously the ideal situation would be everyone entering data perfectly every time, but every time somebody has to manually enter data in any area, you're going to see issues and choke points. So giving the right people the ability to override and make judgment calls is important throughout the process.

One thing that I used to do when I was a finance director, specifically for sales forecasting, in building this picture: I would take the data from the CRM platform, take the close dates that were in it, and add at least 30 days, if not 60, because my view was that sales teams are, quite frankly, always optimistic. They have to be optimistic; they're optimistic by nature. Little things like that make a big difference, because you're taking the source of data from the sales team, the best view of the data that exists in the company, but overlaying some assumptions that make it more realistic and bring it in line with your experience as a finance team, which is of course always a little bit more conservative. Those key assumptions, how much you want to dial the forecast from the CRM platform up or down, are pretty straightforward to do in ScaleXP, and if anyone doesn't know how to do that, we're really happy to give you a quick overview.

ScaleXP team: [Attendee], I saw your question about whether this works with the HubSpot Sales Hub Starter package. I won't speak for HubSpot, but I'll tell you that I'm using a free version of HubSpot for my demo account, and the screen that you're looking at right now, the revenue forecast, is in my demo account. I've basically taken a deal with line items from closed-won, created my invoices in HubSpot, and that's flowed through to ScaleXP. I've created the contracts for those, with revenue items. […] So I imagine your ability will only be increased by the version that you have.

To answer [attendee]'s question about creating deals in the CRM: there are probably multiple ways you can do it, and as we have discussions about that, we'll decide what works best for your business. If you're using ScaleXP Invoicing, you generate the invoices, as I said, in HubSpot, so there are multiple ways to do it. You could create one three-year product, or three one-year products. HubSpot also gives you some flexibility around how you configure the deal amount: you can take the MRR, the ARR, or the total contract value. All of that information is going to flow through to ScaleXP. But again, when you're generating those contracts in ScaleXP, or if we're going to automate that in any way, we'll have to figure out what works for that scenario. I think that ties back to what Hugh was saying: let's go through a few different scenarios end to end that are relevant for you as we build it out.

Suezann, Founder and CEO, ScaleXP: Perfect. I'm conscious that we have about 30 seconds until we said we were going to finish, and we like to finish on time. For anyone who's not a ScaleXP customer, of course we'd love to talk to you about how the platform can make all of this a little bit easier. You're very welcome to sign up for a free trial; there is a link down here at the bottom of the screen. You can also just get in touch with us via the email invites that we sent out. The last thing I want to wrap up with is a huge thank you to you, Hugh, for joining. It's so helpful to have your insights and your experience from working with larger companies, and to bring those to bear and really underline how important getting processes right is for slightly smaller, slightly higher-growth companies. So a massive thank you.

ScaleXP team: Well, there is one more question that we didn't address. Laura: "We have deal lengths ranging from 6 to 36 months. Can HubSpot reflect the MRR spread over different terms in its forecast?" The revenue forecast chart that you saw is actually in ScaleXP, using both HubSpot and Xero or QuickBooks data. Based on the contract terms, we can reflect that in the revenue forecast, and it is tied to some of the parameters around the deal. So we can have a six-month deal, a three-month deal or a 72-month deal, all reflected accordingly. And then from the renewal schedule, in theory, if you have a 36-month deal, we could be looking at the 36-month contract and then the 36-month renewal off the back of it, so you would have essentially six years of MRR forecast tied to those deals.

Suezann, Founder and CEO, ScaleXP: So I think with that we're going to go ahead and wrap up. Thank you, everyone, for joining. We really appreciate your time; we know everyone's busy, and we sincerely hope this was helpful and useful. Have a great afternoon, or if you're in North America, morning. Take care.

Hugh, HubSpot: Thanks, guys. See you.

## CRM data for finance teams: unlock efficiency & insight

### Experts at HubSpot and ScaleXP share insights into best practice for integrating your CRM and accounting system without breaking the bank

In this webinar, Suezann Holmes, CEO of [ScaleXP](https://www.scalexp.com/integrations/hubspot/), and Hugh McNulty, [HubSpot](http://www.hubspot.com), explore best practices with CRM data for finance professionals. They focus on how to collaborate across your organization to unlock your data and drive results for your business.

Topics covered include:

1. how to use CRM data in forecasting
2. practical tips to manage contracts and renewals
3. best practices to prevent revenue leakage.

Key takeaway: connecting finance and CRM data doesn’t have to be hard or expensive and it is possible for companies to get started early in their life cycle, as they’re building towards success, to put the right tools and processes in place for efficient and effective growth.

## Why this is so important

Companies of all sizes, from SMEs up to large large enterprises, often spend huge amounts of time, effort and resources making sure their commercial data is right in their CRM. So they are tracking salespeople’s every move: they are tracking the deal values, all of that. And then their finance data sits completely separate – “over here in a dark room that no one should ever talk to or look at”.

The key point is that really those two things should be connected because bad CRM data, whilst annoying and a drag on your business, probably won’t’ shut down your business, but a bad collections policy or not getting invoices out the door or having cash flow problems, that will tank your business. That will shutter a firm.

So we have to think about this stuff. You can have sales people closing deals that are millions of dollars in your portal. Unless that money hits your bank account, it doesn’t matter. So you need to have a source of truth that you can rely on by connecting these two.

We realize that’s difficult. If it was easy we wouldn’t bother having tools like ScaleXP and HubSpot. So it is difficult, but there are certain things we can do that make it worthwhile. It is absolutely key and for the firms that nail it, everything else becomes easier and their businesses run better.

## How to integrate CRM data into financial reporting for accurate revenue recognition

CRM data supports accurate revenue recognition when it follows one path from the closed deal to the reported number. The workflow has six steps:

1. **Deal closed.** The deal is marked won in the CRM, with the signed contract attached.
2. **Contract terms captured.** Start date, end date, billing frequency and each product line are recorded on the deal.
3. **Invoice created.** The invoice is raised in the accounting system from the deal’s line items, so prices and dates match the contract.
4. **Revenue schedule built.** Each invoice line gets a schedule over its service period, under ASC 606 or IFRS 15.
5. **Journal approved.** The month’s deferred revenue release is prepared as a journal and posted once finance approves it.
6. **Report produced.** Revenue, deferred revenue, MRR and ARR are reported from the same schedule, so the CRM view and the ledger agree.

### CRM fields that must be clean

- Contract start date and end date, or the term in months
- Billing frequency and payment terms
- Line items with product, quantity, price and discount
- Customer name and billing details that match the accounting system
- Renewal date and whether the contract renews automatically

### The same workflow in HubSpot, Salesforce and Pipedrive

The steps are identical in each CRM; only the names of the records differ.

| Step | HubSpot | Salesforce | Pipedrive |
|---|---|---|---|
| Deal closed | Deal stage set to Closed won | Opportunity stage set to Closed Won | Deal marked as Won |
| Contract terms | Start date and term recorded on the deal | Start date and term recorded on the opportunity | Start date and term recorded on the deal |
| Product lines | Deal line items | Opportunity products | Deal products |
| Invoice, schedule, journal and report | Run in Xero or QuickBooks Online from the deal data | Run in Xero or QuickBooks Online from the opportunity data | Run in Xero or QuickBooks Online from the deal data |

In ScaleXP, contract dates can also come from the CRM deal (HubSpot, Salesforce, Pipedrive). ScaleXP prepares the schedules and journals; they post once finance approves. The [CRM and accounting integration](https://www.scalexp.com/integrations/crm-accounting-integration-software/) page shows how deal, invoice and payment data move between the systems.

![A smiling man in a green t-shirt with crossed arms next to the text 'Revenue Forecasting'.](https://www.scalexp.com/wp-content/uploads/2024/08/Revenue-Forecasting-1024x546.png)

## Topic 1: Revenue forecasting from your CRM

### Sales forecasting: why is this so hard?

1. The first reason is that the data for revenue forecasting sits in multiple systems.
2. It is always changing.
3. Many people feel like they need to import the entire sales funnel in order to get a view of future revenue and they then need to work to remove certain deals – any that are stagnant, old or unlikely to close
4. There are renewals that need to be folded in as well.

So there’s lots of different data sources.

![A crystal ball held by a person dressed in a dark, ornate outfit with a headscarf, surrounded by text elements.](https://www.scalexp.com/wp-content/uploads/2024/08/crystal-ball-with-text-1024x477.png)

People oftentalk about a revenue forecast like it’s a crystal ball. And while there is always an element of the unknown and the future, it doesn’t need to be such voodoo. It can be a very structured process.

There are some best practices in terms of the data that should come in and how the data should come in to make this process as straightforward as possible.

### Revenue forecasting from your CRM: data best practices

![Chart detailing data categories for new sales, invoiced revenue, contracted revenue, and renewals in ScaleXP.](https://www.scalexp.com/wp-content/uploads/2024/08/Data-to-include-1024x444.png)

There are four key pieces of data that you need to capture in order to have a forecast.

**New sales.** You need to have an object in your CRM or a line item in your spreadsheet or some sort of object that captures every piece of additional revenue that you’re going to close. So you can’t have your B2B Pipeline that’s really well forecasted but a B2C pipeline that you don’t really capture. Every deal, whatever the probability, needs to be captured. ***For each of those you need to have:***

- **an amount,** so whether that is for a SaaS business, a recurring subscription amount, or for an e-commerce business, how much you are selling it for, ***there needs to be a dollar/pound/Euro value for every single one of those***. There are ways in CRMs you can make that mandatory – HubSpot, Salesforce, Zoho are the same for this. And you can alert on anything that is one or zero, for example.
- ***a close date.*** at the very least you need to have something that largely represents how often the period of time in which these deals close. So even if the salesperson is like I have no idea when it’s closed, make an educated guess, otherwise the revenue is never going to come in, you shouldn’t be counting it in the first place. So it’s mandatory to have an estimated close date for every deal. Be aware that will get closer as the deal travels along the pipeline. Tools like HubSpot or Salesforce do this automatically as a deal travels along your pipeline.
- ***a deal probability***. so if something is at scoping, right at the start, or you know you’ve just got a warm lead, hand it 10%. As it moves through and you’ve sent it a quote or you’ve sent a contract or you’re at negotiate, 50 or 60% and then it’s out for signature, 80 or 90% depending on how confident you are.

With those four pieces of data: deal, amount, close date, deal probability – you can get a revenue forecast. The better and more accurate those number are, the better your revenue forecast will be. That sounds too simple to be true, but when you boil it down that’s pretty much all you need, if you’re capturing all parts of that and your data is reasonably clean.

![Portrait of Hugh McNulty, a professional associated with HubSpot.](https://www.scalexp.com/wp-content/uploads/2024/08/Hugh-642x1024.png)

“The big gap in process that I see people leave is closed won deal or closed lost deal is the end of the process. Sales walk away, management walk away, and everybody’s happy or not so happy.

What I’ve seen really good businesses do with a tight process is the closed one is really only three quarters of the way through the deal goes to closed won, then it goes to to be invoiced or a process or a tool like ScaleXP then it automatically invoices that customer.

Now there’s a little bit of setup in that, there’s a little bit of connecting different tools but with technology now it is not as difficult as it used to be.

You don’t have to hire somebody, you don’t need an agency or anything like that so for example in HubSpot it would be Closed Won deal that’s automatically invoiced then still not finished you have to ensure that that invoice is paid.

Only when the invoice is paid does everybody walk away happy because the money’s in the bank. The salespeople get paid their commission .

So you have to think about it in a slightly longer process but with small pieces of key data that all go all the way through and then that’s what we can do to build a basic forecast.

Some people put renewals at the end of that process – we will talk about that later – then it sort of goes in a circle all the way around.”

### Revenue forecasting: the added complication of revenue recognition rules

Another complication of forecasting from your CRM is that CRMS tend to focus on contract and invoice values, whereas financial forecasts need to follow accounting rules for revenue recognition.

A common issue for SaaS companies and other subscription businesses is how to translate booked and invoiced revenue into accounting revenue for purposes of forecasting, spreading the value across the appropriate amount of time. Often this is done in manual spreadsheets which are time consuming to maintain and do not sync automatically with the latest CRM data.

This is where tools like ScaleXP come in, to automate translation of all the CRM data into a financial forecast which meets business and investor needs to see recognized revenue and other key business metrics of revenue such as monthly and annual recurring revenue amounts.

Here is an example of best practice in translating CRM data into a financial forecast.

This example forecast has been generated in ScaleXP, in this case combining CRM data from Hubspot and accounting data from Xero to generate a forecast.

![A revenue forecast chart displaying actuals, invoiced revenue, contracted revenue, renewals, and deals in progress over time.](https://www.scalexp.com/wp-content/uploads/2024/08/Forecast-example-1024x417.png)

This graph illustrates historic data alongside a forecast.

The components that are coming into here are:

- **invoiced Revenue:** that’s invoiced revenue that’s yet to be recognized, in other words, deferred income.
- **Contracted Revenue:** these are deals closed in the CRM system that are not yet invoiced. If you’re closing a three year deal and you’ve issued one invoice, then year two and year three obviously need to come into your forecast. Those are shown here.
- **Renewals:** you can pick these up either based on a historical renewal retention rate, or you can pick them up on a deal by deal basis.
- **Deals in Progress:** Deals in the pipeline that are expected to generate new sales, generally probability weighted.

## Topic 2: Best practices in managing contract renewals

![A woman holding a tablet and smiling, wearing a yellow blazer, with text 'Contract Renewals' beside her.](https://www.scalexp.com/wp-content/uploads/2024/08/contract-renewals-1024x542.png)

### Contract renewals: why this is so hard

There are a few reasons that managing and tracking contract renewals can make you feel a bit like you’re a dog chasing your tail.

1. The data sits in multiple systems. You will have some data in your CRM system and you will also have some data in your accounting system. To create a reliable renewals pipeline, this all has to come together seamlessly.
2. It is critical to track upsells, downgrades, cancellations; that can be hard.
3. The problem of shared responsibilities across teams. Usually customer success has responsibility to make sure that the deals are renewed, while finance has responsibility to make sure that the value for the contract renewal is captured correctly.
4. Values are always changing, often without anyone thinking to keep a record of it.

![Cartoon illustration of a dog with a swirling motion and accompanying text about data management challenges.](https://www.scalexp.com/wp-content/uploads/2024/08/renewals-picture-with-text-1024x360.png)

### Renewals best practice

#### 1. Have a separate renewals pipeline in your CRM

***Companies that track renewals well treat it as another sales pipeline.*** The customers that you’ve already sold to and are happy, or unhappy, are still the easiest revenue you will ever get, far more than new business, so treat your existing customer base and your renewals as a different pipeline.

And that’s just the same in your CRM, so the same way you have an online sales pipeline or a regional model or whatever, have another one called renewals.

Each deal or each existing customer with a contract that’s ending on a certain date or renewing on a certain date, then, is the estimated close date and their current run rate is the deal amount.

#### 2. Have a clear owner of the renewal; include ownership of both data and payment status

So in a typical renewal situation, someone internal – customer success or sales or someone else – effectively becomes a salesperson to the internal customers and his or her job is to close that renewal before the customer contract runs out.And from a deal perspective, the amount may then change as there might be an upsell or other upgrade at renewal or if say, the customer is removing some software or reducing the package they are on. Someone needs to price that and, from a data perspective, edit the deal amount up or down.

This becomes quite a complex thing where customer success, finance, sales all are involved. It’s sort of everybody’s problem and yet who will get it boiled down to one new deal in the renewals pipeline with an object for each against three or four data properties?

***It is super important to define who’s responsible for this.*** Too often salespeople who have sold the account get left involved with the account and they have to jump in when it’s contract renewal time or somebody in customer success who maybe isn’t that commercial has to jump in without training, or finance are involved negotiating contracts.

In renewals, particularly with data management, you have to name one person who’s responsible for moving that deal through the pipeline and closing that renewal. Now that’s not always possible in a scale-up, people wear different hats, but at least make it part of somebody’s job role.

The last thing I’ll say about the data in the renwals pipeline is that, just like we talked about in the sales pipeline, closed one is only three quarters of the way through. So once we’ve got the closed won as a renewal pipeline deal, then invoiced or bill issued, and then paid.

***So just like it’s the salesperson’s responsibility to get the company money in the bank, the renewal manager or the customer success manger (CSM), their job is to get the customer closed, invoiced, and paid. And if they have to work with finance to do that and collaborate, even better.***

With HubSpot or Salesforce or any sort of CRM, particularly when combined with a tool like ScaleXP, you can probably arrange that quite easily.

#### 4. Track changes to deal value, payment status, etc. in your CRM

![Four steps for managing renewals in a CRM system, including sales pipeline and tracking retention.](https://www.scalexp.com/wp-content/uploads/2024/08/renewals-best-practice-1024x438.png)

#### 5. Track renewal retention rates in a systematic, automated way

A tool like ScaleXP can help coordinate renewal activity and ensure data is collected and tracked correctly.

Below is a screenshot from the a renewals summary screen in ScaleXP.On the left hand side you have renewals due; ScaleXP is generating these automatically using the data and the text on existing deals and invoices.

ScaleXP is then tracking them through the CRM pipeline.

![Data table displaying current contracts, CRM data, and expected renewals with various details.](https://www.scalexp.com/wp-content/uploads/2024/08/renewals-in-scalexp-1024x287.png)

As mentioned above, industry best practice is to create a separate renewal deal as soon as the initial deal is closed. Set the renewal up in the CRM and then ScaleXP will pull in the status from the CRM system and keep it continuously updated.

You can just look down the page and see if there’s a deal that’s missing. That can then be flagged early to the customer success team.

Also, with ScaleXP, all the latest contract values can automatically feed into your revenue forecast, so this is a good way to make sure that nothing falls through the cracks and that everything is being picked up and works systematically.

## Topic 3: Managing revenue leakage

![A man with a shaved head wearing a purple shirt, arms crossed, next to the text 'Revenue Leakage'.](https://www.scalexp.com/wp-content/uploads/2024/08/revenue-leakage-title-1024x515.png)

### What does revenue leakage mean? What causes it? How can I prevent it?

So what do we mean by revenue leakage? Revenue leakage refers to the unintentional loss or delay in translating booked revenue into cash sales, and it comes in a lot of different guises.

- **late invoices:** the most common one that everyone thinks about is invoices that are sent late – delayed a week or a month or sometimes even several months
- a high invoicing error rate: this is a second one that people sometimes don’t think about.
- **forgotten or delayed renewals** is another example of revenue leakage. People just aren’t tracking renewals or the renewals are tracked in a spreadsheet and then the person who’s tracking those renewals in a spreadsheet leaves and someone forgets to update the spreadsheet. Three deals close in quick success and one deal doesn’t go into the spreadsheet and no one picks it up for months.
- **missed invoices and other mismatches between booked deals and invoiced deals:** And then the last one which is probably the least considered but very important is the amount of time that the finance team spends reconciling with tech just how many deals have been closed and how many invoices have been sent.

![Graphic representation of revenue leakage with a faucet and dollar bills flowing out.](https://www.scalexp.com/wp-content/uploads/2024/08/revenue-leakage-1024x421.png)

### Customer stories: examples of revenue leakage

Suezann Holme of ScaleXP shares some real life examples of how ScaleXP has helped customers prevent revenue leakage by reducing invoicing error and missed invoices.

![Portrait of Suezann Holmes with light brown hair and a maroon top against a neutral background.](https://www.scalexp.com/wp-content/uploads/2024/08/Suezann-Holmes-677x1024.png)

“Aweek or so ago we onboarded a customer and this customer mentioned that they had an error rate of about 20%. That means one of every five invoices being sent out has incorrect data. It was because the invoices were being prepared by the finance team based on Slack messages from sales rather than the kind of comprehensive, joined up process that is so easy using ScaleXP”

“Another recent customer said she’s spent three full days already – and likely another two more ahead – just going through all the deals that have been closed and ticking off against invoices been sent.” This is another clear example of revenue leakage because there will be some revenue, some invoices that weren’t sent, not to mention a week of time to manually check this. It’s an outdated process that can easily be sorted with today’s technology.”

### Revenue leakage: the importance of collaboration

Quite often, CRM data is entered by salespeople or customer success managers who don’t think about the operations of finance or bill collection. And finance, for their part, don’t understand or care about the deals in the CRM or what data is stored there. Management, meanwhile, are left with the consequences: wondering why the revenue in their sales reports doesn’t translate into cash in the bank.

The solution comes down to connecting the process with the right technology and the right process to ensure collaboration across teams. Having the right process and systems in place to make collaboration easy and routine ensures that this happens and that information flows seamlessly across all parts of the deal process, right through to collecting the cash.

![Multiple hands coming together in a fist bump over a table with documents and charts.](https://www.scalexp.com/wp-content/uploads/2024/08/collaboration-1024x313.png)

Hugh McNulty of HubSpot explains why collaboration is the answer to preventing revenue leakage.

“I have been on both sides of this:

- I’ve been the customer success manager in small growing firms and I’ve never thought once when I was early in my career about how anything finance would work and I didn’t speak to finance.
- And then I’ve been on the other side of that where at a management level you’re trying to work out how you’ve got all this revenue in the CRM and none of it in the financial accounts.”

In the past this was hard to sort. The tools that we used for this were NetSuite, Sage, huge on site financial software accounting softwares that took a team of accountants even to make it work- probably ran on diesel in the back of your office. Nowadays we have the technical tools to solve this. It is not that complicated if we agree the processes. You have CRMs that you can get for free, HubSpot is one; there are plenty others. You can get integrations like ScaleXP which work with inexpensive accounting systems that are easy to set up, such as Xero and others.

So therefore I don’t think the technology is any more the blocker. For most of the businesses here, it will be people and process.

**Having the right people and process:**

So the first thing I would do is get whoever is sending out the invoices, whoever cares what your Xero or your bank accounts look like, bring them in and have them sit beside the person who’s selling the deals and get them to feel each other’s pain. Have them work through a process end to end. Have a finance person watch what a salesperson does end to end and see how that appears in your invoicing, your accountancy software.

You have to make sales and customer success feel that getting the money in the company’s bank is actually their problem too; that it matters if a deal they sold doesn’t pay. Especially at SMBs and scaleups, the company won’t be there in six months to pay them anything if that happens, so it’s important to get them to feel skin in the game that getting money in the bank, that it is part of everybody’s process here, and they’re responsible for that. The flywheel spins faster, they can sell more deals, they earn more commission. Finance are happier, the business can pay more money, and everything works better.

![Portrait of Hugh McNulty, a professional associated with HubSpot.](https://www.scalexp.com/wp-content/uploads/2024/08/Hugh-642x1024.png)

A very pragmatic example of how we see this working is this example of the invoicing process.

### Preventing revenue leakage: best practices in invoicing

This illustrates best practice invoicing using ScaleXP and HubSpot in conjunction with a basic accounting package like Xero or QuickBooks.

![Visual representation of steps for easy and fast invoice creation with various features listed.](https://www.scalexp.com/wp-content/uploads/2024/08/invoicing-best-practice-1024x212.png)

**1. Have the sales team fill in the details needed for invoicing.**

The ideal thing to do for invoicing is when a deal is closed won in HubSpot , or in any CRM system, have the sales team fill in the key fields of what the invoicing needs to look at. They know that data they’ve just negotiated the deal and it is very easy to set up in the CRM’s platform the fields that need to be captured to feed into the invoicing.

**2. Sync all invoice details, creating current and future invoices seamlessly.**

ScaleXP now has an invoicing tool that works with HubSpot and we’re able to take all that data from HubSpot and sync it into Xero. It can sync into Xero as a draft or approved invoice, or to QuickBooks Online with Send Now or Wait Until Approved, so the finance team can review it first. There’s quite a lot of sophisitication in this functionality so that can include creating multiple future invoices.

Both Xero and QuickBooks have really good functionality for creating repeating invoices for subscriptions; what ScaleXP is doing is just letting Xero and QuickBooks know that those kind of recurring invoices need to be sent out. The data is coming in directly from HubSpot with really no retyping.

**3. Issue invoices across as many entities and currencies as required.**

In ScaleXP, it is possible to issue invoices across multiple business entities. We work with businesses, even small businesses, that have multiple legal entities in the UK, in Canada, in the United States, and elsewhere. In these cases, the invoices can pass from HubSpot into any one of those Xero or QuickBooks entities.FX rates can be integrated too.

**4. Sync invoice status into HubSpot so that the sales team can see whether or not they have been paid.**

Using ScaleXP invoicing from HubSpot, there is a two-way sync back into HubSpot so the sales team can go into HubSpot. They can see if those invoices have been paid, if they’re late, if there are credit notes, etc. If there’s any problem, the sales team will be aware and, without leaving HubSpot, they can see what’s happening with the invoices. This empowers them to take more responsibility for payment, to be more willing to jump in when there are problems.

### Revenue leakage: best practice

As a holistic process, the goal is to arrive at a process that looks something like this where your systems are seamlessly woven together with really no gaps.

![Workflow diagram illustrating revenue management processes involving ScaleXP and HubSpot.](https://www.scalexp.com/wp-content/uploads/2024/08/revenue-leakage-best-practice-1024x446.png)

From the time that you create a Closed Won deal, you’re basically creating the invoice schedule including the future invoices and record of financial contract.Invoices are being automatically issued or automatically passed into the accounting system to be reviewed by the finance team.

ScaleXP does a lot to automate not just invoicing, but also revenue recognition off the back of that, preparing and posting the journals back into Xero or QuickBooks, tracking the upsells and downgrades, making sure that the renewal schedules are prepared with the relevant values, etc.

This enables a truly seamless process not just in terms of revenue leakage, but revenue recognition and revenue forecasting as well.

People often think that it’s only possible to arrive at this ideal process in a few years and with a little bit more people, but with today’s tools and technology, there is no need to wait. Tools like HubSpot and ScaleXP are priced to be affordable to small businesses and SMEs, not just large entities.

At ScaleXP, one of our goals is to enable a seamless revenue process quite early in your company’s lifecycle.

## Frequently asked questions

### How should finance teams manage CRM data to get invoices right?

Finance teams get invoices right by making the CRM deal the single source for every invoice, instead of retyping details from emails or Slack threads. With ScaleXP, sales complete the invoicing fields when a deal moves to Closed Won in HubSpot, and ScaleXP creates the invoice and its future billing schedule in Xero or QuickBooks Online. In Xero they go in as drafts or approved; QuickBooks Online has no draft invoices, so QuickBooks users choose Send Now or Wait Until Approved. Finance can review and approve each invoice first, so control stays with the team that owns the ledger. The outcome is accurate invoices sent on time, fewer corrections and credit notes, and cash that reaches the bank sooner.

### How does ScaleXP use CRM data for finance to improve collections?

ScaleXP improves collections by syncing invoice and payment status from Xero or QuickBooks back into HubSpot. Sales and customer success can see, without leaving the CRM, whether an invoice is paid, late or credited, so the person who owns the customer relationship can step in early. Finance no longer chases payment alone, and every team works from the same numbers. Treating a deal as finished only when the cash is in the bank turns collections into a shared process and protects cash flow as the business grows.

### Can ScaleXP find missed invoices by matching CRM deals to accounting records?

Yes, ScaleXP gives finance teams missed-invoice visibility by comparing closed deals in the CRM with the invoices raised in Xero or QuickBooks Online. Instead of spending days ticking deals off against invoices by hand, finance sees which customers have not been billed this month and which accounts are churning, in one view. Natalie, Director of Operations, put it simply: “Being able to see which of our customers are churning, identifying who we’ve missed billing that month was invaluable.” Catching revenue leakage early means more revenue collected, cleaner books and a truer picture of real revenue.

### Does connecting CRM data to finance require an expensive ERP project?

No, connecting CRM data to finance does not require an ERP migration or a large implementation team. ScaleXP sits on top of the systems growing companies already use, linking HubSpot, Salesforce or Pipedrive with Xero or QuickBooks Online, so there is no replacement ledger and no change to how sales work. Every plan includes tailored onboarding, and ScaleXP was founded by a chartered accountant and former CFO who know what finance needs from CRM data. Companies can put a joined-up deal-to-cash process in place early in their lifecycle and keep it as entities, currencies and contract volumes grow.

How ScaleXP does this

ScaleXP builds revenue recognition schedules from your CRM contracts and prepares the journals for Xero or QuickBooks. Finance approves them before they’re posted. [See how revenue recognition works in ScaleXP](https://www.scalexp.com/revenue-recognition/)
