Automated Google Sheets Financial Tracker

Job ID: 39048462

Budget: $30 – $250 USD

I'm searching for a skilled developer who can create an automatic Google Sheets generator for me. This tool will connect to my bank and import my business's transaction history, providing a comprehensive overview of my finances.

It should include:
- Various types of graphs and charts (Line charts, Bar charts, Pie charts) to visually represent our financial performance and highlight areas of concern.
- The capability to incorporate company goals and forecast potential growth based on our expenses.

Key aspects to be tracked:
- Revenue
- Expenses
- Profit Margins

Ideal skills for this job include proficiency in Google Sheets, experience with financial data analysis, and a good understanding of data visualization. Previous work with creating automated sheets and connecting them to bank data would be a huge plus. I need this project to be completed as soon as possible so I can start monitoring my business's financial health effectively. I need it to be as detailed as possible, we need to know how much we are spending on employee pay, how much we are spending on contractors, on lab equipment, how much is the average reimbursement we are receiving from each individual insurance company, what cpt codes are averagely reimbursing, etc.