BMD FLYASH BRICKS

Sales

₹0

0 transactions

Cash In

₹0

0 payments

Bricks Produced

0

units produced

Bricks Sold

0

0 orders

Expenses

₹0

0 entries

Receivables

₹0

outstanding

Net Profit

₹0

this period

🧱

BRICKS IN STOCK

Production − Sales = Available

HEALTHY

0

bricks available — today

0% 0% in stock

PRODUCED

0

in period

SOLD

0

dispatched

NET STOCK

0

± period

WAGES CYCLE (Tue→Tue)

—

CYCLE PRODUCTION

0 bricks

Quick Entry

💰

Sale

🏭

Production

💸

Expense

📦

Stock

💳

Payment

🗑️

Clear Data

Clear All Data

��️ Warning: This will permanently delete all data — including sales, production, expenses, inventory, payments, and staff records. This action cannot be undone.

Enter the admin password to confirm:

👁️

Trends

🏭 Brick Production

📋 Daily Cash Summary

🔴 Follow-Up Required · Outstanding Balances

✅ All balances cleared. No follow-up required.

Recent Sales

Sl. No	Date	Customer	Vehicle	Location	Qty	Total ₹	Received ₹	Balance ₹	Status

Monthly Summary

💡 Tap a row to see daily breakdown

Month	Sales ₹	Cash ₹	Bricks	Expenses ₹	Profit ₹	Margin

💰 Sales & Dispatch

Record deliveries, track payments, and manage customer balances

📋

⬤ Not synced yet

✏️ New Sale Entry ▾

⚡ Live Sale Preview

— Select status —

🧱 Bricks

0

💰 Total

₹0

✅ Received

₹0

⚖️ Balance

₹0

🚚Delivery Details

Date *

Customer Name *

Phone Number

Site / Delivery Location

Vehicle No.

💰Payment Details

Quantity Sold (Bricks) *

Total Amount (₹) *

Rate: ₹ /brick

Payment Status *

Amount Received (₹)

Enter 0 if no cash received yet

Balance (₹) — Auto

📝Remarks (optional)

🔍

Sl. No	Date	Customer Name	Phone	Vehicle No.	Site / Location	Qty	Total (₹)	Received (₹)	Balance (₹)	Status	Remarks

Total Sales

₹0

Cash Received

₹0

Balance Pending

₹0

Transactions

0

\ud83d\udccb

Sync Production from Google Form

\u26ac Not synced yet

Production Entry Form

⏱️ Enter at end of each shift. Keep it simple — only required fields marked *.

Date *

Shift *

Number of Bricks Produced *

Male Workers

Female Workers

Remarks

Total Bricks Produced Today

0

across all shifts

Total Bricks This Month

0

bricks produced

👨 Male Workers Today

0

workers

👩 Female Workers Today

0

workers

👷

WEEKLY WORKER AVERAGE

Tue to Tue wages cycle

AVG MALE

0

per day

AVG FEMALE

0

per day

AVG TOTAL

0

per day

WORKING DAYS

0

in period

Period Total: 👨 0 | �� 0 | 🧱 0 bricks

Production Log

📅 View date: ⇕ Sort:

Sl. No	Date	Shift	Bricks Produced	👨 Male	👩 Female	Total Workers	Remarks	Entered At

Expense Entry Form

⏱️ Record every expense immediately. Bill available entries build trust and accountability.

Date *

Expense Category *

Description *

Amount (₹) *

Remarks

Total Expenses Today

₹0

0 entries

Total Expenses This Month

₹0

this month

👷 Weekly Labour & Staff Payments

⏱️ Labour and staff wages are paid weekly. Record this week's payment below.

Week Ending (Payment Date) *

No. of Workers Covered

Total Amount (₹) *

Remarks

📅 Weekly Labour Payment Log

Sl. No	Week Ending	Workers	Amount Paid (₹)	Avg / Worker (₹)	Remarks

This Month's Labour Total: ₹0

Expense Entries

📅 View date: ⇕ Sort:

Sl. No	Date	Time	Category	Description	Amount (₹)	Remarks

Total: ₹0

Expense Category Breakdown (This Month)

Category Split

Category Totals

No expense data yet.

Raw Material Stock Tracker

💡 Update inventory when materials arrive (IN) or are consumed in production (OUT). Closing stock = Opening + IN − OUT.

Current Stock Summary

Add Inventory Movement

Date *

Material *

Movement Type *

Quantity *

Unit

Vendor / Reason

Amount (₹)

Stock Movement Log

Sl. No	Date	Material	Type	Quantity	Unit	Vendor / Reason	Amount (₹)

