Forecast of income/expenses

You can make a forecast each week of the revenue and expenditure of debtors and creditors.

The Debiteuren/crediteuren prognose per week data collection each week calculates the weekly forecast for the following income and expense categories:

• Automatic debtor collection
• Automatic debtor refunds
• Debtor payments due
• Automatic payment of creditors
• Automatic payment of creditors abroad (by currency)
• Automatic payment of creditors abroad (basic currency)
• Automatic payment of creditors abroad (all currencies)
• Manual payment of creditors

Determine number of weeks

The data collection calculates the number of weeks in which income and expenses can potentially occur. The invoice due date is an important element in this respect:

• The due date has passed

  The number of weeks for this invoice is 0 (zero). The invoice should already have been received or paid.

• The due date has not yet passed.

  The invoice is not yet due and the difference between the due date and today's date is therefore determined. The number of weeks follows from this.

  Note:

  An invoice with a credit limit or payment discount is past due in Profit (the number of weeks is set to zero). To qualify for the payment discount or instead, to avoid the credit restriction from being imposed, it is important not to wait until the term of payment has expired, but instead payment should be made within the payment term.

Income forecast

• Automatic debtor collection

  The forecast of the amount due from your debtors via automatic collection displays the total amount of the invoices that meet the following conditions: they have an outstanding balance, they are not blocked and they qualify for automatic collection.

• Debtor payments due

  The forecast of the amount due from your debtors displays the total amount of the invoices that meet the following conditions: they have an outstanding balance, they are not blocked and they do not qualify for automatic collection.

• Doubtful debtors

  It is also possible to take doubtful debtors into consideration. For example, if you apply a percentage for doubtful debtors, you can calculate that percentage in the analysis (MS Excel). This way the forecast provides a more realistic picture of the future income and expenses.

Forecast of expenses

• Automatic debtor refunds

  The forecast of the amount to be refunded to your debtors via automatic refunds displays the total amount of the invoices that meet the following conditions: they have an outstanding balance, they are not blocked and they qualify for an automatic refund.

• Automatic payment of creditors

  The forecast of the amount to be paid to your creditors via automatic payment displays the total amount of the invoices that meet the following conditions: they have an outstanding balance, they are not blocked and they qualify for automatic payment.

• Automatic payment of creditors abroad

  The forecast of the amount to be paid to your foreign creditors via automatic payment displays the total amount of the invoices that meet the following conditions: they have an outstanding balance, they are not blocked and they qualify for automatic international payment.

Note:

The forecast for automatic internaional payments is broken down by payment type:

• Automatic payment of creditors abroad (by currency)

  These are the creditor invoices that are automatically paid in the currency linked to the creditor. Each payment order only includes a single foreign currency. You would generally use this for a bank account number in a foreign currency, for example a dollar account.

• Automatic payment of creditors abroad (basic currency)

  These are the creditor invoices that are automatically paid in the basic currency (generally euros). The payment order is paid in the basic currency.

• Automatic payment of creditors abroad (all currencies)

  These are the creditor invoices that are automatically paid in the currency linked to the creditor. The payment order is paid using multiple currencies.

Manual payment of creditors

The forecast of the amount to be paid manually to your creditors displays the total amount of the invoices that meet the following conditions: they have an outstanding balance, they are not blocked and they do not qualify for automatic payment.