Custom CRM & Inventory Tracker

I need a single, easy-to-use system that lets me enter, view, and analyse three core data sets for my Rice Mill: inventory, financial figures, and customer information. At the moment I juggle separate spreadsheets and it is slowing decisions down, so the goal is to consolidate everything into one place—whether that ends up being a well-structured Excel/Google Sheets file with scripts or a lightweight web-based CRM you build from scratch or adapt from an open-source platform.

Key functions I cannot compromise on are:
• Reporting & analytics that convert raw numbers into clear dashboards and printable summaries.
• Automated data entry wherever repetitive input can be eliminated (think drop-downs, lookups, or API pulls).
• Smooth data import/export so I can back-up or migrate records without a headache.

Only I will be logging in, so user-level complexity and multi-role permissions are unnecessary; instead, speed and clarity of the interface matter most. If you propose database or cloud solutions, please keep hosting and maintenance straightforward.

Deliverables I expect:
1. A working file or deployable app containing the three data modules.
2. Step-by-step documentation or a short video walkthrough covering how to add records, run reports, and export data.
3. A brief hand-off session for real-time Q&A.

Feel free to recommend the tech stack you believe best fits the scope—Excel VBA, Google Apps Script, Airtable, or a small custom web app with MySQL/NoSQL are all acceptable if they meet the requirements.