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

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: https://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 https://www.avalonaccounting.ca/free-... ► Free Bookkeeping Template Blog Article https://www.avalonaccounting.ca/blog/... ► Expenses vs. Capital Assets https://www.avalonaccounting.ca/blog/... ► Small Business Bookkeeping Guide (Includes Home Office Info) https://www.avalonaccounting.ca/blog/... ► How to File Your GST/HST Return https://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 YouTube 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. https://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. https://www.avalonaccounting.ca/cours... 🖥️ LEARN MODERN BOOKKEEPING ► Learn to do your own bookkeeping with modern tools and our proven practices. https://www.avalonaccounting.ca/cours... 📈 BOOKKEEPING AND TAX FOR FREELANCERS ► This course teaches sole proprietors how to simplify bookkeeping and taxes. https://www.avalonaccounting.ca/cours... ****************************** CONNECT ► Website: https://www.avalonaccounting.ca/ ► Bookkeeping with Avalon: https://www.avalonaccounting.ca/onlin... ► Blog: https://www.avalonaccounting.ca/blog ► Facebook:   / avalonaccoun.  . ► Instagram:   / avaloncpa   ► LinkedIn:   / avalon-accounting   ****************************** FAQs ► What Can I Write-off? http://bit.ly/EXPENSESCAN ► Should I incorporate my business in Canada? http://bit.ly/INCORPCAN ► What is a shareholder loan? http://bit.ly/SHLOANCAN ► When and How Should I Hire an Employee? http://bit.ly/hirelikeapro ► Should I offer profit sharing? http://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: https://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: https://joecollins.typeform.com/to/bc... ► Business Owner’s Productivity Guide: https://joecollins.typeform.com/to/zJ... ► Financial Foundations Guide: https://joecollins.typeform.com/to/jF... ► $1 Million Dollar Service Based Business Guide: https://joecollins.typeform.com/to/e2... ► Manage Your Own Bookkeeping Course: https://avalonacounting.thinkific.com...