Skip to the page content

Electrical store guide

A learning path for an electrical store, new or running: job titles, cable by the metre and roll, electricians' prices, a project order, opening balances.

On this page

This guide is for the team setting up Vende at an electrical and lighting store that sells over the counter, gives regular electricians their own prices, and takes project orders from installers. It has two parts: A new business for a store just opening, with no stock, receivables or payables from before, and A running business for a store moving to Vende, with team practice and opening balances. The example is Toko Listrik Terang Abadi. The names of the store, customers, suppliers and people and all the figures are made up.

What the business looks like:

  • Goods: cable sold by the metre or by the 50-metre roll, LED lamps, switches and circuit breakers.
  • Buyers: households paying cash, regular electricians with their own prices, and installers ordering for one project.
  • Orders: an installer asks for a quotation, pays a down payment, receives the goods delivered, then pays the rest later.

Work through it from the top. Every step names its menu, who does it, what changes afterwards, and an example with figures.

The features in this guide come with the Electrical and lighting shop business type package, except those marked extra. The shop's features show under Settings → Subscription, section This shop's features. If a menu is missing, contact the Vende team.

Tip: Lost on a page? Press the ? button at the top of that page. A short tour shows every field.

A new business

Who does what

This package holds three users, the owner included.

Part of the store Job title in Vende What they do and open
Owner Owner Every menu, also suppliers and purchase notes, customer and supplier payments, expenses, opening balances, and Reports → Profit & Loss
Cashier and sales admin Head Cashier Customers, groups and Special Prices, selling on the till, quotations, orders and down payments, notes from delivery notes
Warehouse and delivery Warehouse Admin Products and their units, quantity prices, delivery notes, Reports → Stock

A bigger store adds a Finance Admin for payments and expenses, or a second Cashier, by adding users to its subscription. Every role is explained in Roles and permissions.

1. Shop details and users

Done by the Owner: fill in Settings → Shop (name, address, WhatsApp, logo), then create the accounts in Settings → Users with the Job title of the table above. See Adding and managing users.

The people at Toko Listrik Terang Abadi: Pak Yusuf (owner), Mbak Nia (cashier and sales admin, Head Cashier) and Mas Bayu (warehouse and delivery, Warehouse Admin).

2. Master data

A shop of this business type already has the product categories Cables, Lamps, Switches and Sockets, Circuit Breakers and Panels, Tools, and Installation Services, and the units Metre, Roll, Box and Unit. Its expense categories are the common ones, such as Electricity, Salaries and Transport.

Cable by the metre and by the roll

Warehouse Admin:

  1. In Master Data → Products, press New Product, enter the Name Kabel NYM 2x1,5 mm, the Category Cables, the Base Unit Metre, a cost price of Rp 6.000 and the Selling Price Rp 8.000.
  2. Under Other Units, press Add Unit, choose Roll, enter Contains (Metre) 50 and the Selling Price Rp 375.000.
  3. Press Create.

Stock is always counted in metres. A roll sold takes 50 metres off, and cable cut for a walk-in buyer takes off the metres bought. See Base unit, other units and main unit.

The product form of Kabel NYM with the base unit Metre and the other unit Roll of 50
Cable by the metre with the other unit Roll

Other goods and quantity prices

Warehouse Admin: create the other goods with the Base Unit Pieces:

Good Category First cost price Selling Price
Lampu LED 10 W Lamps Rp 18.000 Rp 25.000
Saklar Tunggal Switches and Sockets Rp 10.000 Rp 15.000
MCB 10 A Circuit Breakers and Panels Rp 45.000 Rp 60.000

On the product Lampu LED 10 W, fill in the Quantity prices table: From quantity 10, Price Rp 23.000, then press Save changes. A buyer of 10 lamps or more gets Rp 23.000 a lamp by itself. See Quantity prices.

The same lamp in several wattages or light colours may be made with variants, for example Daya (wattage) 10 W and 15 W. See Product variants.

