Other Cash Items
|
Access this report using Reports>Bank Reconciliation>Other Cash Items. |
Use this report to print a list of other cash items. These are items that were entered and posted affecting cash that were not checks/vouchers or receipts. Other cash items might include entries, such as a bank service charge that was entered as a Journal Voucher. The information in this report was entered on the following forms:
- The service charge was cleared using the Activities>Reconcile Cash Accounts - Other Cash Items Tab.
- The items listed were entered and posted using Transactions>Enter Journal Vouchers, Transactions>Accounts Payable>Enter A/P Invoices, Enter A/P Credits, Transactions>Accounts Receivable>Enter A/R Invoices, or Enter A/R Credits.
Advanced Security Users
Account Level Security is available for this report. This feature allows the Administrator to define the account codes and related amounts a user can view in the report. When account level security is activated by the Administrator for the organization (Security>Set Up Account Level Segments) and enabled for a user or group (Security>Set Up Account Level Security), the report will only print account information the user is allowed to see. Note that if a user does not have Account Level Security enabled, the user will see all account codes.
If the "Print Disclaimer on Report" check box is selected on the Security>Set Up Account Level Segments form, "This report may be affected by Account Level Security" prints in the header of this report. In that case, an * also prints after the report title.
Multicurrency Users
The Currency, Currency Description, Functional Amount, Exchange Adjustment, and Cleared Amount columns are only available if the Administrator has installed and added the Multicurrency module (Organization>Add a Module). These amount fields follow the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).
Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.
Use this tab to determine what data to include in the report and to define the report layout.
- By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
- By selecting Available Columns, the data that appears in the body of the report is determined.
|
Column |
Description |
|
{GL Segment} Code |
The name assigned to the GL segment. The report prints a code, such as 11000, 11001, or 11501. |
|
{GL Segment} Title |
The title assigned to the GL segment. The report prints a title, such as Payroll Cash Account, Cash in Checking, or Money Market Account. |
|
{GL Segment} Short Title |
Usually the first 15 characters of the GL Segment Title. The report prints the short title, such as PR Cash, Cash in Check, or Money Market. |
|
Reconciliation ID |
The unique identity created for the reconciliation and entered on the Summary Tab. |
|
Reconciliation Date |
The date associated to the reconciliation and entered on the Summary Tab. |
|
Status |
A designation of Open or Locked, depending on if a bank reconciliation has been completed and locked, or if it still open and possibly incomplete. Historical System Generated reconciliation's display as Open. |
|
Reconciliation Lock Date |
The date and time the bank reconciliation was completed and locked for the Reconciliation ID. |
|
Document Number |
The voucher, credit, or invoice number entered during transaction entry. |
|
Document Date |
The date assigned to the voucher, credit, or invoice during transaction entry. |
|
Document Description |
The description for the voucher, credit, or invoice. |
|
Document Entry Order |
The order the documents were posted. The system displays the date and time. |
|
Currency |
The currency type associated with the amount, such as USD, MXN, or CAD. |
|
Currency Description |
The description associated with the currency, such as US Dollar, Mexican Peso, or Canadian Dollar. |
|
Document Amount |
The amount of the voucher, credit, or invoice. This field follows the currency formatting of the document. |
|
Functional Amount |
The functional amount booked to each document. |
|
Exchange Adjustment |
The exchange adjustment amount, which is calculated by taking the difference between the Cleared Amount less the Functional Amount for the document. |
|
Cleared Amount |
The amount of which the document actually cleared the bank or the original document amount if it has not cleared. |
|
Session ID |
The session ID assigned to this batch of documents. |
|
Transaction Source |
The transaction type for the document, such as JV, APM, API, ARM, ARP, or ARB. |
|
Cleared Status Code |
The status of the invoice, journal, or credit—OS (Outstanding), CL (Cleared), or V (Voided). |
|
Cleared Status Description |
The status description of the invoice, journal, or credit—Outstanding (OS), Cleared (CL), or Voided (V). |
|
Cleared |
A designation of Yes or No, depending on if the document was selected as having been cleared by the bank. |
|
Cleared Date |
The date the invoice, journal, or credit cleared the bank. |
|
Last Updated By |
The user ID of the person who last updated the bank reconciliation. |
|
Last Updated At |
The computer used to update the bank reconciliation. Historical System Generated reconciliation's display as System Created. |
|
Last Updated Date |
The date and time the reconciled bank account was updated. |
Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.
Use this tab to set up any Available Options for the report.
|
Options |
Description |
|
Summarize Amounts |
Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together. |
Use this tab to change the font and page setup for a report.
Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.