GST & Inventory Upgrade in Access

I have a fully-functional accounting application built in Microsoft Access, but it predates GST and has only basic item tracking. I now need a knowledgeable Access developer to extend the existing database so it can:

• Generate GST-compliant invoices that calculate and display CGST, SGST and IGST
• Prepare sales and purchase registers ready for GST return filing
• Track GST liability separately for every customer and supplier
• Update stock automatically whenever I enter a sale, purchase or return
• Log quantities received, sold and returned as distinct movements
• Show the current on-hand quantity and total stock value for each item at any moment

The current file structure, forms and reports are solid, so you’ll be working inside the existing MDB/ACCDB, adding the required tables, queries, VBA code and reports while keeping the interface familiar for my team. I’ll provide a copy of the database, sample data and any design documents I have; you deliver the upgraded file, documentation of the new objects and a brief walkthrough so we can maintain it going forward.

If you have strong VBA skills and recent experience fitting GST logic into legacy Access projects, let’s talk and schedule a quick screen-share review of the existing schema.