Expected Incoming Cash Report

In this article:

• Brief Description  
• Use Cases 
• Finding and Using the Report  
• Available Filters 
• Report Output

Brief Description  

The Expected Incoming Cash Report displays payments that are expected to be received in the near future.    

Use Cases 

This report is useful for identifying adjustments that can be made to organization expenses in the short term by considering the expected timeline for receiving payments.

Finding and Using the Report  

• In Actionstep, go to Reports > Accounting Reports > Banking. 

Then, refer to these articles for help generating and saving reports for future use:

• Reporting Overview
• Generating a Report
• Saving a Report Configuration

Available Filters 

• Period end date: Choose the cut-off date for the report. No items with a date later than the Period end date will be displayed. 
• Report layout: Choose how the report will be organized. There are three options: 
  • Group by date: Each date will display a table. Every item with an expected payment date of the heading date will be displayed.  
  • Expected from: Each debtor will display a table that only displays items and amounts owed by that debtor. 
  • No grouping: Displays a single table containing all items, regardless of date or debtor.  
• Invoice due date: Choose the date used in the Expected Date column on the report. There are two options:  
  • Payment due date, which is the due date on the invoice. 
  • Average days to pay, which calculates the average days it takes for invoices to be paid in your system. It displays the date *your average days to pay* after the invoice's AR date.  
• Sales Pipeline/Sold: Choose whether sales pipeline/bill schedule data is displayed on the report.

Report Output 

There are 4 types of tables that can be displayed on the report: 

• Overdue: Displays when Report layout is set to Group by Date. It contains items with expected payments past the due date defined in the Invoice due date configuration option. 
• Due date: Displays when Report layout is set to Group by Date. Its Header date is the due date of all items listed in the table. 
• Expected from: Displays when Report layout is set to Expected from. Its Header name is the name of the debtor for all items listed in the table. 
• Summary: Displays when Report layout is set to Group by Date or Expected from. It contains totals for each date, with a total at the bottom. 

The columns each of these tables are the same: 

• Expected From: This shows the debtor from which the payment is expected. 
• Source: This shows the item for which the payment is expected. This can be an invoice or a sales pipeline item. 
• Description: This shows the specific item for which the payment is expected. 
• Expected Date: This shows the date payment is or was expected.  
• Matter ID: This shows the ID of the matter with which the row item is associated. 
• Matter Name: This shows the name of the matter with which the row item is associated. 
• Amount: This shows the amount of the expected payment. 
• Date (Summary table): Shows the date of the expected payments. 
• Total Amount (Summary table): Shows the total of the expected payments for the corresponding date. Below the line, there is a sum of this column.