Part 1: SE Payments Report
Click Business Tools > SE Payments > SE Payments Payouts.
Click on the payout that you would like to reconcile and make a note of the following:
The last 3 digits of the Payout ID.
Processing Fee amount.
Total Deposit amount.
The date range of Payout.
Part 2: Income Transaction Report
From the left navigation menu, click Billing Admin > Invoices & Payments > Inc Trans Rpt.
Select the date range.
Use the 2nd of the month as the "Start Date."
Use the most recent date in the SE Payments Report as your "End Date."
Select both Recurring and Non-Recurring Charges.
In the Payout Batch ID, type in the last 3 digits of the Payout ID. Click on the payout.
Click Export to EXCEL.
Part 3: Excel
Delete accounts with $0 in the Payment Sub Total column in the Excel Report.
These are accounts with invoices but without payments in the time period.
Within the Transaction Total column, account for totals that are not $0. If the amount is:
Positive: a credit was used, or an invoice was added but was paid outside of the date ranges used to pull the report.
Negative: A credit was created but not used, or an invoice was paid but added outside of the date ranges used to pull the report.
After updating the Excel spreadsheet, re-calculate the totals in the "Total" field - they are static and will not automatically update.