All imports

Purchases

Import purchase invoices. Groups lines into purchases, resolves items and vendors.

Pro

Supported Formats

BasilBook Template (.xlsx / .csv)

One row per line. Group by referenceNumber.

Column Reference

ColumnRequiredDescription
purchaseDateDate (YYYY-MM-DD)
itemNameItem name (must exist)
quantityQuantity
unitUnit (kg, liter, etc.)
unitPricePrice per unit
vendorNameVendor (auto-created if new)
referenceNumberPO / invoice number
currencyCurrency code
notesNotes

How It Works

  • Items must exist (matched by name)
  • Vendors auto-created when not found
  • Stock movements generated for tracked items
  • Journal entries auto-generated per purchase — learn more at /auto-journal

API Endpoint

POST/api/purchases/import

Ready to import purchases?