The Problem

We recently had a customer come to us that was beginning to utilize Concur Invoicing and Concur Expense for all 50 of their companies and wanted the import files generated by Concur to automatically create the appropriate transactions in QuickBooks®. An import file was being generated each day when new Invoices were entered into the Concur system. That meant if one invoice was entered each day for each company file there could be a total of 250 files each week that would then need to be imported into QuickBooks®; not to mention the files generated to create the Bill Payments in QuickBooks® as well. All of these files needed to be downloaded via FTP, decrypted and then manually imported into the correct QuickBooks® file. This was a very time consuming process the customer did not want to go through.

The Solution

We took this challenge head on, working with the team at Concur to develop a solution that would streamline and automate the entire process. Our solution has a simple setup process after which all the user has to do is monitor an error folder in case any issues arise. Our custom solution downloads the import files from the FTP site, decrypts the files, archives a copy of the file, opens the correct QuickBooks® file, creates the Bills and Bill Payments, closes QuickBooks® and moves to the next set of files. If another company is added then a quick 30 second setup is needed and the next time the program runs the new company falls right in line and everything gets done for the new file with no additional work needed.

This solution is a huge time saver for the customer and it is a solution that could be easily adapted to work for other Concur users. We were also able to get the Concur Expense product to import as well.

Please contact us if you would like to automate your Concur importing too!

Leave a Reply

Your email address will not be published.