shopify bookkeeping template
shopify sales and fees
e-commerce shopify financials
paper and spark shopify bookkeeping
online seller shopify
shopify shop sales and fees taxes
shopify sales tax
online shop bookkeeping
paper and spark reviews
shopify sales tracking template
shopify sales tracking
shopify fees
shopify sales tax information
shopify template review
paper and spark reviews
paper and spark reviews

Shopify Seller Spreadsheet

Regular price$97.00 USD

When it comes to your shopify bookkeeping, it's time to go from confused to capable.

Are you a 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?

Get ready to win back your time with this automated bookkeeping template from Paper + Spark. My spreadsheet tools give you everything you need to easily do your books, and NO overwhelming bells & whistles (or monthly subscription costs) that you don’t need.

Bookkeeping, accounting, tax stuff… it doesn’t come naturally to a lot of us, but it is essential. Not only does knowing your money help you MAKE more money, but you gotta deal with taxes every year!

Download the Shopify Seller Spreadsheet today and get caught up on & confident about your numbers in just a couple hours!

How the Shopify Seller 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.

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.

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

What You Get Immediately After Purchase:

Spreadsheet file

Instantly downloadable spreadsheet file that can be used in Excel, Numbers, or Google Sheets, for any year you need to do your books

Video & Text Instructions

A Google Doc guide with crystal clear written & visual instructions, plus video tutorials with step-by-step instructions & examples

support & motivation

Access to the Accounting Accountability Club on FB for support, questions, and monthly office hours, plus monthly checklists delivered to your inbox

The best part about buying a Paper + Spark spreadsheet is the support. 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. You’ll do your biz books every month with clarity, and you’ll finally truly understand what these numbers, reports, and terms MEAN.

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 that out-of-the-box, one-size-fits-all bookkeeping software option? 



Get them both bundled together for a discount! Pick out the exact spreadsheet combo for whatever and wherever you sell.

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.

"My accountant loves your spreadsheets!"

What do real customers have to say?

Highlights from my recent customer survey:

  • Tax time is much easier with their P+S spreadsheet
  • They love the 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. 

Customer Reviews

Based on 29 reviews
Regan Quinn

Love it everything I wanted in a eady to use spreadsheet

Danielle Clark
Wish I would've had this sooner

I've been in business since 2000 and my only regret is not having this sooner. I've been searching for a better way to track my business and I've found it here with Paper + Spark's spreadsheets. 10/10

Kimberly B.
Shopify Seller Spreadsheet

Easy to follow instructions made specifically for Shopify sellers. Highly recommend.

Candice Brock

I am still getting used to the spreadsheets but I am thrilled about having a way to track the massive amounts of raw inventory that I have. This is the only program I have found that is beneficial to makers

Stephanie Smith
Game. Changer.

This spreadsheet has streamlined my business like nobody’s business! Thank you for creating such brilliant products AND offering support after the fact! 10/10!