Addition of a "Cost" column to enhance visibility into business performance
A
Aaron Farley
Small businesses we've worked with have said they do not have the skills or resources to leverage a SW integration with, say, QuickBooks. While GHL already tracks revenue (when products are sold), adding a cost column would help more fully track and run their business on GHL.
Our thoughts on possible implementation are below:
-->Light implementation: addition of a static cost column in the 'Inventory' section whereby a user inputs the cost for a given product. This could be updated by the user as product costs change.
=>Upon sale of a product, the revenue could be registered from the sale price and the cost could be pulled from the cost recorded in the 'Inventory' section, providing a close measure of profit for each transaction.
-->Full implementation: a database that records product cost information as it is entered and timestamps the entry. User could select FIFO (first in, first out) or LIFO (last in, first out) accounting methods to drive the logic determining product cost for a given sale.
=>For example: a user buys 5 packs of cinnamon rolls for $3/ea on Jan 1 and 6 packs for $2/ea on Jan 15. GHL records the existence of these in inventory with their stated cost at that time. When the cinnamon roll is purchased on Jan 23rd, the revenue would be recorded based on the sale price and the cost would be recorded either as $3 (FIFO) or as $2 (LIFO) depending on the accounting method selected.
Log In