The job is to build a custom accounting ledger for a pawn brokerage business in Excel. The ledger is very straight forward in that its sole purpose is to keep track of money flows out (loans) and in (payments of principle and interest) of multiple loans. Reporting functionality is required including a) interest paid year to date (or inception to date) on a particular loan, b) summary of all loans outstanding, c) print/report function to create monthly interest invoices.
To clarify further, this is an issue of Excel functionality. I already have a spreadsheet that does what I need. What I am looking for is the automation of the spreadsheet in some form of data entry form. Maybe a better description would be a Quicken-lite piece of software. In Excel, using some sort of macro or VBA, create a form which will receive the information around the activity (interest paid, interest accrued, principle paid, new loan principle sent) and then calculate and summarize the loan in a ledger.
Potential to work collaboratively in the future to design and tweak the ledger with additional customizations.