Yes. You can upload a CSV file to create multiple collection schedules.
**Steps:**
1. Log in and go to Direct Debits > Collections > Upload Collection Schedules.
2. Download the file format template.
3. Enter the customer details, collection dates (future-dated), amounts, and any external reference.
Please note: The date must be set in the future, based on the earliest available collection date for your schedule. External Reference allows you to add your own reference for each collection, which will be displayed in the L&Z portal under the respective customer and their scheduled collections.
You will then be able to input your own customer information using the following format.
4. Save and upload the file via Choose File > Upload Schedules.
This will open your file explorer. Navigate to the location where you saved the file, then either double-click the file or select it and click Open.
- The file will now be populated and ready for this to be uploaded, when ready click on to the Upload Schedules
- You will then see the Upload Collection Schedules Response screen displayed as shown below.
- If any errors are detected during this process, they will be displayed on the Upload Collection Schedules Response screen, clearly outlining the cause. Please note: if an error occurs, the remainder of the file will not be uploaded.
- Once the file has been uploaded, the new collection schedule will be visible under the relevant customer within the collection schedules, as illustrated in the example below.
If you prefer to create your own file, we recommend using Excel and then saving it in CSV format. Please ensure the file follows this layout:
The system will confirm successful uploads or show errors. Schedules will then appear under each customer’s account.
For assistance, contact customer.services@landz.co.uk.