Icon

Efficient Expense Report Management: A Step-by-Step Guide

Learn how to manage and process expense reports efficiently with our comprehensive guide. From receiving reports via email to finalizing payments, streamline your workflow with these best practices.

By Abby Brumfield

In this guide, we'll learn how to efficiently process and manage expense reports received via email. The process involves reviewing the details of the expense report, verifying receipts, and ensuring all necessary information is included. We'll also cover how to enter data into the appropriate accounting systems and prepare the necessary documentation for reimbursement. This guide aims to streamline the workflow, ensuring accuracy and compliance with company policies.

Let's get started

Okay. For expense reports, I receive them via email. They usually come from either Nate or Amy.

Occasionally, I receive an unusual one from Abby or even from Raul, but not very often. It appears in the format you see here. Nate has been doing it for a long time, so he's great at providing all the information I could possibly need in an email. One new addition is that Rachel has reviewed the content, confirming it has been checked. The first step in reviewing an expense report is to open the email containing the report.

1
Click on "2May2025_DaytonOH.pdf"
Step #1: Click on "2May2025_DaytonOH.pdf"
2
Click on "Open"
Step #2: Click on "Open"

3
See below
Step #3: See below
4
See below.
Step #4: See below.

Take a quick look to ensure it is complete. Check that it includes the project number, the reason for travel, and the appropriate signatures. Next, I will review the receipts. Now that Rachel is looking at this, many people are reviewing receipts. I haven't noticed any missing receipts. Once again, I go back and open the receipts. This time, all the receipts are grouped together in one package.

5
Click here
Step #5: Click here
6
Click here
Step #6: Click here
7
Click here
Step #7: Click here

This receipt is for $528.36, which covers the airfare.

8
Click on "JonHolzmanExpense Report"
Step #8: Click on "JonHolzmanExpense Report"

I do that for each set of receipts.

9
Click on "Receipts 28 Apr - 2 May DAY"
Step #9: Click on "Receipts 28 Apr - 2 May DAY"

The total amount for the hotels was 115.

10
Click on "JonHolzmanExpense Report"
Step #10: Click on "JonHolzmanExpense Report"

11
Click on "Receipts 28 Apr - 2 May DAY .... x"
Step #11: Click on "Receipts 28 Apr - 2 May DAY .... x"

I'm sorry, it seems like the text you provided is incomplete. Could you please provide the full text or more context so I can assist you better? This is what was over here.

12
Click on "JonHolzmanExpense Report"
Step #12: Click on "JonHolzmanExpense Report"

Yes, these were 1466. Yes. Next, I check the meals and incidentals to ensure they are separated correctly. We should have the three full days in the middle and 75% of each day at the beginning and end. I'm sorry, but it seems like the transcript you want me to refine is missing. Could you please provide the text you need help with?

13
Click on "Receipts 28 Apr - 2 May DAY"
Step #13: Click on "Receipts 28 Apr - 2 May DAY"
14
Click on "JonHolzmanExpense Report"
Step #14: Click on "JonHolzmanExpense Report"

Car rental, 28, okay. 264. We have 17 for fuel.

15
Click on "Receipts 28 Apr - 2 May DAY ... ×"
Step #15: Click on "Receipts 28 Apr - 2 May DAY ... ×"
16
Click on "JonHolzmanExpense Report"
Step #16: Click on "JonHolzmanExpense Report"

I'm sorry, but it seems like the text you provided is incomplete or not in a recognizable format. Could you please provide the full text or clarify the content you need help with?

17
Click on "Receipts 28 Apr - 2 May DAY ..."
Step #17: Click on "Receipts 28 Apr - 2 May DAY ..."
18
Click on "..."
Step #18: Click on "..."

48.

19
Click on "Receipts 28 Apr - 2 May DAY"
Step #19: Click on "Receipts 28 Apr - 2 May DAY"

After checking all the receipts, I need to go in here, and then I'll...

20
Click on "JonHolzmanExpense Report"
Step #20: Click on "JonHolzmanExpense Report"
21
Click here
Step #21: Click here

Once again, I will do this for your benefit. I would go to Steve's documents and...

22
Click on "SierTek Corporate -..."
Step #22: Click on "SierTek Corporate -..."

