
Oanh
Excel VBA Accounting Automation Specialist
Skills

See my services

Portfolio
Work experience
Accountant – Input Cost Accounting
Travel & Tourism Company • Full-time
Apr 2025 - Present • 1 yr 7 mos
Handle hotel booking costs and supplier account reconciliation for a travel company. - Enter and upload accounting data into MISA accounting software, then extract and verify data against Excel records. - Check payables against debt statements from many hotel suppliers. - Clean and process e-invoice data exported from the tax authority portal. - Use advanced Excel formulas and pivot tables for daily reporting and cross-checking. - Built a VBA macro for Outlook and Excel that collects debt data from email attachments across multiple mail folders and accounts, consolidates it into one master file, and logs errors, replacing a manual copy-and-paste routine.