Ankit Sharma

Accounts, MIS & E-Commerce Executive · Faridabad, Haryana

Advanced Excel · VBA Tally Prime E-Commerce Analytics Power BI · Power Query UGC NET Qualified

15+

Retail outlets managed via centralised reporting

20K

Annual marketplace transactions analysed & validated

5,500+

Outlet sales submissions processed over 15 months

<1 min

Reporting prep time after VBA automation (was hours)

🗃️ Financial Reporting

P&L, Trial Balance, Balance Sheet, Bank & Ledger Reconciliation, GST, TDS — across multi-outlet and multi-platform environments.

⚡ Automation Specialist

VBA macros for Amazon, Flipkart, Snapdeal reporting. Excel-to-Tally bulk import templates. Single-click month-end closing workflows.

🛒 E-Commerce Analytics

Marketplace payout reconciliation, FBA/FBF inventory planning, profitability analysis across Amazon, Flipkart, Blinkit, Meesho & more.

📊 MIS Dashboards

Power Query & Power Pivot dashboards with MOM/YOY trends, region-wise and channel-wise breakdowns, and ad-spend ROI tracking.

🧾 Tally Integration

Designed Excel-Tally templates for Sales, Purchase, Receipt, Payment, Journal, Stock Journal — eliminating manual ledger posting.

🤖 AI-Augmented Workflow

Leverages ChatGPT & Gemini for VBA writing, DAX development, formula generation, and process research to accelerate delivery.

Shadani India Pvt. Ltd.

Accounts, MIS & E-Commerce Executive

Mar 2025 — Present

🏪 Retail & Operations

GST accounting for 15+ company-owned retail outlets
Automated daily sales reconciliation (Google Forms vs POS data) — 100% Cash & UPI matching accuracy
Built Excel-Tally pipeline integrating billing machine output with Tally product masters
Bulk import templates eliminating manual ledger posting at month-end
Data validation controls reducing reconciliation time from days to hours
Order processing, invoicing, and billing via Petpooja POS
Stock audit, inventory monitoring, outlet expense tracking

🛒 E-Com & Q-Com Accounting

Bulk transaction processing via Excel VBA + Power Query integrating Amazon, Flipkart, Blinkit, Meesho codes with TallyPrime
Automated framework for marketplace payout reconciliation and order-wise profitability
Interactive dashboards: sales performance, ad spend CTR, customer engagement
GST-oriented sales summaries and marketplace transaction reports
Single-click monthly accounting data-processing templates
Inventory management for Amazon FBA, Flipkart FBF, Blinkit appointments

📋 Compliance & Taxation

GSTR-1 preparation and reconciliation for e-com platforms and outlets
IMS and GSTR-2B reconciliation and verification
TDS calculation and deduction tracking for e-com platforms
Input Tax Credit (ITC) verification and adjustment
Vendor reconciliation for GST compliance

📊 MIS & Reporting

Daily, Monthly, Quarterly, Half-Yearly and Annual Management Reports
MOM and YOY business performance analysis
Product-wise, Region-wise and Channel-wise performance reports
Outstanding balances and collection performance monitoring
Outlet performance and operational review reports

Model iRapido

Junior Financial Accountant (Intern)

Jun 2024 — Dec 2024

Developed custom VBA Excel automation tools for a critical Chart of Accounts (COA) project for a US-based accounting services firm
Classified General Ledger (GL) codes into a new structure across 4 distinct business entities
Automated complex data mapping and integration workflows, eliminating manual bottlenecks
Delivered measurable system efficiency improvements, earning official recognition and an Amazon Gift Card reward for outstanding performance
Deepened expertise in data integration, GL accounting structures, and process automation in a cross-border accounting environment

📊

Advanced Excel & Automation

Excel VBA / Macros Power Query Power Pivot DAX Formulas Pivot Tables & Charts Dashboard Development Data Modelling Conditional Formatting Data Validation Advanced Functions

🧾

Accounting & Finance

Tally Prime Journal Entries Bank Reconciliation Ledger Reconciliation GST (GSTR-1/2B/IMS) TDS Calculation Accounts Payable / Receivable P&L / Balance Sheet Trial Balance Inventory Accounting E-Invoice & E-Way Bill ITC Verification

🛒

E-Commerce & Marketplace

Amazon FBA Flipkart FBF Blinkit / Q-Commerce Meesho · JioMart Payout Reconciliation Settlement Verification Order Profitability Analysis Inventory Planning Ad Spend Analysis GSTR-1 (Marketplace)

🔧

Integration & Systems

Excel-to-Tally Integration Bulk Data Import Templates Product Code Mapping Google Forms Automation Google Sheets Google Apps Script (Basic) Power BI (Basic) MS Word Mail Merge MS PowerPoint

🤖

AI & Digital Tools

ChatGPT / OpenAI Google Gemini AI-assisted VBA Writing DAX via AI AI Research & Automation Petpooja POS

📈 Proficiency Overview

Excel / VBA Automation95%

Tally Prime90%

Financial Accounting / GST88%

E-Commerce Analytics85%

Power Query / Power Pivot80%

Power BI / DAX65%

Marketplace Sales Reporting Automation

Excel VBA

Developed a suite of VBA-based macros to automate the entire sales reporting pipeline for Amazon, Flipkart, and Snapdeal. What previously took several hours of manual data consolidation now runs in under one minute with a single click.

Automated state-wise sales report generation across all three marketplaces
Automated management summary preparation with zero manual input
Reduced reporting preparation time from hours to under 60 seconds
Improved consistency and eliminated human entry errors across monthly cycles

Excel-to-Tally Integration Templates

Tally Integration

Designed a comprehensive set of Excel import templates that connect directly to TallyPrime, enabling bulk automated uploads of all voucher types without manual ledger posting. Also built product mapping systems linking marketplace SKUs to Tally item masters.

Covers Sales, Purchase, Receipt, Payment, Journal, Sales Order, Stock Journal vouchers
Automated product code mapping: marketplace codes → Tally master items
Eliminated manual data entry for high-volume month-end processes
Reusable templates deployed across Amazon, Flipkart, Blinkit, Meesho channels

Management Dashboard Reporting System

MIS Dashboard

Built an Excel-based management reporting suite using Power Query and Power Pivot. Provides real-time visibility into sales performance, gross and net profitability, with automated Month-on-Month and Year-on-Year comparisons.

Product-wise, Region-wise, and Channel-wise performance analysis
Automated MOM and YOY business trend tracking
Sales, gross profit, net profit, and ad spend dashboards in a single workbook
Interactive slicers for dynamic executive reporting

Retail Outlet Reconciliation System

Excel Automation

Engineered an automated Excel verification system to reconcile daily sales data from Google Forms submissions with Billing POS data across 15+ retail outlets, ensuring 100% accuracy in Cash and UPI payment matching.

Reconciled 5,500+ outlet sales submissions over 15 months
100% accuracy in Cash and UPI payment matching
Reduced month-end reconciliation time from days to hours
Strict data validation formulas minimising revenue leakage and manual errors

Chart of Accounts (COA) Automation — Model iRapido

Internship Project

During a 6-month internship at a US accounting services firm, developed custom VBA Excel automation tools to classify General Ledger (GL) codes into a new COA structure across 4 distinct business entities — eliminating manual bottlenecks in a critical migration project.

Automated complex data mapping and integration across 4 business entities
Significantly reduced manual effort in GL code classification and migration
Earned official recognition and an Amazon Gift Card reward for outstanding performance
Deepened expertise in data integration, GL structures, and cross-border accounting workflows