Ready to Rvvup your reconciliation?
Rvvup has built a single location to give you visibility into all money movement in your account. Located in your Rvvup Dashboard, the “All transactions” page gives you insight into funds going in and out including payments, refunds, fees, balance top-ups, and Rvvup Payout disbursements to your bank account.
ℹ️ How to navigate the All transactions page
- Log in to your Rvvup Dashboard
- Click on Payments
- Select All transactions
- Use the filters across the top to customise the list
- Click on a line item to view more information in a pop out window
- Or click on the Payment Session ID link to view the related details in a pop out window
ℹ️ How to download the CSV of your All transaction page
- Log in to your Rvvup Dashboard
- Click on Payments
- Select All transactions
- Click on the Date button and choose a date range
- Click the Apply button
- Click the Export button to download the CSV file
🧮 Advanced: Creating a Reconciliation Pivot Table
In this step, you’ll be able to determine the amount(s) of the Rvvup Payout disbursements as well as confirm the successful receipt of said disbursement.
-
Open the downloaded CSV file using your spreadsheet tool of choice
- Next, create a pivot table (Guides for creating pivot tables: Numbers, Sheets, Excel)
-
In the pivot table field editor, you will want to do the following:
• Add Filters for: Type Status (only select “Succeeded”), Card Brand (untick “AmEx”), and Payment Method [only select Pay by Card, Pay by Bank, Apple Pay, and (blank)] - • Add to Columns: Transaction Type
• Add to Rows: Disbursed At, Transaction ID, External ID
• Add to Values: Amount (by default, this should be a sum*)
🎉 You should now be left with something that has the amounts disbursed alongside the amounts of your payments, refunds, and fees.
Notes
- The grand total column should be either a - or 0.00 (except the blank Total).
- You may notice a final line for (blank), any amount shown here is the active balance awaiting a future disbursement.
- In the event that you see scientific notation, some tools will need the table to be formatted to accounting.
- You may need to adjust your dates to ensure you're getting the right disbursements - specifically if you're pulling a full month of data. It's possible your first day of the calendar month would show a disbursement from payments made on the previous day (last day of the previous month).
- Each disbursement amount shown should match the funds received in the bank account you have on file with Rvvup.
- *If the amount is not sum by default, you will need to refer to your tool’s help article for guidance on how to alter values to sum.
Looking for VAT invoices?
🏦 Pay by Bank payments: If you processed at least 1 Pay by Bank payment in a given month, Rvvup will generate a VAT invoice with the Pay by Bank fee information. You can download the statement on the first day of the next month by logging into your Dashboard and clicking on Reconciliation.
💳 Pay by Card payments: If you processed at least 1 Pay by Card payment in a given month, you’ll receive a statement via email with any VAT related information.
🛟 Need additional help?
Please reach out to us at support@rvvup.com! We always happy to partner with you to help make reconciliation easier.