Follow-up and Analysis, Cash Book—Exercises

Main Exercise

Cash Book Queries 

Query Cash Account Balance

Purpose: The purpose of this lesson is to query for the balance of your cash account.

Windows:
Cash Account Balances Analysis

  1. Open the window and populate.
  2. The window will show an overview of incoming cash, outgoing cash, and balance per day for each cash account.  If the account has an associated cash account, the transactions will be visible in the associated account.
  3. If you have more than one cash account, view each account by clicking on the cash account drop down list and selecting the next account.
  4. You can highlight a specific cash account balance line, right-click and then select Cash Transactions to view the transaction that make up the daily total.

Query Cash Transactions

Purpose: The purpose of this lesson is to query for detailed cash receipt and payment information.

Windows:
Cash Transactions Analysis

  1. Open the window and populate.
  2. The window will display all of the cash transactions to date.
  3. You can view and query by a large selection of criteria.
  4. You can drill down to more detail by highlighting a line, right-clicking and selecting one of the menu selections.

Query Cash Transactions

Purpose: The purpose of this lesson is to query for payment files that have been sent or received.

Windows:
Historic Payment Files

  1. Open the window and populate.
  2. The window will display all of the payment files that have been sent of received to date.
  3. You can highlight a specific file, right-click and select Open File with Notepad in order to see the file details.

Analyze Mixed Payment/Cash Box Ledger Transactions

Purpose: The purpose of this lesson is to view mixed payment and cash box transactions that have been approved.

Windows:
Mixed Payment/Cash Box Ledger Transaction Analysis

  1. Open the Mixed Payment/Cash Box Ledger Transaction Analysis window and populate. All cash transactions that belong to approved mixed payment statements and cash box reports will be displayed.
  2. Select a mixed payment transaction, right click and then click Details. The Mixed Payment  window will open and the mixed payment statement to which the selected transaction belongs will be displayed in it.
  3. In the Mixed Payment/Cash Box Ledger Transaction Analysis window, select a cash box transaction, right-click and click Details. The Cash Box window will open and the cash box report to which the selected transaction belongs will be displayed in it.

Mixed Payment Queries 

Overview Mixed Payments

Purpose: The purpose of this lesson is to query for created Mixed Payments.

Windows:
Mixed Payments Analysis

  1. Open the window and populate.
  2. The window will show an overview of all existing mixed payments.
  3. You can highlight a specific Mixed Payment, right-click and then click Details to open the Mixed Payment entry window.

Query Payment Details

Purpose: The purpose of this lesson is to query for Mixed Payments detailed information.

Windows:
Mixed Payment Analysis

  1. Open the window and populate.
  2. The window will display information on the voucher connected to the statement and Cash Account in the header part. There are three tabs in the window. The first tab, Ledger Transactions, will display all invoices/installments and other ledger items, like payments on account, affected or created in the mixed payment.
  3. Click the Bank Fees and Direct Cash Transactions tab. This tab will display all general payments made (Bank Fee and Direct Cash Transactions).
  4. Click the Cash Transactions tab. This tab will display all Cash Transactions in the statement.

Reports 

Print Mixed Payment

Purpose: The purpose of this lesson is to print a report for a Mixed Payment.

Windows:
Mixed Payments Analysis

  1. Open the window and populate.
  2. Highlight one line, right-click and then click Print Mixed Payment.
  3. A Print dialog box will appear on the screen.

Note: Here you can decide whether or not to see posting information for Direct Cash Transaction. You can also decide whether or not to see information on matched ledger items.

  1. Select both boxes and click OK.
  2. Click Preview and you will see a printout of the Mixed Payment.