ORDERTRACKER / SMALL BUSINESS STARTER KIT
Give one order
a clear home.
You do not need a complicated system to begin. Start with one job and use the same order reference on every file you need.
Choose the job in front of you
- Taking a request? Open the custom order form. Confirm the specification, quantity, price, promised date and pickup or delivery details. Print blank or fill it in and save a PDF before closing.
- Tracking work? Open the order tracker workbook. Replace the labelled example with one row per order. Update the stage and due date as work changes.
- Waiting for money? Open the deposit workbook. Keep the requested deposit separate from confirmed payments. Enter the cumulative amount received, not just the most recent payment.
- Checking artwork? Open the approval checklist. Record the exact proof version and the actual customer response. Keep their original reply separately.
- Checking a price? Use the costing worksheet or the online job profit calculator. Include labour and other costs, not just materials.
One example: a sticker order
A fictional café orders 500 stickers for $240. You request $120 as a deposit, but have received $80. The unpaid requested deposit is $40. The full unpaid order balance is $160. Neither figure is your profit.
If this example job has $150 of included costs, estimated profit is $90 and margin is 37.5% ($90 ÷ $240). This is a simplified example, not a tax calculation or a promised result.
A five-minute review
- Which orders are due next? Confirm the next action and promised date.
- Which jobs need information or artwork approval before work can continue?
- Which payments have actually arrived? Compare records with your payment provider.
- Which jobs are finished? Update the order and save a private backup.
Keep customer information private
Save your completed files somewhere only the right people can access. Keep one currency per workbook. The workbooks have 100 working rows and a labelled example; check calculations after opening in another spreadsheet app. These are not direct CSV import files for OrderTracker.
Printable forms can lose typed entries when closed or refreshed. Print or save a PDF first. The order form is an information worksheet, not an invoice or contract.
When a connected workspace helps
If you need customer history connected to orders, explore the BeaStickersCo walkthrough. Create a separate OrderTracker account, then choose Free without a card or an eligible 14-day paid-plan trial with a verified card. Review the first charge date before confirming.
Prepared November 9, 2026. Free to adapt for your own business. Educators may share this kit with its guide and attribution, or link to ordertracker.ca/templates for current files. Operated by BeaStickersCo.