Cash Flow / Cash Management
There are five Crystal Reports provided with the Cash Flow / Cash Management Patch available from TMW Systems Inc. These reports are detailed below:
Cash Flow Projections Report
This report prompts you for the 'Starting Date' for the report (Almost always the current date), then produces the key Cash Flow Summary Report. Cash Flow first looks through your General Ledger, and identifies all your 'Bank' type Accounts, and the 'Currency' those Bank Accounts are in. Each currency beginning balance is summarized.
Next, the A/R is analyzed, breaking down the 'Dollars Incoming' by: 'Disputed' (overdue by more than 20 days), 'Over Due' (should have been received within the last 20 days but has not), and 'Future Payments', broken down by the week they are expected to arrive.
The 'G/L Incoming' and 'G/L Outgoing' sections utilize the GL Journal Entry program. If you have an entry such as a 'Cash Payment' for a Trailer expected 3 weeks from now, enter a one-sided entry into a BATCH called 'CASH-REQ'. If you have outgoing cash, such as a regular payment that does not go through A/P, then enter the transaction as a 'Credit Amount' into the same batch. Think of the CASH-REQ batch as a "notepad" that keeps track of future miscellaneous Inbound and Outbound cash that is not already recorded in the A/R, A/P, and G/L modules.
The A/P system is searched for cash requirements based on the 'Due Dates' of the Invoices already entered.
Collections Report
The Collections Report is a superb tool for reviewing and planning collection services. This report allows you to focus on a specific 'Currency', the 'Age' of Overdue Invoices, or a specific 'Site'. Only Outstanding Invoices are selected.
-
The report, in 'Summary' format, is ordered by 'Customer Name', identifying the Balance Owing. Each outstanding Freight Bill is shown, with summary information from the AR Inquiry program. Comments recorded through the AR Inquiry program’s 'Reference' field are shown on this report as well.
-
The 'Detailed' format, shown after this first summary format, includes details from the Freight Bills. This feature is great for assisting in identifying the details of the bill you are about to perform collections on.
Days to Pay Ranking Report
Produces a list of Clients, in order of their 'Days to Pay' values, from 'Worst' to 'Best'. You have the ability to select only Clients with 'Days to Pay' in the range of Lowest to Highest.
On Account Payments Report
On Account Payments are fine when you have not been provided with the details of how to distribute the incoming check, however, there must be discipline in place to assure the 'On Account' Payments are applied properly, as soon as possible. This report produces a list of 'On-Account' payments in your system, broken down by Customer ID. You can choose a single Customer ID or see All Customers, and have the choice between a 'Summary' and 'Detail' report:
-
The Summary report lists only the 'Customer ID', 'Amount' and 'Functional Amount' of the payment.
-
The Detailed report lists all of the information from the Summary report, but also lists the individual 'Invoice #', 'Type', 'Date' and 'Reference' information.
Overdue Invoices Report
Shows Invoices that have NOT been paid, then breaks them down by the severity of their "days passed due". Current categories, which could be modified by each Client through Crystal, are:
-
Over 100 days overdue
-
50 100 days overdue
-
10 49 days overdue
-
0 9 days overdue
-
Due Soon, less than 10 days
-
Due in 10 49 days
-
Due in 50 100 days
-
Due in over 100 days
