Kumaran Silk ERP

SKU	KS Product Name	Vendor	Category [Code]	Purch Date	Sales Date	Cost ₹	Sell ₹	Margin	Orig Qty	Stock	Adj	Sold	Sold M%	% Sold	Inv. Value	Last Scan	Auth Status

Bill No	Date / Time	Customer	Salesperson	Payment	Delivery Status	Items	Subtotal	GST	Total	Discount	Authorization

From To

SKU ↕	Date ↕	Supplier ↕	Vendor Invoice Number ↕	Items ↕	Total Qty ↕	Total Cost (Pre-GST + Shipping) ↕	Total Invoice Value ↕

Only vendors with purchases in FY

Vendor Name	GSTIN	Contact Person	Phone	Email	State	Address	Total Purchases	Last Purchase

Customer Name	Group	GSTIN	Contact Person	Phone	Email	State	City / Country	Total Sales	Last Sale

Bill No	Date	Customer	GSTIN	Payment	Delivery Status	Items	GST	Total	Authorization

PO No	Date	Customer	Items	Status

Return No	Date	Vendor	Items	Value

Order No	Date	Customer	Item	Qty	Est. Price	Advance	Due	Status

Record a Payment

Customer

Date

Mode

Amount Received (₹)

Note (optional)

Recent Receipts & Payments

Reference ID	Date	Party	Mode	Amount	Applied To

Customer

From

To

Email downloads the PDF automatically, then opens your email app — attach the downloaded file manually (mailto links can't attach files).

Date	Particulars	Ref No.	Debit	Credit	Balance

Vendor

From

To

Debits are purchases (goods received); credits are purchase returns (credit notes). Payments made to the vendor aren't tracked yet, so this is a running transaction history, not a fully reconciled payable.

Date	Particulars	Ref No.	Debit	Credit	Balance

Bank account

⬆ Upload statement

Upload the Excel (.xls) file downloaded from the bank portal as-is. It's read on this computer — the file itself is never uploaded or stored; only the statement lines are saved.

Statement lines

Line No	Date⇅	Description	Withdrawal⇅	Deposit⇅	Balance	Status

Total Outstanding (all-time): ₹0.00

Daily Breakdown

Till Reconciliation

Computed Closing Balance

₹0.00

Cash Counted ₹

Cash Adjustments (Bank Deposit / Owner Withdrawal — for the day shown above)

Type

Amount ₹

Note

Type	Amount	Note

Financial Year

From

To

Salesperson

Search

From

To

Category / Subcategory	Code	Product Item Code	Products

	Date	Type	Status	Product / Bill	Invoice	Description	Requested By	Impact	Action

From To

Date	Type	SKU	Product	Cat Code	Amount	Original Invoice	New Invoice	Notes

Activity

User

From

To

Search

Date	Activity	Details	User	Timestamp

Date	Category	Description	Payment	Amount

Date	Description	Payment	Amount

Export & Bank Details

Bank Name

Bank Account Number

IFSC Code

IE Code (Import/Export)

AD Code

Purchase SKU Numbering

New purchases auto-assign the next SKU in sequence. Use this to jump to a specific starting series — e.g. reserving a number range or aligning with an existing SKU book.

Next Purchase SKU (current)

Set Next Purchase SKU To

Custom Range Check

From

To

Date Range (by Application Date)

From

To

Track IGST refund claims (RFD-01) against export bills. Purely a tracking log — doesn't affect the GST Summary figures.

Export Bill	Customer	ARN	Applied	Refund Amount	Status	Received

Date Range (by Invoice Date)

From

To

Port Code, Shipping Bill No. and Shipping Bill Date — required per export invoice for GSTR-1 Table 6A. Filled in after customs clears the shipment, so this list exists to make sure nothing gets missed before filing.

Invoice No	Date	Customer	Invoice Value	IGST	Port Code	Shipping Bill No.	Shipping Bill Date	Status

Emp No	Employee	Role	Monthly Salary	Status	Mark