Skip to content

A full-featured accounting system built entirely in Excel with VBA, including login authentication, sales, quotes, invoices, client tracking, and inventory management.

Notifications You must be signed in to change notification settings

aliqayid/ExcelAccountingSystem

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

6 Commits
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

Excel Accounting System

This is a fully integrated accounting system built using Microsoft Excel and VBA macros. The file simulates a desktop application with a secure login screen, navigation menus, and functional modules for managing core accounting operations.

๐Ÿ’ก Features

  • ๐Ÿ” User Login & Authentication
  • ๐Ÿงพ Sales Module
  • ๐Ÿ’ผ Quotations Generator
  • ๐Ÿงฎ Invoice Management
  • ๐Ÿ‘ฅ Clients & Account Statements
  • ๐Ÿ“ฆ Inventory Tracking
  • ๐Ÿ“Š Custom Excel dashboards & reports

๐Ÿ“‚ File Structure

-## ๐Ÿ–ผ๏ธ ู…ุนุงูŠู†ุฉ ุงู„ุตูˆุฑ

ุดุงุดุฉ ุชุณุฌูŠู„ ุงู„ุฏุฎูˆู„:

Login Screen

ุงู„ูˆุงุฌู‡ุฉ ุงู„ุฑุฆูŠุณูŠุฉ:

Dashboard

๐Ÿ“ฅ ุชุญู…ูŠู„ ุงู„ู…ู„ู

ูŠู…ูƒู†ูƒ ุชุญู…ูŠู„ ุงู„ู…ู„ู ู…ู† ู‡ู†ุง:

๐Ÿ“Ž ุชุญู…ูŠู„ ู…ู„ู Excel ุงู„ู…ุญุงุณุจูŠ

๐Ÿš€ How to Use

  1. Open the .xlsm file in Microsoft Excel (2016 or later).
  2. Enable macros when prompted.
  3. Log in using the default credentials:
    • Username: admin
    • Password: admin (you can change this later)
  4. Use the buttons in the main interface to navigate through the system.

๐Ÿ›  Requirements

  • Microsoft Excel 2016 or later
  • Macros must be enabled
  • Windows OS is recommended for full VBA compatibility

๐Ÿ” Security Note

This file uses simple VBA for demonstration purposes. For production or sensitive data, consider implementing advanced encryption and secure database integration.

๐Ÿ“ƒ License

This project is shared for educational purposes only. Not intended for commercial use without permission.


Feel free to fork, enhance, or adapt it for your own business logic or client needs!

About

A full-featured accounting system built entirely in Excel with VBA, including login authentication, sales, quotes, invoices, client tracking, and inventory management.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors