Sales, Customer & Collection Management System

An integrated system for managing customers, invoices, products, and receipts, with data-entry forms, balance and statement reports, and a dashboard for monitoring sales and collections.

An integrated sales, customer, and collection management system built with Google Sheets and Google Apps Script, designed to manage daily operations through an organized and user-friendly interface. It includes four data-entry forms for managing customers, invoices, products, and receipts, with save, edit, delete, search, and print functions. The system provides four main reports for customers, products, invoices, and receipts, along with balance reports and customer statements for monitoring transactions and payments. The dashboard tracks key metrics including total sales, collections, collection rate, top customers, and top-selling products, providing a clear view of business performance. It brings sales and collection operations, reporting, and performance analysis together in one centralized and easy-to-manage solution. Technologies: Google Sheets · Google Apps Script · Dashboard