{"id":77746,"date":"2021-03-01T14:03:43","date_gmt":"2021-03-01T05:03:43","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/expense-record-flow-20161121\/"},"modified":"2022-05-26T14:34:49","modified_gmt":"2022-05-26T05:34:49","slug":"expense-record-flow-20161121","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/templates\/expense-record-flow-20161121\/","title":{"rendered":"Expense Record Flow"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#0b6305;border-radius:3px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#3E9638;color:#FFFFFF;border-top-left-radius:1px;border-top-right-radius:1px\">Expense Record Flow 20161121<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:1px;border-bottom-right-radius:1px\">Reports and records expenses after correction and approval. The Process is automatically started at the beginning of every month for all employees. The employee holds the [1. Report] Task until the closing date and inputs the expenses and reimbursements during that term. At the [3. Confirmation\/Adjustment] Step the accounting staff make corrections such as \u201cPayment by corporate card\u201d, and then it is automatically recorded in a Google Sheet.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-2\" data-anchor=\"swimlane\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Worker (#of Swimlane: 3)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul wp-block-list\"><li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fas fa-user fa-lg\" style=\"color:#333333;\"><\/i><\/span><\/span> <strong>Employee<\/strong> <\/li><li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fas fa-user fa-lg\" style=\"color:#333333;\"><\/i><\/span><\/span> <strong>Superior<\/strong> <\/li><li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fas fa-user fa-lg\" style=\"color:#333333;\"><\/i><\/span><\/span> <strong>Accounting<\/strong> <\/li><\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-2\" data-anchor=\"nodes\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Business Flow (Complexity of Workflow: 17)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul wp-block-list\"><li><strong>1. Claim<\/strong> <ul style=\"list-style-type:none\"><li>An employee enters the details of out-of-pocket expenses each time it is incurred and saves\/suspends. The claim is submitted by completing the Step at the end of the month.<\/li><\/ul><\/li><li><strong>1x. Correct and resubmit<\/strong> <ul style=\"list-style-type:none\"><li>The claimant corrects and resubmits.<\/li><\/ul><\/li><li><strong>1y. Correct<\/strong> <ul style=\"list-style-type:none\"><li>The claimant corrects and resubmits.<\/li><\/ul><\/li><li> <strong>2. Approve<\/strong> <ul style=\"list-style-type:none\"><li>The claimant&#8217;s boss confirms the content of the expense and returns any deficiencies.<\/li><\/ul><\/li><li><strong>3. Confirm \/ Adjust<\/strong> <ul style=\"list-style-type:none\"><li>The person in charge confirms or rejects the claim.<\/li><\/ul><\/li><li><strong>Google Sheets insertion<\/strong> <ul style=\"list-style-type:none\"><li>The system appends the value of the specified Data Item to the specified Google Sheets.<\/li><\/ul><\/li><li><strong>x1. Duplicate Table<\/strong> <ul style=\"list-style-type:none\"><li>The system duplicates the input contents in the Expense Details to the Expense Details 2.<\/li><\/ul><\/li><li><strong>x2. Claimer&#8217;s Email address<\/strong> <ul style=\"list-style-type:none\"><li>The system retrieves the claimant&#8217;s registered email address and sets it to a String-type Data Item.<\/li><\/ul><\/li><li><strong>x3. Table to TSV<\/strong> <ul style=\"list-style-type:none\"><li>The system converts the input contents of Expense Details 2 into TSV format data and sets it in the Data Item.<\/li><\/ul><\/li><li><strong>x4. Email address insertion<\/strong> <ul style=\"list-style-type:none\"><li>The system adds the specified value to the end of each row of the specified TSV data.<\/li><\/ul><\/li><\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-2 su-spoiler-closed\" data-anchor=\"diagram\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Workflow Diagram (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"989\" height=\"630\" data-attachment-id=\"102547\" data-permalink=\"https:\/\/support.questetra.com\/en\/templates\/expense-record-flow-20161121\/attachment\/expense-record-flow-20161121-220-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/expense-record-flow-20161121-220-en.png?fit=1078%2C687&amp;ssl=1\" data-orig-size=\"1078,687\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"expense-record-flow-20161121-220-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/expense-record-flow-20161121-220-en.png?fit=989%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/expense-record-flow-20161121-220-en-989x630.png?resize=989%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-102547\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/expense-record-flow-20161121-220-en.png?resize=989%2C630&amp;ssl=1 989w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/expense-record-flow-20161121-220-en.png?resize=494%2C315&amp;ssl=1 494w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/expense-record-flow-20161121-220-en.png?resize=768%2C489&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/expense-record-flow-20161121-220-en.png?w=1078&amp;ssl=1 1078w\" sizes=\"auto, (max-width: 989px) 100vw, 989px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>BPMN Icons<ul><li>Start Event<\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/timer-start-event\/\" target=\"_blank\">Timer Start Event<\/a><\/li><li>End Event<\/li><li>Join Gateway<\/li><\/ul><ul><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/throwing-message-intermediate-event-email\/\" target=\"_blank\">Throwing Message Intermediate Event (email)<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/timer-intermediate-event-boundary-type\/\" target=\"_blank\">Timer Intermediate Event (Boundary Type)<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/human-task\/\" target=\"_blank\">Human Task<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/addons\/table-duplicate-2021\/\" target=\"_blank\">Table, Duplicate<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/addons\/converter-quser-to-email-string-2021\/\" target=\"_blank\">Converter: Quser to Email-String<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/addons\/converter-table-to-tsv-string-2021\/\" target=\"_blank\">Converter: Table to TSV-String<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-add-static-value-to-all-lines-2021\/\" target=\"_blank\">TSV String; Add Static Value to All Lines<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-append-tsv\/\" target=\"_blank\">Google Sheets: Sheet, Append TSV<\/a><\/li><\/ul><\/li><\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-2\" data-anchor=\"nodes\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Business Process Variables (#of Data Item: 23)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul wp-block-list\"><li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>= Out-of-pocket cost =<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>0<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-user fa-lg\" style=\"color:#04B45F;\" title=\"User (Select Box)\"><\/i><\/span> <strong>Applicant<\/strong> <span style=\"font-style:italic; color:#009900\">q_Applicant<\/span> <code>1<\/code> <ul style=\"list-style-type:none\"><li> <span style=\"color:#0693E3;\">${processInstance.initQuserId}<\/span><\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-clock fa-lg\" style=\"color:#5FB404;\" title=\"Datetime\"><\/i><\/span> <strong>(Application time)<\/strong> <span style=\"font-style:italic; color:#009900\">q_Application<\/span> <code>2<\/code> <ul style=\"list-style-type:none\"><li>The processing completion time of the Step 1 Claim is automatically set<\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>= Expense Data (Reporting information) =<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>3<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-table fa-lg\" style=\"color:#0404B4;\" title=\"Table\"><\/i><\/span> <strong>Expense detail<\/strong> <span style=\"font-style:italic; color:#009900\">q_Detail1<\/span> <code>4<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-percent fa-lg\" style=\"color:#B45F04;\" title=\"Numeric\"><\/i><\/span> <strong>Accounting Expenses Amount<\/strong> <span style=\"font-style:italic; color:#009900\">q_Amount1<\/span> <code>5<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-percent fa-lg\" style=\"color:#B45F04;\" title=\"Numeric\"><\/i><\/span> <strong>Amount of Out-of-pocket costs<\/strong> <span style=\"font-style:italic; color:#009900\">q_Costs1<\/span> <code>6<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>= Expense Data (Supplement by accounting) =<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>7<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-table fa-lg\" style=\"color:#0404B4;\" title=\"Table\"><\/i><\/span> <strong>Expense detail 2<\/strong> <span style=\"font-style:italic; color:#009900\">q_Detail2<\/span> <code>8<\/code> <ul style=\"list-style-type:none\"><li>Automatically set at x1<\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-percent fa-lg\" style=\"color:#B45F04;\" title=\"Numeric\"><\/i><\/span> <strong>Accounting Expenses Amount 2<\/strong> <span style=\"font-style:italic; color:#009900\">q_Amount2<\/span> <code>9<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-percent fa-lg\" style=\"color:#B45F04;\" title=\"Numeric\"><\/i><\/span> <strong>Amount of Out-of-pocket costs 2<\/strong> <span style=\"font-style:italic; color:#009900\">q_Costs2<\/span> <code>10<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>= Pointed out or comment =<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>11<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-comments fa-lg\" style=\"color:#045FB4;\" title=\"Discussion\"><\/i><\/span> <strong>Internal communication<\/strong> <span style=\"font-style:italic; color:#009900\">q_Communication<\/span> <code>12<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>= Approver, etc. =<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>13<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-user fa-lg\" style=\"color:#04B45F;\" title=\"User (Select Box)\"><\/i><\/span> <strong>Approval by Superior<\/strong> <span style=\"font-style:italic; color:#009900\">q_Superior<\/span> <code>14<\/code> <ul style=\"list-style-type:none\"><li>The User who operated the Step 2 Approve is automatically set<\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-clock fa-lg\" style=\"color:#5FB404;\" title=\"Datetime\"><\/i><\/span> <strong>Approval time<\/strong> <span style=\"font-style:italic; color:#009900\">q_Approval1<\/span> <code>15<\/code> <ul style=\"list-style-type:none\"><li>The processing completion time of the Step 2 Approve is automatically set<\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-user fa-lg\" style=\"color:#04B45F;\" title=\"User (Select Box)\"><\/i><\/span> <strong>Approval by Accounting<\/strong> <span style=\"font-style:italic; color:#009900\">q_Accounting<\/span> <code>16<\/code> <ul style=\"list-style-type:none\"><li>The User who operated the Step 3 Confirm\/Adjust is automatically set<\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-clock fa-lg\" style=\"color:#5FB404;\" title=\"Datetime\"><\/i><\/span> <strong>Approval time<\/strong> <span style=\"font-style:italic; color:#009900\">q_Approval2<\/span> <code>17<\/code> <ul style=\"list-style-type:none\"><li>The processing completion time of the Step 3 Confirm\/Adjust is automatically set<\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>= Google Sheets output (appending) =<\/strong> <span style=\"font-style:italic; color:#009900\"><\/span> <code>18<\/code> <\/li><li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box single line)\"><\/i><\/span> <strong>Applicant&#8217;s Email address<\/strong> <span style=\"font-style:italic; color:#009900\">q_Email<\/span> <code>19<\/code> <ul style=\"list-style-type:none\"><li>Automatically set at x2<\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box multiple lines)\"><\/i><\/span> <strong>TSV Data<\/strong> <span style=\"font-style:italic; color:#009900\">q_TSV<\/span> <code>22<\/code> <ul style=\"list-style-type:none\"><li>Automatically set at x3<\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box single line)\"><\/i><\/span> <strong>Spreadsheet ID<\/strong> <span style=\"font-style:italic; color:#009900\">q_ID<\/span> <code>20<\/code> <ul style=\"list-style-type:none\"><li> <span style=\"color:#0693E3;\">Set the Spreadsheet ID<\/span><\/li><\/ul><\/li><li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box single line)\"><\/i><\/span> <strong>Sheet Name<\/strong> <span style=\"font-style:italic; color:#009900\">q_Name<\/span> <code>21<\/code> <ul style=\"list-style-type:none\"><li> <span style=\"color:#0693E3;\">Expense<\/span><\/li><\/ul><\/li><\/ul>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"><i class=\"fal fa-graduation-cap\"><\/i> <span style=\"font-style:italic; color:#009900\">Field Name<\/span>, <code>num<\/code>, <span style=\"color:#0693E3;\">Initial Value<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/uc?id=101GHndEdLp2GBKWV84u4CYi73gvVak3A&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">expense-record-flow-20161121-236-en.qar<\/a>\n  <ul><li><a href=\"https:\/\/drive.google.com\/uc?id=1t9VFX0w6MYXQj0fcX24EzPfUw_E1ayCV&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">expense-record-flow-20161121-236-en.csv<\/a> (for Importing Data Item Definitions)<\/li><\/ul>\n<\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"><i class=\"fal fa-info-circle\"><\/i> Only available for <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>You need to associate the Swimlane settings according to your organizational structure upon import<\/li><li>Immediately after importing, a setting error will occur<ul><li>Make the necessary settings in edit mode<\/li><\/ul><\/li><li>Prepare a spreadsheet on Google Sheets beforehand<ul><li>Add a sheet with the name that is exactly the same as the Initial Value set in the String-type Data Item \u2018Sheet Name\u2018<\/li><li>Set the IDs of the spreadsheet to the Initial Value set in the String-type Data Item \u2018Spreadsheet ID\u2019<ul><li>Spreadsheet ID is contained in its URL. https\uff1a\/\/docs.google.com\/spreadsheets\/d\/<em>spreadsheet ID<\/em>\/edit#gid=(sheet ID)<\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Scenario: <a rel=\"noreferrer noopener\" href=\"https:\/\/en.workflow-sample.net\/2016\/11\/expense-claim.html\" target=\"_blank\">Episode 510: &#8220;Post Facto Approval&#8221; in Expense Report Flow is Good Enough<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360052780932-Settings-Required-When-Importing-an-Archive\" target=\"_blank\">Settings Required When Importing an Archive<\/a><\/li><li>Manual: <a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002245052-M202-Set-the-Deadline-for-Each-Step\" target=\"_blank\">M202: Set the Deadline for Each Step<\/a><\/li><li>Manual: <a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002259971-M205-Business-Data-Items\" target=\"_blank\">M205: Business Data Items<\/a><\/li><li>Manual: <a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002247792-M415-Adding-an-Auto-Step-to-be-Used-in-a-Business-Process-Definition\" target=\"_blank\">M415: Adding an Auto-Step to be Used in a Business Process Definition<\/a><\/li><li>Reference: <a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360004009451-R2012\" target=\"_blank\">R2012: Limits on the Business Process Definition<\/a><\/li><li>Reference: <a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360007721412-R2051\" target=\"_blank\">R2051: Input Control and System Limits<\/a><\/li><li>Reference: <a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024573911-R2252-OAuth-Token-Getting-Procedure\" target=\"_blank\">R2252: OAuth Token Getting Proced<\/a><a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024573911-R2252-OAuth-Token-Getting-Procedure\">ure<\/a><\/li><li>Reference: <a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024292672-R2271-Automatic-Assignment-to-Datetime-Type\" target=\"_blank\">R2271: Output of Date and Datetime Data via EL syntax<\/a><\/li><li>Reference: <a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024292872\" target=\"_blank\">R2272: Output of Strings via EL syntax<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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 \u201cPayment by corporate card\u201d, and then it is automatically recorded in a Google Sheet.<\/p>\n","protected":false},"author":3,"featured_media":102552,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[156],"tags":[501,396,3163,3162],"faq_section":[],"class_list":["post-77746","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-templates","tag-budget-control","tag-google-sheets-api-v4","tag-google-workspace-ja","tag-google-workspace"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":0,"uagb_excerpt":"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&hellip;","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-kdY","jetpack-related-posts":[{"id":77695,"url":"https:\/\/support.questetra.com\/en\/templates\/approval-flow-budget-control-20160920\/","url_meta":{"origin":77746,"position":0},"title":"Approval Flow-Budget Control","author":"Hirotaka NISHI","date":"2022-01-17","format":false,"excerpt":"A Proposal-approval flow that automatically records the approved spending in a Google Sheet. When a new Issue is entered at the [1. Submit plan draft] Step, the \u201cBudget Consumption Log\u201d (Google sheet) is referred to, and the total expenditure so far is calculated automatically. At the Step of [2. Decision],\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75455,"url":"https:\/\/support.questetra.com\/en\/templates\/expense-claim-monthly-flow-20130701\/","url_meta":{"origin":77746,"position":1},"title":"Expense Claim Monthly Flow","author":"Hirotaka NISHI","date":"2021-02-01","format":false,"excerpt":"Expenses paid behalf are claimed collectively by month. Starts automatically in the \"Morning of the 1st of every month\", and allocates the Step of [1. Input Expense\/ Claim] to all employees. An employee inputs data of expense each time paid on behalf and saves, and claims when all input is\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-expense-claim-monthly-flow-20130701-218-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-expense-claim-monthly-flow-20130701-218-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-expense-claim-monthly-flow-20130701-218-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-expense-claim-monthly-flow-20130701-218-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-expense-claim-monthly-flow-20130701-218-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":164341,"url":"https:\/\/support.questetra.com\/en\/templates\/taking-out-management-for-privacy-data-20220420\/","url_meta":{"origin":77746,"position":2},"title":"Personal Information Transfer App","author":"furuzo","date":"2024-08-08","format":false,"excerpt":"This workflow is for authorizing permission for personal information to be taken out of the system. Authorization is automatically recorded in the control ledger (G sheet). When a return check is performed, the work result is automatically updated.","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/business-apps-dammy.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/business-apps-dammy.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/business-apps-dammy.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":75446,"url":"https:\/\/support.questetra.com\/en\/templates\/out-of-pocket-expenses-claim-20180325\/","url_meta":{"origin":77746,"position":3},"title":"Out-of-pocket Expenses Claim","author":"Hirotaka NISHI","date":"2020-12-24","format":false,"excerpt":"A User claims every time when expense paid out-of-pocket. Launched by emailing the receipt image taken with \"smartphone\" was done, and the amount and the date etc. of expense paid are automatically entered from the email body. At the Step of [1. Claim (appending], data of the claim can be\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-out-of-pocket-expenses-claim-20180325-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-out-of-pocket-expenses-claim-20180325-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-out-of-pocket-expenses-claim-20180325-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-out-of-pocket-expenses-claim-20180325-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-out-of-pocket-expenses-claim-20180325-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75216,"url":"https:\/\/support.questetra.com\/en\/templates\/travel-request-flow-20160118\/","url_meta":{"origin":77746,"position":4},"title":"Travel Request Flow","author":"Hirotaka NISHI","date":"2021-04-08","format":false,"excerpt":"Allows multiple personnel to make an approval. By registering the deputy manager and assistant manager as \"leader of the department (supervisor)\", other than the department manager become able to undertake the Task of [2. Approval on Travel]. Incidentally, the Operation of [2. Approval on Travel] will be allocated to a\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/02\/eye-catch-travel-request-flow-20160118-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79860,"url":"https:\/\/support.questetra.com\/en\/templates\/common-password-request-20160725\/","url_meta":{"origin":77746,"position":5},"title":"Common Password Request","author":"Hirotaka NISHI","date":"2021-01-05","format":false,"excerpt":"Manage common passwords. Passwords are recorded in Google Sheets and retrieved\/updated via the API. The password user requests disclosure at the Step of [1. Password Request]. When the administrator approves, the password is automatically acquired and disclosed at the Step of [3. Password confirmation]. After confirmation, the password recorded in\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/77746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=77746"}],"version-history":[{"count":16,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/77746\/revisions"}],"predecessor-version":[{"id":120380,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/77746\/revisions\/120380"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/102552"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=77746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=77746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=77746"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=77746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}