The JEDA Complete Business Toolkit - Sales & Inventory Management System (Advanced) + Simple Bookkeeping Template

Two powerful Excel tools for small business owners who sell physical products. Track your finances and manage your stock automatically, in any currency, with no monthly subscription. Over 50% off for the first 50 orders.

The JEDA Complete Business Toolkit Combo bundles two of our most powerful Excel tools into one package because every product-based business needs both.

Built by a Chartered Accountant . Designed for small business owners across Africa. Ready to use the same day you purchase.

TEMPLATE 1 - JEDA SmartExcel Simple Bookkeeping Template

This is your complete financial record-keeping system in one Excel file.

You enter your daily income and expenses. The template automatically produces your Profit and Loss Statement, Cash Flow Statement, VAT summary, and a live financial dashboard without you touching a single formula.

What it covers:

- Income sheet - every sale recorded with date, category, reference, payment method, and VAT

- Expenses sheet- 18 pre-set expense categories that auto-populate from a dropdown

- Receivables - track every customer invoice, balance outstanding, and days overdue. Overdue invoices flagged automatically

- Payables - track every supplier bill, amount paid, and balance owed

- Profit and Loss -auto-calculated monthly and year-to-date figures

- Cash Flow - actual money in and out, opening and closing balance every month

- VAT sheet - VAT collected, VAT paid, and net VAT payable calculated automatically

- Invoice sheet -professional invoices with auto-calculated subtotals, VAT, and totals

- Dashboard - live KPI cards showing total income, expenses, net profit, and cash balance with monthly charts

13 sheets. Fully automatic. Works in any currency.

TEMPLATE 2 - Sales and Inventory Management System Advanced Version 2.0

This is your complete sales and stock management system in one Excel file.

Whether you operate one location or three, this system tracks every product, every sale, every return, and every reorder point automatically.

What it covers:

- Product Catalogue - up to 250 plus products with cost price, selling price, VAT rate, and auto-calculated gross margin

- Sales Log -every sale recorded with product, quantity, discount applied, payment method, VAT, and profit per transaction

- 3-Location Inventory Tracking - manage stock levels across up to three branches or warehouses simultaneously

- Reorder List - automatically flags every product that has dropped below your set reorder point across all locations. No more running out of your best sellers

- Returns Log - customer returns recorded separately from sales with reason tracking

- Purchase Orders - generate and track supplier orders with expected delivery dates

- Payables Tracker - supplier bills, amounts paid, and outstanding balances

- VAT Return - VAT collected on sales and VAT paid on purchases calculated automatically

- Monthly Sales Report - revenue, units sold, top products, and profit summary by month

- P&L Summary - profit and loss calculated from your sales and cost data

- Dashboard - live overview of total revenue, total profit, stock value, and units sold with low stock alerts highlighted in colour

Advanced version. 15 sheets. Handles up to 250 plus products. Works in any currency.

What you get when you purchase:

- Both Excel template files delivered to your email immediately

- A step-by-step video tutorial linked on the Home sheet of each file

- Access to a WhatsApp support group

- Email support jedaacc17@gmail.com

- Lifetime access no subscription, no renewal fee

Who this is for:

- Shop owners and retailers managing products across one or more locations

- Distributors and wholesalers tracking stock and sales volume

- Market traders who want to move from manual records to a proper system

- Any small business owner who sells physical products and needs both financial records and stock management in one setup

Who this is NOT for:

- Businesses that do not sell physical products (use our Simple Bookkeeping Template only)

- Businesses looking for accounting software this is an Excel-based system, not a SaaS product

- Businesses that need multi-user cloud access this is a single-user desktop Excel file

Requirements:

Microsoft Excel 2016 or newer. Works on Windows, Mac and Microsoft 365 excel online . Does not require internet connection after download. No VBA or macros in the bookkeeping template. Advanced Inventory System uses basic Excel functions only.

The launch offer:

The first 50 orders are priced at over 50% off the regular price. Once the 50th order is placed, the price returns to the standard rate permanently. The discounted price is applied automatically at checkout no code needed.

Frequently asked questions:

Can I use this if I am not based in Nigeria?

Yes. Both templates work in any currency. You set your currency symbol once in the settings and every sheet updates automatically. The tools are used by business owners across Nigeria, Ghana, Kenya, South Africa, and beyond.

Do I need accounting knowledge to use this?

No. Both templates are designed for business owners, not accountants. Every sheet is clearly labelled, dropdowns guide your entries, and a video tutorial walks you through each feature step by step.

What happens if I get stuck?

WhatsApp support is available directly from the JEDA team. Message +234 815 689 1086 and we will help you get set up.

Can I share this with my accountant?*

Yes. You can share the file with your accountant or bookkeeper. The purchase covers one user licence.

What if I only need one template?*

Both templates are also available separately. The combo gives you both at over 50% off the combined individual prices. If you only need one, message us and we will point you to the right listing.