Stepbystep instructions on how to make, use and edit our free accounting spreadsheet.

https://tinyurl.com/accountingspread...

Need to do your bookkeeping but don't want to pay for expensive software? This sheet lets you complete your bookkeeping and share it with your accountant for your yearend tax filings.

Get Your Yearend Ready in 3 Steps!
1⃣ Step 1 Add your bank and credit card transactions
2⃣ Step 2 Use the dropdown menu to categorize them
3⃣ Step 3 Share this file with your accountant

******************************

✅ Sign up for my newsletter here: https://www.avalonaccounting.ca/weekl...

******************************

CONTENTS OF THIS VIDEO

00:00 Intro
00:58 Make a Copy of the Sheet (Important!)
01:46 Overview of the Sheet
03:30 PART 1 HOW TO DO YOUR BOOKKEEPING
03:40 Step 1 Download Your Transactions
03:50 Step 2 Organize Your Transactions
05:31 Step 3 Paste Transactions Into Sheet
06:29 Step 4 Check Your Balances
07:11 Step 5 Categorize Transactions
17:12 Step 6 Review Your Trial Balance
17:57 Step 7 Review Your Income Statement
18:23 Step 8 Share With Your Accountant
18:40 PART 2 HOW THE SPREADSHEET WORKS
18:51 How Recording Transactions Work
20:03 How the Trial Balance Works
21:22 How the Income Statement Works
21:38 How Sales Tax Rates Work
22:05 How to Add or Change Transaction Categories
25:12 Learn Modern Bookkeeping Software
25:24 How to Add or Change Sales Tax Rates
28:01 How to Add More Bank or Credit Card Accounts
31:23 Final Thoughts

******************************

MENTIONED IN THIS VIDEO

► This Accounting Spreadsheet Great for corporate yearend accounting
https://tinyurl.com/accountingspread...

► Basic Bookkeeping Spreadsheet Great for selfemployed taxes
   • Free Bookkeeping Template | Excel and...  

► Learn Modern Bookkeeping Online Course
https://www.avalonaccounting.ca/cours...

► Yearend Accounting Checklist
   • ✅ Yearend Accounting Checklist  8 S...  

******************************

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.

******************************

CONNECT

► Website: https://www.avalonaccounting.ca/

******************************

‍ 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...

******************************

FLOAT VISA $500 CASH BACK

Float Financial provides a company credit card built for modern businesses.

Check out our review for details

► https://www.avalonaccounting.ca/blog/...

Use our referral link to receive $500 cash back

► https://tinyurl.com/floatvisa

We may receive compensation when our link is used to sign up for a Float Visa.

******************************

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/avalona...

We may receive compensation when our link is used to sign up with OWNR

****************************

⚒ BEST ONLINE TOOLS FOR SMALL BUSINESSES

We've curated a list of our favorite online tools to help small business owners get stuff done and thrive. Check out our list linked below.

► https://www.avalonaccounting.ca/tools

******************************

‍ 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...