Template to track credit card expenses and expense reports combi

[sunshinelover]

In search of a template to track corporte credit card expenses and the
expense reports submitted for those expenses. Or a template to track and
reconcile credit card expenses and expense reports.

 

[Michael]

You could create your own. Incude in Row 1 as column headers:
Transaction ID
Transaction Reference
Transaction Date
Vendor
Cleared
Amount
Balance
You might also want a column for month for sorting and subtotaling purposes.
If date is in column C, in D2 for month type =month(C2) and copy down. If
you do use subtotals you won't need the Balance column.
HTH

 

[Dodo]

In search of a template to track corporte credit card expenses and the
expense reports submitted for those expenses. Or a template to track
and reconcile credit card expenses and expense reports.

Might find something here:

http://office.microsoft.com/en-us/templates/CT011356681033.aspx