Print on Demand Seller Bookkeeping Spreadsheet

About this template

This print on demand bookkeeping spreadsheet shows your real margin after fulfillment, not the figure before it. It is made for POD sellers who want to know what each sale leaves once the printing and shipping partner has been paid.

Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).

Fulfillment cost on its own line

Fulfillment cost is a category of its own, so the gap between a sale and what you keep stops being a surprise at the end of the month. Used as a profit tracker, it shows that gap every month and every quarter.

One entry per line

Every sale goes on the Income tab and every cost on the Expenses tab, with a tax rate chosen per line. The monthly and quarterly views, profit and loss, sales tax worksheet and dashboard all calculate from those two registers. Nothing is retyped, and no report can contradict the ledger.

15 connected tabs

Fifteen connected tabs sit behind the dashboard:

• Income: 500 rows, with the tax split out on every line
• Expenses: 500 rows, split the same way
• Setup: your categories, your tax rates and your set-aside percentage
• Monthly, Quarterly and Profit & Loss: all calculated, nothing typed
• Sales Tax: collected against paid, by rate and by quarter
• Estimated Tax: four quarterly set-asides at your own rate
• Custom Range: pick any two dates and every figure follows
• Comparison: this year against last, month by month
• Balances: what each account took in and paid out
• Dashboard: six live figures and the four quarters
• Start Here: setup in a few minutes

Real files, filled and blank

You get real spreadsheet files, not a PDF with a link in it: Excel and Google Sheets, each filled with a worked example and each blank and ready for your own numbers. The filled copy is the file in the photos, with two full years of demo data so the Comparison tab has something real to compare.

It is a small business ledger with no marketplace connection: you enter the figures from your own payouts and invoices.

Works with

• Microsoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.
• Google Sheets with a free Google account. No Google account is needed for the Excel files.
• No add-ins, no macros, no subscription and no bank connection

What you download

• The Excel workbook filled with a worked example, and the same workbook blank and ready for yours
• The instruction guide, which has one-click links to the Google Sheets versions (filled and blank)
• The terms of use as a PDF

Your files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for use in your own business; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.

Frequently asked questions

Does it work in both Excel and Google Sheets?

Yes. You download Excel files for Excel 2016 or later, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.

How is fulfillment cost handled?

Fulfillment cost has its own expense category, so the profit and loss and dashboard show what you keep after it is paid.

Does it import orders from my shop or POD partner?

No. There is no connection to any platform or bank, and no add-ins or macros. You enter or paste your figures on the two registers.

Can I set money aside for tax?

The Estimated Tax tab calculates four quarterly set-asides at the rate you choose on Setup.

Is there a filled example to learn from?

Yes. The filled copy is the file shown in the photos, with two full years of demo data, and a blank copy comes with it.