Hello Gurus
I need some help in putting together an accounting excel file.
I have two sheets
Sheet 1 has the following columns
Column 1: Date
Columns 2-8 have some information that does not include any calculations
Column 9: Amount Deposited in Bank
Sheet 2 has the following columns
Column 1: Expense Type
Column 2: Expense Purpose
Column 3: Estimated Amount
Column 4: Amount Given To
Column 5: Actual Expense Amount
Column 6: Amount returned back
Column 7: Balance remaining in the bank
Sheet 1 will have one row per day.
Example:
July 13th.........................$1000
Sheet 2 will have expenses for that day which may be more than one row per day.
Example:
July 13th..Stationery purchase..$300..Jim..$250..$50..The balance remaining in the bank should be calculated as follows. $1000-250 which is $750
If there were more rows in the second sheet for July 13th then each row should be calculated based on the amount deposited on that day as per information in sheet 1.
I had a simple excel file and it worked ok until this morning. THat is on July 7th the amount deposited was $100, July 8th another $100 with no expenses on those days. All of a sudden on July 9th, the deposit was $100 but the expense was $250 which meant that I had to go back and add the deposited amount on the 7th, 8th and 9th and then deduct the expense on the 9th. I just calculated for each day and since the 9th had a bigger expense than deposit, the numbers were all off.
Not sure if I clearly stated my problem, but I am positive that some of you may have understood the problem. Thanks so much in advance for your response and help
S
I need some help in putting together an accounting excel file.
I have two sheets
Sheet 1 has the following columns
Column 1: Date
Columns 2-8 have some information that does not include any calculations
Column 9: Amount Deposited in Bank
Sheet 2 has the following columns
Column 1: Expense Type
Column 2: Expense Purpose
Column 3: Estimated Amount
Column 4: Amount Given To
Column 5: Actual Expense Amount
Column 6: Amount returned back
Column 7: Balance remaining in the bank
Sheet 1 will have one row per day.
Example:
July 13th.........................$1000
Sheet 2 will have expenses for that day which may be more than one row per day.
Example:
July 13th..Stationery purchase..$300..Jim..$250..$50..The balance remaining in the bank should be calculated as follows. $1000-250 which is $750
If there were more rows in the second sheet for July 13th then each row should be calculated based on the amount deposited on that day as per information in sheet 1.
I had a simple excel file and it worked ok until this morning. THat is on July 7th the amount deposited was $100, July 8th another $100 with no expenses on those days. All of a sudden on July 9th, the deposit was $100 but the expense was $250 which meant that I had to go back and add the deposited amount on the 7th, 8th and 9th and then deduct the expense on the 9th. I just calculated for each day and since the 9th had a bigger expense than deposit, the numbers were all off.
Not sure if I clearly stated my problem, but I am positive that some of you may have understood the problem. Thanks so much in advance for your response and help
S
