Guides / How to Use

Google Sheets

Connect Google Sheets to automatically sync receipt data.

Connecting your Google Sheets

When you sign up with your Google Account, your Google Sheets is automatically connected.

Folder structure

Files are organised by year: Aidely Receipts Scanner / 2026 / Receipt_YYYY

Sheet structure

Tabs

  • Summary
  • Month — 12 pre-built monthly tabs
  • Reference

Columns for receipt data

  • Receipt identity column: Unique ID, Receipt Image Name, Receipt Date
  • Financial column: Total Amount, Currency
  • Classification column: Items, Company Name, Expense Category, Business Purpose, Payment Method, Attendees, Capital / Revenue, Deductible.
  • Receipt image column: Receipt Image URL — a clickable link to Google Drive
  • System reference column: Scanned At, Full Text, Notes.

Data Management

Some fields are restricted to prevent data loss.
Restricted: Unique ID, Receipt Image Name, Receipt Image URL, Scanned At, Full Text. Other fields are editable/deletable.

Editing receipt data will also update it in the App Dashboard and Receipt History.

Deleting from Sheets removes the receipt data only — the receipt image will remain in Google Drive.