Development of Internal VAT Return Automation Tool

FreelanceJobs

Canada

Canada

Trouver des emplois similaires

À propos

We are an accounting organization seeking an experienced developer or agency to build an Internal VAT Return Automation Tool. This tool will standardize VAT return preparation, replicate our senior accountants' validation logic, and reduce manual effort. It is intended for internal use across multiple clients and is rule-based, not AI-driven.
Project Overview:
Currently, VAT working papers are prepared manually in Excel using checklists, validation logic, and structured working files. This project will convert that workflow into a configurable software tool capable of generating audit-ready VAT working papers.
Objectives:
Automate VAT working paper preparation
Replicate senior accountant validation logic
Reduce errors and improve consistency
Reduce review time
Maintain audit-quality documentation
Enable multi-client usage
Ensure traceability of validation steps
Scope of Work:
The selected freelancer/agency will:
Design system architecture
Develop a backend rule engine
Implement a file upload interface
Convert VAT checklist logic into system rules
Build automated Excel outputs
Implement logging and audit traceability
Support testing and validation
Provide documentation and knowledge transfer
Functional Requirements:
User Input Interface: Client Name, Bookkeeper, Reviewer, VAT Period, mandatory and optional file uploads
VAT Rule Engine: Supplier-level controls, VAT logic validations, missing documentation checks, aging & transaction controls, client-specific configuration
Excel Output: VAT Return Summary, VAT Rate-wise tabs, Exception/Issue Register, Missing Receipt Report, Aging Exception Report, Metadata Sheet
Structured for audit review, reusable as working papers
Technical Requirements:
Backend: Python preferred (or equivalent), modular architecture
Excel automation: openpyxl/xlsxwriter or equivalent, template-based outputs
Logging & traceability of rules applied
Scalable, maintainable, and extendable
Secure file handling and data confidentiality
Deliverables:
Fully working internal VAT automation tool
Complete source code and configurable VAT rule framework
Integrated Excel template
Technical and rule documentation
Deployment instructions
Knowledge transfer session
Experience Required:
Accounting/tax automation experience
Understanding of VAT/GST/Sales Tax workflows
Experience translating accounting SOPs into system logic
Internal business tool development
Strong backend engineering skills
Preference: Developers with finance domain exposure
Proposal Requirements:
Applicants must submit:
Proposed technical architecture
Estimated timeline
Milestone breakdown
Cost estimate
Relevant experience and example projects
Clarifying questions (if any)
Timeline: 8–12 weeks (flexible, to be finalized with developer)
Confidentiality & Ownership:
NDA required before project start
Full source code ownership assigned to our organization
No reuse of logic/framework without written consent
We are looking for a highly skilled developer/agency who can deliver a robust, maintainable, and scalable VAT automation tool for internal accounting use.
Contract duration of 1 to 3 months.
Mandatory skills: Full Stack Development, Software System Design, Excel VBA, Accounting Software, Automation, ERP Integration, Bookkeeping, Financial Accounting, VAT Return, API Integration

Canada

Compétences linguistiques

English

Avis aux utilisateurs

Cette offre a été publiée par l’un de nos partenaires. Vous pouvez consulter l’offre originale ici.

Trouver des emplois similaires