Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Accounting Database
#1
Rainbow 
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*.


Attached Files
.xlsx   Accounting-Sheet-FY2019.xlsx (Size: 237.48 KB / Downloads: 3)
Reply


Forum Jump: