Purchase Invoice Template
A comprehensive purchase invoice system with product list management, tax settings, and vendor tracking for B2B transactions.
This purchase invoice template provides a complete invoicing solution for managing purchase orders and transactions. It includes a primary purchase invoice sheet with vendor details (company name, contact information, address, phone), sales personnel tracking, P.O. numbers, requestioner information, and shipping terms (Ship Via, F.O.B Point, payment Terms). The template features an integrated Product List Management sheet for maintaining inventory with product IDs (auto-generated using formulas), product descriptions, pricing per unit, inventory quantities, and storage locations. A SET UP sheet controls tax rates and discount percentages globally. Instructions are provided for proper template usage. The template uses IF, ROW, and TEXT functions for dynamic product ID generation and conditional logic.
What's inside
- Vendor/supplier information section
- Sales personnel and requestioner tracking
- P.O. number and shipping term fields (Ship Via, F.O.B Point, Terms)
- Product List Management with auto-generated product IDs
- Inventory tracking by location
- Dynamic pricing per unit
- Global tax rate setting (4%)
- Global discount percentage setting (10%)
- Formula-based product ID generation (CK- prefix)
- Conditional logic with IF statements
Download this template
.xlsx · 4 sheets · included with lifetime access
More in Invoicing & Billing
Invoicing & BillingAccount Payable V12
Track purchase orders, supplier payments, and aging analysis with automated reconciliation.
- PO log with issue dates and supplier tracking
- Payment terms configuration with flexible day calculations
- AP aging chart showing not-due vs. overdue amounts
Invoicing & BillingAccount Receivable V12
Track invoices, customers, and payment aging to manage outstanding receivables efficiently.
- Invoice log with date and amount tracking
- Payment terms configuration by customer
- Automatic AR aging calculation by due date
Invoicing & BillingAccount Statement Template
Professional account statement with configurable company details and conditional formatting for billing.
- Centralized settings sheet for company details
- Conditional display of company information
- Pre-formatted statement layout
Invoicing & BillingAccount Statement with Customer Details
A comprehensive account statement template that displays customer information and financial transactions with dynamic lookup capabilities.
- Dynamic customer lookup using XLOOKUP
- Customer details tracking (ID, contact, email, address)
- Professional header formatting