Truth in IT
    • Sign In
    • Register
        • Videos
        • Channels
        • Pages
        • Galleries
        • News
        • Events
        • All
Truth in IT Truth in IT
  • Data Management ▼
    • Converged Infrastructure
    • DevOps
    • Networking
    • Storage
    • Virtualization
  • Cybersecurity ▼
    • Application Security
    • Backup & Recovery
    • Data Security
    • Identity & Access Management (IAM)
    • Zero Trust
    • Compliance & GRC
    • Endpoint Security
  • Cloud ▼
    • Hybrid Cloud
    • Private Cloud
    • Public Cloud
  • Webinar Library
  • TiPs
  • DRAW

Invoicing & Finance Workflows in ConnectWise PSA

Connectwise
05/26/2026
0 (0%)
Share
  • Comments
  • Download
  • Transcript
Report Like Favorite
  • Share/Embed
  • Email
Link
Embed

Transcript


My name is Colin, part of the product success team here at ConnectWise. Today I'll be running through our Good to Goal series, showcasing really what best practice is inside of a well-setup ConnectWise environment. So I'm going to give people maybe another minute or two to join. I appreciate everyone coming on right on time. We'll give another minute or two before we get kicked off here. Good to Go! I think we have a good point to start. So I appreciate you guys joining me this afternoon. Like I said, my name is Kyle, part of the product success team here at ConnectWise. And really what these sessions are, our Good to Goal series for our Power Sessions, is to run through the different areas of ConnectWise PSA, discuss best practice, discuss really what the best-looking setup looks like inside the system, and then run through some scenarios for how to best utilize the tool sets, as well as explain the reasons why we want things set up in a certain way, and what value we can get out of the system as well. In these sessions, I'd like to share a few tips and tricks along the way, a few different screen configurations, so you can start to see your full list of data and get really the most out of your ConnectWise experience. Today, we're going to be concentrating primarily on invoicing and finance inside of the system. Just a quick agenda. I'm not going to bore you with too many PowerPoints. I just want to showcase the quick agenda here. Introduction, a little bit of the pre-billing setup, so what you need to be able to have set up inside of the system before you actually start the invoicing process. We're going to go through a few different invoicing runs, whether it's going to be projects, regular ticket-time materials, sales orders, all of the above, and then finally some post-invoicing and reporting, what to do once these invoices have been created and make sure we're actually making money as they must be here. I expect probably about 30 minutes or so to go through this run-through, and then we'll be able to leave the rest of the time for the session for any sort of Q&A. For the Q&A, I'm not going to limit it just to the invoicing side. Really, if you have any questions around any words of the application, happy to answer those along the way. So jump straight in here, really from a pre-billing setup perspective. There's a few areas that we're going to want to kind of do some internal checks around, and the first one that I want you guys to all be aware of is going to be on the finance and the actual company finance page. Now, this is where we're going to start capturing information about the companies we're going to be sending invoices to and setting some defaults on a company-by-company basis if we want to get to that level. Today, I'm going to pick on Chris Craft Aviation, and there's a few fields inside of here that are going to need to be filled out before we are able to actually push this thing into an invoicing run. First one I want to make you guys aware of is going to be the company status field on this top pod here. So this company status, it allows you to have controls inside of your system to prevent tickets or invoices from being generated for certain clients if they are in sort of like a credit hold status or a not approved status. These guys right now are showing active for me, so I'm not going to have any sort of issues trying to save any records inside their system. Second key area of what you're going to need to make sure to set up before you do an invoicing run is going to be the account ID field in this finance details section. So this account ID field really is how ConnectWise pushes the invoices for this company into an accounting package. So name field here, Chris Craft Aviation. This is essentially what I'm telling my Xero accounting package or QuickBooks instance of what to push the company record to inside of the system whenever I'm syncing the invoices back and forth. If this field is blank, then upon you guys creating and closing out invoices, it's going to give you a big error message saying that it's not an account ID set up. So just a good field that you need to know if you're going to be doing a billing run. I have a few different custom fields here around some of the credit limits and additional debt. These are just custom fields inside the database. You can build whatever you see fit. But from my perspective and what I see other partners do, if there are some sort of credits that we want to keep in track or how much we want our clients to start dipping into, then we have to do a massive hardware purchase. Good to keep in mind what we can actually leverage inside of here. On the right-hand side, we have some overrides we can set on a company-by-company basis, such as billing terms. Maybe you have some companies that you want to do, let's say, net 30 days versus due upon receipt. We can override this on a company-by-company basis. Same thing for if we want a different invoice template or different email invoice template that goes out to them. Set this out on a company-by-company basis. Finally, a good thing to know is in this invoice delivery option section, we can start stacking who we're actually going to be sending the invoices from by defaulting who we want CC'd on these invoices being sent from ConnectWise down here. By default, it's just going to go to the billing contact, but we can also tell it, yeah, we want to go to the accounts department as well. On the main area for starting points for a billing run, it's going to be on our billing setup table. You're going to have a different billing setup table based on each of the different ABMs or different locations you have inside of here. Again, I'm looking at my DropByRT location, my DropByRT ABM. This is where we're going to put some company-specific information that are going to appear on the actual invoices to our clients, such as our remit to information. If you guys are doing any sort of change of addresses or any sort of change of ABMs or company names, to get that to be able to get reflected on the invoices, you're going to need to update it inside this billing setup table field as well. Probably the more important areas inside of here to note, though, are going to be our default invoice templates. Inside my system, I only have one invoice template. I don't want to get too, too fancy inside of here. It's using the stop-standard ConnectWise PDF ones. You do have the ability to do custom invoice templates inside of ConnectWise using ReportWriter. It can be a bit difficult to work with. We have a few templates in there out of the box already, but typically, I just kind of stick with the one default invoice template. Areas to make note of that I see some partners get slipped up over is going to be in your invoicing options section. We have a few options here to exclude do not bill time records, exclude do not bill expense, and do not bill products. What this is really telling us is anytime I have a time entry that has that billable flag set as do not bill, it's just going to prevent them from ever flowing into the invoicing section. Reason being, those time entries should get automatically written off at the end of every day if they're set to do not bill. Therefore, we don't actually need to put them on the invoice. So pretty handy, especially if you have a bunch of $0 entries inside of your invoice screen and don't know why. Probably because this box isn't ticked. If you're looking to put a logo on your invoices from ConnectWise, we're able to tick that off and upload a local image. We have some localization options here specifically for Australia, such as if we want to put your ABN, you can load your ABN down here, as well as overriding if you want to have read receipts or delivery receipts when you do send invoices out of ConnectWise. There's a secondary tab here, the routing tab. Invoice routing allows you to have multi-step checks along the way so that when you do create an invoice, it goes through a list of maybe one or two different people inside of your organization before you basically flag it as ready to be sent out in the invoicing run. My sequence in my instance here is basically whoever creates the invoice gets the first level of checks upon it. Then once the first round of checks goes through, they're going to then get routed to whoever the account manager is that's associated with that company record. Now, when I have this option here for account manager, what that's referring to is whoever it is on the team tab of my company that I'm getting routed to. Going back into my Chris Craft Boats guy, I go into my team tab. Henry Hagan is the designated account manager for this company. Anytime I create an invoice for Chris Craft Aviation, the second router goes to Henry Hagan to approve it before we want it to actually send this out to the client. Now, invoice routing is more of a process-related feature rather than a hard standard feature. We still can send invoices out to the clients without getting them all approved. There are some things we can do, I've seen partners do, such as requiring the routers to change the status of the invoice to something like an approved status before it even shows up in some different queues. But it is at least a good way to do some checks and balances so that we're only sending out invoices after we give it the once-over check. All right. Those are most of the pre-billing areas just to be aware of. Now we're going to get into some of the actual billing runs inside of ConnectWise. And where we're going to want to navigate to is inside of our finance module and then inside of our invoicing screen. And then seeing what's currently inside of the queue to be invoiced. Before I go into any of these specific records, I kind of want to showcase what's on the screen right now. First thing on the top here, we have this through date field. And what that's telling us is all these records inside of this list view right now is from the beginning of time up until this date. Now this always defaults to the current date. But let's say if I wanted to only see records up until the 28th of February, for instance, I can change my through date back to the 28th of February. And this is only going to show me records that are dated from February 28th and backwards. So if you are doing, let's say, end of month invoicing and you, for whatever reason, maybe on vacation, you come back a week later and you have some more noise from the next month inside of here, utilizing this through date will make sure that it's only bringing crop records dated from the 28th of February backwards. I'll flip this guy back over to the 24th. Other area to be aware of is this invoice date field. So this is this field basically is whatever date we're going to be putting on the invoices if we created it today. Maybe a bit easier to show you rather than explain it. Let's say if I change this to the 1st of April, for instance, and I want to go ahead and create this one as an invoice. When I do create this invoice, the date on the invoice is going to show as April 1 because I have changed this date up here. Again, this defaults to the current day, but if you're trying to future date or backwards date your invoices, this is how you can do an amass from this invoicing screen. So. Take a look now at the actual list view format of this page. I have a few more options than most of the people have by default inside of the system. You guys can enable some of these extra fields by going into this little gear icon on the right hand side and grabbing some of these fields out of the hidden columns and putting into the visible ones. The ones that are going to be most valuable for you guys are going to be this invoice amount, billing amount, and agreement amount field. Now, what this actually shows is, let's say this billing amount field, it tells me the total value that is to be invoiced inside of the system. So, for my Chris Craft Aviations, for instance, it's showing me as $2,500. Now, if I were to go and actually create an invoice for this line item, the invoice balance that the client owes us is going to be this invoice amount field of $2,400. These line items don't always match up because if there are time entries that are being applied to the agreement or products applied to an agreement that we still want to showcase to the client, it's going to show up inside of this agreement amount field. So, for this line item, I had $137 applied to the agreement. It's still going to show the overall balance of the invoice, but what's due from the client is going to be whatever this $2,400 is. So, if you guys are showcasing, showing covered time entries on the invoice, then definitely throw this column into this mix so that when you do do your billing runs, you can say, cool, I know that it's showing me half a million dollars, for instance, but I'm actually only going to create an invoice for $5,000 because the rest of it was covered by the agreement. So, some of these other line items here, such as my ticket, my project, sales order fields, the ticket numbers will showcase on this line item whenever that ticket is set to bill separately. If that ticket is not set to bill separately, then it's going to fold in to the other line items on this invoicing screen from the same company that don't have any sort of bill separately type charge. So, if I were to untick the bill this ticket separately, this $200 would just combine into the rest of the current line item here. Same thing for the project. Projects are always going to showcase inside of the invoicing screen to bill separately. And then same thing with the sales orders. If the products are against the sales order, it's going to showcase inside here to bill separately. Really, only whenever these tickets are set to bill together is going to be when they're on a service ticket that's not set to bill separately. So, to actually do a billing run or prep for a billing run, the best way I like to tell partners to do it is, especially if you're billing a massive amount of records on an individual basis, is you can actually click into the company name field. And you can get a preview of what's to be invoiced on this particular line item. So, on this one, I got three different time entries. And then I also have a product for $2,000. Now, if I hit the actions option from within this company field and do create invoices, it's going to give me a bit of a recap inside of here. And this is the one saying that, yep, I had $539 of time, $2,000 in products, but $137 was actually applied to the agreement. So, therefore, I only have this $2,400 amount left. So, it gives you a bit of a preview before you actually go ahead and generate the invoice. And showcasing the $2,400 here. So, keep that one as it is. The other way to do it is you can do a mass action approach. Whereas if you basically want to grab everything inside of here, you can do a mass action create invoice. It's more room for error on that one because there could be bits and pieces inside of here that I don't actually want to invoice. And this is just going to grab every record and try to invoice it out. Usually, I tell partners to click on the company name and double check the record you're actually trying to build before you just do a mass action. And that will clear my invoicing screen. The other sets of invoicing that you do inside of ConnectWise are going to be your agreement invoicing for your recurring services. And to get into there, we're going to go, rather than just the invoicing tab, we have a secondary agreement invoicing tab up here. And same rules apply to these three dates. Right now, this is showing me everything from the beginning of time up until the 24th of March of what I can invoice. And the best way I can tell this is going to be to expose this period start date field. And it's going to tell me that these three pending invoices are from January, from February, and then from March, based on the period start date. And what you can do if you're future generating invoices is you can push this through date to a future date in time, let's say the 1st of April. And then it'll show me basically everything that's pending to be invoiced from April going forward. I'm going to do a bill in advanced. I'm going to go back to the 24th, just so I can have all those records. And then from here, very similar process as action. I'm probably going to tweak these a little bit. Someone has been messed in my environment, so I'm going to undo these guys. Undo these guys. And that one. These ones should be good. And this gives me a preview of all the invoices that just got created. Now, I still have a few invoices pending inside of here. There's a trick if you maybe generated an agreement too early and ConnectWise is trying to tell you to generate the agreement invoices for months that you're not actually providing services to the client. What you can do to clear these things out of the invoicing process is if you tick the boxes, so let's do quantum byte solutions, for instance. I can do actions and then cancel invoices. And all that's really going to do is put a filter on this page. So that's showing up and now the canceled field rather than my open field. Just the way that you don't accidentally generate these agreement invoices in a future date, just filter on there. I did get a little bit hasty for those invoices I created before. I actually wanted to keep one of those standard invoices to show you a few other things on there. All the joys of doing a live demo. All right, let me see if I can find it. I think it was this one. That did not cover any sort of project invoices, and I want to touch upon that because I get a lot of questions pretty often about project invoices. Cool. All right, so let's talk about this Chris Craft aviation one down here. This one is a $400 fixed fee project, and pretty often I get questions coming to me asking about different sort of progress based billing. So let's say you might expect someone to pay you 50% upfront and then 25% upon initiation and another 25% upon completion. Inside of this invoicing screen, we can create something called progress invoices specifically for projects. And the way to do it is if you click on the actual name of the company here. And then for the project invoices, we go to actions, you can create a progress bill. And this is where I can specify how much of the WIP I'm trying to actually invoice out here. So let's say if I want to start by invoicing 50% out. Cool. I got $200 of the $400 out. That's showing me that I still have $200 to be billed. I can then come back in here, let's say when I'm 25% of the way done. I'll do it for another $100. And then upon completion, I can create my final invoice for the rest of the $100. That way for that fixed fee balance of $400, it's split out against three different invoices, depending on the key milestones for the project. So getting out of the invoicing screen, I want to then touch upon some of the special invoices inside of ConnectWise. So we do have three different types of special invoices. We have credit memos, we have down payment invoices, and miscellaneous invoices. Credit memos, best way to describe them is like a credit return. So typically what I see people use these as is returning products into the system. So let's say if I order a product that was faulty, I need to go back to the vendor for whatever reason. I can come to my credit memo here. Then I can add a negative quantity product inside of the system. I have an HP laptop in here somewhere. So I'll do a negative one HP laptop. Nope, I'm going to do a negative one. That's just a positive one. My apologies. You're right, negative one. And this will show me now a $2,200 balance that I have available for the client. I can use this credit balance on any of the other invoices that I have in the system as well as save it across the accounting package if I would like to. Other cool thing with credit memos is if you're trying to return the product back into stock, you can utilize the picking shipping options inside of here and basically teleconnect wise that I've actually received this back into stock and now it should show my stock on hand. The next one I want to touch upon is the down payment invoices. Again, if you're guys are requiring a 50 percent deposit on a massive hardware order, this is probably the easiest way to start tracking that with down payments. The area I want to stress is always select something in the apply to. Like ninety nine point nine percent of the time you're asking for a down payment because it's for a specific job. So if you select the actual apply to field inside of here, I can tell it that, yep, I want to apply it just to the sales order. So whenever I create the invoice from the sales order, my down payment amount can apply to it. Let's say it's going to be a $500 down payment amount. I'm going to backtrack because I already created an invoice for this sales order. Kill that one off. So now I have a $500 down payment, I can apply to just the sales order number six for the client and then upon creating this invoice. It's going to automatically apply that $500 balance just this one invoice because it's tied to that same sales order. I restricted it to. I'm all touched on this. To be honest, I mean, they don't not really need it. If you're trying to invoice something out quickly, you can use it. But generally, if you're trying to invoice a service or a product, it's probably better to throw that onto a sales order or a ticket rather than just generating miscellaneous invoices. So I don't really have a lot of use cases for these ones. All right, so we just generated a bunch of invoices. I guess the question is now, what do we do with them? So going back to some of my writing rules from before, anytime I do have an invoice that. Has been created and brought it across to myself. I can go into the finance and the my invoices screen and start to see all the invoices. My responsibility to do something with. So I can go into this top one here for our accounting. And if I'm happy with the invoice, I want to route it forward to the account manager. Go ahead and pull the plus icon and moves it across the list. So you do have a mass. Well, and now that they've all been approved. Then what you're going to want to do in the list is start actually invoicing and sending them out to your clients. Now, that's usually done via the invoice batch emailing screen. And this is where we're essentially doing a mass email batch to the client for all of the invoices still inside of an open status. Now, when it is time to send these invoices to them, you can press craft aviations. That's the one I'm set up with. You can do a mass action set now. And then upon sending the invoices to your clients via this manner, likewise also sets these invoices to a closed status. So basically locks them down on this point and also generates some of the jail data inside of them. Now, I'm not going to send them because I don't want to get nine emails. I'm just going to do a different way. I'm going to close them out in this case. And once these invoices are closed out, there's an extra tab that pops available on these invoices around some of the jail mappings. So how we're actually pushing this data from ConnectWise into our accounting package. So before I get into the actual invoice, let me go ahead and showcase a little bit of the jail mapping piece of it. So jail mappings, they can be either very specific or very, very broad. It really depends on your own level of need inside of the organization. My preference is to have a lot more specific because I can get a lot more intentional with the data I'm receiving from ConnectWise. Now, the major account types that you guys should be aware of is going to be the revenue account type, which is basically any fixed fee tickets, fixed fee projects, or any of the time entries at a T&M level. It's going to try to map to a revenue account. Revenue agreement. This is just referring to the billing amount field that's on an agreement. I'll show you that in a second here. I don't really see this one used very often anymore. Most of the time, people bill from agreement additions, so this one's a bit obsolete. But if you are using it for whatever reason, that's just talking about whatever is in this billing amount field in the invoice recurring parameters. There's a revenue agreement products field. These are referring to your agreement additions. That's going to be whatever the mappings of these products used are that you should be billing your clients from a recurring revenue perspective. This is generally my recommendation is if you're going to be billing any sort of recurring services, use an agreement addition and map it across to a revenue agreement product. And get very intentional with these mappings because this is going to be the main driver to figure out if your business is profitable or not, because most of you guys should be making most of your money around the recurring services. Last one down here, the revenue product mapping. This is just referring to any sort of product sale that's not associated with an agreement. So if you are adding a HP laptop, for instance, to a ticket or a sales order, any sort of purchases, generally they go to a revenue product level mapping. There are probably about 10 or 15 other ones in there as well, but these four inside of here are the most often used. Now. With these geomappings, we can start coupling how we're actually passing the data into our accounting package as well by using what we call the class system. So going back to my first session talking about locations and departments, departments again kind of being a P&L, I can start to use this my company groups level to tell, hey, anytime my record is actually tied to managed services for revenue, I want to basically put that into a tracking category. And this maps across to your P&L inside of Xero, inside of QuickBooks, saying that, yeah, this is actually going to be going to whatever account defaults onto it. But then anything that's associated with my company groups is going to go to that managed services tracking category. So if I take a look at my technician work role. I have this mapping set for the technician. And then I have a blank for this tracking. So whatever I do, create the invoice and close it out. And we'll find the close, the first match for my account. And we'll also find the first map with the tracking field. So I can actually have both the technician and the tracking category inside of a one geomapping. Right. Easier if I show you on an actual invoice here. So I go back to my invoice search. See if I can find my record. That's part of this one. So this big invoice has three different time entries on there. I go into my GL entries. Notice that it's going to the account of technician. But I have different tech services, managed service, professional services. Because the department on each of these time entries are different. So this one was done on a professional services board. This one was done on managed services. This one on tech services. So I'm basically putting the credit still in the technician account. But I can then have another level of delineation where tech services, managed services and professional services are still able to be tracked separately inside the system. Works really well with the agreement class products too. So if I go into one of my agreement invoices. Don't think I actually created. That's not good. Oh, there they are. Cool. And take a look at my GL entries here. I'll have a very similar setup where some of my products are associated with managed services. Some are associated just my sales. So I can be able to track inside of my account system. But my profitability is of just my resale versus the profitability of my actual managed services offerings. Let me show you one more thing about the GLs before I get into the recording piece here. So there is a hierarchy when it comes around the GL mappings. So if I take my revenue agreement products, for instance. If I hit this map type drop down. This is the order of these are actually a hierarchy that ConnectWise tries to use to find the right GL mapping inside of the list. So we can get as specific as the individual product level mapping, which is. Probably not worth it for 99% of the cases, but instead. I usually tell partners to use a product subcategory or product category level mapping. So whenever I do, let's say a Microsoft 365. Use inside my system. I might have 10 different skus that are associated with Microsoft 365. I'm going to associate that with a product subcategory and then have something like applications managed services revenue dash Microsoft 365 resale. And that's going to be associated with. That's going to be associated with my actual product catalog setup, so all of these five SKUs are using my category subcategory. So whenever I sell these SKUs on an agreement invoice. Here I have this one set up, but I can tell it to go to a M365 account name inside my county package. And. You don't need to have just 17 records. I see anywhere from like 20 records all the way up to like 200 records for the GL mapping. So it really depends on your own business requirements from a reporting side. Now we just generate a bunch of invoices and a bunch of agreement invoices. Let's take a look at some of the reporting pieces of it. So my favorite place inside of connect to us to do so is going to be the financial dashboard. If you guys are using bright gauge or like MSP CFO, something like that. Cognition 360 also really good tools to be able to utilize this, but native inside of connect wise. This is going to give me the best indication of my financial for the health of the business. Now, first place I want to showcase is going to be taking a look at the month of March, expanding out my different services. So the services section is going to be basically tickets not applied to agreements. And the area that I see most people struggle with is figuring out what my service with is still. So things I have created time entries for that unimplied agreement in a certain month, and I haven't invoiced them for whatever reason, usually because the tickets still open or maybe it's waiting approval somewhere. So where you should be checking inside your system is going to be in this invoice hours reconciliation column. And most more specifically, this remaining balance field. So this is basically your service with for the month. And for me, I only have a point of nine inside of here. I got just did a massive rub. But if I wanted to figure out what is this value, I can click into it. It'll give me an overview of what's still outstanding per company for this amount. I want to filter by this extended amount field because this is basically tell me the dollar figure that's still to be invoiced. So I got two bucks left for quantum bytes. I click into the company record. It will show me the actual time entry here. And if I click into the actual members time, it will bring me into the time entry as well. So this one showing me all my service with because tickets still opens and it needs info status. I might make this a bit more dramatic. There's more time entries on this one and see what we got. This is going to be after hours in your technician. Not apply to the agreement. We're going back now. Now show me three hours and thirty seven three point three seven hours remaining. Now to come up with the actual dollar figure of what's to be remaining. What I tell partners to do is on the same line in the financial dashboard. If you compare the total invoice of six oh two. To this extended amount field of nine nineteen. Whatever the difference is, is what's still left as service with for that month. So I still got three hundred and seventeen bucks. The math checks out three hundred seventeen bucks. I still need invoice for the month of March. That's on an open ticket somewhere. So I recommend everyone to call for a bit of their homework afterwards. Go through your financial dashboard for, let's say, the last nine months. We'll talk about this financial year. So click into each month. Search. See what's in this remaining field next month. Exactly the same thing. See what's in the remaining field. If it's showing zero dollars for you, it's awesome. But I'm expecting there to be probably about a thousand or two thousand bucks each month that people just had an open tickets. I've never got close for whatever reason that we need to make sure you're actually recognizing the revenue on. Next area I want to showcase is going to be this agreements area. And this really comes back to the session I was running the other day, which is profitability by different agreement types and recurring services. The whole reason why I'm telling everyone to set up multiple different agreements with different agreement types for each of the levels of services. And so I can come into here and start comparing where I'm actually making money. Now. A lot of these ones manage cybersecurity. There's not really anything on these agreements and the way I can tell that. This is going to be in this hour section. So for all but the exception of the per user. There was no time applied to any of these agreements during the month of March, which is generally what I want to see, because these are mostly just resell only agreements. So I'm not doing any labor on my three sixty five or my stream on IT or cybersecurity. But the ones that I am selling labor on, like my managed support services per user. I'm able to see that, yep, that was about three point five hours of time put against it during the month of March. And I could start doing some analysis over here. So it's effective right field is essentially just grabbing the four thousand bucks or forty four bucks we invoice during the month of March by that by three point five three. And that's basically telling me that I made twelve hundred bucks per hour based on the labor of my managed services agreement. But on a realistic but good way to be able to figure out which clients are actually making money versus not making any money, because if you actually click on these agreement types over here. They'll give you a breakdown for every single one of the clients that has this agreement type that was invoiced for the month. So, Arkham had two hours, Chris Craft Aviation one point five about showing me about thousand or sixteen hundred effectively dollars per hour for their different services here. But I want to dive into that even further. Let's say if I want to figure out, cool, was that thirteen hundred bucks of Chris Craft Aviation's costs coming from. I can get the breakdown where I had twelve hundred ninety bucks worth of costs on the actual products that's associated with the invoice for the agreement invoice. And then for every single one of my time entries, I have a dollar figure associated with the costs here. And this is going to be around a concept called member hourly cost. So, how much are we actually paying our technicians per hour inside of the system? So, myself, I think I set myself like fifty bucks an hour or so. So, based on a forty five minute time entry, it's going to chuck in the cost against the agreement there. So, at the beginning of the month, if you look at the financial dashboard, you're going to show amazing profitability across the entire system. But then as your technicians start putting time against their agreements throughout the month, then the true profitability is going to get calculated. So, now, when you look at the same dashboard at the end of the month, you'll be able to see what the true profitability is rather than any sort of estimates you may have had in the first part. And the other piece of that is going to be like if I go into a managed WAN, again, these ones are going to be straight up license resales, not covering any time. And it's only going to show me this one line item for what the costs are for the actual agreement additions. I can still click on the invoice if I want to and verify that. You can see the costs here. Managed infrastructure is my product. I sold it at 205 bucks for this line item. So, if you see any weird figures inside of there, you can keep going down the rabbit hole and figure out where the data is wrong so you can go ahead and correct it and have this data correct moving forward. Because I don't really care if you use BrightCage or ConnectWise or whatever other tools are out there. All I care about is the data inside of here to be correct. So, whatever you use for reporting will also be correct. And that financial dashboard is a great tool to really narrow down where the data is coming from. All right, I think I'm slowing down here. That's probably a good place to wrap it up for today. So, let's go ahead and open up Q&A in the chat for the next 10 minutes or so. So, if anyone has any questions around what they saw, definitely go ahead and post inside of here. As you guys are chatting, again, on the financial dashboard, we do have the location and the apartment filter here as well. So, if I do want to just say, yeah, I only care about managed services, showing just my managed services data, I can use that as a filter inside of here, too, which is pretty cool. Does that help, Sean? Yes, let me follow up on that. All right, so, I'm going to go ahead and open up the Q&A now. So, if anyone has any questions around what they saw, definitely go ahead and post inside of here. As you guys are chatting, again, on the financial dashboard, we do have the location and the apartment filter here. So, if I do want to just say, yeah, I only care about managed services, showing just my managed services data, I can use that as a filter inside of here, too, which is pretty cool. For those of you who may have joined the first few sessions, this is a nine-part webinar series. So, this is session five. There should be three more with specific content around, I'll say, procurement, projects, and then a kind of companies configuration session. And then the final session will be just a general Q&A about everything we've covered across today. They're all going to be uploaded to YouTube. Just grab that YouTube link now to be able to send that across in the chat here. I'm glad to assist there. I'm still trying to grab the YouTube link. There we go. I'll drop this in the chat here. Downpayment section in my invoice is grayed out. Okay. So, you're only able to select and apply to before you actually save the invoice. So, if you do have a downpayment invoice – I'll share my screen again. I think this is the right one. Yeah, there we go. So, when you are creating a downpayment invoice, the only chance you do actually have the user apply to is before the downpayment invoice initially gets saved. So, if I do that and then – let's say if I don't make an apply to. It can be grayed out. Unfortunately, the only way to go about that is actually deleting the downpayment invoice and recreating it with the correct apply to inside of there. So, not a great solution, but that's the only way to be able to do it, unfortunately. And when you do create the downpayment invoice, make sure you select a company so we have actually something to apply to. All right. I don't see any other questions here, so I'll probably end the session for this one around now. If you guys do have any further questions, though, feel free to reach out to partnersuccess at connectwise.com. We'll be able to organize a more in-depth session with you guys on a one-to-one basis, but I appreciate your time and enjoy the rest of your day. Thank you.

