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.

March 17, 2026 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.

Step #1: Click on "transactions" — Click on "transactions"

Type "concu"

Step #3: Click on "02/26/2026 | $ 0.00" — Click on "02/26/2026 | $ 0.00"

We will export it.

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

Open the file.

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

Click Enable Editing.

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

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

Step #7: Click on "File" — Click on "File"

Step #8: Click on "Save As" — Click on "Save As"

Step #9: Double-click on "This PC" — Double-click on "This PC"

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

Step #10: Click on "Concur - Import Allocations" — 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.

Step #11: Click on "97-2003 Workbook" — Click on "97-2003 Workbook"

Step #12: Double-click here — Double-click here

Type "02.26 - "

Step #14: Click on "Save" — Click on "Save"

Step #15: Click on "Yes" — Click on "Yes"

From here, simply exit.

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

Step #20: Click on "Concur - Import Allocations" — Click on "Concur - Import Allocations"

Step #21: Double-click here — Double-click here

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

Step #22: Click on "Macros" — Click on "Macros"

Step #23: Click on "Run" — Click on "Run"

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

Step #24: Click on "Concur - Import Allocations" — Click on "Concur - Import Allocations"

Step #25: Click on "02.26 - Concur Export" — Click on "02.26 - Concur Export"

Step #26: Click on "Open" — 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.

Type "02.26 - Concur Import"

Press OK, then enter your journal description.

Type "2/28/2028 + Tab"

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.

Type "01.26 - Concur Expenses"

Step #37: Double-click here — Double-click here

Step #38: Drag "14840.75" — Drag "14840.75"

Step #39: Click on "2/28/2028 01.26 - Concur Expenses" — Click on "2/28/2028 01.26 - Concur Expenses"

Step #40: Click on "32 02.26 - Concur Import" — Click on "32 02.26 - Concur Import"

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

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.

Step #42: Click on "File" — Click on "File"

Step #45: Click on "Get started" — Click on "Get started"

Go to Manageability.

Step #46: Click on "device with Intuit" — Click on "device with Intuit"

Type "Somanysprinkles030323! + Enter"

Step #49: Click on "Not now" — Click on "Not now"

Step #50: Click on "Inc." — 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.

Step #51: Click on "Create or modify records and sync" — Click on "Create or modify records and sync"

Step #54: Click on "Select dimension columns" — Click on "Select dimension columns"

Step #55: Click on "☐ Claim Type" — Click on "☐ Claim Type"

Step #56: Click on "Service Type" — Click on "Service Type"

Step #57: Click on "Get template" — Click on "Get template"

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

Step #60: Click on "Operating Expenses" — Click on "Operating Expenses"

Step #61: Click on "Payroll & Employee Expenses" — Click on "Payroll & Employee Expenses"

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

Type "Ctrl + A"

Type "Ctrl + C"

It looks ready for us.

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

Step #69: Right-click here — Right-click here

Step #72: Double-click here — Double-click 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.

Step #75: Click on "Operating Expenses" — Click on "Operating Expenses"

Type "Ctrl + C"

Next, we will set up the bank account.

Type "Ctrl + V"

Step #81: Click on "Payroll & Employee Expenses" — Click on "Payroll & Employee Expenses"

Type "9230"

Step #83: Click on "Fifth" — Click on "Fifth"

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

Step #85: Double-click here — Double-click here

Excuse me. 23/06/2015.

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

Type "Backspace"

Type "=sum("

Type "Enter"

Type "Ctrl + V"

Step #95: Right-click on "23,620.15" — Right-click on "23,620.15"

Step #96: Click on "23,62" — Click on "23,62"

Type "Ctrl + C"

23/06/2015.

Step #98: Right-click on "23,620.15" — Right-click on "23,620.15"

Step #101: Click on "23,620.15" — Click on "23,620.15"

102

Type "Esc"

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

104

Type "non"

Step #105: Double-click on "Review" — Double-click on "Review"

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

106

Type "non"

Step #111: Double-click on "Yes" — Double-click on "Yes"

Step #112: Drag "POST ? Select Yes if you wish to post this line" — Drag "POST ? Select Yes if you wish to post this line"

Everything looks good.

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

Step #114: Click on "Sync to IES" — Click on "Sync to IES"

Step #115: Click on "Sync" — Click on "Sync"

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.

March 17, 2026 By Jessica Esslinger

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

Type "concu"

We will export it.

Open the file.

Click Enable Editing.

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

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

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

Type "02.26 - "

From here, simply exit.

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

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

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

Type "02.26 - Concur Import"

Press OK, then enter your journal description.

Type "2/28/2028 + Tab"

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.

Type "01.26 - Concur Expenses"

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

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.

Go to Manageability.

Type "Somanysprinkles030323! + Enter"

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.

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

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

Type "Ctrl + A"

Type "Ctrl + C"

It looks ready for us.

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

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

Type "Ctrl + C"

Next, we will set up the bank account.

Type "Ctrl + V"

Type "9230"

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

Excuse me. 23/06/2015.

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

Type "Backspace"

Type "=sum("

Type "Enter"

Type "Ctrl + V"

Type "Ctrl + C"

23/06/2015.

102

Type "Esc"

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

104

Type "non"

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

106

Type "non"

Everything looks good.

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