Are you an experienced coder with a knack for seamlessly integrating financial data from Xero and QuickBooks into Excel? We're seeking a skilled individual to develop a custom solution that will streamline the process of downloading financial information and populating predefined Excel templates.
Key Responsibilities:
1. Develop a solution that allows users to select clients from Xero or QuickBooks directly within Microsoft Excel. 2. Enable users to choose specific types of reports such as Balance Sheet, Profit & Loss, Trial Balances, and more, all from within Excel. 3. Design a system that automatically feeds the selected data into predefined Excel worksheets, ensuring accuracy and efficiency.
Requirements:
1. Proficiency in coding languages such as Python, VBA, or similar, with a focus on integrating APIs (Xero and QuickBooks). 2. Expertise in working with Microsoft Excel, including creating dynamic user interfaces and automating data entry processes. 3. Experience in developing custom solutions for financial data management and reporting.