Inward Supply CSV Import & Reconciliation

BillYantra lets you import your inward supply (purchase) data from the GSTN portal or accounting software like Tally and automatically compare it against your recorded purchases. This helps you spot discrepancies before filing GSTR-3B.

Why Import Inward Supply?

• Quickly add purchases from many vendors without manual data entry
• Reconcile your books against the GSTN portal's GSTR-2B data
• Identify missing supplier invoices or amount mismatches before filing
• Add new vendors to your vendor list automatically from the import

How to Import

1. Go to Purchase → Import Inward Supply.
2. Click Download Template to get the expected column format.
3. Prepare your CSV (from GSTN portal, Tally, or any accounting software — column aliases are detected automatically).
4. Upload the CSV file.

Supported CSV Formats

BillYantra auto-detects columns from these sources:

Reconciliation Results

After upload, BillYantra shows four tabs:

New

Vendor invoices found in the CSV but not yet in your purchases. You can import all or selected rows to add them as new purchase records.

Mismatch

Invoices where the vendor and bill number match an existing purchase in BillYantra, but the amount differs by more than ₹1. Review each row — the difference is shown — and decide whether to update your record.

Matched

Invoices where everything (vendor GSTIN, bill number, amount) matches your existing records. No action needed — these are your reconciled entries.

Missing

Invoices in your BillYantra records that are not present in the imported file. These may be invoices your vendor has not yet filed in their GSTR-1, which could affect your ITC claim.

Applying Changes

• Click Apply Changes to import all "New" rows and update all confirmed "Mismatch" rows at once.
• New vendors in the import are created automatically in your vendor list.
• You can reject individual rows before applying by unchecking them.

Tips for Accurate Reconciliation

• Always import the GSTR-2B download from the GSTN portal for the period you are filing.
• Match is done on Vendor GSTIN + Bill Number (case-insensitive, spaces ignored).
• Reconcile monthly before the GSTR-3B due date (20th of next month).

Note: The CSV import supports up to 500 rows per file. For larger imports, split the file and import in batches.