top of page

Cost of goods sold: How to calculate and record COGS

Updated: Jan 28

Follow Consistent Accounting Procedures:

Accounting in QuickBooks follows a specific and structured process. As an accrual-based system that complies with GAAP standards, following consistent accounting procedures is imperative. Proper setup of products and services, including standard sales and purchase prices, is essential for calculating COGS when no bill is linked to an invoice. The primary goal of GAAP accounting is to align expenses and bills with the revenue generated from invoices, creating a clear audit trail to connect all transactions seamlessly and produce accurate financial statements.


Accounting in QuickBooks follows a specific and structured process. As an accrual-based system that complies with GAAP standards, following consistent accounting procedures is imperative. Proper setup of products and services, including standard sales and purchase prices, is essential for calculating COGS when no bill is linked to an invoice. The primary goal of GAAP accounting is to align expenses and bills with the revenue generated from invoices, creating a clear audit trail to connect all transactions seamlessly and produce accurate financial statements.


The accounting process is:

Estimate (optional) to PO (optional) to Bill Item or Expense Item (marked billable, attach receipt) to bank feed (transaction) matched to bill or expense, will populate the Unbilled Charges Report, adding Inventory (quantity) and COGS (amount) to your financial statements. When invoiced (add billable items to the invoice from the suggested transaction pop out drawer). This process Bill + Invoice is critical for correct accounting of Sales, COGS and Inventory, is GAAP Compliant and produces accurate financial statements.

My accounting preference is to GAAP accounting (matching purchase with revenue to calculate accurate Gross Profit) following correct workflows.

If you are pre-entering vendor or store receipts that will be billable to a client, use a bill, then match in the bank feed (bank transactions) These bills will remain on A/P until paid, from a bank feed transaction or otherwise.

Pre-entered bills will dictate whether the expense/purchase is for:

  • Item dropdown lines for products and services purchased for resale, typically billable items sold and matched to an invoice. OR

  • Category dropdown lines for indirect overhead expenses, asset purchases, liability payments, and are typically non-billable. You can enter a bill or expense for COGS directly to the Income Statement, using the category field, for cash accounting transactions only   <not recommended, especially where inventory is concerned, and valuations are necessary.

  • Always add, customer or job, class and location to each document


  • The rule of COGS calculations: Cost of goods sold: How to calculate and record COGS

    • An invoice (income) + bill attachment (Item: COGS) with markup = gross profit.

    • An invoice (income) + bill attachment (Item: COGS) and no markup is a reimbursement = zero gross profit.  

    • An invoice with no bill or expense attachment will not calculate COGS (if not stated in your products and services), increasing your stated gross profit-income, and your tax liability.

    • An Invoice with only a receipt attachment may not calculate the true COGS, or COGS at all, to your income statement (from the receipt) if the price and cost are pulling from the products and services and no billable expense item is attached. Increasing gross profit income and your tax liability.

    • Sales, Inventory and COGS should be reconciled EOM.

    • Create a (BOM) monthly and save to My Accountant > Shared Documents, maintaining a historical record of Inventory, COGS and Sales.


How do you keep your products and services price and cost updated?

Use Average Costing Method of Inventory Valuation. Read More:

OR

Average Cost of Services

When taking an inventory count:

Ending Inventory - Beginning Inventory + Purchases =

  • (+ result) debit inventory, credit COGS

    (COGS was overstated, inventory was understated)

  • (- result) credit inventory, debit COGS

(COGS was understated, inventory was overstated)


Cost of goods sold: How to calculate and record COGS
Cost of goods sold: How to calculate and record COGS



Subscribe to our newsletter

Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
OPEN HOURS

Mon - Fri: 6am - 6pm

​​Saturday: By Appointment

​Sunday: By Appointment

CONTACT US

Phone: 480-734-9786
(text messages preferred)

MAILING

8390 E. Via De Ventura F110

Scottsdale, Arizona 85258

What my clients say

Client Testimonials

I would highly recommend Priscilla for any accounting needs. Her company Bookkeeping Business Online is an outstanding accounting firm who would be an asset to any business.

Karen

I appreciate it Priscilla, it's a pleasure to work with you.

Murat

Just thought I would let you know that since all of my books are now done in QuickBooks, the amount of time it takes me to do my taxes has decreased from two weeks to just over one day.  Thank you for getting me started.

Dale

Jobber is a field service application
Fishbowl Inventory
CLASS ACTION U LOGO.png
Xero is a cloud-based accounting software platform designed for small and medium-sized businesses.
Synder is Ecommerce transaction syncing program
Passpack is a team password management platform
QuickBooks Live Experience Advanced Certified Pro Advisor
QuickBooks Live Experienced Payroll Certified
QBO Partner #backingyou
Shoeboxed: Receipt scanning app or receipt scanning service—your choice.
Reduce overselling and stock errors with Finale's platform that continuously syncs across sales channels and integrations.

Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. Used with permission under the QuickBooks ProAdvisor Agreement.

Your information is protected by
256-bit SSL encryption
  • X
  • @onlinebkpg
  • LinkedIn

RESUME

parse.ly      Privacy Policy

chart beat  Privacy Policy

mix panel   Privacy Policy

Dreamstime mock.jpg

NAICS CODE 541219-03

SIC CODE 8721 

© 2023 by bookkeepingbusinessonline.com  

bottom of page