How do I create a financial chart of expenses

[Ymitchell]

My mgr travels often. I need to create a spreadsheet to input all her trips
and the tricky part is to keep account of which trips have not been paid yet
and how much money is still outstanding. There are different types of
expenses to be filed for each type of trip. Hope you can help. Thanks.

 

[Bernard Liengme]

In row 1 a list of headers: date (of departure), Place, Travel, Meals,
costX, costY, .... TOTAL, Paid
Enter the data fro each trip - one trip per row, with numbers under Travel,
Meals, etc
Suppose the Total in is column K, in K2 enter =SUM(C1:J2)
Copy this down to say row 50; don't worry about the zeros.
Example
1/1/2008 Moscow 4,567.45 456.89....................................
6,789.45
When mgr is reimbursed, put X in the Paid column (column L)

In M1 the text: Unrecovered expenses:
In N1 =COUNTA(B:B)-COUNTIF(L:L,"X") this tells you for how
many trips reimbursement is outstanding
In O1 =SUMIF(P,"",K:K) tell how much
is owed

But you really should master some basic Excel things before attempting a
project like this. How about reading excel for Dummies or similar book