Icon

Exporting, Allocating, and Reimporting Concur Imports into QuickBooks

Learn step-by-step how to export Concur imports from QuickBooks, reallocate by service and claim types, and reimport using a macro. This guide covers file management, macro usage, and syncing to IES for efficient accounting workflows.

By Jessica Esslinger

In this guide, we'll learn how to export a Concur import that has already been brought into QuickBooks, reallocate it by service and claim types, and then reimport it using a macro. This process helps ensure that your financial data is organized and accurately reflected in your records.

We'll cover how to locate the most recent Concur import, export and save the file, use a macro to automate allocations, and finalize the data for syncing.

Let's get started

In this SLP, we will cover how to export the Concur import that was previously imported into QuickBooks. We will go over exporting it, reallocating it by service types and claim types, and then reimporting it using a macro. We will find the most recent Concur import that just arrived.

1
Click on "transactions"
Step #1: Click on "transactions"
2
Type "concu"
3
Click on "02/26/2026 | $ 0.00"
Step #3: Click on "02/26/2026 | $ 0.00"

We will export it.

4
Click on "7 6"
Step #4: Click on "7 6"

Open the file.

5
Click on "144 KB Done"
Step #5: Click on "144 KB Done"

Click Enable Editing.

6
Click on "Enable Editing"
Step #6: Click on "Enable Editing"

Next, go to File, select Save As, and choose This PC.

7
Click on "File"
Step #7: Click on "File"
8
Click on "Save As"
Step #8: Click on "Save As"
9
Double-click on "This PC"
Step #9: Double-click on "This PC"

Next, go to the folder Concur Import Allocations. I will provide you with the path.

10
Click on "Concur - Import Allocations"
Step #10: Click on "Concur - Import Allocations"

We will save it as the current month. Right now, it's "Concur Export," and I already have one saved here.

11
Click on "97-2003 Workbook"
Step #11: Click on "97-2003 Workbook"
12
Double-click here
Step #12: Double-click here
13
Type "02.26 - "
14
Click on "Save"
Step #14: Click on "Save"
15
Click on "Yes"
Step #15: Click on "Yes"

From here, simply exit.

16
Click here
Step #16: Click here

Next, open the Concur macro by clicking on Monthly Concur Macro.

17
Click here
Step #17: Click here
18
Drag here
Step #18: Drag here
19
Click on "☐"
Step #19: Click on "☐"
20
Click on "Concur - Import Allocations"
Step #20: Click on "Concur - Import Allocations"
21
Double-click here
Step #21: Double-click here

From here, go to Macro, select Macros, then click Run.

22
Click on "Macros"
Step #22: Click on "Macros"
23
Click on "Run"
Step #23: Click on "Run"

Find the file you just saved, select it, and click Open.

24
Click on "Concur - Import Allocations"
Step #24: Click on "Concur - Import Allocations"
25
Click on "02.26 - Concur Export"
Step #25: Click on "02.26 - Concur Export"
26
Click on "Open"
Step #26: Click on "Open"

It will prompt you to enter a journal number for how you want it to appear in QuickBooks. I will enter the journal number "Concur Import." The system will prompt for the entry date, which should be the last day of the month or the date it was transferred out.

27
Type "02.26 - Concur Import"
28
Click on "OK"
Step #28: Click on "OK"

Press OK, then enter your journal description.

29
Type "2/28/2028 + Tab"
30
Click on "OK"
Step #30: Click on "OK"
31
Click here
Step #31: Click here

Since this was for January Concur expenses, that is what I'm going to type. Click OK, and it generates your sheet automatically. It allocates everything you need.

32
Type "01.26 - Concur Expenses"
33
Click on "OK"
Step #33: Click on "OK"
34
Click on "OK"
Step #34: Click on "OK"
35
Click here
Step #35: Click here
36
Drag "A"
Step #36: Drag "A"
37
Double-click here
Step #37: Double-click here
38
Drag "14840.75"
Step #38: Drag "14840.75"
39
Click on "2/28/2028 01.26 - Concur Expenses"
Step #39: Click on "2/28/2028 01.26 - Concur Expenses"
40
Click on "32 02.26 - Concur Import"
Step #40: Click on "32 02.26 - Concur Import"

These last three rows are not needed since they are zero.

41
Click here
Step #41: Click here

I'm going to press Delete. From here, go to File, select Blank Workbook, then choose Red Sheet Sync. You can use this option as well.

42
Click on "File"
Step #42: Click on "File"
43
Click here
Step #43: Click here
44
Click on "ab"
Step #44: Click on "ab"
45
Click on "Get started"
Step #45: Click on "Get started"

