About

I have 3 locations (A,B,C) of incomes and expenses. Once a week I will put in excel the daily and weekly incomes and expenses of that week. I want 3 columns of incomes and 3 columns of expenses in the master sheet, and each date of the year will be a different row but please also add extra SUM rows for end of every week, month, and year. Daily expenses of 2 locations (A and B) are fixed as 10% of daily income from location A, and 15% from daily income of location B. But expenses of location C are our main challenge, these will vary. For ONLY the expenses of this location I will enter the expenses by using an Excel FORM. I will need a NEW blank form after I put in a new date for that form. Then I will put in yearly, monthly, weekly or daily expense on that date. I will also put in dates of payment, reason, duration from to (using a calendar to appear in the cells). Some expenses will be one time, some yearly, some for a few months, some every week, some only on some days, some scheduled on the 1st of every month etc, and I want to be able to put in any of those expenses on any day by choosing a new form of that date. In the future, by putting in that date, I should be able to see what expenses I had filled out on that date. Then, the yearly, or part yearly, or monthly or weekly or daily expenses should ADD up and AVERAGE to a total DAILY expense and show up in the main sheet as the expense of the 3rd location, side by side of expenses of A and B locations. I will ATTACH here a word document (“Examples”) to show as a template for the excel form, which shows some examples of the kinds of expenses I will put in, and I have explained these expenses in the attached document. The main sheet should have rows for each dare of the year (with day) and have extra rows for SUM of weekly, monthly, and yearly incomes and expenses. Additionally an extra column should show the dates of the forms (for expenses of the 3rd location) and another column showing the total of all amounts of that date (not SUM or daily average). The currency will be euro, with DD/MM/YY format.