Live Forms v7.2 is no longer supported. Click here for information about upgrading to our latest GA Release.

Expense Report

Owned by Former user (Deleted)
Feb 15, 2017
3 min read

The Expense Report template is a  workflow that routes from an employee to his/her manager for approval and optionally the CFO if the PO is greater then $2,500. Finally, it routes to Finance for payment.

Employee > Manager > CFO (conditional) > Finance

The video at right guides you through installing and using this template or you can follow the steps below.

Install and try out the Expense Report template in less than 10 minutes. Follow the Tutorial Video by clicking on the image above.


 

Prerequisite

frevvo Cloud Account or On-Premise software installed with a tenant created. Click to signup if necessary.

Install Template

Click each step below to expand it.

 Step 1. Create Users and Roles
Workflows route between multiple users and/or roles, which you must first create.
  • Click here to download a CSV file.
  • Open it in any text editor, make the following changes and save the file.
    • Replace YOUR_EMAIL with your email address. This is used for notifications.
    • All passwords default to 123. You may change any password.
  • Login as the tenant admin user.
  • Click the Manage Users Link.
  • Click the upload csv users icon, browse to the CSV file you just edited and click Validate.
  • You may see several warning messages. If you see a thumbs down icon in the left column and the message email is invalid in the Error/Warning column, please edit the file, correct the error and try again.

  • Click the Load button. You should see something like:  "Users Loaded successfully. 9 Added, 0 Updated, 0 Deleted, 17 Roles Added."
  • Logout of the tenant admin user account.
 Step 2. Upload the Expense Report Template
  1. Click this link to download the template and save it (ExpenseReport_app.zip).
  2. Logout of the tenant admin account and login as f_designer@<replace with your tenant id> (this user was created by the previous step).
  3. Click the  Upload icon at the top of the Applications page.
  4. Leave all checkboxes unchecked and upload the ExpenseReport_app.zip file.
  5. Click the Edit button for the Expense Report application that was created and click the Flows button at left.
  6. Click the  Deploy icon for the Expense Report workflow.
 Step 3. Create a Space

A space is a built-in portal that's very easy to create and makes it easy to test your workflow.

  1. Make sure you have deployed your workflow at the end of Step 2 above.
  2. Click the Spaces link at left. Click the New icon.
  3. Enter Portal as the Space Id and click Create. Make sure the Space Id is the string Portal exactly.
  4. Click the Edit icon on the Space Home page. 
  5. Click the icon to hide the left panel.
  6. Click the save and exit icon to save the changes to your space.
  7. Click the  Share icon. Copy the share URL for your space and save it.
  8. Logout of the f_designer account.

Use Template

Click each step below to expand it.

 Step 1. Employee
  1. Go to the space you just created using the URL you copied in Step 3 of the installation above.
  2. Click Login and login as f_tom@<replace with your tenant id>.
  3. Select the Expense Report workflow from the Expense Report menu.
  4. In the form that shows up, fill in the required fields.
    1. The Table columns change (become enabled/required) depending on the expense category.
    2. Summary information of expenses by category is also shown below.
  5.  Make sure that the Grand Total is less than $2,500 so that we skip the CFO approval step.
  6. Sign the Section and click Send to Manager. The workflow is routed to Tom's manager Jerry (f_jerry) and a notification email is sent.
  7. Logout.
 Step 2. Manager
  1. Check your email and click on the link to the space above or simply go to the URL you copied in Step 3 of the installation above.
  2. Login as f_jerry@<replace with your tenant id>.
  3. Select Important Items > Task List. You should see the Expense Report created above.
  4. Click the  Perform icon.
  5. Review the expenses (you cannot change them), enter a Comment and Sign.
  6. Click the Send to Finance button and logout.
  7. The workflow is routed to Finance since the Grand Total is less than $2,500.
    1. If the total is greater than $2,500, you will have to perform these same steps again as the CFO (f_ed@<replace with your tenant id>).
 Step 3. Finance
  1. Check your email and click on the link to the space above or simply go to the URL you copied in Step 3 of the installation above.
  2. Login as f_sue@<replace with your tenant id>.
  3. Select Important Items > Task List. You should see the Expense Report in your task list.
  4. Click the Perform icon.
  5. Enter payment details in the Finance section and sign it.
  6. Click the Finish button and logout.
  7. The workflow is now complete.

 

 Step 4. View PDFs sent in email

The employee (Tom) will receive an email when the workflow ends. The email will have the Expense Report PDF attached for reference.