Cost of Good Sold Journal Totals not matching other Reporting?

SUGGESTED

Can anyone lend guidance on why the COGS in Sage 50 Income Statement does not match the COGS calculated on the Inventory Profitability Report and both of those vary widely from the COGS total found on the Cost of Goods Sold Journal Report?

While I didn't expect all three to equal one another, the variance for 2019 between Income Statement COGS and Inventory Profitability Report is within a margin of error I'm ok with, $11K for the year.  However, both of those are about $100,000 less than the COGS total on the Cost of Goods Sold Journal report.  

Any answers?  Thanks

  • 0
    SUGGESTED

    Here are the things I would check. First review a General Ledger report for your COGS account(s). Look in the Jrnl column for anything other than COGS. If you find any other entries, they will cause the account balance to be different from the other COGS reports.

    Another thing to keep in mind with the COGS Journal is that, when viewing it in detail, the totals at the bottom are simply the total debits and total credits. That doesn't always equal total COGS. For example, if you had a return, Inventory will be debited and COGS credited. So both the debit total and the credit total are still increased even though COGS is being reduced.

    You should also check your inventory items to make sure the "GL Cost of Sales Account" is set correctly. Any items not posting to a COGS account will cause a variance between the income statement and the COGS Journal or Inventory Profitability Report.

    If you use non-stock items and you have entered an amount in their Last Unit Cost field, when you sell that item a COGS entry will be made that appears in the COGS Journal but non-stock items are not included in the Inventory Profitability Report.

    Hopefully one of those will help you track down your variance.

  • 0 in reply to StephenC

    great, thank you so much for taking the time!