Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

How to create a statement of cash flows in AGRIS

At its most basic form, the cash flow statement organizes and reports the cash generated and used. Here are a few ways the statement of cash flows is used:

...

In AGRIS terminology, all the cash that came into a bank code and all the cash that went out of a bank code will be shown. AGRIS software does not have the ability to pull this type of information from the ledger in an official report, where all entries are posted in summary form. However, we can pull this basic information from the Execution Work File where we have the detail, and we can exclude manual ledger entries that did not hit a bank code.

...

Process:

  1.     Build execution work file in SJI > Execution ID > Build Execution Work File for the year up to the current date. Answer Yes to include all detail

  2.     Run the Ledger Account Detail Report for asset bank codes.

    1. SJI > Report Manager > Execution Report > Execution Report > Choose the work file just built > 1. Print Standard Reports > 2. Ledger Account Detail Report

    2. Enter the beginning and ending account code number that represent bank accounts in AGRIS. Enter date ranges to limit date range if only wanting to run for a certain month compared to the year.

      1. Remember: this is reporting from the work file, not live data. This is built for a specific point in time, not live.

    3.     On the Additional Options screen, answer NO to include General Ledger entries and NO to include Execution ID Budgets entries.

  3.     The grand total of the report will show the net cash flow, or all cash in and out, for the date range chosen.