SpendWise
Daily Expenditure & Budget Tracker
Total Expenditure
₹0.00
Across 0 transactions
Today's Expenditure
₹0.00
Today
Top Spending Category
None yet
₹0.00 (0%)
Add New Expense
Category Breakdown
Spending distribution by category
No data to visualize
Add an expense to see breakdown
Expense History
Showing all recorded transactions
| Date | Description | Category | Payment | Amount | Actions |
|---|
No expenses found
Try adjusting your search or filter criteria, or add a new expenditure entry above.
Confirm Action
Are you sure you want to proceed?
Google Sheets Auto-Backup
Mirror every expense automatically to your Google Sheet
Once saved, every new, edited, or deleted expense syncs automatically in the background.
2. Manual Bulk Sync & Restore
const SHEET_NAME = 'Expenses';
function getOrCreateSheet() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
let sheet = ss.getSheetByName(SHEET_NAME);
if (!sheet) {
sheet = ss.insertSheet(SHEET_NAME);
sheet.appendRow(['ID', 'Date', 'Description', 'Category', 'Payment Method', 'Amount (INR)', 'Updated At']);
sheet.getRange(1, 1, 1, 7).setFontWeight('bold');
}
return sheet;
}
function doPost(e) {
const sheet = getOrCreateSheet();
const payload = JSON.parse(e.postData.contents);
const now = new Date().toISOString();
if (payload.action === 'syncAll' && Array.isArray(payload.expenses)) {
sheet.clearContents();
sheet.appendRow(['ID', 'Date', 'Description', 'Category', 'Payment Method', 'Amount (INR)', 'Updated At']);
sheet.getRange(1, 1, 1, 7).setFontWeight('bold');
const rows = payload.expenses.map(item => [
item.id, item.date, item.description, item.category, item.paymentMethod, Number(item.amount), now
]);
if (rows.length > 0) {
sheet.getRange(2, 1, rows.length, 7).setValues(rows);
}
return ContentService.createTextOutput(JSON.stringify({ status: 'ok', count: rows.length }))
.setMimeType(ContentService.MimeType.JSON);
}
const data = sheet.getDataRange().getValues();
const rowIndex = data.findIndex((row, idx) => idx > 0 && row[0] === payload.expense?.id);
if (payload.action === 'delete' && rowIndex > 0) {
sheet.deleteRow(rowIndex + 1);
} else if ((payload.action === 'add' || payload.action === 'edit') && payload.expense) {
const exp = payload.expense;
const rowValues = [exp.id, exp.date, exp.description, exp.category, exp.paymentMethod, Number(exp.amount), now];
if (rowIndex > 0) {
sheet.getRange(rowIndex + 1, 1, 1, 7).setValues([rowValues]);
} else {
sheet.appendRow(rowValues);
}
}
return ContentService.createTextOutput(JSON.stringify({ status: 'ok' }))
.setMimeType(ContentService.MimeType.JSON);
}
function doGet() {
const sheet = getOrCreateSheet();
const values = sheet.getDataRange().getValues();
const expenses = values.slice(1).filter(r => r[0]).map(r => ({
id: String(r[0]),
date: r[1] instanceof Date ? Utilities.formatDate(r[1], Session.getScriptTimeZone(), 'yyyy-MM-dd') : String(r[1]),
description: String(r[2]),
category: String(r[3]),
paymentMethod: String(r[4]),
amount: Number(r[5]) || 0
}));
return ContentService.createTextOutput(JSON.stringify({ status: 'ok', expenses }))
.setMimeType(ContentService.MimeType.JSON);
}