Free Bookkeeping Template | Excel and Google Sheets

Free Bookkeeping Template | Excel and Google Sheets | Step by Step Guide

Рет қаралды 45,470

Күн бұрын

Learn how to use our free bookkeeping template in Excel or Google Sheets. This template is super easy to use with our step-by-step guide for beginners.
Free Bookkeeping Template: www.avalonaccounting.ca/free-...
******************************
CONTENTS OF THIS VIDEO
00:00 - Intro
00:20 - Make a Copy or Download the Template
01:47 - Overview of Bookkeeping Tab
03:48 - Entering Transactions
05:48 - Download Your Transactions from Online Banking
07:36 - Paste Transactions Into the Sheet
08:39 - Enter GST/HST Amounts
09:10 - Tips on Keeping Receipts
09:27 - If Not Registered for GST/HST
09:49 - Record Expenses and Asset Purchases
12:49 - Record Revenue Transactions
14:13 - Review the Income Statement
14:47 - Home Office Expenses
18:00 - What About Capital Assets?
19:04 - Filing your GST/HST Return
21:45 - Customize Your Transaction Types
23:44 - Outro
******************************
LINKS FROM THE VIDEO
► View the Bookkeeping Template
www.avalonaccounting.ca/free-...
► Free Bookkeeping Template Blog Article
www.avalonaccounting.ca/blog/...
► Expenses vs. Capital Assets
www.avalonaccounting.ca/blog/...
► Small Business Bookkeeping Guide (Includes Home Office Info)
www.avalonaccounting.ca/blog/...
► How to File Your GST/HST Return
www.avalonaccounting.ca/blog/...
******************************
AVALON ACCOUNTING
Avalon is a virtual accounting firm located in Canada. We aim to be THE online accounting department for small businesses in Canada.
We provide online bookkeeping, accounting services and expert financial advice for small businesses.
We are on a mission to educate small business owners through our KZfaq channel, blog and free resources. Check out our links below to dive in.
******************************
🧑‍🏫 ONLINE COURSES
► Take your business to the next level with our online courses.
www.avalonaccounting.ca/courses
🏅 ESSENTIAL FINANCIAL CONCEPTS FOR SMALL BUSINESSES (🆓FREE COURSE)
► Keys to building a business that provides owners with time, money and purpose.
www.avalonaccounting.ca/cours...
🖥️ LEARN MODERN BOOKKEEPING
► Learn to do your own bookkeeping with modern tools and our proven practices.
www.avalonaccounting.ca/cours...
📈 BOOKKEEPING AND TAX FOR FREELANCERS
► This course teaches sole proprietors how to simplify bookkeeping and taxes.
www.avalonaccounting.ca/cours...
******************************
CONNECT
► Website: www.avalonaccounting.ca/
► Bookkeeping with Avalon: www.avalonaccounting.ca/onlin...
► Blog: www.avalonaccounting.ca/blog
► Facebook: / avalonaccoun. .
► Instagram: / avaloncpa
► LinkedIn: / avalon-accounting
******************************
FAQs
► What Can I Write-off? bit.ly/EXPENSESCAN
► Should I incorporate my business in Canada? bit.ly/INCORPCAN
► What is a shareholder loan? bit.ly/SHLOANCAN
► When and How Should I Hire an Employee? bit.ly/hirelikeapro
► Should I offer profit sharing? bit.ly/PROFITSHARECAN
******************************
► 20% OFF INCORPORATION WITH OWNR
If you are looking to incorporate (in Canada) and want to save some cash, check out Ownr with our affiliate link for 20% off incorporation costs:
www.ownr.co/partners/avalon-a...
We may receive compensation when our link is used to sign up with OWNR
******************************
FREE BUSINESS GUIDES:
► Starting Your Business Guide:
joecollins.typeform.com/to/bc...
► Business Owner’s Productivity Guide:
joecollins.typeform.com/to/zJ...
► Financial Foundations Guide:
joecollins.typeform.com/to/jF...
► $1 Million Dollar Service Based Business Guide: joecollins.typeform.com/to/e2...
► Manage Your Own Bookkeeping Course:
avalonacounting.thinkific.com...

Пікірлер: 93

@danielaroloff-johnson7024 8 ай бұрын

