ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Template to track credit card expenses and expense reports combi (https://www.excelbanter.com/excel-discussion-misc-queries/40392-template-track-credit-card-expenses-expense-reports-combi.html)

sunshinelover

Template to track credit card expenses and expense reports combi
 
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
--
Sincerely, Michael Colvin


"sunshinelover" wrote:

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.


Dodo

"?B?c3Vuc2hpbmVsb3Zlcg==?="
wrote in
:

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 he

http://office.microsoft.com/en-us/te...356681033.aspx


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)


All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com