The RICS>Pay Funding Report is used to view funding details per batch and transaction. This report is used by bookkeepers to balance funding deposits over a specified time period and can be broken out to display credit and debit batches individually.
Follow the steps below to run the RICS>Pay Funding Report:
1. In the RICS Backoffice, navigate to Reporting :: Report Creator
2. Type 'RICS>Pay Funding Report' in the search box or navigate to POS :: RICS>Pay Funding Report in the dropdown menu
FILE OPTIONS
3. Use the File Type dropdown menu to determine the output format
4. As needed, enter a report description in the Report Name field
Note: Report descriptions will display in the Report Manager.
5. As needed, enter a valid email address in the 'Email A Copy To' field to email the report
REPORT OPTIONS
6. Us the scroll bar to navigate to the Report Options section
7. Use the Sales Period dropdown menu to determine what sales period to analyze
Note: Batch times on this report reflect the chosen Report Batch Start Time listed in your RICS>Pay settings. To modify this setting, refer to the RICS>PAY: Modify Report Batch Start Time guide.
8. Choose from the 'Include Debit/Credit Detail?' options.
Note: Select 'Yes' to view both Credit and Debit batch totals in the Funding Summary section of this report.
REPORT CRITERIA
9. Select and enter the necessary criteria to determine what sales to display
Report Criteria Options:
By Store – Enter or search for a store code(s) to determine which store(s) to report on.
By Store State – Enter a state’s abbreviation(s) to determine which store state(s) to report on.
Note: Multiple options can be selected to narrow a search. If selecting multiple Stores or States, separate each value by a comma. To exclude the selected value(s), select the checkbox next to Exc.
10. Click 'Run'
DOWNLOAD REPORT
11. In the RICS Back Office, navigate to Reporting :: Report Manager
12. Locate and click on the 'RICS>Pay Funding Report' listed under "Today"
13. Click 'Download' on the right of the page
VIEW REPORT
The top section of this report is the 'Funding Summary'. The details in this section include funding totals per day per store. If 'Include Debit/Credit Detail?' was set to 'Yes' in the report options, each day's funding totals will be broken out by Credit and Debit.
Note: Batch times on this report reflect the chosen Report Batch Start Time listed in your RICS>Pay settings. To modify this setting, refer to the RICS>PAY: Modify Report Batch Start Time guide.
Column Details:
- Store: RICS Store Number
- Deposit ID: RICS>Pay Funding ID
- Transaction Batch Date: Batch Date When Payments Occurred
- Funding Date: Batch Deposit Date
- Payment Network: Credit Card or Debit Card
- Sales Total: Total Sales On Funding Date
- Refund Total: Total Refund Amount On Funding Date
- Transaction Total: Aggregated Batch Total
- Total Fees: Total Fees Collected On Funding Date
- Chargebacks: Chargeback Total On Funding Date*
- Net Deposit: Transaction Total Minus Total Fees & Chargebacks
*Does not include $25 chargeback fee.
The bottom section of this report is the 'Funding Detail'. The details in this section include funding totals per transaction per store per day.
Column Details:
- Store: RICS Store Number
- Deposit Date: Transaction Deposit Date
- Transaction Date: Date When Payment Occured
- Transaction Id: RICS>Pay Transaction ID
- Last 4: Last 4 Digits of Card Processed
- Payment: Card Brand (ie. Visa, Mastercard, Discover)
- Payment Network: Credit Card or Debit Card
- Fees: Fees Collected From Transaction
- Amount: Payment Amount
Note: If the RICS>Pay Funding Report is not available in your Report Creator, your store Admin can grant this permission by navigating to Setup :: Users :: Manage Roles, searching for the appropriate user role, scrolling down to Reporting : POS, checking the box titled 'RicsPay Funding Report' and clicking Save.
Comments