Hi, many small businesses such as cafes do not track inventory. I cannot see how to simply set up to show COGS separate to Operating Expenses so you have Sales, less COGS (Opening Stock + Purchases, less Closing Stock) = Gross Profit, less Expenses = Net Profit, Where maybe Opening & Closing Stock c…

Read though this topic - about half way down there is a model set up [image] Inventory accounting using Opening Stock + Purchases - Closing Stock I don’t want to use Inventory items etc. I want it to be turned off but at the same time when i make a sales invoice the figu…

In a cafe using inventory is impractical. Most of what you purchase are ingredients. You dont just buy in a tomato and sell it. You buy a bag of coffee beans and sell it in dozens of different coffees, same with milk, flavourings etc. It would be impossible and inaccurate to run an inventory system …

Below is the Non-Inventory setup if using Opening / Closing Stock LHS Chart of Account set up - RHS Summary tab P&L Statement [image] If not using Opening / Closing stock - then a more basic model [image] The point is - you can designed the Chart of Accounts to do exactly as you want. There a…

Thank you, that looks good. “The point is - you can designed the Chart of Accounts to do exactly as you want.There are no limitations, boundarys or controls.” And that is the way it should be, just a matter of knowing how to do it.

[image] tec: just a matter of knowing how to do it. Go to Settings - Chart of Accounts and all the tools are there and read this Guide [image] Set up chart of accounts When setting up a new accounting system, usually you start with the Chart of account…

I have set that up, except I cannot see how to get your Gross Profit & COGS totals ? [image]

Got it for the COGS. Now for the Gross profit Sub-total. [image]

Make Gross Profit a new group. Use the code field to control position and what contributes to each group: [image]

I have that but clearly I am doing something wrong; [image]

The Gross Profit should be a “New Total” as you want a calculation to occur. Not a “New Group” as indicated above as that only provides a Heading

COGS when Inventory not tracked

Brucanna November 15, 2016, 10:10pm 6

Go to Settings - Chart of Accounts and all the tools are there and read this Guide

Topic		Replies	Views
Calculating COGS	3	884	August 24, 2017
How to show Gross Profit?	3	222	April 6, 2026
Selling Inventory Not Invoiced, COGS & Profit Margins	6	828	July 13, 2018
Cost of sales	3	452	June 26, 2023
COGS items not related directly to inventory items	3	423	December 27, 2018

COGS when Inventory not tracked

Related topics