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.
@AvalonAccounting10 ай бұрын
Woohoo! So glad this was helpful.
@jericac7406 Жыл бұрын
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
@AvalonAccounting Жыл бұрын
Hey Jerica - glad it was helpful!
@cryptobeat1 Жыл бұрын
This is excellent info. Please do more videos like this that save so much time! 👍🏼
@badral-balushi5911 Жыл бұрын
Thank you very much for sparking the idea 😍
@StilwaterGroup Жыл бұрын
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!🎤💧
@AvalonAccounting Жыл бұрын
Awesome, glad it will be helpful!
@user-kd8fe5hh9p8 ай бұрын
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?
@BuddyBearCreatorАй бұрын
this looks so oh oh oh involved
@crystalmethshrimp7 ай бұрын
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.
@jdcrouse_official Жыл бұрын
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!
@AvalonAccounting Жыл бұрын
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/ kzfaq.info/get/bejne/mJOTedljqdypoXk.html
@TimArmstrongmarketing5 ай бұрын
You are the coolest accountant ever.
@AvalonAccounting3 ай бұрын
Hey Tim, thanks so much for that! Glad to have you here with us :D
@EricAlHarb Жыл бұрын
Thanks
@AJ-qz7xo Жыл бұрын
Thanks for the great info
@amitdhawan579 Жыл бұрын
That is very cool. Thanks!
@AvalonAccounting Жыл бұрын
Thanks Amit - glad you like it!
@richrosen943710 ай бұрын
WOuld this work for the US as well -- not sure if there many bookkeeping differences between the usa/ can
@moemaya94997 ай бұрын
Doesn't quickbooks online already have this set up in its software? With learning rules as well?
@annegilpin2993 Жыл бұрын
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?
@AvalonAccounting Жыл бұрын
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!
@canadianbnb Жыл бұрын
If you operate in BC canada do you need to also track the PST paid for your expenses or just the GST ?
@AvalonAccounting Жыл бұрын
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!
@canadianbnb Жыл бұрын
@@AvalonAccounting Thanks for this
@SD-rg5mj Жыл бұрын
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