If you are looking to reconcile the total billings in the Revenue Recognition export with the total in the Adjustments export, you may have noticed that the numbers won't match off the bat.
The reason for seeing differences between the total_amount column in the Revenue Recognition export and the adjustment_total column in the Adjustments export is because the latter is includes unpaid invoices.
When downloading the Revenue Recognition export, you are given the option to easily exclude all invoice types and statuses except for 'Charge' and Paid', which is what you want to select to get an accurate list of paid charge invoices:
Once downloaded, all you need to do is sum up the total_amount column to get total revenue for the selected time range.
The Adjustments export works a bit differently. When choosing filters before downloading, you can only exclude/include uninvoiced adjustments and choose whether to use the invoiced date. You are not able to select the invoice state or type, however. That has to be done AFTER downloading the export:
This means that you need to filter out all invoice types and invoice states except for Charges and Paid after downloading, and then you can use the adjustment_total column to sum up the revenue received for that time range.
After opening the export, you will need to go to the adjustment_type column and include ONLY 'Charge'.
Next, you will go to the invoice_state column and include ONLY 'Paid'.
This will leave you with a list of paid invoices for the selected time range. You can then compare the total line items in the Adjustments export with the total line items in Revenue Recognition export to ensure they match and either sum up the columns right then OR start working on converting the currencies to your main currency IF you accept multiple currencies.
Comments
0 comments