Financial Reporting & Automation Specialist (Excel-Focused) - EST Hours (Remote)

This a Full Remote job, the offer is available from: Anywhere

ISTA Personnel Solutions is a dynamic and fast-growing BPO company. We are not a recruitment agency - we operate as a dedicated extension of our U.S.-based clients’ teams, delivering high-quality service with precision, efficiency, and a personal touch.

We are seeking a detail-oriented Financial Reporting & Automation Specialist with advanced Excel skills and a strong understanding of financial reporting structures. This role is ideal for someone who takes pride in reducing manual work, building reliable spreadsheets, and ensuring financial reports remain accurate and structured over time. You’ll work extensively with financial data exported from systems such as QuickBooks Online and play a key part in maintaining and improving recurring management and financial reporting.

PLEASE NOTE

  • Working Hours: Mon – Fri, 9:00am – 6:00pm EST (16:00pm – 01:00am OR 15:00pm - 00:00am South African Time, depending on daylight savings in the USA)
  • Work Environment: This is a fully remote working role.
  • You will be required to work on both South African and US public holidays (compensation for SA public holidays in accordance with the BCEA).
  • Internet Requirements: A fixed fibre line with a minimum speed of 25 Mbps (upload & download) and the ability to support a wired Ethernet connection is mandatory. Applicants without a fixed fibre line cannot be considered.
  • Power Backup: A reliable power backup solution is required to manage load shedding and power outages. Applicants without a power backup cannot be considered.

Key Responsibilities

    • Work with financial data exports from systems such as QuickBooks Online
    • Maintain and enhance Excel-based financial reporting models
    • Prepare and update monthly P&L and Balance Sheet reporting files
    • Ensure formulas, links, and structures remain stable across reporting periods
    • Manage changes in GL codes, mappings, and account structures
    • Reduce manual reporting effort through improved Excel logic and automation
    • Build structured summary sheets, reconciliations, and visual reporting outputs
    • Identify and implement process improvements within reporting workflows
    • Ensure accuracy and integrity of financial data and calculations

Requirements

  • Essential
    • Advanced Microsoft Excel (formulas, PivotTables, structured models)
    • Strong understanding of financial statements and reporting logic
    • Understanding of Profit & Loss, Balance Sheet, GL structures
    • Experience handling exported system data (CSV / Excel dumps)
    • Strong analytical and problem-solving ability
    • High attention to detail and data accuracy
  • Advantageous
    • Experience with QuickBooks Online
    • Exposure to Power Query or reporting automation techniques
    • Experience maintaining recurring reporting templates
    • Familiarity with financial data structuring and reconciliations
    • Interest in efficiency tools (e.g. Copilot, automation tools)

If you are not contacted within 14 working days, please consider your application unsuccessful.

This offer from "iSTA Solutions" has been enriched by Jobgether.com and got a 82% flex score.
Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...