--- title: "Spare Parts Stock Register Format (Excel) | ServicePilot" description: "Spare parts stock register format for service businesses: opening stock, received, issued to jobs and technicians, balance and reorder level. Free Excel CSV." url: https://servicepilot.in/blog/field-service-software/spare-parts-stock-register-format/ canonical: https://servicepilot.in/blog/field-service-software/spare-parts-stock-register-format/ site: ServicePilot section: Blog articles updated: 2026-10-30 keywords: "spare parts stock register format" language: en-IN --- Field Service Software # Spare Parts Stock Register Format for Service Businesses By the ServicePilot Team · Published 30-10-2026 Spare parts list format Photo by [Rodrigo Rodrigues | WOLF Λ R T](https://unsplash.com/photos/woman-working-on-a-laptop-with-spreadsheet-data-hpbduAj7wew?utm_source=servicepilot.in&utm_medium=referral) on [Unsplash](https://unsplash.com/?utm_source=servicepilot.in&utm_medium=referral) A spare parts stock register format has one row per movement: date, part name and code, opening balance, quantity received (with supplier and bill), quantity issued (with job number and technician), returned, closing balance and reorder level. Count physical stock monthly and match it to the register; differences point to parts used but not recorded. [Download the stock register (CSV, opens in Excel) CSV, opens in Excel or Google Sheets · 1 KB · free to edit Download](https://servicepilot.in/downloads/spare-parts-stock-register.csv) Capacitors, filters, membranes, gas cylinders, cameras, adaptors: every service business carries parts, and most lose money on parts used but never billed. A spare parts stock register format that records every receipt and every issue against a job closes that leak. Download the CSV below. ## Spare parts stock register format: columns - Date - Part name and code (one code per part, used everywhere) - Opening balance - Received: quantity, supplier, bill number - Issued: quantity, job number, technician - Returned (unused parts back from site) - Closing balance - Reorder level and remarks ## Rules that make the register honest - No part leaves the store without a job number. - Van stock is "issued to technician" and settled weekly against jobs done. - Faulty parts removed from site come back and are logged, especially under warranty. - Physical count every month; investigate every difference. ## Set reorder levels For each fast-moving part, note how many you use in a typical week and how many days the supplier takes. Reorder when the balance covers only that lead time plus a small buffer. Raise levels before your peak season (summer for AC, monsoon for pest control). ## Parts and billing Every part issued should end up on an invoice or be marked as covered by a comprehensive AMC. Compare parts issued with parts billed each month; the gap is your leak. ## Stock and jobs in one system ServicePilot's [inventory](https://servicepilot.in/features/inventory-and-purchasing/) holds products and vendors, purchase orders and goods receipts, and records parts used on each [job](https://servicepilot.in/features/jobs-and-scheduling/), so stock, jobs and invoices agree. See the [technician daily report format](https://servicepilot.in/blog/technicians-field-staff/technician-daily-report-format/) for parts used per day. [In ServicePilot See inventory management for service firms in ServicePilot How ServicePilot handles this for your business, with a free demo.](https://servicepilot.in/features/inventory-and-purchasing/) Frequently asked questions ## Questions people ask **Q: Why record the job number when issuing a part?** A: It ties every part to a job and an invoice, so parts used are billed or covered by an AMC, not lost. **Q: What is a reorder level?** A: The balance at which you buy again, set from how fast the part is used and how long the supplier takes. **Q: Should technicians hold stock?** A: Many firms give technicians a small van stock. Record it as issued to the technician and reconcile it weekly. **Q: When does Excel stop working?** A: When several people issue parts at once or you need stock per branch. Then a shared system is easier. ## Related articles [Field Service Software Service Job Card Format for Field Service Teams Service job card format for field service teams: job number, customer, site, complaint, work done, parts, time, charges and sign-off. Excel-ready CSV download. Read the article](https://servicepilot.in/blog/field-service-software/service-job-card-format/)[Field Service Software Technician Tracking Software: What to Track and What Not To Technician tracking software for service firms: what to track (jobs, attendance, availability, completion), what not to, and how to do it without GPS spying. Read the article](https://servicepilot.in/blog/field-service-software/technician-tracking-software/)[Field Service Software How to Choose Field Service Software in India How to choose field service software in India: a practical checklist covering AMC, dispatch, GST billing, mobile use, support and cost. Read the article](https://servicepilot.in/blog/field-service-software/choose-field-service-software-india/) Recent articles - [Pest Control - Bed Bug Treatment Cost: How Pest Control Firms Should Price](https://servicepilot.in/blog/pest-control/bed-bug-treatment-cost/) - [CCTV & Security - CCTV Preventive Maintenance: Scope of Work and Report](https://servicepilot.in/blog/cctv-security/cctv-preventive-maintenance/) - [AMC Management - Breakdown Maintenance Format for AMC and Service Firms](https://servicepilot.in/blog/amc-management/breakdown-maintenance-format/) - [Fire Safety - Fire Extinguisher Refilling Price List: A Format to Set Your Rates](https://servicepilot.in/blog/fire-safety/fire-extinguisher-refilling-price-list/) - [AMC Management - AMC Certificate Format for Service Companies](https://servicepilot.in/blog/amc-management/amc-certificate-format/) [View all articles](https://servicepilot.in/blog/)