GST Yearly Maintain in Excel Format

This query is : Resolved

Report Abuse 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?

Asha Kanta Sharma

Asha Kanta Sharma

(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.

Upgrade to CAclubindia Pro. Subscribe Now!