Intercompany Expense Reporting and Management in Microsoft Dynamics AX 2012

Intercompany Expense Reporting and Management in Microsoft Dynamics AX 2012

Multinational Professional Services Firms always have employees working out of different office locations and it is a common practice in this industry to share resources(workers) between companies to execute project/non-project tasks. In such scenarios, it is pretty common that employees of one legal entity works on the Project/non-project tasks of other legal entities and might incur expenses which needs to charged to the project or ledger of the borrowing entity.

Until AX 2012 R2, there was not a good option in AX to handle the accounting of intercompany expenses scenarios in an efficient manner.

With the introduction of intercompany expense reporting feature in AX 2012 R2, it becomes a lot simplified for the users to manage the accounting of such scenarios. In today’s post we will take a look at this this new functionality in AX 2012 R2 and understand how this works.

The enabling and disabling the intercompany expense management feature is centrally controlled by a new parameter introduced in the Travel and Expenses Parameters form.

  • Go to Travel and Expenses > Setup > Travel and expense parameters form.
  • Mark the “Allow intercompany expenses” checkbox to enable this feature.

Travel & Expense Paramter AX 2012

Note that prior to submitting an intercompany expense report, you need to make sure that the necessary intercompany accounting relationship is setup between the loaning and borrowing entities under the General Ledger Module.

Refer to my post on intercompany timesheets earlier to understand the loaning and borrowing entities.

Let us  now go to the enterprise portal and create an intercompany expense report. In this demonstration we will assume that,

  • USMF is the company where the worker is employed. (Loaning Legal Entity)
  • USSI is the contracting company where the worker does the work. (Borrowing Legal Entity)
  • Now, Navigate to EP > Employee Services > New Expenses Report.
  • Mark the Intercompany expense report check box.

New Expense Report

  • Click New Expense line button
  • Select the Borrowing legal entity. In this case I will select USSI.
  • Select the Expense Category and click OK. This dropdown will show the categories which are validated for the worker.

Select Expense Category and Legal entity

  • Key in the other required values such as transaction date, amount, payment method etc and save the expense line and then submit and approve the expense report.
  • Note that if you are entering a project related expense line, then you can select the project, line property, activity etc.
  • So with this, the accounting team do not need to worry about creating manual journal entries for these intercompany expenses as employees are able to enter the expenses directly in the borrowing legal entity.
  • Now, let us go ahead and post the approved expense report and analyze the financial voucher.
  • Navigate to Travel & Expense Module > Common > All Expense reports, Select the expense report and approve it.
  • Click the Sub ledger journal button to see the general ledger update which will happen when we post this expense report.

Financial Voucher

In the screenshot above, note that the intercompany ledger update in USMF and USSI are based on the intercompany accounting setup done under the GL module in both the entities and the other accounts gets automatically picked up based on the payment method setup and the ledger account setup for the expense category.

Simple ! Microsoft Dynamics AX 2012..

Till next time..keep exploring…

Regards

Sandeep

Employee Cash advance management in Microsoft Dynamics AX 2012

Hi Friends,

Tracking the money that employees spend when incurring expenses for your business is a real key of Expenses management in an organization.

In today’s post we will discuss about the employee cash advance management feature of AX 2012.

We will start with the process of employee submitting a request for cash advance, the approver reviewing and approving it, paying the employee and then we will also see a little bit of process how the employee can return his cash advances.

Employee Submits Cash advance request in Employee self-service portal :

1. Navigate to the Manage Expenses > Cash advance request area in the Enterprise portal.

image

2. Click New Cash advance request and key in required details for this request. Save and close after filling in the details. Then, submit the request for approval.

image

image

Two easy to use steps for employees to submit cash advance request !!

Approver reviews the Cash advance request:

1.  Approver logs into enterprise portal and finds the cash advance request assigned to him/her for review.

image

2. Approver opens the cash advance request and then reviews and approves it.

image

Just two clicks !! QUICK and Easy for the reviewer/approver.

Finance team pays to the employee after the request got approved :

1. The finance teams logs in to AX and navigates to view the approved cash advance requests.

image

2. One click PAY !! The finance team member/user just clicks the Pay and transfer button and AX 2012 does the rest. Employee gets PAID !! System automatically creates and posts the required financial voucher entry for this transaction based on the setups which are done.

image

See below the automatic financial journal created and posted in the system.

image

image

The cash advance payment cycle for the employee is completed in few simple steps.

Let us now take a quick look at how the employee can return the cash back or how an employee can expense his cash advances in AX 2012.

1. Employee logs into the Enterprise portal and navigates to expense management area and create a new expense report and clicks Other > Return cash advance.

image

2. System automatically shows all your reconciled cash advances. Select the one you want to expense and select the expense category and submit the expense report.

image

DONE !!

System creates the necessary financial journals after the expense report is approved and posted.

Simply POWERFUL Smile

Till next time !!! Keep reading