This one I would recommend regardless of your skill level with accounting or Excel: Make one table with the raw data and then draw whatever summary or analysis you need from that and put it on another sheet.Admittedly, this will probably be too complex if you don't have any knowledge or interest in accounting, but if you do, it will give you much greater flexibility on what you can do with your personal finances (e.g., different current asset accounts for different budgets, making accruals, keeping tabs on accounts payables/receivables etc.) If you have some beginner accounting knowledge, I would suggest using double-entry bookkeeping.Like I said, this represents what I am looking for, but just mostly want input on Functionality!! I am very VERY new to budgeting this way and am trying. I have had others comment on how terrible this setup is. I'm not sure what I think about the charts yet. My weekly income on each Expense sheet: I would have to manually fill this formula for each month as far as I can tell to refer to the correct weekly income on the Income sheet. I am hoping to set up an account for these expenses alone. The Expense sheets with Envelopes include the amount paid per person, by week, total per month, and a running total through the months for each category that is less the amount spent per month. So far I am thinking of a sheet for each month, which can be difficult with all the formulas for a newbie like me. I am most curious about how to do this where I can have monthly sheets reflecting my envelope style and actual spending. I have created a workbook that fits the way I think about things for the most part. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Or use tableit, or the ExcelToReddit converter (thanks to u/tirlibibi17), to convert your data into a Reddit table. Provide some dataĪdd screenshots in your text post, or provide links to uploaded images at an image-hosting site. Tip: For VBA or Power Query, select the code, press Tab, then copy/paste the selection into your post or comment. The best way to display code on Reddit is to put it in a code-block This awards the user a ClippyPoint and changes the post flair to solved. OPs may (and should) reply to any solutions saying: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |