Reporting and reconciliation, in Python and Visual Basic
Recurring reports and reconciliation that took most of a morning now arrive finished, built inside the tools the business already had.
- Python
- pandas
- Visual Basic for Applications
- Excel
- Access
- SQL
Not every business is going to adopt a new platform, and a lot of real work lives permanently inside Excel and Access. Automation there has to meet the tools where they are.
Python where the data is remote
Pulling from exports and internal systems, joining, reconciling and writing out a finished report. The work that used to be a morning of spreadsheets and manual matching.
Visual Basic where the data lives locally
Macros that turn a sequence of repeated manual steps into one button, inside the workbook people already open every day. Unfashionable, and by a distance the fastest route to hours saved when the alternative is asking a team to change tools.
Video walkthroughs
Screen recordings showing the manual version and the automated version side by side are being cut and will appear on this page.
14 hours a month no longer spent on this work.
Want this running in your business
Bring the process that costs you the most hours. Thirty minutes and you will know what it takes.