Cash account details (CA303000)
By using this window, 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.
Also, you can quickly add a new cash transaction and release or clear selected cash transactions.
The options that allow the release of Customer ledger and Supplier ledger cash transactions from the Cash management workspace are located in the Cash management preferences (CA101000) window. Cash transactions originating in the General ledger workspace appear in the list; they can be cleared but not released from the Cash management workspace.
The window toolbar
- Release
- Releases the selected transactions or those for which you have selected the unlabelled check box in the table.
- Clear
Marks selected transactions in the table as cleared.
If you click this button, in the table below, the Cleared check box will be selected and the Clear date field 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.
The top part
In this area, you can make selections that affect which transactions will be shown below.
- 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.
By default, the start date is the first date of the current month, week, or financial period, depending on the option specified as the Default date range in the Cash management preferences (CA101000) window. You can select any date that is earlier than the End date.
- End date
The end date of the date range for Default date range which you want to view information.
By default, it’s the last date of the current week, month, or financial period, also depending in the in the Cash management preferences (CA101000) window.
- 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.
The All transactions / Cleared only sections
This part displays the totals on cash transactions that match the specified selection criteria.
The elements are organised in two columns:
- All transactions
- contains the values for all listed transactions.
- Cleared only
- contains the values for cleared transactions only.
- Beginning balance
- The cash account balance at the start of the specified period for the applicable transactions.
- Total debit
- The total amount of receipts calculated for the applicable transactions.
- Total credit
- 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.
The 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 top part.
- Create transaction
Opens the Quick transaction dialog box. Here you can create a supplier ledger, customer ledger, or cash management transaction, depending on the selected entry type.
The transaction gets its ID in accordance with the number series used in the appropriate workspace for documents.
The Quick transaction dialog box
This dialog box opens when you click one of the following:
- Add expense
- in the Funds transfers (CA301000) window
- Create adjustment
- in the Reconciliation statements window
- Create transaction
- in the Cash account details (CA303000) window
By using the dialog box, you can quickly add cash transactions of any entry type. Note: In the Funds transfers (CA301000) window, you can add cash transactions with only an entry type that has Workspace set to CA .
- Cash account
- The cash account to be updated by this transaction.
- Entry type
- The user-defined type of cash transaction.
- Doc. date
- The date of the transaction.
- Period
- The financial period to which the transaction is posted.
- Currency
- A read-only column that shows the currency of the cash account.
- View base / View currency
For the documents with amounts in foreign currency, the Currency toggle button switches the currency of the amounts between the base currency and the selected foreign currency.
The label on the Currency toggle button depends on the currently selected currency of the amount:
- View Base
- The amount is displayed in the foreign currency; click the button to view the amount in the base currency.
- View Currency
- The amount is displayed in the base currency; click the button to view the amount in the foreign currency.
The Currency toggle button does not affect the documents with amounts in the base currency only.
- Document ref.
- The reference number of the corresponding external document.
- Amount
- The amount of the transaction in the specified currency.
- Description
A detailed description of the transaction.
The field is filled by default with the description of the 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 general ledger account that is used by default as the offset account for transactions.
The field is visible if the Entry type ID is set to Cash management on the Create payment tab in the Process bank transactions (CA306000) window.
- Offset subaccount
The offset subaccount used with the account selected.
The field is visible if the Entry type ID is set to Cash management on the Create payment tab in the Process bank transactions (CA306000) window.
- Save (button)
- Creates a transaction with the specified details and closes the dialog box.
- Cancel (button)
- Clears the dialog box elements and closes it without saving the transaction.
The 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.
- 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.
The table columns (detailed view)
In the detailed view (available when the Show summary check box is deselected), you see detailed information about the transactions in the list.
- Doc. date
- The date of a transaction or a document.
- Post period
- The posting period of the transaction.
- Workspace
- The workspace where the transaction was entered.
- Orig. doc. number
- The identifier of the document. Click the link to navigate to the appropriate window so you can view the details of the transaction.
- Document ref.
- The reference to an external document, if one exists.
- Trans. type
The cash-related document type, which can be any of the following:
- From the Supplier ledger workspace
- Supplier refunds, prepayments, and checks
- From the Customer ledger workspace
- Payments and memos
- From the Cash management workspace
- Cash adjustments, transfers, and transfer expenses
- Batch no.
The reference number of the batch (generated for the transaction).
Click the link to navigate to the Journal transactions (GL301000) ../../accounting/gl301000-ref.html window so you can view batch details.
- Status
- The status of the document. The status depends on the processing workflow defined for the particular document ( Trans. 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.
- Deposit no.
- The number of the deposit that includes this transaction.
- Description
- A detailed description of the transaction.
- Customer/Supplier no.
- The supplier or customer associated with the document if it is a supplier ledger or customer ledger document.
- Account name
- The name of the customer or supplier.
- Day of week
- The day of the week when the transaction was created.
- Clear date
- The date of the clearing.
- Cleared
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.
- Reconciled
- A check box that you select to indicate that this transaction has been reconciled.
- Reconciled number
- The identification number of the reconciliation statement.
Related pages
Concepts
- About cash transaction monitoring
- About cash transaction processing
- Reclassification results
- About cash entry processing