[Solved] Track income/expenses by day

Discuss the spreadsheet application
Locked
Vancouver_Guy
Posts: 1
Joined: Sun Jun 23, 2024 4:27 am

[Solved] Track income/expenses by day

Post by Vancouver_Guy »

I have searched and looked at many templates but have not found the one I want.

I have one on excel but it is through work and when I stop working I will not have access to it. I can't even download it!

I want something where I can enter the income each month (or set it up to do it automatically as well as payroll deductions) and then daily enter any amount I have spent and select the type of expense. It keeps a running total of the amount of money left. At the end of the month I can see the totals for Groceries, auto, etc.
Attachments
What I have now looks like this.
What I have now looks like this.
Screen Shot 2024-06-22 at 7.35.05 PM.png (47.82 KiB) Viewed 3052 times
Last edited by MrProgrammer on Sun Jun 30, 2024 6:27 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] Suggestions provided and no response from Vancouver_Guy -- MrProgrammer, forum moderator
Open Office 4.1.3 on Mac OS Monterey 12.7.5
User avatar
MrProgrammer
Moderator
Posts: 5430
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: A spreadsheet where I can track expenses by each day

Post by MrProgrammer »

Hi, and welcome to the forum.
Vancouver_Guy wrote: Sun Jun 23, 2024 4:36 am I want something where I can enter the income each month (or set it up to do it automatically as well as payroll deductions) and then daily enter any amount I have spent and select the type of expense. It keeps a running total of the amount of money left. At the end of the month I can see the totals for Groceries, auto, etc.
There must be hundreds of topics in the Calc forum about this sort of idea. You might benefit by reading them. You can search for them as well as I. The search box is at the upper-right of every forum page. Some probably will refer to "budget' or to "bank statement" or "personal finance".

There are also applications like GnuCash which have all of this programmed for you using a database. Of course you will need to read their documentation. But, depending on your skills, this might be quicker than learning how to do this yourself with Calc or with Base. They will also have features which may be helpful for you but which will be difficult to do in Calc without a great deal of work. If you don't like GnuCash, which is free and downloaded about 7000 times a week, there are plenty of others, some free, some not. YNAB seems to be highly regarded. I don't personally use any of them.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.8, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Locked