Quickbooks Categorization Insights using AI - FountIQ ๐
5 views
Quickbooks Categorization Insights using AI - FountIQ ๐
Birchstone AdvisoryยทMar 20, 2026
The Bookkeeper's Categorization GPT
Chapters
00:00
Introduction to Categorization
Setting up the categorization tool for client bookkeeping.
01:03
Identifying Transaction Errors
02:21
Addressing Double-Counting Issues
03:35
Liability and 1099 Considerations
04:13
Remediation Plan
05:12
CPA Consultation and Summary
Transcript
00:00
Okay, so we're back here in our product section, and, we're going to work on the categorization at GPT.
00:09
We're going to head and launch the tool here, and it brings us right to it.
00:14
And we'll do a little refresh to, get it started there, get it kick started, and let's go ahead and get going.
00:21
So I'm just going to talk to it, and then I will copy and paste, a transaction here or there.
00:28
So I'm reviewing my client's books, and she's an interior designer, she's a sole proprietor.
00:34
And there's that one transaction, a Chase credit card for $2841.76 on January 15th.
00:44
So the previous bookkeeper recorded it as a credit card expense.
00:49
Something about that doesn't look right to me.
00:51
So, can you check?
01:08
I didn't, paste the transaction, but let's just see what happens.
01:18
don't like red.
01:19
Red X's.
01:20
Let's see here.
01:23
mis categorization.
01:25
Right.
01:25
Credit card P payments are not expenses.
01:29
Okay, let's see here.
01:36
See, it exceeds the 2500 de minimis.
01:39
So we got to fix this.
01:41
Duplicate.
01:42
Duplicate entry check.
01:43
Okay, so.
01:46
no.
01:46
no.
01:47
so every single purchase on her credit card was already recorded as an expense when she swiped it, and then the payment was also recorded as an expense.
01:56
That means everything is doubled.
02:06
See what it says here?
02:24
Okay, so if they're recorded Expensive.
02:27
Yeah, it's double counting.
02:30
All right.
02:33
okay, so we got to worry about 1099 too, right?
02:45
So we got to move this stuff over to the liabilities.
02:48
so this has been happening for eight months in the previous bookkeeper did this every single month.
02:54
So how do I fix all of them?
03:10
All right, so, yeah, it's going to be fixable.
03:13
So it's good.
03:15
And, and so the bot is going to walk us through how to do it.
03:20
And, so we're gonna have to identify it.
03:24
Then we're going to reclassify everything using the, Reclassify Transactions tool, and it shows us how to do that.
03:34
And then we're going to have to do a retroactive reconciliation, and then we're going to have to clean up some of the rules to make sure that it is.
03:43
you know, that the rule routes properly.
03:50
And then we have to look at the $2,500 threshold as well as the 1099 to make sure we clear those.
03:58
And, so lots of stuff to go through, but step by step.
04:04
I think that we could get through this pretty easily.
04:09
Okay but let's just ask.
04:12
So that's a lot of cleanup.
04:14
should I flag this for my CPA or do you think I can handle it myself?
04:26
Did mention that should only take about 10 minutes.
04:29
However let's just see.
04:32
I think that it's going to take longer than 10 minutes.
04:43
so yeah it's, it's probably best to flag this with cpa make sure that they're understood and they can double check everything Right.
04:52
So reclassify, reconcile and then identify the shift in net income because it's going back eight months and it looks like 22,000 in taxable income possibly just not great eight months.
05:09
So possibly could have rolled over on a previous tax year.
05:12
So all of this is really good stuff to get flagged on.
05:16
It's really important to kind of pay attention to that.
05:19
So that is that.
05:25
Okay, so here is another one.
05:27
I got a lot of transactions.
05:28
This is actually a batch transaction.
05:30
So can you help me categorize this week's transactions for my landscaping client?
05:35
They're a, they're sole proprietor.
05:38
they have three crew members on the, on the payroll.
05:42
And they are.
05:44
Let me get, let me get the transactions here.
05:57
Okay, just paste that in.
05:59
Let's just see.
06:10
These are large transactions, so, let's just see what it comes up with.
06:21
Okay.
06:22
great chart.
06:23
Good.
06:23
Let's see.
06:28
All right, so let's just kind of go through this.
06:31
L.
06:31
So cogs.
06:32
That's right.
06:34
Expense for vehicle, Home Depot.
06:37
What is that?
06:40
Check that.
06:40
And then Chipotle, 50% deductible.
06:44
And then state tax commission is not what's going on there.
06:49
I check it.
06:50
And then, looks like the, contract labor.
06:56
you know what, Actually, I think that I over.
07:00
I, had a bunch of transactions and I over.
07:02
copied.
07:03
So let's just say ignore the state tax and the web designer from another client.
07:19
All right, and then what?
07:20
Let's see here.
07:21
But the other one that stood out to me was this Home Depot one, which is interesting.
07:25
Let's see, it looks like Home Depot.
07:31
See here, Safe harbor.
07:39
fixed assets.
07:40
Whoa.
07:40
Okay, hold on.
07:43
So, for the Home Depot one, let's see, he bought a new commercial lawnmower.
07:49
It's just one item.
07:51
$3,127.
07:53
So that's a fixed asset.
08:06
See what it says here?
08:18
Yeah, there we go.
08:19
Yeah, those are gone.
08:24
that's 2500.
08:25
Yeah, of course.
08:27
De minimis, Safe harbor.
08:29
So we fixed that.
08:30
So that's good.
08:31
But then the other one is a, Chipotle.
08:33
So let's, let's inquire about that.
08:35
So for the Chipotle, it was lunch for the crew after a big install job, it was all four of them.
08:41
So that's 50% deductible.
08:43
Correct.
09:01
Yep.
09:02
That works.
09:04
Four crew members, lunch.
09:06
All right, great.
09:07
So everything is green.
09:09
We are looking good.
09:15
thanks, so much.
09:17
It's faster than doing them one by one.
09:19
Can I send you batches like this every single week?
09:42
Beautiful.
09:45
So this is all good.
09:50
thank you.
Comments
Comments
No comments yet
Quickbooks Categorization Insights using AI - FountIQ ๐