Cash analysis report

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

This report shows the balances for the checking and/or saving accounts you choose, as well as 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 supplier and customer, or an individual line for each document.

Treasurers, accountants, and controllers who need to see where the money is going from your current accounts and savings accounts.

Subscription

Cash Management

User type

Business, Project Manager, Employee
Permissions

Cash Analysis Report: Run

View a monthly report

  1. Go to Cash Management > All > Reports > Cash analysis.

  2. On the report settings page, select View.

    The report displays all results as of the current date.

  3. To refine the report, select Customize.

Customize and run

Before running the report, you can select the types of items to include as well as specify how you want the report to appear.

Use trial-and-error to get the precise results you want.

Fill in the desired boxes, and select View to see the report. If after viewing the results you want to refine the report further, select Customize to return to the report setup page.  Repeat this process until you're satisfied. For complex financial reports you plan to run regularly, select a reporting period and memorize the report when you're done setting it up. Just change the As of date before running the report next time.

  1. Set the filters to get the specific data you want.

    Filters enable you to include or exclude specific types of data in the report. To get fewer and more precise results in your report, set more filters.

  2. Format the report.

    Format options vary from report to report. Generally, you can set the layout of the report and/or arrange how to group and display the data contained in the report.

  3. Enter a title, subtitle, and footer text for your report.

  4. To view, process, memorize, export, or customize the report or add it to the dashboard, select one of the following:

    To... ...select

    View the report now, in your browser.

    View

    Display the report now, in printable PDF format.

    Print

    Generate the report and store it for later access. Reports can be either stored in the My Stored Reports list or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.

    Process & store

    Add the report to your dashboard

    Add to dashboard

    Memorize (that is, save) the report so that later you can refer back to it or modify and re-run it.

    Memorize

    Export the report to a separate file that you can then distribute or save to your local drive. File formats to which you can export the report data vary among reports.

    Export

    Return to the main report page and refine the report further.

    Customize

Report filters

Use the filters to focus the results of your report. In effect, filters enable you to isolate and assemble just the data you want. You can set any combination of filters.

  1. Select the Cash account you want the report to include.

  2. The following filter options appear if you work in a multi-entity environment:

    1. To select transactions of a specified currency, use the Transaction Currency dropdown list.

      This option appears only if your company uses foreign transaction currencies. If you do not make a selection, the report contains transactions of all currencies. However, the report itself is in base currency.

    2. To filter the report by geographic location, enter the name of the region, country, state or territory, or city in the Location box, or select the down arrow, and then select the location you want from the list that appears.
    3. To filter the report by department within the company, enter the name of the department in the Department box, or select the down arrow and then, from the list that appears, select the department you want.

    4. If you want the report to cover certain locations regardless of what you select in the Location box, use the Show For field. To do this, in the Show for field, select the down arrow and then select the locations you want the report to cover:

      • If you want the report to include data for all locations regardless of the entity you're currently using, select All locations.
      • If you want the report to include data only for the entity you're currently using, select This location.
      • If you want the report to include data only for locations that are child locations of your current entity, select Child locations. For example, if your current entity is California, and you have child locations for San Francisco and Los Angeles, use this option to have the report include data only for Los Angeles and San Francisco.
  3. Select whether the report is Based on the Transaction date or the Due date of a transaction.

  4. Select the Display by dropdown list to include the following additional details in your report:

    • Subtotals for each Supplier or customer, including current, past, and future amounts due (and owed if Accounts Receivable is included).
    • Subtotals for each transaction, including current, past, and future amounts due (and owed if Accounts Receivable is included).
  5. Select the Include accounts receivable checkbox to include the amounts for Accounts Receivable in your report.

  6. Clear the Standard interval selection checkbox to use different aging intervals and future period intervals in your report.

    The standard intervals are:

    • Aging intervals: 0-30, 31-60, >60
    • Future period intervals: <30, >30
  7. Then, select the Aging intervals and Future period intervals dropdown lists to select different intervals. To create a custom interval for either, select None and use the Custom aging intervals and Future period intervals fields to define the interval you want.

