RIPL Community of Practice

Full Version: Accounting Database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
My attempt at creating an accounting database. It does work. I'm not sure if converting from *.ods to *.xlsx foobared anything, but basically it's my expenditures, my accounts, my budgets, all that jazz. i have it populate reports using vlookups, nested conditional sums, and some more tricky stuff.

I hope to improve and simplify the program into a simpler, more usable form. Currently some of the sheets are... unwieldy *cough* the reconcile sheet *cough*.