Ashish Srivastava

1 Tally prime with Gst-

Accounting Software: Proficient in Tally Prime with in-depth knowledge of integrated financial modules

GST Handling: Managing GST-related transactions including GST returns, input tax credit, and reconciliation

Payroll Management: Skilled in payroll processing and employee record handling within Tally Prime

Taxation Modules:

TDS: Knowledge of tax deduction at source and compliance workflows

VAT: Familiarity with VAT calculations and filing (as per historical or regional requirements)

Inventory Management: -

-Stock Categories: Effective tracking and categorization of stock items

-Batch-wise Inventory: Managing stock with batch numbers and expiry

-Godown Management: Handling multi-location stock with seamless godown allocation

-Actual & Billed Quantities: Accurate recording of inventory flows vs invoice data

-Additional Costs Allocation: Distribution of indirect costs to inventory items

-Billing & Pricing: Configuring discount structures and analyzing price impacts

-Currency Management: Experience with multi-Currency transactions and exchange rate adjustments

-Interest Calculations: Automating interest on overdue accounts or receivables/payables

2 MS Excel: -

Spreadsheet Design & Templates:

-Skilled in creating customized Marksheets, Salary Sheets, Week-Off Trackers, and Calendars tailored to organizational needs

-Use of interactive controls such as Scroll Bars, Checkboxes, and form elements to enhance usability

Advanced Formulas & Functions:

1Lookup Functions: VLOOKUP, HLOOKUP, INDEX MATCH, IF(ISNUMBER)

2Logical Functions: IF, IF(OR), IF(AND(OR)), conditional analysis and automation

3Statistical & Conditional Analysis: DSUM, SUMIFS, COUNTIFS for data segmentation and insights

Data Handling & Validation

Effective use of Advanced Filters, Data Validation, and Flash Fill for clean data processing

Expertise in structuring reliable MIS reports and dashboards

Analytical Tools:

1 Scenario building using Scenario Manager

2 Forecasting and planning with Goal Seek and Data Tables

3 Financial and operational Consolidation of data across multiple sheets and sources

Loan Sheet Oversight: Maintained structured loan tracking sheets aligned with regulatory and audit standards

• Pivot table
• Office management
• Loan processing
• Office operations
• Bookkeeping
• Office administration