Expense Tracker by  lovezonline  lovezonline 
  Log In  |  Create a FREE Account  |  Everyone's Spreadsheets  |  Tags  |  Help  
 Saving... 
  login to save   undo redo  |  bold italic font text underline more font formatting  |  align left align center align right  |  text color background text color  |  sum hide/show tools
  fx
Culprits
ExpenseP1P2P3P4Who PaidAmountEqual Shares
GasXXXXP121#VALUE!
ArcadeXXP110
TollsXXXXP315
LunchXXP150
DinnerXXXP2200
Spent#VALUE!#VALUE!#VALUE!#VALUE!
Resonsible#VALUE!#VALUE!#VALUE!#VALUE!
Delta
 
Average Rating:  Not rated (Not yet rated)
 
Name:  Expense Tracker by  lovezonline lovezonline 
Description:  !!Needs Countif support and SumIF support before I can finsih it!! This spreadsheet allows you to track trip expenses when going on a groups trip. It solves the problem of spliting costs by assigning trip costs based on who actually participated in various trip events. This has been road tested on several trips with groups from 2-12 people. This spreadsheet is for a group of up to 4 people. You simply put an 'X' in the column of the people who should pay for a partiicular item and the persons Initials in the who paid column. Fill out the amount and it calcuoates how much each person should have paid. At the bottom it works out how much you actually paid (Col F and G) and how much you should have paid (Col H) and works out a delta. At the end of the trip those who have a positive delta get owed money and the ones with a negative have to pay money.
Tags:  trip expense share  

[ default color ]
 
 recent: