19/12/2025
π Custom Excel VBA Dashboards & Automated Systems π
Delivering Real Business Insights with Smart Automation
Proud to share one of my latest Sales Performance Dashboards, developed using Excel VBA with full automation and interactive visuals.
β
Dashboard Highlights:
πΉ Sales, Collection & Revenue Performance Tracking
πΉ KPI Speedometers (Actual vs Target)
πΉ Mobile & Fixed Category Analysis
πΉ Customer & Solution-based Filtering
πΉ Automated Calculations & Reports
πΉ Clean, Professional & Decision-Ready Design
π― System Capabilities:
β Automated data processing
β User-friendly interface
β Custom business logic
β Scalable & fully customizable
β Designed for real corporate usage
π Happy Customer
Special thanks to Mr. Wansanath Asmadala
Corporate Account Manager β Dialog Axiata
for trusting me and selecting me to develop this customized dashboard solution.
πΌ I Develop Custom Excel VBA Solutions For:
π’ Corporates
πͺ Retail & Sales Teams
π½ Restaurants
π Finance & Operations
π‘ If your business still depends on manual Excel work, I can transform it into a fully automated dashboard or system tailored exactly to your workflow.
π© Inbox me Roshen Hadji
π± Contact me : 0777 754 249 today to discuss your requirement
π Custom Excel VBA Dashboards | Automation | Business Systems
β¨ Your data. Your rules. Your dashboard.
10/12/2025
π Food Wastage & Sales KPI Dashboard along with a Fully Automated Management System for Big Plate Restaurant.
Iβm excited to share that I have designed and implemented a fully functional Food Wastage & Sales Analysis System with advanced automation and analytics features.
β
Key Features of the System:
β‘οΈ Secure User Login System
β‘οΈ Automatic Daily Backups
β‘οΈ POS Daily Sales Importing (fully automated)
β‘οΈ Daily Loading, Stock-Out & Closing Stock tracking
β‘οΈ Accurate Food Wastage by food category & date range
β‘οΈ Top Demand Items identification
β‘οΈ Sales Category Analysis
β‘οΈ Top Menu Item Sales
β‘οΈ Top Item Category Analysis
β‘οΈ Period Purchase vs Sales Comparison
β‘οΈ Top Profitable Menu Items
β‘οΈ Highest Cost Menu Items
β‘οΈ Fully automated Dashboard with interactive visuals
With over 10 years of experience in building Excel VBA systems and dashboards for individuals and major companies, I have developed many enterprise-level solutions such as:
β Payroll systems
β Cheque printing systems
β SVAT voucher printing systems
β Credit management systems
β Stock management systems
β Receipt management systems
β Document control dashboards
β And many moreβ¦
π’ Iβve worked with reputed Sri Lankan companies, including:
π― London Stock Exchange Group (LSEG)
π― Access Engineering PLC
π― Hambantota International Port Group (HIPG)
π― Sri Lanka Co-operative Marketing Federation Ltd (Markfed)
π― CodeGen International (Pvt) Ltd
π― George Steuart & Company Ltd
π― Teejay Group
π― Jiffy Group
π― Venture Tea (Pvt) Ltd
π― Botanicoir Lanka
π― Enrich Tea & Food Exports (Pvt) Ltd
π― Marina Square Colombo
π― Amila Transport & Logistics
π― And many moreβ¦
π₯ If you are an individual or company employee looking to achieve your monthly targets and monitor:
β¨ Sales
β¨ Collections
β¨ Revenue
β¨ Funnels
β¨ Commission
β¨ New subscriptions
I also develop a custom KPI Dashboard System, specially designed for Area Managers (e.g., Dialog Axiata PLC).
π© If you want to develop any type of professional customized system or dashboard using Excel VBA, feel free to contact me. today!
π 077 775 4249
19/06/2025
SVAT Voucher Printing System; A powerful, Excel VBA-based tool designed to simplify and accelerate your SVAT voucher processes.
03/07/2023
Advanced Excel Training Program conducted for Mr. Nishantha Illangasinghe, Finance Manager.
This Advanced Excel Training Program is designed specifically for beginners, intermediate and advance users who want to develop their skills in Microsoft Excel.
This training program provides you a hands on Microsoft Excel experience which assist you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool thus taking your career to the next level by differentiating themselves quickly and dramatically.
While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.
By the end of the course you'll be writing robust, elegant formulas from scratch, allowing you to:
- Easily build dynamic tools & Excel dashboards to filter, display and analyze your data.
- Create your own formula-based Excel formatting rules.
- Join datasets from multiple sources with XLOOKUP, OFFSET, INDEX & MATCH functions.
- Manipulate dates, times, text, and arrays.
- Automate tedious and time-consuming tasks using cell formulas and functions in Excel.
I'll dive into a broad range of Excel formulas & functions, including:
- Count and Sum Functions
- Logical Functions
- Date & Time Functions
- Text Functions
- Lookup and Reference Functions
- Round Functions
- Formula Errors
- Names in Formulas
- Data Validation
- Pivot Table
- Conditional Formatting
- Advanced Filter
- Excel VBA & Macros
- Excel VBA Programs and Dashboards
If you're looking for the ONE course with all of the advanced Excel formulas and functions that you need to know to become an absolute Excel rockstar, you've found it.
Further, I will conduct customize workshops based on Cooperate requirements.
See you in the course!
For Inquiries, Call me.
Roshen Hadji: 0777754249
22/06/2023
Successfully implemented a Cheque Printing System for Jiffy Products Sri Lanka Private Limited at Mirigama Export Zone.
Thank You for being our esteemed customer.
Your support and trust in us are much cherished.
Your satisfaction is our first priority.
Thank You Once Again !!!
For inquiries, please contact:
Roshen Hadji : 077 775 4249
21/06/2023
Successfully implemented a Sales and Inventory Management System for R&T Ref Engineering at Angoda.
Thank You for being our esteemed customer.
Your support and trust in us are much cherished.
Your satisfaction is our first priority.
Thank You once again !!!
For inquiries, please contact:
Roshen Hadji : 077 775 4249
16/06/2023
Successfully implemented a Cheque Printing System for AMILA Transport and Logistics at Siyambalape
is an Excel VBA based cheque printing system with a user friendly interface and easy data inputting methods. This system ensures the accuracy of the cheque data and reduces errors that could be caused by manual cheque writing.
Thank You for being our esteemed customer.
Your satisfaction is our first priority.
Thank You once again !!!
For inquiries, please contact:
Roshen Hadji : 077 775 4249
29/05/2023
Another CCTV project sucessfully completed for a valuable client in Dematagoda.
8CH Turbo.
2mp HD color camera.
with receivers.
access with SLT Fiber connection.
Thank You for being our esteemed customer.
Your support and trust in us are much cherished.
Your satisfaction is our first priority.
Thank You once again!
For inquries, please contact:
Roshen Hadji : 077 775 4249
Roy Saidi : 077 650 5747
23/05/2023
SVAT Voucher Printing System Review
SVAT voucher printing system is a system that simplifies and eases the struggle of printing SVAT
vouchers using templates. This Excel VBA-based work system uses a very user-friendly GUI
(graphical user interface) and ensures an efficient and accurate printing of SVAT vouchers.
Call for Price : Roshen Hadji 0777754249
SVAT Voucher Printing System Review
page: https://www.facebook.com/excelbusinesssolution/SVAT voucher printing system is a system that simplifies and eases the struggle of printing SVA...