Development of a Professional E-commerce ERP & Financial Tracking System in Google Sheets (Audicstore)

@marjanahmed13

Hi! My name is Marjan and I'm here to offer you my services as a skilled applicant with over a decade of experience working on Freelancer.com. l believe I am the best fit candidate for this project due to my extensive experience; I would like to have a discussion to get to know that we both are on the same page. Once the scope will be locked, I will start working on it right away.

@NoorUlHudaXZT

Hi, I will develop a custom E-commerce ERP & Financial Tracking System in Google Sheets for Audicstore. The system will feature Advanced Inventory Management, Dynamic Sales Tracking with Gateway Fee Automation, Complex Shipping Logic, Returns & Refund Management, and an Automated Financial Dashboard for real-time insights. With expertise in PHP, JavaScript, MySQL, and Google Sheets, I will ensure accurate data visualization, financial modeling, and seamless automation. I'm excited to bring efficiency and profitability to Audicstore. Let's discuss how to tailor the solution to your specific needs further. Best regards, Noor

@Tacticssoft

Hello, I can develop a fully automated Google Sheets ERP system for Audicstore using advanced formulas and Google Apps Script to accurately track inventory, sales, logistics, and real-time Net Profit/Loss. The system will include weighted average inventory costing, automated payment gateway fee calculations (Tabby, Tamara, ZidPay), and a dynamic shipping engine with VAT and city/weight-based cost logic. I will also implement returns and refund tracking, low-stock alerts, and a live financial dashboard with charts and top-selling product insights. Everything will remain fully editable so you can easily update gateways, costs, cities, inventory batches, and other settings whenever needed. I will also provide a simple guide explaining how to import sales data and manage the system smoothly. Thanks & Regards Tacticssoft

@anirudhat

Building a multi-module ERP system in Google Sheets with Apps Script is exactly the kind of project I specialize in — I've built similar inventory-to-profit tracking systems for e-commerce operators and understand the nuance of weighted average costing across mixed supplier batches. For Audicstore, I'll architect interconnected sheets for Inventory, Sales, and Shipping, powered by custom Apps Script functions that dynamically calculate WAC per SKU, auto-apply gateway fees (Tabby 6.5%, Tamara 7%, ZidPay 2.5%+1 SAR) via dropdown-driven logic, and run your tiered shipping engine with Roadlink's city-based rates plus 15% VAT — all feeding into a real-time Net Profit/Loss dashboard. The system will be fully editable and extensible, so adding future payment gateways or adjusting shipping tiers requires zero code changes. I'm available to start immediately.

@sareheshak

السلام عليكم ,,,,,,,,,,,,,,,,,,,, I can build a fully automated Google Sheets ERP for your store to manage inventory, sales, shipping logic, returns, and a real-time P&L dashboard, using advanced formulas and Apps Script automation for dynamic updates and accurate profit calculations. The system will support weighted average costing, gateway fee automation, complex shipping rules, VAT handling, and editable logic so you can easily adjust rates, gateways, or products in the future. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA

@alkadevi

Hello, I’d be happy to help take your website from concept to a fully polished, live launch. My approach focuses on combining clean design, thoughtful UX, and reliable development so the final site not only looks modern but also guides visitors toward the actions that matter most. What I will deliver: • A modern, responsive design that works seamlessly across desktop, tablet, and mobile • Clear user experience structure to guide visitors toward enquiry, purchase, or sign-up • Clean, standards-compliant development (HTML5, CSS3, JavaScript) or a CMS build such as WordPress or Shopify, depending on what fits your project best • Basic on-page SEO setup including proper headings, meta tags, and optimized structure • A handoff package including editable files, style references, and deployment guidance Process: Discovery & sitemap planning Initial design concepts and visual direction Iterative revisions until final approval Development and content integration Testing, launch, and short post-launch support I focus on clean, user-centered websites that are easy to manage and scalable for future growth. I’d be happy to share relevant portfolio examples and discuss the best structure and platform for your project. Looking forward to collaborating with you. Best regards, Alka