Thank you so much! I was able to make changes to the file while keeping the formulas intact. I will be doing the bookkeeping for my husband's new business, and I feel your video and file provided me everything I need to do so successfully!

@DadAndDaughter-2020 Жыл бұрын

Thank you so much Paul, Very nicely prepared and explained. I am in the process of taking over the small restaurant business and after watching this video I am much confident to do bookkeeping my self. Very easy to use and understandable spreadsheet is made.

@jasondueck4307 Жыл бұрын

Well done Paul! Thanks for this super helpful video. Incredible value!

@tomhamilton1788 Жыл бұрын

A nice way to get started in basic accounting for a small / part time business. Thanks for sharing this template ! :) All the best.

@starvinmcmarvin Жыл бұрын

By far the most useful video i've watched today about book keeping

@BeakyPress Жыл бұрын

This is perfect, exactly what I needed. Thank you so much for providing all of this for free!!

@AvalonAccounting Жыл бұрын

Glad it was helpful!

@erikaabrahao556 Жыл бұрын

Thank you Paul - great template and very well explained.I appreciate the assistance.

@UnitedSoul Жыл бұрын

This is an incredible template. Thank you for sharing.

@BusinessSimulationCoach Жыл бұрын

Thank you for the template. A good one and simple too.

@user-sh9sd7xv9f 9 ай бұрын

Thank you very much for this template Paul. It is so helpful

5 ай бұрын

THANK YOU! This was so easy to follow. I so appreciate you going through this document.

@AvalonAccounting 5 ай бұрын

You are so welcome!

@georgehachey1881 Жыл бұрын

13 years in business, and searching for something like this. Paul, you're the best, Thank You! George Hachey GH Artwork

@AvalonAccounting Жыл бұрын

Thanks George! Glad you've found it helpful :)

@philosophicaltool5469 8 ай бұрын

This is great, thank you!

@egeorge4378 Жыл бұрын

This is great! 👍

@cheeryvalley5981 Жыл бұрын

Thank you so much for doing this video

@KnottingHookCrochet Жыл бұрын

OMG!!! Thank you!! This is exactly what I needed.

@AvalonAccounting Жыл бұрын

Glad it was helpful!

@CoachShaunie 8 ай бұрын

Very helpful. Thank you for sharing

@bagus853 3 күн бұрын

Thank you so much, Paul! GBU

@pharaoh9070 4 ай бұрын

Appreciate this. Thought this would be hard.

@didarhosain8304 8 ай бұрын

Thank you so much for your great video. i will appreciate if you could make the total financial statement procedure in the following way.

@paulocamacho2976 3 ай бұрын

Thank you very much!!

@AvalonAccounting 3 ай бұрын

You're welcome!

@paulamcglinchey7655 11 ай бұрын

Thanks!

@AvalonAccounting 11 ай бұрын

Thanks so much!

@cg9392 Жыл бұрын

Hello, thank you so much Paul. this is perfect for a small restaurant business. Can additional transaction types be added to expand the list?

@LadyReddK Жыл бұрын

Thank you for a simple a straightforward system. I've downloaded it and made some tweaks (since I'm in the US). I'd appreciate some guidance on how to split a transaction. I have one receipt that needs to go to multiple places.

@AvalonAccounting Жыл бұрын

Hey Leah - I'm glad the template has been helpful for you! You could break up a purchase into multiple lines and record part of it to different accounts. Just be careful to make sure the line items add up to the total of the receipt. If possible I recommend keeping it as one line item so it minimizes chances of error. The spreadsheet is really designed to try and keep things simple.

@deane9050 Жыл бұрын

Hi could you tell me what is the transaction type for putting money in to the business as an investment cost, great spreadsheet thank you

@nanonerd 2 ай бұрын

Great video !! Simple, easy to follow, great pacing. Question: What about personal money invested into a business. Would this be classified as equity, and if so, how would we record that into this spreadsheet?

@mikeys_xXx 9 ай бұрын

Legend

@nowshinahmed8851 9 ай бұрын

Hey ! could you tell me, how I can add new transaction type?

@maryattaway7222 Жыл бұрын

Can you add transaction types? I'd like "accounts payable" for payments to my vendors

@gladyssandoval9431 Жыл бұрын

Hi Paul. I'm so happy I found this video. I just started a self employed business and template and your explanation are highly helpful. Here a question. I used my personal funds to purchase over 2-4 year period the required equipment and utensils. How could I record them?