Monthly Profit & Loss Report

Select Year

Select Month

Total Sales Revenue

₹0

Cash Received

₹0

Total Expenses

₹0

Bricks Produced

0

bricks

Gross Profit

₹0

Profit Margin

0%

📤 Expense Breakdown

🏗️ Production vs Sales Gap

Full Profit & Loss Statement

Item	Selected Month	All Time Total
📥 Total Sales Revenue	₹0	₹0
💰 Cash Received	₹0	₹0
📤 Total Expenses	₹0	₹0
✅ Gross Profit (Sales − Expenses)	₹0	₹0
🔴 Outstanding Receivables	₹0	₹0
�� Bricks Produced	0	0
🛒 Bricks Sold	0	0
📊 Avg Rate per Brick (��)	₹0	₹0

Full Sales Ledger

Sl. No	Date	Customer	Phone	Vehicle	Site	Qty	Total (₹)	Received (₹)	Balance (₹)	Status	Remarks

Full Expense Ledger

Sl. No	Date	Category	Description	Amount (₹)	Remarks

👥 Customer Ledger — Outstanding Tracker

👥 Customer Portfolio

💰 Outstanding payment tracker

Total Customers

0

Total Received

₹0

Total Outstanding

₹0

Customers with Dues

0

🔍

Sort:

No customer data yet. Add sales entries first.

📞 Payment Follow-up List From To

#	Customer Name	Phone	Total Sales (₹)	Amount Received (₹)	Outstanding (₹)	No. of Orders	Last Order Date	Status

Customer Balance Due

₹0

total outstanding

Received This Month

₹0

customer payments

Vendor Balance Due

₹0

total payable

Paid This Month

₹0

vendor payments

👤 Record Customer Payment

Date

Customer Name *

Outstanding Balance

Amount Received *

Payment Mode

Remarks

🏗️ Record Vendor Payment

Date

Vendor Name *

Outstanding Payable

Amount Paid *

Payment Mode

Remarks

Vendor Ledger — Payables Tracker

Sl. No	Vendor	Total Purchases (₹)	Total Paid (₹)	Balance Payable (₹)	Status

Customer Payment History

Sl. No	Date	Time	Customer	Amount (₹)	Mode	Remarks

Vendor Payment History

Sl. No	Date	Time	Vendor	Amount (₹)	Mode	Remarks

📒 One-time setup: Enter all customers who owed you money before you started using this system. These opening balances will appear in the Customer Ledger and affect outstanding totals — without polluting your sales history.

Total Opening Due

₹0

Customers Entered

0

Already Cleared

0

Add Opening Balance Entry

✏️ Enter the net amount still owed to you after accounting for all old receipts. If a customer paid everything already, don't enter them here.

Customer Name *

Matches existing sales customers automatically

Phone Number

Opening Balance (₹) *

Amount owed to you as of your system start date

As of Date

Date your books were transferred (usually today or month start)

Note / Reference

📋 Bulk Add (Paste from Notebook / Excel)

💡 Paste rows directly — one customer per line in format: Name, Phone, Balance
Example: Pratap Rana, 9876543210, 45000

Paste Data (Name, Phone, Balance — one per line)

Opening Balance Register

#	Customer Name	Phone	Opening Balance (₹)	As of Date	Payments Received	Still Outstanding	Note

Total Opening: ₹0 Total Received: ₹0 Still Pending: ₹0

🗄️ Backup & Restore Data

Download a full backup of all your data (sales, payments, customers, production, expenses). Restore from any previous backup file.

⬆️ Restore from Backup

🧾 Export to Tally (XML)

Generate a Tally-compatible XML file (sales, receipts, vendor payments & expenses) with auto-created ledger masters. Leave dates blank to export everything.

In Tally: Gateway of Tally → Import Data → Vouchers, then select the downloaded file.

From Date

To Date

🗂️ Clear Data — Department-wise

Permanently delete data for one department only — your other records stay safe. Each action is password-protected. This cannot be undone — download a backup first.

Clear Department

Enter the admin password to confirm:

👁️

Part A — Google Sheets Structure (8 Tabs)

Tab Name	Purpose	Who Edits It
📊 DASHBOARD	Live KPIs, today's snapshot, monthly summary	Auto (formulas only)
📝 SALES ENTRY	All sales data from Google Form	Auto from Form
🏗️ PRODUCTION ENTRY	All production data from Form	Auto from Form
💸 EXPENSE ENTRY	All expense data from Form	Auto from Form
📦 INVENTORY	Raw material stock levels and movement log	Auto from Form
�� CUSTOMER LEDGER	Customer-wise outstanding balance tracker	Auto (formulas)
📈 MONTHLY P&L	Profit & Loss report by month and year	Auto (formulas)

