Purchase Order Tracker Spreadsheet — Monthly Tabs, Auto-Numbering, Running Totals Digital Download

A done-for-you Excel workbook to track purchase orders month by month. Pre-built tabs for May–December, auto-numbering PO format, running monthly totals, dropdown menus, and a full instruction tab so you can reuse it year after year.

Stop juggling notebooks, sticky notes, and shoebox receipts. This Purchase Order Tracker gives you a clean, professional system for logging every PO your team writes — instantly searchable, sortable, and reusable for years.

What's inside:

• 8 pre-built monthly tabs (May through December 2026)
• Auto-numbered PO column per month (e.g., 05-26-001, 06-26-001…)
• Live running total at the top of each tab — updates as you enter amounts
• Dropdown menu for payment Type (CC, Check, Billable)
• Click-to-toggle indicators for AWR (A Workorder Returned) and Reconciled status
• Tracks: Job ID, Customer, PO #, Vendor, Amount, Tech, Manager Approval (MAPP), Payment Type, AWR, Reconciled
• Detailed Instructions tab covering reuse for future years, customizing PO formats, and adding Tech / Vendor dropdowns

Who it's for: Electricians, contractors, HVAC, plumbing, landscaping, and any service business that needs to keep purchase orders organized without expensive software.

Format: Excel (.xlsx) — works in Excel, Excel for Mac, Excel Online, and Google Sheets. Delivery: Instant download.