The Adjusted Cash Balance report helps restaurant operators maintain precise control over their cash flow. This report provides a comprehensive overview of the cash balance by accounting for all adjustments and liabilities, ensuring an accurate reflection of available cash for the selected date range. By delivering detailed insights into cash movements and balances, the Adjusted Cash Balance report helps managers make informed financial decisions and optimize cash management.
Navigation
In the Reports section of the left navigation pane, select My Reports.
The My Reports page appears.At the top of the My Reports page, select Banking.
The page generates a list of reports in alphabetical order.Locate the Adjusted Cash Balance report.
Select Customize to adjust the report parameters and run the report.
Report Parameters
| Field | Description | |
| 1 | Legal Entity | Filters the report to show data for the selected legal entities. |
| 2 | Start | First date for which to pull data for the report. The Start and End date 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. |
| 3 | End | Last date for which to pull data for the report. The Start and End date 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. |
| 4 | View options | This section provides options to select, save, edit, or delete a report view. For more information about report view controls, see Using My Reports. |
| 5 | Run | Generates the report. Export, Email, or Print the report by selecting the down arrow to the right of the Run button. |
Report Columns
Column | Description |
|---|---|
Overview | |
Legal Entity | Name of the legal entity assigned to the bank account. |
GL Cash Bal | Total balance of all bank accounts, excluding credit cards. |
Outstanding Items | Total value of all items that are not reconciled in Bank Activity. |
Subtotal | Sum of GL Cash Balance and Outstanding Items. |
Undeposited | Sum of all undeposited funds associated with the legal entity. |
Adjusted Subtotal | Sum of GL Cash Balance, Outstanding Items, and Undeposited. |
Payables | Total amount of open payables associated with the legal entity. Credit amounts are displayed in parentheses (). |
Other Current Liabilities | The balance of all GL accounts with a GL Type of Current Liabilities minus Payables. |
Total | Total adjusted cash balance for the legal entity. |
Details | |
Legal Entity | Name of the legal entity assigned to the bank account. |
Outstanding Date | Date of the outstanding deposit or payment. |
Outstanding Deposits | Amount of the outstanding deposit. |
Outstanding Payment | Amount of the outstanding payment. |
Location Number | Number used to identify the location associated with the transaction. |
Location Name | Name of the location associated with the transaction. |
Reference | Number used to identify the deposit or payment. |
Vendor/Customer | Name of the vendor if the transaction if a payment or name of the customer if the transaction is a deposit. |
Comment | Displays comments associated with the transaction, if any. |
Adjusted Balance | GL balance adjusted for outstanding deposits (additions) or payments (subtractions). |
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.