In addition to uploading individual payments manually via payment allocation in the Finance app, multiple payments can be uploaded in bulk for trading programs.
This article will guide you through:
- Downloading the bulk payment template
- Populating the bulk payment template
- Uploading the bulk payment template
Looking for something else?
- Need to record adjustments in bulk? Learn how to bulk upload adjustments here.
- Looking to record payments manually? Learn how to record and allocate payments through the Enable interface here.
Downloading the bulk payment template
To download the payment allocation template:
Step 1: Click on Finance in the green banner at the top of the page.
Step 2: Click on Uploads in the drop-down menu.
Note: If you are unable to see the Finance menu, a channel admin user may need to provide you with the correct user permissions.
Step 3: Within the Payment uploads tab, click the Upload button in the bottom left of the page. You will automatically be navigated to the payment uploads wizard.
Step 4: Click on Download import template to save the Payments Template CSV file to your computer’s downloads folder.
Populating the bulk payment template
Once the payments template has been downloaded, you will need to populate each row with the following column data for your payment allocations. Column headers must not be changed or renamed in the file.
- Trading partner name: The name of the trading partner the payment is attached to. This should match the trading partner name displayed in Enable. Learn how to find the names of your trading partners in Enable here. Note: If you populate the trading partner name column, you should leave the trading partner reference column blank.
- Trading partner reference: The reference of the trading partner the payment is attached to. This should match the trading partner reference displayed in Enable. Learn how to find the references of your trading partners in Enable here. Note: If you populate the trading partner reference column, you should leave the trading partner name column blank.
- (Mandatory) Currency: The currency used for the payment (e.g. USD, GBP, CAD etc.).
- (Mandatory) Payment value: The total value of the payment being made or the payment received. Do not use commas to separate thousands, "-" to denote zero, or parentheses to denote negatives; simply use the number without these, using a leading negative sign if required.
- (Mandatory) Tax: The tax value that should not be allocated to the payment lines. If there is no tax, populate it with 0.
- (Mandatory) Payment method: The method of payment. The list of valid payment methods is displayed on the Instructions page after downloading the template. Note: If there are changes need to the listed Payment methods, reach out to the Enable Support team to ask about updating these options.
- (Mandatory) Date of payment: The date of the payment in the format YYYY-MM-DD.
- (Mandatory) External reference: A reference for the payment, e.g. an invoice number. This must be unique for the trading partner.
- (Optional) Notes: Any additional notes or information for each payment.
- (Optional) Reason code: Required if the sum of Allocated value columns does not equal the Payment value column, i.e. if the payment is being left unallocated or partially allocated. Reach out to the Enable Support team here to confirm the reason codes that have been set up in your channel.
- Allocated value: The proportion of the total payment value that is allocated to a given payment line. This payment line will be determined by the payment line ID. Do not use commas to separate thousands, "-" to denote zero, or parentheses to denote negatives; simply use the number without these, using a leading negative sign if required.
Note: Unallocated negative receipts cannot be loaded by the bulk load feature, even when negative receipts are allowed in the channel. These payments need to be uploaded through the Enable user interface; learn how to record payments manually here.
-
Payment line ID: The ID of the payment line that the proportion of the total payment value is allocated to. The payment line IDs can be found on the debtors/creditors report.
By default, there are three pairs of allocated value and payment line IDs. If you have more than 3 payment allocations to make, add more columns to the template (i.e. Allocated value 4, Payment line ID 4, Allocated value 5, Payment line ID 5, etc.). If you have less than 3 payment allocations to make, you do not need to delete the unused columns.
Uploading the bulk payment template
Once you have populated the template, you can then upload it through the UI.
To load the bulk payment template:
Step 1: Click on Finance in the green banner at the top of the page and click Uploads in the drop-down menu.
Step 2: Within the Payment uploads tab, click the Upload button in the bottom left of the page.
Step 3: Click the Next button to navigate to the Instructions page.
Step 4: Click the Next button to navigate to the Uploads page.
Step 5: Click anywhere in the Upload box to select the file from your directory, or drag and drop the file into the Upload box.
Once selected, the file will automatically start to upload. If there are any issues with the file, a Validation page is displayed; otherwise, an Upload summary page is displayed.
Step 6: If validation issues are displayed, review and address these before re-uploading the file. The column and row of each error will be specified on the Validation page. From the Validation page, click Back to navigate back to the Upload page to select the corrected file.
Step 7: Once the data has been uploaded successfully, review the Upload summary page to ensure the details are as expected.
The Upload summary displays summarized details from the file, including the number of payments, how many have been allocated versus unallocated, and the date range of the payments. This will also include the count of under-allocations and over-allocations. Under-allocations occur when the allocated value entered is less than the balance due for the payment line, and over-allocations occur when the allocated value entered exceeds the balance due for the payment line.
Step 8: To continue, click the Next button to navigate to the Upload attachments page.
Step 9: If applicable, upload up to three attachments per payment, such as receipts or invoices. These attachments are optional, so this stage can be skipped as necessary.
Step 10: Click the Next button to navigate to the Summary page, which confirms that your payments have been uploaded successfully.
Step 11: To continue uploading further data, click Upload a new file, or click Finished to navigate to the Payment history page.
All payments that have been uploaded will be displayed in the Payment history tab of the Finance app.
What’s next?
Interested in viewing payments and adjustments that have already been recorded in Enable? Learn more about your payment history here.