Icon

Example Data App - Sales Apportionment

Data App automates the calculation steps for sales tax report for the subscription data with dynamic selection of the 12-months period. Based on the user-specified start date of the taxation period, the Data App will automatically take the active membership falling into this period and compute the total sales per state based on the subscription fee.

Sales Apportionment Logic:
- Sales where billing zip code is unknown are being apportioned to all participating states.
- For the sake of simplicity, we have assumed that all states determine apportionment solely based on sales (i.e. not considering payroll and property apportionment factors.

Data App DescriptionData App automates the calculation steps for sales tax report for the subscription data with dynamic selection of the 12-monthsperiod. Based on the user-specified start date of the taxation period, the Data App will automatically take the active membershipfalling into this period and compute the total sales per state based on the subscription fee.Sales Apportionment Logic:Sales where billing zip code is unknown are being apportioned to all participating states.For the sake of simplicity, we have assumed that all states determine apportionment solely based on sales (i.e. not consideringpayroll and property apportionment factors.To interact with components: Right Click -> (Execute and) Open ViewTo see the calculation steps and more explanation -> Right Click -> Component -> Open Sales Tax Reporting View and Downloadthe Results Read and Cleanthe Data Data App DescriptionData App automates the calculation steps for sales tax report for the subscription data with dynamic selection of the 12-monthsperiod. Based on the user-specified start date of the taxation period, the Data App will automatically take the active membershipfalling into this period and compute the total sales per state based on the subscription fee.Sales Apportionment Logic:Sales where billing zip code is unknown are being apportioned to all participating states.For the sake of simplicity, we have assumed that all states determine apportionment solely based on sales (i.e. not consideringpayroll and property apportionment factors.To interact with components: Right Click -> (Execute and) Open ViewTo see the calculation steps and more explanation -> Right Click -> Component -> Open Sales Tax Reporting View and Downloadthe Results Read and Cleanthe Data

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: daria.liakh
Created at: 2023-09-25
On NodePit since: 2024-06-13
Last update: 2024-11-21
Created with KNIME version: v5.2.1
Tags: KNIMEFinanceSalestaxreportingunknownsalesapportionmentdataapp

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

Try NodePit Runner!