Quickbooks Categorization Insights using AI - FountIQ 🐚
32views
Quickbooks Categorization Insights using AI - FountIQ 🐚
Birchstone Advisory
The Bookkeeper's Categorization GPT
Quickbooks Categorization Insights using AI - FountIQ 🐚
Birchstone Advisory
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, 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:20
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:02
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, 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.
04:02
But step by step I think that we could get through this pretty easily.
04:09
Okay but let's just ask 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 however let's just see 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 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 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.
08:28
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 🐚