Part B — Sales Entry Sheet Column Layout

Col	Header Name	Type	Formula / Notes
A	Timestamp	Auto	Filled automatically by Google Form
B	Date	Date	Entered in form (format: DD/MM/YYYY)
C	Customer Name	Text	Entered in form
D	Phone Number	Text	Entered in form
E	Site / Delivery Location	Text	Entered in form
F	Vehicle Number	Text	Entered in form
G	Quantity Sold (Bricks)	Number	Entered in form
H	Total Amount (₹)	Number	Entered in form
—	~~Payment Status~~	—	No longer needed — auto-calculated from Amount Received
J	Amount Received (₹)	Number	Entered in form
K	Balance Amount (₹)	Formula	=H2-J2
L	Remarks	Text	Entered in form
M	Month-Year	Formula	=TEXT(B2,"MMM-YYYY")

🟡 Yellow columns are formula columns — do not type in these manually.

Part C — Production Entry Sheet Columns

Col	Header Name	Type	Notes
A	Timestamp	Auto	Auto from Form
B	Date	Date	Entered in form
C	Shift	Dropdown	Morning / Evening / Night / Full Day
D	Number of Bricks Produced	Number	Entered in form
E	Remarks	Text	Entered in form
F	Month-Year	Formula	=TEXT(B2,"MMM-YYYY")

Part D — Expense Entry Sheet Columns

Col	Header Name	Type	Notes
A	Timestamp	Auto	Auto from Form
B	Date	Date	Entered in form
C	Expense Category	Dropdown	8 categories (Raw Material, Labour, etc.)
D	Description	Text	Entered in form
E	Amount (₹)	Number	Entered in form
F	Remarks	Text	Entered in form
G	Month-Year	Formula	=TEXT(B2,"MMM-YYYY")

Part E — Key Google Sheets Formulas

1. Today's Total Sales Amount (DASHBOARD cell B2)

=SUMIF(SALES!B:B, TODAY(), SALES!H:H)

2. Monthly Total Sales (DASHBOARD cell B3)

=SUMPRODUCT((MONTH(SALES!B2:B2000)=MONTH(TODAY()))*(YEAR(SALES!B2:B2000)=YEAR(TODAY()))*SALES!H2:H2000)

3. Balance Amount — Auto (SALES column K)

=H2-J2 ← paste down all rows in column K

4. Total Outstanding Receivables (all unpaid balances)

=SUMIF(SALES!I:I,"Pending",SALES!K:K)+SUMIF(SALES!I:I,"Partial",SALES!K:K)

5. Customer-wise Outstanding Balance (CUSTOMER LEDGER col E)

=SUMIF(SALES!C:C, A2, SALES!K:K) ← where A2 = customer name in Customer Ledger sheet

6. Today's Production (bricks)

=SUMIF(PRODUCTION!B:B, TODAY(), PRODUCTION!D:D)

7. Monthly Expenses Total

=SUMPRODUCT((MONTH(EXPENSE!B2:B2000)=MONTH(TODAY()))*(YEAR(EXPENSE!B2:B2000)=YEAR(TODAY()))*EXPENSE!E2:E2000)

8. Net Profit This Month (Sales minus Expenses)

=B3-B6 ← B3 = Monthly Sales, B6 = Monthly Expenses (in DASHBOARD)

9. Expense by Category (e.g. Labour Wages this month)

=SUMPRODUCT((MONTH(EXPENSE!B2:B500)=MONTH(TODAY()))*(EXPENSE!C2:C500="Labour Wages")*EXPENSE!E2:E500)

10. Bricks Produced vs Sold Gap (Inventory Check)

= Estimated closing stock of bricks in yard =SUMPRODUCT((MONTH(PRODUCTION!B2:B500)=MONTH(TODAY()))*PRODUCTION!D2:D500) -SUMPRODUCT((MONTH(SALES!B2:B500)=MONTH(TODAY()))*SALES!G2:G500)

11. Count Customers with Balance Due

=COUNTIF(CUSTOMER_LEDGER!E:E,">0")

12. Average Rate per Brick This Month

=IFERROR(SUMPRODUCT((MONTH(SALES!B2:B500)=MONTH(TODAY()))*SALES!H2:H500) /SUMPRODUCT((MONTH(SALES!B2:B500)=MONTH(TODAY()))*SALES!G2:G500),0)

Part F — Google Forms Setup (3 Forms)

📋

Form 1 — Sales Entry Form

