Without a corporate card, or when something has to be paid right now, you cover work costs yourself and claim them back later. Small amounts are easy to put off, then forget, and a few months later the receipts are gone too. Tracking each expense until the money is back in your account in a single table stops that money leaking away.

1. Photograph the receipt when you pay

When you pay for something work-related with your own money, photograph the receipt on the spot and put it in a Work expenses album. If you tapped your card and didn't take a receipt, many banks and card apps let you view transaction details you can screenshot, or you can ask the merchant for a copy. With a photo, a lost paper receipt no longer means a lost claim.

2. Build a reimbursement tracker

Once a week, add the album's photos to the receipt tool to get the date, store and total, and paste them into a Reimbursements sheet. Add tracking columns to the right.

Date Store Total Purpose Paid with Status Submitted Paid
8/4/2026 Office Plus 23.40 Training handouts Personal card Paid 8/8 8/25
8/12/2026 City Cabs 18.70 Client visit Personal card Submitted 8/14
8/19/2026 Green Bowl 64.00 Team lunch Personal card To submit

Limit Status to four values, To submit, Submitted, Paid and Rejected, and pick them from a Data Validation list.

3. Three numbers to watch

Put three calculations at the top of the sheet so you see them every time you open it.

  • Not yet submitted: =SUMIF(F:F, "To submit", C:C)
  • Submitted and waiting: =SUMIF(F:F, "Submitted", C:C)
  • Longest wait in days: in a spare column, =IF(F2="Submitted", TODAY()-G2, ""), then take the MAX of that column

A claim that's been waiting a long time is worth a polite follow-up. Conditional formatting that highlights waits over 30 days makes sure you notice.

4. Submit before your card bill is due

Whatever you put on your own card comes out of your account on the statement due date. If reimbursement arrives later, your money is tied up in the meantime. Put your card due date in your calendar and submit everything marked To submit two or three weeks before it. If your company has its own monthly cutoff, work to that instead.

5. When a claim is rejected

Claims get rejected for unreadable receipts, the wrong kind of proof or an unclear purpose.

  • Fill in Purpose on the day you pay, including who it was with and why. You won't remember in three weeks.
  • Check what your expense policy accepts, such as itemized receipts rather than card slips for meals, and ask for the right document when you pay.
  • Mark rejected claims as Rejected and note the reason, which helps when you resubmit and next time you pay.

Summary

Manage out-of-pocket expenses with a photo on the day you pay, a tracker with a status for every claim, and submitting before your card bill is due. Turn receipt photos into rows once a week, glance at the three numbers, and forgotten reimbursements become a thing of the past.