Formulas

Value description Notation letter Formula
Total Expenses: a a = Sum of all expenses excluding cash advances
Less Personal Expenses: b b = Sum of all expenses marked personal, excluding cash advances
Business Expenses: c c = a-b
Less Unauthorized Expenses: d d = Sum of unapproved amounts
Authorized Expenses: e e = c-d
Less Company Paid Expenses: f f = Total of all Company Paid line items, excluding cash advances
Less Cash Advances: g g = Sum of all cash advances
Amount Due Employee: i i = e – f – g