Welcome back! Ask questions, get answers, and join our large community of tax professionals.
cancel
Showing results for 
Search instead for 
Did you mean: 

Question was deleted by user

Highlighted
Level 2
last updated ‎December 06, 2019 4:50 PM
 
Labels (1)
0 Cheers
1 Solution

Accepted Solutions
Highlighted
Level 12
last updated ‎December 06, 2019 4:50 PM

Let me try this part: "and then adjusted to actual at year end via journal entry (debit/credit inventory and debit/credit purchases (or cost of goods sold depending on Chart of Accounts)."

If this file uses "Inventory Items" then every JE made to inventory asset is a mistake. The Item Names manage the values on hand, and a JE bypasses this. You can see in my attachment that By Item value for the As Of Date is an exact match to the Bal Sheet for that same As Of Date. By Item Names is how you manage "Perpetual inventory" in QB, so you never make a JE. A JE does not provide for Item Names. The function, once you take your final physical inventory for the cycle, is Adjust Inventory.

Now, if they are doing Periodic Inventory, sure. You rebalance between COGS and Asset "Periodically."

And the reporting provides what you asked. You run the Balance Sheet Standard for This Fiscal Year and select the comparison of Previous Period, which gives you, for example, Dec 31 2016 and Dec 31, 2017 as columns.

"One CPA firm I worked with used the clients' QuickBooks profit and loss statement and made a manual entry in Other Costs section of Cost of Goods Sold to account for the actual difference in the beginning and ending inventory balance."

Again, that is only used for Periodic Inventory management, in QB.

In a quick turnaround business, all purchases would go to COGS directly. You JE to asset for the final date of the fiscal year for what still is on hand, and reverse it for the first date of the new fiscal year. Example: Bakery.

In a business such as used vehicles, recreation vehicles, and other large ticket purchases that are on hand a while, you post all purchases to Asset first. Then, Periodically and at least for Year End, you reduce what is on hand to COGS, if that is no longer on hand.

Keep in mind that QB Pro/Premier do average costing. QB Online does FIFO. QB Enterprise does Average, or you can enable FIFO.

Hope that helps. Please see my attachment. In a file using perpetual inventory (inventory item Type, Named stock on hand), you should be able to prove that match.

*******************************
"Level Up" is a gaming function, not a real life function.

View solution in original post

0 Cheers
8 Replies 8
Highlighted
Level 12
last updated ‎December 06, 2019 4:50 PM

Let me try this part: "and then adjusted to actual at year end via journal entry (debit/credit inventory and debit/credit purchases (or cost of goods sold depending on Chart of Accounts)."

If this file uses "Inventory Items" then every JE made to inventory asset is a mistake. The Item Names manage the values on hand, and a JE bypasses this. You can see in my attachment that By Item value for the As Of Date is an exact match to the Bal Sheet for that same As Of Date. By Item Names is how you manage "Perpetual inventory" in QB, so you never make a JE. A JE does not provide for Item Names. The function, once you take your final physical inventory for the cycle, is Adjust Inventory.

Now, if they are doing Periodic Inventory, sure. You rebalance between COGS and Asset "Periodically."

And the reporting provides what you asked. You run the Balance Sheet Standard for This Fiscal Year and select the comparison of Previous Period, which gives you, for example, Dec 31 2016 and Dec 31, 2017 as columns.

"One CPA firm I worked with used the clients' QuickBooks profit and loss statement and made a manual entry in Other Costs section of Cost of Goods Sold to account for the actual difference in the beginning and ending inventory balance."

Again, that is only used for Periodic Inventory management, in QB.

In a quick turnaround business, all purchases would go to COGS directly. You JE to asset for the final date of the fiscal year for what still is on hand, and reverse it for the first date of the new fiscal year. Example: Bakery.

In a business such as used vehicles, recreation vehicles, and other large ticket purchases that are on hand a while, you post all purchases to Asset first. Then, Periodically and at least for Year End, you reduce what is on hand to COGS, if that is no longer on hand.

Keep in mind that QB Pro/Premier do average costing. QB Online does FIFO. QB Enterprise does Average, or you can enable FIFO.

Hope that helps. Please see my attachment. In a file using perpetual inventory (inventory item Type, Named stock on hand), you should be able to prove that match.

*******************************
"Level Up" is a gaming function, not a real life function.

View solution in original post

0 Cheers
Highlighted
Level 8
last updated ‎December 06, 2019 4:50 PM

Your first paragraph doesn't make sense to me.  If ending inventory is adjusted through COGS purchases, then why would state that that COGS does not factor beg and ending inventory?


Regardless, there is one right answer for actual COGS, it is basically the difference in Beg and ending inventory, plus purchases made during the year, less items removed for personal use.  I would like to see the ending inventory on balance sheet tie to ending inventory on the tax return (in Lacerte, if you prefer)

0 Cheers
Highlighted
Level 2
last updated ‎December 06, 2019 4:50 PM
My apologies - I didn't properly word the question. The gist of the question is  whether to agree the tax return to QuickBooks or to make a journal entry to QuickBooks so that the cost of goods sold agree.
0 Cheers
Highlighted
Level 8
last updated ‎December 06, 2019 4:50 PM
The answer is that the actual COGS should match both quickbooks and the tax return. The actual ending inventory should be determined by actually counting the inventory, and the COGS should reflect the actual financial investment in the inventory that was sold during the year.
0 Cheers
Highlighted
Level 12
last updated ‎December 06, 2019 4:50 PM

And why would you delete the question? That is exactly why I copy parts of the original question, when I am answering.

This is peer user community. Others had the chance to learn from your question and now that opportunity is gone.

*******************************
"Level Up" is a gaming function, not a real life function.
0 Cheers
Highlighted
Level 2
last updated ‎December 06, 2019 4:50 PM
I was very uncomfortable with the tone of one of the people who responded. Let's leave it at that.
0 Cheers
Highlighted
Level 15
last updated ‎December 06, 2019 4:50 PM

There should be no difference of "professional"  opinion.    The way QB works (or any accounting software) is to adjust purchases when inventory is adjusted.  This is basic Accounting 101 

If the "professional" picks up the already adjusted purchases number, then allows Lacerte to also do that adjustment by the math of the delta between beginning inventory and ending inventory.....well, that said "professional" should hang up their professional shingle.   

I use "inventory delta" as a specific line item in the purchases area to track this adjustment.

Former Chump... umm.... AllStar.
If a post answers your question, click on *Accept as solution* for future searches
0 Cheers
Highlighted
Level 2
last updated ‎December 06, 2019 4:50 PM
Thanks for your reply
0 Cheers