You can export the details of payments that have been made on your site into a Comma Separated Values (CSV) file. This file can be opened in most spreadsheet programs (for example: Excel, Google Sheets and Numbers).
To export the payment details:
Go to Setup & Tools and select Export Data.
Click Perform Complex Export and then choose Start Data Export Wizard.
Next to What Do You Want To Export? select Payment Export.
Enter a filename into the Name Your File Field and click on Continue To Next Step.
You now need to build your export file by adding the fields you want to export. You can rename the fields as you add them and this will change the column headers in your exported file.
Click Add New Field To File and select Payment Details
In the second drop down box choose the field that corresponds to the data you wish to export. For example, to see the order number, payment method and total paid, select Order ID, Payment Method and Amount Paid.
When you have added all the fields you need click Continue To Next Step.
Please Note: Neto does not store credit card information. Only the first and last digits of the card number will be exported.
Filter the results of your file by adding Payment Filters. To export all data you can leave the filters empty and click Continue To Next Step.
Please Note: By default all filters are set to be wild card filters. If you want an exact match filter add a ^ in front of the value.
Select where you want the file to be exported to.
|Send the file as an attachment on an email.||Enter your Email Address.|
|FTP||Save the file on another server.||Enter the server FTP Location, FTP Username and FTP Password.|
|External URL||Post the file to another server (advanced option).||Enter the External URL, FTP Username, FTP Password and any other required fields.|
|Local URL||Save the file to a folder on your site.||Enter a Folder Name (or leave blank for the default location).|
To create an export template so that you can run this export easily in future, tick the Do You Wish To Save This Export Session As An Export Template To Export With In The Future? and enter a name for the template.
Click on Export Now. The export file will now be generated, please allow 2-5 minutes for the file to be created.