Green Lanka Factory App v6.43.02

GREEN LANKA GROUP

Factory Dashboard

Factory operations and modules available to your role. Select a section to continue.

ATTENDANCE & PAYROLL

Attendance Dashboard

Raw Hikvision punches stay unchanged. Daily attendance and payroll are calculated separately.

Month

Daily report · Monthly editable register · Print / PDF

Payroll Employees0

Present Days0

Missing Checks0

OT Hours0.00

ConnectorNo sync

Monthly Attendance Summary

Select a month.

Employee	Staff Department	Employment	Expected	Present	Paid Leave	No Pay	Missing	Worked Hrs	OT Hrs
No attendance loaded.

Daily Attendance

Actual Hikvision punches are preserved. A punch inside the shift check-in window is credited as the exact shift start. OT is rounded down to the configured interval.

MonthEmployee

Date	Employee	Shift	Actual In	Payroll In	Last Out	Punches	Worked	Late min	Early min	OT hrs	Status	Action
No daily attendance loaded.

Hikvision Connector Events

Employee events received from the connector for the selected month. Events marked Review are visible here but are not used for payroll until they qualify as an attendance punch.

Date / Time	Employee No.	Employee	Use	Status	Verify	Minor	Device	Payroll Link
No connector employee events loaded.

Attendance Adjustment

Use only for approved leave, missing punch correction, no-pay or manual OT. Raw Hikvision events are never edited.

Payroll Employees

Assign each person to a staff department, Permanent/Casual employment type, salary method and OT rate profile. Face photos are synced from the Hikvision terminal by the Windows connector.

Photo	Code	Name	Hikvision	Department	Employment	Shift	Salary Type	Basic / Rate	Incentive	OT Profile	Status	Action
No payroll employees.

Deleted Employees

Employees with saved payroll history are archived instead of destroying past payroll. You can restore an archived employee here.

Code	Name	Department	Deleted	Action
No deleted employees.

Employee Master

A clearer employee setup: link the Hikvision person, assign work details, then enter only the salary fields relevant to that employee. EPF/ETF comes automatically from Employment Type Setup.

No Photo

Hikvision Person Photo

Select the linked Hikvision person. Photos are synced from Person Management by the Windows connector.

Monthly Payroll

Load and process one Department + Employment Type at a time. Attendance must already be Verified/Locked for the same scope.

MonthDepartmentEmployment

StatusDraft

Gross PayRs. 0.00

Employee EPFRs. 0.00

DeductionsRs. 0.00

Net PayRs. 0.00

Employee	Present	No Pay	OT Hrs	Basic Earned	OT Pay	Incentive	Allowances	Other Earn.	Deductions	EPF	Net Pay	Action
Prepare payroll to save a monthly snapshot.

Monthly Earnings / Deductions

Employee	Type	Category	Amount	Note	Action
No monthly adjustments.

ATTENDANCE & PAYROLL

Advance Entry

Fast keyboard entry by employee number or name. Keep the date selected, find the employee, press Enter, enter the amount, then press Enter again to save.

-

Advance Entries - Selected Month

Every advance keeps its transaction date, employee, amount, user and timestamp in the payroll database.

Date	Employee	Amount	Note
No advance entries.

ATTENDANCE & PAYROLL

Tea Entry

Tea is entered by number of packets. The selected Tea Item Master rate calculates the salary deduction automatically.

-

Tea Entries - Selected Month

0 packets · Rs. 0.00

Date	Employee	Tea Item	Packets	Rate	Amount
No tea entries.

ATTENDANCE & PAYROLL

Employee Loan

Create a loan using the loan date, principal and number of installments. The normal installment is calculated automatically.

-

Loan Installment Entry

Record the dated installment that should be deducted from the selected payroll month.

Loan Register

Principal, installment plan and remaining balance.

Employee	Loan Date	Start	Principal	Installments	Normal Inst.	Balance	Status
No employee loans.

Loan Installments - Selected Month

Date	Employee	Amount	Note
No loan installments.

ATTENDANCE & PAYROLL

Other Deductions

Use this only for deductions that are not Advance, Tea or Loan. Date and reason are mandatory.

-

Other Deductions - Selected Month

Date	Employee	Reason	Amount
No other deductions.

Daily Attendance Report

Select a date.

Date

Employee No.	Employee	Department	Employment	Shift	Actual In	Payroll In	Out	Day Qty	OT Qty	Status
No daily attendance report loaded.

Editable Monthly Attendance Register

Each square shows In, Out, Day Qty and OT Qty. Click a square to edit the approved payroll values.

Attendance / Payroll Setup

Admin-only device token, shifts, staff departments, OT rate profiles and holidays.

Hikvision Connector

New connector token

Copy this into the Windows Connector Settings. It is shown only here.

Serial	Device	Factory	Last Event Sync	People Sync	Status
No registered attendance device.

Shift Master

Example: 07:30 start with 10 minutes before/after means a first punch from 07:20 through 07:40 is credited as exactly 07:30. OT starts after shift end and is rounded down to complete intervals. Day Qty 1.00 requires 8 working hours plus the shift break minutes (for example 9 hours presence with a 60-minute break, or 8 hours with no break).

Shift	Time	Check-in Rule	Break	Hours	Early Grace	OT Rule	Days	Action
No shifts.

Staff Department Master

Create factory staff groups such as Workers, Staff, Driver, Security and any other department you need.

Department	Order	Status	Action
No staff departments.

Employment Type · EPF / ETF

Permanent employees are statutory-eligible. Set the Employee EPF, Employer EPF and ETF percentages here once for the whole factory. Casual employees are automatically excluded from EPF/ETF.

Permanent: eligible for EPF/ETF. Casual: not eligible; all statutory rates are forced to 0.

Employment Type	EPF / ETF Eligibility	Employee EPF %	Employer EPF %	ETF %	Status	Action
Run the v6.41.89 SQL migration to create employment type rates.

OT Rate Profiles

Configure separate hourly OT rates for normal workdays, off days/Sundays and holidays. Assign a profile to each employee.

Profile	Normal / Hr	Off Day / Hr	Holiday / Hr	Status	Action
No OT rate profiles.

Holiday Calendar

Date	Holiday	Paid	Action
No holidays.

GREEN LANKA TEA FACTORY

Agent Transport Summary

Monthly transport calculation by route and agent. Total = Factory Incentive + Sup. Trans. Chg. + Fertilizer Transport.

Month

Total Kilograms0.00 kg

Factory IncentiveRs. 0.00

Sup. Trans. Chg.Rs. 0.00

Fertilizer TransportRs. 0.00

TotalRs. 0.00

Monthly Agent Transport

No saved month selected.

Route	Agent	Normal kg	Super kg	Total kg	Agent kg	Rule	Rate	Factory Incentive	Sup. Trans. Chg.	Fertilizer Transport	Total
No Agent Transport month saved yet.

MONTHLY PDF IMPORT

Upload Route Incentive Sheet

Reads Route, Normal kg, Super kg, Total Net kg, the source incentive and Sup. Trans. Chg. from the Green Lanka monthly sheet. Rotated PDF rows are reconstructed and reconciled before any data is accepted. Factory Incentive is then recalculated from Master Data.

Green Lanka only

Incentive PDF * Month

Choose the monthly Agent Incentive PDF and press Read PDF.

FERTILIZER TRANSPORT

Upload Fertilizer Transport Report

Reads the Green Lanka Listing of Deductions/Issues PDF. The importer uses each Total Recovery : Route amount as that route's Fertilizer Transport deduction and adds it to the saved monthly Agent Transport calculation.

PDF import ready

Monthly formula:

Factory Incentive + Sup. Trans. Chg. + Fertilizer Transport = Total. Routes not listed in the uploaded fertilizer report are set to Rs. 0.00 for that month. The report grand total must reconcile before it can be applied.

Fertilizer Transport PDF * Month

Choose the fertilizer report PDF and press Read PDF.

AGENT SUMMARY

Agent Summary

Select an Agent to see every previous month downwards: kilograms, rate per kg, gross transport amount, additions, deductions and the running balance.

Search Agent

Current BalanceRs. 0.00No agent selected

Transport EarningsRs. 0.00

Total Deductions / PaymentsRs. 0.00

Savings RateRs. 0.00/kg

Previous Months

Newest month first. Each month shows earnings and additions first, followed by all deductions.

Select an Agent to view monthly summaries.

Add Account Entry

Loan Deduction Schedule

Account Ledger

Select an agent.

Date	Type	Description	Reference	Debit	Credit	Balance
Select an agent to view the ledger.

ADMIN MASTER DATA

Agent Transport Master

Maintain kilogram ranges, map each Route to its Agent, identify Factory Lines, and choose Range Based, Special Rate or No Incentive.

