Over the last few months, we have been interfacing with several companies that use Microsoft Dynamics GP. The inevitable question that we hear during the requirements phase is related to importing transactions from the corporate credit card. How does it work? Basically, a corporate card is provided to each employee and they are expected to enter/import expenses on the card within the reporting system. Once the expense report is approved, the data is pushed to GP. After this, the accounting department then does the reconciliation between the employee-submitted corporate card expenses and the card statement. If everything is correct, this should balance out. That’s the gist of it.
As we know, GP has an Expense Management add-on called eExpense. This provides online expense reporting and helps companies automate their expense submission process. But eExpense does not provide an interface for managing and tagging corporate credit card expenses. That’s where we come in!
Within the Gorilla Expense application, users can import transactions from their corporate card and even their personal cards. For this discussion, we will stick to the corporate card only. After the transactions are imported, our application allows the users to tag them with specifics – such as expense type, codes, projects, cost centers or account numbers. These fields are setup in the Gorilla application based on how it is setup in GP. The user can also split each card transaction into multiple cost centers. Once the compiling and tagging is done, the report is then available to the manager and finally the accounting folks to approve.
Once the approval is complete, the final ‘gatekeeper’ sends the transactions to GP using the Gorilla Integration Manager (GIM). The GIM is a very versatile & flexible tool that allows the gatekeeper to map specific parameters and fields to codes and accounts within GP. So, with the push of a button, all the transactions are available within GP and they have been tagged appropriately and immediately.
Our application combined with the GIM takes the pain out of importing and processing corporate credit card transactions. It is a “cannot live without” (actual customer quote) tool for accounting folks that cuts-down the processing time, effort involved and importantly data entry errors. So there you have it. A quick synopsis of the Gorilla Expense – Great Plains symbiosis!
If you have any questions or need assistance in implementing or customizing our application with GP, send us a message at [email protected] or 877.973.6737.