RIPL Community of Practice
Accounting Database - Printable Version

+- RIPL Community of Practice (https://ripl.lrs.org/cop)
+-- Forum: Research Institute for Public Libraries (https://ripl.lrs.org/cop/forumdisplay.php?fid=1)
+--- Forum: Rip-Off and Duplicate (https://ripl.lrs.org/cop/forumdisplay.php?fid=5)
+--- Thread: Accounting Database (/showthread.php?tid=363)



Accounting Database - ryanhigginbothan - 06-04-2019

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*.