The GBTA did a survey of more than 200 travel managers in the US on which expense types they mandate the usage of corporate card
No surprises that Airfare was the top at 67%. This is mainly to better manage the spend related to airfare and utilize programs and partnership with air travel vendors. Plus, in some cases, if tickets are canceled or modified, corporate cards have discounted change-fees for being part of the air travel vendor program. Closely following the Airfare expense type are Lodging and Rentals both of which maintain a similar philosophy.
Charging meals to the corporate card provides greater visibility from a compliance perspective. This is especially true if meals are related to Entertainment type expenses. Companies are also increasingly asking employees to charge misc. business expenses like internet, phone calls, faxes etc. to the corporate card to prevent potential frauds. For sales people on the road all the time, the corporate card is a big convenience for mileage and gas related expenses as well.
So, how do your company stack up compared to this? Which expense types do you mandate your users to use the corporate card for? Let us know in the comments below.
Reference: GBTA April 2014 survey. Chart provided by Travel Procurement, part of BTN Newsletter
As we all know Dynamics GP provides an organization with solid agility and flexibility in meeting their business needs today and also into the future. With such flexibility, comes the ability to configure GP in many different ways to meet unique requirements of the organization – and this extends to expense reporting as well.
Gorilla Expense offers a fully automated and seamless integration with GP. We refer to this as ‘1-click’ integration’. We do this by using web services and eConnect, depending on the customer’s preference. While we can do a flat-file based integration, our customers love the way our integration app sends the data from several expense reports to GP with just a click! When it comes to expense reporting, there are multiple ways to integrate the data from our system to GP. In this series, we will be exploring the different flavors of our integration with GP.
Integration with Payables in GP – Series (1 of 3)
This is the standard and most common format of our integration with GP. Here, we send the expense data as a Payable Transaction Entry within the Purchasing module in GP. Expenses sent from our system will show up as invoices. Depending on the payment method defined in our system and the setup of vendors, the invoice will be issued for the employee or the corporate credit card.
Integration with Project Accounting in GP – Series (2 of 3) Here, we send the expense data from our system to the Project Accounting module in GP, where expenses will be captured against different cost categories and tied to specific open projects. The project workflow is also mapped within our system such that the respective project owner(s) will be approving the expense reports before they are sent to GP.
Integration with Receivings in GP – Series (3 of 3) Here, we will send the data as a Receivings Transaction Entry within the Purchasing module. The expenses are allocated to different cost categories and the PO number is referenced. Since these expenses will show up as Receivables once posted, this integration is used when the customer is planning to bill back their clients. The customer name /PO number is referenced in our application so that the expenses are tied to it.
Besides these, we can also configure our Integration App to do other forms of integration as needed. In the next article, we will showcase our integration with Payables in GP. Stay tuned!
Our customers frequently ask us questions on this topic. Mainly – What is the IRS policy for a receipt? And is it only needed for expenses greater than $50? There seems to be a lot of confusion and misinformation on this topic. So, to clarify doubts, here is the scoop –
1) The IRS accepts electronic receipts, but there are a few caveats (read more on this from a previous blog article we wrote. Click here)
2) Actually, the IRS does not need a receipt for expenses less than $75 (believe it or not!). Here is the text from the IRS publication 463 that validates it –
What Are Adequate Records?
You should keep the proof you need in an account book, diary, log, statement of expense, trip sheets, or similar record. You should also keep documentary evidence that, together with your record, will support each element of an expense.
Documentary evidence. You generally must have documentary evidence, such as receipts, canceled checks, or bills, to support your expenses.
Exception. Documentary evidence is not needed if any of the following conditions apply.
You have meals or lodging expenses while traveling away from home for which you account to your employer under an accountable plan, and you use a per diem allowance method that includes meals and/or lodging. (Accountable plans and per diem allowances are discussed in chapter 6.)
Your expense, other than lodging, is less than $75. <——
You have a transportation expense for which a receipt is not readily available.
If you want to read the entire publication, it is available here. Hope you found this article to be useful! Now you can light a mini-bonfire and burn those <$75 receipts.
Please note that this is NOT legal or tax advice. Please contact your attorney or accountant for more information.
If you think you have strange expense reports, you must see this! Robert Half Management Resources survey interviewed several CFOs and asked them to name the most unusual things they have seen employees include in expense reports. The results – bound to raise both eyebrows! Here are a few of the most questionable items:
– Cosmetic surgery
– Lottery tickets
– Pet food
– A trailer rental for a family reunion
– $12,000 for a family trip-+
– A teepee
– A fine for crashing into a toll booth
The survey was developed by Robert Half Management Resources, and it was conducted by an independent research firm. The survey included responses from 1,600 U.S. and Canadian CFOs from a random sample of companies with 20 or more employees.
The list also included gadget, leisure and hobby expenses:
– A person lost his personal cell phone somewhere in the office, so he submitted the cost of a new one
– Movie tickets
– Hotel charge for viewing adult movies (Yikes!)
– Day at the spa
– A golf trip for the employee and his three friends
– Video game console (PS4 maybe?)
Personal expenditures were frequently cited by executives as questionable. Here are some examples:
– Grocery receipts
– Cigarettes
– Pair of socks
– Toilet paper
– Hot tub supplies
– Golf clubs
– Expensive lunch for the employee, without clients
Expenses covering the cost of personal celebrations and not related to the office was equally if not more surprising:
– Flowers the employee bought for his wife
– Expenses for his son’s birthday party
– Wedding anniversary dinner
Anyone submitting an expense report should double and triple check their expenses to avoid this situation, which could definitely land the employee in hot water. One respondent said “The most unusual thing I saw was a submission for something that had already been expensed and reimbursed”
Here is a frequently heard request from Accounts Payable departments (AP) in companies around the world –
‘Can we integrate T&E with our Payroll system to issue reimbursements faster and error-free?’ And a very pertinent request at that – considering that AP is largely responsible for issuing T&E reimbursements.
A recently conducted survey, with results displayed below, showed that at least 74% of T&E reimbursements fall largely within the domain of AP. This becomes an additional burden to handle for AP among other important tasks. Plus, the ripple effects of delayed reimbursements or wrong reimbursements affects the heart of the business: the morale of the workforce. So it really is a no-brainer to automate this process through integration.
And this fits into the overall theme for companies in the 21st century which is – religiously examining ways towards becoming more efficient and effective at what they do. And on that list is frustration and delays with T&E reimbursements for employees after a trip. This is especially true after an international trip where the employee could have sizable out of pocket expenses with imminent due dates on their credit cards. Therefore integration of T&E and Payroll systems is paramount and companies are investigating in more detail on how to maintain a seamless integration between these two systems which are essentially two sides of the same coin.
Payroll systems look at an employee at one point in time, chiefly, what is that employee’s salary or hourly wage today. They automatically calculate net pay for a given pay period, federal, state and local taxes, deductions for such items as health care copays and contributions to charities etc. These systems also automatically cut checks to employees or have their pay automatically deposited into their bank account.
T&E Expense Reporting systems, on the other hand, help manage the employees expenses from a trip. If the company utilizes a corporate card, then the employee submits those expenses are part of the same system. The key pieces of the expense transaction includes details about the trip, expense type, vendor and mainly the receipt of the transaction.
The benefits of integration between these two systems are:
– Reduce reimbursement time
– No more manual keying of data in multiple places
– Utilize the existing flow and scheduling for T&E reimbursements
– Real-time visibility of reimbursement status for all parties
– And most importantly, the emotional aspect – employees expect the company to reimburse them for out-of-pocket expenses ASAP. And by automating the process as much as possible (which in turn reduces errors, delays and frustrations), it shows the employees that the company cares!
So how does this typically work?
The natural next step for T&E data after it has been reconciled in the expense reporting & ERP systems is sending it to the Payroll system. Think of it as ‘Passing the expense report data baton’!
Expense-Reporting-Payroll-Integration
Here is how it works in steps –
– Once the expense reports are approved within the Gorilla Expense web application, Gorilla Expense can automatically generate 2 files 1) Payroll file precisely in the same format as expected by your payroll provider 2) GL File precisely in the same format as expected by ERP System
– The payroll file can be imported into the Payroll system to issue reimbursement
– The GL file can be imported into the ERP system for GL entries
– If the Payroll system setup for T&E reimbursements is the same as payroll, then the employee will be reimbursed for T&E expenses during the next payroll cycle
Contact us at info@gorillaexpense.com if you have any questions or if we can help you manage this process more efficiently for your company.
When you think of expense reports, you also think about its vulnerability to fraud. While there are tools and systems to better tackle fraud, consistent auditing still plays a vital role.
Last year, the Association of Certified Fraud Examiners (ACFE) reported that nearly 15% of all fraud in the workplace was related to T&E expense reporting. According to the same report, the median financial loss to an organization for a single instance of expense fraud is $26,000, and the median duration of the fraudulent activity is two years. That is a lot of money and a long duration.
Earlier this year, AirPlus International fielded a survey to corporate travel managers to explore how they manage expense fraud in the travel category. 35% of the respondents reported that they manage both travel and T&E within their organizations. Another 15% of the respondents identified their official role as a travel manager but were closely involved in creating T&E expense policy as it relates to travel. On the other side, only 30% of travel managers said their company’s travel policy had any guidelines for T&E expenses. 7% of the respondents said they were not involved at all with T&E expenses.
Of the 119 surveyed, 8% of the respondents reported that their companies had uncovered significant fraud in T&E expense reporting over the last two years while 19% said that they didn’t know of any significant fraud. For the 8% of respondents, the most common behavior was falsifying or altering receipts to inflate reimbursements. Additional common fraudulent behaviors include submitting too many “below-the-line” expenses (expenses below a certain $ value that do not require receipts per a corporation’s T&E policy), exchanging premium-class tickets and reclaiming receipts.
The survey respondents utilized safeguards in place at their organizations for preventing and detecting fraud. The most common prevention tactic, cited by 81% of the respondents, was to include direct manager approval for all T&E expenses. 67% of respondents said their companies required receipts for all expenses incurred during travel, while 59% required the use of a corporate card for T&E expenses.
To read the full report by AirPlus International click here
Maintaining compliance and increasing visibility are the key factors in prevention of T&E fraud. Surprisingly, the ACFE reports that most workplace fraud is initially discovered from a tip provided by a co-worker. However, to take action, the tip must be backed up by facts and data.
Here is a video on T&E expense fraud which you may find useful –
Contact us for more information or if you have any specific questions we can help with at info@gorillaexpense.com
Expense report padding may seem like a harmless offense and a common thing. But it still constitutes as fraud. Here are 8 cases where employees and public officials got caught cheating big.
In the last few months, we have been receiving inquiries regarding our integration with ERP & Accounting systems in relation to some of the other expense reporting solutions out there. I think the key difference can be summarized as – Full Automation
Most of the other systems out there say that they can ‘integrate’ but what they really mean is that they provide a flat-file that can then be imported into the ERP system. Nothing wrong with this and it may actually work better for some companies. But when we refer to integration, we mean full 100% automated integration, which means – the Accounting person pushes a button and the expenses are available in the ERP system as GL entries or into AP. This makes a huge difference for our customers.
Using our integration manager utility, they are able to pick and choose expense reports they want to send. After that, they click on a button to push the expense data. Simple as that! We have heard from our customers that With this approach, there is lesser chances of errors, much fewer manual steps that need to be taken and it can be performed by anyone in Accounting or AP without any expert training. Plus, the mapping of parameters can be tweaked very easily within the integration manager by the Admin without having to redesign the flat file format. Thus the Accounting folks will have lot more flexibility in how the data is pushed to the ERP or Accounting systems. We guarantee that this approach is 21st century proof! 🙂
So, come take a look at this and some of the other advancements we are making in the expense reporting space. To see a list of some of the systems we integrate with, go to the ‘Advanced Functions’tab here. If you’d like to learn more or have any questions, as always, send us an email – info@gorillaexpense.com
We have been receiving several inquiries over the last few months about our integration with NAV2013 in relation to what would happen if NAV is hosted on the cloud. Here is the quick scoop –
Microsoft has made significant investments towards the “hostability” of NAV2013. This helps deploying and using NAV in the cloud, thus benefiting both customers and partners. Microsoft is currently fine-tuning deployment scenarios and developing guidance for deploying NAV on Azure. Microsoft expects to make deployment of NAV on Azure broadly available in Q1, 2013. They had initially planned it closer to Nov 2012.
Our application is deployed on the cloud too (as one of the options), specifically Azure (Yes, we are heavily Microsoft oriented and we love it :). With this option, the customer has nothing to worry about in regards to hosting the data, managing the application or tackling the overhead associated with maintaining a server, support etc. Our integration with NAV is agnostic to the hosting format employed. NAV can be on a dedicated server on the cloud or we could be co-hosted with NAV too. Neither approaches affect out integration from the user’s perspective. On the back-end, there will be a few more gerbils turning wheels. But the customer will always experience a seamless and fully automated integration between our solution and NAV.
This flexible integration and hosting capabilities between our solution and NAV makes life much easier for the customer, the partner and of course for us too. Read about our integration with NAV here. If you would like to learn more or have any further questions, send us a message at – info@gorillaexpense.com.
Meanwhile, here are some more tidbits about NAV013 you may find useful
– Microsoft announced the availability of NAV 2013 in 15 markets. With significant improvements in functionality and several new capabilities, this launch was hailed as the most significant release of NAV yet
– Functionality such as Cash Flow Forecast, Cost Accounting, and Excel Integration to Query enable greater accounting efficiency for customers while offering partners the ability to develop customized solutions
– The new NAV web client allows users to access NAV from virtually any device. Improved query and charting offer compelling ways to analyze and display data for more users
– Improvements to the migration tool, partner development tools, and increased interoperability with Microsoft technologies mean less time is needed for partners to customize and deploy solutions, and they are easier for customers to learn and have impact
– Specifically useful for partners, NAV2013 enables easier deployment, configuration and installation through the RoleTailored developer experience. The new .NET Framework enhancements makes it easier to build, deploy and integrate high-performing add-ons with existing NAV solutions, and share data more easily
By popular demand from our global customers, we have released a new feature for capturing VAT. Now, users will be able to list the VAT amount(s) for an expense. Since the transaction includes the receipt, companies will be in compliance with typical VAT reclaim requirements. Depending on the country, different VAT rate categories can be configured in the system.
This is really nifty and helps with more T&E visibility for stakeholders. Also it makes VAT reclaim for companies a piece of cake (or a piece of pie if you are from Europe:) Simply compile the expenses, list all the VAT transactions and you are ready to report it! Hope you enjoy this functionality. As always, we love to hear from you – info@gorillaexpense.com
