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.
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.
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.
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.
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.
Accounting Impact:
-
Credit Card Liability Account – Debit 84.25
-
Accounts Payable Account – Credit 84.25
payoff the charge payoff
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:
Accounting Impact:
-
Employee Expense Payable – Debit 50.00
-
Cash account – Credit 50.00
Limitations due to specific company configurations
- GST and VAT-enabled companies.
- Cash and accrual companies configured to post credit card transactions and fees to the General Ledger after creation.
- 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.
Check 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