Hub
Pricing About
WorkflowWorkflow

Sales Apportionment - Data App

UnknownsalesApportionmentKNIME for FinanceSales Tax ReportingTax
knime profile image
Versionv2.0Latest, created on 
Jan 22, 2025 3:39 PM
Drag & drop
Like
Download workflow
Workflow preview
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.

Read more on the topic Sales Tax Reporting on the KNIME Blog: https://www.knime.com/blog/sales-tax-reporting

External resources

  • KNIME Blog: Sales Tax Reporting
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.4.0
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.2.2, 5.3.0, 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Data GenerationTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.3.0, 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.2.2, 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME JavaScript ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.3.0, 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.3.0, 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.3.0, 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.2.2, 5.3.0, 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.2.0, 5.4.0

    knime profile image
    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits