A step-by-step guide to entering business data in EPIC Inc's dashboard.
🌟 See the Full Demo Dashboard (100% Data) →
Preview how the dashboard looks when all data is entered for FY 2025-26
v1.0 · March 2026Before we start clicking buttons, let's understand what EPIC Inc does and how money flows.
EPIC Inc earns money in 4 ways (we call these Verticals):
Every business transaction follows this simple path:
Meanwhile, we also spend money on expenses (rent, salaries, parts, etc.)
When you open the dashboard, here's what you see.
The dashboard has two modes. You'll mostly work in Admin mode.
Admin mode — This is YOUR mode. Data entry, tables, details.
Executive mode — For the MD. Charts and summaries. Read-only.
On the left side, you'll see the navigation. In Admin mode, it looks like this:
Follow this order. Each step depends on the one before it.
What are these? Business Units are the companies under EPIC (like "Epic Inc" and "Kalyteri Enterprises"). Verticals are the 4 ways EPIC earns money.
When to add: Only when a new company or business line is created. These are already set up for you.
| Table | Key Fields | You Need To Know |
|---|---|---|
| Business Units | Unit Name, Legal Name | Currently: Epic Inc, Kalyteri Enterprises |
| Verticals | Vertical Name, Code | Currently: Device Rentals, Product Supplies, AMC, Commission |
What are these? Vendors are companies we buy from (suppliers). Expense Heads are categories for our spending.
| Table | Key Fields | Example |
|---|---|---|
| Vendors | Vendor Name, GST No, Contact | "Kite Technologies" — we buy laptops from them |
| Expense Heads | Name, Category, Affects P&L | "Device Maintenance" under DIRECT category |
Expense categories explained:
What are these? The items and services EPIC sells or rents. Each has an HSN/SAC code (government tax code) and a GST percentage.
| Field | What It Means | Example |
|---|---|---|
| Type | PRODUCT (physical item) or SERVICE | A printer = PRODUCT, maintenance = SERVICE |
| Name | What we're selling/renting | "98 inch Interactive Panel" |
| HSN/SAC | Government tax classification code | 9954 (for services) |
| Default Rate | Standard price in ₹ | ₹7,06,503 |
| GST % | Tax percentage (usually 18%) | 18.00 |
What are these? Clients are the companies or people who pay us. Client Locations are their office/delivery addresses.
| Field | What It Means | Example |
|---|---|---|
| Client Name | Company or person name | "Danieli" or "Mr. Gopinath (School)" |
| Client Type | BUSINESS or INDIVIDUAL | Company = BUSINESS, person = INDIVIDUAL |
| GST No | Their GST registration number | Optional — individuals may not have one |
| PAN No | Their PAN card number | Needed for TDS purposes |
| Contact Person | Who do we call there? | The person who handles payments |
After adding a client, add their Locations (if they have offices in multiple cities):
| Field | Example |
|---|---|
| Client (dropdown) | Select "HUL" from the list |
| Location Name | "CHIKKABALLAPUR" |
| City | "BANGALORE" |
What is this? This links a Client to the Verticals they use. A client might rent devices AND buy products — so they'd be linked to 2 verticals.
How to add:
Master data is set up once. The real daily work is entering transactions — this is what the finance team and admin do every day.
This is what drives the dashboard. Every transaction entered here shows up automatically in the charts and reports.
Sometimes, after we send an invoice, something changes:
In these cases, we cannot just delete the invoice (it's already in the tax records). Instead, we issue a Credit Note — a formal document that reduces the amount the client owes us.
| Field | What It Means | Example |
|---|---|---|
| Credit Note No | Unique reference number for this credit note | CN-001 |
| Invoice (dropdown) | Which invoice is this correcting? | Select "INV-HUL-001" |
| Credit Date | Date the credit note is issued | 2026-03-14 |
| Amount | How much are we reducing? (in ₹) | ₹5,000 |
| Reason | Why are we issuing this? | "Client returned 2 units" or "Billing error correction" |
When to create a Credit Note:
When a client pays you, the system needs to know which invoices that payment covers. The Smart Receipt form handles this in one step.
How it works:
Example — One payment covering multiple invoices:
| Invoice | Outstanding | Allocate | TDS (2%) | |
|---|---|---|---|---|
| ☑ | EPIC 315/25-26 | ₹1,94,700 | ₹1,94,700 | ₹3,894 |
| ☑ | EPIC 316/25-26 | ₹1,05,020 | ₹1,05,020 | ₹2,100 |
| ☐ | EPIC 319/25-26 | ₹1,32,750 | — | — |
Client sends ₹3,00,000. It covers invoices 315 and 316 fully. TDS of ₹5,994 is deducted. Invoice 319 is left unpaid for now.
After clicking Create:
Partial payment example:
Client sends ₹2,50,000. You allocate ₹1,94,700 to invoice 315 (fully paid) and ₹55,300 to invoice 316 (partial). Invoice 316 becomes PARTIAL with ₹49,720 still outstanding.
Small day-to-day cash expenses — courier charges, auto fare, fuel, food, etc. Go to Transactions → Petty Cash.
| Field | What It Means | Example |
|---|---|---|
| Transaction Date | When the cash was spent or received | 2026-04-15 |
| Transaction Type | CASH_IN (top-up) or CASH_OUT (expense) | CASH_OUT |
| Business Unit | Epic Inc or Kalyteri | Epic Inc |
| Expense Head (dropdown) | What category is this expense? | Courier / Transportation |
| Description | What was the expense for? | Porter charges for laptop delivery |
| Client | Which client this relates to (if any) | HUL |
| Paid By | Staff who spent the cash | Kalai |
| Amount | How much was spent | ₹350 |
| Receipt Available | Does the staff have a receipt? | YES / NO |
| Status | RECORDED → VERIFIED → CANCELLED | RECORDED |
When goods are received from a vendor, record it under Transactions → Purchases. This captures the vendor's bill — needed for GST input credit.
| Field | What It Means | Example |
|---|---|---|
| Purchase Date | When goods were received | 2026-04-10 |
| Vendor (dropdown) | Who supplied the goods? | Grace Laser Jet Tech (Eyeplus) |
| Vendor LPO (dropdown) | Which LPO was this against? | LPO-2026-001 |
| Vendor Invoice No | The vendor's bill number | EYE/INV/2026/0342 |
| Vendor Invoice Date | Date on the vendor's bill | 2026-04-08 |
| Amount + GST + Total | Cost breakdown | ₹25,000 + ₹4,500 = ₹29,500 |
| Payment Status | UNPAID / PARTIAL / PAID | UNPAID |
| Status | RECEIVED / RETURNED / CANCELLED | RECEIVED |
The "Payment Status" field on a Purchase (UNPAID / PARTIAL / PAID) is just a summary. It tells you whether a bill is settled, not when, how much, by which mode, from which bank, or which cheque number. Those facts must live as their own records under Payments. Here's why merging them breaks the books:
| Scenario | What happens | Why one row won't work |
|---|---|---|
| 1. Bill today, pay later | Goods received 10-Apr (Vendor Invoice EYE/INV/2026/0342, ₹29,500). Cheque issued 25-Apr. | For GST input credit, the purchase must be booked on 10-Apr (vendor's invoice date). The payment record lives 15 days later. One row can't have two dates that mean different things. |
| 2. One bill, many payments | ₹1,00,000 vendor bill paid in three instalments: ₹30k (5-Apr), ₹30k (20-Apr), ₹40k (10-May). | One Purchase row, three Payment rows. The purchase shows status PARTIAL after the first two, then PAID after the third — auto-derived from the linked payments. |
| 3. One payment, many bills | Single ₹2,00,000 cheque clears 3 vendor bills (Bills #340, #341, #342) at month-end. | One Payment row references three Purchases. If you merged them, you'd have to duplicate the same cheque number across three rows — bank reconciliation breaks. |
| 4. Advance before goods | Pay ₹50,000 advance to a vendor on 1-Apr; goods arrive 15-Apr with vendor's bill. | A Payment can exist without a Purchase yet. If both lived on the same row, you couldn't record the advance until the goods came in. |
Formal payments to vendors — bank transfers, cheques, etc. Go to Transactions → Payments.
| Field | What It Means | Example |
|---|---|---|
| Payment Date | When the payment was made | 2026-04-15 |
| Business Unit | Epic Inc or Kalyteri | Epic Inc |
| Expense Category | DIRECT / INDIRECT / ADMIN / ASSET | DIRECT |
| Expense Head (dropdown) | Auto-fills category when selected | Device Maintenance |
| Vendor (dropdown) | Who did we pay? | JJ Electronics |
| Vendor LPO (dropdown) | Which LPO is this payment against? | LPO-2026-001 |
| Purchase (dropdown) | Which purchase is this paying for? | EYE/INV/2026/0342 |
| Amount + GST | Payment amount | ₹45,000 + ₹8,100 |
| Payment Mode | CASH / BANK / UPI / CHEQUE / PETTY_CASH | BANK |
| Reference No | Cheque no., NEFT/RTGS UTR, UPI txn id | UTR2026041500342 |
| Bank Account | Which bank account the money left from | ICICI —XXXX1234 |
| Status | PENDING / APPROVED / REJECTED | PENDING |
CASH for petty cash spending, BANK for NEFT/RTGS, UPI for GPay/PhonePe/BHIM, CHEQUE when a cheque is issued, PETTY_CASH for the petty-cash float. Reference No should hold the cheque number, UTR, or UPI transaction id so it can be matched on the bank statement later.
Track your rental device fleet under Transactions → Assets. Each device gets an auto-generated code like EPIC-LT-001.
| Field | What It Means | Example |
|---|---|---|
| Asset Code | Auto-generated: BU-TYPE-SEQ | EPIC-LT-001 |
| Asset Type (dropdown) | From Asset Types master | Laptop (LT) |
| Serial No | Manufacturer serial number | 5CG9128MSJ |
| Product (dropdown) | Specific product model | Refurbished Dell i7 Laptop |
| Purchase Cost | What we paid for it | ₹25,000 |
| Status | IN_STOCK / RENTED / UNDER_REPAIR / REPLACED / SOLD / RETIRED / LOST | RENTED |
| Current Client | Who has it right now? | HUL Device Rentals |
| Current Contract | Which contract it's assigned to | EPIC/RNT/0032/24-25 |
Asset Journey (Transactions → Asset Journey) tracks the full lifecycle of each device — which client had it, under which contract/PO, and for how long. This enables ROI calculation per device.
The top part of the sidebar has dashboard screens that visualise your data automatically. Below is an overview — each section is explained in detail further down.
| Screen | What It Shows | Where Data Comes From |
|---|---|---|
| 🧾 Invoices | All bills we've sent to clients | Invoices + Invoice Items tables |
| ⏳ Receivables | Money clients still owe us, sorted by how old the bill is | Calculated from Invoices − Receipts |
| 📋 Contracts | Active agreements with clients — shows which quarter we're in | Contracts table |
| 💸 Expenses | Where our money is going, broken down by vertical | Vendor Payments table |
| ↕️ Cash Flow | Total money IN vs money OUT — the company's lifeline | Receipts + Expenses |
| 📟 Assets & Rentals | Devices we own, their status, and rental income they generate | Assets + Device Rental invoices |
| 💼 Service Income | Monthly service-fee income from facilitating client orders | Service Income (commission_transactions) table |
Every section on the dashboard exists for a reason. Here's what each one tells you and why it matters for the business.
What it shows: Every bill EPIC has sent to clients — invoice number, date, client name, vertical, net amount, amount received, outstanding balance, and payment status (PAID / PARTIAL / DUE / HOLD).
Why it matters:
Business implication: If invoices are not raised on time, the company appears to have lower revenue than it actually earns. Late invoicing also means late payments — clients won't pay if they haven't received a bill. The MD uses this screen to check: "Have we billed everyone we should have billed this month?"
| Field | What It Means | Example |
|---|---|---|
| Invoice No | Unique bill number (for GST filing) | EPIC-412-25-26 |
| Client (dropdown) | Who are we billing? | Danieli India |
| Vertical (dropdown) | Which business line? | Product Supplies |
| Contract (dropdown) | Against which contract/PO? | CNT-DAN-FY26 |
| Gross / GST / Net | Base amount + tax = total bill | ₹4,10,000 + ₹73,800 = ₹4,83,800 |
| Status | PAID / PARTIAL / DUE / HOLD / CANCELLED | DUE (client hasn't paid yet) |
What it shows: Money that clients owe EPIC, sorted by how old the unpaid invoice is. Displayed as an ageing chart (0-30 days, 31-60, 61-90, 90+ days) and a detailed table of overdue invoices.
Why it matters:
Business implication: This is the MD's early warning system. If the 90+ days bucket keeps growing, it means EPIC has a collection problem. The MD can decide to: stop further work for that client until they pay, escalate to senior contacts, or negotiate a payment plan. Ignoring ageing receivables leads to bad debts — money that's never recovered.
What it shows: All active contracts with clients — contract number, client name, vertical, billing amount, billing frequency, current contract quarter, and validity period.
Why it matters:
Business implication: Contracts are the backbone of Device Rentals, AMC, and many Product Supply deals. Missing a billing cycle means delayed revenue. If a contract expires without renewal, that client's revenue drops to zero. The MD uses this screen to answer: "How many contracts are active? Which ones are expiring soon? Are we billing on schedule?"
| Field | What It Means | Example |
|---|---|---|
| Contract No | Unique contract reference | CNT-DAN-FY26 |
| Client + Vertical | Who and which business line | Danieli — Product Supplies |
| Billing Amount | How much to invoice each cycle | ₹4,85,000 per quarter |
| Billing Frequency | How often we bill | QUARTERLY |
| Start / End Date | Contract validity period | 01-Apr-2025 to 31-Mar-2026 |
| Contract Quarter | Which quarter of the contract we're in (auto-calculated) | Q4 |
What it shows: All money EPIC spends — broken down by vertical (horizontal bar chart), by category (donut chart showing DIRECT / INDIRECT / ADMIN), and a detailed table with GST breakup.
Why it matters:
Business implication: The MD watches the expense-to-revenue ratio closely. A healthy company keeps expenses at 20-30% of revenue. If expenses creep toward 40-50%, margins shrink and the company has less cash to invest or pay dividends. This screen answers: "Where is our money going? Are we spending too much on any vertical? Is overhead growing out of control?"
What it shows: The simplest and most important view — total money IN (collections from clients) vs total money OUT (all expenses including GST), and the Net Cash Position (the difference).
Why it matters:
Business implication: The MD checks this to decide: "Can we afford to buy new equipment? Can we hire more staff? Should we chase collections more aggressively?" A negative net cash position means the company needs to either speed up collections or slow down spending. Banks and investors also look at cash flow to assess the company's health.
What it shows: Three things: (1) Asset status donut — how many devices are RENTED, IN STOCK, UNDER REPAIR, or REPLACED. (2) Monthly rental revenue trend. (3) Rental totals — subtotal, GST, and total invoice value from device rentals.
Why it matters:
Business implication: Device Rentals is a capital-intensive vertical — EPIC buys devices upfront and earns back the investment over months of rental income. The MD uses this screen to track ROI: "How quickly are we recovering our device investment? Do we need to buy more devices to meet demand? Are too many devices sitting idle?" A growing rental revenue trend with high utilisation is a sign of a healthy rental business.
What it shows: Monthly service-fee income earned from facilitating client orders. The chart shows EPIC's 10% service fee — the net amount EPIC keeps from each transaction.
How service-fee revenue works:
Why it matters:
Business implication: The MD uses this to track: "Is our facilitation volume growing month over month? Which clients are driving the most service income? Should we invest more in this vertical since it's capital-free?" Service Income is also a pipeline for other verticals — clients who start here often move to Device Rentals or Product Supplies later.
| Field | What It Means | Example |
|---|---|---|
| Transaction Date | When the transaction happened | 2026-03-10 |
| Client (dropdown) | Which client's order we facilitated | HUL Chennai |
| Vertical (dropdown) | Always "Service Income" | Service Income |
| Gross Amount | Total order/transaction value | ₹7,50,000 |
| Service Rate | EPIC's cut (usually 10%) | 10.00 |
| Service Amount | What EPIC earns (10% of gross) | ₹75,000 |
| Net Settlement | Amount paid out to client (90%) | ₹6,75,000 |
| Transaction Type | CLIENT_ORDER or CASH_TO_ONLINE | CLIENT_ORDER |
| Status | COMPLETED or PENDING | COMPLETED |
What it shows: Every payment received from clients. Each receipt is automatically linked to the invoices it covers through the Smart Receipt Form.
Why it matters:
Business implication: Missing receipt entries make the dashboard show inflated receivables (money owed). This gives the MD a wrong picture — they might chase a client for payment that's already been received. Always record receipts immediately when payment hits the bank.
What it shows: Written orders from clients confirming they want to buy from EPIC. POs are the legal backing for invoices.
Why it matters:
Every table — whether under Transactions or Master Data — works the same way. Learn one, you know them all.
1. Click a table in the sidebar under Transactions or Master Data (e.g., "Clients" or "Invoices")
2. Click the green Add New button at the top-right of the table
3. A popup form appears. Fill in the fields:
Click anywhere on a row to open the read-only View panel. It shows all fields with FK references resolved to human-readable names.
Click the three-dot menu (⋮) on the left side of any row, then select Edit. The form appears pre-filled with current values. Change what you need and click Update.
The three-dot menu (⋮) has two options for removing records:
| Action | What Happens | Can Undo? |
|---|---|---|
| Cancel | Sets status to CANCELLED or INACTIVE. Record stays in the database and appears in historical reports. | Yes — just change the status back |
| Delete | Permanently removes the record from the database. Double confirmation required. | No — gone forever |
In any CRUD table, names shown in green with a dashed underline are linked records. Hover over them to see a quick preview popup showing key details from the linked table — without leaving the current screen.
CRUD tables show only the most important columns in the list view to keep things clean and readable. Click View on any row to see all fields in a popup. Click Edit to modify all fields in a form. The list is your quick glance — the detail view is where you see everything.
Save yourself time by avoiding these.
Wrong: Trying to add a Client Location before adding the Client.
Right: Set up Master Data first (Business Units → Verticals → Vendors → Products → Clients → Locations → Client Verticals), then enter Transactions.
Client = someone who pays us (we sell/rent to them)
Vendor = someone we pay (we buy from them)
The same company can be both! But add them in both tables separately.
Buying a laptop to rent out = ASSET (capital purchase, not a regular expense)
Repairing a rented laptop = DIRECT (regular business expense)
Paying office electricity = INDIRECT
Paying the accountant = ADMIN
After adding a new client, always link them to their verticals. Otherwise, reports won't include that client in the right vertical breakdown.
When adding a new record, make sure Status is set to ACTIVE. Some forms might default to a different value.
Print this page or keep it open in a tab for easy reference.
| # | What to Set Up | Where in Sidebar | How Many | How Often |
|---|---|---|---|---|
| 1 | Business Units | Master Data → Business Units | Usually 2-3 | Rarely (one-time) |
| 2 | Verticals | Master Data → Verticals | 4 (fixed) | Almost never |
| 3 | Expense Heads | Master Data → Expense Heads | 12+ | When new expense types arise |
| 4 | Asset Types | Master Data → Asset Types | 12 (LT, DT, PR, etc.) | When a new device category is needed |
| 5 | Vendors | Master Data → Vendors | As needed | When we start buying from someone new |
| 6 | Products & Services | Master Data → Products & Services | As needed | When we start selling/renting something new |
| 7 | Clients | Master Data → Clients | As needed | Every time we get a new client |
| 8 | Client Locations | Master Data → Client Locations | 1+ per client | When client has a new branch/office |
| 9 | Client Verticals | Master Data → Client Verticals | 1+ per client | Every time after adding a new client |
These are the tables the admin/finance team uses regularly. Data entered here drives all the dashboard charts and reports.
| # | Transaction | Where in Sidebar | Who Does It | How Often |
|---|---|---|---|---|
| 1 | Contracts | Transactions → Contracts | Admin / Finance | When a new deal is signed |
| 2 | Invoices | Transactions → Invoices | Finance | Monthly / as per billing cycle |
| 3 | Receipts | Transactions → Receipts | Finance | When client payment hits bank |
| 4 | Petty Cash | Transactions → Petty Cash | Admin / Ops | Daily — small cash expenses |
| 5 | Purchases | Transactions → Purchases | Admin / Finance | When goods received from vendor |
| 6 | Payments | Transactions → Payments | Finance | When vendor is paid (bank/cheque) |
| 7 | Service Income | Transactions → Service Income | Admin | Each facilitation transaction |
| 8 | Assets | Transactions → Assets | Admin | When devices are bought / status changes |
| 9 | Asset Journey | Transactions → Asset Journey | Admin | When a device moves to a new client |
| 10 | Vendor LPOs | Transactions → Vendor LPOs | Admin | When placing order with vendor |
| 11 | Credit Notes | Transactions → Credit Notes | Finance | When corrections are needed |
| Term | Plain English |
|---|---|
| Invoice | A bill we send to a client saying "please pay us ₹X" |
| Credit Note | A document that reduces an invoice amount — issued when we overcharged, client returned goods, or there's a billing error. It lowers what the client owes us. |
| Receipt | Proof that a client has paid us money. The Smart Receipt form auto-links payments to invoices and tracks TDS. |
| Petty Cash | Small day-to-day cash expenses (courier, auto fare, fuel). Tracked separately from formal vendor payments. |
| Purchase | Goods received from a vendor with their bill — captures vendor invoice number for GST input credit. Not the same as payment. |
| Payment (Vendor) | Formal money transfer to a vendor/supplier. Links to a Purchase or LPO. Starts as PENDING, needs approval. |
| Vendor LPO | Local Purchase Order — an order we raise to a vendor to buy goods/services. |
| Asset Journey | History of which client had a device, under which contract/PO, and for how long. Used for ROI calculation. |
| Asset Code | Auto-generated unique tag for each rental device: BU-TYPE-SEQ (e.g. EPIC-LT-001 = Epic Inc, Laptop, #001). |
| Outstanding | Money a client still owes us (bill sent but not yet paid) |
| Receivable | Same as outstanding — money we're waiting to receive |
| P&L (Profit & Loss) | Revenue minus Expenses = Profit (or Loss if negative) |
| GST | Goods & Services Tax — 18% tax added on top of the base price |
| TDS | Tax Deducted at Source — when a client deducts tax before paying us. Captured automatically in the receipt form. |
| PO (Purchase Order) | A written order from a client confirming they want to buy from us |
| AMC | Annual Maintenance Contract — yearly deal to maintain equipment |
| HSN / SAC | Government codes to classify products (HSN) and services (SAC) for tax |
| PAN | Permanent Account Number — tax ID card for individuals/companies |
| Ageing | How many days old an unpaid invoice is (0-30 days is OK, 90+ days is trouble) |
| Vertical | A business line / revenue stream (Device Rentals, Product Supplies, etc.) |
| Business Unit (BU) | A company entity (e.g. Epic Inc or Kalyteri Enterprises) |
| Inflow | Money coming IN (payments from clients) |
| Outflow | Money going OUT (our expenses and purchases) |
| Net Cash | Inflow minus Outflow — how much cash we actually have |
| ACTIVE / INACTIVE | ACTIVE = currently in use. INACTIVE = archived (but still in system) |
| Cancel vs Delete | Cancel sets status to CANCELLED (reversible, stays in DB). Delete permanently removes the record (irreversible, double confirmation required). |
Reach out on WhatsApp and we'll help you right away.