• Preview of Purchasing Card Transaction Log and ReconciliationExcel workbook preview

Purchase Orders, Requisitions and Purchasing

Purchasing Card Transaction Log and Reconciliation

$17.99 Free XLSX
Excel workbook · 14 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

Who this is for

A cardholder or card approver who must reconcile the monthly purchasing card statement before the deadline and explain every flagged transaction.

What is inside

  • 12 sample transactions with net and tax split and GL coding
  • Automatic flags: over the single transaction limit, no receipt, blocked category, possible split purchase
  • Card limits and blocked categories on the Settings sheet
  • Reconciliation sheet: log total against statement total and the difference
  • Counts of flags, missing receipts and items not on the statement
  • Cardholder and approver sign-off block

How to use it: Enter the card limits and blocked categories on the Settings sheet, log every transaction with its receipt, then reconcile to the bank statement and sign before the monthly deadline.

Files & formats
  • XLSXpurchasing-card-transaction-log-and-reconciliation.xlsx14 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.

Free downloads & full access

Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.

Bought with a different email? Open your account and enter your order number.

Licence

Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.