Cashflow Module

In TRASER DMS 365, the Cashflow Module helps you to monitor your company’s financial solvency and predict future liquidity. Based on previous periods, operating revenues and expenses are determined in order to calculate liquidity surpluses or deficits. Sources for forecasting include receivables, liabilities, liquid funds, budgets, orders, projects and taxes. This chapter contains all key information regarding the setup and use of the Cashflow Module and is divided into the following sections:

• Setting up cash flow chart of accounts
• Defining cash flow payment term for customer/vendor
• Configuring cash flow setup
• Setting up manual cash flow expenses
• Setting up manual cash flow revenues
• Creating cash flow forecast

Setting up cash flow chart of accounts

The central element of cash flow forecasting in TRASER DMS 365 is the cash flow chart of accounts which consolidates all relevant forecast entries. The structure can be based on the regular chart of accounts, with at least one separate account required for each source to be included. Please proceed as follows to set up the cash flow chart of accounts:

• Use the quick search (ALT+Q) to find the Chart of Cash Flow Accounts page.
• Click on New in the menu bar.
• Fill in the fields in the General FastTab according to the following table:

You have successfully set up a cash flow chart of accounts.

Defining cash flow payment term for customer/vendor

You can assign a payment term for cash flow forecasting at the vendor or customer level. To do so, please proceed as follows:

• Use the quick search (ALT+Q) to find the Customers or Vendors page.
• Open the customer or vendor record for which you want to set a payment term for cash flow forecasting.
• Navigate to the Payments FastTab.
• In the Cash Flow Payment Terms Code field, select a payment term code for cash flow forecasting from the dropdown list. For more information regarding payment terms, click here.

You have successfully assigned a payment term code for cash flow forecasting to a customer or vendor.

Configuring cash flow setup

In the cash flow setup, you define central settings for cash flow forecasting, including the frequency of automatic updates, the accounts to be used, the numbering series for cash flow forecasts as well as tax-related parameters such as the tax period, tax payment window and balance account. To configure the cash flow setup, proceed as follows:

• Use the quick search (ALT+Q) to find the Cash Flow Setup page.
• Fill in the fields according to the information in the following table:

You have successfully configured the cash flow setup.

Setting up manual cash flow expenses

In addition to the automatically calculated cash flow data, manual expenses can also be taken into account. This can include expenses such as salaries, interest on loans or investments. These values can be planned for a specific period and included in the liquidity calculation. To set up manual expenses, please proceed as follows:

• Use the quick search (ALT+Q) to find the Cash Flow Manual Expenses page.
• Click on New in the menu bar.
• Fill in the columns according to the following table:

You have successfully set up a manual expense.

Setting up manual cash flow revenues

In addition to the automatically calculated cash flow data, manual revenues can also be taken into account. This includes, for example, income from interest or private capital. These values can be planned for a specific period and included in the liquidity calculation. To set up manual revenues, please proceed as follows:

• Use the quick search (ALT+Q) to find the Cash Flow Manual Revenues page.
• Click on New in the menu bar.
• Fill in the columns according to the following table:

You have successfully set up a manual revenue.

Creating cash flow forecast

To calculate cash flows, you must have at least one cash flow forecast card. It is recommended to create multiple forecasts, e.g., on a monthly basis, to allow for comparison of data over time. To do so, please proceed as follows:

• Use the quick search (ALT+Q) to find the Cash Flow Forecasts page.
• Click on New in the menu bar.
• Fill in the fields in the General FastTab according to the following table:

• After you have filled in all the information in the General FastTab, click on Home > Cash Flow Worksheet in the menu bar.
• In the cash flow worksheet, click on Home > Suggest Worksheet Lines... in the menu bar.
• In the Options FastTab, make the desired settings according to the following table:

• If needed, make additional adjustments or apply filters in the Filter: VAT Entry and Filter: Cash Flow Azure AI Buffer FastTabs.
• Confirm your entries with OK.
• The cash flow worksheet is filled with data. Then, click Home > Register in the cash flow worksheet.
• Confirm the dialog window with Yes.

You have successfully created a cash flow forecast. If you previously enabled the Show in Chart on Role Center toggle switch in the cash flow forecast, the forecast will now be displayed directly in your Role Center. Otherwise, you can view an overview of the forecast amounts by source type and period using the CF Availability by Periods action in the menu bar of the open cash flow forecast or check it in the FactBox area (ALT+F2) in the Cash Flow Forecast Statistics FastTab.