Google Sheet and Macro Expert or Developer

Seeking a programmer that is fluent in Google Sheets with experience in Excel + VBA to build complex scripts, macros and pivot tables to build multiple operational and financial spreadsheets (financial calculator, revenue, daily account receivables and payment arrengements) for a truck fleet manager . This will have a fixed-cost and delivery time.

Project Details:

1. Financial Calculator to be updated based on real data. Based on a model that we will share, we will be looking to build a calculator to determine the plausible terms for a truck loan and then as we receive payment information (as described below) , we would like to update the actual payments received and update indicators and financial terms.
2. We are building our account receivables, collections and payment arrangement management system and dashboard. We anticipate that this project will require the development of lookup tables, pivot tables, and a few macros. However, we look forward to hearing what you propose would be the best solution.
1. Generate daily account receivables that can be manually overrided.
2. Handling the actual payments received (collections) raw data from payment processor reports (.csv) and transform them into beautifully formatted spreadsheets summarizing revenue and other indicators by truck, for each day, the past 7 days, and the past month.
3. Create a form to input payment arrangement plans, which will update into the account receivables for that day and potentially affect the financial terms.
4. Additionally, we will have final report sheets with bar graphs that summarize the transaction data for snapshot analysis.
About the recuiter
Member since May 20, 2018
Riki Permana
from Queensland, Australia

---

---

Offer to work on this project closes in 117 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions