Archive for month: October, 2014

You are here: / / October

Import Credit Card Data into Dynamics NAV Through Automation

/1 Comment/in , , , , /by

Gorilla Expense offers a robust and fully automated integration of credit card data into Dynamics NAV. This is available for all versions of NAV. Using our proprietary Gorilla Expense Integration App, the AP Manager can import credit card transactions (or the App can do it 100% automatically), auto-categorize the transactions to specific expense types/cost categories using our mapping algorithm and then send the data to Navision with a click of a button!

Typically the data is sent to the Purchase Journals in NAV (video of integrating expenses to Purchase Journals) so that an invoice is created to pay the credit card company. But we can also send the data to the General Journals (video of integrating expenses to General Journals) as well as Purchase Invoice screen (Visit our main Expense Reporting for Dynamics NAV page for more details). Any relevant information supplied by the credit card company in the data file can also be referenced in the ‘Description’ field within the Journals or Purchase Invoice Lines in NAV.

The advantages that the Gorilla Integration App offers are:

* Send credit card data to NAV through automation

* Complete visibility of credit card expenses in NAV

* Prevent duplicate expenses in NAV

* Improve the reconciliation process through reporting and analytics within Gorilla Expense

* Eliminate time consuming manual work of keying in data

Gorilla Expense supports integration with all the major credit card companies – AMEX, VISA and MasterCard and their various file formats. The flavors of credit cards that we support range from the standard Corporate Credit Card for T&E Expenses to Purchase Cards or P-Cards for making purchases on behalf of the employer.

Here is how the process works:

Step 1> The AP Manager opens the Gorilla Integration App and logs in as the Admin. Here we have selected NAV as the system to send the data to. The Integration App is typically accessed by the Admin user (belongs to Accounting/AP/IT etc.) in a company.

Logging into Integration App as Admin

Step 2> Once logged in we want to select and import the credit card file supplied by the card provider that is typically downloaded by the Admin on a weekly or monthly basis. In this example, we are using a file supplied by our AMEX corporate card on a monthly basis. The following screenshot shows how the Admin can select the respective card and its format.

Selecting the card and format

 

 

**Note: Depending on how the credit card program is setup and services offered by the card provider, Step 2 can be fully automated with no human intervention. In that case, the Gorilla Integration App will automatically ‘pick up’ and import the latest file supplied by the card provider from an FTP site. AMEX typically enables this offering by default for all their corporate card and P-card programs and Gorilla Expense supports this approach**

In the screenshot below, the admin has selected the AMEX file – ‘Transactions.csv’ for import. The file was downloaded from our online AMEX account.

Selecting the file downloaded from the AMEX website

Step 3> Once the file is selected, the Integration App automatically associates the expense type and vendor using our mapping algorithm as shown in the screenshot below. This makes the transactions complete and no manual work is need to categorize the transactions.

Auto-allocation of expense type and vendor

Step 4> The Admin can now select all transactions or select specific transactions to import into the system and send to NAV. The screenshot below shows that two transactions were selected to send to NAV. Out of the two, only the one shaded in Green was sent. The transaction shaded in Yellow was already submitted earlier and is highlighted as a duplicate transaction.

The Gorilla Integration App prevents duplicate transactions from being sent to NAV by using the ‘Unique Identifier’ number supplied by the credit card as part of their file. This a is a powerful feature that saves AP Managers lots of time in checking for duplicates and also makes the reconciliation process easier.

Import transactions and prevent duplicates

 

Step 5> Once all the transactions are imported into the Gorilla application, they are dragged and dropped into a batch and send to NAV through automation using the same Integration App. The transactions show up as invoices within a batch called ‘GORILLA’. Depending on the payment method defined in the Gorilla application, the invoices are created to pay the employee or the corporate credit card.

In this example, our AMEX card has the payment method defined as AMEX which is tied to the ‘American Express’ Vendor ID defined in NAV. Here is a screenshot that show the expense data in Purchase Journals in NAV.

Expenses in Purchase Journals

All the details from the credit card transaction, namely the vendor and the report number are also made available to provide additional visibility for the CFO / accounting manager and to make it easier to search for expense data in NAV.

This explains how credit card data can be integrated into NAV using the Gorilla Expense Integration App. The App is very flexible in allowing credit card data from multiple cards and various formats to be imported into the system. If you would like to see a live demo of the App or have any additional questions, please contact us at info@gorillaexpense.com

While SAP Acquires Concur, We Renew our Commitment to SMBs

/in , , /by

It’s been a few weeks since SAP agreed to purchase Concur. The deal makes plenty of sense for SAP because of their focus in the ‘enterprise + powered by the cloud’ market. In a similar vein, it has been a few years since SAP purchased Ariba and SuccessFactors. With Concur now folded into the giant SAP umbrella, SAP will have access to an enterprise T&E solution that they can sell to their 200K + enterprise size customers.

But equally important over the next several months, SAP has its work cut out in trying to build an enterprise suite with these cloud acquisitions – a tricky job that will consume plenty of resources and time.

Concur’s focus in the last few years has been primarily in evolving their travel booking solution, investing in travel related apps and setting up of their marketplace. But the next few steps are going to be critical for Concur – they currently have the huge 15 year US government contract that they must deliver, meet additional requirements and opportunities from SAP and evolve their mobile and web mobile expense platforms to keep up with nimble and innovative cloud travel & expense competitors like us.

Above all, supporting all of these initiatives equally well through the choppy seas of a typical M&A process is paramount. While the cloud is very attractive to most customers, SAP must understand that no customer wants to be stuck with segmented cloud applications from different acquired vendors that don’t ‘talk’ to each other.

The marriage of Concur and SAP makes a lot of sense for both companies and the enterprise market. But, what does this mean for SMBs? Would the SAP-Concur nexus consider SMB travel and expense requirements to be mere distractions? Perhaps too small to worry or even care about? Will they even have the resources and time to help the ‘little guys’ out?

SMBs must take a very close look at this situation and understand where they fit in the landscape. There are different aspects to this – how is the Concur service going to be in the future now that they are a small part of a much larger behemoth? Would Concur’s travel & expense solution pricing change? Where do SMBs fit in Concur’s plan as they reach out to larger enterprises with SAP?

These are all big questions. But one thing is guaranteed – Gorilla Expense will continue to service the needs of SMBs at the same economical price and exceptional service that our customers are used to. The SMB market is our sweet spot and we pride ourselves in working with customers like you. If anything, the SAP-acquiring-Concur transaction has redoubled our efforts and renewed our long-term commitment to this space.

Our recent update of our mobile app – Gorilla Expense Pro is proof of that. We evolved the mobile app to the point where users don’t have to get in front of a computer to submit expenses anymore! This is very important and powerful for the typical SMB where employees are increasingly juggling more work and time spent on unproductive tasks is directly related to lost dollars for the company. In our journey through working with several SMBs, we realize that no two companies manage their T&E processes in the same way. Our focal points have always been:

– Make the solution super easy to use (if you have to read our manuals, then it means we are not doing our jobs)

– The solution is flexible and can be configured to meet the customer’s requirements

– Provide exceptional customer support (Wow! the customer all the time)

– Keep the solution economical to own for our customers (less than the price of 3 cups of Starbucks coffee per month)

We really strive to make a difference in our customer’s lives and also be successful in this space. We don’t compromise performance for price. We realize that SMBs frequently operate in a cost control mode and should not have to pay for features that are unnecessary to them.

We hope you enjoyed reading this article. Gorilla Expense is currently offering an attractive switchover program for current Concur users. As part of this program, you will get access to our entire solution – mobile, web and integration (credit card, travel, accounting and payroll systems). Customers who have made the move typically see savings ranging from 10% to 60% of Concur’s price. To learn more, please contact us at info@gorillaexpense.com.