Print Expense Tracker

History Log

Why Use a Digital Print Tracker?

In the busy environment of a photocopy shop or a university project center, tracking every single page is difficult. Notebooks get lost, and mental math leads to financial leakage.

Power User Features

Designed for the Indian market context (₹), but works globally.

🚀 Cloud Sync Setup Guide

To enable syncing between your Phone and Laptop, you need to create your own "Backend" using a free Google Sheet.

Step 1: The Google Sheet

• Create a new Sheet named Print Tracker DB.
• Rename Sheet1 to Jobs (Case sensitive).
• Add a second tab named Payments (Case sensitive).
• Jobs Headers (Row 1): id, documentName, pages, costPerPage, totalCost, date
• Payments Headers (Row 1): id, amount, date

Step 2: The Script

Go to Extensions > Apps Script. Delete existing code and paste this.
IMPORTANT: Paste your Spreadsheet ID in the first line.

// ==========================================
// PRINT TRACKER BACKEND (FINAL)
// ==========================================

// 👇 PASTE YOUR SPREADSHEET ID HERE 👇
const SHEET_ID = "PASTE_YOUR_SHEET_ID_HERE"; 

function doGet(e) {
  const ss = SpreadsheetApp.openById(SHEET_ID);
  const jobsSheet = ss.getSheetByName("Jobs");
  const paySheet = ss.getSheetByName("Payments");
  
  const jobsData = getSheetData(jobsSheet);
  const payData = getSheetData(paySheet);
  
  return ContentService.createTextOutput(JSON.stringify({ 
    jobs: jobsData, 
    payments: payData 
  })).setMimeType(ContentService.MimeType.JSON);
}

function doPost(e) {
  const ss = SpreadsheetApp.openById(SHEET_ID);
  
  try {
    const data = JSON.parse(e.postData.contents);
    const action = data.action;
    
    const lock = LockService.getScriptLock();
    lock.tryLock(10000); 
    
    try {
      // CONVERT TIMESTAMP TO DATE OBJECT
      const rowDate = new Date(data.date);

      if (action === "addJob") {
        const sheet = ss.getSheetByName("Jobs");
        const id = data.id; 
        sheet.appendRow([id, data.documentName, data.pages, data.costPerPage, data.totalCost, rowDate]);
      } 
      else if (action === "addPayment") {
        const sheet = ss.getSheetByName("Payments");
        const id = data.id;
        sheet.appendRow([id, data.amount, rowDate]);
      }
      else if (action === "editJob") {
         updateRow(ss.getSheetByName("Jobs"), data.id, [data.id, data.documentName, data.pages, data.costPerPage, data.totalCost, rowDate]);
      }
      else if (action === "delete") {
        const sheetName = data.type === 'job' ? "Jobs" : "Payments";
        deleteRow(ss.getSheetByName(sheetName), data.id);
      }
      
      return ContentService.createTextOutput(JSON.stringify({status: "success"}));
      
    } catch (innerError) {
      return ContentService.createTextOutput(JSON.stringify({status: "error", message: innerError.toString()}));
    } finally {
      lock.releaseLock();
    }
    
  } catch (e) {
    return ContentService.createTextOutput(JSON.stringify({status: "fatal_error", message: e.toString()}));
  }
}

// --- HELPER FUNCTIONS ---

function getSheetData(sheet) {
  if (!sheet) return [];
  const lastRow = sheet.getLastRow();
  if (lastRow < 2) return []; 
  
  const rows = sheet.getRange(2, 1, lastRow - 1, sheet.getLastColumn()).getValues();
  const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
  
  return rows.map(row => {
    let obj = {};
    headers.forEach((h, i) => {
      if (row[i] instanceof Date) {
        obj[h] = row[i].getTime();
      } else {
        obj[h] = row[i];
      }
    });
    return obj;
  });
}

function deleteRow(sheet, id) {
  const data = sheet.getDataRange().getValues();
  for (let i = data.length - 1; i >= 1; i--) {
    if (String(data[i][0]) === String(id)) {
      sheet.deleteRow(i + 1);
      return;
    }
  }
}

function updateRow(sheet, id, newValues) {
  const data = sheet.getDataRange().getValues();
  for (let i = 1; i < data.length; i++) {
    if (String(data[i][0]) === String(id)) {
      sheet.getRange(i + 1, 1, 1, newValues.length).setValues([newValues]);
      return;
    }
  }
}

Step 3: Deploy & Connect

• Click Deploy > New Deployment.
• Select Type: Web App. Execute as: Me. Who has access: Anyone.
• Copy the URL, come back here, click "⚙️ Data Source", paste URL, and connect.

Frequently Asked Questions