@christophersmith6118 11 ай бұрын

Normally you'd debit the expense or asset account for the purchase and then credit either a bank account, credit card or cash. Here you're basically increasing the value of an expense and decreasing the value of an asset (bank / cash) However you can pay things from whatever account you use to track owners funds, so whether that's a drawings account or some sort of director's loan account depending on your type of business. For example if you've bought a laptopfor $500 then it could be Debit: Capital Asset - Computer Equipment Credit: Drawings

@ToqirAbbas-lh3jt 3 ай бұрын

Hi Paul - Thanks for the video. I have a business account but I transfer money to my personal account to do the transactions. Can i use personal credit card statements for book keeping or should I use my company bank account transactions ? ( I receive money for my services and transfer money to personal account for expenditures). Please advise. Thanks

@Riosbjj Жыл бұрын

thank you for this. Do you guys file taxes for clients as well?

@jamesharris9594 Ай бұрын

Its good should help me greatly, how do you add more transaction types to list

@stephr608 5 ай бұрын

Can we adapt this for QST? With the Quebec sales tax rate?

@florak1087 3 ай бұрын

Hi there.I hope you can help. How do you put in refunds in the rows? Do you make a new column for that or do you just subtract it? Help! Great video!

@gregbuck8137 5 ай бұрын

Awesome! Funny I found this and am in the same city ! What about PST my man ?

@user-vk2qu7pd5l 6 ай бұрын

how do i add more transaction types

@taliaallen4161 10 ай бұрын

On my end the categorized transactions are not coming up on the income statement page- please advise?

@user-rw2yj5mg3x 6 ай бұрын

Can I use these formulas here in the United States? I am in Virginia. This really helped me understand the process behind what I need to do, but I wonder if much of it would be different in the US?

@ms8211 Жыл бұрын

This is a great video thanks. Can we record purchased inventory here as well and in what category is recorded?

@AvalonAccounting Жыл бұрын

Hi! Sorry to say that there isn't a way with that sheet to record inventory as it's not set up for balance sheet accounts besides capital asset purchases. We'll be coming out with another spreadsheet that allows you to record balance sheet items like inventory so keep an eye on the channel.

@michaelabaker8077 Жыл бұрын

Hi Paul, Thanks so much for this - super useful over here in the UK. Can I ask, I work on a record label and we have various costs related to sales, such as paper inserts for records - would you say that would come under cost of sales? Thanks again so much

@AvalonAccounting Жыл бұрын

Hey Michaela - glad you've found the template useful! Including those costs as cost of sales sounds reasonable to me.

@deborahchandler2564 11 ай бұрын

Hi Paul! Thank you so much for this video! I am sole proprietor of a small little cafe/bake shoppe and bookkeeping is not my best skill. (Not even near the top of the list) because times are tough my accounts are all used for business and personal, because of borrowing from Peter to pay Paul. can a transfer all my accounts info and use this just as easily? All info in one place sort of thing? thanks for the guidance :) Deb

@user-mc1pd8sy6r 4 ай бұрын

how do I add a transaction, i.e. payment of estimated taxes?

@joywashington8784 5 ай бұрын

How can I add additional transactions as income or expenses?

@user-vk2qu7pd5l 6 ай бұрын

Hi there, I was thinking about using your template for a small Landscaping company. I have to submit GST/HST every month. Is that possible to keep those totals separate for each month with your template? I have made my own template over the years but its not very professional.

@MasterpisopArtZ Жыл бұрын

Hey, I'd like to see a balance sheet tutorial for this too. Thanks

@AvalonAccounting Жыл бұрын

Totally understandable! Due to the complexity though, we would highly recommend getting accounting software if you need a balance sheet. We love Xero but there are loads of options out there as well.

@clairerafter3235 5 ай бұрын

Thank you that is brilliant but i have one question if your inputting the stuff for book keeping is it done monthly or yearly

@AvalonAccounting 5 ай бұрын

You can enter information as frequently as you like but the idea would be to create a new spreadsheet annually.

@SukhpreetSingh-dq7ym Жыл бұрын

Hi Paul, Thanks for an amazing video. Can you please tell, which transaction type I need to use for the salary payments to the employees?

@AvalonAccounting Жыл бұрын

Hey Suhkpreet - I would use the Wages and Benefits account for that. Paul

