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 recuiterMember since Nov 11, 2022 Guneet Singh
from Greater Poland, Poland