Cloud Excel ERP for Manufacturers | Tech Mind Developers

Cloud Excel ERP Admin

Month Billed: ₹0.00

Month Recv: ₹0.00

Net Bal: ₹0.00

Month: 0.00 Kg

Avg ₹/Kg: ₹0.00/Kg

Net ₹/pc: ₹0.00/pc

All Dates

#	ADate	BParty Name	CRemark / Misc	DItem / Description	EPcs	FFinish	GWt (g)	HRate (₹)	IAmount	JReceived	KOld Bal	LNet Bal	MWt (Kg)	N₹/Kg	Tag & Actions
═══════ MONTH GRAND TOTAL RECONCILIATION ═══════
∑	GRAND TOTAL MONTH SUMMARY:				0	Total			₹0	₹0	₹0	₹0	0.00 Kg	₹0/Kg	SUMMARY

Plating Jobwork

OCT 26 (CURRENT)

Filter:

#	A	B	C	D	E	F	G	H	I	J	K	L	Actions
#	Plater / Contractor Name	Date	Description	Remark / Misc	Weight (Kg/Bag)	Finish	No of Bags	Rate/Kg (₹)	Total Weight	Total Amount	Payment Done	Balance	Actions
∑	Total Plating Summary:						0		0.00 Kg	₹0	₹0	₹0

Item Master (Standard Hardware Weights & Rates)

Items registered here will auto-complete standard weights & rates when typing in Item Name.

Item Code / Description	Standard Finish	Standard Weight (Grams/Pc)	Default Rate (₹/Pc)	Effective Rate / Kg	Action

MONTH TOTAL 0 pcs

Billed: ₹0.00 Recv: ₹0.00 Net Due: ₹0.00

Customer Statement

Party Name

Complete Ledger Statement & All Transaction History

Total Billed / Work ₹0

Total Paid / Received ₹0

Net Outstanding Balance ₹0

Transaction Records (Orders & Payments):

Date	Description / Type	Weight	Bill Amount	Paid	Balance	Status

Activity & Edit History Timeline:

1-Click Month Roll-Forward

Automated Balance Transfer for All Parties

Automated Closing Balance Transfer:

Closing Net Balance (Col K) for all parties will automatically transfer to Old Balance (Col J) of the new month sheet.

New Month Name

Security Verification: Enter Admin PIN

* Month roll-forward permanently transfers all closing net balances.

Preview: Net Balances Carried Forward

Manage Passwords & Security

Admin Control for User Logins & Operation Rights

Select User Account to Update Password

Admin Password controls Master Login + all critical approvals (New Month, Purge, Deletions).

Current Admin Password *

New Password for Admin *

Confirm New Password *

Add Order Entry

Date

Party Name

Head / Entry Type

Row Color / Status Tag

Item Name (Type 1st letter)

Weight (g/pc)

Finish Code

Rate (₹/pc)

Pcs (Quantity)

Payment Received (₹)

Remark / Misc Notes

Total Bill (₹): ₹0.00

Total Wt (Kg): 0.00 Kg

Effective ₹/Kg: ₹0.00/Kg

Add Plating Work Entry

Record contractor electroplating lots & weight

Date

Plater / Contractor Name

Work Description / Lot

Finish Code

Remark / Misc Notes

Row Highlight Color

Weight / Bag (Kg)

No. of Bags

Rate / Kg (₹)

Payment Made / Advance (₹)

Total Wt (Kg): 0.00 Kg

Total Amount (₹): ₹0.00

Net Balance (₹): ₹0.00

Add New Party

Parties Master Database

Add Product to Item Master

Auto-suggest standard weights & rates

Edit Product in Item Master

Update item code, description, weight or rate

Edit Party Details

Safely rename or update party information

Order Record

Party Name

Record Details & History

Last edited: Just now

Total Order Amount ₹0

Total Paid / Received ₹0

Remaining Balance ₹0

Remark

Record Partial Payment Instalment:

Payment Timeline / History:

Date & Time	Mode	Amount (₹)	Logged By

Row Audit Trail (Edit History):

Change Password

Update your login security credentials

Party Sequence Reordering

Arrange parties sequence in Excel sheet & dropdown

Auto-saved to browser

Filter by Time Period

Search transactions within date ranges

Quick Period Presets

From Date (Starting)

To Date (Ending)

Order Audit Timeline & History

Party: Nikhil

Audit Logs

Data Retention & Purge Tool

Admin Tool: Safely purge historical sheets while keeping opening balances

Zero Data-Loss Guarantee

Before purging, an automatic full backup (.json) will be saved to your device automatically. Active party opening balances in the latest active month sheet remain 100% preserved.

Select Retention Window

Admin Master PIN Confirmation

One-Time Excel Data Migration Onboarding Wizard

Upload historical client Excel records with anti-corruption calculation safety lock.

Step 1: Download Standard Excel Template

Pre-formatted columns with guide rows, sample data, and formatting rules (.xlsx).

Step 2: Select or Drag & Drop Completed Excel File

Supports .xlsx, .xls, and .csv files. Single master sheet or multiple party/month sheets are automatically detected.

Step 3: Data Integrity Verification & Preview

✅ 100% Valid • Ready to Migrate

Parties

Months

Orders

Total Billed

₹0

Total Received

₹0

Sample Rows Preview (First 5 records) Review columns before confirming

Party	Month	Date	Description	Finish	Wt (g)	Rate	Pcs	Billed (₹)	Recv (₹)

Select Import Mode:

Append & Merge (Recommended)

Adds new parties and orders from the Excel file while keeping existing records safe.

Clean Setup / Fresh Start (Replace All)

Replaces all demo/existing data completely with this Excel data. (Automatic backup snapshot will be saved first).

Cloud Excel ERP

Record Payment

Customer Receivables (Outstanding Accounts)

Plating Contractor Payables (Jobwork Accounts)

Item Master (Standard Hardware Weights & Rates)

Party Name

Transaction Records (Orders & Payments):

Activity & Edit History Timeline:

1-Click Month Roll-Forward

Manage Passwords & Security

Add Order Entry

Add Plating Work Entry

Add New Party

Add Product to Item Master

Edit Product in Item Master

Edit Party Details

Party Name

Record Partial Payment Instalment:

Payment Timeline / History:

Row Audit Trail (Edit History):

Change Password

Party Sequence Reordering

Filter by Time Period

Order Audit Timeline & History

Audit Logs

Data Retention & Purge Tool

One-Time Excel Data Migration Onboarding Wizard

Historical Data Migration Already Completed & Locked