Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • knime
  • Spaces
  • Examples
  • 40_Partners
  • 06_S-IN_Soluzioni_Informatiche
  • 02_Accounting Management
WorkflowWorkflow

Accounting Management

Acoounting management Pdf report Excel nodes
KNIME profile image

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
This workflow collects the expenses, reported monthly from a single Excel file, into a Global Accounting file for use by an Accounting Manager. A pdf report is prepared with the total refunds due to each employee for each month. The Send Email node could be used to send pdf reports directly to Administration manager. The workflow follows this folder hierarchy: Year -> Months collects all the Excel file archived in the Months subfolder and appends the resulting table to a Global Excel file located in the "Year" folder. For this example, the Excel files are located in the workflow.file/data/accounting/2019 and months subfolders. For production use: set flow variable in "Retrieve Excel Files" metanode as follows: In the "Move file to Processed status" metanode, change the settings of the "Copy/move files" node from "Copy" to "Move". In addition to this, the expenses are reorganized in order to prepare a monthly PDF report which is sent via e-mail - there fore the Send Email node needs to be configured respectively. This workflow was developed by S-IN Soluzioni Informatiche

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.1 Note: Not all extensions may be displayed.
  • Go to item
    KNIME Core Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.1

    KNIME profile image
    knime
  • Go to item
    KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.1

    KNIME profile image
    knime
  • Go to item
    KNIME HTML/PDF Writer Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    KNIME profile image
    knime
  • Go to item
    KNIME JavaScript Views Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    KNIME profile image
    knime
  • Go to item
    KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.1

    KNIME profile image
    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item
Loading deployments
Loading ad hoc executions

Legal

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

Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits