Load the QTN first — the Contract Sum and payment schedule stages below come from that quotation (already net of any negotiated discount). The line items table below still shows the original scope for reference; the amount actually invoiced is calculated here.
Variation Order Sections
Tick the approved VOs for this project to include as separate billing sections on this invoice. Each section shows its own subtotal, then a combined TOTAL DUE.
Bill To
Line Items
WBS No.
Description 1
Description 2
Qty
Unit
Rate (RM)
Amount (RM)
Totals & Payment
Purchase Order Details
SDD-PO-2026-0001
Supplier Details
Items Ordered
WBS No.
Description 1
Description 2 / Specification
Qty
Unit
Rate (RM)
Amount (RM)
Deliver Goods To
Totals
Variation Order Details
SDD-VO-2026-0001
Client Details
Project Details
Variation Line Items
WBS No.
Description 1
Description 2
Qty
Unit
Rate (RM)
Amount (RM)
Totals & Summary
VO Contract Summary
Receipt Details
SDD-RCP-2026-0001
Received From
Payment Details
Project Register — Grouped by Project
Every project is anchored to its original Quotation reference. Expand a project to see all linked documents and its current Active Value (unbilled balance).
No projects found. Issue a Quotation to start a new project.
Document Register
Ref No.
Type
Date
Client / Supplier
Project
Amount (RM)
Status
Action
No documents found. Start by issuing a document from the left menu.
⬆ Import Line Items
In Google Sheets or Excel: select your data range → Copy (Ctrl+C) → click the box below → Paste (Ctrl+V).
Column order must be: wbs_no | type | description_1 | description_2 | qty | unit | rate
Tip: header row is optional — the app detects it automatically.
Upload a .csv file exported from Excel or Google Sheets. Column order must be: wbs_no | type | description_1 | description_2 | qty | unit | rate
📂
Click to choose a CSV file
or drag and drop here
Download this template, fill it in your costing engine (Google Sheets / Excel), then import it back here.
wbs_notypedescription_1description_2qtyunitrate
01.00 division Division A — Preliminaries
01.01 item Hoarding & Protection 18mm plywood, 1.2m ht 20 m 45.00
01.01.02 item Site Signboard Aluminium composite 1 lump sum 380.00
02.00 division Division B — Demolition Works
02.01.01 item Hacking Wall Tiles All wet areas 45 sqft 3.50
Copy this header row into row 1 of your costing sheet, then fill data below:
wbs_no type description_1 description_2 qty unit rate
Preview — 0 rows detected
WBS No.
Type
Description 1
Description 2
Qty
Unit
Rate
Amount
📋 Accountant Handoff Sheet
🗑 Delete Document
You are about to permanently delete:
—
—
This cannot be undone. The document will be permanently removed from the register.
Document Preview
💳 New Payment Schedule
⚙️ Setup & Google Sheets Integration
Connect your Google Sheet to automatically log every issued document and sync document counters across multiple users.
1
Create your Google Sheet
Go to sheets.google.com → create a new sheet. Name it "Samreno Document Register 2026".
2
Paste the Sheet URL below
Copy the full URL from your browser and paste it here. It will be saved to your browser.
This app file is version —
Push Existing Data to Sheets
Pull Latest Data From Sheets
Use this on a new device, or to pick up documents/contacts issued from another device. This replaces what's stored locally in this browser with the latest from the Sheet — the Sheet is the source of truth.
1
Open your Google Sheet → Extensions → Apps Script
Delete all default code. Paste the script below entirely.
2
Save & Deploy as Web App
Click Deploy → New deployment → Type: Web App → Execute as: Me → Who has access: Anyone → Deploy. Copy the Web App URL.
3
Paste Web App URL in the Connection tab
Every user of this app pastes the same URL. Documents will log to the shared Sheet automatically.
Add clients here for autocomplete when creating documents, and to auto-fill tax/registration details on invoices. Data is stored in your browser.
Tax / Registration Details (optional — fill in when available)
Company
Contact
Phone
Email
TIN
Reg No.
MSIC
SST Reg.
SST?
These details are printed on every Accountant Handoff Sheet for e-Invoice submission via SQL Account → MyInvois portal. Stored in your browser.
These are Samreno's own e-Invoice details. Buyer TIN (client's TIN) is captured per-document in the client details section when issuing invoices.
These values are read from, and saved directly to, the Counters sheet — so a change here applies immediately to every device. If starting from an existing series, adjust the "Next Number" below.