@kenjalia3151 8 ай бұрын

Hi Paul where can i download the templet?

@adanroldan8930 Жыл бұрын

Thanks! What do you do when you have returns for transactions. I have a lot of returns...

@AvalonAccounting Жыл бұрын

Hey Adan - you could use a negative number and record the return to your sales account. Or if you prefer, you could create a separate expense account and record returns to that account using positive numbers on the spreadsheet.

@26.2coffeecompany Жыл бұрын

thank you - at a simple level, I can use this to get a basic income statement in the US. any major difference?

@amielewis7118 Жыл бұрын

I was wondering the same thing. I am wanting to use this for my husband's bookkeeping, but we are in the US. So I am wondering if there are any major differences?

@AvalonAccounting Жыл бұрын

Hey there - you could use this for a basic income statement in the US. The sales tax component may not work, but if it's just recording expenses, it will create a basic income statement. Thanks for checking it out!

@naizilayasen2703 4 ай бұрын

how can I get this one

@brel4508 6 ай бұрын

How would you add an Owner Draw as a Transaction Type?

@TanjaRohn 5 ай бұрын

I went into Transaction Types sheet and added a line. Miraculously it adds it to the drop down list!

@MasterpisopArtZ Жыл бұрын

Thanks does this sheets works for corporation? and how do i calculate income tax please help

@AvalonAccounting Жыл бұрын

Hey! The sheet in this video linked below would work best for doing the bookkeeping for your corporation. kzfaq.info/get/bejne/Zqh8nrFkzMzQYIU.html Calculating corporate tax is a bit more complicated than I can explain here, but you can get a rough estimate by multiplying your net income by your corporate tax rate. See the link below for corporate tax rates in Canada. www.avalonaccounting.ca/blog/corporate-tax-rates-canada

@LisaSonora 2 ай бұрын

Great tutorial - Have not received the template - tried different email addy's and it never arrived, not even spam. Sent an email, too requesting. Would love to use your template. Thanks!

@AvalonAccounting 2 ай бұрын

Hey Lisa, thanks for bringing this up! You should have received an email from Laurie with a link to the bookkeeping template while we try to fix this issue. ☺

@jericac7406 Жыл бұрын

If we have personal and business transactions do we just delete the personal and keep all business transactions?

@AvalonAccounting Жыл бұрын

If you're using the sheet and only need an income statement to use for preparing your personal tax return, then deleting the personal transactions should work just fine. Some businesses (especially corporations) will need to show all transactions from the account so that their cash account in their books reconciles to the bank account balance at year-end. The sheet is built for the first scenario (personal tax returns) where you don't need to show agree your cash balance per the books to the cash balance in your bank account.

@jericac7406 Жыл бұрын

@@AvalonAccounting thank you I used template for my tax return.

@memkart Жыл бұрын

Can I modify GST/HST to be pertinent to the US?

@AvalonAccounting Жыл бұрын

Hey Marty - I'm not entirely sure how US sales taxes work, but if its a value added tax like GST/HST you could probably modify the sheet to work the same way.

@canadianbnb Жыл бұрын

If all items are supposed to be postive, how would you input a refund into the sheet template sheet ? Thanks

@AvalonAccounting Жыл бұрын

You could enter the refund as a negative sales item or a positive expense. They'll both have the same effect of reducing net income for the refunded amount.

@ephraimmathew3531 Жыл бұрын

how did you find the GST or calculate the GST

@AvalonAccounting Жыл бұрын

Hi Ephraim - you can find the GST paid on receipts or invoices or you can calculate it from the gross total. One way to calculate GST charged at 5% is to multiply the gross total by 5 and divide that by 105. For example if we paid a total $315 for something, we could calculate the GST included in that amount: $315 * 5 / 105 = $15

@ephraimmathew3531 Жыл бұрын

@@AvalonAccounting but i did 56.22*5/105 which then gave me 2.6771 but in your video it said 2.68... did you round to 2dp

@palmtree2367 3 ай бұрын

Hi, Is this template still available. I'm not receiving the email when I subscribe. Thanks, Paul.

@AvalonAccounting 3 ай бұрын

Hey! Sorry, our automation broke yesterday but I've just fixed it now. Please let me know if you still didn't receive the email with the template - it should be in your inbox now. - Paul