App Installation

After, Purchase app you need to install "Excel Import & Reconciliation for Customer Invoices and Refunds" app.

Overview

This app enables you to efficiently import and reconcile large volumes of customer payments for invoices and refunds. It supports both full and partial payment reconciliation based on imported data, with easy import functionality via Excel (XLSX/XLS). Additionally, you can seamlessly monitor and track error logs during the import process for smooth operations.

Configurations/Settings

To enable the Import Sales Payment feature, you'll need to grant the appropriate access rights to the user. Start by enabling the "Allow Import Sales Payment" option, which will allow the user to perform the import. Follow the steps outlined in the images below to set up these access rights.

How to Import Customer Invoice Payments Using Excel

Once access rights have been granted to the user, the "Import Sales Payment" menu will become visible. Refer to the images below for a visual guide on where to find this menu.

For example, we will pay the invoice for the following sales order. Note: The invoice must be in the "Open" stage.

To import Customer Invoice Payments / Customer Refund Invoice Payments, ensure the file format matches the example shown in the image below.

Steps for Importing Sales Payments

1. Create a New Import Sales Payment Record
After creating the record, fill in the required details:
    1.1 Import Excel File: Select the Excel file you wish to import.
        Note: Only XLS/XLSX files are supported.
    1.2 Payment Date: Payments will be recorded based on this selected date.
    1.3 Payment Type: Choose the correct payment type for your import.
        1.3.1 For importing Customer Invoice Payments, select Customer Invoice Payment.
        1.3.2 For importing Customer Refund Invoice Payments, select Customer Refund Payment.
                            

Verify File Data After selecting the file, click on the Verify File Data button. This will check for any issues in the imported data. If there are errors, a warning will be displayed in the Message column of the verified and imported records.

Process Payments and Reconcile Invoices
To finalize the process, click on the Process Payments button. This will process all the imported payment records and reconcile the invoices as paid.
You can view the paid invoices in the following examples.

Additional Features

1. Manually Adjust Imported Payment Amounts: If needed, you can manually change the payment amounts in the imported records.
2. Manually Pay Specific Invoices: You can manually pay a particular invoice by clicking on it.
> This feature is especially useful if there's a warning regarding the imported amount.

How to Import Customer Refund Invoice Payments Using Excel

To import Customer Refund Invoice Payments, ensure you select the payment type as Customer Refund Payment. The process is similar to importing Customer Invoice Payments, and the file format should match the example mentioned earlier. Follow the same steps to complete the import and reconciliation.