2019-07-17 / Workflow Apps / ,
Expense Record Flow
Reports and records expenses after approval/correction. The Process for all employees is automatically started at the beginning of every month. The employee holds the [1. Report] Task until the closing date and inputs the expenses and payments on behalf of during that term. At the [3. Confirmation/Adjustment] Step, the accounting staff makes corrections such as “Payment by corporate card”, and then it is automatically recorded in a Google Sheet.
https://support.questetra.com/templates/expense-record-flow-20161121/
2019 (CC BY-SA 4.0) Questetra, Inc.
Nodes
1. Report 1x. Rework 1y. Rework 2. Approval 3. Confirmation / Adjustment Applicant’s Emai address Applicant’s Email address insertion Duplicate Table Google Sheets insertion Table to TSV
Data
guide = Out-of-pocket cost =
select Applicant
datetime (Application time)
guide = Expense Data (Reporting information) =
table Expense detail
number Accounting Expenses Amount
number Amount of Out-of-pocket costs
guide = Expense Data (Supplement by accounting) =
table Expense detail 2
number Accounting Expenses Amount 2
number Amount of Out-of-pocket costs 2
guide = Pointed out or comment =
discuss Internal communication
guide = Approver, etc. =
select Approval by Superior
datetime Approval time
select Approval by Accounting
datetime Approval time
guide = Google Sheets output (appending) =
single Applicant’s Email address
multiple TSV Data
single Spreadsheet ID
single Sheet Name
multiple (Access Log)

Download

http://archive.workflow-sample.net/home/en/expense-record-flow-20161121-193-en.qar

Process Modeling Story

https://en.workflow-sample.net/2016/11/expense-claim.html