Database Not Configured
The database connection is set by the system administrator. Staff should only use the Login screen.
Set the Supabase Project URL and anon public key in supabase-config.js, then deploy again.
Login
Use the email and password you created in Supabase Authentication.

Select the category you need
Only categories available to your role are shown. The app no longer opens Firewood automatically.
rounded stock yards 0.00 yd
rounded stock yards 0.00 yd
Attention Needed
Today Activity
Daily Production Data
selected factory 0.00 kg
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 kgDispatch 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.
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.
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.
Use Stock → Entry for Daily Production, Return Tea and Dispatch / Outgoing entries. Tea Dispatch Assignment integration will be added later.
Selected Month Summary
Month-to-date figures for the month selected above.
Financial Year Summary
Separate to-date totals for the selected financial year.
Opening Stock
Admin onlyDetailed Dispatch Register
Historical detailed dispatch records for the selected financial year. Latest first. This reference register does not change the Daily Ledger.
| Date | Invoice | Buyer | Grade | Dispatch kg | Vehicle | Remarks |
|---|
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 | Status | Actions |
|---|
Factory Balance Report
Financial-year production, outgoing stock, expected balance and stock-taking variance.
Expected Closing Stock Trend
daily ledger balanceGreen Leaf vs Made Tea
daily kilogramsAdjusted Monthly Out-turn
after applied stock-taking adjustmentsOutgoing Stock
dispatch, local sale and gratisStock-taking Excess / Loss
physical stock against ledger on final green leaf dateMonthly Out-turn After Actual Stock Adjustment
Excess or loss is allocated by each month’s green-leaf share.
| Month | Green Leaf kg | Recorded Made Tea kg | Allocated Excess / Loss kg | Adjusted Made Tea kg | Adjusted Out-turn % |
|---|
| Physical Stock Date | Final Green Leaf Date | Session | Expected Stock kg | Physical Stock kg | Excess / Loss kg | Variance % | Verification | Admin Action |
|---|
Entry
Enter daily production, returned tea and independent dispatch / outgoing quantities.
Dispatch is entered separately from Local Sale and Gratis. Tea Dispatch Assignment integration will be added later.
Daily Production Entry
Made Tea = Fired Tea less refuse tea, rounded to the nearest whole kilogram. Refuse Tea is kept as the balancing quantity.
Return Tea Entry
Returned tea is added back to the expected made-tea balance.
Dispatch / Outgoing Entry
Entered independently for now. Dispatch Assignment integration will be added later.
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.
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 Reports
Final Stock by Grade
kg compositionSession Stock Trend
final stock over timeDeduction Impact
refuse kg by rateStock Value by Grade
valuation comparisonBox Type Usage
number of boxes recordedSelling Mark Percentage
share of final stockAverage Price Contribution
grade contribution to weighted averageGrade 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 onlyFactory 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
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 |
|---|
Leaf Quality Master Data
Customers: Admin/Office Clerk · Reasons: AdminCustomer List
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
Office Cashbook Dashboard
Selected Day Entries
| Date | Factory | Type | Category | Description | Amount | Diff | Bill |
|---|
Recent Cashbook Entries
| Date | Factory | Type | Category | Description | Amount | Diff | Bill |
|---|
Cashbook Entry
Bill photo required for expensesCashbook Reports & Monthly Vouchers
Expense Category Summary
| Category | Bills | Cash Amount | Invoice Total | Difference |
|---|
Detailed Cashbook Records
| Date | Factory | Type | Category | Description | Amount | Diff | Bill |
|---|
Cashbook Master Data
Expense categoriesExpense Category
Category List
You can upload Seller’s Contracts and Seller Tax Invoices, and enter receipts, adjustments, VAT documents and payments for your permitted factory or factories. Saved records cannot be edited or deleted.
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 the factory tax-invoice PDF issued to tea buyers. The app recognises both supplied layouts, reads every page, and links each invoice and lot to the Seller’s Contract.
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 | Buyer / TIN | Seller Contract | Lots | Taxable Value | VAT | Total | Match Status | 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.
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.
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.
Select the period and click Search Sales Report.
Deductions and adjustments by category
| Category | Source | Type | Contracts / Entries | Amount | % of gross |
|---|
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 |
|---|
Withdrawn lot details
Withdrawn lots are kept separately and never included in sold kilos, average, proceeds or VAT.
| Sale date | Factory / Mark | Contract | Lot | Invoice | FY | Grade | Bags | Gross kg | Net kg |
|---|
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.
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.
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.
| Date | Description | Contract / Mark | Receipt type | Reference | Debit | Credit | Recorded balance |
|---|
Accounts Statement
Create a dated factory ledger with Seller’s Contract proceeds, VAT, deduction categories, adjustments, advances and bank receipts.
Select a factory, account and date range.
Positive balance represents money receivable. A negative balance represents advance or credit available.
| Date | Account | Description | Contract / Reference | Debit | Credit | Running balance |
|---|
VAT Management
Open only the VAT area you need. The working paper uses Auction Sale VAT by sale date, other VAT Output, Purchase Bills, Tax Credit/Debit Notes and VAT Payments.
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.
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
| Date | Input / Output | Category | Description | Reference | Value | VAT | Total |
|---|
Other VAT Output
Use this for Local Sales, Manure Sales, Refuse Tea, Coir Bags and other taxable sales. These invoices are automatically included in IRD Schedule 01. Auction Sale VAT comes from Seller Tax Invoices and must not be entered again here.
Saved VAT Output
All saved non-auction VAT Output entries are listed below.
| Date | Factory | Category | Customer / TIN / Invoice | Value | VAT | Total | Document | Actions |
|---|
Purchase Bills – VAT Input
Upload each purchase bill. The app reads the photo/PDF, learns from previously saved supplier entries, suggests corrected values, and lets you choose the VAT effective month separately from the bill date.
Saved Purchase Bills
Showing only the factory selected at the top. The bill date and Effective VAT Month are shown separately.
| Bill Date | Effective Month | Type | Broker | Factory | Supplier | Invoice | Value | Invoice VAT | Disallowed VAT | Allowable VAT | Total | Bill | Actions |
|---|
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.
| 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 the VAT period they settle. A payment made in a later calendar month still reduces the selected VAT period.
VAT Payment History
All payments already recorded are shown here. Filter by factory or 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
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.
| 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.
| 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.
| 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.
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.
Tea Dispatch Control Centre
Create controlled invoices, assign them to broker dispatches and verify every bag weight before departure.
Tea Dispatch 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 |
|---|
Sale Arrangements
Create the official sale number and calendar once, then assign every dispatch to the correct sale.
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.
| Sale / FY | Date of Sale | Catalogue Close | Prompt Buyer | Prompt Seller | 10% Payment | E-Platform Buyer | E-Platform Seller | VAT Summary | VAT Buyer | VAT Seller | Buyer TIN Delivery | TIN Collection | Status |
|---|
Create Tea Invoice
Invoice numbers are unique within the factory financial year.
Saved Invoices
Private invoices remain visible here with a PRIVATE label but are handled only in the separate Private Sales page.
| Invoice | Sale Type | Effective Financial Year | Selling Mark | Grade | Packs | Sack | Net / Pack | Sample | Expected Net | Mfg Date | Valuation | Moisture | Status |
|---|
Private Sales
Register private-sale invoices and their supporting documents separately. These invoices never enter public acknowledgements, broker valuations, Seller Contracts, catalogue attempts, Sale +3, unsold, shutout or violation processing.
Create / Edit Private Sale
First mark the tea invoice as Private Sale in Invoicing, then select it here. Invoice details are loaded automatically and may be corrected for the private-sale document.
Private Sale Register
This register is independent from the public auction and Seller Contract workflow.
| 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.
| 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
Open a dispatch to continue bag weighing. Use Dispatch PDF for the Tea Estate Invoice layout; dispatch deletion is available only to administrators.
| Dispatch | Sale | Date | Broker | Lorry | Driver | Invoices | Packs | Expected Net | Weighed | Status | Acknowledgement | Broker Valuation | SMS |
|---|
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 |
|---|
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.
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.
Administrator — Create Missing Invoice
Use only when an invoice printed in the acknowledgement has no Tea Dispatch invoice or Dispatch Assignment. The new record is audited and rechecked before the acknowledgement can be saved.
Administrator Correction
Review and correct details extracted from the acknowledgement PDF before saving. Changes are rechecked against Dispatch Assignment.
| # | Lot | Invoice | Grade | Packs | Weight / Pack | Net kg | Rechecked Status |
|---|
Use this only after checking or correcting the PDF row values above. The acknowledgement will be saved once, without the automatic recovery chain. Any remaining unmatched row will open in the manual Dispatch Assignment workspace.
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 | 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.
| Acknowledgement Invoice / Lot | Grade / Packs | Ack kg | Current Status | Correct Dispatch Assignment |
|---|
Broker Valuations
Upload a valuation only after its acknowledgement has been saved. The valuation is linked to the acknowledgement and therefore to all covered dispatches.
Upload Broker Valuation
The system checks the sale number, estate marks and invoice numbers against the selected acknowledgement before saving.
Saved Broker Valuations
Each valuation opens from its acknowledgement and inherits the acknowledgement's dispatch links. Use Report to print or save valuation details and the invoice tally.
| Sale | Acknowledgement | Printed Date | Marks | Invoices | Projected Proceeds | Dispatches | Actions |
|---|
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.
Restore Results
No restore has been run.
| Valuation PDF | Result | Rows | Download / Error Details |
|---|
Broker Valuation Lot Source Register
The header row and Invoice column remain frozen. Linkage Status reads valuation evidence directly from this source register.
| 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. | |||||||||||||||
Seller Contracts
Upload Seller Contracts immediately after Broker Valuation and link sold, unsold or withdrawn lots to the original Tea Dispatch invoices.
Only administrators and office clerks with an assigned factory can upload Seller Contracts.
Upload / Edit Seller Contract
Upload the broker PDF, verify every lot and save it directly inside the Tea Dispatch workflow.
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 | Actions |
|---|
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.
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.
| 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. | ||||||||||||||||||
Invoice Document Chain
Compare Dispatch, Acknowledgement, Broker Valuation and sold-status source rows directly for each invoice and sale. This register does not rewrite historical linkage records.
Audit Filters
Each sale is checked separately. A source document is counted when its own invoice, sale and estate-mark evidence exists; old catalogue-attempt pointers are not used to decide whether the document was found.
Invoice Linkage Register
The header row and Invoice column remain frozen. Evidence is calculated directly from saved source documents. Sold Status is read from the extracted Seller Contract lot source register and linked through the invoice financial year.
| Invoice | FY | Selling Mark / Grade | Dispatch | Acknowledgement | Broker Valuation | Sold Status | Overall |
|---|---|---|---|---|---|---|---|
| Open this tab to load invoice linkages. | |||||||
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. | ||||||||||||
Acknowledgement Holding Bin
Hold acknowledged Dispatch Assignment invoices safely and transfer them to any selected sale later. Quantity and sample history are retained.
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. | |||||||
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.
Unsold Bin Filters
Results are read from catalogue attempts and Seller Contracts. No manual movement is required.
Currently Unsold
The latest confirmed Seller Contract result is Unsold. Sale +3 recatalogue details are shown when available.
| 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.
| 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 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.
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. | ||||||||
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.
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. | |||||||||
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.
Recorded Bags & Sample
| Item | Actual Scale | Expected | Difference | Check | Scale / Source | Sri Lanka Date / Time | Remark |
|---|
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.
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.
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.
Live Reading Test
Place a known test weight on the scale. A stable reading must be shown before production use.
Raw 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 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.
Register Period
The financial year is the main period. Month and sale are optional additional filters; all 1–1500 buttons remain visible.
Invoice Numbers 1–1500
Status priority is Sold → Unsold → Catalogued → Dispatched. A later final Seller Contract result therefore replaces the earlier workflow colour.
Invoice Detail
Click an invoice number to view the full dispatch-to-sale history.
Tea Dispatch & Sold Reports
Review month-wise and sale-wise movement, detailed dispatches, Seller Contract outcomes and the live status of any invoice.
Report Filters
Financial year comes from the Tea Dispatch Master assigned to each invoice. Month uses dispatch date for dispatch reports and sale date for sold reports.
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.
| 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.
Month-wise Summary
Dispatch and Seller Contract outcomes grouped by calendar month.
| Month | Sales | Dispatches | Invoices | Packs | Dispatch Net kg | Sold kg | 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 kg | Unsold kg | Withdrawn kg | Pending |
|---|
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.
| 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.
| FY | Dispatch | Sale | Date | Invoice | Selling Mark | Grade | Packs | Dispatch Net kg | Broker | Lorry | 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 | Price / kg | Proceeds | Buyer Return Status |
|---|
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.
Return Month
Select the factory and calendar month. The full auction dispatch quantity, including its dispatch sample, is placed under Colombo Auction. Gifts / Others is reserved for genuine gift or other disposals entered separately. Generated TC5 input values print in larger written blue (#00308F).
1. Factory Particulars
Saved particulars are carried forward automatically to the next month.
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.
| Opening Stock | From Own Leaf | From Leaf of Other Estates | From Bought Leaf | Made by Other Factories | Misc. Receipts | Total Available | Disposals | Closing Stock |
|---|---|---|---|---|---|---|---|---|
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.
| 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.
| 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.
Declaration
These details appear on page 2 of the generated TC5 return.
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.
| Dispatch | Recipient | Status | Sent / Updated | Error |
|---|---|---|---|---|
| No SMS log loaded. | ||||
Factory Profit & Loss
Combines captured factory data with approved monthly adjustments and calculates cost of production.
Monthly P&L Summary
Auto values come from existing app modules. Manual entries are added separately and remain fully traceable.
| Section | Description | Source | Auto | Manual | Total | COP |
|---|---|---|---|---|---|---|
| Select a factory and month. | ||||||
Transaction Drill-down
Select a P&L line to see the exact source records and manual adjustments behind the total.
| Date | Source | Reference / Description | Amount | Routing |
|---|---|---|---|---|
| No line selected. | ||||
Automatic Source Checks
| Source | Records | Amount | Status / Note |
|---|---|---|---|
| No source data loaded. | |||
Review, Route & Reconcile
Every source transaction appears once, with an automatic destination suggestion, duplicate protection and a complete audit trail.
Source Transactions
Change the P&L destination at any time. Linked bank credits are marked and excluded by default to prevent double counting.
| Date | Module | Reference / Description | Amount | Suggested / Current Destination | Confidence | Status | Action |
|---|---|---|---|---|---|---|---|
| Load a month to review transactions. | |||||||
Month Control
Closing a month locks P&L routes and manual adjustments. Reopen only with a recorded reason.
Monthly Operational Inputs
Made tea and green leaf are read automatically where available. Enter an override only when the official month-end figure differs.
Manual P&L Entry / Adjustment
Use this for payroll, electricity, bought leaf payments and any cost or income not captured automatically.
Saved Monthly Entries
| Date | Section | Description | Reference / Note | Units | Rate | Amount | Action |
|---|---|---|---|---|---|---|---|
| No entries. | |||||||
Monthly Profit & Loss Report
Structured from the supplied factory P&L workbook with live source values, manual adjustments and COP.
| Section | Description | Source | Auto | Manual | Total Cost / Income | COP / kg |
|---|---|---|---|---|---|---|
| Prepare a report first. | ||||||
P&L Master Lines & Source Mapping
Edit the workbook line names and decide whether a line is manual or linked to an existing app source.
Configured Lines
| Order | Section | Line | Type | Source | Match | Included | Status | Action |
|---|---|---|---|---|---|---|---|---|
| No P&L lines. | ||||||||
User Control Centre
Manage every Supabase login's app role, active status, factory assignments and visible categories from one dedicated page.
Access Overview
All Supabase Users & App Access
Every account from Supabase Authentication is shown here, including accounts without an app role. Select a user to manage role, status, factories and category visibility. Password reset emails can also be sent from this page.
| Email / Auth Status | Name | Role | Factories | Category Access | Created / Last Sign-in | Action |
|---|---|---|---|---|---|---|
| No users loaded. | ||||||
Timer Records
ESP32 timer records uploaded to Supabase. Use filters to check by date, device, and status.
| Device | Start Time | End Time | Total Min | Actual Min | Intervals | Status | Uploaded At |
|---|---|---|---|---|---|---|---|
| No timer records loaded. | |||||||