Overview
The system has the option to upload an excel file that contains payment records, so that payments can be massively processed using this file.
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
Instructions
Follow the steps below:
- Go to Account Receivables > Receive Payment.
- Click on the "Receive Payment From Excel File" link.
- 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 click within the dotted area to search and select the file to upload.
- The company 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.
Relevant Articles
Admins and Accounting have access to payment pages.