Purchases

Upload purchases

Record a lot of stock you bought in one go, from a spreadsheet. You check every line before anything is saved.

1

Fill in the template

One row per item you bought. Use item names exactly as they are in your item list.

  • Item_Name the item, spelled as in your list
  • Date the day you bought it
  • Purchase_Rate what you paid for one
  • Quantity how many
  • Paid_Amount how much you have paid so far
  • Vendor_Name optional, who you bought from
  • Payment_Type optional, how you paid (Cash if empty)
Download the template
2

Choose your file

An Excel file (.xlsx or .xls). Only the first sheet is read.

Getting your items, vendors and payment types…

Prefer to type them in? Use Purchases. To correct stock counts (damage, expiry, a recount), use Upload stock adjustments instead.