Within the L&Z portal you can upload a collection file to set up one off or single collections by choosing customers you want to add schedules for.
You can within the portal, download an example or if you wish to download a copy of the file with your customers included.
To download a copy of the file:
- Once you have logged in to the portal click on to Direct Debits at the top of the screen.
- Then on the left-hand menu click on to Collections and then click on to Upload Collections.
- Within the Upload Collections screen you can then either select Download File Format or Download File Format with External Reference.
- The file will download with a CSV example showing as the following.
- With the above example you will need to remove this from the file and input your own customer information using the following format.
Note – The Date will need to be future dated depending on when your nearest collection can be made.
To Download a file to include Customer information:
- Once you have logged in to the portal click on to Direct Debits at the top of the screen.
- Then on the left-hand menu click on to Collections and then click on to Upload Collections.
- Within the Upload Collections screen you can then either select Download File Format with Customers or Download File Format with Customer and External Reference.
- When one of these have been selected, you will be able to choose from the list of your customer you wish to include the file and you can also enter the collection date as well.
Note – The tab will only show 10 entries which you can adjust up to 100 entries, you can also search for your customers within this tab as well.
- When you have selected the customer’s, you wish to use you will need to click on to Download.
- The file will download with in a format of CSV, the example below shows how the file will look.
- You will need to enter the amount in Coloumn C for your customers and if you wish in Coloumn F you can enter the External Reference.
Once you have saved the file you will now be able to upload the file within the Upload Collections Screen.
- Once you have logged in to the portal click on to Direct Debits at the top of the screen.
- Then on the left-hand menu click on to Collections and then click on to Upload Collections.
- Within the Upload Collection Screen, if you click on to Choose File.
- This will bring up the file explorer, you will need to Navigate to where the file has been saved to, once selected you can either double click on the file or select the file and then click on to Open once selected.
- The file will now be populated and ready for this to be uploaded, when ready click on to the Upload Collections.
- You will now be presented with the Collection File Upload Response screen as shown below.
Within this screen if any errors incur this will appear on this screen and this will show the error with the cause of the error. If an error does incur the remaining file will not be uploaded.
When the file has been uploaded the collection will now appear under the Customer, within the collection schedules as a one-off collection shown by the example below.
*External Reference this will allow you to input your own reference for the collection and this will appear in the L&Z portal under customer and the collections that have been scheduled.
You can if you wish to create your own file, we advise to create this using excel and then saving the file in a CSV format. The layout of the file will be as follows:
If you have any further questions, please do not hesitate to contact our customer service team via email at customer.services@landz.co.uk