Approve expense claims from a Google Form by amount

Every expense claim ends up with the same person reading it, even the $12 taxi. This sends only the larger claims to your finance manager and approves the small ones on the spot.

Each claim is written to your expenses sheet with its decision, and the employee gets an email saying what was decided.

Google FormsWhen someone answers the form. Save it as claim.When someone answers the form. Save it as claim.

Expenses sheetSet sheetUrl to blank.

Finance manager's emailSet financeManager to blank.

Decision on the claimSet decision to approved.

If claim.answers.Amount is greater than 500If claim.answers.Amount is greater than 500

Yes

Finance manager signs off the claimRequest approval: Approve claim.answers["Your name"]'s expense claim of $claim.answers.Amount Save it as review. Who to ask: financeManager Prepared by: claim.respondent_emailFrom claim.answers["Your name"]: claim.answers["What was it for?"] ($claim.answers.Amount)

Change decision to review.decision.Change decision to review.decision.

No

No steps

Record the claimAdd a row in sheetUrl. Save it as logged.Google Sheets

Tell the employeeSend an email to claim.respondent_email. Save it as told. Subject: Your expense claim was decisionHi claim.answers["Your name"], Your expense claim of $claim.answers.Amount for claim.answers["What was it for?"] was decision. Thanks, FinanceGmail