@jonhw5

Hello, thanks for posting this project. I will design and implement a tailored, automated ERP system in Google Sheets and Apps Script for Audicstore, focused on precise Net Profit/Loss tracking across sales, inventory, and logistics. With extensive experience in advanced inventory management, weighted-average costing, and dynamic shipping logic, I will build interconnected modules that handle multi-source purchases, low-stock alerts, and currency-proof VAT handling for domestic transactions. The system will support importing sales data from Zid/Excel, calculate gateway fees (Tabby 6.5%, Tamara 7%, ZidPay 2.5% + 1 SAR), and allow seamless manual edits to orders, weights, and cities with instant profit recalculation and future gateway additions. The Shipping Engine will compute cost with 15% VAT on base rates, apply 15% uplift where required, and show shipping ROI against the fixed 25 SAR charge. Returns will be managed with clear status tags and refunds computed as Item Price + 25 SAR return fee. The Financial Dashboard will provide real-time totals and charts for sales trends and top-selling products, with 15% VAT incorporated for domestic transactions. Everything will be fully editable so you can adapt the model to evolving needs. Looking forward to collaborating on delivering a robust, scalable solution that streamlines Audicstore’s profitability. What is your preferred cadence for importing sales and inventory data (e.g., daily, real-time via API, or batch uploads), and do

@nutankumarftp

As an experienced Full Stack Web Developer with comprehensive proficiency across diverse technologies, I bring more than a decade of expertise to your ERP & Financial Tracking System project for Audicstore. My core competency in Google Sheets and Apps Script is particularly well-suited to executing the automated process flow you require. Over 2,000 successful projects later, my development career has spanned complex E-commerce financial modeling, data analysis and management—covering all bases of your demanding project requirements. Given your inventory needs, my deep knowledge of Google Sheets Formulas including VLOOKUP, XLOOKUP, QUERY and IFS will enable us to efficiently track SKUs, product names, brands and categories—an essential aspect of managing your product lifecycles effectively. My expertise extends even further to fulfill the inventory requirements you've detailed; for instance, I can implement a weighted average costing logic that ensures precise profit calculation by dynamically considering various purchase batches. Additionally, my knack for Data Visualization comes into play with your "Automated Financial Dashboard" requirement. Having constructed numerous analytical charts and visualizations in the course of my career using Google Sheets tools with JavaScript synergies, I can provide real-time summaries of Total Sales, COGS (Cost Of Goods Sold), Total Shipping Costs and Total Net Profit—while facilitating VAT accounting on domestic transactions.

@DigitalNightOwl8

Hey Mate , Good morning! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, Ruby on Rails, html/css as well as javascript and jquery. I have rich experienced in MySQL, PHP, Software Architecture, Data Management, Inventory Management, JavaScript, Google Sheets, Data Analysis, Data Visualization and Financial Modeling. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. "B. Not yet refunded" Looking forward to hearing you back and discussing all details.. Talk to you soon

@AlexNdungu

Hello, I’d be happy to build a custom Google Sheets + Apps Script ERP for Audicstore that tracks sales, inventory, shipping, and fees to calculate accurate Net Profit/Loss in real time. I can implement: Advanced inventory with weighted average cost across multiple purchase batches Automated sales imports and dynamic payment gateway fee calculations Tabby, Tamara, ZidPay, plus future gateways A shipping engine that calculates actual provider costs with VAT and weight logic Returns/refund tracking with automated refund calculations A live financial dashboard showing sales, COGS, logistics ROI, and net profit with charts The system will be fully editable, modular, and automated using Apps Script, with a short guide so you can easily manage imports, inventory batches, and updates. I can start right away and deliver a clean, scalable ERP sheet tailored for your store operations.

@danielboggs

Hello Audicstore, I’ve read your brief and can build a fully editable Google Sheets ERP that tracks every penny, from weighted-average inventory costing across batches to sales, gateway fees, shipping engine, returns, and a P&L dashboard with charts. I’ll implement dynamic batch-based cost calculations, automated low-stock highlights, import routines for Zid/Excel, editable order fields, and a shipping calculator that applies city-based rates plus 15% VAT. Everything will be editable and backed by Apps Script automations for fee calculations and real-time dashboards. I have hands-on experience building e‑commerce financial models, advanced Sheets formulas, Apps Script automations, and clear user guides. I’ll deliver the connected workbook and a short guide within the agreed timeline. Can you share sample exports for a week of sales and recent purchase batches (CSV/Excel) so I can map columns and validate the weighted-average costing logic? Sincerely, Daniel

@nicolasalexandro

Hey — saw your post about building a Google Sheets-based ERP and financial tracking system for Audicstore. When everything runs through Sheets, the biggest pain point is keeping inventory, orders, and financials in sync without things breaking as volume grows. Quick question before I suggest an approach: Do you already have separate sheets for inventory, sales, and expenses, or are we starting from a single master file? I’ve built automated Google Sheets + Apps Script systems for e-commerce before, including order syncing, stock updates, and basic P&L views, so I’m familiar with what usually causes errors over time. If you can share your current sheet, a sample file, or any workflow notes, I’ll take a look and outline how we can structure this so it stays stable as you scale.

@salajka

I'm a Google Sheets & Apps Script specialist with 8+ years of experience building exactly this kind of automated ERP system. I've built inventory management, sales tracking, POS systems, and financial dashboards using Google Sheets + Apps Script for various businesses. Here's what I'll build for Audicstore: 1. Advanced Inventory Management - SKUs, brands, categories, weighted average cost calculation (Bulk Suppliers vs. AliExpress), low stock alerts 2. Dynamic Sales & Order Tracking - Import from Zid/Excel, gateway fee auto-calculation (Tabby 6.5%, Tamara 7%, ZidPay 2.5%+1 SAR) 3. Financial Dashboard - Net Profit/Loss tracking, expense categories, automated P&L 4. Apps Script automation - form triggers, auto-updates, email alerts 5. Everything editable/customizable as your business evolves I've built a similar POS + inventory system (Snackerz Shack) using Apps Script, so I understand exactly what's needed. Can we connect to discuss the full scope? I can start this week.

@vasylklymiu

Hi, I would like to grab this opportunity and will work till you get 100% satisfied with my work. I just applied after read your job posting carefully and I believe that I am good fit to your project. I'm a serious bidder. I will satisfy you with my high skills! I am an expert which have 8+ years of experience on PHP, JavaScript, Software Architecture, Inventory Management, MySQL, Data Visualization, Data Analysis, Google Sheets, Financial Modeling, Data Management I am looking forward to meet you to discuss the further detail about this project. Looking forward to hearing from you. Warm Regards

@Hemantt841

From your project description, you need a highly customized Google Sheets ERP system for Audicstore that tracks inventory, sales, shipping costs, and calculates net profit with dynamic costing and VAT considerations. Your detailed shipping logic and the need for editable gateway fee automation show the complexity and precision required. I bring over 15 years of experience in full stack development and database design, having completed 200+ projects that involved financial modeling and e-commerce logistics. My expertise with Google Sheets, Apps Script, PHP, JavaScript, and MySQL aligns well with your need for automation, data management, and visualization within a single interconnected system. To deliver, I will build a modular Google Sheets solution using advanced formulas and Apps Script to automate inventory updates, sales imports, shipping cost calculations, and refund handling. The system will include a real-time P&L dashboard with customizable charts and editable parameters for fees and stock thresholds. I expect to complete the initial build and testing within one week, ensuring full flexibility for your future edits and data imports. Let’s discuss how I can tailor this system to your exact needs and make your financial tracking effortless.

