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 Add responsibleManagers to DataSort 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 reminderAdd Company Ratings to DataCompanyRatingsread multiple lists from different countriesCategories toExcel Sheets Joiner Sorter Table Editor ConstantValue Column Nominal ValueRow Filter Data Access Rule Engine GroupBy Joiner Rule Engine Joiner CSV Reader Excel Reader OverdueInvoices Status Overdue InvoicesEmail Notification 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 Add responsibleManagers to DataSort 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 reminderAdd Company Ratings to DataCompanyRatingsread multiple lists from different countriesCategories toExcel Sheets Joiner Sorter Table Editor ConstantValue Column Nominal ValueRow Filter Data Access Rule Engine GroupBy Joiner Rule Engine Joiner CSV Reader Excel Reader OverdueInvoices Status Overdue InvoicesEmail Notification

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: 2021-04-14
Last update: 2024-11-17
Created with KNIME version: v4.3.1

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

Try NodePit Runner!