Tool Search: Deposit Reporter
The Deposit Request Report provides a summary of the Deposit Request for a specific day, week, month, or a date range and is intended to help with bank reconciliation. The report is a PDF file and includes all of the transactions in the Deposit Request, grouped by bank account, and provides a total for the transaction fees and a total for the merchant fees by Fund ID. The Gross Amount, Fees, and Net Amount are provided for each Fund ID at the end of the report.
| What can I do? | What do I need to know? |
|---|---|
Generate the Report
To generate the report, click the Deposit Request Report button at the bottom of the screen, select one of the following Timing options, then click the Run button.
| Timing Option | Description | Example |
|---|---|---|
| Daily | The specific date on which you want to report. Enter or select the Deposit Request Date. |  |
| Weekly | The specific week, Monday through Friday, on which you want to report. Enter or select the date for the Monday of the week on which you want to report in the Week Of field. If you do not enter a date that falls on a Monday, Campus automatically changes the date to the first previous Monday. |  |
| Monthly | The specific month on which you want to report. Enter or select the month and year in the Month Of field. |  |
| Date Range | The specific dates on which you want to report. Enter or select the Start Date and End Date. The date range is limited to 60 days. |  |
Deposit Request Report Example
There are three parts to the Deposit Request Report.
Part 1 - Summary
The Summary section of the report displays the bank accounts, request date(s), and amounts. The Daily Deposit Summary displays the date you selected and all other reports display the applicable date range.
- The last four digits of the bank account and Bank Account ID display in the Bank Account column.
- The Total for the Deposit Request displays after the bank information.
- The Grand Total for all bank accounts displays at the bottom of the first page.Note: The Grand Total includes rollover amounts from the previous linked deposit. Before it is included, the rollover amount is rounded to the nearest penny (Adjust In). The excess amount is subtracted (Adjust Out) and applied to the next deposit.
Example of the Date Range Deposit Request Summary
Part 2 - Deposit Details
The Deposit Details include the Fund ID, Fund Description, Fee type, Payer Name, Recipient, Payment Reference Number, and Amount grouped by Bank Account. The Payment Reference Number is useful if you need to manually calculate the payment from which the fee(s) originated and verify the fee allocation. There is a Grand Total at the end of this section.
Part 3 - Fund Totals
The third part of this report displays totals by Fund ID, listed in the Calculated Fund Totals or Actual Fund Totals sections. The Calculated Fund Totals section only includes payments made while the ‘Split Transaction and Service Fees’ checkbox is not checked and the Actual Fund Totals section will only include payments made while the ‘Split Transaction and Service Fees’ checkbox is checked.
The Calculated Fund Totals section will display the gross amount by Fund ID, followed by the calculated Transaction Flat Fee and Merchant Fees that belong to each Fund ID.
The Actual Fund Totals section will only display if the ‘Split Transaction and Service Fees’ checkbox has been enabled within the Payments Setup Settings. This section will display how the Transaction Flat Fee and Merchant Fees were actually split by Fund ID. The Service Fee column will also display along the top of the section since it is no longer being separated into its own Fund ID. Once enabled, the Calculated Fund Totals section will only display if there are non-split transactions included within the report.
