Forum Discussion
Entering information on a daily sheet to be sent to monthly sheets in same workbook.
Thank you so much for your reply. You have so far given me more information than I have found anywhere else. Sorry for the bad pics but I tried to send others and could not, so had to reduce but was too far. I hope I can send these with no problems.
Everything in. the workbook. is done so it. is one entry and then everything is moved through formulas to the total sheets that show all income and expenses for the year and. then a final total only that I can take to an accountant. All work wonderfully but I have to go to so many sheets to enter the information I was trying to come up with a sheet that could be added to daily or weekly or whenever there was something to go in. This sheet is not meant to be a daily sheet and was not to be saved but cleared each time used and only would send information to the proper sheet instead of me having to go to every sheet to make the entries.
To you, I am sure this may look cumbersome but having. learned Excel from my own investigations and questions, it is what I have developed and have been trying to. use the best of Excel to make things happen for me with just a single entry. There are so many input items that I created a variety of sheets as you can see from the pictures of the workbook so I could enter only once. It is necessary to enter things daily in some cases and others are only once a month and others are only once a year. I attempted to divide rationally and create sheets that would make this easy for me. It began as a simple process for a small business, then I added personal to it, then two houses, and as it grew I continued to make it less and less cumbersome. Now I was trying to devise a single page that I could use to enter items that would send them to each page so I would not have to open all pages as I enter information. I make sense to you with my thought process.
If you still recommend a complete change then I would certainly need much more help with that but is not out of the question just would rather not have to spend as long as I did to do this workbook to this point before I could use it. I like the easiest and most simple way to get the end result I want which is entering everything once and then having at the end of the year click print and the end result with all totals come out ready for the accountant.
Sorry for the epistle but I do thank you very much for your input and looking forward to your comments
I really do advise rethinking all of this, ideally beginning with this new year, even though we're some six weeks into it (unless you want to do a different fiscal year).
I'm going to attach a simple example that is taken from the income and expense tracker that I personally use. The heart of it is a single database into which all income and well as expenses in the form of checks and credit card transactions are entered (via downloads from the various banks).
I then use the Excel tool known as a Pivot Table to report or sumarize on ALL of that activity, breaking things out on a monthly basis by budget category.
In your case, you might want to add one or two other ways of slicing this, which would be a matter of added columns to that central database. That would enable you to track income and expenses separately, for example, as they involve different houses (assuming those are themselves income producing properties that you want or need to track for tax reporting purposes).
But the basic idea is to enter all the data into a singe database and let Excel do the heavy lifting of analyzing it (i.e., breaking it apart). Excel is really good at the latter, if you get out of the way.