I would like to create a database using free software to track all personal expenditures by category, etc. Pre-covid, I used to collect all receipts from anything purchased by me or my family and I would keep the receipts in manilla envelopes by month. I started creating a spreadsheet to enter every purchase, but stopped collecting receipts at the beginning of Covid.
I would like to create a simple form/database to make the data entry easier and then be able to run queries to track spending in general categories as well as specific types of purchases.
So far I have an idea of having General Categories such as:
FOOD
My data analysis would consist mainly of running queries to determine the amount we spend in a month or year for a specific item such as peanut butter, sales tax, fuel, etc.
I would like to also be able to do simple graphs to visualize spending trends, etc.
I would like to create my own database if possible rather than buying some sort of budgeting software.
I would like to create a simple form/database to make the data entry easier and then be able to run queries to track spending in general categories as well as specific types of purchases.
So far I have an idea of having General Categories such as:
- Food
- Clothing
- Vehicle
- Home
- Garden
- Health
- Pet
- Entertainment
FOOD
- Fruit
- Vegetable
- Meat
- Dairy/Eggs
- Frozen Foods
- Candy/Treats
- Food Preservation & Supplies
My data analysis would consist mainly of running queries to determine the amount we spend in a month or year for a specific item such as peanut butter, sales tax, fuel, etc.
I would like to also be able to do simple graphs to visualize spending trends, etc.
I would like to create my own database if possible rather than buying some sort of budgeting software.