This add-on allows you to import payments in bulk using an Excel template.
Enabling the Add-on
- Go to the Account & Settings tab and click on "Integrations & Add-ons"
- Use the search field on the right and enter "Import Payments"
- Click on "Enable" under the add-on's section
Once the add-on has been enabled, an "Import Payments" option will be displayed on the right hand side of the payments table.
You can follow the steps below to import payment records:
- Download the payment import template by clicking on the "Import Payments" option on the payments table.
The first row contains headings to identify each column. Do not modify this row otherwise the upload will not work.
- Columns in the file:
- First Name - Enter the client's first name.
- Last Name - Enter the client's last name.
- Date - Enter the date the payment was received (must be in YYYY-MM-DD format).
- Amount - Enter the amount of the payment.
- Method - Enter the payment method used (Cash, Check, Credit Card, Debit Card, Direct Debit, ACH, Bank Transfer, e-Transfer, PayPal, Venmo, Square, Other).
- Description - Enter a description about the payment (optional).
After the template has been filled out, select the template file on the "Upload Payments" page and submit the form.
Validating Uploaded Payments
After the template file has been submitted, you'll need to verify and validate each of the uploaded payments on the "Validate & Import Records" table by following the steps below:
- Review the information for each payment record as shown in the image below:
NOTE: If an invalid customer name or payment method is uploaded, these fields will be blank and you will need to select the customer and method using the down down menu for each field. Only completed rows will be added so if you are missing one of the fields, the payment will not be imported.
- Click on the "Import Payments" button to import the payment record.
- Repeat this process for all of the payment records that were uploaded.
You can clear any unimported payments by clicking on the "Clear Unimported Payments" on the right hand side, as shown in the image below:
You may wish to allocate the payments you've just imported to your invoices. This can be done automatically in bulk using our Automatic Allocation Add-on.
When using the Automatic Allocation Add-on to allocate imported payments, it's best to set the "Trigger Method" to "Manual", as this will allocate unallocated payments when you manually trigger the process. This is useful if you need to allocate payments or credits to invoices that have already been approved.