Actions
Task #17570
openTask #18500: Ocean Sprint Planning for 17/07/2025 - 25/07/2025
CSV Report - VAT Return CSV file
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:¶
-
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.
-
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.
-
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.
-
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.
-
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
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}]
Updated by Redmine Admin 6 months ago
- Status changed from Development Done to QA
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
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
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
Updated by Redmine Admin 5 months ago
- Status changed from Development Done to New
Updated by Redmine Admin 4 months ago
- Status changed from New to Development Done
Updated by Redmine Admin 4 months ago
- Status changed from Development Done to New
Updated by Redmine Admin 4 months ago
- Status changed from New to Development Done
Updated by Redmine Admin 3 months ago
- Status changed from Development Done to QA
Actions