Cash Management standard reports

Cash Management standard reports involve your cash accounts, including banks, savings institutions, and credit cards. Reports include bank, check, deposits, and credit card registers, along with a cash balances and adjusted available cash report. The registers enable you to drill down to the details quickly and conveniently.

You can run, view, process, memorize, export, and customize Cash Management reports.

Report Description

Adjusted available cash

The Adjusted available cash report includes true balances for all bank accounts by including all pending transactions.

Immediately after you complete the pay bills process, you can run this report to view your available bank balance. The cash balance reflects the bills that you paid and any other applicable pending transactions that have yet to get to the bank (beginning balance – pending transactions = ending balance).

Bank register

View a register of transactions from the range of banks and dates that you specify.

Cash analysis

See your cash position instantly with the Cash Analysis report. See what you have in the bank, what you owe to your vendors, and what your customers owe to you.

This report shows the balances for the checking or saving accounts you select, and amounts that are current, past due, and due in the future. The report always includes amounts for Accounts Payable, but you can also add amounts for Accounts Receivable. You can show increasing levels of detail that include totals for all AP and AR, subtotals for each vendor and customer, or an individual line for each document.

Cash balances

The Cash balances report shows balances for each of your cash accounts, along with the totals for the selected accounts.

The balance is calculated by adding all the transactions in the general ledger account associated with the cash account. The report also includes when the account was last reconciled and if the account has never been reconciled.

Credit card register

View a list of charges and payments for the specified time period. It also shows whether those transactions have been reconciled. The report also provides a link to reverse transactions.

Check register

View a list of Accounts Payable checks. This report includes the reconciliation status of each check. You can group checks by the banks on which they were drawn, the vendors to whom they were paid, or the date on which they were written.

Revaluation

Use the Revaluation report to revaluate bank accounts.

Deposits register

Specify a report by bank and then filter the deposits by date or reporting period. You can also view the individual receipts within that deposit.

Receipts register

The Receipts register report lists receipts that you received from specified customers in a specified time period. You can view the report in greater or lesser detail, and restrict it to receipts that have not yet been deposited. You can also do the following:

  • Drill down to the invoices to which the receipts were applied.
  • Drill down to the customer's information from this report.
  • Reverse transactions at the top level of a company, or in the entity that created the transaction, if you are a multi-entity shared user.

  • Find payments that have not been fully applied, where the amount received is greater than the amount applied.