Invoice Automation

This project focused on automating the creation of invoices using a Python-based script. The goal was to replace a manual workflow. The solution supports three different invoice types. For RPA project invoices, the script retrieves logged working hours directly from Jira and generates the invoice based on that data. For RPA maintenance invoices, time entries are collected from a Jira maintenance project where work is logged whenever maintenance is required. For RPA usage invoices, the script accesses the Blue Prism database and selects execution times for specific RPA jobs, which are then billed accordingly. Invoices are generated as Word documents, using Python’s docx-mailmerge library to fill the invoice templates with the collected data. The automation is triggered by creating a ticket in Jira. If an error occurs, the script automatically creates an error ticket in Jira so developers can handle the issue.