Bookkeeping with AI and Google Sheets

Рет қаралды 18,451

Күн бұрын

Пікірлер: 29

@DerpGear 10 ай бұрын

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.

@AvalonAccounting 10 ай бұрын

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-kd8fe5hh9p 8 ай бұрын

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

@crystalmethshrimp 7 ай бұрын

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

@TimArmstrongmarketing 5 ай бұрын

You are the coolest accountant ever.

@AvalonAccounting 3 ай бұрын

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!

@richrosen9437 10 ай бұрын

WOuld this work for the US as well -- not sure if there many bookkeeping differences between the usa/ can

@moemaya9499 7 ай бұрын

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