Icon

Automated Reporting of Receivables

Problem: Too many overdue receivables to handle every day whichneed reporting, sorting, discussion and evaluation. Impossible to domanually on a daily basis, the responsible teams should beenabled to focus their resources on solving the issues.Data: Paid and Unpaid Invoice Data, Customer data, CompanyRatings (ERP, CRM, Excel Sheets,...)Goal: Daily automated overview of overdue receivables to categorizeand apply actions to. Notify the internal contact about the items viaemail. Use Case:There is a long list of overdue receivables of the B2B customers due to COVID19 and liquidityproblems. The company wants to address this issue: Finance provides a list of paid and unpaidinvoices. After calculating and identifying the overdues and the total amount of receivables percustomer we combine the data with the Company Rating and CRM Data to find the responsibeemployee. After we apply some rules for categorizing obvious cases, Finance and Sales departmentcan then manually go through the list together and assign Notes and Action to remaining open Items.In the end the responsible person receives an email for each item including the assigned action towork on the issue. The data is in addition saved to a spreadsheet. Filtering:Keep only overdues Send each receivableinvoice via email tothe responsible Manager Calculate days overdue andapply DUE-related Rules Data Access:Read Data Report Overdues toSpreadsheet for furtherDocumentation, Collaborationand Editing Connect to different Sources:SAP, Salesforce, database, googlesheets, MSSharepoint, ... Manual Labeling ofStatus & Actionwhere Rule did notapply Apply Action:Based on due invoice sum and customer rating Join:Add Data from another Source CRM Data Rating Data Sort by due timeand invoice sumAdd Notes andAction manuallyAdd NotesColumnOnly overdueitemsCustomer List with assigned Manager, Name, EmailApply Labels"big", "medium","small" based oninvoice sumInvoice sum bycustomerSell to FactoringGive timeSend a reminderCompanyRatingsread multiple lists from different countriesAdd responsibleManagers to DataAdd Company Ratings to DataCategories toExcel Sheets Sorter Table Editor ConstantValue Column Nominal ValueRow Filter Data Access Rule Engine GroupBy Rule Engine CSV Reader Excel Reader OverdueInvoices Status Overdue InvoicesEmail Notification Joiner Joiner Joiner Problem: Too many overdue receivables to handle every day whichneed reporting, sorting, discussion and evaluation. Impossible to domanually on a daily basis, the responsible teams should beenabled to focus their resources on solving the issues.Data: Paid and Unpaid Invoice Data, Customer data, CompanyRatings (ERP, CRM, Excel Sheets,...)Goal: Daily automated overview of overdue receivables to categorizeand apply actions to. Notify the internal contact about the items viaemail. Use Case:There is a long list of overdue receivables of the B2B customers due to COVID19 and liquidityproblems. The company wants to address this issue: Finance provides a list of paid and unpaidinvoices. After calculating and identifying the overdues and the total amount of receivables percustomer we combine the data with the Company Rating and CRM Data to find the responsibeemployee. After we apply some rules for categorizing obvious cases, Finance and Sales departmentcan then manually go through the list together and assign Notes and Action to remaining open Items.In the end the responsible person receives an email for each item including the assigned action towork on the issue. The data is in addition saved to a spreadsheet. Filtering:Keep only overdues Send each receivableinvoice via email tothe responsible Manager Calculate days overdue andapply DUE-related Rules Data Access:Read Data Report Overdues toSpreadsheet for furtherDocumentation, Collaborationand Editing Connect to different Sources:SAP, Salesforce, database, googlesheets, MSSharepoint, ... Manual Labeling ofStatus & Actionwhere Rule did notapply Apply Action:Based on due invoice sum and customer rating Join:Add Data from another Source CRM Data Rating Data Sort by due timeand invoice sumAdd Notes andAction manuallyAdd NotesColumnOnly overdueitemsCustomer List with assigned Manager, Name, EmailApply Labels"big", "medium","small" based oninvoice sumInvoice sum bycustomerSell to FactoringGive timeSend a reminderCompanyRatingsread multiple lists from different countriesAdd responsibleManagers to DataAdd Company Ratings to DataCategories toExcel Sheets Sorter Table Editor ConstantValue Column Nominal ValueRow Filter Data Access Rule Engine GroupBy Rule Engine CSV Reader Excel Reader OverdueInvoices Status Overdue InvoicesEmail Notification Joiner Joiner Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: felix.kergl-raepple
Created at: 2020-09-07
On NodePit since: 2022-11-05
Last update: 2024-11-18
Created with KNIME version: v4.6.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!