Skip to content

Your Store's First Month of Bookkeeping, Worked Through: 24 Orders

A demo candle shop's October: 24 orders, 13 bank lines, one Stripe payout split line by line, and the profit and loss you should end up with.

5 min read
Calculator beside neatly sorted receipt folders and documents

Quick answer

Your bank deposits are not your sales. Each Stripe payout mixes three things: sales, sales tax you owe the state, and Stripe's fee taken out. Split every payout into those three lines and October for our demo shop comes out at $1,056.00 revenue and $392.45 net profit, from $1,066.44 that customers paid.

Pick by your situation

  • You have under 30 orders a month and want $0 softwareWave Starter ($0) or a spreadsheet, using the split shown below
  • You expect to hire an accountant at tax timeAsk them which tool they use first, then pick that one
  • You buy from more than 5 suppliers a monthSkip Xero Early: it allows 5 bills a month. QuickBooks Simple Start is $38/mo

Built from official pricing and help pages checked 2026-10-14, not hands-on testing. How we research

At a glance

5 min read5 steps

  • XeroEarly $27 per month (promotional discount for the first 3 months shown)

    Best for: Low-volume sellers who send up to 20 invoices a month and reconcile bank transactions

    checked 2026-10-03

  • QuickBooks OnlineSimple Start $38/month list price (50% off for 3 months promotion shown)

    Best for: Stores that want a widely used accounting product with tiered plans up to 25 users

    checked 2026-10-03

  • WaveStarter $0; Pro $19 USD/month billed monthly

    Best for: Solo founders who want unlimited invoices, bills and bookkeeping records at $0

    checked 2026-10-03

5 steps in this guide

  1. 1Download the sample orders and bank files below.
  2. 2List every bank line for the month.
  3. 3Split each Stripe payout into sales, sales tax owed and Stripe fees.
  4. 4Put each expense in one category: supplies, shipping labels, software, ads.
  5. 5Add it up into a profit and loss, and check the payouts against the orders.
On this page

Wickfield Candle Co. is a made-up shop for this demo, not a real business.

The month we’re booking

Wickfield Candle Co. is a demo shop, not a real business. It sells one 8 oz candle at $24 plus $6 shipping, and it ships from Pennsylvania. In October, the shop gets 24 orders for 38 candles in total. You can download the real CSV files for these orders and bank lines in section 7 below to follow along on your own computer. Here are the 13 bank lines from the shop’s checking account for that month:

Date Bank line Amount
Oct 1 Owner contribution from personal savings $1,000.00
Oct 2 Shopify Basic monthly plan −$39.00
Oct 3 Namecheap domain −$11.28
Oct 6 Stripe payout (6 orders) $242.88
Oct 6 Uline boxes and tissue −$86.40
Oct 9 Wax & Wick Supply: wax, wicks, jars −$212.75
Oct 13 Stripe payout (7 orders) $278.36
Oct 14 Pirate Ship USPS labels −$118.62
Oct 20 Meta ads −$60.00
Oct 20 Stripe payout (5 orders) $214.06
Oct 27 Stripe payout (4 orders) $188.73
Oct 28 Pirate Ship USPS labels −$97.35
Nov 3 Stripe payout (2 orders) $104.26

Split every Stripe payout into three lines

This is the step most new owners skip. A payout is not one number for your books. Take the October 13 payout of $278.36 as a worked example. It covers 7 orders where customers paid $288.84 in total.

Line Amount
Sales (candles + shipping charged) $282.00
Sales tax owed to Pennsylvania (3 of the 7 orders) $6.84
Stripe fees (2.9% + 30¢ per order) −$10.48
Deposited in the bank $278.36

Check the math: 282.00 + 6.84 − 10.48 = 278.36. If your split does not add back to the deposit, something is missing. Do this for all five payouts. Together they come to $1,028.29, which is the $1,066.44 customers paid minus $38.15 in Stripe fees.

Sort the costs

Once your payouts are split, every other bank line from the month goes into one cost bucket. Sorting them this way keeps your profit calculation clean and shows you where your cash went.

Category Lines Total
Supplies (cost of goods) Wax, wicks, jars; boxes and tissue $299.15
Shipping labels Pirate Ship, twice $215.97
Software Shopify Basic, domain $50.28
Ads Meta ads $60.00

Notice that the $1,000.00 owner contribution from October 1 is not in this table. That deposit is not income. It is money you put into the store from your own savings, known as owner’s equity. Always leave it out of your profit numbers.

October’s profit and loss

When you combine the split payouts and the sorted expenses, you get the profit and loss statement for October.

Line USD
Product sales (38 candles × $24) 912.00
Shipping charged to customers 144.00
Revenue 1,056.00
Supplies: wax, wicks, jars, packaging −299.15
Gross profit 756.85
Stripe fees −38.15
Shipping labels −215.97
Software: Shopify Basic + domain −50.28
Meta ads −60.00
Net profit 392.45

Customers paid $1,066.44 across the month. After product supplies, shipping labels, fees, software, and ads, the shop kept $392.45 as net profit, which is about 37 cents of every dollar. That is the number in our Reel. Remember that this profit is before paying yourself and before income tax.

Sales tax is money you’re holding

In October, 5 of the 24 orders shipped to addresses inside Pennsylvania, so they were charged Pennsylvania sales tax at 6%, or $10.44 in total. That cash arrived inside your Stripe payouts, but it belongs to the state, not to your store. You must record it as a liability, which means money you owe, rather than counting it as revenue. Each state has its own rules for when you must register, collect, and file. To learn how states track this and what tools can help, see sales tax software for online stores and business basics for a US online store.

Why October’s bank deposits look smaller

If you add up the Stripe deposits that hit the bank during October, they only total $924.03. Stripe paid out $1,028.29 for October’s orders in total, but the last payout of $104.26 for 2 orders did not land in the bank until November 3. Bookkeeping tools let you report on a cash basis, where you count money when it arrives in the bank so that $104.26 counts in November, or on an accrual basis, where you count the sale when the order happens in October. Pick one method, keep it the same every month, and ask your tax professional which one you should file on.

Do it in Xero, QuickBooks or Wave

We have not run Wickfield’s month through these three tools yet. When we do, this section will get screenshots, timings, and notes on what each one got wrong. The three-line payout split shown above works the same way in all of them.

Tool Plan to start on What to know Price checked
Wave Starter, $0 Pro is $19/mo Oct 3, 2026
QuickBooks Simple Start, $38/mo 30-day free trial; 1 user Oct 3, 2026
Xero Early, $27/mo 20 invoices and 5 bills a month Oct 3, 2026

Software prices change, so check the pricing page before you sign up. You can also read our full ranking of the best bookkeeping software for an online store. To try this yourself, download orders_oct2026.csv and bank_oct2026.csv. You can import the bank file into any of the three tools to practise without connecting your real bank account.

When to bring in a bookkeeper

Doing your own books on a simple month helps you see where your money goes. Still, you do not have to do it forever. Bring in a bookkeeper when you start selling in several states, when you hold inventory that you need to count at year end, when you hire anyone, or when tax season makes you guess at answers. You do not need to hand over everything at once, either. Many bookkeepers will happily review a month that you reconciled yourself and point out what to fix.

This is a bookkeeping walkthrough on demo numbers, not tax advice.

Frequently asked questions

Is the money Stripe sends me my revenue?
No. A payout is what customers paid, minus Stripe's fee. It also includes any sales tax you collected, which belongs to the state.
Is sales tax part of my sales?
No. You collect it for the state and pay it over later. Record it as money you owe, not as income.
Do I need bookkeeping software in month one?
Not necessarily. With a few dozen orders a spreadsheet works if you split each payout the same way every time. Software helps once bank lines pile up.
Is this tax advice?
No. It shows the bookkeeping steps on a demo shop's numbers. Ask a tax professional about your own state and filing.

Written by

Kitmere

Kitmere is an independent publication. We read the official sources, test tools on real tasks and write down what we find.