Free Bookkeeping Template | Excel and Google Sheets | Step by Step Guide
Vložit
- čas přidán 6. 08. 2024
- 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 CZcams 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... - Jak na to + styl
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!
A nice way to get started in basic accounting for a small / part time business. Thanks for sharing this template ! :) All the best.
Well done Paul! Thanks for this super helpful video. Incredible value!
Thank you Paul - great template and very well explained.I appreciate the assistance.
By far the most useful video i've watched today about book keeping
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.
This is perfect, exactly what I needed. Thank you so much for providing all of this for free!!
Glad it was helpful!
This is an incredible template. Thank you for sharing.
Thank you for the template. A good one and simple too.
Thank you very much for this template Paul. It is so helpful
THANK YOU! This was so easy to follow. I so appreciate you going through this document.
You are so welcome!
This is great, thank you!
Very helpful. Thank you for sharing
13 years in business, and searching for something like this. Paul, you're the best, Thank You!
George Hachey
GH Artwork
Thanks George! Glad you've found it helpful :)
Thank you so much, Paul! GBU
This is great! 👍
Thank you so much for doing this video
OMG!!! Thank you!! This is exactly what I needed.
Glad it was helpful!
Appreciate this. Thought this would be hard.
Thank you so much for your great video. i will appreciate if you could make the total financial statement procedure in the following way.
Thank you very much!!
You're welcome!
Thanks!
Thanks so much!
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.
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.
Hello, thank you so much Paul. this is perfect for a small restaurant business. Can additional transaction types be added to expand the list?
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
Hey ! could you tell me, how I can add new transaction type?
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?
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?
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
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
Hey Michaela - glad you've found the template useful! Including those costs as cost of sales sounds reasonable to me.
Can we adapt this for QST? With the Quebec sales tax rate?
Its good should help me greatly, how do you add more transaction types to list
Can you add transaction types? I'd like "accounts payable" for payments to my vendors
This is a great video thanks. Can we record purchased inventory here as well and in what category is recorded?
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.
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
On my end the categorized transactions are not coming up on the income statement page- please advise?
Legend
Awesome! Funny I found this and am in the same city ! What about PST my man ?
Hey, I'd like to see a balance sheet tutorial for this too. Thanks
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.
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?
Hey Suhkpreet - I would use the Wages and Benefits account for that.
Paul
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?
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
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!
thank you for this. Do you guys file taxes for clients as well?
should I be doing this at the end of the year of tax season? Or should I be doing this monthly? I was hoping to do it monthly/bi weekly
how do i add more transaction types
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.
Thanks! What do you do when you have returns for transactions. I have a lot of returns...
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.
Hi Paul where can i download the templet?
Thank you that is brilliant but i have one question if your inputting the stuff for book keeping is it done monthly or yearly
You can enter information as frequently as you like but the idea would be to create a new spreadsheet annually.
how do I add a transaction, i.e. payment of estimated taxes?
How can I add additional transactions as income or expenses?
thank you - at a simple level, I can use this to get a basic income statement in the US. any major difference?
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?
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!
Thanks does this sheets works for corporation? and how do i calculate income tax please help
Hey!
The sheet in this video linked below would work best for doing the bookkeeping for your corporation.
czcams.com/video/0BLkN3gfl0Q/video.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
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!
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. ☺
How would you add an Owner Draw as a Transaction Type?
I went into Transaction Types sheet and added a line. Miraculously it adds it to the drop down list!
If we have personal and business transactions do we just delete the personal and keep all business transactions?
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.
@@AvalonAccounting thank you I used template for my tax return.
Can I modify GST/HST to be pertinent to the US?
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.
how can I get this one
If all items are supposed to be postive, how would you input a refund into the sheet template sheet ? Thanks
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.
how did you find the GST or calculate the GST
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
@@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
Hi, Is this template still available. I'm not receiving the email when I subscribe. Thanks, Paul.
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
Can't download, didn't recieve the email
Hey there!
Can you send us an email at hq@avalonaccounting? We'll send you the bookkeeping template through there! :)
anyone else have troubles downloading the template?
Hey Jordan, were you able to get the template!
If that's the case let me know so I can send one over to your inbox. :)
Can’t download it?
for a professional bookkeeping job, this is useless