TOURMALINE

πŸ–₯️ Description

Tourmaline is a comprehensive point-of-sale solution developed in Visual Basic, Excel, and SQL, ideal for small and medium-sized stores that need to control their operations without relying on expensive systems.
This program efficiently manages inventory, generates receipt-style invoices, creates quotes, records product entries and exits, handles exchanges or returns, and maintains up-to-date customer and product databases.

It also includes tools for cash register balancing, expense tracking, and a powerful automatic report generator, offering a detailed view of sales, inventory movements, and cash flow.

Thanks to its user-friendly interface and Excel-based implementation, Tourmaline easily adapts to any business, eliminating manual errors, saving time, and facilitating decision-making with clear, real-time data.

It is the perfect tool for entrepreneurs who want to professionalize their store without losing control over their daily operations.

🧰 Technologies Used

  • Advanced Excel
  • Visual Basic for Applications (VBA)
  • SQL for integrated database management
  • Integration with 80mm receipt printers

πŸ“ˆ Program Impact

With Tourmaline, merchants can reduce errors, streamline processes, and have full control of their store with a tool that is adaptable, fast, and accessible. It does not require a constant internet connection and can run on any PC with Excel, making it ideal for traditional stores looking to digitize without complications.

πŸ—ƒοΈFeatures

🧾 Billing

80mm receipt-style invoices ready for printing

πŸ“¦ Inventory Management

Product entries, exits, exchanges, returns, and reference-based control

πŸ“‹ Quotations

Automatic generation of itemized quotations

πŸ’΅ Cash Register Balancing

Control of income, expenses, and cash register closing

πŸ‘₯ Customer Database

Complete record of frequent customers and contact details

πŸ“Š Automatic Reports

Dynamic sales, inventory movement, and statistics reports in Excel

πŸ“ Expense Control

Registration and categorization of expenses