@Visharaa2024

Hello, Your project stood out because building a fully automated ERP system in Google Sheets requires strong financial modeling, accurate inventory tracking, and automation using Apps Script. I can develop a customized and scalable ERP for Audicstore that tracks inventory, sales, logistics, and financial performance while calculating the exact Net Profit/Loss for every order. The system will include advanced inventory management with SKU tracking, purchase batches, and weighted average cost calculation for accurate COGS. Sales data from Zid or Excel will automatically connect to inventory, apply payment gateway fees (Tabby, Tamara, ZidPay), and allow manual edits for orders, weights, cities, and gateway rules with instant recalculations. I will also build a shipping engine that calculates actual logistics costs with VAT, compares them with the fixed 25 SAR shipping fee, and measures logistics profit or loss. A returns and refund module and a real-time financial dashboard with sales trends and top-selling products will also be included. The entire system will remain fully editable and flexible so you can easily update pricing, gateways, shipping rules, or inventory logic. I will also provide a short guide explaining how to import data and manage the system efficiently.

@cindyviorinar

Hi, I’ve reviewed your requirements for Audicstore and can build a fully editable Google Sheets ERP that tracks every penny from SKU-level inventory through logistics to a live P&L. I will implement dynamic weighted-average costing for multi-batch purchases, low-stock alerts under 5 units, import and reconcile Zid/Excel sales, and configurable gateway-fee rules (Tabby, Tamara, ZidPay) with an admin interface to add or edit gateways. The Shipping Engine will calculate provider costs (Roadlink, Aramex/ZidShip) with weight tiers and 15% VAT, compare against the fixed 25 SAR customer charge, and show shipping ROI. Returns/refunds, status tags, and real-time dashboards (sales, COGS, shipping, net profit, top sellers) will be included. I’ll use advanced Sheets formulas and Apps Script for automation and deliver a short guide for imports and batch management. I also have practical experience applying LLMs/Transformers for automation and chatbot helpers for data entry/QA if you want future enhancements. I can deliver a working file and walkthrough in about 7 days. Which sales export format do you use most often (Zid CSV/Excel columns and a sample row), and do you have preferred field names for SKU, weight, city and payment method? Best regards, Cindy Viorina

@fabians73

Hello Audicstore, I’ve read your brief and can build a fully editable Google Sheets ERP that tracks every penny from sales to net profit. I’ve implemented weighted-average costing, multi-source purchase batching, SKU-level inventory, and low-stock alerts using advanced formulas and Apps Script automation. I’ll wire sales imports (Zid/Excel) to inventory, implement gateway fee rules (Tabby, Tamara, ZidPay) with editable future gateways, and create the Shipping Engine that applies city-based rates, VAT, weight bands, and calculates shipping ROI vs. the fixed 25 SAR charge. Returns, refund workflows, and a real-time P&L dashboard with charts and Top-5 product analytics will be included. Deliverables: an inter-connected Sheets file, Apps Script automations, and a short user guide , everything editable so you can change logic, fees, and rates easily. I can start with a requirements review and a working prototype within the first week. Which sales export fields (order ID, SKU, weight, payment method, city, gross amount, discount) will be consistently available in your Zid/Excel files, and can you share a representative sample? Best regards, Fabian

@sadam61

Hi Audicstore, I'm excited to help you develop a professional e-commerce ERP & financial tracking system tailored perfectly for your high-fidelity audio equipment store. With over 9 years of experience in building automation systems using Google Sheets and Apps Script, I’m confident in transforming your requirements into a seamless solution. I’ve successfully delivered similar projects that involved advanced inventory management, dynamic sales tracking, and automated financial dashboards. This ensures accurate profit/loss calculations, enabling you to manage your inventory and logistics efficiently. I can start immediately and will ensure everything is editable to suit your needs going forward. Thanks, Sadam