Cash Account Details

Form ID: (CA303000)

By using this form, you can view all activity on any cash account during the date range you specify. You can view summary information or the complete list of cash-related transactions performed on the account during this period. The information is collected from cash management, general ledger, accounts payable, and accounts receivable forms.

Also, you can quickly add a new cash transaction and release or clear selected cash transactions. The options that allow the release of AR and AP cash transactions from cash management forms are located on the Cash Management Preferences (CA101000) form. Cash transactions originating in the general ledger appear in the list; they can be cleared but not released from cash management forms.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Release Releases the selected transactions—those for which you have selected the unlabeled check box in the table.
Clear Marks selected transactions in the table as cleared. If you click this button, the Cleared check box will be selected and the Clear Date box will be filled with the current date. You can clear a transaction regardless of its status. The clearing step is optional in cash transaction processing, and whether you use it depends on your company policy.

Selection Area

In this area, you can make selections that affect which transactions will be shown below. You can select a cash account, a date range, and options that affect the detail level of the information displayed.

Element Description
Cash Account The cash account for which activity is displayed.
Start Date The start date of the date range for which you want to view information. You can select any date that is earlier than the End Date.

By default, the start date is the first date of the current week, month, or financial period, depending on the Default Date Range option specified on the Cash Management Preferences (CA101000) form.

End Date The end date of the date range for which you want to view information.

By default, the end date is the last date of the current week, month, or financial period, also depending on the Default Date Range option specified on the Cash Management Preferences form.

Show Summary A check box that you select if you want the system to group transactions in the list as receipts and disbursements as well as by day. If it is not selected, you will see the detailed view of the transactions listed.
Include Unreleased A check box that indicates (if selected) that the unreleased transactions will also be displayed on the list.
Currency The currency of the selected cash account.
Table 1. All Transactions and Cleared Only SectionsThis part of the Selection area displays the totals on cash transactions that match the specified selection criteria. The elements are organized in two columns: The first column (All Transactions) contains the values for all listed transactions, and the second column (Cleared Only) contains the values for cleared transactions only.
Element Description
Beginning Balance The cash account balance at the start of the specified period for the applicable transactions.
Acct. Debit Total The total amount of receipts calculated for the applicable transactions.
Acct. Credit Total The total amount of disbursements calculated for the applicable transactions.
Ending Balance The cash account balance at the end of the specified period for the applicable transactions.

Table

This table contains the list of cash transactions that meet the specified criteria. They are displayed in the summary or detailed view, depending on whether you have selected the Show Summary option in the Selection area; the subsections below describe the columns for both views.

Table 2. Table Toolbar

The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.

Button Description
Create Transaction Opens the Quick Transaction dialog box so that you can create an AP, AR, or cash management transaction, depending on the selected entry type.
Table 3. Table Columns (Summary View)In the summary view (available when the Show Summary check box is selected), the transactions in the list are grouped by the day (of the specified period) and by the basic transaction types: receipt and disbursement.
Column Description
Doc. Date The document date.
Day of Week The day of the week that corresponds to the date.
Receipt The total amount of receipts entered for the specified date.
Disbursement The total amount of disbursements entered for the specified date.
Ending Balance The cash account balance at the end of the day.
Batch Payment Nbr. A link to the batch payment in which the transaction has been included. If you click the link, the system opens the batch on the Batch Payments (AP305000) form. For details, see Processing ACH Payments.
Table 4. Table Columns (Detailed View)In the detailed view (available when the Show Summary check box is cleared), you see detailed information about the transactions in the list.
Column Description
Included An unlabeled check box that indicates (if selected) that this transaction will be included if you click Release or Clear.
Doc. Date The date of a transaction or a document.
Post Period The posting period of the transaction.
Module The functional area of the product where the transaction was entered.
Orig. Doc. Number The identifier of the document. Click the link to navigate to the appropriate form so you can view the details of the transaction.
Document Ref. The reference to an external document, if one exists.
Tran. Type The cash-related document type, which can be any of the following:
  • From AP module: Vendor refunds, prepayments, and checks
  • From AR module: Payments and memos
  • From CA module: Cash adjustments, transfers, and transfer expenses
Batch Number The reference number of the batch (generated for the transaction). You can click the link to navigate to the Journal Transactions (GL301000) form so that you can view batch details.
Status The status of the document. The status depends on the processing workflow defined for the particular document (Tran. Type).
Receipt The document amount if it is of the Receipt type.
Disbursement The document amount if it is of the Disbursement type.
Ending Balance The cash account balance, as updated by this transaction.
Batch Payment Nbr. A link to the batch payment in which the transaction has been included. If you click the link, the system opens the batch on the Batch Payments (AP305000) form. For details, see Processing ACH Payments.
CA Deposit Nbr. The number of the deposit that includes this transaction.
Description A detailed description of the transaction.
Business Account The vendor or customer associated with the document if it is an AP or AR document.
Account Name The name of the customer or vendor.
Day of Week The day of the week when the transaction was created.

Quick Transaction Dialog Box

This dialog box opens when you click one of the following:

By using the dialog box, which includes the following elements, you can quickly add cash transactions of any entry type.

Note: You cannot create a cash transaction with project-related settings in this dialog box. To create a cash transaction in the Projects functional area, use the Project Transactions (PM304000) form instead of the Quick Transaction dialog box.
ElementDescription
Cash Account The cash account to be updated by this transaction.
Entry Type

The user-defined type of cash transaction.

Tip: If an entry type has been defined as the default one for the cash account on the Entry Types tab of the Cash Accounts (CA202000) form, the system automatically fill in this entry type, but you can override this value.
Doc. Date The date of the transaction.
Fin. Period The financial period to which the transaction is posted.
Currency A read-only column that shows the currency of the cash account.
Document Ref. The reference number of the corresponding external document.
Business Account

The business account (customer or vendor) for the transaction. If the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form, the list of values may be limited based on the branch selected on the current form.

A customer or vendor is available for selection if the Restrict Visibility To box on the Financial tab of the Customers (AR303000) or Vendors (AP303000) form is empty or contains this branch or the company of the branch.

This box appears if the selected entry type is associated with the AP or AR subledger.

Location ID

The default location of the selected business account.

This box appears if the selected entry type is associated with the AP or AR subledger.

Payment Method

The default payment method of the selected business account.

This box appears if the selected entry type is associated with the AP or AR subledger.

Amount The amount of the transaction in the specified currency.
Description A detailed description of the transaction. The box is filled by default with the description of selected entry type.
Status The status of the transaction.
Cleared A check box that you select to indicate that this transaction has been cleared.
Offset Account The GL account that is used by default as the offset account for transactions. The box is displayed if the entry type selected has Module set to CA.
Offset Subaccount The offset subaccount used with the account selected.
Hold

A check box that indicates (if selected) that the transaction is on hold, which means it may be edited but cannot be released. You can clear the Hold check box if the transaction is balanced. If this check box is cleared, the transaction status changes to Balanced (or, if approval is required, to Pending Approval). The check box is cleared by default.

The check box is shown in the dialog box even if the Hold Transactions on Entry check box has been cleared on the Cash Management Preferences (CA101000) form.

Cleared A check box that you select to indicate that the transaction was cleared with the reconciliation source, generally based on preliminary information.
This dialog box has the following buttons.
Save Creates a transaction with the specified details and closes the dialog box.
Release

Releases the transaction and closes the dialog box.

The button is available if the Hold check box has been cleared.

Cancel Clears the dialog box elements and closes the dialog box without saving the transaction.