# Upload Invoice Payment

The invoice payment upload feature allows you to easily record and manage payments made towards the invoices. With this, you can efficiently upload payment information into the system, ensuring accurate tracking and reconciliation of your financial transactions. Whether you're paying by check, cash, or any other method, the Upload Invoice Payment feature simplifies the process by providing essential payment details such as payment date, method, amount, and invoice number.

To batch import invoice payments, follow the steps mentioned below:

* Download the latest CSV template.
* Copy the payment information into the template.
* Upload the template.

### Downloading the CSV template

* Go to the "**Batch Upload Invoice Payment**" module using the search menu.
* Click on the "**Download Template**" option.

  <div align="left"><figure><img src="/files/fNffUMCmv8M5pu1NcaMr" alt=""><figcaption></figcaption></figure></div>

### Copying the information into the template

Once you’ve downloaded the template file, you can copy your data using any spreadsheet software. There are columns that you must complete and others that are optional. Mandatory fields are marked with a double asterisk (\*\*) prefix.

Below are some points to be noted when entering the data into the template.&#x20;

* The file must be a CSV (comma-separated values) file. The name of your file must end with.csv.
* Make sure you don’t change any column headings from row 1 in the template; these are needed for the file to import correctly.
* All date fields will accept the MM-DD-YYYY format.

{% hint style="info" %}
If you’re importing more than 5,000 records, we recommend you split the file.
{% endhint %}

<figure><img src="/files/OlpPb6MAHvExJzfcsIZK" alt=""><figcaption></figcaption></figure>

#### Upload Invoice Payment Template Fields

<table><thead><tr><th width="254">Column</th><th width="112">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>**InvoicePaymentIdentifier</td><td>Text</td><td>This field represents a unique identifier for each invoice payment transaction. It serves as a reference to track and distinguish individual payments.</td></tr><tr><td>**PaymentDate</td><td>Date</td><td>Enter the payment date here.</td></tr><tr><td>**PaymentMethod</td><td>Text</td><td>Enter the method used for making the payment here, such as credit card, wire, cash, etc.</td></tr><tr><td>**DepositAccount</td><td>Text</td><td>Enter the account to which the payment is deposited or credited.</td></tr><tr><td>RefNo</td><td>Text</td><td>Enter the reference number for the invoice payment. This acts as a unique identifier for the invoice payment and helps to easily find the payment in the system.</td></tr><tr><td>ChequeNo</td><td>Text</td><td>If the payment method is "Cheque", enter the cheque number here.</td></tr><tr><td>Memo</td><td>Text</td><td>This field allows you to add additional information related to the invoice payment.</td></tr><tr><td>DiscountAmount</td><td>Numeric</td><td>If there's any discount applied to the payment, this field allows you to enter the discount amount. It helps track any deductions or adjustments made to the payment amount.</td></tr><tr><td>DiscountAccount</td><td>Text</td><td>This field allows you to specify the account where the discount amount is recorded or allocated. It identifies the ledger or account associated with the discount applied to the payment.</td></tr><tr><td>**Amount</td><td>Numeric</td><td>Enter the invoice amount in decimal format (example: 3245.12).</td></tr><tr><td>**InvoiceNumber</td><td>Text</td><td>Enter the invoice number to which the payment is applied. It establishes a link between the payment and the corresponding invoice for accurate reconciliation.</td></tr><tr><td>ImportError</td><td>Text</td><td>If there are any errors from an upload, they will be listed in this column.</td></tr></tbody></table>

### Uploading the template

Once you have filled the CSV file with your data, you can follow the steps below to upload it into Xoro:

* Click Browse to select the saved CSV template file.

  <figure><img src="/files/ZFm6HiqKzTvGY5kICsvG" alt=""><figcaption></figcaption></figure>
* After the file has been selected, click **Upload** to start importing.

  <figure><img src="/files/Czc8x60kJ9S1lomC24hD" alt=""><figcaption></figcaption></figure>
* While the import is in progress, the summary of the progress will be displayed at the bottom of the screen with the progress bar.
* After the import has been completed, the result will be displayed with a message for success or error (if any).

  <figure><img src="/files/ymxx0unDUWs7tiww5Qre" alt=""><figcaption></figcaption></figure>
* Addresses will only get uploaded into the system if there are no errors in the file. If there are errors in the file, you can download the error file, fix the errors in the **original file,** and upload it back into Xoro.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.xorosoft.com/xoroerp-1/utilities/data-imports/upload-invoice-payment.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.