Record a site expense
in about a minute.
Use your existing attendance Google Sheet, now with an Expenses tab, to record what was purchased, for which project, from which hardware shop, and where the bill photo is stored. No PDF or technical spreadsheet knowledge needed.
1. Open your existing attendance workbook
Open your existing private Attendance Google Sheet using the corrected link sent by management. Sign in with your assigned Google account. The SAME workbook now contains Attendance and Expenses entry tabs. Open Expenses for spending; keep using Attendance for site visits. Never use the superseded separate expense file shared previously.
Each row already has an ID. Use the next row that has no Date/Item/Amount.
Type/select the payment date (AD), then what was purchased or paid for.
Select the correct Fishtail project from the Project Name dropdown. Do not type an unrelated company project.
Amount is in NPR and must be greater than zero. Hardware means the shop or supplier name, if applicable.
Paste the receipt's Google Drive link into Bill Photo. Use Remarks for short factual notes.
Google Sheets saves edits automatically. Open Summary to see total entered expenses and incomplete rows.
2. What do the eight columns mean?
| Column | What to enter | Example (illustration only) |
|---|---|---|
| ID | Already assigned. Leave unchanged. | EXP-FBL-…-000001 |
| Date | Actual expense date (AD). | 18-Oct-2026 |
| Item | What was bought / spent. | Nails, 2-inch |
| Project Name | Select from dropdown. | 15 Narayani Parajuli |
| Amount | NPR paid (positive number). | 450 |
| Hardware | Supplier, hardware shop or store; leave blank if not applicable. | Example Hardware |
| Bill Photo | Private Google Drive file URL for the receipt; link must be accessible to the authorized reviewer. | Paste Drive link |
| Remarks | Short, factual details, if needed. | For site formwork |
Columns after H are hidden reference fields. They link person, company, project, receipt, and source-row identities. You don't need to fill or unhide them.
3. Example of a completed entry
The example below is only a display. It is not connected to your Google Sheet and does not create a payment.
4. How to attach a bill photo
Show the full receipt, date, shop name, line items and total if present. Don't crop important details.
Upload the photo in a management-approved, restricted evidence folder or your authorized Drive space. Do not use public “Anyone with link” sharing.
Open the uploaded image in Drive → Share / Copy link. Ensure the authorized manager can open it.
Return to your expense row, tap the Bill Photo cell, and paste the link. The Sheet does not automatically grant access to the photo.
Photo status: This first release records receipt links; it does not upload images directly from a spreadsheet cell, nor verify whether a receipt is authentic. If you lack permission to upload or share, ask management to designate a private evidence folder.
5. Common questions
Where is the Save button?
Google Sheets normally saves your edits automatically. After entering a value, tap the checkmark / Enter to finish editing, and check Summary.
What if the project isn't in the dropdown?
Do not choose the wrong project. Tell management which Fishtail project is missing. The list has to be updated from the governed project registry.
What if I paid an advance instead of buying an item?
Do not record it as an expense without clear accounting direction. Report the advance separately so it can be classified correctly.
What if I have two purchases on one day?
Use one row for each distinct spending event, even when Date, Project Name or Hardware are identical.
Can I edit an old amount or delete a row?
Don't delete or overwrite old records. Contact management with the original ID and requested correction. Automated append-only auditing is not installed in this initial workbook version.
Can my colleague open my expense workbook?
The existing attendance workbook is shared with its assigned engineer and authorized administrative accounts. Other engineers should not be added. Additional private tabs do not create file-level confidentiality; do not forward private workbook links.
Do I still use the separately sent expense Sheet?
No. That earlier standalone file is retired and owner-protected. Use only the Expenses tab inside your original attendance workbook, as shown in the corrected email/Slack DM. Management is handling final removal of the old direct sharing permission.
Does the tutorial upload or publish any financial data?
No. This is a public how-to page only. Actual spending amounts, receipt links and identity mappings remain in private Drive workbooks. Expense entries are not automatically synced to the public website.
Tutorial version v0.2 · 18 October 2026 · Workbooks: Shiv site visits + Expenses v1.17 and Paras Attendance + Expenses v1.8, both with their original Google Sheet IDs. Public website contains instructions only, not private links, payment amounts or supplier records.
System separation: this Fishtail field-expense guide does not migrate the Rohini/Krishna Kumar Gupta finance register, shared cement, daily progress, PDF rate sources or attendance records. Google Drive remains the operational data authority.