Classic View: System Administration > Payments > Deposit Reporter > Deposit Request Report
Search Terms: 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 Daily Deposit Request Summary
Example of the Date Range Deposit Request Summary
Part 2 - Deposit Details
The Deposit Details include the Fund ID, Fund Description, 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. You can use this information to make journal entries in your accounting system and ensure the fees are applied to the correct Fund ID.
The Transaction Flat Fee and Merchant Fee columns report the actual fund allocation from the database for the Transaction Fees within the report.
