Latest / QB Power Hour Podcast / 08.27.2024 - Reconciliation Best Practices and Tips
Transcript
- 0:06Dan DeLong: You are listening to the audio portion of the QB Power Hour webinar series.
- 0:10Dan DeLong: The QB Power Hour is a free, bi weekly webinar series for accounting professionals presented by Michelle Long and Dan DeLong, who are very passionate about the industry, QuickBooks, and apps that integrate with QuickBooks.
- 0:23Dan DeLong: You can find out all the details about the webinar series at qbpowerhour.
- 0:27Dan DeLong: com.
- 0:28Dan DeLong: So without further ado, here's Michelle and Dan.
- 0:30Dan DeLong: Welcome, everybody, to another QB Power Hour.
- 0:34Dan DeLong: We are talking today about bank reconciliations in QuickBooks Online.
- 0:39Dan DeLong: Very exciting stuff, right?
- 0:42Dan DeLong: Because that is, that's what we're here for, right?
- 0:45Dan DeLong: that is like the, Michelle, what would you equate bank reconciliations or just reconciling accounts to in a hierarchy of things?
- 0:59Michelle Long: It's like the core of our business a lot of times.
- 1:03Michelle Long: It's One of the central things that we do to make sure we've got all the transactions and that things are in there and it's one Of the starting points to getting everything in there.
- 1:14Michelle Long: So
- 1:16Dan DeLong: yeah, I mean it's if you're you know the old saying of Counting beans, right?
- 1:24Dan DeLong: That's what that's where the rubber hits the road
- 1:28Michelle Long: carolyn says it's like washing the dishes, something you have to do all the time.
- 1:35Matthew Fulton: I remember when I first got started in working with QuickBooks Online, reconciliations were the absolute bane of my existence.
- 1:43Matthew Fulton: I hated, them, especially in the old, system.
- 1:48Matthew Fulton: It just took forever and just, it was a nightmare.
- 1:51Matthew Fulton: And we're going to show today like how it's so much easier.
- 1:53Matthew Fulton: It's going to be pretty cool.
- 1:56Dan DeLong: As, the elder statesman in the, on the panel, Michelle what, was that like?
- 2:03Michelle Long: Now I don't like this elder business experience, maybe.
- 2:10Michelle Long: It is amazing.
- 2:11Michelle Long: It is amazing how far bankruptcy has come.
- 2:14Michelle Long: I talking about bankruptcy, it just reminded me, speaking of elder or experience in my very first internship that I had with Hallmark cards, which I'm talking about Hallmark corporate, the private company.
- 2:28Michelle Long: It would be a fortune 500 company if they were public.
- 2:31Michelle Long: But anyway, so my first job I was reconciling a bank account This was back in the manual days, you know his mainframe system manual days Anyway, I was off like ten thousand dollars on this account and I couldn't for the life of me find it You know, I had checked everything and this was old days where you got your ruler and your cash Vying through things and checking them off to the bank statement the old fashioned way that we had to do it the hard way I couldn't find it.
- 2:58Michelle Long: I was off like ten thousand dollars.
- 3:00Michelle Long: So I went and asked my manager, Hey, can you help me with this?
- 3:04Michelle Long: He was like, ah, it's good material.
- 3:06Michelle Long: We'll look for it next month My first lesson in immateriality was 10, 000 on a 2 million bank account was immaterial.
- 3:17Michelle Long: It was like, no big deal, we'll just look for it next month.
- 3:20Michelle Long: I was like, oh my gosh! But look how far bank records have come to where we are today, where it's at.
- 3:27Michelle Long: Pulling in the statements is pulling in this whole bank feed automating this transaction.
- 3:31Michelle Long: And now it's pulling in bank balances in the month for us and doing the reconciliation for us.
- 3:38Michelle Long: Wow.
- 3:38Michelle Long: Yeah, literally.
- 3:40Dan DeLong: I was telling Matt when we were preparing for, this this, webinar is that, I literally reconciled six months of a, of an account.
- 3:53Dan DeLong: In less than a minute, with the tools that are now available, it's amazing how far it's come, there's Casey.
- 4:07Michelle Long: Sorry.
- 4:08Michelle Long: Casey said it took 10
- 4:10Dan DeLong: minutes.
- 4:10Dan DeLong: He's
- 4:11Michelle Long: shocked, too.
- 4:12Michelle Long: I can't believe it.
- 4:16Dan DeLong: Alright, let's go ahead and kick us off here.
- 4:18Dan DeLong: Go ahead, Michelle.
- 4:21Michelle Long: Hi, everybody.
- 4:22Michelle Long: I'm Michelle Long, CPA.
- 4:25Michelle Long: Frequently, or formerly, newly retired.
- 4:29Michelle Long: Figuring out what I am these days.
- 4:32Michelle Long: Former owner of Wands for Success.
- 4:34Michelle Long: I actually, I still own it.
- 4:35Michelle Long: Actually, my whole career, I've wanted a jewelry client.
- 4:41Michelle Long: I finally got a jewelry client.
- 4:43Michelle Long: I couldn't say no.
- 4:44Michelle Long: I'm going to wind up paying him more than he ever pays me.
- 4:49Michelle Long: Anyway, I've got all kinds of projects lined up with my new plan and I am getting him set up and going You know, that's the great thing about being retired.
- 4:58Michelle Long: You can decide what you want to say.
- 4:59Michelle Long: Yes or no Anyway, i'll get him going and then i'll turn him over to my son.
- 5:05Michelle Long: For the ongoing work, but anyhow, that's enough about me.
- 5:08Michelle Long: Dan, go ahead.
- 5:11Dan DeLong: Dan DeLong, owner of Danwith and School of Bookkeeping, working worked at, not working worked at Intuit for nearly 18 years and co hosting today as well as the Workshop Wednesdays over at schoolbookkeeping.
- 5:24Dan DeLong: com and doing some tech editing for some of the QBO book and QuickBooks books that are out there and joining us today Friend of the show.
- 5:37Matthew Fulton: I need a haircut.
- 5:38Matthew Fulton: Otherwise, I'd look like that, but I'm still Matthew Fulton My friends call me Spot, founder and owner of Parkway Business Solutions You know, we focus primarily on workflow design still do a bunch of accounting, but highly, specialized and I helped click the light switch on for QB community, like the Facebook group, but they're the ones that keep it going.
- 5:59Matthew Fulton: Of course also, which kind of ties into some of the stuff today is I am a workflow consultant for ledger sync.
- 6:06Matthew Fulton: It's an application that actually helps you grab all your transactions, your statements, and your images.
- 6:11Matthew Fulton: So you can have everything on one single dashboard for all your clients and very, happy to be here and be a guest co host.
- 6:18Matthew Fulton: Thank you guys for asking.
- 6:20Dan DeLong: Appreciate you joining us here today and the, sweetening that you did on the presentation slides is forever.
- 6:30Dan DeLong: I'll forever be in your debt because I'll be leveraging the the consistencies that you've done here.
- 6:37Dan DeLong: So appreciate that.
- 6:40Dan DeLong: A little bit the QB Power Hour.
- 6:42Dan DeLong: It's every other Tuesday at 12 noon Eastern.
- 6:46Dan DeLong: This one is not eligible for CPE Credit but the first one of the month will be with our friends at Baker's Hub will be our CPE sponsor, but this one is, not.
- 6:58Dan DeLong: So we just wanna make sure that everybody's aware that even though it's a great topic and, and should be we just wanna try to make it a, an easier.
- 7:10Dan DeLong: Act option of just that first one of the month, whatever that happens to be, would be eligible for CPE credit.
- 7:17Dan DeLong: And if the links there, and I think put them in the chat for today's, for today's slides the, landing page that we have set up for, today has the the handouts and we'll have the replay and the podcast and whatnot.
- 7:33Dan DeLong: But if you go to qbpowerhour.
- 7:34Dan DeLong: com slash resources, there's PDFs and recordings of all of the of the prior QB Power Hour webinars.
- 7:43Dan DeLong: so much.
- 7:44Dan DeLong: A little bit of housekeeping if you have specific questions about something that we're talking about here today, please put them in the Q& A, and but if you just have general general things about what is, what do you equate bank reconciliation to, put them in the comments in the chat, right?
- 8:03Dan DeLong: And we are simulcasting, which again, it reminds me that I didn't Do this.
- 8:08Dan DeLong: I'm okay.
- 8:09Dan DeLong: I've got to do that.
- 8:10Dan DeLong: Once we transitioned over for our first poll question, but on the Facebook group into the QB power user group, if you're watching there, whenever I do put it in there, you'll want to make sure that the streaming platform that we're using has access to your profile.
- 8:29Dan DeLong: So we know who you are when you if you happen to say something in the group there while we're streaming.
- 8:36Dan DeLong: And thank you, Matt, for putting the, putting me in a pink hat because.
- 8:43Dan DeLong: We do have a QB Power Hour store with some swag and I, do look pretty good in pink there, I think.
- 8:50Matthew Fulton: Bringing sexy back, for sure.
- 8:53Matthew Fulton: Loving it.
- 8:54Matthew Fulton: It's
- 8:54Michelle Long: a great color on you, Dan.
- 8:56Michelle Long: I think it looks awesome.
- 9:00Dan DeLong: Check it out if you want, and you can, you too can have your own pink hat.
- 9:06Dan DeLong: Alright, so our agenda today we're going to be talking about just reconciling in QuickBooks Online.
- 9:12Dan DeLong: Alright.
- 9:12Dan DeLong: In general, some common challenges some specialized workloads.
- 9:17Dan DeLong: Mark Matt, Matthew, excuse me.
- 9:19Dan DeLong: I was thinking maker is Mark and not wanting to say maker is Mark.
- 9:25Dan DeLong: And then I threw in Mark for Matt.
- 9:27Dan DeLong: Oh my goodness.
- 9:28Dan DeLong: One of those days.
- 9:31Dan DeLong: But we have some Matthew has some specific workflows to help out with with reconciliation, and we have some helpful tools and hopefully if time, permits, we have some QA time.
- 9:43Dan DeLong: I'm going to stop sharing because we have our, first poll question.
- 9:47Dan DeLong: How frequently are you much time are you spending, average in a month, reconciling accounts for clients?
- 9:55Dan DeLong: And I'm looking for the poll question.
- 9:59Dan DeLong: There we go.
- 10:00Dan DeLong: Launching.
- 10:01Dan DeLong: Okay, and I'll launch that and I will stop sharing so Spot can pick up.
- 10:06Matthew Fulton: Doing as we speak.
- 10:09Matthew Fulton: And Michelle was telling us earlier that it's her fault, actually, that you were That's right.
- 10:18Matthew Fulton: Everything is Michelle.
- 10:21Dan DeLong: She is the, she is more than the goat.
- 10:23Dan DeLong: She is the goat.
- 10:25Dan DeLong: Not just the goat only counting, she is the goat for all the goats around
- 10:31Michelle Long: today.
- 10:33Michelle Long: No, it's funny though.
- 10:35Michelle Long: You know the Taylor Swift song, Me, I'm the Problem?
- 10:38Michelle Long: That's me today.
- 10:39Michelle Long: No, I don't.
- 10:42Michelle Long: You obviously aren't a cheese fan then, because if you're a cheese fan, you have to be a Taylor Swift fan too.
- 10:48Michelle Long: I wasn't a big Taylor Swift fan until she was Kelsey's girlfriend, and now I am a big Taylor Swift fan, too.
- 10:55Michelle Long: And I can't wait for the tea season to start, which, by the way, Dan, we gotta get some bets going again.
- 11:01Dan DeLong: Yeah, exactly.
- 11:03Michelle Long: But we don't play your team this year, I don't think.
- 11:07Dan DeLong: It sounds like you're scared.
- 11:10Michelle Long: No, I just don't remember.
- 11:12Michelle Long: I'm just trying to remember, but I don't think we do.
- 11:16Michelle Long: Anyway, sorry.
- 11:17Michelle Long: Back to reconciling.
- 11:19Michelle Long: Yeah,
- 11:20Matthew Fulton: and so to answer the questions in the chat I, made these polls in my, head.
- 11:24Matthew Fulton: I was wondering like I said before, the reconciliations used to take me so much time and I was wondering how much time it takes, on average for you to, reconcile your accounts for all the accounts for one client.
- 11:42Matthew Fulton: Hey, you can have two accounts.
- 11:43Matthew Fulton: You could have 10 accounts.
- 11:45Matthew Fulton: It just depends on the amount of time spent.
- 11:47Dan DeLong: yeah and there's, definitely other things other than financial institutions that you could want to reconcile yourself, like clearing account and those types of things.
- 11:57Dan DeLong: So it could certainly could, add up more so than than financial institutions.
- 12:05Dan DeLong: So, let me go ahead and end the poll here and I'll share the results.
- 12:08Dan DeLong: It looks like, Majority is 15 to 30 minutes per client.
- 12:16Dan DeLong: If you have a pretty, if you have a lot of clients, then that could certainly certainly add up as a lot of time, of the day.
- 12:24Michelle Long: I would venture to guess too, a lot of that time is spent going and getting the bank statement.
- 12:30Michelle Long: Now that we have the statement there, or the balance there, I think the time spent reconciling is going to go down in a vast number of clients.
- 12:38Michelle Long: Not every client.
- 12:39Michelle Long: There's always the exception to the rule.
- 12:42Michelle Long: But I think a lot of that time is going to be reduced.
- 12:45Matthew Fulton: What do you guys think?
- 12:47Matthew Fulton: I definitely agree.
- 12:49Matthew Fulton: Having worked with an application that's been fetching statements for so many years, trying to get this to be a consistent process of automating that fetching is extremely difficult because the different institutions change how it's done all the time.
- 13:04Matthew Fulton: So we we actually touch base on that through some of this.
- 13:08Matthew Fulton: And I will give the full disclaimer to everybody that's here.
- 13:11Matthew Fulton: If you know me I love to try to share as much information as possible.
- 13:15Matthew Fulton: So this is definitely a decade.
- 13:16Matthew Fulton: That's worth downloading because there will be additional information.
- 13:21Matthew Fulton: I've got some workflow tip things are added in that we can go through somewhat quick to always make sure we have enough time for your questions to Q and a at the end, but definitely take the time to download it.
- 13:32Matthew Fulton: Michelle, you brought this up real quickly earlier.
- 13:35Matthew Fulton: There's so much more that you need to reconcile than just your basic checking and savings account.
- 13:41Matthew Fulton: The credit cards as well.
- 13:42Matthew Fulton: So financial institutions, I say it that way because it's, all of that.
- 13:45Matthew Fulton: It could be loan accounts as well.
- 13:47Matthew Fulton: Clearing accounts, of course, especially when you're using third party apps.
- 13:52Matthew Fulton: I'm a firm believer, when in doubt, wreck the account.
- 13:55Matthew Fulton: The account, and I don't mean wreck it as in w I mean wreck it as in reconcile.
- 14:00Matthew Fulton: No wrecking it,
- 14:01Dan DeLong: Ralph.
- 14:02Matthew Fulton: Yes, exactly right.
- 14:04Matthew Fulton: And some of the tips and things in here have to do with our accountant tools just in case there are those who are just being introduced to those report options.
- 14:13Matthew Fulton: In there you can see when all your last reconciliations were done very quickly and easily.
- 14:18Matthew Fulton: And at the top you can even change your dating of all your common reports.
- 14:22Matthew Fulton: Super important to know as well.
- 14:25Matthew Fulton: But this is where the real fun comes into play, right?
- 14:27Matthew Fulton: It's the automatic statement fetching.
- 14:29Matthew Fulton: So this new functionality.
- 14:32Matthew Fulton: They could
- 14:32Dan DeLong: have used a dog for this icon,
- 14:38Matthew Fulton: You want
- 14:38Dan DeLong: to play fetch or
- 14:40Matthew Fulton: dog names would have been great.
- 14:41Matthew Fulton: I would have actually been honored that way.
- 14:47Matthew Fulton: So, one of the key things.
- 14:49Matthew Fulton: Not all financial institutions are supportive for the fetching.
- 14:53Matthew Fulton: That's one challenge.
- 14:55Matthew Fulton: It's, evolving and it's growing, but if they don't support it, you still have to go get this stuff.
- 15:01Matthew Fulton: And then also keep in mind, the logging credentials have to be good.
- 15:05Matthew Fulton: So in the chat if you have a client that is so wonderful and they love to change their Banking passwords every two weeks because they can't remember their password say yeah, that's me i'm sure we've all got those which cost us tons of extra time and energy Now the cool thing with this though is If you've cleared the bank feed and you've done your last reconciliation These bottom windows here statement ending date and ending balance will auto fill in You All right.
- 15:35Matthew Fulton: So I decided to make this in two minutes, so that you can see what you should be doing.
- 15:42Matthew Fulton: So both parties want to ensure that your families or loved ones are done.
- 15:47Matthew Fulton: I can do more on mental health claims, one of the things is when you get a look at all of the documents, I would like you to go over the document that you're going to be checking in so that you can see exactly how they're divided.
- 16:04Matthew Fulton: Thanks.
- 16:10Matthew Fulton: The balance of the deposits you're checking the dollar amount you're checking the dollar amount of the money in the money out each and The number of transactions because remember I could do a plus 10, 000 here and a plus 10, 000 here and it would still reconcile and now you have two extra transactions that shouldn't even exist there.
- 16:29Matthew Fulton: So you've got to really look at that part.
- 16:31Matthew Fulton: Shortcuts lead to long year end closes.
- 16:35Matthew Fulton: So be very careful.
- 16:39Matthew Fulton: Michelle, Dan, before I go a little further, what other kind of like common challenges do you think will are that you've seen the most out there as well as the chat?
- 16:46Matthew Fulton: What are the common challenges you all have seen?
- 16:49Dan DeLong: The biggest thing and when I was in my 18 years talking to small business owners and accountants added to it was that opening balance not being what it was when they, reconciled it last month that was just a large call driver, right?
- 17:10Dan DeLong: Because you reconcile it one month, you would expect the ending balance to be the opening balance the next month that you go and.
- 17:17Dan DeLong: Do that.
- 17:20Dan DeLong: It was, a, reasonable expectation what that, that happened, the, thing is that opening balance is one of those fundamental truths of, QuickBooks that I would call, tell people is that it's just the sum of the reconciled transactions in that account, when you go to reconcile, it is not pulling from history, right?
- 17:45Dan DeLong: It is just.
- 17:46Dan DeLong: It is one of those things that is recalculated when you go to record stock If and one of my coworkers said something to a customer and it's always stuck with me.
- 17:57Dan DeLong: That opening balance, especially in QuickBooks Online opening balance is like a pirate shit.
- 18:02Dan DeLong: There's ours in there.
- 18:04Dan DeLong: right?
- 18:06Dan DeLong: and that's all it's doing.
- 18:09Dan DeLong: Is is adding up all of the transactions that are ours that are in the register and putting that in there and if it doesn't add up.
- 18:23Matthew Fulton: That's my quote of the day.
- 18:24Matthew Fulton: That's a
- 18:25Michelle Long: good way to remember it.
- 18:26Michelle Long: Yeah, I
- 18:28Dan DeLong: like it.
- 18:29Dan DeLong: And it was easy for me to remember that way.
- 18:31Dan DeLong: And it's always stuck with me.
- 18:33Dan DeLong: And that's
- 18:34Michelle Long: the
- 18:34Dan DeLong: fundamental truth about that is that Regardless of what you expect it to be right because you reconcile the last month that opening balance is just a recalculation when you go into this of everything in that register at that moment in time that has an R on it in and that's what it's going to be.
- 18:57Dan DeLong: You can do the same thing, but run a report outside of it.
- 19:01Dan DeLong: you for transactions that are reconciled and that should match what's showing up in your opening balance, right?
- 19:09Dan DeLong: So that is, that was the biggest challenge.
- 19:13Dan DeLong: I think when it didn't match is now, hunting down what changed and that screen that says, Hey, it's not ready because it's different.
- 19:23Dan DeLong: And it gives you a little bit of.
- 19:27Dan DeLong: Breadcrumb trails to go down.
- 19:30Dan DeLong: It's really part of it.
- 19:31Dan DeLong: It's a challenge because there's a variety of things that change.
- 19:35Dan DeLong: And that's what I would tell people is that something changed from the time that you recognize how that today.
- 19:42Dan DeLong: That there's no longer an R in there that was there before or there's an R in there that shouldn't be there That wasn't there before
- 19:51Michelle Long: and that's one of the things I would like to give into it kudos for giving us that where it says Stop, wait a minute.
- 19:58Michelle Long: Your beginning balance has changed and here's the transactions that have changed It allows you to go in and find them because that saves us so much time that we're looking for Or the way we had to in the past, one of the other common challenges Matt, that screenshot we had, there was brighter or Dan, whoever put it in there, it showed a couple of zeros at the very beginning of it.
- 20:21Michelle Long: And as Matt was saying a while ago you want to also reconcile clearing account, have clearing accounts.
- 20:27Michelle Long: So when you have a transaction where.
- 20:30Michelle Long: You know you're doing a zero dollar expense or a zero dollar check or a sales receipt This is zero dollar sales receipt or whatever the situation is and i'm not sure what those were from People will just leave them there forever They forget that you're supposed to clear those things off and that's one reason why we use a clearing account We don't want them in our main checking account.
- 20:52Michelle Long: So clearing up those kind of things out of here as well as old outstanding checks that Who knows what happened to them?
- 21:00Michelle Long: Were they duplicates?
- 21:02Michelle Long: Were they voided?
- 21:03Michelle Long: Were they You know, somebody lost them and never cashed them researching and finding out what happened to them.
- 21:10Michelle Long: And what do we need to do?
- 21:11Michelle Long: Clearing out that old stuff that's there.
- 21:13Michelle Long: I've gone in sometimes where you have to scroll down like 50 of those before you even get to any of the real stuff so cleaning up some of those things before you even get started is some of the main challenges too.
- 21:27Michelle Long: So anyway the point about the clearing account is good when to keep that out of the main checking account too.
- 21:34Matthew Fulton: So I asked that question on purpose because I figured you guys would land on a whole bunch of these without necessarily even seeing what we'd already put in here because it's more fun to have the conversation about it than you guys all just staring at slides.
- 21:45Matthew Fulton: So missing there's the things I have in here right off the bat.
- 21:50Matthew Fulton: If you've got missing transactions.
- 21:52Matthew Fulton: Guess what?
- 21:53Matthew Fulton: You really have nothing, no other choice, but to first do a search through your magnifying glass.
- 21:59Matthew Fulton: And I have QuickBooks pulled up back behind.
- 22:01Matthew Fulton: I can go to that in a moment to show things, but there's so many nuances here to try to have them all prepared.
- 22:06Matthew Fulton: It's difficult.
- 22:07Matthew Fulton: So if you've got the missing transactions, do a search, try to make sure it didn't get into the wrong account, because it's easy to be done.
- 22:13Matthew Fulton: And if it is, if you can't find it anywhere, Double check.
- 22:18Matthew Fulton: Also that it wasn't multiple transactions combined together into one larger amount or, the other way around as well, maybe the bank has multiple transactions, smaller amounts, and you can bind them into 1.
- 22:33Matthew Fulton: these are the little pieces that Dan likes to call bread crumbs.
- 22:37Matthew Fulton: I like to call horrific rabbit holes that have you ending up in nowhere frustrated on a zoom with your client saying, you promised me this would be easy.
- 22:47Matthew Fulton: You told me.
- 22:48Matthew Fulton: Oh, this shouldn't be should be really easy for you.
- 22:51Matthew Fulton: Famous last words.
- 22:52Matthew Fulton: Right?
- 22:54Matthew Fulton: Michelle, you nailed the clear, the clearing the uncleared transactions in my mind when I'm doing a reconciliation, every single transaction, it all, every one of them has a story.
- 23:05Matthew Fulton: So their story is either been told or it's still pending there.
- 23:11Matthew Fulton: But if there are 0 items.
- 23:14Matthew Fulton: Still take a peek.
- 23:15Matthew Fulton: Make sure there's a reason if you're the only one doing the books in there and you're cool that you can clear them out.
- 23:21Matthew Fulton: If you're getting in fresh and brand new, I will usually leave them for the first time to see if I'm missing something else and need to tie it back and the memo notes or something help me better understand it But you want to get those cleared out so there's less junk in your way two little tips if you still have people writing checks get them to have the bank put on their void after 60 days Because it's going to make it to where, legally, you don't have to honor it after 60 days.
- 23:51Matthew Fulton: You should always go longer than that, of course.
- 23:54Matthew Fulton: But it gives you the ability if it's been an extra 3 4 months, you can void those.
- 23:59Matthew Fulton: Do the the proper work around to show it's still owed.
- 24:02Matthew Fulton: But you can void it and get that area cleared out.
- 24:05Matthew Fulton: And then the last one is right tool.
- 24:07Matthew Fulton: He Hector made a really cool, we worked together and created this unclear transaction reconciliation lookup, where if there are certain ones in there, you can click on, and it will pull up a different tab for each one.
- 24:18Matthew Fulton: It's help you search them to try to find it faster.
- 24:22Dan DeLong: Nice saving precious seconds
- 24:26Matthew Fulton: as Hector would say.
- 24:30Matthew Fulton: Dealer duplicates, this is a big one and there's so many different ways this could go, but I wanted to try to highlight the green box and guys sent some color blind and that is green, right?
- 24:44Dan DeLong: That is green.
- 24:45Dan DeLong: Yes.
- 24:46Matthew Fulton: Okay.
- 24:46Matthew Fulton: So the green box means it came through either a bank, basically through the banking center.
- 24:51Matthew Fulton: You either imported transactions in or a bank.
- 24:53Matthew Fulton: Bank feed was connection connected and it used it to pull the transaction directly.
- 24:58Matthew Fulton: That's how you get the link to transaction towards the top left on the transaction itself.
- 25:03Matthew Fulton: And the ones where they don't have it is where something was manually entered.
- 25:09Matthew Fulton: So if you're doing this and you have you've got to do your research, check it out.
- 25:15Matthew Fulton: What I would actually do in this scenario is I'd go back to this specific one with the green box.
- 25:21Matthew Fulton: I would go to edit, and then I would delete it, to where, because it's linked, it goes back to the bank feed area.
- 25:30Matthew Fulton: I want to slow down and stress, if you delete the manual one, it's gone.
- 25:35Matthew Fulton: If you delete a piece that's been connected through a bank feed, it goes back to the bank feed.
- 25:40Matthew Fulton: Because then you can match it, And you get the green box on the one you manually put in.
- 25:48Dan DeLong: Tidying it up with a bow.
- 25:49Dan DeLong: Putting a bow on it.
- 25:51Matthew Fulton: A nice green bow.
- 25:52Dan DeLong: Yes.
- 25:54Dan DeLong: That you can't see if it's green or not.
- 25:56Matthew Fulton: And then, To do, exactly, To do and undo, or whether you should or not undo reconciliations.
- 26:05Matthew Fulton: This
- 26:05Dan DeLong: is some Shakespeare going on here
- 26:08Matthew Fulton: to undo.
- 26:09Matthew Fulton: That is the reconciliation, something like that.
- 26:14Matthew Fulton: I cannot stand when I have these extra little things back behind here.
- 26:19Matthew Fulton: Even though it's, completely fine.
- 26:23Matthew Fulton: You'll notice on this one here 1130 with the minus 2, 500, Dan, you talked earlier, Michelle, you were talking about the fact like your beginning balance is off, right?
- 26:33Matthew Fulton: And you need to fix it or bank feed broke.
- 26:37Matthew Fulton: You need to reconnect it and being a helpful, they decided that they would actually put another opening balance in there for you and that automatically reconciled.
- 26:46Matthew Fulton: So some reason your tolls are off when you have these, if you put, I, every time I'm jumping to something new to do reconciliation, I will put the same ending date as the last reconciliation and the same ending reconciliation balance, the proper one, pull it right back up and first see if there's anything just sitting inside there.
- 27:05Matthew Fulton: Okay.
- 27:06Matthew Fulton: And you can do that same trick, click off anything that is pending there that should have still been reconciled, and very quickly click the button and make it to where it gets to the right balance, and now you get your zero.
- 27:19Matthew Fulton: Only thing is, you do it a whole bunch of times, it starts looking ugly.
- 27:22Matthew Fulton: So as accountants, we have that batch undo to get back to those.
- 27:28Matthew Fulton: Just be sure if you don't have these statements as attachments, take a screenshot of it first, because it's telling you the ending balance and the balance, I'm sorry, the ending date and balance.
- 27:38Matthew Fulton: For each of the months so you can go back and do those wrecks really quickly because theoretically, you know that the transaction stuff should be there.
- 27:46Dan DeLong: Yeah, the one one thing about undoing that I want to caution people about Is the fact that?
- 27:55Dan DeLong: undo Just undo Undoes what was done during the reconciliation, right?
- 28:02Dan DeLong: So if you do something outside of the reconciliation, it will not get undone.
- 28:09Dan DeLong: So if you, do go reconcile a transaction in the register, or if you added something to make it work, that especially after the fact, undoing doesn't make it work.
- 28:22Dan DeLong: Undo that, right?
- 28:23Dan DeLong: So when you connect the bank feed, for example, and it pulls in a balance that's reconciled and it puts a transaction in the register, that transaction is not going to be touched by an undone, undue process.
- 28:41Dan DeLong: Yes,
- 28:43Matthew Fulton: I'm going to pull up the poll as I do that.
- 28:45Matthew Fulton: Lisa is the audio better by the way.
- 28:47Matthew Fulton: Hopefully that will help get it a little bit louder for you to standardize it.
- 28:51Matthew Fulton: So our next poll we're ready for right?
- 28:54Matthew Fulton: Dan?
- 28:54Dan DeLong: Yes, which one is what percent?
- 28:59Dan DeLong: Let's see, gotta find it now.
- 29:01Dan DeLong: All right.
- 29:01Dan DeLong: What percent of your accounts are you able to do by automatic statement fetching?
- 29:05Dan DeLong: Oh
- 29:06Michelle Long: this
- 29:06Dan DeLong: is such a great thing.
- 29:09Michelle Long: One of the things in that reconciliation history that you were showing, one of the things that I like about that is, I think it was there where it will it was in the reconciliation history I'm, sorry I wasn't there in the reconciliation history where you can see where you previously reconciled and it shows that The statement date and like when you reconcile it will also show if somebody forced the bank reconciliation and so it will show like the statement date The ending balance, and if you forced it to reconcile, it'll show the amount that went to miscellaneous discrepancy or reconciliation discrepancy.
- 29:50Michelle Long: Anyhow, I had a client that kept doing that, but he also knew.
- 29:54Michelle Long: That if I saw something in reconciliation discrepancies on the P& L that he was in trouble because that he forced the bank reconciliation because I told him he's got to reconcile every month, right?
- 30:05Michelle Long: So he would click reconcile now and let it go to recognition discrepancy and then I'd call him up and yell at him, undo it, make you fix it.
- 30:13Michelle Long: And redo it correctly and stuff.
- 30:14Michelle Long: One month he decided he was going to get smart, he thought.
- 30:18Michelle Long: He went in and founded Reconciliation with Prophecies and moved it to office supplies.
- 30:24Michelle Long: And I called him up, and I was like, David you did it again.
- 30:29Michelle Long: You forced that bank reconciliation.
- 30:30Michelle Long: He says, how did you know?
- 30:32Michelle Long: I said I told you I know everything Because that report or that screen where it says the reconciliation history Will still show you When they forced it, even though the little booger went in and changed it from reconciliation Discrepancies and moved it to office supplies.
- 30:52Michelle Long: I still could see in that You area when he forced the bank reconciliation.
- 30:58Michelle Long: So even though your client tries to pull one on you, QuickBooks helps you stay one step ahead of them.
- 31:06Dan DeLong: You're like Lord Morris.
- 31:07Dan DeLong: You have little birds in, in, in QuickBooks that tells you.
- 31:13Dan DeLong: Tells on people.
- 31:15Michelle Long: So there are these little tools that we take for granted that are very helpful when you have sneaky clients.
- 31:24Matthew Fulton: Okay, and it looks like we've got 100 percent there.
- 31:27Dan DeLong: All right.
- 31:28Dan DeLong: And yeah, it's, the biggest one is 55 percent of zero to 19%.
- 31:36Dan DeLong: And I think I saw in the comments that it's unreliable.
- 31:41Dan DeLong: Some of the, things about about statement fetching in general.
- 31:46Dan DeLong: And we'll talk a little bit about maybe some of the tech behind that.
- 31:50Dan DeLong: But, but yeah, it's when it worked.
- 31:55Dan DeLong: It's great.
- 31:56Matthew Fulton: It's a good point.
- 31:57Matthew Fulton: Yeah.
- 31:58Matthew Fulton: so let me go back to our share here and so the next area I really want to share about is specialized workflows and One of the things that drive me nuts in the program are the transfers and the credit card payment options Transfers are always the problem Always the problem you need to make every time you have it and because it's trying to link to two different pieces I've seen where somebody's managed to match four transfers In one account to one transfer on one other side somehow And things and balances get completely knocked off and it's just very difficult to find those unless you undo them And really like it becomes faster just to get rid of them and put it back in But i'll show you some tricks that I have on that Additionally, deposit detail reporting.
- 32:55Matthew Fulton: I've got the way we do deposits.
- 32:58Matthew Fulton: I feel it's a little bit of an extra step, but it saves a lot of time.
- 33:03Matthew Fulton: It helps you capture any situation where an owner is investing money in the business or taking it out.
- 33:09Matthew Fulton: And then of course, you've got your merchant processing.
- 33:11Matthew Fulton: If you're using external merchant processing, are they batching transactions together?
- 33:16Matthew Fulton: Are they taking the fee out at the same time, or is it a separate fee?
- 33:21Matthew Fulton: Your third party applications the order in which you do all of anything with the third party apps becomes super important So for the this is one that i've been talking about this forever, especially with bank rules It makes the most sense to do this Why the way we do every transfer is we will create a vendor every time we create a clearing account first And then we create a vendor that will be You Transfer to one, two, three, four transfer from five, six, seven, eight, where the last four digits of the last four digits of the account that gives me the ability to create money in money out rules and you set it up where you've got multiple parts of bank text.
- 34:09Matthew Fulton: It's always bank text contains transfer to.
- 34:13Matthew Fulton: The next one, the numbers, and by doing this, it goes from one into a clearing, out of the clearing, to the other, and because of the rules, it's just as efficient as the transfers, but you get names on all your transactions, and you get to see the in and out very easily.
- 34:32Matthew Fulton: So you can go back and reconcile this stuff very fast.
- 34:36Matthew Fulton: I can't
- 34:36Dan DeLong: see that easily at all
- 34:38Matthew Fulton: But
- 34:44Dan DeLong: I think that I want to talk a little bit about you know The challenge right of what you're talking about Because this is a unique situation where you have potentially both sides of the transfer connected in your bank feed and those rules Thank you it really gets And, it, really who, acts on it first, right?
- 35:09Dan DeLong: So if it's a savings account that automatically puts it in through the, to the checking account, because you've set up a bank rule to do or the checking account, the savings account or credit card to the checking account it's whoever gets to it first.
- 35:25Dan DeLong: And then it causes other challenges if it's not a transfer what am I doing seeing a deposit with a negative amount.
- 35:35Dan DeLong: In my checking account, right?
- 35:36Dan DeLong: Because it's, money coming in or out and it gets recorded as a deposit or an expense that is adding money to a, register.
- 35:47Dan DeLong: It can just look really confusing, especially if you're not expecting it to be that way.
- 35:52Dan DeLong: So I really like what you're, talking about here with setting something up in between, as a go between.
- 36:00Dan DeLong: So that.
- 36:01Dan DeLong: You can take advantage of those rules, and then it really doesn't matter what kind of transfer what kind of transaction it is.
- 36:08Dan DeLong: It could be a transfer, it could be a deposit, it could be an expense, it could be a check, or whatever, right?
- 36:12Dan DeLong: And then it's fine to, from that account perspective.
- 36:17Matthew Fulton: Yeah.
- 36:18Matthew Fulton: The worst part about this, I cannot tell you how many times I've caught new accounts we were never told about because of doing it this way.
- 36:26Matthew Fulton: That's the best and the worst.
- 36:27Matthew Fulton: It's the best because you caught it.
- 36:28Matthew Fulton: It's worse because now you have historical stuff you have to put in.
- 36:30Matthew Fulton: You have to have the conversation like you, what do you mean you ordered, opened up three new credit card accounts.
- 36:34Matthew Fulton: You didn't tell me about it yet.
- 36:35Matthew Fulton: So it, again, if you're doing it it's, going to zero itself out every time.
- 36:41Matthew Fulton: So at the end of the month, you have to reconcile that account back down.
- 36:45Matthew Fulton: If there's anything left, either somebody invested money in the business, or they took it out to a non business account or an account is missing.
- 36:56Matthew Fulton: So my logic to that part michelle, what are your thoughts there?
- 37:03Michelle Long: I think that's a great process to follow and that's the most important thing is to have a process And do it one way all the time consistently because that helps eliminate duplicates Otherwise you're doing it from this account and from that account and then you're getting duplicates and all that So I think that's
- 37:20Matthew Fulton: a great tip though.
- 37:21Matthew Fulton: Thank you for sharing
- 37:21Michelle Long: that
- 37:22Matthew Fulton: put all the problems in a bucket,
- 37:23Michelle Long: right?
- 37:24Matthew Fulton: so Love it.
- 37:27Matthew Fulton: So I already talked about this piece that by doing it, it gives you the different Having it.
- 37:32Matthew Fulton: I always do all the transferables as a vendor and having names on it Every transaction should have a name every single transaction Because if you have problems or challenges, you have to do the research you have more tools to do stuff The next one I wanted to go into is dealing with deposits.
- 37:50Matthew Fulton: And this is, again, this is a unique one.
- 37:53Matthew Fulton: The ultimate goal here is we have to be able to do the reconciliations.
- 37:58Matthew Fulton: And a lot of the times duplicates, as we mentioned before, can come into play.
- 38:02Matthew Fulton: Because if you have multiple payments by customers combined into one deposit, your bank, if you accept the bank feed piece that will match that comes in, but then you have your undeposited funds and starts growing, right?
- 38:16Matthew Fulton: Everything else.
- 38:17Matthew Fulton: Or if you're creating multiple deposits, one for each person, they're never going to match easily.
- 38:23Matthew Fulton: And it drives me nuts when you have.
- 38:25Matthew Fulton: Three different individual deposits that are selected because you remember that those matched to the one single number.
- 38:33Matthew Fulton: But if I ever have to come back later and I'm doing it, I'm not going to know it.
- 38:37Matthew Fulton: So we create an account I call revenue query.
- 38:41Matthew Fulton: It's just because you can't create rules for uncategorized income unless that changed recently.
- 38:47Matthew Fulton: And what it allows me to do is basically take all of my deposits quickly and toss them right into a revenue query account.
- 38:56Matthew Fulton: Then, with all this stuff put into the bucket, I can come through, and as part of my end of the month close process, I pull up a deposit detail report, and I can then have pull up all the different images, if there's multiple checks, and go and actually check off the correct pieces that tie into it, and spe you like, spend down that revenue query.
- 39:21Dan DeLong: And what type of account is is, Revenue Query?
- 39:25Matthew Fulton: It's a different income account, so it still sits up in the, basically it sits up in your income area.
- 39:30Matthew Fulton: Because when you, when it's in there, you know that's always supposed to be knocked down to zero, is the, whole point.
- 39:39Matthew Fulton: As you start to spend these down, it should equal the same amount when you put it to Revenue Query in the bottom.
- 39:46Matthew Fulton: So you've got revenue query.
- 39:48Matthew Fulton: When you do a, you go pull up your deposit detail.
- 39:51Matthew Fulton: If it's not broken down with the names in here is so vendors, if it's a refund would have a name as well.
- 39:58Matthew Fulton: You click on the top line.
- 40:00Matthew Fulton: You would then come in, find the pieces, check them off.
- 40:03Matthew Fulton: And then come down here click off the trash can get rid of it doesn't break the reconciliation So you can actually go through clear out your bank feeds reconcile And still go back and clear this out before you finish your month end all the way
- 40:21Dan DeLong: You're getting some kudos in the chat there.
- 40:24Dan DeLong: That's nice
- 40:25Matthew Fulton: It's such a big It just helps save so much time because the other part of this also is This is the same kind of a concept that if you're using a stripe or something else and you have a customer sales receipt for 350, but the amount that came through the deposit was 345, you can actually do check off the 350 merchant fee at the bottom minus five.
- 40:56Matthew Fulton: Now it pops it right back in, didn't break the reconciliation, saves you a bunch of time.
- 41:01Matthew Fulton: It's all about getting these different problems in a controlled bucket.
- 41:07Dan DeLong: And, somebody mentioned in the chat and don't peek at the P and L because your, revenue will be overstated.
- 41:15Dan DeLong: How do you coach your client about that?
- 41:18Dan DeLong: Because then you can look at it and you, at least you know what you're looking for, but how do you avoid questions from the client?
- 41:25Dan DeLong: Wait a minute, what's this revenue query?
- 41:27Dan DeLong: And do you Just frame that up upfront.
- 41:31Matthew Fulton: Yeah because usually when I'm having to do more of this, it's because they're not getting sales receipts or invoices in on time to be able to match things right away.
- 41:41Matthew Fulton: And we always try to, we train them and let them know what we're doing.
- 41:44Matthew Fulton: So it's a don't stress on this until.
- 41:47Matthew Fulton: This is the other option where most people would do this is they put this into ask my accountant or ask client name and now you have deposits in an expense and It's weird.
- 41:58Matthew Fulton: Do your financial still work the same?
- 42:00Matthew Fulton: Yeah, but it's wonky.
- 42:02Matthew Fulton: So I Like it up at the top because it's a spend down if it's a cruel based and you haven't created any of the sales receipts or invoices It's still right if it's cash basis and this stuff isn't in there.
- 42:20Matthew Fulton: It's still right.
- 42:21Matthew Fulton: It's only when you're actually having both the invoice in there and On a cash basis, right?
- 42:31Matthew Fulton: And then you've also got the revenue query That would double your income until you spend it away to match the payments.
- 42:38Matthew Fulton: That's it.
- 42:39Matthew Fulton: I think I said all that Michelle?
- 42:45Michelle Long: Yes, that's right, sorry, I was looking for the mute button.
- 42:48Michelle Long: Yes, that's right, but I wasn't listening closely because I was also talking about sheet laws in the chat, or on the Q& A, but yes, that sounded correct.
- 43:01Matthew Fulton: So we're pretty close.
- 43:03Matthew Fulton: I think we're doing okay.
- 43:04Matthew Fulton: Time wise on all this stuff here.
- 43:06Matthew Fulton: Let's see here.
- 43:07Matthew Fulton: So then the last part again, syncing with third party apps, we could be here for the rest of the day and talk about a lot of these different things.
- 43:17Matthew Fulton: What it all comes down to is truly understanding what the workflow is.
- 43:22Matthew Fulton: This is why I like doing workflow design is figuring out, okay, The beautiful thing about QuickBooks Online and cloud based accounting is, it's a database in the sky.
- 43:33Matthew Fulton: And they can allow different apps that specialize in different areas to connect and handle the hard parts of the workflow.
- 43:40Matthew Fulton: You just need to make sure which data gets accepted first through the banking area so it can match correctly.
- 43:48Matthew Fulton: So again, like a A2X for e commerce, a bookkeep's going to create journal entries.
- 43:54Matthew Fulton: When you do your mapping, you want to make sure whatever is hitting through the journal entry, Always try to make it match exactly what's the bank the actual bank feed.
- 44:02Matthew Fulton: It just makes you a lot happier that's pretty much the same for all of these different type of programs Just keep that in mind and will help save you a lot of time.
- 44:11Dan DeLong: Yeah, and when you've added more More, apps let me launch the poll and I'll talk about that.
- 44:19Dan DeLong: Which one do you use transfer?
- 44:21Dan DeLong: There we go.
- 44:23Dan DeLong: Noom changed something again love when technology changes.
- 44:30Dan DeLong: And now I have more poll questions than I actually created poll questions for the webinar, but now I got to find more than one.
- 44:38Dan DeLong: Yes, it's Michelle and I forgot what I was talking about before I launched a poll.
- 44:52Dan DeLong: What was what were we?
- 44:53Dan DeLong: Oh, when you have multiple apps.
- 44:59Dan DeLong: And, knowing exactly like you were saying, what, where that is going to take place and if there is a shortfall in, in that integration like I'm, working with, you mentioned bookkeep there, right?
- 45:17Dan DeLong: And, understanding.
- 45:19Dan DeLong: That, that's going to only bring in journal entries, right?
- 45:22Dan DeLong: And how, is that, automation potentially limiting some of the workflows that you would be doing inside of QuickBooks, or is there a, like some of the sender or, some of the sales connectors, they're, mostly concerned with just getting the sale into QuickBooks, but then that passing the baton of taking it to the payout, picking up the fees and those types of things they're not too concerned with.
- 45:55Dan DeLong: So really understanding what, that integration will actually look like when you see it in, in, inside of QuickBooks so that you can take it to the goal line of I want to reconcile, right?
- 46:09Matthew Fulton: This made me also think about 0 sales receipts.
- 46:12Matthew Fulton: But first, I actually would like to, there's a good question that was asking about talking about reconciliations for QuickBooks checking.
- 46:20Matthew Fulton: And I have to be honest.
- 46:22Matthew Fulton: I don't really use it.
- 46:24Matthew Fulton: And the clients I have are not using it.
- 46:27Matthew Fulton: So I'm not as familiar with that piece.
- 46:28Matthew Fulton: I wish I could give answers to it.
- 46:29Matthew Fulton: But Dan, Michelle, might you have some guidance on it?
- 46:34Dan DeLong: The way it started, right?
- 46:37Dan DeLong: The whole idea when it was QuickBooks Cash, right?
- 46:41Dan DeLong: And then it turned into QB checking.
- 46:45Dan DeLong: Accountants got the where the afterthought, of that problems and they're a little, bit of foreshadowing
- 46:57Michelle Long: there.
- 46:57Michelle Long: Maybe,
- 47:00Dan DeLong: But like the accountants couldn't access the account at all, right?
- 47:04Dan DeLong: Like it was initially set up as a business owner or primary admin only could have access to that.
- 47:11Dan DeLong: And then through feedback thank you for submitting all the feedback, accountants can have access to it, but there's still things in that, that you can't access.
- 47:24Dan DeLong: But yes, you can get.
- 47:26Dan DeLong: The statements now and you can, view the statements from as, an accountant.
- 47:31Dan DeLong: I use it myself, it's my business.
- 47:35Dan DeLong: So I I'm, one in the same on both sides of that.
- 47:39Dan DeLong: I don't have clients or people that where I'm just the, the accounting professional in that position to know some of the subtle nuances with regards to that, but that history.
- 47:53Dan DeLong: Make sense as to what where you might be finding that finding the shortfall.
- 48:00Dan DeLong: But you should have access to the statements as an, accountant and be so that you can get them, but you gotta get to them through the, banking side.
- 48:11Dan DeLong: It's not in the.
- 48:12Dan DeLong: They don't necessarily show up as statements that are fetched, but you should be able to access them through your client quickly.
- 48:20Matthew Fulton: Stay tuned for our last poll and you're going to understand why based on a question like that.
- 48:26Matthew Fulton: So I think we're pretty close on that one poll.
- 48:28Matthew Fulton: Do you want to share the last piece?
- 48:31Matthew Fulton: We're down towards the last little bit of the slides where we wanted to somewhat quickly talk about some.
- 48:37Matthew Fulton: Other technology, I think this starts to become more of open conversation and then if there are other things we want to pull up QuickBooks online to show, we can do that.
- 48:46Matthew Fulton: Of course, as well.
- 48:47Matthew Fulton: So thank you guys for all the interaction today and the questions.
- 48:50Matthew Fulton: Honestly, it makes it more fun for all of us when everybody's having a good time.
- 48:57Matthew Fulton: Different tools and again, we could do a whole series on just something like this.
- 49:04Matthew Fulton: LedgerSync and of tools for collecting and working with the data.
- 49:08Matthew Fulton: Full disclosure, I like to always do that at the beginning.
- 49:10Matthew Fulton: I've been working with, I've been using LedgerSync since 2015, 2016.
- 49:15Matthew Fulton: I'm very proud to say I'm now a consultant, a paid consultant with them.
- 49:18Matthew Fulton: I'm not here in that role today, but I've been working with them to help them build out their own global rules engine, which is designed to help us basically create rules that can live across all your clients at once instead of having to go in and out of every single company file and work in process transactions.
- 49:35Matthew Fulton: Now what ledger sync really its core functionality for the longest time has been is fetching your transactions, your statements, and your images, checking deposit images.
- 49:44Matthew Fulton: There were other apps like this in the past.
- 49:47Matthew Fulton: Hubdoc, everybody was a big, fan of that, right?
- 49:50Matthew Fulton: Hubdoc still exists, but they don't really do the fetching part.
- 49:54Matthew Fulton: FileThis, is gone.
- 49:56Matthew Fulton: Most every company that's out there.
- 49:59Matthew Fulton: They've all gotten out of the game because it is so difficult through all these different financial institutions to stay connected.
- 50:06Matthew Fulton: We even partner with MasterCard to connect with over 10, 000 institutions to grab statements, and I got some bad news for everybody.
- 50:13Matthew Fulton: They're making it tougher and tougher to keep getting the statements.
- 50:17Matthew Fulton: I will not be surprised if we see a dip in statement availability in QuickBooks online as well.
- 50:22Matthew Fulton: We'll not be surprised.
- 50:23Matthew Fulton: Is that
- 50:24Dan DeLong: a.
- 50:24Dan DeLong: Is that a financial institutions decision or is that more of a distant, security or both?
- 50:34Dan DeLong: Like it's trying to make it more difficult for.
- 50:37Dan DeLong: Bad actors to get into this information
- 50:42Matthew Fulton: So what it has to do with primarily is back in the day With all the statement fetching everything else That's because everybody was going in through the front door screen scraping and grabbing this information pulling it back to you As more institutions move over to an api an approved handshake behind the scenes That is providing the transactional data but they are still scraping the statements is what's been happening through all this.
- 51:06Matthew Fulton: So Fiserv Finicity MasterCard Plaid, I know more about this stuff than any human ever should.
- 51:16Matthew Fulton: Thanks to Maurice and LedgerSync and how it works back in the day.
- 51:19Matthew Fulton: For example, you guys might remember Wells Fargo a long time ago for the bank feeds when they started putting in the pre approved authorization on XXDateXX.
- 51:28Matthew Fulton: Do you know they did that just to stuff the bank memo so you'd have to go to the bank to download it and have It be useful.
- 51:33Matthew Fulton: Thank you I won't hound on that.
- 51:38Matthew Fulton: Yeah.
- 51:38Matthew Fulton: Thank You know true authenticity wells fargo.
- 51:41Matthew Fulton: Thank you.
- 51:42Matthew Fulton: Okay So There's a lot of different tools out there that will actually help and grab some of this stuff dan, you've been testing out bot keeper and some of their bosses, right?
- 51:54Matthew Fulton: so i'd love to let you talk about that because You Yeah.
- 51:59Dan DeLong: I talked to the folks at Botkeeper and really tried to understand what the heck Botkeeper actually is, and and they, invited me to be a beta tester for them and they are rolling out a function called auto bank rec, where they will actually.
- 52:20Dan DeLong: Fetch the statement if it's supported, right?
- 52:24Dan DeLong: That's all the, caveat if it's, if the statement is, supported, it also can be uploaded into their, portal, but what it will allow you to ultimately do is see that.
- 52:35Dan DeLong: The general ledger or their bank feed side by side with the, statement.
- 52:42Dan DeLong: And then you can just either confirm it, it'll either try to match it'll match the transaction or tell you, okay, there's some discrepancies with the statement.
- 52:51Dan DeLong: You can bring up the statement and see see for yourself, if, it's there the, really cooler part of it is that, If it doesn't support statement fetching or if it doesn't even support, connecting to to a bank feed and you have access to the statement, you can upload the statement and still use that auto bank rec option.
- 53:17Dan DeLong: It'll just look at what's in QBO at the time and allow you to compare, and.
- 53:24Dan DeLong: It's in beta.
- 53:26Dan DeLong: So let me preface that it's being a beta tested.
- 53:31Dan DeLong: So there are some beta things to it.
- 53:34Dan DeLong: And some of the challenges with, you mentioned paying down credit cards, like it can't see that type of transaction, but they're working on fixing that.
- 53:44Dan DeLong: So when you know, when it rolls out it might be a really cool ad to be able to do that.
- 53:51Dan DeLong: And BotKeeper does other things too in that portal.
- 53:56Dan DeLong: And that's not its only thing.
- 53:59Matthew Fulton: So you're basically saying sometimes these apps can neither confirm nor deny if they're getting it, right?
- 54:05Dan DeLong: exactly But it was cool.
- 54:08Dan DeLong: It was cool because I'm testing it out with Corpay is a MasterCard.
- 54:13Dan DeLong: They don't connect to QuickBooks online for bank feeds and their statement That they give you is oriented in two different orientations horizontal portrait and landscape.
- 54:27Dan DeLong: And and it's able to actually read that.
- 54:32Dan DeLong: It is?
- 54:33Dan DeLong: And, yes.
- 54:35Dan DeLong: Surprisingly, I didn't think you were going that way.
- 54:37Matthew Fulton: Okay.
- 54:37Matthew Fulton: Yeah.
- 54:38Matthew Fulton: That's impressive.
- 54:39Dan DeLong: Okay.
- 54:39Dan DeLong: I'm like here's a fun one for you.
- 54:43Dan DeLong: And I uploaded the statement and, lo and behold, it's got transactions from the statement side for me to match and it's got the information in it.
- 54:52Dan DeLong: That's actually, sideways if you actually looked at the PDF.
- 54:58Matthew Fulton: They need to turn that thing upside down or whatever they say.
- 55:01Matthew Fulton: Relay, other online banking they of course give you the access to the images and statements as they, for their specific accounts.
- 55:12Matthew Fulton: I could spend, I could have made a whole bunch of other tools on here as well.
- 55:17Matthew Fulton: The ones I wanted to share right off the bat is Money Thumb.
- 55:21Matthew Fulton: Hands down, the best I've ever used for their OCR technology, PDF OCR technology.
- 55:29Matthew Fulton: And what I mean by that very specifically.
- 55:32Matthew Fulton: You've got paper statements, you scan them in, and they're not a first edition digital line item, nice and clean.
- 55:40Matthew Fulton: This will do a better job on statements than anything else I've seen.
- 55:44Matthew Fulton: The only other thing that's probably close, but it's not really for statements, has been makers up.
- 55:49Matthew Fulton: Their ocr large language model is pretty dang impressive so really like it They can convert to csv files or dot qbo files And there's a lot of tools inside of that of how you manipulate and use it.
- 56:03Matthew Fulton: I've got videos on my youtube channel I'm sure There's a couple other ones hector's done as well proper soft I would recommend Buy their suite.
- 56:14Matthew Fulton: This is one of those things.
- 56:15Matthew Fulton: I think it's right now 200 bucks for their whole lifetime version of all of their different converters Just have it ready to go You never know if you're going to need to go to a csv to a qbo to an ofx to a blah blah blah Really great tool dext is another one that does the statement ocr parsing I believe they're still doing that inside of the program, right if anybody knows so those are three just quickies to to share as well And last one, which was 74 percent said yes for using transfers in another, I think
- 56:50Dan DeLong: I, I did share for a little bit.
- 56:55Matthew Fulton: All right.
- 56:56Dan DeLong: And this was, part of the challenge when, Matt and I were talking about, what are we going to talk about here is that there is definitely a rabbit hole.
- 57:06Dan DeLong: That we could go down as far as the nuances of the bank feeds, and it's been a while since Michelle and I had done ruling the rules in, in, in QuickBooks online, and really just talking about some of the technology behind the rules that you can and the bank feeds that when you take Advantage of that tool, it's either going to make create some efficiencies for you, or it's going to make your life a living hell.
- 57:38Dan DeLong: If you, do it improperly.
- 57:41Dan DeLong: And so we were thinking maybe this is a series that we have Matthew come on and do this sort of thing.
- 57:49Dan DeLong: And would you be interested in that?
- 57:51Dan DeLong: Yeah.
- 57:51Dan DeLong: Do we talk about, Talk about that.
- 57:54Dan DeLong: Do we do we go into some of these apps a little bit deeper?
- 58:00Dan DeLong: What, would be, what do you want, right?
- 58:04Matthew Fulton: I, yep.
- 58:05Matthew Fulton: And as I'm going to, we're going to finish the poll there.
- 58:08Matthew Fulton: I'll finish the last couple of slides.
- 58:10Matthew Fulton: Cause I know I always like to try to keep us right on the time as best possible for everybody's, schedule the day.
- 58:16Matthew Fulton: So back to you, Dan.
- 58:20Dan DeLong: Yeah.
- 58:21Dan DeLong: Always check us out at the QB power hour.
- 58:23Dan DeLong: com website.
- 58:26Dan DeLong: But there is something right there on the, homepage where you can put in, suggestions for things that you want us to talk about or unpack.
- 58:37Dan DeLong: Matthew, I really appreciate you joining us here today and all the hard work that you put into today's lesson.
- 58:46Dan DeLong: And hopefully there's some, if the chat is any indication there, there is some definite, nuggets, that, people took away from from today and Shel, always great to see you as well.
- 59:01Michelle Long: Yes.
- 59:01Michelle Long: Thank you.
- 59:02Michelle Long: Thank you.
- 59:02Michelle Long: Good to see you, Dan.
- 59:03Michelle Long: And thank you, Matt, for joining us.
- 59:05Michelle Long: Thank you both for everything.
- 59:06Michelle Long: I've got to run.
- 59:07Michelle Long: Thanks everybody.
- 59:08Michelle Long: See you soon.
- 59:10Dan DeLong: All right.
- 59:10Dan DeLong: Have a great day, everyone.
- 59:11Dan DeLong: We'll see you next time on the QB power.