Project

General

Profile

Actions

Task #17570

open

Task #18500: Ocean Sprint Planning for 17/07/2025 - 25/07/2025

CSV Report - VAT Return CSV file

Added by Redmine Admin 7 months ago. Updated about 18 hours ago.

Status:
QA
Priority:
Normal
Assignee:
-
Start date:
03/13/2025
Due date:
07/25/2025 (about 5 months late)
% Done:

16%

Estimated time:
24:00 h
Spent time:
GitLab ID:
2196
GitLab Milestone:
GitLab Ticket Number:
356
GitLab Time Logged:
14400
Lock Timeline Date:
No
gitlab project trace:
Ocean Sprint Planning for 17/07/2025 - 25/07/2025

Description

Acceptance Criteria:

  1. Report Generation

    • The system should provide a VAT Return CSV file under the reports module.
    • Users should be able to generate the report based on a specific VAT period (e.g., Monthly).
    • The report should be exportable in CSV format, following MRA/MNS guidelines.
  2. Report Contents
    The report should include the following columns:

    • VAT Payer TAN
    • VAT Payer Business Registration Number (BRN)
    • VAT Payer Full Name
    • VAT Period
    • Telephone Number
    • Mobile Number
    • Name of Declarant
    • Email Address
    • VAT Registration No. of person to whom supplies is made
    • Name of person to whom supplies is made
    • Value of Supplies (MUR)
    • VAT Amount (MUR)
    • Date of Invoice
    • Invoice Number
    • BRN of person to whom supplies is made

    Please refer to the comments section for additional details related to the specs.

  3. Validations

    • Only invoices within the selected VAT period should be included in the report.
    • VAT-exempt invoices should be clearly marked.
    • Users should be able to view and verify transactions before submission.
  4. Permissions & Access Control

    • Only authorised users (e.g., the finance team) should have access to generate and export this report.
    • Salespersons should not have access to VAT reports.
  5. Export & Submission

    • The report format should be compatible with MRA (Mauritius Revenue Authority) VAT submission requirements or MNS VAT submission requirements.
    • Users should be able to download the report in the required format for easy submission.

Additional Notes:

  • The report should be accessible for historical data tracking and auditing purposes.

Sample VAT Report – CSV file from EDL

VAT RETURN CSV FILE.xlsx


GitLab Sync Log

[{"id": "27022", "author": "Waliyuddin Delba", "hours": 4.0, "created": "2025-07-21T09:59:59.390Z", "log_date": "2025-07-20", "comment": "Imported from GitLab by @Waliyuddin Delba on 2025-07-21T09:59:59.390Z: 4h-(4.0)h spend at: 2025-07-20", "status": "active", "deleted_by": "", "redmine_entry_id": 9962}]

Actions #1

Updated by Redmine Admin 7 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 6 months ago

  • Status changed from Development Done to QA
Actions #3

Updated by Redmine Admin 6 months ago

  • Status changed from QA to New
Actions #4

Updated by Redmine Admin 5 months ago

  • Due date changed from 05/16/2025 to 07/11/2025
  • Parent task changed from #16612 to #18453
  • gitlab project trace changed from Ocean Sprint Planning for 06/05/2025 - 16/05/2025 to Ocean Sprint Planning for 01/07/2025 - 11/07/2025
Actions #5

Updated by Redmine Admin 5 months ago

  • Due date changed from 07/11/2025 to 07/25/2025
  • Parent task changed from #18453 to #18500
  • gitlab project trace changed from Ocean Sprint Planning for 01/07/2025 - 11/07/2025 to Ocean Sprint Planning for 17/07/2025 - 25/07/2025
Actions #6

Updated by Redmine Admin 5 months ago

  • Status changed from New to Development Done
  • % Done changed from 0 to 16
  • GitLab Time Logged changed from 0 to 14400
Actions #7

Updated by Redmine Admin 5 months ago

  • GitLab Sync Log updated (diff)
Actions #8

Updated by Redmine Admin 5 months ago

  • Status changed from Development Done to New
Actions #9

Updated by Redmine Admin 4 months ago

  • Status changed from New to Development Done
Actions #10

Updated by Redmine Admin 4 months ago

  • Status changed from Development Done to New
Actions #11

Updated by Redmine Admin 4 months ago

  • Status changed from New to Development Done
Actions #12

Updated by Redmine Admin 3 months ago

  • Status changed from Development Done to QA
Actions

Also available in: Atom PDF