Electricians, installers and suppliers

  • Head Cashier: in Master Data → Customer Groups, create the group Tukang Listrik. In Master Data → Special Prices, press New Special Price: For the Customer Group Tukang Listrik, Applies to One product Kabel NYM 2x1,5 mm in the unit Roll, Fixed price Rp 360.000. See Special Prices for customers and groups.
  • Head Cashier: in Master Data → Customers, register Pak Tono with the Group Tukang Listrik, and CV Sinar Instalasi Mandiri without a group with the Payment Terms (days) 14.
  • Owner: in Master Data → Suppliers, register CV Sumber Kabel Nusantara (30 days' credit) and Grosir Lampu Benderang.

3. First capital and buying

  1. The Owner records Rp 20.000.000 of capital into Bank BCA in Transactions → Finance → Owner's Capital.
  2. The Owner records the note of CV Sumber Kabel Nusantara in Transactions → Purchases: 20 Rolls of Kabel NYM 2x1,5 mm × Rp 300.000 = Rp 6.000.000, 30 days' credit, no payment. The stock grows by 1.000 metres, at a cost of Rp 6.000 a metre.
  3. The Owner records the note of Grosir Lampu Benderang, paid in full from Bank BCA: 100 Lampu LED 10 W (Rp 1.800.000), 50 Saklar Tunggal (Rp 500.000) and 10 MCB 10 A (Rp 450.000), so Rp 2.750.000.

See Recording a purchase note.

4. Selling at the store

The Head Cashier serves buyers on the till through Transactions → Sales, button New sale. An example day, cash into Cashier Cash:

Buyer Goods Amount
Pak Tono (Tukang Listrik) 2 Rolls of Kabel NYM 2x1,5 mm × Rp 360.000 Rp 720.000
Household 10 Metres of Kabel NYM 2x1,5 mm × Rp 8.000 Rp 80.000

Choose the unit Roll or Metre on the note line. Pak Tono's price fills itself in once he is chosen as the customer. The cash of that day is Rp 800.000. See Recording a sale on the till.

5. One project order from quotation to paid

Example: CV Sinar Instalasi Mandiri wires one shophouse.

Goods Price Amount
4 Rolls of Kabel NYM 2x1,5 mm Rp 375.000 Rp 1.500.000
40 Lampu LED 10 W Rp 23.000 (quantity price) Rp 920.000
20 Saklar Tunggal Rp 15.000 Rp 300.000
4 MCB 10 A Rp 60.000 Rp 240.000
Total Rp 2.960.000
  1. Head Cashier: in Transactions → Quotations, press New Quotation, choose CV Sinar Instalasi Mandiri, enter the four goods, then save and send its PDF. See Making a price quotation.
  2. Head Cashier: once agreed, press Convert to Order, fill in the Pickup Date, then press Receive Down Payment of Rp 1.000.000 into Bank BCA. See Taking a down payment on an order.
  3. Warehouse Admin: when the goods go out, in Transactions → Delivery Notes, press Make Delivery Note, choose that order, fill in the Sent column for all goods, then press Save Delivery Note and print it. The stock leaves then. See Sending goods in several deliveries with delivery notes.
  4. Head Cashier: on the order page, press Make Note from Delivery Notes, choose the delivery note, then Make Draft Note. Press Pay: Taken from the order down payment shows Rp 1.000.000. Press Unpaid, then Save transaction.

The rest, Rp 1.960.000, becomes a receivable of CV Sinar Instalasi Mandiri, due in 14 days. Goods delivered in several trips get several delivery notes, then are billed with one note.

6. Receivables, payables and expenses

  • The Owner records the settlement of CV Sinar Instalasi Mandiri in Transaction Details → Sale Payments: Rp 1.960.000 into Bank BCA. See Recording payment of an unpaid note.
  • The Owner pays CV Sumber Kabel Nusantara before the due date in Transaction Details → Purchase Payments. See Paying what you owe suppliers.
  • The Owner records the store's electricity of Rp 250.000 in the category Electricity in Transactions → Finance → Expenses, from Cashier Cash. See Recording shop expenses.

7. Reports per job title

Report What it shows Opened by When
Reports → Stock The stock of every good, cable in metres Warehouse Admin Every day
Reports → Receivables What every installer still owes Owner Every week
Reports → Payables What is owed for cable, with due dates Owner Every week
Reports → Profit & Loss Sales, cost of goods sold and expenses Owner Every month
The Stock report in the demo shop Toko Listrik Terang Abadi, used in the step 7. Reports per job title
The result to check: Reports → Stock

8. Checklists

  • Every day: the Head Cashier closes the till sales. The Warehouse Admin makes a delivery note for every order that leaves.
  • Every week: the Head Cashier makes notes from the delivery notes that arrived. The Owner reads Receivables and Payables, then collects and pays what is due.
  • Every month: the Warehouse Admin counts the cable and lamps with a stocktake. The Owner reads Profit & Loss.

A running business

This part is for the team moving an electrical store already running to Vende: there is already cable, including rolls already cut, lamps on the racks, installers owing money, debts to distributors, and goods paid for but not collected yet. The order is always the same:

  1. Fill in the master data.
  2. Practise transactions until every part is used to them.
  3. Empty the practice transactions.
  4. Fill in the opening balances on the first day.
  5. Go live.

The opening balances come last on purpose, so the practice does not upset their figures. The examples in this part use Toko Listrik Terang Abadi from the new business part.

1. Master data

Do Who does what, 1. Shop details and users and 2. Master data above. Also register every customer still owing money or with an order, every supplier still owed, and every good still in stock. Many goods are imported from Excel. See Importing and exporting products with Excel.

Master data is not deleted when the practice transactions are emptied.

2. Team practice

Work in a practice shop of the type Electrical and lighting shop with all three accounts. Every step names who and what must show.

Practice 1: master data

  1. Owner: shop details, both users and both suppliers.
  2. Mas Bayu (Warehouse Admin): the four goods, the Roll unit of the cable, and the quantity price of lamps.
  3. Head Cashier: the group Tukang Listrik with the Special Price of cable, Pak Tono and CV Sinar Instalasi Mandiri.
    • Check: on the till, 1 Roll of cable for Pak Tono shows Rp 360.000, for a walk-in buyer Rp 375.000, and 10 lamps Rp 23.000 a lamp.

Practice 2: one working day and one order

  1. Owner: Rp 20.000.000 of capital and both purchase notes as in part 3.
  2. Head Cashier: both store sales as in part 4, Rp 800.000 cash.
  3. Head Cashier: the quotation, the order and the Rp 1.000.000 down payment of CV Sinar Instalasi Mandiri.
  4. Warehouse Admin: the delivery note of all the order's goods in Transactions → Delivery Notes.
  5. Head Cashier: the note from the delivery note, the rest of Rp 1.960.000 unpaid.
  6. Owner: the Rp 1.960.000 settlement into Bank BCA and the Rp 250.000 electricity expense from Cashier Cash.

After Practice 2 this must show:

Report What must show Opened by
Reports → Cash Balance Bank BCA Rp 20.000.000 − Rp 2.750.000 + Rp 1.000.000 + Rp 1.960.000 = Rp 20.210.000; Cashier Cash Rp 800.000 − Rp 250.000 = Rp 550.000 Owner
Reports → Payables CV Sumber Kabel Nusantara Rp 6.000.000 Owner
Reports → Stock Cable 1.000 − 200 − 100 − 10 = 690 metres, lamps 60, switches 30, circuit breakers 6 Warehouse Admin
Reports → Profit & Loss Sales Rp 2.960.000 + Rp 800.000 = Rp 3.760.000, cost of goods sold Rp 2.960.000 (310 metres of cable Rp 1.860.000, lamps Rp 720.000, switches Rp 200.000, circuit breakers Rp 180.000), expenses Rp 250.000 Owner

Practice 3: opening balances

Fill in the opening balances with the example of part 4 below, check them as in part 5, then empty again.

3. Empty the practice transactions

Done by the Owner in Settings → Empty Transactions, button Empty All Transactions. Quotations, orders with their down payments, delivery notes, notes, purchases, payments, expenses, capital and opening balances are deleted. Products with their other units, quantity prices, Special Prices, groups, customers, suppliers, warehouses, cash accounts, users and settings stay. Vende makes a full backup first. See Emptying transactions or all data.

4. Opening balances

Done by the Owner in Settings → Opening Balances on the morning of the first day, with As of that day. See Entering opening cash, stock, receivables and payables.

  • Opening Stock: cable is entered in the Unit Metre, whole rolls and the rest of the rolls already cut added up. Example: 8 whole rolls and one roll with 35 metres left become Kabel NYM 2x1,5 mm 435 Metres with a Cost Price per Unit of Rp 6.000. Lampu LED 10 W 80 Pieces at Rp 18.000, Saklar Tunggal 40 Pieces at Rp 10.000, MCB 10 A 12 Pieces at Rp 45.000.
  • Opening Receivables: CV Sinar Instalasi Mandiri Rp 1.500.000 with its due date.
  • Opening Payables: CV Sumber Kabel Nusantara Rp 3.000.000.
  • Opening Cash: the money counted in every account, less the down payment below. Example: the Bank BCA account Rp 15.000.000, the cashier's drawer Rp 1.000.000.

Goods paid for but not collected yet

Opening Balances has no tab for goods paid for before the first day but not collected or delivered yet. The way to do it with what is there:

  1. The goods are still in the store, so they are counted in Opening Stock.
  2. The Head Cashier makes a new order on the first day in Transactions → Sales Orders holding only those goods, at the agreed prices.
  3. On the order page, she presses Receive Down Payment for what was already paid, into the cash account that now holds the money, dated the first day.
  4. The Owner fills in that account's Opening Cash with the money counted less that down payment.

Example: yesterday Pak Tono paid Rp 720.000 in cash for 2 Rolls of cable he only collects tomorrow. His order holds 2 Rolls of Kabel NYM 2x1,5 mm × Rp 360.000, its down payment is Rp 720.000 into Cashier Cash, and the Opening Cash of Cashier Cash is Rp 1.000.000 − Rp 720.000 = Rp 280.000.

What follows:

  • Cashier Cash comes back to Rp 1.000.000, the same as the drawer, and the order holds Rp 720.000 as its down payment.
  • When Pak Tono collects his cable, the Head Cashier presses Convert to Sale on that order and saves the note. The down payment pays the whole note, nothing is left, and 100 metres of cable leave the stock.
  • Reports → Profit & Loss records the Rp 720.000 sale on the day of the note. If the old program already recorded that sale, the year's profit in both records is added up with care so it is not counted twice.

5. Check before going live

Report What must show Opened by
Reports → Cash Balance Bank BCA Rp 15.000.000 and Cashier Cash Rp 1.000.000, the same as the money counted Owner
Reports → Stock Cable 435 metres, lamps 80, switches 40, circuit breakers 12 Warehouse Admin
Reports → Receivables CV Sinar Instalasi Mandiri Rp 1.500.000 Owner
Reports → Payables CV Sumber Kabel Nusantara Rp 3.000.000 Owner
Transactions → Sales Orders Pak Tono's order with a Rp 720.000 down payment Head Cashier

The figures differ? The Owner corrects the row in Settings → Opening Balances before real transactions are recorded.

6. Going live

From that day every sale, quotation, order, delivery note and payment is recorded in Vende as in the new business part, with the same checklists. In the first week, the Warehouse Admin compares Reports → Stock with the count on the racks and the rolls of cable left, and the Owner checks that Reports → Profit & Loss holds only sales and expenses since the first day.

Still not answered?

Ask us directly. We help until it is clear.

Ask on WhatsApp