Because it takes me right to where I need to be. In Accounting, under Steve's Documents, at the bottom of the list, is Travel Tracker.

23
Click on "Accounting"
Step #23: Click on "Accounting"
24
Click on "Steve's Docs"
Step #24: Click on "Steve's Docs"
25
Right-click on "Travel tracker 2022.xlsx"
Step #25: Right-click on "Travel tracker 2022.xlsx"
26
Click on "Corporate -"
Step #26: Click on "Corporate -"
27
Click here
Step #27: Click here

I would return and search for John Holtzman's April 28th trip in the Travel Tracker.

28
Click here
Step #28: Click here
29
Drag "Travel tracker 2022.xlsx"
Step #29: Drag "Travel tracker 2022.xlsx"

I should already have it here because Nate sends me all this stuff, and I pre-approve it.

30
Click on "30 Holzman"
Step #30: Click on "30 Holzman"

I would enter the actual amount spent.

31
Click here
Step #31: Click here
32
Click here
Step #32: Click here

I enter these columns here. I enter the date when I will issue the check. I enter the fact that this is an ACH... Cannot spell. The date the check should be issued is typically tomorrow for ACH transactions.

If I enter them into the Wright-Patt Credit Union today, the checks will be issued tomorrow. However, since it's after 2:00, I probably won't enter this quickly. So, the date will likely change to 5/15 instead of tomorrow.

33
Click here
Step #33: Click here

I always leave this column out. This column shows the amount we will reimburse the employee, not the total expense report amount. In this case, they are both the same number. I enter the expense report amount here a second time. Once it's paid, I'll clear it from this column. At the bottom, there's a running total of outstanding expense reports.

34
Type "1735.93"
35
Total
Step #35: Total

I haven't been in for a while. They were all due on the 8th. They've probably all cleared. Next time I go into Wright-Patt, I will check the history and ensure those are cleared. As a point, I need to have that amount of money in the bank account.

36
See below
Step #36: See below

Although we usually keep it just above $10,000 to $15,000, I need to ensure that's covered. Sometimes, the amounts for expense reports can be quite large.

37
Click here
Step #37: Click here

As you can see, there's one here for almost $13,000. Sometimes, they can be a larger amount.

38
Drag here
Step #38: Drag here

That is probably not an expense report. Yes, that's an ACH I made to pay for the tech library. Once I've done that, the next step is to come back here and find the form labeled "Employee Expense Template." Then, I open it.

39
Click on "SierTek Corporate - Steve's Docs"
Step #39: Click on "SierTek Corporate - Steve's Docs"
40
Right-click on "Expense Payment Template.xlsx"
Step #40: Right-click on "Expense Payment Template.xlsx"

This is a cover sheet for the expense report.

41
Click here
Step #41: Click here
42
Click here
Step #42: Click here
43
Click here
Step #43: Click here

I used to put the routing numbers and similar information here for things like this because this is ICBM, which is a JV.

I need to send a copy of this expense report with my invoice to Peerless. However, I will not include any banking information for our employees. That would be unwise. Yes, that worked, right?

After completing that step, I print it as a PDF.

Open the downloads folder and locate the files in Adobe. Gather the expense report, receipts, and the cover sheet you just created.

44
Click on "Combine files"
Step #44: Click on "Combine files"
45
Click on "Add Open Files"
Step #45: Click on "Add Open Files"
46
Click on "Add Files"
Step #46: Click on "Add Files"
47
Drag here
Step #47: Drag here

Combine them into one file.

48
Click on "Combine"
Step #48: Click on "Combine"

I saved the file.

49
Click on "Save"
Step #49: Click on "Save"

I usually save this to a file labeled "Payments that Need to be Made."

I'll save it to Downloads, as it should go there.

50
Click on "↓ Downloads"
Step #50: Click on "↓ Downloads"

Unable to move that... I might need to change that description because I can't remember the exact dates. I save the file with the employee's name and the expense report dates. This way, when invoicing, I can check the travel tracker to see if any travel is linked to the invoice. This helps me identify which expense reports to use.

51
Click on "Save"
Step #51: Click on "Save"

In short, that is the process for creating the expense report and preparing it for submission. The next step is to make the payment. See the next SOP.

Efficient Expense Report Management: A Step-by-Step Guide