mibuso.com

Microsoft Business Solutions online community
It is currently Fri Aug 29, 2014 3:10 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Direct Cost Applied account
PostPosted: Fri Jan 13, 2012 6:31 pm 
Offline

Joined: Mon Jan 02, 2012 2:32 pm
Posts: 8
Country: India (in)
Our client dont want to include Direct cost Applied and COGS accounts in Income Statement.

Up to this month Direct cost Applied Account is getting balanced with COGS since the purchases and sales are done in same month.

In this month they have done purchases in this month and want to do sales of the item in future month.In this situation the value is getting remained in Direct Cost Applied account and when they run the Income Statement and Balance Sheet reports they dont match to each other since the Income Statement dont include Direct Cost Applied Account.

Can any one please help in balancing the reports without including Direct Appllied Account.

Below is the general affect of accounts when Purchases and sales are done:-

When the purchase order is invoiced the Accounts affected are

1)Inventory
2)Account Payable
3)Purchase Account
4)Direct Cost Applied Account

When the Sales order is Posted the Accounts Affected are

1)Inventory
2)Account Receivables
3)Revenue Account
4)COGS

When the Purchases and Sales are made in the same month the Direct Cost Applied account
gets balanced with COGS.

Where as in a situation where Purchases are done in one month and Sales are done in the other month the value will be remained in Direct Cost Applied account until sales are done for that item.


Top
 Profile E-mail  
 
 Post subject: Re: Direct Cost Applied account
PostPosted: Fri Jan 13, 2012 6:53 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Mar 13, 2008 10:50 pm
Posts: 52
Location: Croatia
Country: Croatia (hr)
The point of having Direct Cost Applied is because inventory cost cannot be treated as expense (loss) until the goods are actually sold.

When you post a purchase of goods, you debit the purchases accounts (increasing your expenses / loss), which you shouldn't - because there is no loss if you have the goods, and until you sell the goods. That's why you credit the Direct Cost Applied account to neutralize the expenses. Basically, from Income Statement perspective, there is no expense here.

When you sell goods, then you debit the Cost of Goods Sold account, which increases your expenses.

(the description above is simplified, and it doesn't include what happens at balance sheet side for payables, receivables and inventory of either of transactions)

If both sales and purchases happen in the same month, then Direct Cost Applied and COGS get balanced, and that's expected (because then your inventory has no effect on your profit / loss).

However, if the goods are not sold in the period when they are purchased, then you must not show them in your Income Statement - and if you had excluded the Direct Cost Applied account from it, then only purchases would show there, meaning that the expense has actually occurred, while it hadn't.

I would say that you need to talk to your accountant once again, and make sure that both COGS and Direct Cost Applied are configured as Income Statement accounts, and whatever happens in NAV is completely correct, as far as IAS/IFRS rules go.

_________________
(Co-)author of "Implementing Microsoft Dynamics NAV 2009"
http://navigateintosuccess.com/


Top
 Profile  
 
 Post subject: Re: Direct Cost Applied account
PostPosted: Fri Jan 13, 2012 8:14 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 5012
Location: Los Angeles, CA
Country: United States (us)
Instead of trying to understand the concept behind these accounts, it looks like you just copy and pasted from a blog.

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
 Post subject: Re: Direct Cost Applied account
PostPosted: Thu Mar 21, 2013 2:16 pm 
Offline

Joined: Sat Jan 23, 2010 6:33 pm
Posts: 9
Country: India (in)
Hi,

This is Jaishanker, I have few doubts in cost accounting.

When a purchase of inventory is made, 4 accounts are hit:
1000 Inventory
2050 A/P
2100 Purchases
2150 Direct Cost Applied

When the items are sold, 4 accounts are hit:
1000 Inventory
1050 A/R
1100 Sales
1150 COGS

Case 1).Invoice a purchase order for $10.00 *3 qty for item A, the following happens

Purchases A/c $30 Dr
Accounts Payable A/c $30 Cr

Inventory A/c $30 Dr
Direct Cost Applied A/c $30 Cr

Case 1.1). Now, suppose i need to return 1 qty of item A to the vendor and the vendor is only willing to give you credit for $8.00 per qty. When you post the credit, the following will happen:

Accounts Payable A/c $8 Dr
Purchases A/c $8 Cr

Direct Cost Applied A/c $8Dr
Inventory A/c 8 Cr

In this case we have to post additional two entries for Adjustment

Direct Cost Applied A/c $2Dr
Inventory A/c $2Cr

Case 1.2) Invoice a Sales order 1 qty at $12.00 for item A, the following happens:

Accounts Receivable A/c $12 Dr
Sales A/c $12 Cr

COGS A/c $10 Dr
Inventory A/c $10 Cr

-----------------------------------
Please confirm the above entries then give me income statement for the above transaction.
Plz.


Top
 Profile E-mail  
 
 Post subject: Re: Direct Cost Applied account
PostPosted: Thu Mar 21, 2013 7:29 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 5012
Location: Los Angeles, CA
Country: United States (us)
http://www.dynamicsnavconsultant.com/20 ... e-cpa-way/

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
 Post subject: Re: Direct Cost Applied account
PostPosted: Sat Jul 05, 2014 10:25 pm 
Offline

Joined: Sat Jul 05, 2014 10:08 pm
Posts: 1
Country: United States (us)
Actually, you are all incorrect and so is Microsoft.

The entries expoused by you'all and Microsoft is incorrect. The terminology is bad.

When you receive inventory ( which is when the purchase transaction occurs , not when it's invoiced) the correct entry is

Debit Inventory ( Balance Sheet Account) 100 LCY based on standard cost or inventory item cost or po price

Credit Uninvoiced Payables ( Balance Sheet ) 100 LCY based on PO price

There is no need and in fact should be NO Income accounts involved unless you are having a purchase price variance.

I am a certified public accountant for 30 years and have been working in Manufacturing for 20 of them. The NAV method is wrong , wrong, wrong. It is not GAAP nor IFRS.

Alex , your post on the CPA is off as well . That is an IRS or Tax based calculation based on the traditional 1120 calculation of COGS. It is NOT a CPA way. It is not GAAP or IFRS but TAX Based.
Therefore your nomenclature is incorrect.

You cannot talk about account without identifying that they are Balance Sheet or Income Statement Accounts.

Michael Carr CPA


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: