Follow-up and Analysis, Cash Book—Exercises
Main Exercise
Cash Book Queries
Purpose: The purpose of this lesson is to query for
the balance of your cash account.
Windows:
Cash Account Balances Analysis
- Open the window and populate.
- 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.
- 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.
- 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.
Purpose: The purpose of this lesson is to query for
detailed cash receipt and payment information.
Windows:
Cash Transactions Analysis
- Open the window and populate.
- The window will display all of the cash transactions
to date.
- You can view and query by a large selection of
criteria.
- You can drill down to more detail by highlighting a
line, right-clicking and selecting one of the menu selections.
Purpose: The purpose of this lesson is to query for
payment files that have been sent or received.
Windows:
Historic Payment Files
- Open the window and populate.
- The window will display all of the payment files
that have been sent of received to date.
- 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
- 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.
- 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.
- 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
Purpose: The purpose of this lesson is to query for
created Mixed Payments.
Windows:
Mixed Payments Analysis
- Open the window and populate.
- The window will show an overview of all existing mixed payments.
- You can highlight a specific Mixed Payment, right-click and then
click Details to open the
Mixed Payment
entry window.
Purpose: The purpose of this lesson is to query for Mixed
Payments detailed information.
Windows:
Mixed Payment Analysis
- Open the window and populate.
- 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.
- Click the
Bank Fees and Direct Cash Transactions
tab. This tab
will display all general payments made (Bank Fee and Direct Cash
Transactions).
- Click the
Cash Transactions
tab. This tab will display all Cash
Transactions in the statement.
Reports
Purpose: The purpose of this lesson is to print a report
for a Mixed Payment.
Windows:
Mixed Payments Analysis
- Open the window and populate.
- Highlight one line, right-click and then click Print Mixed
Payment.
- 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.
- Select both boxes and click OK.
- Click Preview and you will see a printout of the Mixed Payment.