Answered: Question was deleted by user - Intuit Accountants Community

Welcome back! Ask questions, get answers, and join our large community of tax professionals.

Question was deleted by user

1 Best Answer

Accepted Solutions

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.

*******************************
Don't yell at us; we're volunteers

View solution in original post

8 Comments 8

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.

*******************************
Don't yell at us; we're volunteers

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)

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.

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.

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.

*******************************
Don't yell at us; we're volunteers

I was very uncomfortable with the tone of one of the people who responded. Let's leave it at that.

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.

HumanKind... Be Both

Thanks for your reply