Admin

Range Values

From kg	To kg	Rate / kg

Route & Agent Master

Combined route kilograms:

Select the same Agent for all routes belonging to that agent. Their kilograms are added only to select the range rate; each Route keeps its own kilograms. Mark a Route as Factory Line when the factory runs the line; Factory Incentive is then always 0.00.

Route	Agent	Line Type	Rule	Special Rate

Agent Account Master

Set the monthly savings cut rate per kilogram for each Agent. Savings are deducted automatically from the Agent account for every saved transport month.

Agent	Savings Rate / kg	Notes

Default range values in this version:

1–4,999 kg = Rs. 10.50/kg · 5,000–9,999 kg = Rs. 11.00/kg · 10,000–14,999 kg = Rs. 12.00/kg. Add or edit further ranges here. Routes marked Special use their own rate; routes marked No Incentive receive 0.00. Factory Lines always receive 0.00 Factory Incentive.

Current Balance
rounded stock yards 0.00 yd

Today Received
rounded stock yards 0.00 yd

Today Issued 0.00 yd

Vehicles Inside 0

Attention Needed

No pending vehicles.

Today Activity

Daily Production Data

Today Green Leaf
selected factory 0.00 kg

No green leaf records.

New Firewood Vehicle Entry

Vehicles in Process

Issue Firewood for Usage

Stock Ledger

Date	Type	Reference	Stock In	Out	Actual / Payment	Rate	Amount	Balance

Reports

Green Leaf Daily Entry

Inputting user: -

Enter green leaf once per factory for the linked green leaf date and manufacturing date. Saving again updates the same daily record.

Withered Leaf Forecast

Roller Charge: 300.00 kg

Withered %	Forecast Withered kg	Roller Charge kg	Optimum Rollers	Average kg / Roller

Recent Green Leaf Entries

Factory	Green Leaf Date	Manufacturing Date	Green Leaf kg	Remarks	Entered By

Withered Leaf Batch Entry

Enter withered leaf batch-wise. Production will take the daily total of all batches for the manufacturing date.

Withering Batches

Factory	Manufacturing Date	Batch	Trough	Withered kg	First Roller Time

Daily Fired Tea / Production Outturn

Only one fired-tea entry per factory per manufacturing date. Dhool 1, Dhool 2 and Big Bulk are entered separately.

Recent Production

Factory	Green Leaf Date	Manufacturing Date	Fired Tea kg	Made Tea kg	Net OT	Made Tea / Hour

Dryer Time / Made Tea Per Hour

Enter dryer starting and finishing time for the selected manufacturing date. The system calculates dryer output as made tea kg per hour.

Tea Stock

Balance: 0.00 kg

Factory Grade / Type Filter

Dispatch Tea

Return Tea

Physical Stock Taking

Tea Stock Ledger

Date	Factory	Type	Grade	Reference	In kg	Out kg	Balance

Manufacturing Summary

Daily manufacturing summary for the selected factory/date.

Factory Manufacturing Date

Firewood Cost

This reads existing firewood issue records. It does not change firewood intake, issue, vehicle, or ledger data. Select one manufacturing date to see daily and month-to-date firewood cost per made tea kg.

Factory Date

Manufacturing Master Data

Admin only. Existing Green Lanka login users are kept. Assign tea factory access here.

Factories

User Factory Access

Daily Ledger

Monthly and financial-year summaries, made-tea balance, refuse-tea balance and the selected-month ledger.

Financial year: April 1 – March 31

Factory Financial Year Summary Month

Dispatch kilograms are now read directly from completed Tea Dispatch records. Production is entered from the Production category. Dispatch kilograms continue to come automatically from completed Tea Dispatch records; Stock → Entry is used for Return Tea, Local Sale, Gratis, refuse outgoings and permitted adjustments.

Selected Month Summary

Month-to-date figures for the selected month. Verification and locking are performed here for the whole month.

Pending verification

A locked month cannot be changed until an administrator unlocks it.

Financial Year Summary

Separate to-date totals for the selected financial year.

Opening Stock

Admin only

Daily Stock Ledger — Selected Month

Only the selected month is shown below. Financial-year calculations and summaries still carry balances forward in date order.

Date	Opening Made	Green Leaf	Fired Tea	Made Tea	Return Tea	Refuse Tea	Out-turn %	Dispatch	Local Sale	Gratis	Made Outgoing	Closing Made	Opening Refuse	Refuse Out	Closing Refuse	Actions

Factory Balance Report

Financial-year production, outgoing stock, expected balance and stock-taking variance.

Expected Closing Stock Trend

daily ledger balance

Green Leaf vs Made Tea

daily kilograms

Adjusted Monthly Out-turn

after applied stock-taking adjustments

Outgoing Stock

dispatch, local sale and gratis

Stock-taking Excess / Loss

physical stock against ledger on final green leaf date

Applied stock-taking rows are frozen at the Expected Stock, Physical Stock and Excess/Loss values saved when the adjustment was added. Later ledger activity will not recalculate historical applied sessions.

Physical Stock Date	Final Green Leaf Date	Session	Expected Stock kg	Physical Stock kg	Excess / Loss kg	Variance %	Verification	Admin Action

FACTORY PRODUCTION

Daily Production Entry

Enter the physical production figures once. Fired Tea, Withered Leaf %, out-turn and firewood cost are calculated automatically.

Keyboard: press Enter to move to the next production entry field; Enter on Firewood for Firing saves the entry.

Fired Tea = 1st Dhools + 2nd Dhools + Big Bulk

Factory

Recent Production Entries

Firewood cost uses the current weighted average firewood intake rate available to the app.

Date	Green Leaf	Withered	Withered %	1st Dhools	2nd Dhools	Big Bulk	Fired Tea	Made Tea	Refuse	FW Withering	FW Firing	FW Total	FW Cost	Action

Entry

Enter returned tea and stock outgoings. Daily Production has moved to the separate Production category. Dispatch kilograms are read automatically from Tea Dispatch.

Stock data entry

Factory Financial Year

Production is entered only from the Production category. Dispatch is automatic from completed Tea Dispatch records; Local Sale and Gratis remain separate Stock entries.

Return Tea Entry

Returned tea is added back to the expected made-tea balance.

Stock in

Outgoing Entry

Dispatch is read directly from Tea Dispatch. Enter only the additional Stock outgoings shown below.

Direct Dispatch source

FACTORY STOCK CONTROL

Stock Balancing

Maintain Fertilizer in bags, Tea Packets in packets, Diesel in liters and Paper Sacks in sacks. Every movement is factory-wise.

Factory

Stock Movement

Use this for opening stock, receipts, issues and corrections for the four stock categories.

Pump Diesel for Vehicle

This entry automatically deducts the pumped liters from Diesel stock.

3 photos required

Stock Movement History

Running stock movements for the selected factory.

Date	Stock Item	Movement	Quantity	Reference	Remarks	Source	Action

Diesel Pumping History

Vehicle, odometer and three-photo evidence for every diesel issue.

Date / Time	Vehicle	Odometer	Liters	Vehicle Photo	Odometer Photo	Pump Photo	Remarks

Stock Taking Dashboard

Latest Stock Taking Sessions

Date	Factory	Session No	Final Stock kg	Stock Value

Stock Taking Session

Create or select a stock-taking session. All data is stored factory-wise. Non-admin users can only use their assigned factory.

Open Existing Session

Grade Entry

Current Session Summary

Grade	Mark	Gross kg	Box Deduction kg	Net Tea kg	Refuse kg	Final Stock kg	Valuation	Value	Action

STOCK TAKING MANAGEMENT SUMMARY

Stock Summary

Last stock-taking position, financial-year main figures and month-wise stock movement with the adjusted out-turn after actual stock adjustment.

Factory Financial Year

Last Stock Taking - Main Stats

Latest physical stock-taking session in the selected financial year. Applied sessions use the frozen reconciliation values saved when the adjustment was added.

Financial Year Main Stats

Main made-tea stock and adjusted production position for the selected financial year.

Month-wise Stock Summary + Monthly Out-turn After Actual Stock Adjustment

The stock-taking excess/loss is shown when it was applied. For adjusted out-turn, that variance is allocated across the production period by each month’s green-leaf share.

Month	Starting Balance kg	Green Leaf kg	Recorded Made Tea kg	Stock Taking Excess / Loss kg	Allocated Adj. for Out-turn kg	Adjusted Made Tea kg	Adjusted Out-turn %	Dispatch kg	Local Sale kg	Gratis kg	Final Balance kg

Stock-taking Reconciliation History

Physical stock compared with expected stock. Applied historical sessions remain frozen.

Physical Stock Date	Final Green Leaf Date	Session	Expected Stock kg	Physical Stock kg	Excess / Loss kg	Variance %	Verification	Adjustment

Stock Taking Reports

Simple A4 reports with larger figures and grade comparisons. Photo report uses compressed images to keep the PDF smaller.

Factory Session From To

Compare Grade 1 Compare Grade 2

Final Stock by Grade

kg composition

Session Stock Trend

final stock over time

Deduction Impact

refuse kg by rate

Stock Value by Grade

valuation comparison

Box Type Usage

number of boxes recorded

Selling Mark Percentage

share of final stock

Average Price Contribution

grade contribution to weighted average

Grade Summary

Grade	Entries	Gross kg	Net kg	Refuse kg	Final Stock kg	Share %	Average Value/kg	Stock Value

Grade-to-Grade Comparison

Measure	Grade 1	Grade 2	Difference

Selling Mark Percentage Report

Selling Mark	Entries	Final Stock kg	Stock Share %	Stock Value	Value Share %	Average Price/kg

Grade Contribution to Average Stock Price

Grade	Final Stock kg	Weight Share %	Grade Average Price	Contribution to Overall Average	Contribution %

Session Comparison

Date	Factory	Session	Grades	Gross kg	Final Stock kg	Refuse Tea Deduction %	Stock Value

Grade Photo Evidence

Photo Compliance Report

Grade	Total Entries	With Photo	Missing Photo	Compliance %

Detailed Stock Report

Date	Factory	Session	Grade	Mark	Photo	Deduction %	Gross kg	Box Deduction kg	Net Tea kg	Refuse kg	Final Stock kg	Value

Stock Taking Master Data

Admin only

Factory for marks

Factory Marks

Select a factory or use Edit below to change its main and second selling marks.

Grades

Deductions

Factory Box Types

Only the box types saved for the selected factory will appear in its calculator.

Leaf Quality Dashboard

Latest Bad Leaf Records

Date/Time	Factory	Customer	Reason	Photo	Action

Bad Leaf Customer Entry

Type the supplier/customer Reg No. The customer name will appear automatically. Then select the poor-quality reason and add photo proof.

Leaf Quality Reports

Factory From To Route Bad Leaf Type

Routes with most bad leaf

Route	Records	Customers

Bad leaf type summary

Type	Records	Customers

Customers with repetitive bad leaf

Customer	Route	Records	Most Common Type	Last Record

Detailed Records

Date/Time	Factory	Reg No	Customer	Route	Reason	Severity	Remarks	Photo	Action

Route Leaf CSV Generator

Generate and save one complete calendar month for Gomadiya, Pattigala and Horagala. Export any required date range later without changing the saved month.

Not saved

Monthly rules: Customer monthly Net Kilos cannot exceed the selected cap (default 140 kg). The same customer must have at least 6 calendar days between supply dates. Excluded receiving days never receive generated rows.
Output columns: Customer No · Date · Bags · Gross Weight · Bag Weight · Water Deduction · Course Leaf Deduction · Net Weight · Normal Flag (1).

Generation Month *The complete month is generated and saved as one locked dataset. Maximum Net kg / Customer / Month *Default limit: 140 kg. Gomadiya Full-Month Target Net kgCustomers 10500–10599 Pattigala Full-Month Target Net kgCustomers 11000–11099 Horagala Full-Month Target Net kgCustomers 7600–7689

Exclude Receiving Days for the Month

0 excluded

Tick any date that must not contain a supply. The generated month will remain fixed after Save & Lock.

Export Saved / Generated Data

This range only filters the CSV export. It does not regenerate or alter the full-month data.

Separate export range

Export From * Export To * Preview Route

No CSV generated or loaded yet.

Customer No	Date	Bags	Gross Weight	Bag Weight	Water Deduction	Course Leaf Deduction	Net Weight	Normal
Generate or load a month to preview its CSV rows.

Leaf Quality Master Data

Customers: Admin/Office Clerk · Reasons: Admin

Factory

Customer List

Bulk customer import

Upload PDF/CSV/TXT containing Reg No, Name, Telephone No and Route. The first column must be Reg No.

Reg No	Name	Telephone	Route
No import preview yet.

Poor Quality Reasons

Tea Sale Proceeds Dashboard

Track net tea proceeds and VAT receipts separately. Over-advances and proceeds credits are automatically carried to the next Seller’s Contract for the same factory.

Outstanding settlements

Prompt date	Factory / Mark	Contract	Prompt-date balance	Current proceeds balance / credit status	Non-BG VAT	BG VAT	Status

Seller Tax Invoices

Upload Public Auction or Private Sale tax invoices issued by the factory to tea buyers. Select the sale type first so matching is restricted to the correct Seller’s Contracts.

FactoryDefaults to the factory selected at the top. Sale TypeSelect before choosing the PDF. Seller tax-invoice PDF

Invoice extraction and contract matching

Select a seller tax-invoice PDF.

Review the buyer, contract, lot, quantity, price, taxable value and VAT before saving. Change the matched Seller’s Contract from the dropdown when needed.

Save	Page / Format	Tax Invoice	Buyer	Seller Contract Match	Lots	Taxable Value	VAT	Total	Status / Notes

Saved Seller Tax Invoices

Showing only the factory selected at the top. Original PDFs remain available by page number.

Date	Factory	Tax Invoice	Sale Type	Buyer / TIN	Seller Contract	Lots	Taxable Value	VAT	Total	Match Status	PDF	Actions

Quarterly IRD VAT Schedules — 01, 02 and 04

Prepare Schedule 01 from Seller Tax Invoices plus Local Sales, Manure Sales, Refuse Tea, Coir Bags and other taxable output invoices. Schedule 02 and Schedule 04 follow the supplied IRD XLSM templates. CSV dates are written as quoted MM/DD/YYYY text. Serial and money columns are written as unquoted whole-number values with no decimal point.

Factory Factory TINUsed in the IRD export filename. Year Quarter Schedule type Version Submission date

Select a factory, year and quarter. Every CSV date is exported as MM/DD/YYYY with leading zeros. Version 6.21 keeps IRD money columns as raw integers and fixes VAT Summary grouping. All XLSM fields are mandatory; invoice numbers cannot contain spaces; TINs must contain exactly 9 digits.

CSV format: Dates are exported as MM/DD/YYYY with leading zeros. Monetary columns are exported as raw integers without .00 or any decimal point. Do not open and re-save the IRD upload CSV in Excel because Excel can visually reformat dates.
Schedule 01 coverage: Tea buyer invoices and all saved Other VAT Output invoices are included. Do not upload a Colombo Tea Auction invoice again when the broker's RAMIS Web API transmission already succeeded.

IRD Schedule 01 — Output Tax Invoices

#	Invoice Date	Tax Invoice No.	Supplier / TIN	Purchaser / TIN	Source / Contract	Description	Taxable Value	VAT	Total	IRD Validation
Select a factory, year and quarter, then search.

IRD Schedule 02 — Purchase / Input Tax Invoices

#	Invoice Date	Tax Invoice No.	Supplier TIN	Supplier Name	Description	Value of Purchase	VAT	Disallowed VAT	Allowable VAT	IRD Validation
Select a factory, year and quarter, then search.

IRD Schedule 04 — Tax Credit / Debit Notes

#	TIN No.	Invoice Date	Invoice No.	Credit / Debit	Note Date	Note No.	Value	VAT	Issued By Me	IRD Validation
Select a factory, year and quarter, then search.

Bank Receipts

Record proceeds and VAT deposits into their respective bank accounts. Partial receipts are supported.

Receipt history

Use Edit to correct a saved receipt. Financial balances and carried credit are recalculated after saving.

Date	Contract	Type	Purpose	Bank account	Amount	Reference	Remark	Entered by	Actions

Allocate advances received before sale

Link all or part of a pre-sale advance to the relevant Seller’s Contract. The original received date is used when calculating the balance before prompt date. Any excess automatically carries to the next contract of the same factory.

Advance date	Factory	Advance / Unallocated	Allocated contract	Allocation date	Allocated amount	Remark	Actions

Bank Account Master

Create separate receiving bank accounts for each factory. Bank Receipts will show only the accounts belonging to the selected factory.

Saved bank accounts

Factory	Bank	Account name	Last 4	Type	Status	Actions

Proceeds Adjustments

Record manual adjustments after the Seller’s Contract, including advance interest and other additions or deductions. Interest is entered as a manual amount for now.

Saved adjustments

Date	Contract	Factory / Mark	Category	Type	Amount	Remark	Actions

Tea Sale Reports & Statements

Open only the report you need. Weekly and monthly sales reports, bank statements and accounts statements are kept in separate workspaces.

Weekly / Monthly Tea Sale Report

Weekly reports use the sale date. Monthly reports use the Report Month saved with each Seller’s Contract.

