cancel
Showing results for 
Search instead for 
Did you mean: 

#COE #BA01 Cost Center on Asset Acquisition credit

RyanMuller
Participant
0 Kudos

Hello,

When we get supplier invoices related to expenses to be capitalized our AP Coordinators enter them against a asset clearing account and the have a cost center. This cost center is required for workflow, management reporting, and expense tracking. 

When our Asset Accounting teams pull the posted expenses against that account later in the month and create the associated asset master data and post the asset acquisition using that clearing account as the offset we've found that the posting is missing data and is an offset only based on the amount and qty and doesn't appear to be offsetting in reporting. The cost center in the expense invoice line is ultimately the cost center used in the asset master data.

As an example:

Invoice 12345 in Company Code US01 for a Laptop: 

GL AccountAmount ($)Debit/CreditProfit CenterCost Center
Accounts Payable2000Credit100 
Asset Capitalization Clearing (Expense)2000Debit10010011

Laptop Asset 12345 in Company Code: US01, Asset Class: Computer Hardware - Acquisition posting

GL AccountAmount ($)Debit/CreditProfit CenterCost CenterFixed AssetAsset Class
Asset Capitalization Clearing (Expense)2000Credit100  Computer Hardware
Computer Hardware (Fixed Asset Acct)2000Debit100 12345Computer Hardware

When we go to report at a cost center level we have $2000 expense still appearing in reporting even though it should be offset which is a big problem for our org. How can the cost center be accurately captured to show the true expense offset which ties thru reporting? This cannot be a unique problem to us and appears primarily in acquisitions but also the master data coding gets dropped in areas like retirements with sales (on the sale piece tying it to the asset).

Thanks in advance for your help,

Ryan

View Entire Topic
1825
Associate
Associate
0 Kudos

There’s proposal that details steps are as below.

Example data:

  • Company code: 1310.
  • Supplier account: 1000122, reconciliation account is 21100000.
  • Asset Capitalization Clearing (Expense) GL Account: 61003000.
  • Cost center 13101101
  • Asset master data: 500019-0

Process steps:

  1. Create supplier invoice for Account payable with APP “Create Supplier invoice”, and the result is as below.

1825_0-1710480811575.png

2. Create new asset master data.

 

1825_1-1710480811579.png

3. Post the asset acquisition via app “Clear outgoing Payment-Manual Clearing”.1825_2-1710480811586.png

 

1825_3-1710480811593.png

 

1825_4-1710480811601.png

4. Check post asset acquisition value in asset master data.1825_5-1710480811606.png

5. Check the report for GL account “61003000” line items as below.

1825_6-1710480811612.png

6. Clear GL account “61003000” if it’s needed.

RyanMuller
Participant
0 Kudos
Thanks for the response, why are we having to use a clearing application to post an asset acquisition with the cost information as opposed to the asset acquisition app. How would this work for retirements with sales and other areas where the asset posting has incomplete object postings?