As a small business who has spent way tooooo much time trying to do this myself for years because I cannot afford a bookkeeper, I THANK YOU x 1000000000000.
Great tool for speeding up the process. Only problem is I'm unable to include refunds or credits, There is no column for that nor can you add the transaction as a negative.
Outstanding... thanks for sharing... trying to take all transactions from different credit card providers and bank accounts to normalize into a giant list to split these transactions between 3 different businesses and personal expenses. This should be a great time saver, great find on the extension!🎤💧
Thank JD! You bet - I just learned about PromptLoop the other day that might work. You can also check out Kevin's video linked below. www.promptloop.com/ czcams.com/video/b-cFv2DvEqE/video.html
hello, I'm going to be off topic, but my question still concerns Google sheet and artificial intelligence, could you advise me a method so that chatgpt describes to me the images that I put in my Google sheet? anyway thank you very much for your videos
Great spreadsheet ... Transaction 6 and 8 though are both Meals and entertainment. What happens if one is deleted ... or should I just use one consistently?
Hi Anne - sorry I don't fully understand your question. It's always good to be consistent with categorizing transactions. If you follow up here to clarify, I can hopefully help further!
Hi there - the short answer is that PST paid on expenses just ends up as part of the expense instead of breaking it out like you do with GST. For example, if you buy a stapler for $20 plus GST and PST, you would record: $20.00 (cost of staples) as an office expense $1.40 (the PST) as an office expense (it just becomes part of the stapler cost) $1.00 (the GST) gets recorded as GST payable to be claimed on a GST return (assuming you're registered for GST). Hope that's helpful!
As a small business who has spent way tooooo much time trying to do this myself for years because I cannot afford a bookkeeper, I THANK YOU x 1000000000000.
Woohoo! So glad this was helpful.
So glad I found this exactly what I needed ai for my bookkeeping this year . Trying to separate personal from business has been a challenge. thank you
Hey Jerica - glad it was helpful!
This is excellent info. Please do more videos like this that save so much time! 👍🏼
Great tool for speeding up the process. Only problem is I'm unable to include refunds or credits, There is no column for that nor can you add the transaction as a negative.
Hi! is there a way to set this up monthly so that way a P&L is generated on a monthly and the AI tool can still be used?
Outstanding... thanks for sharing... trying to take all transactions from different credit card providers and bank accounts to normalize into a giant list to split these transactions between 3 different businesses and personal expenses. This should be a great time saver, great find on the extension!🎤💧
Awesome, glad it will be helpful!
this looks so oh oh oh involved
Thank you very much for sparking the idea 😍
this is GOLD! Wish I'd have seen it 2 days ago... would have saved me ~8 hours of tedious work!! Is there anything similar for excel?
Thanks!
Thank JD! You bet - I just learned about PromptLoop the other day that might work. You can also check out Kevin's video linked below.
www.promptloop.com/
czcams.com/video/b-cFv2DvEqE/video.html
WOuld this work for the US as well -- not sure if there many bookkeeping differences between the usa/ can
You are the coolest accountant ever.
Hey Tim, thanks so much for that! Glad to have you here with us :D
Doesn't quickbooks online already have this set up in its software?
With learning rules as well?
hello, I'm going to be off topic, but my question still concerns Google sheet and artificial intelligence,
could you advise me a method so that chatgpt describes to me the images that I put in my Google sheet?
anyway thank you very much for your videos
Thanks
Great spreadsheet ... Transaction 6 and 8 though are both Meals and entertainment. What happens if one is deleted ... or should I just use one consistently?
Hi Anne - sorry I don't fully understand your question.
It's always good to be consistent with categorizing transactions.
If you follow up here to clarify, I can hopefully help further!
Thanks for the great info
That is very cool. Thanks!
Thanks Amit - glad you like it!
Is this based in the USA?
If you operate in BC canada do you need to also track the PST paid for your expenses or just the GST ?
Hi there - the short answer is that PST paid on expenses just ends up as part of the expense instead of breaking it out like you do with GST.
For example, if you buy a stapler for $20 plus GST and PST, you would record:
$20.00 (cost of staples) as an office expense
$1.40 (the PST) as an office expense (it just becomes part of the stapler cost)
$1.00 (the GST) gets recorded as GST payable to be claimed on a GST return (assuming you're registered for GST).
Hope that's helpful!
@@AvalonAccounting Thanks for this
i tried it but it gives unusable bad results