Account Reporting Tracker
A shared tracker for account managers. Each update entered on the form is sent to the internal database, a master log file and a separate file for every customer, and it works on both Windows and Mac.
- Industry
- Food & Beverage Brokerage
- Deliverable
- Account Reporting Master.xlsm
- Built with
- Excel VBA, File automation
More like this
Related projects
Hotel & Restaurant Management System
Hospitality
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu…
View project
Trade Opportunity Finder & Profitability Analysis
International Trade
A database-driven tool for an import and export business. Products, suppliers, clients and prices are added through forms, and sales simulations calculate landed cost, truck loading…
View project
Invoice Generator with Customer & Product Database
Wholesale Distribution
An invoicing system for a skincare wholesaler. Invoices are created from customer and product databases, saved, searched, reloaded and printed, and a best-selling report is updated…
View project