When it comes to your bookkeeping, it’s time to go from confused to capable.
Are you Shopify seller without a bookkeeping system to support you? Have you tried to set up a process for dealing with your business’ finances, but you quickly get overwhelmed or confused and give up?
Do you have financial paperwork and receipts stuffed into a shoebox, like a ticking time-bomb waiting to explode once your taxes are due?
Or maybe you just opened your Shopify shop, and you’re trying to figure out how to get this bookkeeping thing set up correctly from the beginning. You take a look at Shopify’s reports, and get overwhelmed trying to interpret the data there.
Accounting doesn’t come naturally to a lot of people, and it’s certainly not something most creatives want to spend their free time doing. But did you know that keeping track of your shop’s finances can actually help your business make more money?
That’s why we created the Shopify Seller Spreadsheet, a tool that does the heavy-lifting for you, so you can have the data you need to make smart decisions for your business and more time to do what you love (create!).
I’ve sold hundreds of my bookkeeping templates to Etsy shop owners and other online sellers since 2015. The Shopify Seller Spreadsheet is the result of tons of user feedback, testing, and tweaking. I’m confident you’re going to love it!
This spreadsheet was created by a Certified Public Accountant to help Shopify sellers automate and simplify their monthly bookkeeping process. This tool compiles your business’ revenue and expenses each month to calculate your net profit. There are separate tabs to help you categorize expenses, along with monthly tabs for importing your Shopify transactional data directly from Shopify.
What you’re buying:
Instantly downloadable spreadsheet file that can be used in Excel, Numbers, or Google Sheets, for any year you need to do your books
A detailed instruction guide via Google Docs
Step-by-step series of video tutorials on how to use your spreadsheet & do your books
Access to the Accounting Accountability Club on Facebook for support, questions, and monthly office hours
Monthly checklist & reminder emails
What you’re really buying:
When you purchase a Paper + Spark spreadsheet, you’re not simply getting a downloadable spreadsheet file. You’re really getting a set of resources & support that help you understand your business finances with confidence.
Every P+S spreadsheet comes with step-by-step video & text instructions. You’ll not only be able to see how to use your spreadsheet and do your biz books every month with clarity, but you’ll finally truly understand what these numbers, reports, and terms MEAN.
Every P+S spreadsheet also comes with the support you need to stay motivated and confident.Your purchase includes access to the Accounting Accountability Club, where you can ask questions about doing your books, understanding your numbers, and more. We also hold live monthly office hours in the Club, during which I walk through your questions and screen share examples so you can see how things are done.
Finally, you’ll also get email reminders and monthly checklists on the first of each month delivered straight to your inbox. I’ll hold you accountable to keep your spreadsheets updated and even send you a step-by-step list in case you forget where to find what!
You’re not just buying a file. You’re buying lifetime access to a bookkeeping template, step-by-step instructions for how to understand your biz finances, access to a CPA who actually *understands* e-commerce and how your maker biz operates, an easier tax time for yourself, monthly accountability and a community that will support you throughout your journey as an entrepreneur.
Can you say the same about an out-of-the-box, one-size-fits-all bookkeeping software option?
How the spreadsheet works
My Seller Spreadsheets automate and simplify your monthly bookkeeping process. The Shopify Seller Spreadsheet imports in your Shopify sales & fees directly from your Shopify CSV files with a simple copy & paste.
The spreadsheet also helps you categorize your business expenses, enter sales from other sources, automates important sales tax info, and sums up your monthly net profit.
Not familiar with how to use a spreadsheet? No worries – your purchase includes tons of support and step-by-step video & text guidance. My video tutorials and cheat sheets will walk you through how to open, import, use, and interpret the data on your spreadsheet.
What does the Shopify Seller Spreadsheet help me do?
- Quickly import Shopify data – Save time by quickly importing your Shopify sales each month, along with shipping received, sales tax collected, and refunds issued. The spreadsheet takes the data it needs for you, making less work for you.
- Walk you through entering your Shopify & PayPal fees – I’ll show you exactly where to find all the fees you need to record, and show you how to interpret Shopify & PayPal reports so you know exactly what you’re looking at.
- See all your sales in one place – You can also manually input your sales from all your other sources, such as Paypal, eBay, your own site, craft shows, etc.
- Input expense receipts – Expenses categories each have their own tab. As you make purchases or pay bills throughout the month, you can enter your expenses on a receipt-by-receipt basis in the appropriate category. This means you have a great backup of your expense totals at year-end to backup your tax numbers or give to your accountant.
- Make tax time so much easier – The expense categories roughly correlate to the expense categories on your business’ tax return, making the process of doing your taxes a lot more streamlined and simplified for you or your accountant.
- Calculate net profit or loss each month – Know instantly whether your biz is making a profit or a loss throughout the year, enabling you to make smarter budgeting and goal-setting decisions.
- Deal with sales taxes – Compile all your sales tax collected and in-state sales in one place.
Why a Paper + Spark spreadsheet?
Traditional bookkeeping software is made with accountants in mind. It’s expensive (and generally requires a monthly subscription payment), bulky, and oftentimes more complicated than a micro business like yours needs. It’s made for any and all types of small businesses, and not specific to YOUR business needs as a handmade biz owner or e-commerce seller. When your bookkeeping software is too complicated, too vague, and support or in-plain-English instruction is lacking, you tend to procrastinate on using it. Not updating your books consistently means severe stress once year end or tax deadlines hit.
Spreadsheets are powerful but simple tools. Partner a well-crafted spreadsheet file designed by an accountant intimately acquainted with e-commerce with clear, understandable instructions and you’ve got a formula for bookkeeping success. You get everything you need to feel empowered by your numbers, and nothing you don’t need.
Paper + Spark has been selling spreadsheets since 2015. We currently support thousands of makers and creative entrepreneurs in doing their books and understanding their money. Our spreadsheets have received countless rave reviews from shop owners. No other bookkeeping solution out there offers our level of step-by-step guidance & support. We also stay up-to-date on e-commerce reporting and platform changes.
With a Paper + Spark spreadsheet, you’ll pay a one-time fee for lifetime access to your files and support. We provide any future year files and updates for free, forever, via the account you create at checkout. You can always reach out in the Accounting Accountability Club, or via DM or email, and get answers to your spreadsheet & bookkeeping questions.
What do users have to say about their Paper + Spark spreadsheet?
Responses to my recent survey highlighted these themes amongst spreadsheet users:
Tax time is much easier with their Paper + Spark spreadsheet
Their purchase comes with a wealth of support materials created by an accountant who is down-to-earth and easy to follow (thanks y’all!)
The spreadsheet gives them a clean way to get organized & a bird’s eye view of their business. They love that this tool was made specifically for makers & crafters and how simple and user-friendly it is to update.
Many users said “My accountant loves your spreadsheet too!” — the highest form of praise!
Paper + Spark users are more likely to actually DO their books consistently and over the long term. According to survey results, 65% of spreadsheet users have been using their sheets for at least 2 years. 61% of spreadsheet users report that they update their sheets at least once a month.
Are you looking for a spreadsheet to help you with logging supplies, tracking inventory, and pricing your goods for sale? One of our inventory spreadsheets may be a good fit. Check them out here.
Need the Shopify Seller Spreadsheet and an inventory spreadsheet too? Build your own bundle of spreadsheets and get a significant discount here.
Due to the nature of their reporting, I do not recommend you use this spreadsheet with the PayPal import add on. You could potentially double count your Shopify PayPal sales.
Have questions about any of our spreadsheets? Not sure which tool best fits your needs? Check out the Spreadsheet Resource page for FAQs, videos, and more info.