Standard Operating Procedure: Expense Reimbursement via Google Sheets

This Standard Operating Procedure (SOP) outlines the mandatory process for submitting business-related expenses using the centralized Google Sheets system. Adhering to these guidelines ensures timely processing, accurate financial reporting, and strict compliance with company accounting policies. All employees are expected to maintain precision when inputting data and to ensure all supporting documentation is cross-referenced correctly.

Phase 1: Preparation and Documentation

• Collect all physical or digital receipts associated with the expense.
• Ensure each receipt is legible, dated, and itemized (credit card slips without itemized lists are insufficient).
• Save digital copies as PDFs, naming them in the format: YYYYMMDD_VendorName_Amount.
• Upload all supporting documentation to the designated company cloud folder (e.g., Google Drive/Shared Drive) before initiating the sheet.

Phase 2: Data Entry into Google Sheets

• Open the master "Expense Reimbursement Form" Google Sheet.
• Create a new row or select the next available entry field.
• Date: Enter the transaction date exactly as it appears on the receipt.
• Vendor: Enter the full legal name of the merchant.
• Category: Select the appropriate department code from the dropdown menu (e.g., Travel, Meals, Office Supplies, Software).
• Description: Provide a brief, professional justification for the expense (e.g., "Client lunch with Acme Corp" vs. "Lunch").
• Amount: Input the numerical value; ensure the currency matches the company’s base currency.
• Hyperlink: Copy the share link to the PDF receipt from the cloud folder and paste it into the "Receipt Link" column.

Phase 3: Final Review and Submission

• Verify that the total amount matches your bank statement/receipts.
• Confirm that all mandatory fields (marked with an asterisk) are completed.
• Perform a final scan for duplicate entries to avoid double-claiming.
• Notify the designated Finance Manager or Department Lead via the sheet's comment function or email to trigger the approval workflow.

Pro Tips & Pitfalls

• Pro Tip: Use the Google Sheets mobile app to scan receipts directly into your Google Drive folder as soon as the transaction occurs to avoid losing paper slips.
• Pro Tip: Set a recurring calendar reminder for the last Friday of every month to process all pending expenses to ensure inclusion in the current month's payroll cycle.
• Pitfall: Waiting until the end of the quarter to submit expenses. This creates a bottleneck in Finance and often leads to missing receipts or forgotten context for expenses.
• Pitfall: Sharing the Google Sheet link with the wrong permissions. Ensure the Finance team has "Commenter" or "Editor" access, but never "Owner" or "Public" access.

Frequently Asked Questions (FAQ)

Q: What should I do if I have lost a physical receipt? A: You must complete a "Missing Receipt Affidavit" form, attach it to your expense entry, and provide a screenshot of your bank statement highlighting the specific transaction. Note that repeated missing receipts may be flagged for management review.

Q: Why was my expense entry rejected or sent back? A: Rejections typically occur due to missing itemized receipts, lack of a clear business justification, or incorrect categorization. Check the "Comments" column in the Google Sheet for specific feedback from the Finance team.

Q: Can I bundle multiple small expenses into one line item? A: No. Each transaction must be logged as an individual line item to ensure accurate ledger tracking and audit compliance. Multiple transactions on one line will be rejected.