Be on the leading edge of the bold frontier of e-commerce accounting
Discover the essentials and workflows to take on Shopify bookkeeping like a pro.
You're a virtual bookkeeper and...
You've got your bookkeeping basics down, but are struggling with the next step of finding quality clients who value what you do for them.
You're ready to pivot away from a stagnant niche, and looking for a specialty that truly interests you AND makes you stand out from the crowd.
You know there's a massive opportunity in working with e-commerce clients and are afraid of missing the boat because you don't possess the essential skills to take it on (or don't even know what is involved).
You may be starting to get e-commerce or Shopify clients and aren't trained to handle the unique challenges that this type of bookkeeping presents.
You know you need the essential building blocks that will set you up for Shopify bookkeeping success, and not just surface-level tips and tricks found on the internet.
Or, you're a Shopify seller and...
You're afraid of making a big mess, or doing something wrong because you don't even know what it is that you should know.
You have a great grasp of bookkeeping fundamentals - but you've noticed that Shopify bookkeeping is another beast.
You've discovered that the integrations you were using to make your life easier just made your books even messier and created more work.
You've become frustrated trying to figure out how to record PayPal transactions.
You've tried to research how to do your own Shopify bookkeeping and started uncovering articles mentioning complicated terms like "sales tax nexus," "COGS," and, "multiple payment processors." Now you just want to throw up your hands in resignation.
Maybe all this frustration led you to put off your bookkeeping for a week, which turned into a month, which became a quarter of a year...
Perhaps you never even started your Shopify bookkeeping because you didn't know where to start.
Your books are a mess and you need a step-by-step guide to walk you through the process of handling your Shopify bookkeeping the right way.
A solid foundation to take on Shopify bookkeeping like a pro.
A deep understanding of all the essential aspects of Shopify bookkeeping.
Insights on a proven workflow for integrating QuickBooks Online and Shopify.
Fundamental knowledge for virtual bookkeepers to master the growing niche of Shopify bookkeeping.
Guidance on what exactly it takes for Shopify sellers to properly set up and manage their own financials.
If you want Shopify bookkeeping to be on your list of skills - not your list of fears, then this method has the right tools and guidance to get you there.
If you are ready to move confidently into the world of Shopify bookkeeping, this course will give you the fundamental knowledge you need with workflows and checklists to put it all together.
If you want to tackle your own Shopify bookkeeping, this course will empower you to take it on with a proven system to guide you every step of the way.
0-1 Welcome to Shopify Bookkeeping Method
FREE PREVIEW0-2 About this course / Navigating the course content
FREE PREVIEW0-3 Copyright and information about the course resources and forms provided - please read
0-4 Join the exclusive FaceBook Community for students of this course
0-5 About certificate of completion
0-6 The 5MB Academy for Virtual Bookkeepers and Accountants (and 10% discount code)
1-0 Section 1 - PDF of video lessons
1-1 Complexities of e-commerce
1-2 Bookkeeping best practices
1-3 Shopify platform and tour
2-0 Section 2 - PDF of video lessons (updated October 2024)
2-1 Intro_Basis of accounting
2-2 Setting up QuickBooks Online for the first time
2-3A Shopify chart of accounts - accounts to add (updated October 2024)
2-3B Shopify chart of accounts - removing accounts
2-3C Shopify chart of accounts - resources walk-thru
2-4 Understanding clearing accounts
2-5 Items needed to work on the books
2-6 Resource: Shopify bookkeeping - Quick setup checklist
2-7 Resource: Account categories to add and remove from the QBO chart of accounts
2-8 Resource: Shopify Seller chart of accounts
2-9 Resource: Shopify client onboarding checklist (for bookkeepers)
3-0 Section 3 - PDF of video lessons - Updated October 2024
3-1 Methods for recording Shopify transactions
3-1A When is A2X not a good fit for Shopify sellers?
3-2 Setting up A2X
3-3A - A2X Accounts and Taxes (updated October 2024)
3-3B Mapping payment gateway transactions (Other Assets) (updated October 2024)
3-3C Sales and VAT taxes mapping / using filters (updated October 2024)
3-4 A2X Settings (updated October 2024)
3-5 Switch between accounts | Notifications in A2X (updated October 2024)
3-6 Shopify Payouts in A2X (Updated October 2024)
3-7 Resource: A2X setup checklist
3-8 Resource: A2X certification
4-0 Section 4 - PDF of video lessons
4-1 Shopify monthly bookkeeping workflow basics
4-2A Record transactions - overview
4-2B Monthly A2X review (updated October 2024)
4-2C QBO Banking transactions - Money in
4-2D QBO Banking transactions - bank account transfers
4-2E QBO Banking transactions - Money out
4-2F Record Shopify monthly bill
4-2G Record Payment processor fees
4-2H Inventory, COGS, sales taxes
4-3A Reconcile bank and credit card accounts
4-3B Reconcile Shopify income and payment processor deposits
4-4A Introduction to month-end review | Review banking transactions
4-4B Review Clearing accounts
4-4C Review and update month-end inventory balances
4-4D Review the Profit & Loss and Balance Sheet
4-5 Revise: Making corrections to transactions already recorded
4-6 Restrict: Close the books
4-7 Resource: Shopify monthly bookkeeping workflow list
4-8 Resource: Shopify reconciliation worksheet
5-0 Section 5 - PDF of video lessons
5-1 How PayPal Works
5-2 Preferred PayPal settings
5-3 PayPal financial reports
5-4 Connecting PayPal to QBO
5-5 Using the Connect to PayPal connection
5-6 PayPal workflow basics in QBO
5-7 Record summarized PayPal transactions in QBO
5-8 Record expenses paid via PayPal
5-9 Funds held by PayPal
5-10 PayPal foreign currency transactions
5-11 PayPal bank account reconciliation
5-12 Resource: PayPal bookkeeping checklist
5-13 Resource: PayPal expense import
6-0 Section 6 - PDF of video lessons
6-1 Inventory and Cost of Goods Sold essentials
6-2 Inventory and Cost of Goods Sold workflows
6-3 Inventory bookkeeping workflows
6-4 Inventory tracking spreadsheet
6-5 Inventory journal entries
6-5A Using the Shopify Inventory report
6-6 A2X for recording Cost of Goods Sold
6-7 Inventory management apps
6-8 Inventory month-end review
6-9 Resource: Shopify inventory tracking spreadsheet
6-10 Resource: Simple inventory worksheet - year end
7-0 Section 7 - PDF of video lessons
7-1 US sales tax overview
7-2 Register for sales taxes
7-3 Collect sales taxes
7-4 Remit sales taxes
7-5 Sales tax month-end review
7-6 Resources
8-1 Shopify manual journal entry (A2X not used)
8-2 Bookkeeping for other sales channels: PDF of video lesson
8-2A Bookkeeping for other sales channels
8-3 Pricing tips for bookkeepers: PDF of video lesson
8-3A Pricing tips for bookkeepers
8-4 Resource: Sample e-commerce pricing spreadsheet for bookkeepers
8-5 Resource: Sample engagement letter for bookkeepers
Whether you choose the one-payment plan or the 3-payment plan, when you sign up you get immediate access to all lessons and you can do the lessons at your own pace.
You have lifetime access to the course and all the material, so there's no need to worry if you need to take it slowly.
This course doesn't teach the basics of bookkeeping or how to use QuickBooks Online. So, if you're a bookkeeper, you should have a good understanding of both before diving into this course.
If you're new to bookkeeping, please feel free to check out my other bookkeeping resources and come back to this course when you're ready.
If you're a seller, this course won't turn you into a bookkeeper, but will show you the essentials of doing your Shopify bookkeeping the right way.
This program is a good fit for those who want to grow their bookkeeping business, take a brick & mortar business virtual, or transition out of a bookkeeper or accountant 9-5 and become your own boss.
If you're ready to invest in yourself and create the virtual firm of your dreams, specializing in a growing niche, this course is for you.
Due to the massive value and resources provided in this course, we do not provide a money-back guarantee.
If you are unsatisfied with this course, contact us in the first 30 days and we will discuss your specific circumstances and agree upon a mutually beneficial resolution.
We have students in the Shopify Bookkeeping Method from all over the world. Some of the content is specific to US accounting rules and to the US version of QBO, however, that is pointed out during the lessons.
The general workflows and method for doing Shopify bookkeeping can be applied to any accounting software, however this training focuses on QuickBooks Online.
No. Shopify bookkeeping is very different from other types of e-commerce bookkeeping.
Regardless of the payment plan you choose, you have instant, lifetime access to the course and all the material.
This course takes you through the step-by-step method for doing your own Shopify bookkeeping. Keep in mind that there are a lot of complexities to e-commerce accounting and that you may still need the help of a professional e-commerce bookkeeper.
You will receive instant access to all course lessons.
$947.00
One payment
3 payments of $345
Pay over 3 months