Skip to main content
The purchase register is your side of the reconciliation: what your books say you bought.

​
Upload the files

In the Purchase Register section, click Upload Purchase Registers and add your files.
  • Excel and CSV are both supported.
  • You can upload more than one file at a time, for example a separate file each for regular purchases, journal register, credit notes, and debit notes.

​
Map the columns

A Map Your Columns window opens for each file, so the system knows how to read your sheet. AI Accountant maps the columns automatically. Review them before saving. Then check that each field points at the right column in your file: GSTIN, Vendor Name, Invoice Number, Invoice Date, Voucher Date, Invoice Amount, Place of Supply, Rate, Taxable Amount, individual GST, and Remarks. Confirm the date format matches as well.
Rows with zero tax value are excluded from reconciliation automatically, so you do not need to clean those out yourself.
Click Save Mapping, and repeat the review for each file.

​
Import and run

When all files are mapped, an Upload Summary lists each one marked Ready. Click Import Files. With portal data on one side and your purchase register on the other, click Run Reconciliation. Results appear in a few seconds.

Read the results

Understand what each match status means for your credit.