Profit & COGS
By Richard Rost 2 years ago
Net Profit and Cost of Goods Sold for Orders
In this video, I'll show you how to take my free Invoicing Template and add a unit cost to each line item. This will allow you to calculate your net profit for each order and, in turn, your Cost of Goods Sold (COGS).
Emerson from Chesterfield, UK (a Platinum Member) asks: I'm using your Invoicing Template. How can I add the cost of each item sold so that I can calculate my net profit for each order, and my Cost of Goods Sold for the quarter?
Members will add Unit Cost to the Product Table in the Member version of the Invoicing Template. We'll add it to the product combo box on the order form so it automatically populates into the order detail form. Then we'll create am aggregate query showing COGS for each quarter.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, calculate profit, gross profit margin, cost of goods sold, cogs, profit for each month, profit for quarter
Subscribe to Profit & COGS
Get notifications when this page is updated