Change Cash Flow Settings

Use this window to change the settings for your Cash Flow Manager. It is divided into several sections.

Overall Settings

Here you can select whether or not your cash flow will be based on Open transactionsOpen transactions are those that are still open in the system, such as upaid invoices. or Historical transactionsHistorical transactions are those that were closed at some point in the past, such as paid invoices, paid purchases, and so on..

  • If you select Open transactions, you can also change the Time frame.
  • If you select Historical transactions, you can change the Time frame, as well as the period that you want compare the time frame with.

Tell me more about the advantages and disadvantages of each selection.

Starting Cash

Here, you can choose if you want to include cash inactive accounts. Inactive accounts are those that are in the system but have been marked as inactive on the Maintain Chart of Accounts window. Normally, they would NOT be included in a cash flow.

Expected Incoming and Outgoing Cash

Here you can select which types of transactions you want to include in your cash flow. Those marked with an asterisk * are included when you open the Cash Flow Manager for the first time.

Expected Incoming Cash

Expected Outgoing Cash

*InvoiceThese are sales you have made to customers for which your customers have not paid you. *PurchaseThese are purchases that you have made but not paid for.
*ReceiptUnapplied receipts are those that have been entered into Sage 50 but not applied to invoices, such as prepayments or deposits. *Payroll
*Customer Credit *PaymentPayments are those that are in Sage 50 but have not been applied to any purchases, such as prepayments you have made to vendors.
*General Journal *Vendor Credit
*PrepaymentA prepayment or deposit is a payment the customer makes in advance of actual purchases. *General Journal
*Vendor ReceiptA vendor receipt is a refund that a vendor has issued to you. *PrepaymentA prepayment or deposit is an amount of money you send to a vendor for purchase you will make in the future.
QuoteThese are estimates you have given customers but you have not done any work or billed the customer for work done. Depending on how certain you are of making the sale, you may or may not want to include Quotes in your cash flow. *Customer PaymentA Customer Payment is a refund that you give to a customer.
ProposalThese are estimates made to customers for work that you have not yet performed. Depending on how certain you are of making this sale, you may or may not want to include Proposals in your cash flow. (Sage 50 Premium Accounting and above) Purchase OrderThese are goods or services you have ordered from a vendor, but you have not received the goods or services nor have you been billed by the vendor. Depending on how long it will be before you are billed, you may or may not want to include Purchase Orders in your cash flow.
Sales OrderSales Orders are sales you have made to customers but you have not shipped the goods, performed the services, or billed the customer yet. Depending on how long it will be before you bill the customer, you may or may not want to include Sales Orders in your cash flow.

Show Invoices/Purchases over 30 days overdue: Select these options if you want to see either invoices or purchases that are more than 30 days overdue.

Expected receipt date based on: Select either transaction due dateThis is the date that the transaction is actually due based on the customer terms. If you select this option, Sage 50 will assume that your customers will not pay their invoices until their actual due dates. or Average days to pay. Select this option if you want Sage 50 to calculate expected incoming cash based on the average number of days that your customers take to pay. For example, if you have a customer who is allowed 30 days to pay their invoices but they actually pay, on average, in 20 days, Sage 50 will calculate the expected incoming cash based on the customer paying in 20 days. What is Average days to pay?

Note: If you select Average days to pay and there is no payment history for a customer, Sage 50 will use the transaction due date for invoices for that customer.

Warning! When you change this selection, you will lose any modifications that you have made to invoice due dates.