We have made modifications to the View payments export for owner payments so that it is in a format that can be uploaded into your bank.
Please note that every bank upload format can be different but we have now included additional columns so that all required information displays. If you need to update the order of columns you will be able to do this once your have downloaded the report.
Please note:
The format in which a document is storing data, which can be uploaded to a back can vary from bank to bank, buiding society to building society. All required information will be contained in the downloaded file.
It might be necessary for you to adjust the order of the columns in the downloaded file, but this can easily be done with a spreadsheet application.
- Go to Agency > Commission statement.
At the top of the owner list you find All owners. - Click the cog on the right hand side.
- Select View payments.
- Report dates: Select the date range for which you want to check the payments made by selecting the dates.
- Select owner: Either an individual owner or leave it on All owners
- Click Enter banking details.
- Enter your business banking sort code, account number and account reference
- Click Save.
These details will automatically be added to the report, when you download it.
- Click Filter.
- A list of all the payment runs made in the selected period will be showing
- Click the CSV icon to download the report.
Please note:
The CSV-file will be automatically saved into the Downloads folder of your computer.
Should you download the same report, same owner(s) and time period, several times, the file name will be amended with (1), (2) etc. at the end.
The screenshote belows shows how the data is showing in the CSV-file. The bank details were not included.
