Adjusted Cash Balance
  • 07 Aug 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Adjusted Cash Balance

  • Dark
    Light
  • PDF

Article summary

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

  1. In the Reports section of the left navigation pane, select My Reports.
    The My Reports page appears.

  2. At the top of the My Reports page, select Banking.
    The page generates a list of reports in alphabetical order.

  3. Locate the Adjusted Cash Balance report.

  4. 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' 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' 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.

5

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

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. 


Was this article helpful?