Daily Cash Report

Report Module Guide: Daily Cash Flow Report (Worksheet)

Module Location

Finance > Financial StatementsReports > Daily Cash Flow Report

Module Objective

ThisThe Daily Cash Flow Report module is used to generate a detailed report detailingthat theresembles balancesa daily cash book or bank book. This report presents a chronological list of all transactions (inflows and outflows) for one or more selected cash/bank accounts that affect cash flow onwithin a specific date.period. UnlikeIt is a formalfundamental tool for the control and monitoring of daily cash flow statement, this report functions more as a worksheet or supporting data, displaying the ending position of each cash, bank, receivable, inventory, and other related accounts.activities.

1. Report Parameters (Filter)

The main page of this module is a simple form forcontaining definingvarious parameters to customize the report date.that will be generated.

Here is an explanation for each parameter:

• Date1. Account:

  • Select aSelected singleAccount to choose one or more specific cash/bank accounts from a list, or select All Accounts to generate a combined report.

• 2. To:

  • Specify the report's date range in the Start Date and End Date fields.

• 4. Include 0.00 Balance:

  • Check Yes if you want to display accounts that willhave beno balance or transactions in the referenceselected dateperiod.

    ("as
  of"
  date)

• 5. Currency:

  • Set the currency preference for all the account balances to be displayed (e.g., October 31, 2025).report.

2. Steps to Generate the Report

Step 1: Set Report Parameters

SelectDefine the report Dateparameters you want.need, especially selecting the Account(s) to be reported on and specifying the date range.

Step 2: Generate the Report

After theall dateparameters isare set, click one of the two buttons at the bottom:

• [Display Report]: To preview the daily cash report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report Content (Report Content)Conceptual)

The generated report iswill not a formal Statement of Cash Flows (Operating, Investing, Financing), but ratherbe a detailed listdaily ofcash accountbook, balances.

which

Thiswill reportmost displays:likely display:

• The beginning balance for the period.

• A chronological list of alltransactions, accountseach relevantwith toa cashDate, flow,Description, suchDocument asNumber, MAINDebit CASHIER, BANK BCA, ACCOUNTS RECEIVABLE, INVENTORY,(outflow), and VENDORCredit DEPOSIT(inflow).

• The ending balance of each of those accounts onfor the selected date.period.

Tips & Important Notes

• Use thisThis report asis very similar to the supporting data or a first step for preparing a formal Statement of Cash Flows,Book especiallyTransaction Report, but with the indirectmain method.

  advantage
of
• being

  Thisflexible reportenough provides the detailed balances that make up theto changesselect and combine multiple accounts in workingone capital needed for the analysis of cash flow from operating activities.report.

• This is a usefulfundamental operational report for the ControllerTreasury team in monitoring daily cash activities and for Accounting in the process of auditing or Accountingtracing Manager during the book-closing process.transactions.