Cashflow

Last modified: 18 Dec 2024

Maintaining liquidity is crucial for the success, growth, and survival of your business. To make informed decisions about how to use liquidity, you need accurate, up-to-date information about cashflow, the money moving in and out of your business. To track your cashflow in mc Assetpilot do the following:

1. First you can optionally define cashflow subcategories.

2. Then you must import your cashflow transactions…

   1. …via CSV

   2. …or via bank sync

3. Then you must map these transactions to the categories.

4. After finishing these steps you will be able to monitor cashflow reated topics on your dashboard.

1) Optionally define cashflow subcategories ORGANIZATION LEVEL

Every cashflow transaction has to be mapped to a cashflow category for structured evaluation. These categories are defined in the admnistration settings and by default there already are several main categories. If the main categories do not fit your needs, you can also optionally create subcategories there. See Cashflow categories.

2) Import cashflow transactions…

To use and evaluate cashflows in mc Assetpilot, you have to import these transactions to the platform. You can do that manually by uploading CSV files reguarly, or you sync your bank accounts with the corresponding assets and all transactions will be imported automatically.

All cashflow transactions must have the following attributes:

• Date,

• Purpose,

• Amount (including currency),

• Bank account (including bank name),

• and later after mapping, they also have a cashflow category. See Map cashflow transactions to cashflow categories.

…manually via CSV file upload ASSET LEVEL

You can manually import cashflow transactions via CSV file upload. Therefore the file has to be in a certain format so that the column can be matched to the system columns with the transaction attributes. The system also checks for duplicates before importing any data.

Caution

If you decide to manually import bank transactions, make sure to do it periodically to ensure the accuracy of your forecasts.

Prerequisites

• You are the organization owner, an admin, or a member of all domains or the finance domains. See User groups and permissions.

Steps

1. Navigate to the asset level at which you want to import transactions and select the domain tab Cashflow.

2. Select Upload file and select the CSV file you want to import, or just drag and drop your file into the central area. After the upload, the system scans your file for matching columns and duplicate transactions:

   • Matching columns: The system matches your data to the system columns with the transaction’s attributes automatically. If some of your data could not be matched to a system column, you will have to match the columns from your CSV file manually to the missing system columns:

     • Select the column of your CSV file to match the missing system column. Then select Next.

       

     • On the next page, a table with all the matching data is displayed. Select Finish when you reviewed the table.

   • Duplicate check: The system checks your file for duplicate transactions. A transaction is a duplicate if there is already an existing transaction with completely same attributes. The duplicates will be greyed out in the import preview list of all your transactions. In the column Organizational level you can see at which asset level the original to your duplicate was found. If no duplicates were found in your import file, this column is empty.

Caution

All transactions in mc Assetpilot have to be unique throughout your whole organization. Duplicate transaction will not be imported.

4. After you went through the notifications of the system check, the transactions of your CSV file will be imported and displayed under Unmapped transactions.

Further actions

• Map your transactions to cashflow categories to, for example compare your financial reality with your forecasts. See Map cashflow transactions to cashflow categories.

…automatically via Bank integration ORGANIZATION LEVEL

You must sync a bank account in the administration settings to automatically import cashflow transactions. See Bank integrations.

3) Map cashflow transactions to cashflow categories ASSET LEVEL

All transactions, whether from an imported CSV file or a bank sync, first appear under Unmapped transactions in the Cashflow domain. This means no cashflow category has been assigned to them.

Caution

Unmapped transactions can not be taken into account in forecasts, as the underlying calculations in the financial modela rely on cashflow categories. Therefore every cashflow transaction has to be mapped to a cashflow category to be evaluated in a structured way.

You can map single transactions one-by-one or several at once. They will then appear under Mapped transactions in the Cashflow domain.

Map a single transaction

Prerequisites

• You are the organization owner, an admin, or a member of all domains or the finance domains. See User groups and permissions.

Steps

1. Navigate to the asset level at which you want to map a transaction and select the domain tab Cashflow > Unmapped transactions.

2. Assign a category from the dropdown to the desired transaction.

   

3. Switch to the Mapped transactions tab to see your mapped transaction. Then it will also disappear from the list of unmapped transactions.

Further actions

• Map more transactions in the same manner if needed.

• Change a category afterwards under the Mapped transactions tab.

Map several transactions at once

Prerequisites

• You are the organization owner, an admin, or a member of all domains or the finance domains. See User groups and permissions.

Steps

1. Navigate to the asset level at which you want to map transactions and select the domain tab Cashflow > Unmapped transactions.

2. Select several transactions at once. You have the following options for that:

   • Tick several Check boxes individually at the beginning of the line.

   • Tick the Check box above the list to select the check boxes of all displayed transactions at once.

   • Use the Search or Filter options to narrow down the displayed transactions. Then tick the Check box above the list to select all displayed transactions.

3. A floating button will appear. Select Map transactions. A window will appear.

4. Select the cashflow category you want to assign to all selected transactions, then select Confirm.

5. The transactions will automatically be transferred to the Mapped transactions tab and will disappear from the Unmapped transactions tab.

   

Further actions

• Map more transactions in the same manner if needed.

• Change several categories afterwards at once under the Mapped transactions tab.

4) Monitor your cashflow

To monitor your cashflow, you can display cashflow related information on your dashboard with various widgets:

• View your liquidity balance based on your cashflow and forecasts with the Consolidated financial performance widget.

• Check the number of unmapped transactions with the Topics widget.

• View monthly cashflows as a bar graph with the Monthly cashflows widget.

• Compare forecasted/expected and actual results of cashflow categories with the Profit/Loss overview widget.