Expense Report

📖 Tool Introduction

Expense Report is an online expense organizer built for office workers and small teams, designed to remove the common pain of filling in reimbursement sheets by hand after business trips, field visits and routine office purchases. Instead of wrestling with a spreadsheet, you simply add expenses one row at a time: pick a date, choose a category (transport, meals, lodging, supplies, communication or other), type in the amount and a short note, and the tool keeps a tidy detail table for you in real time. Click Summarize and every amount is automatically grouped by category, producing a subtotal for each category and a grand total for the whole report, with amounts formatted in thousands separators so you never need a calculator again. Everything runs locally in your browser: the items are kept in localStorage, so refreshing the page or closing the browser will not lose them, and nothing is uploaded to any server. The amounts and client names on your travel receipts stay entirely on your own device. The exported CSV carries a BOM header, so it opens cleanly in Excel or WPS with proper Chinese characters, ready to be attached straight to your reimbursement submission. Whether you are self-employed chasing deductible costs or an employee gathering receipts for finance, this tool turns a messy pile of paper tickets into a structured, audit-ready sheet within minutes, and because no account is required you can jump straight into data entry without onboarding friction.

✨ Key Features

• Add and remove rows freely: every line holds its own date, category, amount and note, and a row can be deleted with one click
• Six everyday categories: transport, meals, lodging, supplies, communication and other, covering most routine reimbursement scenarios
• Live category summary: subtotals and the grand total recalculate automatically whenever an amount changes, with thousands separators for readability
• One-click CSV export: includes a header, every line item and a totals row, with a BOM so Excel opens it without garbled text
• Automatic local saving: all items are written to localStorage and survive refreshes and browser restarts
• Built-in example: a five-day business trip dataset loads instantly so you can try the whole workflow in one click

📝 How to Use

1. Click the Add row button and a blank expense line appears in the table
2. On that line choose the date and category, enter the amount (up to two decimals) and a note
3. Repeat the previous step for every receipt; remove a mistaken line with the Delete button on its right
4. Click Summarize and the card below shows category subtotals plus the grand total
5. Once everything looks right, click Export CSV to download the file, or Clear all to start the next reimbursement

⚠️ Notes

• Valid amounts: the amount must be a valid number not less than zero; blank or negative rows are excluded from the summary
• Clearing is permanent: Clear all deletes every item stored locally, and a confirmation dialog protects you from accidental wipes
• Local storage limits: items live in browser localStorage, so clearing browser data can remove them; export important sheets to CSV promptly
• CSV encoding: the export uses UTF-8 with a BOM, which suits Chinese Excel environments and prevents garbled characters
• Fixed categories: six common categories are built in; for anything extra you can mention it in the note column and let finance sort it manually