Avirat
Stock

Bringing your stock in from Excel

Import the stones you already hold from a spreadsheet, as a purchase — or many purchases at once.

A new purchase in Avirat, with the Import Excel button marked
From the demo company — sample data. Click to see it full size.

How to

  1. For one supplier’s stones: open Buying → Purchases → + New Purchase, choose the supplier, and press Import Excel. Download the template, fill one row per stone, and upload it — the lines fill in; check them and press Save Purchase.
  2. For many purchases at once: on the Purchases list use Import from Excel. One row per stone; rows with the same Invoice No become one purchase.
  3. Press Check file first: it shows every invoice and any problem, row by row, before anything is saved.
  4. Fix the sheet if needed and upload again — invoices already imported are skipped, never added twice.

Good to know

  • Your stock in Excel and no time? WhatsApp us your file and we import it for you during your trial.
  • Parties (suppliers and customers) can be imported the same way from Parties → Import Excel.
  • Stones bought on a purchase appear in Stock straight away, at the cost on the purchase.

Open this screen in Avirat →

Related

Still stuck? WhatsApp or call us on +91 97262 88072, or use Help & support inside Avirat — we’ll see the screen you’re on.

Try it with your own stock

14 days free, everything switched on, no card needed.

Start free trialTry the demoTalk to us
WhatsApp us