TL;DR

  • Pre-billing setup requires configuring company finance pages with Account IDs, billing terms, and invoice routing workflows to ensure proper approval processes before invoices are sent to clients
  • ConnectWise PSA supports multiple invoicing types including T&M, project progress billing (allowing staged payments like 50% upfront), agreement recurring billing, and special invoices for credits and down payments
  • GL mappings control how invoice data flows to accounting packages, with hierarchical mapping options from specific products to categories, and class systems enabling P&L tracking by service type
  • The financial dashboard reveals service WIP by comparing invoiced amounts to remaining balances, identifies unbilled time on open tickets, and calculates true agreement profitability by factoring in member hourly costs throughout the billing cycle
  • Invoice batch emailing closes invoices and generates GL data, while the system distinguishes between billing amounts (total value) and invoice amounts (what clients owe after agreement coverage)

Pre-Billing Configuration and Company Finance Setup

The session begins with essential pre-billing setup requirements in ConnectWise PSA. Colin emphasizes the importance of configuring company finance pages correctly before running invoices, including setting company status to active, populating the Account ID field for accounting package integration, and establishing billing terms and invoice delivery preferences. The billing setup table contains critical information that appears on invoices, such as remit-to details and default invoice templates. Invoice routing workflows enable multi-step approval processes, allowing organizations to implement checks and balances before invoices are sent to clients. The system supports routing to specific roles like account managers, ensuring proper oversight of billing activities.

Time & Materials, Project, and Agreement Invoicing

ConnectWise PSA supports multiple invoicing methodologies to accommodate different billing scenarios. For time and materials billing, the invoicing screen displays all billable records with configurable through dates and invoice dates for flexible billing cycles. Project invoicing includes progress billing capabilities, allowing MSPs to invoice fixed-fee projects in stages—such as 50% upfront, 25% at initiation, and 25% upon completion. Agreement invoicing handles recurring services separately, with the ability to generate invoices for future periods and cancel pending invoices that were generated prematurely. The system distinguishes between billing amounts and invoice amounts, accounting for time and products applied to agreements that may be covered under managed services contracts but still displayed to clients for transparency.

Special Invoice Types and Credit Management

The platform provides three special invoice types for specific scenarios. Credit memos function as product returns, allowing negative quantity entries that create credit balances applicable to future invoices and can be synced to accounting packages. Down payment invoices enable MSPs to collect deposits on large hardware orders, with the critical requirement to specify what the down payment applies to—such as a specific sales order—ensuring the deposit is correctly applied when the final invoice is generated. Miscellaneous invoices offer a quick invoicing option, though Colin recommends using sales orders or tickets instead for better tracking and workflow consistency.

General Ledger Mapping and Financial Reporting

GL mappings in ConnectWise PSA determine how invoice data flows to accounting packages, with four primary account types: revenue (T&M and fixed fee), revenue agreement (billing amounts), revenue agreement products (agreement additions), and revenue product (non-agreement product sales). The system supports hierarchical mapping from specific products up to broad categories, with most MSPs using product subcategory mappings for optimal granularity. Class systems enable tracking categories that map to P&L structures in Xero and QuickBooks, allowing differentiation between managed services, professional services, and technical services revenue streams. The financial dashboard provides real-time visibility into service work-in-progress (WIP), showing unbilled time entries on open tickets. By comparing total invoiced amounts to extended amounts in the invoice hours reconciliation column, MSPs can identify revenue leakage from tickets that remain open past month-end. Agreement profitability analysis reveals effective hourly rates by dividing invoiced amounts by hours applied, with member hourly costs factored in to calculate true profitability as the month progresses.

