Cash analysis report

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

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

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:

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

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.