
In Progress
Posted
Paid on delivery
Running a busy grocery store means my numbers move fast, so I want to replace the spreadsheet I built myself with a cleaner, more dependable workbook. The first part of the job is to re-engineer the sheet so that routine tallies—daily sales, supplier payments, cash on hand—update automatically and feed into clear visual charts and graphs. Formulas, pivot tables, or Power Query—whatever gives me solid, automated calculations and an at-a-glance dashboard—is what I’m after. Next, I need print-ready formats. From the same data I should be able to generate polished receipts for customers and neat inventory lists for my stockroom printer. Fonts, spacing, and page breaks must stay consistent no matter how long the list gets. Finally, our billing software already exports raw sales data. I need an extra worksheet or macro that digests that export and spits out a customized list of items a customer has ordered within any chosen product category. Think: select “Dairy” and instantly see every SKU that customer bought, ready to print or email. Deliverables • A single Excel file with automated calculations, dynamic charts, and the import-to-report workflow fully wired. • Two print templates inside the workbook: one for receipts, one for inventory lists, each tested on standard A4. • A quick-filter tool (macro, slicer, or similar) that builds the category-based customer order list in one click, pulling directly from the imported data. I’ll supply the current sheet, sample export files, and examples of our receipt layout. Once everything balances correctly and prints cleanly, the project is complete.
Project ID: 40482780
9 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average ₹5,578 INR for this job

Having worked diligently over a decade in the designing field, especially focusing on software like Microsoft Office (including extensive Excel work) and Adobe Illustrator, I bring to the table highest standards of efficiency, reliability and keen eye for details. I've successfully completed numerous projects of similar nature and can efficiently enhance your grocery store's Excel accounting system to automate your routine tasks, generate visual charts/graphs and print smooth receipts and inventory lists. My insightful knowledge of pivot tables, Power Queries, appropriate formulas and calculations will significantly elevate your user experience by making your accounting process streamlined and virtually effortless. Additionally, my graphic design proficiency is well suited to create print templates with consistent layout. Best Regards Pinky
₹4,311 INR in 1 day
4.8
4.8

Hello! I can rebuild your grocery store workbook into a clean and reliable Excel file with automated calculations, charts, and an easy dashboard for daily tracking. I can also create print-ready receipt and inventory templates that stay properly formatted on A4 pages. Your billing export will be connected to a simple filter or macro so you can quickly generate customer-wise item lists by product category.
₹2,250 INR in 3 days
2.7
2.7

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹7,000 INR in 7 days
2.5
2.5

Hello, I can help redesign and automate your grocery store Excel workbook to make it more reliable, user-friendly, and efficient for daily operations. With strong Excel expertise and experience in reporting, data analysis, and automation, I can transform your current spreadsheet into a structured solution that minimizes manual work and provides clear business insights. The solution can include: • Automated calculations for sales, supplier payments, cash balances, and inventory tracking • Interactive dashboard with charts, graphs, pivot tables, and KPI summaries • Power Query and advanced Excel formulas for streamlined data imports and updates • Print-ready receipt and inventory templates optimized for A4 printing • One-click category-based customer order reporting using macros, slicers, or dynamic filters • Import workflow that processes billing software exports and updates reports automatically I will ensure all calculations reconcile correctly, reports remain easy to maintain, and print layouts stay consistent regardless of data volume. Once you share the current workbook, sample exports, and receipt format, I can begin immediately and deliver a fully tested, documented solution. Thank you.
₹8,000 INR in 2 days
0.6
0.6

As a dedicated finance and accounts professional with deep specializations in GST, TDS, and statutory compliance, I understand the language of numbers you need for your grocery store. My proficiency lies on guaranteeing solid and automated calculations, just what your busy enterprise requires. Certified in various fields essential for your project, such as GST certificates and Start-up Certificates, I provide a breadth of skills that will make your data management run smoothly every day. Moreover, my typing at 60 words per minute is swift and accurate -a combination that can handle large volumes of data with an astounding eye for detail. Imagine the efficiency! I'm experienced in handling multiple formats including PDF, Word, Excel, and PowerPoint, so no task is beyond my range. Life doesn't come without bumps though and I am also confident that my troubleshooting and problem-solving aptitude from previous roles will ease any difficulties we may face along the way. In conclusion, choosing me means choosing reliability. From consistently meeting deadlines to reliable data conversion management even under bulk workloads. My overarching goal is clear communication and client satisfaction; thus meeting all the needs you've outlined. Your project is a great fit for my core competencies and I look forward to putting smiles on both yours and your customers' faces once we nail this project together.
₹7,000 INR in 5 days
0.0
0.0

Hi, I can help with a cleaner Excel accounting workbook that automatically updates your daily sales, supplier payments, and cash-on-hand, with an at-a-glance dashboard and charts. I’ll start by reviewing your current sheet and the billing export, then re-engineer the formulas/pivots/Power Query so calculations are traceable and reconcile correctly. To reduce risk, we’ll verify totals against your sample exports before I lock in the print-ready A4 layouts and page breaks. Which receipt and inventory list fields should be mandatory (name, SKU, quantities, totals, date)? Do you want the category filter to be a dropdown/slicer inside the workbook or a simple macro button? Once you share the files, I can begin and deliver a tested single Excel file soon.
₹5,140 INR in 3 days
0.0
0.0

Hi There, I can re-engineer your grocery store spreadsheet into a dependable, automated workbook that streamlines your fast-moving numbers. For the first part of your requirement, I will use Power Query and advanced Excel formulas to automate your daily sales, supplier payments, and cash-on-hand tallies. This data will feed into a dynamic, at-a-glance dashboard featuring clear visual charts and graphs so you can monitor your business metrics effortlessly. Next, I will design print-ready layouts within the workbook for customer receipts and inventory lists. These templates will be optimized for standard A4 printing, ensuring consistent fonts, spacing, and page breaks regardless of list length. Finally, I will create a dedicated worksheet with a custom macro or advanced filtering tool. This will ingest your billing software exports and let you isolate customer orders by product category, like Dairy, with a single click, making it ready to print or email. Let's contact to discuss details. Solution Vector Roman Khakhula
₹2,500 INR in 7 days
0.0
0.0

Hello, I have 3+ years of experience in Excel automation, dashboards, Power Query, Pivot Tables, and VBA. I can deliver an accurate, automated, and user-friendly solution tailored to your requirements. Ready to start immediately.
₹3,000 INR in 3 days
0.0
0.0

Koppa, India
Payment method verified
Member since Jun 1, 2026
₹400-750 INR / hour
₹750-1250 INR / hour
$15-25 USD / hour
$10-30 USD
€30-250 EUR
$10-20 USD
$250-750 USD
$15-25 USD / hour
$250-750 USD
€8-30 EUR
$15-25 USD / hour
₹600-1500 INR
₹750-1250 INR / hour
$10-30 USD
₹1500-12500 INR
min $50 USD / hour
₹12500-37500 INR
₹750-1250 INR / hour
$30-250 USD
₹600-1500 INR