Report period Select a date in the week Factory

Select the period and click Search Sales Report.

Contract details

Sale / Prompt	Factory / Mark	Contract	Sold kilos	Average	Gross proceeds	Withdrawn lots / kg	Broker deductions	Advances before prompt	Credit carried in by prompt	Prompt adjustments	Prompt balance	Current credit carried in	Current balance / credit movement

Bank Statement Import & Credit Reconciliation

Upload a bank transaction CSV. Credit rows are matched to entered Tea Proceeds or Advance Payments using factory, bank account, exact amount, date and reference. Confirm the link and destination before saving. Duplicate imports are blocked.

Factory Bank account Bank transaction CSV Import supporting documentOptional. Applied to all selected rows in this import.

No CSV preview loaded.

Use	Date	Description	Debit	Credit	Classification	Accounting Destination	Link to Entered Proceeds / Advance	Payee	Cheque No.	Cheque Date	Cleared Date	Status	Notes
No CSV preview loaded.

Add / Edit Bank Debit

Use this form for manual entries or to complete cheque, payee, clearing and supporting-document details after a CSV import.

Saved Bank Transactions

Change a transaction destination directly in the table. For a bank credit, select the entered proceeds or advance payment and press Save Route. Linked credits are not counted twice in the Bank Account Statement.

Date	Description	Classification	Destination	Linked Proceeds / Advance	Payee	Cheque / Status	Cheque Date	Cleared Date	Reference	Debit	Credit	Document	Actions

Bank Account Statement

Produce a dated statement combining receipts and classified bank debits for one factory bank account.

Factory Bank account From date To date

Select a factory, bank account and date range.

This internal statement combines recorded receipts and classified bank debits. Review Later and Suspense items remain visible until resolved.

Accounts Statement

Create a dated factory ledger with Seller’s Contract proceeds, VAT, deduction categories, adjustments, advances and bank receipts.

Factory Account From date To date

Select a factory, account and date range.

Positive balance represents money receivable. A negative balance represents advance or credit available.

VAT CONTROL CENTRE

VAT Management

Manage VAT separately from Tea Sale Proceeds. Work through Output VAT, Input VAT / Purchase Bills, credit and debit notes, payments, then prepare the monthly VAT working paper and IRD schedules.

Working factorySelected factoryChange the factory from the selector at the top.

1Output VAT

2Input VAT

3Adjustments

4Payments

5Summary

Monthly VAT Working Paper

Select the factory and VAT month, then search. Use VAT Summary PDF for a one-page management summary. Use Detailed VAT PDF for transaction schedules, reconciliation, Purchase Bills, Seller Tax Invoices and Tax Credit/Debit Notes with larger fonts.

Prepared Checked Approved

Factory VAT month

Select a factory and month. Auction Sale VAT uses the Seller Contract sale date.

VAT Output – Gross, Credit Notes and Net

Category	Sale with VAT	VAT 18%	Sale without VAT

VAT Input – Gross, Credit Notes and Net

Category	Total amount	Input VAT	Taxable value

Tax Credit Notes Applied in This VAT Period

Purchase Credit Notes reduce VAT Input. Sales Credit Notes reduce VAT Output. They are shown separately and are never hidden inside the sales or purchase totals.

Date	Type	Supplier / Customer	Credit Note	Taxable Value	VAT	Total

VAT Summary Details — Selected Factory & Month Only

Date	Input / Output	Category	Description	Reference	Value	VAT	Total

Other VAT Output

Enter Local Sales, Manure Sales, Refuse Tea, Coir Bags and other taxable sales. Hover a field for guidance.

Saved VAT Output

Select one factory and VAT month, then press Search. Records from other factories are not shown in this register.

Factory VAT month

Saved VAT Output is not loaded.Select a factory and month, then press Search.

Date	Factory	Category	Customer / TIN / Invoice	Value	VAT	Total	Document	Actions
Select a factory and month, then press Search.

Purchase Bills & Broker Tax Invoices – VAT Input

Compact entry layout. Hover any field for guidance. Uploading a clear bill can fill most fields automatically.

1. Bill source

1Bill Type 3Purchase bill file

Automatic reading

No bill read yet.
Select a bill photo or PDF. Reading starts automatically.

2. Bill details

4Factory 5Bill date 6Effective VAT month 7Purchase Bill Supplier Choose existing supplier Supplier VAT number 8Invoice numberInvoice number is required and will be checked for duplicates.

3. VAT amounts

Taxable value VAT amount Disallowed VAT amount Total amount

4. Description

Description

Saved Purchase Bills

Select one factory and effective VAT month, then press Search. Bills are not downloaded until you search.

Factory VAT month

Saved Purchase Bills are not loaded.Select a factory and month, then press Search.

Bill Date	Effective Month	Type	Broker	Factory	Supplier	Invoice	Value	Invoice VAT	Disallowed VAT	Allowable VAT	Total	Bill	Actions
Select a factory and month, then press Search.

Tax Credit / Debit Notes

Credit notes reduce VAT Input or Output. Debit notes increase VAT Input or Output. These records form IRD Schedule 04.

Saved Tax Credit / Debit Notes

Use the filters to find Purchase or Sales notes already entered.

Factory Effective month Credit note type

Date	Effective Month	Factory	Type	Supplier / Customer	Note No.	Original Invoice	Issued By Me	Value	VAT	Total	Document	Actions

Record VAT Payment

Record VAT payments against one VAT period only. Previous-month payable or credit balances are not brought forward. A payment made later still belongs only to the VAT period selected here.

Month-only VAT rule: the selected VAT period starts from zero. Previous payable or credit balances are not brought forward into this month.

VAT Payment History

All payments already recorded are shown here. Filter by factory or VAT period.

Factory VAT period

Payment Date	Factory	VAT Period	Description	Reference / Bank	Amount	Actions

Master Data

Firewood master data is factory-wise. Green Lanka existing master records remain under Green Lanka. Select the factory at the top before adding suppliers, owners, vehicles, or pricing.

Supplier / Customer List

Owner List

Vehicle List

Pricing List

GREEN LANKA CENTRAL STORES

Main Stock, Ordering & VAT Distribution

Bulk purchases are received into Green Lanka main stock. Items issued to group factories are posted through VAT invoices and deducted from stock automatically.

Low Stock / Reorder Items

Code	Item	Unit	Balance	Reorder Level

Pending Purchase Activity

Items, Suppliers & Factory Accounts

Maintain the stock catalogue and parties used for purchase orders, goods receipts and VAT invoices.

Item Master

Supplier Master

Group Factory VAT Account

Items

Code	Item	Category	Unit	Balance	Reorder	Sell Price	Action

Suppliers

Name	VAT No.	Phone	Action

Factory Accounts

Factory	VAT No.	Contact	Action

Purchase Requisitions

Request items before supplier ordering. Admin can approve submitted requisitions.

ItemQuantityEstimated Unit CostLine Note

Item	Qty	Estimated Cost	Note

Saved Requisitions

No.	Date	Required	Department	Status	Items	Action

Purchase Orders & Supplier Ordering

Create a PO directly or load an approved requisition. The PO can be printed and sent to the supplier.

ItemQuantityUnit PriceVAT %

Item	Qty	Unit Price	Taxable	VAT	Total

Purchase Orders

PO	Date	Supplier	Expected	Status	Total	Action

Goods Receipt & Bulk Stock Intake

Receive supplier deliveries against a purchase order. Posting the GRN increases Green Lanka main stock and can add the supplier invoice to VAT Input.

Item	Ordered	Already Received	Receive Now	Unit Cost	VAT %

Goods Receipts

Admin can delete a GRN when sufficient stock remains. Deletion reverses stock, PO received quantities and the linked VAT Purchase Bill.

GRN	Date	PO	Supplier Invoice	Status	Total	Actions

VAT Invoice — Stock Sale to Group Factory

Green Lanka sells or issues stock to another factory under VAT. Posting the invoice deducts stock and adds the output to the VAT working paper.

Stock ItemAvailableQuantityUnit PriceVAT %

Item	Available	Qty	Unit Price	Taxable	VAT	Total

Saved VAT Invoices

Invoice	Date	Factory	VAT No.	Status	Taxable	VAT	Total	Action

Central Stores Stock Ledger

Green Lanka is the main stock location. All posted goods receipts and VAT invoices appear here.

ItemFromTo

Current Stock Balance

Code	Item	Category	Unit	Received	Issued	Balance	Stock Value

Stock Movements

Date	Item	Type	Reference	Counterparty	In	Out	Unit Cost

Settings

Database Connection

The Supabase connection is fixed by the administrator in supabase-config.js.

MADE TEA MOVEMENT CONTROL

Sales Control Centre

