Aakrithi Homemart — Storefront

Cement Products

🧾 Cement Tax Invoice

Bill To

Customer / Firm Name

Mobile

Customer GSTIN

Invoice Date

Address

Cement Items

#	Brand / Grade	HSN	Bags	Weight	Rate/Bag (₹)	GST%	Amount

Totals & Transport

Discount %

Transport / Freight (₹)

Payment Mode

Due Date (if credit)

Notes

Grand Total: ₹0

📁 Saved Bills

📦 Cement Stock

Brand / Company

Grade / Type

Bag Weight

HSN Code

Stock Bags

Retail Rate / Bag (₹)

Wholesale Rate / Bag (₹)

GST %

Date

📊 Remaining Stock (after purchases)

Live view of how many bags are left. Updates automatically after every bill.

No stock items yet.

🏷️ Price Check (from stock)

Cement product

🧮 Calculation History

No calculations yet.

0

📒 Customer / Supplier Ledger

Date

Party Name

Type

Amount (₹)

Dr / Cr

Reference / Bill No

Narration

Ledger Entries

Party Balance Summary

💰 Sales Summary

₹0Today

₹0This Month

₹0This Year

₹0All Time

🧾 Recent Sales

No sales yet.

💸 Expenses

Date

🛒 Purchases (Suppliers)

Total Purchase Amount: ₹0

No purchase entries in ledger (add under 📒 Ledger).

📊 Income vs Expense

₹0Total Income (Sales)

₹0Total Expense

₹0Net

📈 Profit & Loss (All Time)

₹0Total Income (Sales)

₹0Total Expense

₹0Net Profit / Loss

🧾 GST Summary (HSN-wise)

No sales yet.

Total GST: ₹0

📒 Day Book (Cash Book)

No transactions yet.

⚖️ Balance Sheet (Approx.)

₹0Assets (Stock + Cash)

₹0Liabilities (Supplier Dues)

₹0Capital (Assets − Liabilities)

⚙️ Shop / Letterhead Details

Shop Name

Tagline

Address

Phone

Email

GSTIN

Bank Details Terms & Conditions

🗑 Data Tools

📊 Google Sheets Sync

Send all data (stock, bills, ledger, expenses, accounts) to a Google Sheet. Requires a one-time Google Apps Script setup (instructions below).

Apps Script Web App URL

Auto-sync to Google Sheets on every change

Your Google Sheet: Open Sheet ↗

📖 Setup instructions (one-time)

1. Open sheets.new to create a new Google Sheet.

2. In the sheet: Extensions → Apps Script. Delete the default code and paste the script below. Click Save.

3. Click Deploy → New deployment → Type: Web app. Set "Execute as: Me" and "Who has access: Anyone". Click Deploy and copy the Web App URL.

4. Paste the URL above and click Save URL, then Send All Data.

Apps Script code (copy all):

function doGet(e){
  return ContentService.createTextOutput('Aakrithi Cement sync is running. Send data via POST.').setMimeType(ContentService.MimeType.TEXT);
}
function doPost(e){
  try{
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var raw = e.postData.contents;
    var data = (typeof raw === 'string') ? JSON.parse(raw) : raw;
    function writeSheet(name, rows){
      var sh = ss.getSheetByName(name);
      if(!sh){ sh = ss.insertSheet(name); }
      sh.clear();
      if(rows && rows.length && rows[0] && rows[0].length){
        sh.getRange(1,1,rows.length,rows[0].length).setValues(rows);
      }
    }
    if(data.stock) writeSheet('Stock', data.stock);
    if(data.remaining) writeSheet('Remaining', data.remaining);
    if(data.bills) writeSheet('Bills', data.bills);
    if(data.billItems) writeSheet('Bill Items', data.billItems);
    if(data.ledger) writeSheet('Ledger', data.ledger);
    if(data.expenses) writeSheet('Expenses', data.expenses);
    if(data.accounts) writeSheet('Accounts', data.accounts);
    if(data.company) writeSheet('Company', data.company);
    return ContentService.createTextOutput(JSON.stringify({ok:true})).setMimeType(ContentService.MimeType.JSON);
  }catch(err){
    return ContentService.createTextOutput(JSON.stringify({ok:false,error:String(err)})).setMimeType(ContentService.MimeType.JSON);
  }
}

🗂 Data Backup (save & stay in this HTML)

Export all saved data (bills, stock, ledger, shop details) to a JSON file, or import a backup to restore it. Data also persists automatically in your browser.

⬆ Import JSON

Cement Products

🧾 Cement Tax Invoice

📁 Saved Bills

📦 Cement Stock

📊 Remaining Stock (after purchases)

🏷️ Price Check (from stock)

🧮 Calculation History

📒 Customer / Supplier Ledger

Ledger Entries

Party Balance Summary

💰 Sales Summary

🧾 Recent Sales

💸 Expenses

🛒 Purchases (Suppliers)

📊 Income vs Expense

📈 Profit & Loss (All Time)

🧾 GST Summary (HSN-wise)

📒 Day Book (Cash Book)

⚖️ Balance Sheet (Approx.)

⚙️ Shop / Letterhead Details

🗑 Data Tools

📊 Google Sheets Sync

🗂 Data Backup (save & stay in this HTML)

🧾 Make Bill