The beginning cash balance amount on the Estimated Cash Flow Analysis report is the total of all current bank balances for the selected bank accounts. The amount shown for each bank account is the bank balance as of the first reporting period's ending date. This amount does not reflect deposits or disbursements recorded after this date.
If the Accounts Payable module is integrated with Bank Reconciliation, the accounts payable cash requirement amount for each period appears on the report. You can select whether to base the projection on cash required using the invoice due date from the Accounts Payable Open Invoice file or an average due date calculated using the invoice date from the Accounts Payable Open Invoice file and the average days for payment from the Accounts Payable Vendor file. The accounts payable amounts include all invoices, but the Estimated Cash Flow Analysis always applies this discount, when due, to the invoice balance. To see how the accounts payable amounts were derived, print the Accounts Payable Cash Requirements Report with the Age Credit Invoices check box selected.
If the Purchase Order module is integrated with Bank Reconciliation and the Include Open Purchase Orders check box is selected in the Estimated Cash Flow Analysis report, the uninvoiced balance of all open purchase orders for each period appears on the report. To see how the open purchase order amounts were derived, print the Purchase Order Cash Requirements Report.
The payroll amounts displayed are the amounts entered in the Payroll Disbursements field in Disbursements.
The total cash requirements amount is the total of all cash requirement amounts. The total cash requirements for each period are subtracted from the total available cash amount to derive the ending cash balance amount. The ending cash balance then becomes the beginning cash balance amount for the next period.
If the Accounts Receivable module is integrated with Bank Reconciliation, the accounts receivable expected receipt amount for each period appears on the report. You can select whether to base the projection on cash expected (using the invoice due date from the Accounts Receivable Open Invoice file) or an average due date (calculated using the invoice date from the Accounts Receivable Open Invoice file and the average days for payment from the Accounts Receivable Customer file). The accounts receivable amounts include all invoices, but the Estimated Cash Flow Analysis always applies the discount to the invoice balance. To see how the accounts receivable amounts were derived, print the Cash Expectation Report with the Apply Discounts check box selected.
The recorded deposits amounts reflect deposits processed after the first period-ending date. The recorded deposits amounts are printed only if there are deposits pending in a future period.
The total expected cash amount is the total cash expected for the period from all sources listed. This total is added to the beginning cash balance amount to derive the total available cash amount for the period.
The recorded disbursements amount reflects any disbursements entered after the first period end date.