The following table describes each item in the Filters section of this report settings page:

Filter Description

Cash account

Includes data for the selected accounts. You can choose either a single account, all the accounts that fall into the account types of Current or Saving accounts, or all your bank accounts regardless of type. Bank accounts do not include credit card accounts.

Administrators can pre-set a default bank in the Configure Cash Management page. For multi-entity shared companies, you can set a default bank on an entity-by-entity basis.

Location, Department, Individual report, Prompt on run, and Show for

Appears only for multi-entity shared companies. Enables you to limit report results to a specific location and/or department.

Individual report. If this checkbox is cleared, the data is summed in a single report. If this checkbox is selected, each department and/or location combination has its own report page. The order you shuffle the groups determines the order in which their pages are printed. Due to their potentially large size, reports with departments and locations on individual pages can be run offline only.

Prompt on run. Select this checkbox to force the system to wait for you (or anyone using the report) to enter a location/department before it runs the report.

Show for. Enables you to display transactions for certain locations regardless of the location selected in the Location dropdown list.

  • All locations: Display the data of the location/entity you selected and its children.
  • This location: Only display the data of the location/entity you selected and not of its children.
  • Child locations: Only display the data of the children of the location/entity you selected.

Based on

Bases the report on the transaction date or the due date.

Display by

Enables you to include increasing levels of detail in the report.

  • Summary. Display the selected accounts, the current balance of the accounts, and the totals for past, current, and future amounts due (and owed if Accounts Receivable is included).
  • Supplier or customer. Also display subtotals by supplier or customer for the amounts due (and owed if Accounts Receivable is included).
  • Transaction number. Also display subtotals by transaction for the amounts due (and owed if Accounts Receivable is included).

Include accounts receivable

Enables you to include the amounts for AR in the report in addition to AP.

Standard interval selection

Pre-defined intervals for reporting the amounts that are currently due, past due, and due in the future:

  • Aging interval: 0-30, 31-60, >60
  • Future period interval:

Aging intervals

Additional pre-defined intervals for reporting the amounts that are currently due and past due. Select None to create you own custom interval.

Custom aging intervals

Enables you to create your own custom aging periods for amounts that are currently and past due.

Future period intervals

Additional pre-defined intervals for reporting the amounts the are due in the future. Select None to create you own custom interval.

Custom future period pntervals

Enables you to create your own custom periods for amounts that are due in the future.

Formatting

Use this section to change the page layout for this report.

To change the page layout, select the Page orientation dropdown list and select either Portrait or Landscape.

Format option Description

Page orientation

Portrait is the default layout.

Portrait: display or print the report pages vertically

Landscape: display or print the report pages horizontally

Titles and footer

Titles, subtitles, and footers apply only to the .pdf version of this report. (Select Print to get the .pdf version).

  1. Enter the title in the Report title 1 box.

    • This title displays in large type at the top of the page, directly under your company name,
    • You can type over any default name that the system may have automatically supplied in this box.  

  2. Enter the subtitle in the Report title 2 box.

    • The subtitle displays in smaller type, directly beneath the main title.
  3. Enter the footer text in the Footer text box. Footer text displays at the bottom center of the report.

You can use up to 80 characters, including spaces, in each title, subtitle, and footer.

What's in this report?

The default Cash analysis report consists of the following columns:

Report column heading Description

Account

The name of the account.

Account no.

The account number

Balance

The current balance for the account

Payables

Shows AP totals, including details for the current, past due, and future due amounts.

Receivables

Appears when you have selected the Include Accounts Receivable checkbox. Shows AR totals, including details for the current, past due, and future due amounts.

Current

The amount that is currently due, as defined by the aging interval that you selected.

Past due

The amount that is past due, as defined by the aging interval that you selected.

Total due

The total amount that is currently and past due.

Future due

The amount that is due in the future, as defined by the future period interval that you selected.

Total

The total amount that is due.

You can select any link to drill down to the details.