Manage acknowledgements, valuations, seller contracts, returns, reports and auction follow-up after operational dispatch preparation.

Open Invoices0

Ready Dispatches0

Items Awaiting Weight0

Dispatched Net Weight0.000 kg

Sales Subcategory Summary

Open any section directly. Counts use the currently selected factory.

Recent Dispatch Activity

Live status from invoice creation through final weighing.

Dispatch	Sale	Date	Broker	Lorry	Driver	Invoices	Bags	Weight	Status

AUCTION CALENDAR CONTROL

Sale Arrangements

Create the official sale number and calendar once, then assign every dispatch to the correct sale.

Financial year not selected

Create / Edit Sale Arrangement

The current factory financial year is applied automatically. The complete official auction calendar can be stored, including buyer and seller prompt dates, levy dates, VAT dates and TIN collection dates.

Official Sale Calendar

The v6.39.33 migration loads official CTTA Sales 01–13 for Q1 2026 under FY 2025/2026 and Sales 14–24 for Q2 2026 under FY 2026/2027. The earlier Q3 migration provides Sales 25–38. NIL dates stay blank, while the Sale 13 10% payment is retained as NA.

Create Tea Invoice

Invoice numbers are unique within the factory financial year.

Financial year not selected

Financial Year AUTOApplied automatically from the selected invoice / current factory financial year. FactoryChoose the factory only when required; it is not part of the Enter-key entry sequence.

Fast EntryPress Enter to move to the next field.

1Selling Mark 2Invoice Number 3Grade 4Number of Packs 5Sack Type 6Net Tea Weight / Pack (kg)

7Manufacture Date 8Factory Valuation (Rs./kg) 9Moisture Level (%) 10Sale Type Sample Weight (kg) AUTO

Entry order: Selling Mark → Invoice Number → Grade → Packs → Sack → Net Weight → Manufacture Date → Valuation → Moisture → Sale Type → Save. Sample weight is calculated automatically from the grade.

Packed Tea 0.000 kgSample Added + 0.000 kgTotal Expected Net Tea 0.000 kg

Saved Invoices

Filter saved invoices by financial year, then choose invoice-number order independently. Private invoices remain labelled PRIVATE and stay in the separate Private Sales workflow.

Financial YearInvoice Number OrderSale Type

Invoice	Sale Type	Effective Financial Year	Selling Mark	Grade	Packs	Sack	Net / Pack	Sample	Expected Net	Mfg Date	Valuation	Moisture	Status

SEPARATE NON-AUCTION WORKFLOW

Private Sales

Register private-sale invoices separately from the public auction workflow. Private Seller Contracts can now be uploaded here and feed Tea Sale Proceeds, VAT Output, deductions, outstanding balances and invoice history without entering acknowledgements, broker valuations, catalogue attempts, Sale +3, unsold, shutout or violation processing.

PRIVATE ONLY

Upload Private Seller Contract

Upload the broker Private Seller Contract once. The app extracts contract, invoice, buyer, VAT, price, proceeds, deductions and prompt date, then opens the review screen before anything is saved.

PDF → REVIEW → SAVE

Private Seller Contract PDF

VAT treatment
Buyer VAT from the private sale is included in VAT Output after the contract is confirmed. Broker VAT charged on deductions is stored as a broker deduction; claimable Input VAT still comes from the broker Tax Invoice because the Seller Contract itself is not a Tax Invoice.

Private Sales0

Total Packages0

Total Sale Weight0.000 kg

Total Sale ValueRs. 0.00

Average PriceRs. 0.00

Create / Edit Private Sale

First mark the tea invoice as Private Sale in Invoicing, then select it here. Invoice details are loaded automatically. Private Sale sample weight is manual and may be 0.000 when no sample is dispatched.

Private Sale Register

Private Seller Contract imports are linked here automatically when the matching invoice is marked Private Sale. Manual Private Sale entry remains available.

Month

Date	Invoice	Reference	Buyer	Mark / Grade	Packages	Net + Sample	Sale Weight	Price / kg	Total Value	Document	Remarks	Actions
No private sales saved.

Import Previous Dispatch PDFs

Upload one or more Tea Estate Invoice PDFs. Files for the same factory, date, broker, lorry and driver are combined into one completed historical dispatch.

Admin only

Sale ArrangementPrevious Dispatch PDFs

No PDF preview loaded.

PDF	Selling Mark	Invoice	M/F Date	Grade	Packs	Net / Pack	Sample	PDF Total Net	Moisture
No previous dispatch PDF preview.

Missing selling marks, grades, pack options, sack types, brokers, lorries and drivers are created automatically. Existing invoice numbers in the current financial year are skipped.

Create / Edit Dispatch

Assign one or more prepared invoices to the lorry, driver and broker. Administrators can edit or permanently delete incorrect open and completed dispatches. A deletion reason and full audit snapshot are retained.

Dispatch Register

Active assignments are shown by default. Completed dispatches are available from monthly history. Actions are arranged in dispatch workflow order.

ACTIVE DISPATCHES Open / loading assignments only

Dispatched history month

Removed Invoice History

Audit trail for invoices removed from Dispatch Assignment, including removals by another authorized user when a vehicle had no remaining space.

AUDITED

Removed	Dispatch	Invoice	Reason	Removed By	Saved Weights	Type
Loading removal history…

Previous Unsold Carry-Forward Items

Seller Contract-confirmed unsold lots are brought to Dispatch Assignment at Sale +3 and are automatically included when reading the acknowledgement.

Invoice / Mark	Source Sale	Acknowledgement Sale	Sample	Expected Qty	Status

BROKER CATALOGUE RECEIPT

Acknowledgements

Upload the broker acknowledgement and tally every invoice against the combined Dispatch Assignment: completed physical dispatches plus previous-unsold Sale +3 carry-forward invoices.

PDF linked to dispatches

Upload & Link Acknowledgement

The system reads the sale, lot and invoice details, refreshes previous-unsold carry-forward items, and matches the PDF against physical dispatches plus Sale +3 unsold invoices.

No acknowledgement PDF preview loaded.

Administrator Correction

Review and correct details extracted from the acknowledgement PDF before saving. Changes are rechecked against Dispatch Assignment.

ADMIN ONLY

Acknowledgement Sale No. Catalogue Sale Date Printed Date / Time

Detected Selling Marks Correction Note (required only when values are changed)

#	Lot	Invoice	Grade	Packs	Weight / Pack	Net kg	Rechecked Status

No administrator corrections applied.

Dispatches / Previous Unsold Carry-Forward Items Covered

Read a PDF to match dispatches.

Saved Acknowledgements

One acknowledgement can cover several dispatches and selling marks under the same sale. Use Report to print or save the full acknowledgement reconciliation.

Sale	Catalogue Sale Date	PDF	Marks	Invoices / Lots	Linked Dispatches / Carry-Forward	Broker Valuation	Actions

Administrator — Correct Acknowledgement Mismatch

Choose the correct Dispatch Assignment for each mismatched acknowledgement row. The saved PDF is retained and every administrator correction is audited.

ADMIN ONLY

Acknowledgement Invoice / Lot	Grade / Packs	Ack kg	Current Status	Correct Dispatch Assignment

Administrator Correction Reason

INDEPENDENT SOURCE DOCUMENT

Broker Valuations

Upload the Broker Valuation whenever it arrives. An Acknowledgement is optional. The document is filed under its factory and sale first; Document Chain then compares it with any Acknowledgement and Seller Contract already available.

Independent upload

Upload Broker Valuation

Select the factory and sale to file the document. If an Acknowledgement already exists you may select it, but a difference never blocks saving; it becomes a Document Chain exception for review.

No broker valuation PDF preview loaded.

Saved Broker Valuations

Valuations are retained as independent source documents. Acknowledgement linkage is optional and may be attached later. Use Document Chain to review field-level differences.

Sale	Acknowledgement	Printed Date	PDF	Marks	Invoices	Projected Proceeds	Dispatches	Actions

STRUCTURED BROKER VALUATION SOURCE TABLE

Extracted Valuation Lots

Every saved Broker Valuation lot is shown as a separate source row. Financial year comes from the matched invoice created in Invoicing, and repeated reprint attempts remain separate.

Factory Financial year Sale Search

Extracted Lots0

Total Kilos0.00

Projected Proceeds0.00

Invoice Matches0

Unsold Reprints0

Broker Valuation Lot Source Register

The header row and Invoice column remain frozen. Linkage Status reads valuation evidence directly from this source register.

0 rows

Invoice	Source Status	Lot	Grade	Net kg	Packages	Valuation	Projected Proceeds	Dry Leaf Description	Sale	Sale Date	Selling Mark	Factory	Acknowledgement	Valuation PDF	Linkage
Open this tab to load extracted Broker Valuation lots.

