> ## Documentation Index
> Fetch the complete documentation index at: https://www.aiaccountant.com/help/llms.txt
> Use this file to discover all available pages before exploring further.

# Upload and map your purchase register

> Upload your books as Excel or CSV, review the column mapping for each file, and import.

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.

| Setting      | What to set                                                               |
| ------------ | ------------------------------------------------------------------------- |
| Header Row   | The row your column headings sit on.                                      |
| Voucher Type | Regular, Credit Note, or Debit Note, depending on what the file contains. |

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.

<Note>
  Rows with zero tax value are excluded from reconciliation automatically, so you do not need to clean those out yourself.
</Note>

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.

<Card title="Read the results" icon="chart-column" href="/help/gst/read-reconciliation-results">
  Understand what each match status means for your credit.
</Card>
