RKL eSolutions Blog Trends and Insights

How to Use Employee Expense Reports and Company Credit Cards in Sage Intacct

How to Use Employee Expense Reports and Company Credit Cards in Sage Intacct
2:46

 

Sage Intacct allows the use of company credit cards to capture non-reimbursable employee expense report transactions. These credit card transactions flow to Time and Expense so they can be used within an employee's expense report.

Setting Up the Workflow

Set up the credit card

If you’re using the Time and Expense application, you can enable a company credit card for use with employee expenses on the expense report transaction. This is where you select the clearing account that you want the transaction to post. When those transactions are included in the expense report, they can be coded to the correlating expense account.

Picture1

Credit card transactions

Ensure the employee dimension is included on the line item of the transaction. Once tagged it will default to the employee expense clearing account.

Picture2

Accounting Impact:

  • Employee Expense Clearing Account - Debit 84.25

  • Credit Card Liability Account – Credit 84.25

Include Credit Card Transactions in Expense report

Include the transactions in an expense report on the expense report line. Select the appropriate expense type or expense account to move the amount out of the employee expense clearing account. In order to split lines, simply adjust the amount of each line to account for multiple expenses in one credit card transaction. When you click "Select credit card transactions," it will appear on the list to add the expense report.

Picture3

It is now listed on the first line of the expense report and once payment type is selected as Corporate Card, it is now check marked as non-reimbursable by Sage Intacct. Additional lines can be added.

Picture4

Accounting Impact:

  • Expense accounts – Debit Office 84.25 and Meals and Entertainment 50.00

  • Employee Expense Clearing Account- Credit 134.25

Create the charge payoff

Select the charge card and appropriate dates and click "Apply Filters." It now includes the charge card transaction for the expense report. This creates an AP Bill for the credit card vendor.

Picture5

Accounting Impact:

  • Credit Card Liability Account – Debit 84.25

  • Accounts Payable Account – Credit 84.25

payoff the charge payoff

Picture6

Accounting Impact:

  • Accounts Payable account – Debit 84.25

  • Cash Account – Credit 84.25

The Employee Aging only reflects the amount owed to the employee as reimbursable:

Picture7

Accounting Impact:

  • Employee Expense Payable – Debit 50.00

  • Cash account – Credit 50.00

Limitations due to specific company configurations

  1. GST and VAT-enabled companies.
  2. Cash and accrual companies configured to post credit card transactions and fees to the General Ledger after creation.
  3. Cash basis companies.

Want More Sage Intacct Features & Functions?

For more Sage Intacct Tips & Tricks videos, visit our YouTube page and subscribe to stay up-to-date with the latest insights and tutorials. Our channel is dedicated to providing valuable resources for businesses looking to optimize their financial management with Sage Intacct.

question-markCheck out these blogs to help get you started!

Uploading Your Budgets Using Pre-Built Templates
How To Create Ad-Hoc Reports Using Views and Filters
Creating Expanded Columns and a Summary for Reports

 

Lisa Cook

Written by Lisa Cook

With her 10+ years of experience in implementing and consulting, Lisa assists her clients with advancing their systems and business practices.