Software Developer (Excel/VBA or Python)
Software Developer (Excel/VBA or Python)
Get AI-powered advice on this job and more exclusive features.
Direct message the job poster from Expert360
* Role Type: Software Developer (Excel/VBA or Python)
* Duration: ~7-10 days
* Location: Hybrid
About Expert360:
Expert360 empowers more than 42,000 (and growing) elite professionals around the world to find great work and be successful. Expert360 was founded in 2013 with a simple but powerful mission - to connect amazing people with great companies to get important work done.
We believe in choice, flexibility and empowerment. We believe if you can change the world of work, you can change the world. Come and join us in defining and bringing to life the future of work
About the Role:
Our client is seeking a developer to rebuild and modernise an internal billing tool currently implemented in Excel with VBA. This tool automates invoice generation, payments processing, and accounting file creation across multiple data inputs. A core requirement is the inclusion of rigorous data integrity checks to eliminate financial errors and ensure completeness.
Current State:
* Generate invoices from 58+ input sources (mix of PDF, HTML, CSV, Excel)
* Create CSV files for import into Saasu (transitioning to Xero)
* Create credit card CSVs for NAB Transact
* Auto-flag and record direct debit invoice payments
* Export paid invoice records to downstream systems
Key responsibilities:
Build a new billing automation solution that can:
* Parse and process 58 varied input formats (PDF, HTML, CSV, Excel)
* Handle inconsistent file structures with fault tolerance
* Dynamically generate invoices from source data
* Output validated CSV invoice batches for Xero import
* Include rules-based logic to calculate line items, tax, customer IDs
* Payment File Generation
* Generate ABA files for direct debit submission to NAB Connect
* Generate credit card CSV files for NAB Transact upload Flag, log, and handle rejected or mismatched transactions
* Auto-record payments for direct debit invoices
* Export paid invoice details to nominated sheet or tool
* Data Validation & Controls
* Missing mandatory fields (e.g., amounts, customer IDs)
* Duplicate invoices or payments
* Source data mismatches (e.g., totals not reconciling)
* User-friendly error messages and resolution workflow
* Solution can be Excel+VBA or a lightweight script (Python preferred)
* Configurable inputs and mapping logic for new data sources
* Include documentation and support handover
Skills required:
* Advanced Excel & VBA or scripting (Python highly preferred) -
* Proven experience with finance automation, invoice processing
* Familiarity with ABA file generation and Xero/Saasu workflows
* Ability to build robust data validation logic
* Bonus: Experience with NAB Connect / NAB Transact integration
Success Criteria:
* Zero tolerance for billing errors — system must self-check and flag issues
* Full compatibility with Xero's import schema
* Reliable generation of ABA and payment CSV files under operational load
* Solution is transparent, maintainable, and easily adaptable - End user is an Accountant
Seniority level
* Seniority level
Mid-Senior level
Employment type
* Employment type
Contract
Job function
* Job function
Business Development and Design
* Industries
Technology, Information and Internet
Referrals increase your chances of interviewing at Expert360 by 2x
Get notified about new Software Engineer jobs in Brisbane, Queensland, Australia .
Fortitude Valley, Queensland, Australia 1 week ago
Brisbane, Queensland, Australia 1 week ago
Fortitude Valley, Queensland, Australia 1 month ago
Paddington, Queensland, Australia 3 weeks ago
Brisbane, Queensland, Australia 1 day ago
Software Development Graduate (2025, Stores)
Brisbane, Queensland, Australia 1 week ago
Software Engineer - Frontend (Open to remote across ANZ)
Brisbane, Queensland, Australia 1 week ago
Brisbane, Queensland, Australia A$60,000.00-A$100,000.00 1 month ago
Software Engineer - (Java) Backend (Open to remote across ANZ)
Brisbane, Queensland, Australia 3 days ago
Runcorn, Queensland, Australia 2 days ago
Brisbane, Queensland, Australia 3 weeks ago
Front End Developer - Level 3 - Max Term Engagement
Brisbane City, Queensland, Australia 1 week ago
Brisbane, Queensland, Australia 1 week ago
Brisbane, Queensland, Australia 1 week ago
Brisbane, Queensland, Australia 2 weeks ago
Brisbane, Queensland, Australia 1 day ago
Brisbane, Queensland, Australia 3 days ago
Brisbane, Queensland, Australia A$70,000.00-A$90,000.00 1 week ago
Brisbane, Queensland, Australia 2 weeks ago
Brisbane, Queensland, Australia 18 hours ago
Software Engineer (Java/Typescript/Node)
Brisbane, Queensland, Australia 1 week ago
Brisbane, Queensland, Australia 7 hours ago
Brisbane, Queensland, Australia 18 hours ago
Brisbane, Queensland, Australia 1 week ago
Staff Software Engineer - Web Platform (Frontend)
Brisbane, Queensland, Australia 3 weeks ago
Brisbane, Queensland, Australia 4 days ago
Software Engineers - AI Team (Typescript/Node/React/AWS)
Brisbane, Queensland, Australia 2 weeks ago
Brisbane, Queensland, Australia 1 week ago
Brisbane, Queensland, Australia 1 week ago
Brisbane, Queensland, Australia 12 hours ago
Graduate Software Developer - 2026 Start
Brisbane, Queensland, Australia 2 weeks ago
Brisbane, Queensland, Australia 2 weeks ago
Brisbane City, Queensland, Australia 15 hours ago
Brisbane, Queensland, Australia 6 days ago
Eight Mile Plains, Queensland, Australia 2 days ago
Eight Mile Plains, Queensland, Australia 2 weeks ago
We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr