Our existing spreadsheet for consolidating, reconciling and tracking account and payments data is inefficient and needs an overhaul.
There are about 6-7 different sources and types of account data. Because data about a single account comes from multiple sources, the data needs to be correlated and reconciled based on the input of a monthly data dump, ensuring that the correct accounts are being charged the correct amounts.
Then, as payments come in, the spreadsheet needs to allow for daily manual entry and verify that the amounts are coming from the correct accounts, continuously updating accounts receivable.
This project requires strong knowledge of spreadsheet functions. Perhaps macros are needed. This is not a financial model, but an advanced accounting model. Turnaround time: <1 week.