INDEPENDENT SALE OUTCOME DOCUMENT

Seller Contracts

Upload a Public Auction Seller Contract as soon as it is received, even when the Acknowledgement or Broker Valuation has not arrived. The contract is immediately available for Tea Sale Proceeds, VAT, deductions and settlements; Document Chain reconciles later documents when they appear.

Upload anytime

Upload / Edit Seller Contract

Upload the broker PDF, choose Public Auction or Private Sale, verify every extracted row and save only after review.

Contract Sale Type Factory Selling mark Broker Contract number Sale date Report monthDefaults to the sale month. Change only when this contract must appear in a different monthly report. Prompt date Seller VAT number Gross proceeds Total broker deductions Net proceeds expected Non-BG VAT expected BG VAT expected

Broker deduction categories

These are extracted from the Seller’s Contract and can be corrected before saving.

Deduction category	Amount

Seller contract PDFPrivate BPML Seller Contracts are recognised automatically. Always review extracted values before saving.

Lot details

Sold, not-sold and withdrawn lots are stored separately. Only SOLD lots contribute to proceeds, VAT, kilos and averages.

Buyer	Buyer VAT	Lot	Invoice	FY	Grade	Bags	Gross kg	Sample	Net kg	Price/kg	Proceeds	VAT 18%	Total + VAT	Bank guarantee	Status

Saved contracts

Showing only the factory selected at the top.

Sale / Prompt / Report month	Factory / Mark	Contract	Lots	Gross proceeds	Contract net	Adjusted net	Current outstanding / credit status	Non-BG VAT	BG VAT	Seller Tax Invoices	PDF	Actions

STRUCTURED SELLER CONTRACT SOURCE TABLE

Extracted Contract Lots

Every saved Seller Contract lot is listed as a separate source row. Financial year comes from the matched Tea Dispatch invoice, and repeated Unsold/Sold attempts remain separate.

Factory Financial year Sale Status Search

Extracted Lots0

Total Kilos0.00

Total Proceeds0.00

Invoice Matches0

Seller Contract Lot Source Register

The first row and Invoice column remain frozen while scrolling. Financial year is read from the invoice created in Invoicing. Repeated invoice numbers remain as separate sale attempts.

0 rows

Invoice	Lot	Grade	Net kg	Buyer	Price / kg	Proceeds	VAT	Total + VAT	Status	Bags	Gross kg	Sample	Contract	Sale	Sale Date	Selling Mark	Factory	Linkage
Open this tab to load extracted Seller Contract lots.

DOCUMENT CHAIN & LATE RECONCILIATION

Invoice Document Chain

Documents are saved independently. The chain compares only fields shared by the relevant stages and creates review exceptions instead of blocking uploads or silently changing source data.

Sale Chains0

Complete0

Incomplete0

Review Required0

Resolved Exceptions0

Open Differences0

Document Chain Register

A missing document is INCOMPLETE, not invalid. A field difference is REVIEW REQUIRED. Resolutions never rewrite the original PDF extraction.

0 chains

Invoice / Sale	FY / Mark / Grade	Dispatch	Acknowledgement	Broker Valuation	Seller Contract	Overall	Differences	Action
Open this tab to load the document chain.

Document Chain Exceptions

Shows exact field values from each source document. Only administrators can resolve or reopen an exception.

0 exceptions

Invoice / Sale	Link	Field	Source A	Source B	Status	Resolution	Action
No chain exceptions.

INVOICE-LEVEL AUCTION HISTORY

Invoice Catalogue Attempts

Track partial acknowledgements, Shutout/Violated transfers, valuation and Seller Contract links, Unsold Sale +3 recataloguing and Withdrawn decisions.

Invoice	Dispatch	Attempt / Sale	Source	Mark / Grade	Previous Qty	Sample	Expected Qty	Ack Qty	Lot	Status / Outcome	Links	Action
Run the v6.39.17 SQL migration and refresh.

MANUAL SALE TRANSFER QUEUE

Acknowledgement Holding Bin

Hold acknowledged Dispatch Assignment invoices safely and transfer them to any selected sale later. Quantity and sample history are retained.

Factory

Held Invoices0Held Quantity0.000 kg

Invoices Awaiting Manual Sale Transfer

Use Transfer to Sale when the required future sale is known, or Withdraw to end the catalogue workflow.

Invoice	Mark / Grade	Held From Sale	Previous Qty	Existing Sample	Remaining Qty	Reason	Action
No held invoices.

LIVE UNSOLD INVENTORY

Unsold Bin

Invoices enter this bin automatically when the latest Seller Contract result is Unsold. When a later Seller Contract records the invoice as Sold, it moves automatically to Sold from Unsold Bin.

Currently Unsold0

Current Unsold Quantity0.000 kg

Sold after Unsold0

Sold Quantity0.000 kg

Currently Unsold

The latest confirmed Seller Contract result is Unsold. Sale +3 recatalogue details are shown when available.

0 invoices

Invoice	FY	Selling Mark	Grade	Last Unsold Sale	Lot	Unsold Qty	Unsold Times	Next Sale	Next Catalogue Qty	Current Status
No unsold invoices.

Sold from Unsold Bin

Invoices that were Unsold one or more times and were later confirmed Sold automatically appear here.

0 invoices

Invoice	FY	Selling Mark	Grade	Unsold Sale History	Sold Sale	Sold Date	Lot	Sold Qty	Buyer	Price / kg	Contract
No invoices sold after being unsold.

WITHDRAWN TEA FACTORY RETURN CONTROL

Withdrawn Teas to Be Brought Back to the Factory

Withdrawn Seller Contract lots are excluded from catalogue matching and remain here until the full quantity is physically received back at the factory.

Pending Lots0

Pending Quantity0.000 kg

Received Quantity0.000 kg

Fully Returned0

Record Factory Receipt

Partial receipts are allowed. The balance remains pending until the complete withdrawn quantity is received.

Withdrawn Tea Return Register

Shows pending, partially returned and fully returned withdrawn teas separately from buyer rejected returns.

Invoice / Lot	Sale / Contract	Grade	Withdrawn Qty	Received	Balance	Status	Receipt Details	Action
No withdrawn teas.

NON-CATALOGUED TEA RETURN CONTROL

Broker Returns to the Factory

Invoices shown as Not Catalogued, Shutout, Violated or Pending Clarification can be physically returned from the broker. Partial receipts remain open until the complete broker-held quantity is received at the factory.

Pending Invoices0

Pending Quantity0.000 kg

Received Quantity0.000 kg

Fully Returned0

Record Broker Return Receipt

Select the exact non-catalogued sale attempt. Repeated invoice numbers remain separate by sale and attempt number.

Broker Return Register

Tracks each non-catalogued sale attempt independently and shows pending, partially returned and fully returned quantities.

Invoice / FY	Sale / Attempt	Mark / Grade	Reason	Return Due	Received	Balance	Status	Receipt Details	Action
No broker-return invoices.

SOLD TEA RETURN CONTROL

Buyer Rejected / Return Tea

Buyer rejection remains SOLD in the Seller Contract. Record rejection, To Be Returned, partial return and final return details separately.

Invoice / Lot	Sale / Contract	Buyer	Sold	Rejected	Returned	Balance	Status	Return Details	Action
No buyer rejections.

Bag & Sample Weighing

Choose a remaining bag or the sample. Saved items disappear from the dropdown while the dispatch, invoice and Sri Lanka date remain selected after synchronization.

DispatchInvoiceDispatch DateWeighing Date (Sri Lanka)Expected Items

Selected ItemSelect itemNet Tea0.000 kgSack Tare0.000 kgExpected Scale Weight0.000 kgMaximum Allowed0.000 kgInvoice Sample0.000 kg

Weighed Items 0 / 0Actual Scale Gross 0.000 kgExpected Scale Gross 0.000 kgGross Variance 0.000 kg

Recorded Bags & Sample

Item	Actual Scale	Expected	Difference	Check	Scale / Source	Sri Lanka Date / Time	Remark

LOCAL WEIGHING SCALE CONNECTION

Scale Settings & Local Bridge

Connect the digital scale attached to this computer. These settings stay on this browser and do not change another factory computer.

Bridge not tested

BridgeOffline

Serial PortNot selected

Latest Stable Weight—

Reading ModeManual

Browser Connection

The app talks only to the bridge address below. Use 127.0.0.1 when the scale is connected to this same computer.

Install and start the Local Scale Bridge, then press Test Bridge.

Serial Scale Configuration

These values are sent to the bridge and saved on this computer. Start with 9600 / 8 / None / 1 unless the scale manual states otherwise.

No serial configuration loaded.

Live Reading Test

Place a known test weight on the scale. A stable reading must be shown before production use.

—No readingRaw scale text will appear here.

Local Bridge Installation

On the Windows computer connected to the scale, open the included local_scale_bridge folder and run INSTALL_SCALE_BRIDGE.bat as Administrator. The bridge starts invisibly with Windows and listens on this computer only.

No Supabase SQL is required for this update. Connected readings continue to save the device ID, raw reading and reading source with each bag or sample weight.

INVOICE 1–1500 WORKFLOW MAP

Invoice Register

Select the factory and effective financial year to see every invoice number from 1 to 1500 in ascending order. Click any coloured invoice to open its complete movement from dispatch through catalogue and Seller Contract outcome.

Select period

Dispatched0

Catalogued0

Sold0

Unsold0

Private0

Unused1500

Invoice Numbers 1–1500

Only invoices and Seller Contract outcomes belonging to the selected financial year are loaded. Status priority is Sold → Unsold → Catalogued → Dispatched.

1500 invoices

Select a financial year and load the register.

Invoice Detail

Click an invoice number to view the full dispatch-to-sale history.

No invoice selected.

60 MM × 40 MM · 1-UP

Dispatch Invoice Labels

Select a Sale Number and print one browser label for every completed dispatch invoice in that sale. The refreshed design keeps each value next to its field name, underlines the Mark Name, and uses Monimer Serif when it is installed locally.

Select sale number

Sale Label Batch

Only completed Tea Dispatch records are included. Total Kilos is packed tea only: Bags × Net Weight per Bag. Dispatch sample weight is not added.

Factory Sale Number Labels Found

Label Preview

Each preview below represents one physical 60 mm × 40 mm label. Browser print opens one label per page.

0 selected

Select a sale number to load labels.

DISPATCH TO SALE TRACEABILITY

Tea Dispatch & Sold Reports

Review month-wise and sale-wise movement, detailed dispatches, Seller Contract outcomes and the live status of any invoice.

All records

Dispatches0

Invoices0

Total Dispatched Bags0

Total Sold Bags0

Dispatched Net0.000 kg

Sold Net0.000 kg

Sold Gross (Incl. Current Sample)0.000 kg

Sold Gross (Incl. All Sample History)0.000 kg

Net Sales Average-

Gross Sale Average (Current)-

Gross Sale Average (Incl. All Samples)-

Broker Tax Invoice Deductions (Incl. VAT)0.00

Unsold / Withdrawn0.000 kg

Pending Final Outcome0

Documents To Upload

One row per invoice and sale attempt. The register shows the next missing document in order: Dispatch Assignment → Acknowledgement → Broker Valuation → Seller Contract.

0 pending

Dispatch Assignment0Invoices not assigned to a dispatch

Acknowledgement0Dispatched / attempted invoices without acknowledgement evidence

Broker Valuation0Acknowledged invoices without valuation evidence

Seller Contract0Valued invoices without sold-status source rows

Invoice	FY	Sale / Attempt	Selling Mark	Grade	Dispatch Assignment	Acknowledgement	Broker Valuation	Seller Contract	Next Upload	Open
Search reports to calculate missing documents.

Invoice Current Status

Select an invoice above to see its complete movement from creation to final sale outcome.

No invoice selected.

Month-wise Summary

Dispatch and Seller Contract outcomes grouped by calendar month.

Month	Sales	Dispatches	Invoices	Packs	Dispatch Net kg	Sold Net kg	Sold Gross kg (Incl. Current Sample)	Sold Gross kg (Incl. Previous Unsold Samples)	Net Sales Avg Rs./kg	Gross Sale Avg Current	Gross Sale Avg Incl. Unsold Samples	Unsold kg	Withdrawn kg	Pending

Sale-wise Summary

Compare quantities dispatched, acknowledged, sold, unsold and withdrawn for each auction sale.

Sale	Selling Date	Dispatches	Invoices	Dispatch Net kg	Catalogue kg	Shutout / Violation kg	Sold Net kg	Sold Gross kg (Incl. Current Sample)	Sold Gross kg (Incl. Previous Unsold Samples)	Net Sales Avg Rs./kg	Gross Sale Avg Current	Gross Sale Avg Incl. Unsold Samples	Unsold kg	Withdrawn kg	Pending	Factory Valuation Avg	Report

Broker Tax Invoice Deductions by Category

Uses only relevant saved Broker Tax Invoices. Seller Contract reference is matched first; otherwise the app matches Sale Number + Broker. Category amounts come from the explicit Broker Tax Invoice charge fields; VAT from the same matched tax invoices is included as its own category. The Broker Deductions total therefore follows the matched Broker Tax Invoice total including VAT.

Deduction Category	Broker Tax Invoices	Brokers	Amount	% of Broker Deductions
Run Search to load category breakdown.

Sale Factory Valuation

Uses completed dispatch invoices only. Factory Valuation is weighted using full-bag tea only; the separate sample weight is excluded. Every invoice must have a Factory Valuation.

Select one sale

Invoices-

Valuation Net (Excl. Sample)-

Valuation Amount-

Weighted Factory Average-

No.	Dispatch	Invoice	Selling Mark	Grade	Packs	Valuation Net kg (Excl. Sample)	Factory Valuation Rs./kg	Valuation Amount Rs.
Select one sale to prepare the valuation report.

Monthly Grade Dispatch Report

Select a month above. Invoice numbers are grouped under each grade. Packed tea, dispatch samples and the complete dispatched weight are totalled separately.

Select month

Invoice Numbers	Grade Name	Invoices	Packs	Packed Tea kg	Dispatch Sample kg	Total Dispatched kg
Select a month to create the grade dispatch report.

Dispatch Report

One row per Tea Dispatch invoice with acknowledgement, catalogue and final outcome status. Sold Gross includes the Seller Contract sample weight. Net Sales Average = sold proceeds ÷ sold net kg; Gross Sale Average = sold proceeds ÷ sold gross kg.

FY	Dispatch	Sale	Date	Invoice	Selling Mark	Grade	Packs	Dispatch Net kg	Sold Net kg	Sold Gross kg (Current Sample)	Sold Gross kg (Incl. Previous Unsold Samples)	Net Sales Avg Rs./kg	Gross Sale Avg Current	Gross Sale Avg Incl. Unsold Samples	Broker	Lorry	Driver	Acknowledgement	Catalogue	Current Status

Sold Report

Seller Contract lot results for dispatched invoices, including buyer, price and rejection/return status.

Sale	Sale Date	Seller Contract	Lot	Invoice	FY	Grade	Buyer	Outcome	Net kg	Current Sample kg	Prior Unsold Sample kg	Gross kg (Current Sample)	Gross kg (Incl. Unsold Samples)	Net Sales Avg Rs./kg	Gross Sale Avg Current	Gross Sale Avg Incl. Unsold Samples	Price / kg	Proceeds	Buyer Return Status

MONTHLY DISPATCH BOOK

Dispatch Summary

Digital version of the factory dispatch summary register with separate Orthodox and CTC public-dispatch accounts plus Private Sale details. Completed Tea Dispatch invoices feed grade, invoice, bag and selling-mark quantities automatically; Private Sales come from the saved Private Sales register; Local Sale, Gratis, Stock and Refuse Tea figures come from the Stock ledger.

Select month

Summary Month

Only completed Tea Dispatch records are counted. “Previously” means the same financial year before the selected month; “To-Date” is financial-year-to-date through the selected month.

Factory Month Financial Year

Public Dispatch Invoices0

Public Dispatch Bags0

Dispatch to Colombo0 kg

Local Sale (LTS)0 kg

Gratis0 kg

Private Sale Weight0 kg

Private Sale ValueRs. 0.00

Balance in Factory0 kg

Orthodox Grand Tea Despatched Account

Orthodox dispatches are kept completely separate from CTC. Inside each grade, the invoice number is shown above its kilograms. No. of Bags is the total Orthodox bags in that completed dispatch.

0 bags · 0 kgNot calculated

Load a month to prepare the Orthodox register.

CTC Grand Tea Despatched Account

CTC dispatches are shown in their own register. Green Lanka follows the existing TC5 split rule: BP1 and selling marks containing CTC are treated as CTC; all other dispatch invoices remain Orthodox.

0 bags · 0 kg

Load a month to prepare the CTC register.

Private Sale Details

Saved Private Sale records for the selected month. These are shown separately from public Colombo dispatches. Process is identified as Orthodox or CTC using the same rule as the dispatch registers; stock movement remains controlled by the Stock ledger so quantities are not double-counted.

0 bags · 0 kg

Date	Invoice	Process	Bags	Grade	Selling Mark	kg	Buyer	Contract / Ref	Price / kg	Sale Value
Load a month to show Private Sale details.

Factory Disposals — LTS / Gratis

