As with any financial technology, it is important for our merchants to be able to reconcile repurchase and exchange transactions. In order to better support this effort, we have available reports that will make it easier for accounting teams to understand where money is flowing and when.
The Different Reports
As an accountant, we understand that there are many different questions you want to answer when reconciling. To help best answer these questions, we have three primary reports available:
This report will include every RMA where a voucher was generated or issued (but not necessarily used). This report will help answer any questions regarding how many vouchers were created for potential Returnly Credit transactions over a given period of time.
Tip: To understand the number of vouchers created on a given day, filter by voucher_issued_at.
This report will include every repurchase that was created/placed within a given period of time. It is important to note that some line items on this report will be duplicates from the Vouchers report, but others may not be. This is because an RMA can be created with a voucher issued, and then that voucher can be used a number of days later. This report will help answer any questions regarding money that Returnly sent you for Returnly Credit transactions over a given period of time.
Tip: To see how which repurchases were part of a batch payment, filter by stripe_destination_id.
This report will include every RMA that was part of an invoice by Returnly. This essentially means that all RMAs that have been delivered, reviewed, and settled (that were part of a Returnly Credit transaction) will be included in this report. This report will help answer any questions regarding money that Returnly invoiced for Returnly Credit transactions over a given period of time.
Tip: To see which repurchases were part of a payment to Returnly, filter by invoiced_at.
How to Generate the Reports
To find and generate these reports for reconciling Returnly Credit transactions, simply navigate to the Return Manager (dashboard) → Billing → Returnly Credit.
Here you will see a summarized report with all of the RMAs where the shopper was issued a voucher or completed an exchange. To generate detailed reports for a set timeframe, simply click through the "Download CSV Report" option. We recommend that for any reconciliation efforts, you use the export/s rather than the visual report in the dashboard.
You will then be prompted to choose the timeframe you’d like to report on, and to select which reports you want to see. The recipient of the report/s is automatically set as the email address associated with that dashboard login being utilized at that time.
Once you press Send, the report will be processed behind the scenes and will be sent to the pre-defined email address. You can continue to work while this process takes place.
The reports will be generated in CSV format so that you can upload them to the reporting tools of your choice. This will also give you the flexibility to filter and manipulate the data as you so choose.