Purchase Order with Price List
Combined template featuring a purchase order form and integrated price list for vendor procurement and pricing reference.
This template combines a purchase order sheet with an accompanying price list, allowing users to reference product pricing while creating purchase orders. It includes company details (Gem & Co.), vendor information fields, line items with quantities and pricing, and a separate price list sheet for easy price lookups. The template uses SUM functions to calculate order totals and is designed for streamlined procurement workflows.
What's inside
- Purchase order form with vendor and line item details
- Integrated price list reference sheet
- Automatic total calculations using SUM functions
- Company information pre-populated
- Instructions for template usage
Download this template
.xlsx · 3 sheets · included with lifetime access
More in Invoicing & Billing
Account 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
Account 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
Account 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
Account 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