Event Expense Report Template Google Sheets

Standard Operating Procedure: Event Expense Reporting (Google Sheets)

Document ID: TR-FIN-092
Effective Date: 2023-10-27
Version: 1.0.0
Review Cadence: Annual

1. Executive Summary & Purpose

The purpose of this SOP is to standardize the fiscal reconciliation of event-related expenditures. By utilizing a centralized Google Sheets template, the Template Registry ensures audit readiness, fiscal transparency, and expedited reimbursement cycles. This document serves as the governing framework for all event-related financial reporting.

2. Scope & Prerequisites

• Scope: Applies to all employees, contractors, and event leads processing expenses for corporate events.
• Prerequisites:
  • Active Google Workspace account with internal domain access.
  • Access to the "Template Registry Official Event Expense Template" (Shared Drive: /Finance/Templates/Master).
  • Digital copies of all itemized receipts (PDF/PNG format).
  • Authorized Corporate Credit Card or personal expense reimbursement approval.

3. Roles & Responsibilities (RACI)

4. Step-by-Step Procedure

Phase I: Template Initialization

• Access the Master Template via the internal repository link.
• Select File > Make a copy.
• Rename the file using convention: YYYY-MM-DD_EventName_ExpenseReport_OwnerName.
• Move the new file to the specific Event Project folder.

Phase II: Data Entry & Categorization

• Input event metadata (Event Name, Date, Cost Center Code) in the Summary tab.
• Log individual transactions in the Line_Items tab, ensuring correct classification (Travel, Lodging, Catering, Marketing).
• Append the unique transaction ID from the corporate banking portal to each entry.
• Utilize the dropdown data validation for "Payment Method" to ensure consistency.

Phase III: Evidence & Verification

• Upload digital receipt copies to the corresponding Receipts folder.
• Create a hyperlink in the Line_Items tab (Column H) referencing the specific receipt file.
• Review the Total_Calculated field against the physical receipt sum to ensure zero variance.

Phase IV: Submission & Finalization

• Perform a final check for "Duplicate Entry" flags (Conditional Formatting auto-triggered).
• Share the sheet with finance@templateregistry.com with "Commenter" permissions.
• Click "Submit" in the status dropdown menu to trigger an automated notification to Finance.

5. Quality Assurance & Pro-Tips

• Precision Metric: Variance between reported total and actual receipts must be $0.00.
• Pro-Tip (Automation): Use the "ImportRange" function if linking expenses from a secondary lead-generation sheet to prevent manual entry errors.
• Pitfall Avoidance: Do not use personal bank accounts for corporate expenses unless explicitly pre-authorized by the CFO.
• Data Integrity: Lock all cells containing formulas (Column J: "Tax Total") to prevent accidental deletion during data entry.

6. Frequently Asked Questions

Q: What if I lose a receipt for a minor expense under $25?
A: Per internal policy, you must provide a signed "Missing Receipt Affidavit" (Form TR-MR-01) attached to the sheet. Repeated occurrences (3+) trigger a mandatory audit.

Q: How do I handle multi-currency transactions?
A: Enter the expense in the original currency, then provide the official exchange rate used at the time of purchase in the "Notes" column. Use the Google Finance GOOGLEFINANCE() function for automated conversion reference within the sheet.

Q: What is the mandatory turnaround time for submission?
A: Expense reports must be submitted no later than 5 business days post-event conclusion to remain eligible for fiscal quarter reporting.

Authorized by:
Julian Vance
Chief Architect, Template Registry