Overview

Excerpt
The system has the option to upload an excel file that contains payment records, so that payments can be massively processed using this file.

Info
You will be able to download a template where the information required will need to be added prior to uploading the file.

The template contains the following columns:

Invoice #

Customer code

Payment Method

Date Paid

Discount

Amount Paid

Reference Number

Notes

Download here an example of the file.

Instructions

Follow the steps below:

Go to Account Receivables > Receive Payment.
Click on the "Receive Payment From Excel File" link.
Image Removed
This will then take you to the screen where you download/upload the template.
Download the sample excel file and update it.
Upload it when you are done, by dragging the saved file to the dotted area, or clicking within the dotted area to search and select the file to upload.
Image Removed
The company's accounting user that uploaded the file, will receive an email with the results of this upload. Successful and error messages will be provided within the email.

Panel

title

Relevant