Dashboard
Stock by model
AvailableAllocated
Outstanding by dealer (MYR)
PI value — last 6 months (MYR)
Receivables aging (unpaid balance)
Overdue & awaiting payment
Recent activity
Create Proforma Invoice
One PI number per VIN · issuing allocates the VIN to the dealerBuyer & terms
Select a dealer.
Select VINs
Shows Available VINs and VINs already allocated to this dealer.
PIs to issue — one per VIN
0 PIs
VIN Stock & Allocation
PI History
Dealer Payments
Record payment
Select a PI with an outstanding balance.
Outstanding PIs
Dealers & Outlets
Dealer = registered company billed on the PI · Outlet = showroom / branch under that dealerModels & Pricing
EV prints Motor number · PHEV prints Engine numberPrice change history
Shipping Order
Email delivery instructions to the logistics teamDelivery
When sent, the delivery date is recorded on every unit (ETD to Dealers in MASTER TRACKING FILE) and shown in VIN Stock & PI History.
Recipients, wording and each outlet's delivery location are set in Settings → Shipping Order.
Select VINs
Deliver all ticked VINs to
Email preview
Recent shipping orders
Activity Log
Settings
Seller (printed on PI)
Bank account (printed on PI)
Numbering & defaults
Email & weekly payment reminders needs Google Sheets sync
Email mode
Placeholders: {dealer} {due} {total} {no} · wrap text in **double asterisks** for bold. The table (PI Number, Model, Color, Chassis, Invoice link, Price, Payment Slip "Upload here") and signature are added automatically.
When set, the “Upload here” links in PI emails & reminders open this page instead of the Google page — no “created by a Google Apps Script user” banner, with the DENZA icon. Links in emails already sent keep working.
Placeholders: {inv} invoice no. · {no} PI no. · {dealer} · {vin}. Finance staff in Internal CC receive every PI email, so they can also simply “Reply all” with the invoice.
Images (shared with all users)
Saved on the server — every user's PIs use the same logo and stamp. Leave the stamp empty to sign by hand after printing.
Shipping Order
Placeholders: {date} = 05/10 · {day} = Monday · {dateLong} = 5th October · wrap in **double asterisks** for bold.
Delivery locations — the name in the summary line (e.g. “Harmony KLCC”), the company printed in bold, and the delivery address. Click Save settings to keep changes.
Saved places — other delivery locations you can pick for particular VINs (PDI centre, event venue, another branch…).
Users
Admin: everything incl. Settings, users, email mode & schedule. Staff: PIs, VINs, payments, dealers, emails — no Settings.
You can also manage users in the sheet's User tab (Email Address · Name · Password · Role · Active): a password typed there is applied at the next sign-in and then hidden, and the person must choose their own password.
You can also manage users in the sheet's User tab (Email Address · Name · Password · Role · Active): a password typed there is applied at the next sign-in and then hidden, and the person must choose their own password.
| Loading… |
Google Sheets sync
With a URL set, the app works directly on your existing tabs: VINs, allocations, PIs and payments are read live from MASTER TRACKING FILE, LOG, Payment Record and Data Validation, and every change is written back into those same tabs (formula cells are never overwritten). Without a URL, data stays in this browser only.