Calculating and Reporting Monthly Travel Expenses

Article Number:040769

With Kintone, you can create an app that can be used for auto-calculating total travel expenses for each month and reporting or approving the expenses.
The following are the points for creating the app:

Points:

  • Use a table to manage travel expenses on a monthly basis.
  • Use a formula to auto-calculate total travel expenses for each month.
  • Use the Process Management feature to set up a travel expense approval process.

This article provides example settings for each point.

Manage travel expenses on a monthly basis

Tables are useful for managing travel expenses on a monthly basis. Create a new record each month and register daily travel expenses in the table in the record. When registering a daily travel expense entry, add a new table row.

Configure the setting in the app as described below:

  • Place a table on the app form.
    Adding/Deleting Tables on an App Form

  • In the table, place fields to be used for registering daily travel expenses.
    Example: Date, Destination (a "Text" field), Mode of Transportation (a "Drop-down" field), Cost (a "Number" field)

Placing a table

Auto-calculate total travel expenses

To auto-calculate total travel expenses, place a "Calculated" field on the form and set a formula. By placing a "Calculated" field on the form and setting a SUM function that references the values in the table, you can calculate the sum of the values in the table.
Setting Formulas
SUM/CONTAINS Functions: Calculations in Tables

Configuring the app in the following manner, you can calculate the total travel expenses for each month.

  • On the app form, place a "Calculated" field outside the table.

  • Configure the "Calculated" field as described below:

    • Field name: "Total Expenses"
    • Formula: "SUM(Cost)"*

    *For the value enclosed in ( ), specify the field code of a field whose values you want to add up.

Example of setting a formula

Set up a travel expense approval process

To set up a travel expense approval process, use the Process Management feature.
It is a feature that enables users to create a process (workflow) for multiple users to edit and check records.
Configuring the Process Management setting

Configure the setting in the app as described below:

  • In the Process Management setting in the app settings, set statuses such as "Unsubmitted (Draft)," "Processing," "Approved," and "Sent Back."
  • For each status, set an assignee, conditions, an action name (button name), and so on.

When the setting is configured, the button to report/approve travel expenses is displayed on the record.

Example Setting of Process Management