qbo and hubdoc

Linda Artesani shows how to automate expense tracking for property management using Hubdoc and QuickBooks Online. Vendor bills arrive by email and post automatically to QBO, but locked PDFs need a zip-code password to unlock and attach manually. She also covers capturing receipts from on-site purchases and paying bills electronically through QBO's bank-pay feature.
Chapters
Hello, Linda Artesani, Artesani Bookkeeping. I thought I would do a quick video. Actually, I'm going to use my, my own company file, which is a property management firm, to show you how I work with Hubdoc and taking away some of my data entry issues, which is why I love QuickBooks Online and why I love Hubdoc. So let's go to my Hubdoc page. And I want to show you here, we've got a bill that came in from National Grid. Now National Grid is terrible. They'll email it, so I have it set up so it will email it directly to my Hubdoc account. And this is how it comes in, and there's really no way to do this. This is a bill that's for electricity. As you can see, it's electricity service, and it's going to be paid direct pay plan. I have it set up so they pay automatically, so I just really need to enter this as a check. I'm not going to enter it as a bill. Although I can view the bill and see how I'm doing with my electric charges and make sure that's not something weird going on, but it's about what my bill is per month. So I have it emailed directly to Hubdoc. Now, because there's a little green checkmark here next to this transaction, I know that this transaction has been, because I set it up, automatically published to QuickBooks. The checkmark means It's in my QuickBooks account, and I've linked my QuickBooks account already to this Hubdoc account. So since I already set this up, I need to go in and look to see if this $321.04 is actually in QuickBooks for my electric bill. And I also want to make sure that the date got picked up right because there's a lot of dates on this particular transaction. I want to make sure that it shows that the bill is going to be paid on On the date that it says it's going to be deposited, taken out of my account, which is 12/14. So let's go into my account. I'm gonna go to expenses. I'm gonna find National Grid. I've got 2 National Grids in Rhode Island. There's a National Grid for gas and a National Grid for electricity. Electric, and it was $321.04. So here's my bill. The problem is Hubdoc sent this over, but I want to see what it attached to it. So I'm just going to open up the attachment to see what it was, and it's got this here that shows me my e-bill. Problem is, is if I go back to my Hubdoc account, the actual bill that I would normally get in the mail, but I've stopped the mailed ones and had them come in, is actually here. But as you can see, with National Grid, I get this. I get a spiraling circle. I can't really view the bill. So what I do is I come over here to download. It's because it's locked. So National Grid for some reason locks the electric bill. The password is the zip code for my account for this particular property. I type it in and it's going to bring up my bill. So here it is saying my direct bill pay will be on 12/14. If I go down a couple pages, here's my actual bill and I can see, you know, what I paid last month was $206. It's wintertime up there now, so it's getting cold. Furnace is running, the electric is on because the lights are coming on earlier. So I can see this is my actual bill. I want to put this on my account, but I can't attach it without attaching it. I don't want to send this to and set it up in Hubdoc to send this over because it doesn't bring it through because it's locked. So I want to attach this. So what I'm going to do here— and I have to do this with all electric bills, unfortunately, it's a lot of steps— but what I do here is I just created a little email so I can send the attachment. I'm going to come back to my National Grid. I'm also going to attach that transaction that I just created an email for. So I'm just opening up the screen, I'm going to drag and drop this in, which is what's great about QuickBooks Online. I no longer need this. And so now I'm here, and now I've got the bill attached, and I've got the little overview thing attached. The date, it came in as 11/28. I know it's going to get withdrawn out of my account on 12/14. And as you know, with QuickBooks Online, if it's in one— if you've got the transaction dated in one month and the transaction actually happens in another month, it won't see it to match it in the bank feed. So I do want that to see the transaction. I don't want to have it entered twice. Once all that is done, because this is an automatic payment, I want to come back here and I'm just going to go here. This is not something that you would normally do in Hubdoc, but it's something that I like to do. So I see lots of green checkmarks, I just click paid, and then now that shows as paid. And I'm going to come over here and click this one as paid. So now I know where I left off, I know where I'm at. And if I come way down here, you can see all these are done. So I don't click paid until it's paid. Here's another one, A1 Answering Service. So I've already pre-coded this. I actually— this one comes in the mail. They don't do mail, they don't do anything other than snail mail for their bills. And I want to use my answering service. I want to have this in QuickBooks. Instead of me typing it in, I've already preset this and set it up so that it goes automatically into QuickBooks. So I just scanned it and dragged and dropped it actually by hitting Add Receipt, and I dragged and dropped it here. So when I have— sometimes you still have— hard to believe we don't have everybody email billing, but some companies don't do email billing, so I just do that. So here I want to check it because it kind of came in a little crooked, and sometimes when it comes in crooked, it may not pick up the right amounts. So now I want to go back to my vendors and find A1 Answering Service. And see if I can look at it. It says I owe $7,591, which is the one. So now I know this is correct. I might want to— because this is several buildings and I know where my empty building was this past month, so that's where most of the phone calls came in. So I'm going to attach it to that class. And I have it preset to a class, but I change that usually monthly. So now I know this is correct. So what I will do is I'm going to click onto my bank account Pay this bill and then I'm going to apply it to pay it electronically so I don't have to print a check. So I've got this system working where it may seem like a lot of steps but it works for me because now I can log into my bank account and I've verified it. I always double-check my figures with Hubdoc because I just want to make sure. So now I want to pay my bill and I want to pay A1. So I'm just going to click pay my bills. I'll come back over here and just click Make a Payment, and then I'm just gonna copy this, come back to my bills. I'm going to make a payment. I've already got all my vendors in my bank, my online banking. A1 Answering, I'm gonna right-click and paste it. I'm paying it today. I'm gonna slide down here. I have a lot of vendors here. I'm gonna hit Make the payment, and now I'm just going to take this confirmation number from my bill payment and move that back over here to my payment itself for my reference number. Working in Hubdoc and how I work in it—it's a wonderful program, especially when you have this kind of a business where you've got—I've got a maintenance man in Rhode Island, and he purchases things at you know Home Depot, things at apartment. And then he just takes a photograph on his phone and uploads it into the Hubdoc account. So I don't have to worry about him losing any receipts. We haven't really lost any receipts because of this. We've got this system set up where he'll, you know, any bill that he pays with a credit card, he pulls it in. I've got the credit card hooked up to QuickBooks, so all I have to do is come over to my dashboard, my banking. I'll pull this in, I'll look on the account, and I'm— now I know I'm missing one Hubdoc. He did not hubdoc this one receipt, so I can ask him, hey, you know, where's the receipt for 11/20? Which would be— he should have hubdoc'd it by now because it's December 1st, so maybe he didn't bring it in and it's in his truck. But normally he would take a picture, upload it to Hubdoc, I attach it, which is another thing I love about Hubdoc. I mean, it's just there. I'm trying to find one. Here's a Lowe's. So you can see he went to Lowe's and he bought some things and it was for Wheeler Avenue, and I can just click here and say, well, what did he buy again for $34? And now I can see He bought a coupling, drain hose, must have been a leak in a faucet or something like that. So now I've got the ability to tie back to my figures. So if I submit these reports— my husband and I own this property, but if this was a client, if I submit these reports to the client, like if I send them to my husband, he looks at all these bills to make sure that, you know, the expenses are along the lines of the budget and we're not overspending, and he knows all the things that have happened in the buildings. And if he says, hey, Linda, what is this? What did we spend $36.44 at Lowe's? We can just click here and I can pull it up, or he can click and pull it up if he logs into QuickBooks Online. So that's how basically I work in some of the steps in Hubdoc. A lot of the bills are different. Some come in via email, some come in snail mail, and I'll scan them. With Hubdoc, you have to, even though it's automated, I still like to double-check. Did my, and I do it a lot of times when I'm paying the bills, did the bill come in with the attached document? Did the reference number come in when the details were pulled in through QuickBooks, through Hubdoc? Did the reference number pull in when the details were pulled in through Hubdoc? Those are things I like to look at. Is the amount correct? Sometimes if you scan them, if they get Stuck or they're a little crooked. You just need to check it because it's not a perfect science yet, but it's definitely saving time with automation, and who doesn't love that? And it's also— the best thing about it is I've got all my documents attached to my transactions, which means I no longer have to worry about filing all that stuff. I've got copies. And I'll go into this a little bit later on how you button up the year and kind of tie off the year's receipts. But I hope that's helpful. I hope this will give you an idea of how I work in Hubdoc with this particular company. And it's different from all— for all the companies, but this really works well. Client can very easily just click to log into Hubdoc on their phone and then just take a photograph. It's just like taking a picture on your phone and then just hit upload, and then it's there for me within seconds. So you can't beat that. So if you have any questions or comments about Hubdoc or any of the other apps you want me to look into, I'm actually going to be looking into a new one very shortly, LedgerSync. I got an invite, so I'm going to take a peek at that one. But if you have any questions, feel free to reach out to me on Facebook and I'll see if I can get you the information you need to know. Thank you. Have a great weekend. Bye now.
More from Sarah

Mid-Year Bookkeeping Review: How to Catch Errors, Fix Discrepancies, and Set Up a Strong Year-End

Best Bookkeeping Software for Mid-Size Law Firms in 2026 | Clio, QuickBooks Online & More

Enhancing Cash Flow Forecasting: Tools and Techniques for Law Firm Bookkeepers

Trust Accounting Compliance: Avoiding Common Bookkeeping Pitfalls in IOLTA Management

Improving Client Billing Accuracy: Best Practices for Time Tracking and Invoicing in Law Firms

Year-End Financial Close: Streamlining Bookkeeping Reconciliation for Law Firms




