# Upload Bank Statement

Before beginning any bank reconciliation, make sure that your opening balance has been created in Xoro using journal entries and that the bank statement has been uploaded.

You can upload the bank statement using the steps mentioned below:

* Choose a bank account.
* Download the bank transactions.
* Download the latest CSV template.
* Copy the bank statement information into the CSV template.
* Upload the template into Xoro.

### Choosing a bank account

Select the bank account from the drop-down for which you want to upload the statement.

<figure><img src="/files/6cDNNPMZkEXyVVzwjGMy" alt=""><figcaption></figcaption></figure>

### Downloading the bank transactions

Once you have selected the bank account, proceed to download your bank transactions.

* Go to your bank website.&#x20;
* Download your bank statement. Please note that the file type for the bank statement file must be one of the following:
  * OFX
  * QIF
  * CSV

### Downloading the CSV template file

* Go to the “**Upload Bank Statment**” module using the search menu.
* Click on **“Download template”.**

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

### 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.

{% hint style="info" %}
**Please Note:**&#x20;

* If you downloaded. OFX or. QIF, you don’t need to verify the template and can directly upload the file.
* But, if you downloaded .CSV file, please make sure the file format matches the required template.
  {% endhint %}

Below are some points to be noted when entering the data into the template.

* 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 of the 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.
* Be mindful of any leading zeros in your data, some spreadsheet software will trim them automatically without notifying you. This can be resolved by ensuring your columns have correct formatting.
* Sometimes long numbers (UPC, etc.) are formatted as scientific notation. Be sure to change the formatting on this data to display these long numbers correctly.

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

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

#### Upload Bank Statement Template Fields

<table><thead><tr><th width="168">Column Name</th><th width="114.33333333333331">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>**Date</td><td>Text</td><td>Enter the date of the transaction in MM-DD-YYYY format.</td></tr><tr><td>**Amount</td><td>Numeric</td><td>Enter the numerical amount (without commas) of the transaction in decimal format.</td></tr><tr><td>Payee</td><td>Text</td><td>Enter the Payee for the transaction.</td></tr><tr><td>Description</td><td>Text</td><td>Enter the description of the transaction.</td></tr><tr><td>Reference</td><td>Text</td><td>Enter a unique reference of the transaction for tracking purposes.</td></tr><tr><td>ChequeNumber</td><td>Text</td><td><p>Enter a Cheque # for the transaction.</p><p><strong>For Bank Accounts</strong>: Use + values for deposits into your bank and – values for payments.</p><p><strong>For Credit Card Accounts</strong>: Use + values for payments made toward paying off your credit card and – values for charges placed on your card.</p></td></tr></tbody></table>

### Uploading the template

Once you have filled out 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/ulr95UbhvJHr0Mts1RbJ" alt=""><figcaption></figcaption></figure>
* After the file has been selected, click on **Verify & Upload.**

  <figure><img src="/files/d5569gSsjYoegoJkbjYq" alt=""><figcaption></figcaption></figure>
* In the 'Bank Statement File Preview' window, review the data and click on "Upload Statement" to start importing.

  <figure><img src="/files/aBtDczh0s0gKXeSI7G3z" alt=""><figcaption></figcaption></figure>
* After the import is completed, the system displays the result with either a success message or error details (if any).

  <figure><img src="/files/cPrBNo9GzR9HSrNIb878" alt=""><figcaption></figcaption></figure>
* The bank statement will only be uploaded if the file passes validation with no errors. If errors are detected, the system prevents the upload and highlights the issues in the preview screen. Common reasons for errors include:
  * Incorrect date format (must be MM-DD-YYYY)
  * Missing mandatory fields
  * Modified or incorrect column headers
  * Invalid file format
* To resolve errors, review the error details shown in the preview and correct the data in the original file. After changes, re-upload the updated file 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-bank-statement.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.