GST Yearly Maintain in Excel Format

This query is : Resolved

Share Report Follow Query Ask a Query

Seema

Seema (Querist)
Follow

26 March 2018 I want yearly(F.Y.2017-2018) maintain GST details monthwise summery..please share in excel format.

Seema

Seema (Querist)
Follow

29 March 2018 anyone have format?

Aashok Kumar Sharma online

Aashok Kumar Sharma online

(Expert)
Follow

12 July 2024 I'm unable to directly share files or Excel formats here, but I can guide you on how to create a monthly summary of GST details for the financial year 2017-2018 in Excel. Here’s a step-by-step approach you can follow:

### Steps to Create Yearly GST Details Summary (FY 2017-2018) in Excel:

1. **Open Excel**: Launch Microsoft Excel on your computer.

2. **Create a New Worksheet**:
- Click on "Blank workbook" to start a new Excel worksheet.

3. **Set Up Columns**:
- In the first row (Row 1), create headers for your columns. For example:
- A1: Month
- B1: GSTIN
- C1: Total Sales (₹)
- D1: Total GST Collected (₹)
- E1: Total Purchases (₹)
- F1: Total GST Paid (₹)
- G1: Net GST Payable/Refund (₹)

4. **Enter Monthly Data**:
- Enter the month names or numbers (e.g., April 2017, May 2017, etc.) in Column A under "Month".
- Fill in the GST details for each month:
- GSTIN (if applicable)
- Total Sales amount
- Total GST Collected
- Total Purchases amount
- Total GST Paid
- Calculate Net GST Payable or Refund based on GST Collected minus GST Paid.

5. **Format Cells**:
- Format numeric columns (C to G) to display currency format (₹) using the Excel formatting options.

6. **Calculate Totals**:
- In the last row (after December 2017 or March 2018, depending on your financial year end), calculate the total amounts for each column where applicable (e.g., total sales, total GST collected, etc.).

7. **Save the Excel File**:
- Click on "File" > "Save As" and choose a location on your computer to save the Excel file.

### Additional Tips:

- Use Excel formulas (like SUM function) to automate calculations wherever possible to avoid manual errors.
- You can add more columns or customize the worksheet based on specific GST details relevant to your business or organization.
- Ensure to keep backups of your Excel file regularly to prevent data loss.

This structured approach will help you maintain a clear and organized monthly summary of GST details for the financial year 2017-2018 in Excel. Adjust the columns and details as per your specific reporting and tracking requirements.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

swaminathan

ASHOK B GONDKAR

Shameem ahmed

Nayan shetty

Pratap Kumar De

Subscribe Now

GST Yearly Maintain in Excel Format

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

CA Final

Manager- Finance and Compliance

GST CONSULTANT

Senior Executive

Accountant

GST CONSULTANCY