The Stock ledger currently stores Local Sale and Gratis as factory totals without a CTC / Orthodox process tag, so these are shown once here instead of being duplicated into either register.

Date	LTS	Gratis	Total

Summary

Monthly factory stock reconciliation.

Refuse Tea

Balance brought forward, collection and monthly outgoings.

Register Sign-off

Names are saved on this device and printed on the monthly register.

Entered ByChecked ByApproved By

TEA BOARD MONTHLY RETURN

TC5 - Monthly Tea Production & Dispatch

Prepare the official bilingual Sinhala-English TC5 return as a fully typed, sharp vector form without handwriting or scanned backgrounds. Auction packed tea and dispatch samples are linked directly from the Monthly Grade Dispatch Report.

New return

Opening Made Tea0.000 kg

Monthly Production0.000 kg

Colombo Auction0.000 kg

Dispatch Samples0.000 kg

Total Disposals0.000 kg

Closing Made Tea0.000 kg

1. Factory Particulars

Saved particulars are carried forward automatically to the next month.

Name of Factory (as registered) Registered No. Elevation Management Type Telephone

Average Green Tea Leaf Standard (enter two digits)

BestBelow BestPoor

2. Production and Stock Position of Orthodox Made Tea

Monthly made tea and refuse production are read from Stock → Daily Ledger. All made tea defaults to From Bought Leaf, but the source columns remain editable.

Not loaded

Opening Stock	From Own Leaf	From Leaf of Other Estates	From Bought Leaf	Made by Other Factories	Misc. Receipts	Total Available	Disposals	Closing Stock

Green Lanka TC5: Page 1 is maintained as two separate production/stock sections — CTC and ORTHODOX. Enter each process separately. Totals are preserved in the normal TC5 record for compatibility.

Process	Opening Stock	From Own Leaf	From Leaf of Other Estates	From Bought Leaf	Made by Other Factories	Misc. Receipts	Total Available	Disposals	Closing Stock
CTC
ORTHODOX

Load a month to calculate the return.

8. Details of Disposals of Made Tea

Automatic rows come from the Monthly Grade Dispatch Report: packed tea is Colombo Auction and sample weight is Gifts / Others.

0 grades

Invoice Nos.	Grade	Colombo Auction	Private Sales	Forward Contracts	Ex-factory	Direct Export	Gifts / Others	Returned to Other Estates	Direct Sales	Total kg
Load TC5 data to link monthly dispatches.

Other Disposal Details

Add only disposals not already included in Tea Dispatch. Private and direct-sale rows also populate the detailed TC5 sections.

0 rows

Category Garden / Selling Mark Invoice No. Grade Buyer Date of Sale Panel Approval Date Price per kg Weight kg

Category	Mark	Invoice	Grade	Buyer	Sale Date	Panel Date	Price / kg	Weight kg	Action
No additional disposals.

5. Refuse Tea

Manufactured refuse is linked from monthly production. Opening balance is carried from the previous saved TC5 return.

Opening Stock	Manufactured	Quantity Sold	Used as Manure	Other Disposals	Balance Stock

6-7. Broker and Selling Marks

Monthly brokers and active Tea Dispatch selling marks are loaded automatically; edit when required.

Names of Brokers Selling Marks

Declaration

These details appear on page 2 of the generated TC5 return.

Declaration Date Registered Manufacturer / Superintendent Special Remarks

Tea Dispatch Master Data

Financial year, selling marks, grades, sample allowance, pack options, sacks, lorries, drivers and brokers.

Dispatch SMS Notifications

Each factory can save its own Dialog eSMS URL message key, username, password, mask, recipients and message template. Dispatch messages now identify the Selling Mark and show the month-to-date dispatched weight under that mark; Dispatch Code is not included. Historical PDF-imported dispatches can be sent manually from the Dispatch Register by an administrator; they are never sent automatically. To add telephone numbers later, leave the secret fields blank—the saved login is retained and only the recipient list is updated.

ADMIN SETTINGS

Factory Automatic SMS SMS Provider Request Method SMS API URL URL Message Key SMS Username SMS Password SMS Mask / Source Address Recipient Mobile Numbers SMS Message Template

Advanced API parameter names

Message Key Field Username Field Password Field Mask Field Recipient / List Field Message Field Unicode Unicode Field Success Response Text / Pattern Extra Parameters

Select a factory to load its encrypted SMS provider settings.

Dialog eSMS defaults: GET request; message key field esmsqk; username username; password password; mask source_address; recipient list; message message. Available message fields: {factory}, {dispatch_date}, {dispatch_time}, {dispatch_datetime}, {sale}, {sale_date}, {broker}, {vehicle}, {driver}, {driver_phone}, {invoice_count}, {bags}, {net_kg}, {selling_mark}, {mark_dispatch_kg}, {mark_dispatch_bags}, {sale_mark_kg}, {sale_mark_bags}, {month_mark_kg}, {month_mark_bags}, {month_dispatch_count}, {mark_summary}, {month_name}, {factory_valuation}, {valuation_summary}. Line breaks are preserved. Dispatch Code is intentionally excluded. Administrators can use Resend SMS to deliberately send another copy.

Deploy dispatch-sms-v64007 once. Provider credentials are then managed separately for every factory from this screen.

Dispatch	Recipient	Status	Sent / Updated	Error
No SMS log loaded.

ADMINISTRATION

User Control Centre

Manage every Supabase login's app role, active status, factory assignments and visible categories from one dedicated page.

Total Supabase Users0

Active App Users0

Inactive / No Role0

Unconfirmed Emails0

Access Overview

Email / Auth Status	Name	Role	Factories	Category Access	Created / Last Sign-in	Action
No users loaded.

Latest Test Value -

Last Received -

Rows Loaded 0

Supabase Status Waiting for Data

Arduino → Supabase Test

Reads the latest data from the three-column arduino_test table.

Recent Test Data

ID	Test Value	Received At
No Arduino test data loaded.

Timer Devices0

Online Now0

Running / Alarm0

SD Rows Pending0

Combined History0

Timer Monitoring

Live ESP32 status, Supabase events, completed runs and historical records recovered from each timer SD card.

From Date To Date Device ID Source Event Type

Live Timer Status

Online = heartbeat received within the last 15 minutes (Rev K low-I/O heartbeat).

No timer devices loaded.

SD Card Sync Status

Existing /timer_log_v2.csv remains on the SD card and is never deleted by sync.

Device	Factory / Roller	SD Rows	Synced	Pending	Progress	Last Heartbeat
No SD sync status loaded.

Timer Runs

Current and historical runs created from live timer events.

Run	Device	Factory / Roller	Program	Start	End	Status	Last Event
No timer runs loaded.

Combined Event History

Live events plus unmatched SD history. A live event also found on SD is labelled LIVE + SD instead of being counted twice.

Time	Source	Device	Factory / Roller	Program	Interval	Event	Remaining
No timer events loaded.

Database Not Configured

Welcome back

Factory Dashboard

Attendance Dashboard

Monthly Attendance Summary

Daily Attendance

Hikvision Connector Events

Attendance Adjustment

Payroll Employees

Deleted Employees

Employee Master

1 · Employee & Hikvision

2 · Work Assignment

3 · Salary & Overtime

4 · Bank Details

Monthly Payroll

Monthly Earnings / Deductions

Advance Entry

Advance Entries - Selected Month

Tea Entry

Tea Entries - Selected Month

Employee Loan

Loan Installment Entry

Loan Register

Loan Installments - Selected Month

Other Deductions

Other Deductions - Selected Month

Attendance Reports & Monthly Register

Daily Attendance Report

Editable Monthly Attendance Register

Edit Attendance

Attendance / Payroll Setup

Hikvision Connector

Shift Master

Staff Department Master

Employment Type · EPF / ETF

OT Rate Profiles

Holiday Calendar

Agent Transport Summary

Monthly Agent Transport

Upload Route Incentive Sheet

Upload Fertilizer Transport Report

Agent Summary

Previous Months

Add Account Entry

Loan Deduction Schedule

Account Ledger

Agent Transport Master

Range Values

Route & Agent Master

Agent Account Master

Attention Needed

Today Activity

Daily Production Data

New Firewood Vehicle Entry

Vehicles in Process

Issue Firewood for Usage

Stock Ledger

Reports

Green Leaf Daily Entry

Withered Leaf Forecast

Recent Green Leaf Entries

Withered Leaf Batch Entry

Withering Batches

Daily Fired Tea / Production Outturn

Recent Production

Dryer Time / Made Tea Per Hour

Tea Stock

Dispatch Tea

Return Tea

Physical Stock Taking

Tea Stock Ledger

Manufacturing Summary

Firewood Cost

Manufacturing Master Data

Factories

User Factory Access

Daily Ledger

Selected Month Summary

Financial Year Summary