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

    Adjusted Cash Balance

    • Dark
    • 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.


    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?