Print on Demand Order Ledger Spreadsheet, POD Income and Expense Tracker with Cash Per Order, Excel and Google Sheets Template
Price:$7.21
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
See how much cash you keep from each print-on-demand order once production, shipping, fees and refunds come out.
WHAT IT IS
A cash ledger set up for print-on-demand sellers. Log the customer payment and every cost for an order under the same order ID. The Summary tab shows the cash retained per order, plus monthly and category totals and an all-dates total.
WHO IT'S FOR
• Print-on-demand sellers of apparel, mugs, prints, stickers and more
• Sellers who want to spot orders that cost more than they brought in
• Anyone who wants a simple per-order record without accounting software
WHAT'S INCLUDED (4 tabs)
• Instructions: short step-by-step guide
• Transactions: date, order ID, category, money in, money out (up to 500 rows)
• Categories: preset Order payments, Production, Fulfillment shipping, Processing fees and Refunds, editable up to 30 categories
• Summary: 12 monthly totals for the year you choose, category totals, cash retained for up to 500 orders and an all-dates total
A full year of sample orders (January to December 2026) is filled in: 40 orders over 162 transactions, including two refunded orders. Look around, then replace them with your own.
HOW IT WORKS
1. Type only in the blue cells. Gray cells calculate for you.
2. Enter the customer payment as money in, with the order ID.
3. Enter the production cost, shipping, processing fees and any refund as money out, with the same order ID.
4. The Summary lists each order once with its money in, money out and cash retained.
5. Type a year on the Summary tab to see that year month by month.
Use one currency throughout. This is the same design as our Income & Expense Ledger, set up with order IDs, print-on-demand categories and sample orders.
IMPORTANT
This is a cash record, not tax or accounting advice. It records money in and money out. It doesn't calculate tax and isn't a replacement for an accountant. It doesn't connect to any print provider or store. You enter the figures yourself.
COMPATIBILITY
• Microsoft Excel (.xlsx file)
• Google Sheets: upload the file to Google Drive, choose Open with > Google Sheets, then File > Save as Google Sheets
• Standard formulas only: no macros, no add-ins, no sign-up
INSTANT DIGITAL DOWNLOAD
This is a digital file. No physical item will be shipped. You can download it as soon as your purchase is complete.
Please note: this template was created with the help of AI tools and reviewed before release.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
Maker Spreadsheet Bundle, 7 Workbooks: Inventory, Candle, Jewelry and Bakery Trackers, Bookkeeping and Repricing, Excel and Google Sheets
$15.40
-
Digital download
Catalogue Repricing Spreadsheet, Bulk Product Pricing and Profit Margin Calculator for Handmade Sellers, Excel and Google Sheets Template
$4.86
-
Digital download
Home Bakery Inventory and Batch Cost Tracker, Ingredient Cost Per Bake and Recipe Costing Spreadsheet, Excel and Google Sheets Template
$7.21
-
Digital download
Jewellery Inventory and Materials Cost Tracker, Jewelry Spreadsheet for Bead, Wire and Findings Cost Per Piece, Excel and Google Sheets
$7.21