Kolumn

03 / 20 · Purchasing and stock

Purchase order tracker

Every purchase order, payment and delivery date in one place.

SEK 119

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

Keep track of every purchase order: what is ordered, paid, shipped and when it should arrive. The template calculates deposit, balance, days to arrival and flags late orders.

What you get

Sheets
Overview, Orders
Each file also has an instructions sheet and a lists sheet.
Formulas
183
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Add one row per order on the Orders sheet.
  2. Choose currency and status from the lists.
  3. Enter the dates when the deposit and the balance were paid.
  4. The Overview sheet totals orders per status and outstanding amounts per currency.