Go to Manageability.

46
Click on "device with Intuit"
Step #46: Click on "device with Intuit"
47
Click here
Step #47: Click here
48
Type "Somanysprinkles030323! + Enter"
49
Click on "Not now"
Step #49: Click on "Not now"
50
Click on "Inc."
Step #50: Click on "Inc."

Choose Create or Edit Records. Set company manageability and the record type of journal entries. Add new records to IES. Select dimension columns, claim type, and service type. Click Template.

51
Click on "Create or modify records and sync"
Step #51: Click on "Create or modify records and sync"
52
Click here
Step #52: Click here
53
Click here
Step #53: Click here
54
Click on "Select dimension columns"
Step #54: Click on "Select dimension columns"
55
Click on "☐ Claim Type"
Step #55: Click on "☐ Claim Type"
56
Click on "Service Type"
Step #56: Click on "Service Type"
57
Click on "Get template"
Step #57: Click on "Get template"

Here's the template. While that is generating, we will go to the automatically generated sheet it created for us.

58
Click here
Step #58: Click here
59
Click here
Step #59: Click here
60
Click on "Operating Expenses"
Step #60: Click on "Operating Expenses"
61
Click on "Payroll & Employee Expenses"
Step #61: Click on "Payroll & Employee Expenses"

Select all, remove the top section, then press Copy.

62
Type "Ctrl + A"
63
Click on "1"
Step #63: Click on "1"
64
Click on "1"
Step #64: Click on "1"
65
Type "Ctrl + C"

It looks ready for us.

66
Click here
Step #66: Click here
67
Drag here
Step #67: Drag here
68
Click here
Step #68: Click here

Right-click on the journal number, select Paste Special, and check that everything looks correct. It does.

69
Right-click here
Step #69: Right-click here
70
Click here
Step #70: Click here
71
Drag here
Step #71: Drag here
72
Double-click here
Step #72: Double-click here
73
Click here
Step #73: Click here
74
Drag here
Step #74: Drag here

The only thing missing that I might add to this macro, which you won't need, is to copy and paste this bottom row.

75
Click on "Operating Expenses"
Step #75: Click on "Operating Expenses"
76
Drag "02.26"
Step #76: Drag "02.26"
77
Type "Ctrl + C"
78
Drag here
Step #78: Drag here

Next, we will set up the bank account.

79
Click here
Step #79: Click here
80
Type "Ctrl + V"
81
Click on "Payroll & Employee Expenses"
Step #81: Click on "Payroll & Employee Expenses"
82
Type "9230"
83
Click on "Fifth"
Step #83: Click on "Fifth"
84
Click here
Step #84: Click here

Debit, erase, and credit. We need the total amount being imported.

85
Double-click here
Step #85: Double-click here
86
Click here
Step #86: Click here
87
Click here
Step #87: Click here
88
Drag "35.28"
Step #88: Drag "35.28"

Excuse me. 23/06/2015.

89
Click here
Step #89: Click here

I'll do a sum because I can't remember.

90
Type "Backspace"
91
Type "=sum("
92
Drag "35.28"
Step #92: Drag "35.28"
93
Type "Enter"
94
Type "Ctrl + V"
95
Right-click on "23,620.15"
Step #95: Right-click on "23,620.15"
96
Click on "23,62"
Step #96: Click on "23,62"
97
Type "Ctrl + C"

23/06/2015.

98
Right-click on "23,620.15"
Step #98: Right-click on "23,620.15"
99
Click here
Step #99: Click here
100
Click here
Step #100: Click here
101
Click on "23,620.15"
Step #101: Click on "23,620.15"
102
Type "Esc"
103
Click here
Step #103: Click here

I will change this to none, and this to none.

104
Type "non"
105
Double-click on "Review"
Step #105: Double-click on "Review"

Scroll all the way over, go to Post, click Yes, and drag it down.

106
Type "non"
107
Click here
Step #107: Click here
108
Click here
Step #108: Click here
109
Drag here
Step #109: Drag here
110
Click here
Step #110: Click here
111
Double-click on "Yes"
Step #111: Double-click on "Yes"
112
Drag "POST ? Select Yes if you wish to post this line"
Step #112: Drag "POST ? Select Yes if you wish to post this line"

Everything looks good.

113
Click here
Step #113: Click here

From here, click "Sync to IES," then click "Sync."

114
Click on "Sync to IES"
Step #114: Click on "Sync to IES"
115
Click on "Sync"
Step #115: Click on "Sync"
116
Click here
Step #116: Click here