What is it?
The Accounts Payable report provides you with the finance data you need to reconcile the invoices paid to Returnly.
Each record in this report is an RMA associated with a credit transaction (Repurchase or Exchange), where an invoice was paid or will be paid to Returnly, in order to repay Returnly for the funds originally sent to you.
The video below explains the contents of the report, as well as how to use it.
How Do I Access the Reports?
When logged into your Returnly instance, click on Reports from the lefthand menu. Under Reconciliation, you can click on the Accounts Payable link.
You'll then see a pop-up that allows you to select your timing parameters.
You can use any of the pre-sets from the first drop-down menu, or select the specific time window yourself, along with your timezone.
You'll get a confirmation message that the report is being generated and sent to your email address. Remember, the report comes in a .csv (comma separated values).
What's in the report?
Each RMA associated with a credit transaction (Repurchase or Exchange) in the Accounts Receivable report contains the following fields and definitions:
|Invoice Created Date||Timestamp for when the invoice was created by Returnly.|
|Invoice Paid Date||Timestamp for when the invoice was paid by the merchant|
Unique Identifier for the invoice object.
|RMA ID||The RMA number related to the return that allowed for the new order|
|Voucher ID||ID of voucher used for the new Repurchase or Exchange order.|
|New Order ID||Order number for the Repurchase or Exchange order.|
|New Order Type||Indicates how the customer bought their new items: Repurchase, Exchange.|
|New Order Amount||Amount that the customer has spent on the new order created in a Repurchase or Exchange.|
|Credits Spent Amount||
The amount of credit used. This will be:
|Accounts Payable Amount||
Credit Amount spent by customer or less in cases where customer is liable.
|Shopper Payable Amount to Returnly||Amount that the customer will be invoiced for by Returnly when liable for deduction or issues with the returned merchandise. This is paid by the customer, not the merchant.|
|Original Order ID||Order number of the original order that the customer is returning|
|Shopper Email||Email that the customer used to place the original order and to initiate the RMA.|
If a record in this report does not contain an Invoice Paid Date, the Accounts Payable Amount can be accrued as it was not paid by the merchant yet (24-to-48-hour latency).
If a record in this report contains an Invoice Paid Date, the Accounts Payable Amount can be reconciled with the merchant’s Bank Statement or Stripe account as that would mean the merchant has already paid Returnly.
Utilizing your report for specific purposes
- If the report will be used for auditing or granular review of the data, you can explore each RMA associated with a credit transaction in the report.
- If the report will be used for reconciliation and accounting,
- Create a pivot table:
- Rows: Invoice Paid Date, Invoice ID.
- Values: Accounts Payable Amount.
- Accrue the Accounts Payable Amount where Invoice Paid Date is empty.
- Reconcile with your bank statement or Stripe account money paid to Returnly due to Credit, through the Accounts Payable Amount where Invoice Paid Date is not empty.
Note: The Payment ID is searchable in Stripe if you have a Stripe account connected to Returnly.
You can use your Accounts Receivable report to complement the Accounts Payable report to validate if funds were sent to you for RMAs where money is debited (pulled) from your account at a later date.
For more information on reconciliation and best practices, see Returnly's Return Reconciliation Guide.