Chapters

0:00 - Introduction and Session Overview
2:30 - Pre-Billing Setup Requirements
3:35 - Company Finance Configuration
7:13 - Billing Setup Table and Invoice Templates
9:46 - Invoice Routing Workflows
12:02 - Time & Materials Invoicing Process
19:58 - Agreement Invoicing for Recurring Services
23:13 - Project Progress Billing
25:20 - Special Invoice Types: Credit Memos and Down Payments
30:35 - Invoice Batch Emailing and Closing
32:09 - General Ledger Mapping Configuration
40:40 - Financial Dashboard and Service WIP Analysis
45:08 - Agreement Profitability Reporting
49:31 - Q&A Session

Key Quotes

4:24 "This company status, it allows you to have controls inside of your system to prevent tickets or invoices from being generated for certain clients if they are in sort of like a credit hold status or a not approved status."
5:27 "If this field is blank, then upon you guys creating and closing out invoices, it's going to give you a big error message saying that it's not an account ID set up."
15:26 "These line items don't always match up because if there are time entries that are being applied to the agreement or products applied to an agreement that we still want to showcase to the client, it's going to show up inside of this agreement amount field."
23:45 "Pretty often I get questions coming to me asking about different sort of progress based billing. So let's say you might expect someone to pay you 50% upfront and then 25% upon initiation and another 25% upon completion."
34:00 "Get very intentional with these mappings because this is going to be the main driver to figure out if your business is profitable or not, because most of you guys should be making most of your money around the recurring services."
44:42 "Go through your financial dashboard for, let's say, the last nine months. We'll talk about this financial year. So click into each month. Search. See what's in this remaining field next month. If it's showing zero dollars for you, it's awesome. But I'm expecting there to be probably about a thousand or two thousand bucks each month that people just had an open tickets."

