# Electrical store guide

Section: Guides by business type. Address: https://vende.id/docs/panduan/toko-listrik?lang=en

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.

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](#a-new-business) for a store just opening, with no stock, receivables or payables from before, and [A running business](#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](https://vende.id/docs/pengaturan/peran-dan-hak-akses?lang=en).

### 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](https://vende.id/docs/pengaturan/menambah-pengguna?lang=en).

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](https://vende.id/docs/produk-dan-harga/satuan-lain-dan-satuan-utama?lang=en).

![The product form of Kabel NYM with the base unit Metre and the other unit Roll of 50](https://vende.id/images/docs/en/panduan/toko-listrik-kabel-per-rol.webp "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](https://vende.id/docs/produk-dan-harga/harga-beli-banyak?lang=en).

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](https://vende.id/docs/produk-dan-harga/varian-produk?lang=en).

#### 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](https://vende.id/docs/produk-dan-harga/harga-khusus?lang=en).
- **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](https://vende.id/docs/pembelian/mencatat-pembelian?lang=en).

### 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](https://vende.id/docs/jualan/jualan-di-kasir?lang=en).

### 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](https://vende.id/docs/jualan/penawaran-harga?lang=en).
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](https://vende.id/docs/jualan/uang-muka-pesanan?lang=en).
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](https://vende.id/docs/jualan/surat-jalan?lang=en).
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](https://vende.id/docs/jualan/pembayaran-nota?lang=en).
- The **Owner** pays CV Sumber Kabel Nusantara before the due date in **Transaction Details → Purchase Payments**. See [Paying what you owe suppliers](https://vende.id/docs/pembelian/membayar-hutang-pemasok?lang=en).
- 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](https://vende.id/docs/kas-dan-keuangan/mencatat-biaya?lang=en).

### 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](https://vende.id/images/docs/en/panduan/toko-listrik-laporan.webp "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](https://vende.id/docs/produk-dan-harga/impor-ekspor-produk?lang=en).

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](https://vende.id/docs/pengaturan/kosongkan-transaksi?lang=en).

### 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](https://vende.id/docs/mulai/mengisi-saldo-awal?lang=en).

- **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.
