Finance & approvals
Corporate card expense log template and monthly reconciliation guide
A corporate card expense log is the monthly list in which a cardholder explains every charge on the company card: what it was for, who attended, which expense category it belongs to and whether a receipt is attached. The card statement shows the merchant and amount, but only the cardholder can say why the money was spent.
This page gives you a ready-to-use Excel template, field-by-field instructions, a filled-in example that includes a personal charge to be repaid, the documentation rules tax authorities expect and the mistakes that make finance teams send logs back. Unlike an expense report, where an employee asks to be reimbursed for their own money, this log reconciles money the company has already paid.
What is a corporate card expense log?
It is a reconciliation document. Each line of the card statement gets a date, merchant, expense account, business purpose, attendees for meals and entertainment, and the amount. The cardholder signs it, a manager approves it and finance posts the costs to the right accounts and checks that receipts support them.
Good logs show only the last four digits of the card, flag any personal charge openly together with how it will be repaid, and are submitted by a fixed date each month so the books can close on time.
When do you need a corporate card expense log?
- Every month after the card statement closes, by the deadline in your expense policy
- When you paid for client meals or entertainment and need to record attendees and purpose
- After a business trip charged to the company card
- When a personal purchase was put on the card by mistake and must be repaid
- Before quarter-end or year-end close, to clear unreconciled card charges
How to fill in the corporate card expense log
The Excel file contains these fields. Keep your card statement open and fill in one line per charge in date order.
Header
| Field | What to write | Example |
|---|---|---|
| Cardholder and department | Who used the card and their team. | Daniel Kim, Sales East |
| Card number | Last four digits only, never the full number. | **** **** **** 4821 |
| Statement period | The billing period on the card statement. | Oct 1 – Oct 31, 2026 |
| Approver | The manager who reviews and signs. | Laura Chen, Sales Director |
Transactions
| Field | What to write | Example |
|---|---|---|
| Date | Transaction date as shown on the statement. | 2026-10-08 |
| Merchant | Merchant name exactly as on the statement. | The Capital Grille |
| Expense account | The category from your chart of accounts. | Meals & entertainment |
| Purpose and attendees | Why you spent it and, for meals, who attended. | Dinner with ACME buyers J. Ruiz and K. Patel (3 people) |
| Amount | Amount charged, including tax and tip. | $236.75 |
Totals and sign-off
| Field | What to write | Example |
|---|---|---|
| Business and personal totals | Split the total into business charges and personal charges to be repaid. | Business $854.14 / personal $27.45 |
| Receipts attached | Confirm every line has a receipt or explain why not. | Receipts attached for all 5 charges |
| Cardholder declaration | Signature and date confirming the log is accurate. | Daniel Kim, 2026-11-03 |
Corporate card expense log example
A sales manager's October log. The last line is a personal purchase made by mistake; it is flagged in the purpose column and will be repaid by payroll deduction.
| Cardholder | Daniel Kim, Sales East |
|---|---|
| Card | ending 4821 |
| Period | October 2026 |
| Approver | Laura Chen |
| Submitted | 2026-11-03 |
Card transactions
| Date | Merchant | Account | Purpose / attendees | Amount |
|---|---|---|---|---|
| 2026-10-05 | Hilton Chicago | Travel – lodging | Client visit, 1 night | $189.00 |
| 2026-10-07 | Delta Air Lines | Travel – airfare | Round trip to Chicago for ACME review | $412.40 |
| 2026-10-08 | The Capital Grille | Meals & entertainment | Dinner with ACME buyers J. Ruiz and K. Patel (3 people) | $236.75 |
| 2026-10-14 | Zoom | Software | Monthly webinar plan | $15.99 |
| 2026-10-22 | Target | Personal – to repay | Household items charged by mistake; repay via payroll | $27.45 |
| Total | $881.59 |
Total charges $881.59: business $854.14 and personal $27.45 to be repaid. In the US only 50% of the business meal is generally deductible, so finance needs the attendees and purpose recorded.
Free download
Free, no sign-up. Opens in Excel, Google Sheets, Numbers, Word, Google Docs and LibreOffice.
Open the downloaded file in Nobami, our web office, to edit it right away.
How to reconcile your corporate card in 6 steps
- Download the card statement. Export the billing period to Excel or CSV and sort by date.
- Assign an expense account to each charge. Use your company's chart of accounts: travel, meals, software, supplies and so on.
- Write the purpose and attendees. For meals and entertainment, record the client company, names or headcount and the business reason.
- Flag personal charges and arrange repayment. Never hide a mistake; mark it and state how and when you will repay it.
- Attach receipts and check totals. Make sure the log total matches the statement total, then sign.
- Submit to your approver by the deadline. Late logs delay month-end close and tax filings.
Documentation rules for card expenses
In the US, the IRS expects you to substantiate travel, gift and meal expenses with the amount, time, place and business purpose, and for meals the business relationship of the people attending; business meals are generally only 50% deductible (IRS Publication 463). A card statement alone is not enough, which is why the log records purpose and attendees.
In the UK, business entertainment of clients is generally not deductible for corporation tax, so finance needs to know whether a meal was staff, client or travel subsistence to treat it correctly (HMRC Business Income Manual, BIM45000).
Whatever the country, keep receipts and logs for as long as your tax authority requires, and store them in a system with access control rather than in e-mail attachments.
Sources
- IRS Publication 463: Travel, Gift, and Car Expenses (checked November 8, 2026)
- HMRC Business Income Manual: business entertainment (BIM45000) (checked November 8, 2026)
General information, not tax or legal advice. Rules differ by country and company; follow your expense policy and your accountant.
Common corporate card log mistakes
- Recording a client dinner without naming the company or the attendees
- Splitting one bill across several card swipes to stay under an approval limit
- Hiding a personal charge inside a business category
- Writing the full card number on a file that gets shared
- Listing amounts without receipts or a missing-receipt explanation
- Submitting after the deadline so month-end close slips
Corporate card expense log FAQ
How is a corporate card log different from an expense report?
An expense report asks the company to reimburse money an employee paid personally. A corporate card log reconciles charges the company has already paid on its own card and explains each one.
What if I put a personal purchase on the company card?
Flag it as personal in the log, say how you will repay it (bank transfer or payroll deduction) and do it promptly. Hiding it is what turns a mistake into a disciplinary issue.
Do I really need to list attendees?
For meals and entertainment, yes. Tax rules and most expense policies require the business relationship of the people present. Use names and companies, not personal contact details.
I lost a receipt. What now?
Download the transaction record from the card provider and fill in a missing-receipt declaration if your policy has one. Repeated missing receipts are usually not accepted.
Does the template work in Google Sheets?
Yes. The .xlsx file opens in Excel, Google Sheets and Numbers, and the total formulas keep working.