Open topic with navigation
GL: Adjusted Cash Balance Report
Make the following menu selections to display this tab:
eFinancials—Reports—GL Reports—Adjusted Cash
Balance
Use this tab to print a report
showing current balances for selected Cash accounts, the amount of the
untransferred cash receipts from eSite for those accounts, and the combined
total of both. You can select to include unapproved eFinancials transactions.
The report is run for a specified period, selected entitiescompanies,
and specified Cash Group Codes.
Note
When attempting to print the Adjusted Cash Balance report
from a database set that does not have an eSite database, a message indicates
that an eSite database was not found and to verify the eSite
Web Service setup and/or that the eSite database is set up in the
dataset.
Selection Criteria
Note
An asterisk (*)
indicates a required field.
Select EntitiesCompanies
Click to select entitiescompanies
from the Select
EntitiesSelect
Companies
tab. The report runs for all selected entitiescompanies.
Fiscal Year
Type the fiscal year you want the report to use
(for example, 2010).
Period
Type the period you want the report to use (for
example, 1).
Include Unapproved Transactions
If you
want the report to account for unapproved eFinancials transactions, select
this check box.
Select Cash Group Codes
To select Cash Group Codes for the report, click
Select Cash Group Codes. From
the tab that appears, select the check box for each Cash Group Code you
want to include. Or, to select all Cash Group Codes, click Select
All. Then, click Save.
The selected codes appear in a list under the Select Cash Group Codes button.
Use the following features to view the selected
Cash Group Codes in the list:
- Use the
up arrow and down arrow to scroll through the list.
- Use the
plus sign to expand the list to show all of the selected
Cash Group Codes, or click the minus sign to collapse the
list.
At any time, you can remove selected Cash Group
Codes, as follows:
- Click the
Remove link for a Cash Group Code
to delete it from the list.
- Click Clear to remove all Cash Group Codes
from the list.
Note
The option "Not Set" refers to accounts for
which the Cash Group Code is "Not Set" on the GL
Account Maintenance Tab. This is an option on the Cash Group Codes
selection tab. Also, if you clear the Select Cash Group Codes list entirely,
the report is run only for accounts for which the Cash Group Code is "Not
Set."
Report Description
This report is sorted first by EntityCompany
and then by Account Number.
EntityCompany
The entitycompany
ID and description.
Account
The GL account number.
Description
The text description of the account.
General Ledger Cash Balance
The current cash balance for the GL account for
the selected propertiescompanies.
Cash Receipts Not Transferred
The total amount of cash receipts not transferred
for the GL account. The source for this information is eSite.
Note
For untransferred cash transactions to be included on
the report, the eSite Web Service
must be set up.
Current Cash Available
The current cash available for the GL account.
EntityCompany
Total
For each entitycompany,
the report displays the total amounts for General Ledger Cash Balance,
Cash Receipts Not Transferred, and Current Cash Available.
Grand Total
For all selected entitiescompanies,
the report displays the grand total amounts for General Ledger Cash Balance,
Cash Receipts Not Transferred, and Current Cash Available.
Reports Parameters
At the end of the report, the selected parameters
for running the report are listed, including: the Fiscal Year, Period,
Include Unapproved Transactions selection, and the selected Cash Group
Codes.
To Print the Report
- From the eFinancials
menu, select Reports—GL Reports—Adjusted
Cash Balance.
- Click Select
EntitiesCompanies.
Select the entitiescompanies
for which you want to print the report and click Save.
- In the Fiscal
Year field, type the fiscal year you want the report to use (for
example, 2010).
- In the Period
field, type the period you want the report to use (for example, 1).
- Click
Select Cash Group Codes. From the tab that appears, select
the check box for each Cash Group Code you want to include. Or, to select
all Cash Group Codes, click Select
All. Then, click Save. The selected codes appear in
a list under the Select Cash Group Codes button.
- If you want the report
to account for unapproved eFinancials transactions, select the Include Unapproved Transactions
check box.
- Select one of the
following report printing options:
- PDF
Format: Print the report in PDF format for use in a PDF viewer,
such as Acrobat.
- Create
Spreadsheet: Prints the report in an Excel spreadsheet.
- Click Print.
If you selected Create Spreadsheet, you are prompted to open or save the
report Excel file. Otherwise, the report opens in PDF format.
See Also
Cash
Group Codes Overview
Web
Service Setup
GL
Account Maintenance Tab
GL
Reports Introduction
Series
of Reports
Setup
Report Formats