Go to forms.google.com → Blank form → Add these fields exactly in this order. Link to SALES ENTRY tab in your spreadsheet.

Fields: Date (Date), Customer Name (Short text), Phone Number (Short text), Site / Delivery Location (Short text), Vehicle Number (Short text), Quantity Sold — Number of Bricks (Number), Total Amount ₹ (Number), Amount Received ₹ (Number), Remarks (Paragraph). Note: Don't add a "Payment Status" field — the dashboard now calculates Paid / Partial / Pending automatically from Amount Received.

⚠️ Balance Amount is NOT a form field — it is auto-calculated by the formula =H2-J2 in column K of the spreadsheet.

→ Open Google Forms to create

🏭

Form 2 — Production Entry Form

Simple 4-field form. Link to PRODUCTION ENTRY tab.

Fields: Date (Date), Shift (Dropdown: Morning Shift / Evening Shift / Night Shift / Full Day), Number of Bricks Produced (Number), Remarks (Paragraph)

→ Open Google Forms to create

💸

Form 3 — Expense Entry Form

Simple 5-field form. Link to EXPENSE ENTRY tab.

Fields: Date (Date), Expense Category (Dropdown: 8 categories), Description (Short text), Amount ₹ (Number), Remarks (Paragraph)

→ Open Google Forms to create

Part G — Step-by-Step Setup Instructions

Create a free Google Account
Go to accounts.google.com → Create account. Use your business name or personal Gmail. This is completely free.
Open the uploaded Excel file in Google Sheets
Go to drive.google.com → Upload the Excel file → Right-click → Open with Google Sheets. Rename it "Fly Ash Brick Plant Manager 2025".
Verify all 7 tabs are present
Check the tabs at the bottom: Dashboard, Sales Entry, Production Entry, Expense Entry, Inventory, Customer Ledger, Monthly P&L. If any are missing, add them by clicking the + button.
Add formula columns in Sales Entry sheet
Click cell K2 in the SALES ENTRY tab. Type =H2-J2 and press Enter. Then click K2, copy it (Ctrl+C), select K2:K2000, and paste (Ctrl+V). This auto-calculates Balance Amount for every row.
Create Form 1 — Sales Entry
forms.google.com → New Form → Add all 10 fields as listed above → Click Responses tab �� Google Sheets icon → Link to existing spreadsheet → Select SALES ENTRY tab.
Create Form 2 — Production Entry
Same process. Add 4 fields (Date, Shift, Bricks, Remarks). Link to PRODUCTION ENTRY tab.
Create Form 3 — Expense Entry
Add 5 fields (Date, Category, Description, Amount, Remarks). Link to EXPENSE ENTRY tab.
Build DASHBOARD formulas
In the DASHBOARD tab, enter the SUMIF and SUMPRODUCT formulas provided above. Each formula cell should be clearly labelled (Today's Sales, Monthly Sales, etc.)
Set up Customer Ledger
In CUSTOMER LEDGER tab, type customer names in Column A. In Column C enter =SUMIF(SALES!C:C,A2,SALES!H:H) for Total Sales. In Column E enter =SUMIF(SALES!C:C,A2,SALES!K:K) for Outstanding Balance.
Share form links with staff (mobile bookmarks)
Open each form on phone browser → tap Share → Copy link → Save as bookmark on home screen. For Android: Menu → Add to Home Screen. Staff should ONLY access forms, not the spreadsheet directly.
Enable "Collect email addresses" on all forms
In each Google Form → Settings → Responses → turn on "Collect email addresses". This records who submitted each entry — essential for staff accountability.
Test with 3 dummy entries
Enter 1 sale, 1 production, 1 expense using the forms. Open the Google Sheet and verify the data appeared in the right tabs and balance auto-calculated.

Part H — Daily Staff Checklist

🌅 Morning (Start of Day)

☐ Check yesterday's pending payments
☐ Record any cash received from customers
☐ Check production target for today
☐ Verify raw material stock

⏱️ After Every Sale

☐ Open Sales Form immediately on phone
☐ Fill all fields — takes under 2 min
☐ Record vehicle number
☐ Confirm amount with customer

🔄 End of Each Shift

☐ Count total bricks produced
☐ Fill Production Form (4 fields only)
☐ Note any machine issues in Remarks
☐ Record shift expenses

🌙 Evening (End of Day)

☐ Open Dashboard — review totals
☐ Check outstanding customer list
☐ Call customers with pending balance
☐ Owner signs off daily summary

Confirm Deletion

Edit Entry

BMD FLYASH BRICKS

Clear All Data

Bricks Breakdown

👤 Customer

Clear Department