Categories:
  • » Data Protection
Channels:
News:
Events:
Tags:
  • Technical Deep Dive
  • How-To
  • Best Practices
  • Webinar
  • Financial Management
  • MSP Operations
  • Invoicing workflows
  • Financial reporting
  • General ledger mapping
  • Agreement billing
  • Project invoicing
  • Accounting integration
  • Revenue recognition
  • Service WIP tracking
Show more Show less

Browse videos

  • Related
  • Featured
  • By date
  • Most viewed
  • Top rated
  •  

              Video's comments: Invoicing & Finance Workflows in ConnectWise PSA

              Upcoming Webinar Calendar

              • 07/14/2026
                01:00 PM
                07/14/2026
                Crafting a Championship-Worthy Security Team for Unmatched Defense
                https://www.truthinit.com/index.php/channel/2025/crafting-a-championship-worthy-security-team-for-unmatched-defense/
              • 07/14/2026
                02:00 PM
                07/14/2026
                Understanding the Crucial Role of Context in Safeguarding AI-Accessible Data
                https://www.truthinit.com/index.php/channel/2037/understanding-the-crucial-role-of-context-in-safeguarding-ai-accessible-data/
              • 07/21/2026
                04:00 AM
                07/21/2026
                Strategies for Managing AI Governance and Securing App-to-LLM API Traffic
                https://www.truthinit.com/index.php/channel/1967/strategies-for-managing-ai-governance-and-securing-app-to-llm-api-traffic/
              • 07/22/2026
                06:30 AM
                07/22/2026
                Insights and Strategies for Effective Data Privacy and Protection
                https://www.truthinit.com/index.php/channel/2000/insights-and-strategies-for-effective-data-privacy-and-protection/
              • 07/22/2026
                01:00 PM
                07/22/2026
                Insights from Attackers During the FIFA World Cup: A HUMAN Dialogue
                https://www.truthinit.com/index.php/channel/2029/insights-from-attackers-during-the-fifa-world-cup-a-human-dialogue/
              • 07/28/2026
                01:00 PM
                07/28/2026
                Illumio + Netskope: Zero Trust in the Age of AI Autonomy
                https://www.truthinit.com/index.php/channel/2031/illumio-netskope-zero-trust-in-the-age-of-ai-autonomy/
              • 07/29/2026
                04:00 AM
                07/29/2026
                Real-Time Strategies for Safeguarding Against Prompt Injections
                https://www.truthinit.com/index.php/channel/1968/real-time-strategies-for-safeguarding-against-prompt-injections/
              • 07/29/2026
                12:00 PM
                07/29/2026
                Unified Data Security in Action: Uncover, Analyze, and Resolve Threats
                https://www.truthinit.com/index.php/channel/2045/unified-data-security-in-action-uncover-analyze-and-resolve-threats/
              • 07/29/2026
                01:00 PM
                07/29/2026
                Ask Your Cloud Anything: Unlocking Governance Silos in your Environments
                https://www.truthinit.com/index.php/channel/2048/ask-your-cloud-anything-unlocking-governance-silos-in-your-environments/
              • 08/19/2026
                12:00 PM
                08/19/2026
                Becoming Agent Ready: Insights from Cyera's Expertise
                https://www.truthinit.com/index.php/channel/2036/becoming-agent-ready-insights-from-cyeras-expertise/
              • 09/30/2026
                04:00 AM
                09/30/2026
                AI Command Center: Optimizing Visibility and Control in Your Operations
                https://www.truthinit.com/index.php/channel/2024/ai-command-center-optimizing-visibility-and-control-in-your-operations/

              Upcoming Events

              • Jul
                14

                Crafting a Championship-Worthy Security Team for Unmatched Defense

                07/14/202601:00 PM ET
                • Jul
                  14

                  Understanding the Crucial Role of Context in Safeguarding AI-Accessible Data

                  07/14/202602:00 PM ET
                  • Jul
                    21

                    Strategies for Managing AI Governance and Securing App-to-LLM API Traffic

                    07/21/202604:00 AM ET
                    • Jul
                      22

                      Insights and Strategies for Effective Data Privacy and Protection

                      07/22/202606:30 AM ET
                      • Jul
                        22

                        Insights from Attackers During the FIFA World Cup: A HUMAN Dialogue

                        07/22/202601:00 PM ET
                        More events
                        Truth in IT
                        • Sponsor
                        • About Us
                        • Terms of Service
                        • Privacy Policy
                        • Contact Us
                        • Preference Management
                        Desktop version
                        Standard version