Cash Position Worksheet
The Cash Position Worksheet page enables you to generate a cash position report based on selected accounts and a date range.
- Existing Cash Position Worksheet Name
If you are editing an existing worksheet, the worksheet name is provided by the list of existing cash position worksheets.
The list includes private reports that you created and shared reports that were created by others.
- New Cash Position Worksheet Name
If you are creating a new worksheet, this field specifies the new cash position worksheet name.
The report name must be unique as it becomes the worksheet name after the report is created, saved, and referenced in the Existing Cash Position Worksheet Name list.
- Usage
The report's availability
Options are as follows:
- Shared – Other users within your corporation can view and edit the saved worksheet.
- Private – The saved worksheet is only available for your use.
The default selection is Private.
Note: If you selected a shared worksheet from the Existing Cash Position Worksheet Name list, you cannot select the Private option.- Accounts
The accounts to include in the report
Note: If an account is not included in the list, you might not have the appropriate entitlements to include the account in the report.- Date Range
The date range type
Options are as follows:
- Relative Date – The date range is based on a time period, such as the beginning or ending of the week or month.
- Absolute Date – The date range is based on calendar dates specified in the From and To date fields. To use a single date, enter that date in both the From and To fields.
- View Report
This button generates the report based on the worksheet information.
When a report is based on an existing worksheet, it includes categories and subcategories and the daily total for each date in the selected date range for each standard subcategory. It also includes custom subcategories, added when the worksheet was saved.
The standard subcategories are updated with actual amounts provided by the system. The custom subcategories retain the data entered when the report was saved. The data in the customized subcategories is entered manually and not calculated by the system.
