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 Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved.
OPs can (and should) reply to any solutions with: 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.Concur: Cliqbook/Concur is an online system which allows you to make your travel arrangements, submit your travel expense reports, and update your purchasing card transactions.Ohio University Policy 03.015 Travel Advances: This policy provides for advances to be issued only when an employee is traveling with a group of students and a P-card or Controlled Value Card cannot meet the student's travel expenses or if an employee is traveling to a remote geographical area where a P-card or Controlled Value Card is not accepted.This policy outlines the procedures and authority for expenditures and reimbursement for official travel of University employees and students. Ohio University Policy 41.121 Reimbursement for Official Travel and Entertainment: Ohio Revised Code 126.31 enables employees of the University to be reimbursed for actual and necessary travel and other expenses incurred while on official business inside or outside the State of Ohio if authorized by the University.Division of Finance Website: Information regarding per diem rates for domestic travel and link to the Travel Expense Report (Microsoft Excel) for planning purposes.Part-time and Overload Teaching Rates: Memo from Provost regarding part-time and overload teaching rates.Salary Calculation Cheatsheet : A quick reference guide containing information about benefit rates, time breakdown of academic, calendar and summer months, and other pertinent information needed when preparing a budget for a granting agency.Information regarding Graduate fee waivers may also be found in this document. Benefit Expense Rates Fringe Benefit rates include Group Health Insurance, Medicare, Workers' Compensation, and Retirement.National Science Foundation (NSF) Templates National Institutes of Health (NIH) Templates NOTE: These templates were revised for FY 2016. If you have any questions, please contact the ORSP Service Center at or call 740.597.6777 (ORSP). These templates were prepared using Microsoft Excel and are provided to assist with budget creation for proposals at Ohio University.