FREE SHOPIFY BOOKKEEPING TEMPLATE
SHOPIFY BOOKKEEPING TEMPLATE a year of Shopify bookkeeping on four sheets
Enter what your store and your ad accounts tell you once a month, log the costs that arrive by email, and your profit and loss builds itself. About twenty minutes a month, and no accounting jargon to learn first.
Four sheets, no macros, one worked year already filled in.
WHAT’S INSIDE
Twelve months, one evening a month
The monthly grid
Product sales, shipping, refunds, cost of sales, fees and advertising, one row per month. Gross profit, net profit and both margins work themselves out, so you can see the shape of your year rather than just its total.
An expenses log that feeds itself through
Software, accountancy, insurance, postage and the rest, logged as they happen with a category on each one. The monthly grid picks them up automatically, so nothing gets typed twice and nothing gets forgotten.
A year summary and a VAT memo
The annual profit and loss, your gross and net margins, your best and worst months by profit rather than sales, and a quarterly VAT estimate to help you set the money aside before the return lands.
