- 16 Jul 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
Undeposited Funds Report
- Updated on 16 Jul 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
The Undeposited Funds report provides a detailed overview of funds that have been received but not yet deposited into the bank. This report helps restaurant managers track and reconcile cash, checks, and other forms of payments that are pending bank deposit.
By offering insights into the status of these undeposited funds, the report aids in maintaining accurate financial records, ensuring transparency, and preventing discrepancies in cash flow management. Additionally, it allows managers to identify and address any delays or issues in the deposit process, enhancing overall financial control and accountability within the restaurant's operations.
Navigation
In the Reports section of the left navigation pane, select My Reports.
The My Reports screen appears.At the top of the My Reports screen, select Banking.
The screen generates a list of reports in alphabetical order.Locate the Undeposited Funds report.
Select Customize to adjust the report parameters and run the report.
Report Parameters
Field | Description | |
---|---|---|
1 | Filter By | A list of all filter categories. Filter categories will vary based by report. |
2 | Filter | A list of filter options, determined by the 'Filter By' category selected (#1). |
3 | Filter By Bank Account | Bank account(s) for which to run the report. Options in the menu are filtered by selections in the Filter By and Filter parameters. |
4 | Start | First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates. |
5 | End | Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates. |
6 | Show Unapproved | If set to Yes, unapproved transactions are included in the report. If set to No, only approved transactions are included in the report. |
7 | Show Undeposited Funds | If set to All, the report shows both deposited and undeposited transactions. If set to Undeposited Only, the report shows only transactions that have not been deposited. If set to Deposited Only, the report shows only transactions that have been deposited. |
8 | Show Excluded Deposits | If set to Yes, the report shows excluded deposits. If set to No, the report does not show excluded deposits. If set to Only Show Excluded, the report only shows excluded deposits. |
9 | As Of | Date that appears at the top of the report. This date is intended to show when the report was generated. |
10 | Sort By | Sorts transactions either by date or location. |
11 | View options | This section provides options to select, save, edit, or delete a report view. |
12 | Run | Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report. |
Report Columns
Column | Description |
---|---|
Transaction Date | Date of the transaction. |
Deposit Date | Date when the funds were deposited. This field is blank for deposits that were not deposited before or on the As Of date set in the report parameters. If a date is available, the date appears as a hyperlink that can be used to access the Bank Deposit record. |
Transaction | Designation used to identify the transaction. |
Amount | Amount of the transaction. |
Bank Account | Bank account associated with the transaction. The associated bank account is configured on the Bank Deposit record. This field is blank for deposits that were not deposited before or on the As Of date set in the report parameters. |
Location Name | Name of the location associated with the transaction. |
Payment Method | If available, this column displays the method of payment. |
Excluded | A Yes in this column indicates that the transaction has been deposited or marked as excluded. |
Comments | This column displays any comments associated with the transaction on the Bank Deposit record, if available. |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.