Re: [GNC] GNC] Question about Assemblies

2022-03-22 Thread Michael or Penny Novack

On 3/22/2022 9:46 AM, davidvernonl...@gmail.com wrote:

Hi Derek,
I meant that a half decent accounting system which has an inventory system 
would have those features, and am sorry if my statement was misunderstood. I 
use GnuCash to maintain a set of accounts for a boat club with nearly 100 
members and it is excellent for that, and I use the business aspects as I have 
members as customers for service/fees etc.
On your points, of course GnuCash can track costs of inventory in its G/L, but 
when it comes to recording inventory levels to manage a manufacturing business, 
quantities are really needed ,either in the system , or in an external system.  
Then you would need to link the 2 systems, either automatically or manually. If 
manually then ,to move raw materials after manufacture to finished product, 
calculations would have to be done outside GnuCash to multiply  quantity and 
unit cost of each item consumed to provide total cost , and then manual 
postings to GnuCah General Ledger for total cost (Cr raw materials/ Dr finished 
goods) and the same for sales to move from finished inventory to cost of sales 
(Cr finished goods/Dr Cost of goods sold).
To make it more complicated this has to be done on as FIFO or average cost 
basis, depending on the jurisdiction, as particular items will be purchased 
many times for inventory and taken out of inventory for consumption, at 
different times and different quantities. An accounting system with inventory 
management does this for you. To do this semi manually in Excel and then use 
the result to make a journal to GnuCash could  be a lot of work depending on 
the number of transactions.


A business operation needs all sorts of record keeping. The accounting 
package is just part of that. Gnucash is an accounting package. If 
inventory is involved, then also an inventory package, if employees, a 
payroll/human resources package, etc.


Yes, these systems interact, and if only manually a lot of work. If they 
can send and accept "feeds" between the parts, a LOT less as that part 
of it can be automated << and that's where my professional days were 
spent -- in my case, at a "financial">>


You are missing that a proper inventory system needs/should have MUCH 
more than the part that would interact with general ledger. Where 
shelved, what';s the reorder level, who is the supplier, who are 
alternate suppliers, etc. Similarly the payroll system/HR needs more 
than what interacts with general ledger. Who is the emergency contact, 
who is the bene on the employee insurance policy, etc. .


From MY point of view, all that gnucash is missing in this regard is 
the ability to accept "feeds" << normally "general ledger" accepts feeds 
but does not send feds to other parts of the business system -- most of 
them send feeds to general ledger and send to and accept form each other 
>> If gnucash can do THAT, then it is up to other teams to create 
inventory systems, POS systems, payroll systems, etc. that will pay well 
with gnucash handling general ledger.


Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNC] Question about Assemblies

2022-03-22 Thread john
David,

Derek described a way to handle a (simple) retail business with GnuCash. 
Manufacturing is another matter entirely and involves an accounting specialty 
named Cost Accounting. Enterprise resource planning, or ERP, is one flavor of 
cost accounting widely used in many industries. There are others, for example 
the integrated circuits industry uses a system called standard cost accounting. 
ERP doesn't work because aside from the wafers only tiny amounts of some of the 
process inputs actually end up in the product so it's not possible to create a 
meaningful BOM. In standard cost accounting each step in the process is 
assigned a standard cost and WIP accumulates the standard costs for each step 
in the process.

There are a few open-source ERP packages available. GnuCash is definitely not 
one of them and doesn't aspire to be.

Regards,
John Ralls



> On Mar 22, 2022, at 6:46 AM, davidvernonl...@gmail.com wrote:
> 
> Hi Derek,
> I meant that a half decent accounting system which has an inventory system 
> would have those features, and am sorry if my statement was misunderstood. I 
> use GnuCash to maintain a set of accounts for a boat club with nearly 100 
> members and it is excellent for that, and I use the business aspects as I 
> have members as customers for service/fees etc.
> On your points, of course GnuCash can track costs of inventory in its G/L, 
> but when it comes to recording inventory levels to manage a manufacturing 
> business, quantities are really needed ,either in the system , or in an 
> external system.  Then you would need to link the 2 systems, either 
> automatically or manually. If manually then ,to move raw materials after 
> manufacture to finished product, calculations would have to be done outside 
> GnuCash to multiply  quantity and unit cost of each item consumed to provide 
> total cost , and then manual postings to GnuCah General Ledger for total cost 
> (Cr raw materials/ Dr finished goods) and the same for sales to move from 
> finished inventory to cost of sales (Cr finished goods/Dr Cost of goods 
> sold). 
> To make it more complicated this has to be done on as FIFO or average cost 
> basis, depending on the jurisdiction, as particular items will be purchased 
> many times for inventory and taken out of inventory for consumption, at 
> different times and different quantities. An accounting system with inventory 
> management does this for you. To do this semi manually in Excel and then use 
> the result to make a journal to GnuCash could  be a lot of work depending on 
> the number of transactions.
> 
> When you say "Similarly, when you make a Customer Invoice, you can pull from 
> an Asset instead of Income", this would not be correct. The sale must still 
> be an income account, (Cr Income/ Dr Receivables)and you would need a further 
>  entry, the one I describe above, to calculate the cost of the inventory 
> reduction and record cost of sales as an expense.
> 
> On the maintenance of recipes , all major accounting/ERP systems designed for 
> manufacturing have bill of materials, sometimes called recipes or 
> formulations in process industries. Just replace no of items with litres, kg 
> or whatever. However, GnuCash makes no pretence to be an ERP system in a 
> manufacturing environment, and is great at what it does.
> 
> I do see though that SAGE has a Bill of Materials System:
> " Bill of Materials
> Monitor, control, and cost your manufacturing processes for businesses 
> involved in light manufacturing assembly, helping to simplify complex process 
> and analysis. Includes using multiple BOMs with different options for 
> sub-assembly builds, stock, or multiple units of measure."
> 
> Thanks for your work on developing the business aspects of GnuCash, which is 
> much appreciated, in my boat club now I have retired from the Chemical 
> Industry.
> Best
> David
> 
> 
> 
> 
> -Original Message-
> From: Derek Atkins  
> Sent: Tuesday, 22 March, 2022 11:40 AM
> To: David Long 
> Cc: D. via gnucash-user 
> Subject: Re: [GNC] GNC] Question about Assemblies
> 
> David,
> 
> On Tue, March 22, 2022 2:32 am, David Long wrote:
>> Best to use system which has inventory accounting as then you won't 
>> have to worry about accounting double entry as system will generate it 
>> for you automatically.
> 
> Perhaps...
> 
>> When you enter a purchase invoice it will have a quantity purchase 
>> field so item will be put into stock at cost and quantity. Then there 
>> will be a manufacturing transaction which will take it out of raw 
>> materials and into finished stock (assemblies) at cost and quantity.. 
>> When it's sold it there will be a sales transaction in quantity and 
>> p

Re: [GNC] GNC] Question about Assemblies

2022-03-22 Thread Adrien Monteleone

On 3/22/22 8:46 AM, davidvernonl...@gmail.com wrote:

On your points, of course GnuCash can track costs of inventory in its G/L, but 
when it comes to recording inventory levels to manage a manufacturing business, 
quantities are really needed ,either in the system , or in an external system.


As some have noted, you can possibly use one of the investment type 
accounts to fudge quantity tracking, though it of course isn't designed 
for this and doesn't work like other software in this regard. It also 
takes a little bit of mental gymnastics to grok it.


Then you would need to link the 2 systems, either automatically or 
manually. If manually then ,to move raw materials after manufacture to 
finished product, calculations would have to be done outside GnuCash to 
multiply  quantity and unit cost of each item consumed to provide total 
cost , and then manual postings to GnuCah General Ledger for total cost 
(Cr raw materials/ Dr finished goods) and the same for sales to move 
from finished inventory to cost of sales (Cr finished goods/Dr Cost of 
goods sold).


Depending on the inventory and assembly 'recipe' complexity, this can be 
done in a spreadsheet. GnuCash can import transactions, so this 
spreadsheet can create an 'import sheet' version of the final data as 
transactions to be imported - no need for manual entry.



To make it more complicated this has to be done on as FIFO or average cost 
basis, depending on the jurisdiction, as particular items will be purchased 
many times for inventory and taken out of inventory for consumption, at 
different times and different quantities. An accounting system with inventory 
management does this for you. To do this semi manually in Excel and then use 
the result to make a journal to GnuCash could  be a lot of work depending on 
the number of transactions.


Yes, *if* it includes inventory management though GnuCash does not. But 
that doesn't mean it can't handle the accounting of inventory.


Stand-alone inventory management software will generate the necessary 
transactions according to the above considerations to import to any 
accounting package as will point of sale software.


Sometimes, all three functions (as well as Payroll, and other features) 
are shoehorned into one piece of software. Those either cost a small 
fortune, if not a hefty subscription, and/or turn out to be not so great 
at one or more of those 'modules'.




When you say "Similarly, when you make a Customer Invoice, you can pull from an 
Asset instead of Income", this would not be correct. The sale must still be an 
income account, (Cr Income/ Dr Receivables)and you would need a further  entry, the one I 
describe above, to calculate the cost of the inventory reduction and record cost of sales 
as an expense.


Correct. You're describing a Point of Sale (POS) system, another entity 
entirely. Some may have integrated G/L accounting, but not all, and the 
better systems simply offer the relevant transactions for export/import 
to real accounting software.


GnuCash's Business Features are somewhat flexible in the use cases they 
can serve, but they don't shine as a retail/manufacturing POS and are 
geared more toward 'service' type industries.



On the maintenance of recipes , all major accounting/ERP systems designed for 
manufacturing have bill of materials, sometimes called recipes or formulations 
in process industries. Just replace no of items with litres, kg or whatever. 
However, GnuCash makes no pretence to be an ERP system in a manufacturing 
environment, and is great at what it does.

I do see though that SAGE has a Bill of Materials System:
" Bill of Materials
Monitor, control, and cost your manufacturing processes for businesses involved in 
light manufacturing assembly, helping to simplify complex process and analysis. 
Includes using multiple BOMs with different options for sub-assembly builds, stock, 
or multiple units of measure."


What you have described above is really separate software:

-General Ledger Accounting

GnuCash is this.

Other related software would handle separately:

-Payables & Receivables
-Payroll
-Investments
-Loans & Notes
-Budgeting

GnuCash includes these in some form, but maybe not full-fledged.

Then there are packages like:

-Customer Relationship Management (CRM)
-Managerial Analysis
-E-commerce
etc.

GnuCash doesn't include those at all.

And those are just the generic types. Consider that a service business 
might want to track service calls/tickets, time spent on the job, time 
spent in travel, expenses for travel and incidentals, etc. Now, we 
wouldn't think GnuCash should include all of that industry-specific 
related functionality, right?


This is analogous to the retail/manufacturing specific functions:

Purchases & Acquisitions
Inventory Management
Manufacturing & Production
Point of Sale

All separate., though interrelated, functions, that sometimes are in the 
same software package, sometimes not, and not included in GnuCash.

Re: [GNC] GNC] Question about Assemblies

2022-03-22 Thread davidvernonlong
Hi Derek,
I meant that a half decent accounting system which has an inventory system 
would have those features, and am sorry if my statement was misunderstood. I 
use GnuCash to maintain a set of accounts for a boat club with nearly 100 
members and it is excellent for that, and I use the business aspects as I have 
members as customers for service/fees etc.
On your points, of course GnuCash can track costs of inventory in its G/L, but 
when it comes to recording inventory levels to manage a manufacturing business, 
quantities are really needed ,either in the system , or in an external system.  
Then you would need to link the 2 systems, either automatically or manually. If 
manually then ,to move raw materials after manufacture to finished product, 
calculations would have to be done outside GnuCash to multiply  quantity and 
unit cost of each item consumed to provide total cost , and then manual 
postings to GnuCah General Ledger for total cost (Cr raw materials/ Dr finished 
goods) and the same for sales to move from finished inventory to cost of sales 
(Cr finished goods/Dr Cost of goods sold). 
To make it more complicated this has to be done on as FIFO or average cost 
basis, depending on the jurisdiction, as particular items will be purchased 
many times for inventory and taken out of inventory for consumption, at 
different times and different quantities. An accounting system with inventory 
management does this for you. To do this semi manually in Excel and then use 
the result to make a journal to GnuCash could  be a lot of work depending on 
the number of transactions.

When you say "Similarly, when you make a Customer Invoice, you can pull from an 
Asset instead of Income", this would not be correct. The sale must still be an 
income account, (Cr Income/ Dr Receivables)and you would need a further  entry, 
the one I describe above, to calculate the cost of the inventory reduction and 
record cost of sales as an expense.

On the maintenance of recipes , all major accounting/ERP systems designed for 
manufacturing have bill of materials, sometimes called recipes or formulations 
in process industries. Just replace no of items with litres, kg or whatever. 
However, GnuCash makes no pretence to be an ERP system in a manufacturing 
environment, and is great at what it does.

I do see though that SAGE has a Bill of Materials System:
" Bill of Materials
Monitor, control, and cost your manufacturing processes for businesses involved 
in light manufacturing assembly, helping to simplify complex process and 
analysis. Includes using multiple BOMs with different options for sub-assembly 
builds, stock, or multiple units of measure."

Thanks for your work on developing the business aspects of GnuCash, which is 
much appreciated, in my boat club now I have retired from the Chemical Industry.
Best
David




-Original Message-
From: Derek Atkins  
Sent: Tuesday, 22 March, 2022 11:40 AM
To: David Long 
Cc: D. via gnucash-user 
Subject: Re: [GNC] GNC] Question about Assemblies

David,

On Tue, March 22, 2022 2:32 am, David Long wrote:
> Best to use system which has inventory accounting as then you won't 
> have to worry about accounting double entry as system will generate it 
> for you automatically.

Perhaps...

> When you enter a purchase invoice it will have a quantity purchase 
> field so item will be put into stock at cost and quantity. Then there 
> will be a manufacturing transaction which will take it out of raw 
> materials and into finished stock (assemblies) at cost and quantity.. 
> When it's sold it there will be a sales transaction in quantity and 
> price which will generate an invoice and take item out of finished 
> product stock in quantity and cost, and then calculate the sales less 
> cost of goods sold so you know your margins
>
> Hardly any of this can be done by GnuCash so you will need to use 
> spread sheets and have a course in accounting.

I would argue this statement is incorrect and misleading.  Indeed, I would say 
*MOST* of this can be done in GnuCash, although it might not be as seamless as 
it could be.  For example, when you make a Vendor Bill in GnuCash, you can send 
it into an Asset instead of an Expense (which includes Stock/Mutual accounts).  
Similarly, when you make a Customer Invoice, you can pull from an Asset instead 
of Income.

The difference in the sale and purchase of the asset is your Income (margin).

I agree that this is not as seamless as it could be in GnuCash (I admit, when I 
originally wrote the business features I did it from the point of view of 
running a consulting company, not a manufacturing company -- but I did attempt 
to add the features to make the latter *possible*, if not necessarily seamless).

> Plus ,a half decent accounting system which has inventory accounting 
> would also have sales and purchase order management and a bill of 
> material system t

Re: [GNC] GNC] Question about Assemblies

2022-03-22 Thread Derek Atkins
David,

On Tue, March 22, 2022 2:32 am, David Long wrote:
> Best to use system which has inventory accounting as then you won't have
> to
> worry about accounting double entry as system will generate it for you
> automatically.

Perhaps...

> When you enter a purchase invoice it will have a quantity purchase field
> so
> item will be put into stock at cost and quantity. Then there will be a
> manufacturing transaction which will take it out of raw materials and into
> finished stock (assemblies) at cost and quantity.. When it's sold it there
> will be a sales transaction in quantity and price which will generate an
> invoice and take item out of finished product stock in quantity and cost,
> and then calculate the sales less cost of goods sold so you know your
> margins
>
> Hardly any of this can be done by GnuCash so you will need to use spread
> sheets and have a course in accounting.

I would argue this statement is incorrect and misleading.  Indeed, I would
say *MOST* of this can be done in GnuCash, although it might not be as
seamless as it could be.  For example, when you make a Vendor Bill in
GnuCash, you can send it into an Asset instead of an Expense (which
includes Stock/Mutual accounts).  Similarly, when you make a Customer
Invoice, you can pull from an Asset instead of Income.

The difference in the sale and purchase of the asset is your Income (margin).

I agree that this is not as seamless as it could be in GnuCash (I admit,
when I originally wrote the business features I did it from the point of
view of running a consulting company, not a manufacturing company -- but I
did attempt to add the features to make the latter *possible*, if not
necessarily seamless).

> Plus ,a half decent accounting system which has inventory accounting would
> also have sales and purchase order management and a bill of material
> system
> to hold your soap recipes.

So having an inventory system is a requisite for an accounting package to
be "half-decent"?  Huh?

The "Job" feature of GnuCash was an attempt as a purchase-order solution. 
There was also the concept of an "Order" (which was an attempt at
something between a PO and a Quote), but those were never completely
finished and I believe have since been removed.   That notwithstanding, I
would argue an accounting program is NOT the right place to maintain
recipes.

> David

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] GNC] Question about Assemblies

2022-03-22 Thread David Long
decreasing, hence the slow decline
> in traffic. It seems the community is being very helpful, thus there's
> little need to intervene.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
> David Carlson
>
>
> --
>
> Message: 3
> Date: Mon, 21 Mar 2022 15:17:03 -0500
> From: David Carlson 
> To: Fran_3 
> Cc: Christopher Lam ,  GnuCash users group
> 
> Subject: Re: [GNC] Have you abandoned gnuCash email list? U were so
> helpful!
> Message-ID:
>  so+t-yee...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Fran_3,
>
> I did not see your original message.  Did you send it directly to
> Christopher instead of the list?  That is seriously discouraged, and the
> primary reason that I thought that was phishing.
>
> On Mon, Mar 21, 2022 at 1:58 PM Fran_3  wrote:
>
> > Not phishing. I use gnuCash each year for a 2 or 3 weeks to help 3 very
> > small entities here in Florida.
> > They make the data inputs during the year and I try and help them
> organize
> > their annual financials for their tax guy to do their taxes.
> >
> > That said, I am not an accountant but I know enough to get by with a
> > little help from the great gnuCash forum members.
> >
> > And, I will say that I am a big fan of the program... even though I wish
> > it could also generate reports on a cash basis... as opposed to an
> accrual
> > basis... but I can get there by exporting select gnuCash accounts and
> > Transaction Reports to cvs files and then loading them into Google Sheets
> > or Excel.
> >
> > Thanks.
> > Fran Lee
> > Florida
> >
> >
> >
> > On Monday, March 21, 2022, 10:45:36 AM EDT, David Carlson <
> > david.carlson@gmail.com> wrote:
> >
> >
> > That looks to me like it was an exceptionally well crafted phishing email
> >
> > On Sun, Mar 20, 2022 at 8:20 PM Christopher Lam <
> christopher@gmail.com>
> > wrote:
> >
> > On Sun, 20 Mar 2022 at 14:34, Fran_3  wrote:
> >
> > > (snip).
> > >
> > Now I don't see you participating and it seems traffic on the list is way
> > > down.
> > > Have the developers abandoned the project?
> > >
> >
> > Thank you Fran; no, the project is alive as long as there is interest in
> > it. The number of live bugs seems to be decreasing, hence the slow
> decline
> > in traffic. It seems the community is being very helpful, thus there's
> > little need to intervene.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> >
> >
> > --
> > David Carlson
> >
> >
>
> --
> David Carlson
>
>
> --
>
> Message: 4
> Date: Mon, 21 Mar 2022 17:00:38 -0400
> From: Michael or Penny Novack 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Have you abandoned gnuCash email list? U were so
> helpful!
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> On 3/21/2022 2:58 PM, Fran_3 via gnucash-user wrote:
>
> >   even though I wish it could also generate reports on a cash basis...
> as opposed to an accrual basis... but I can get there by exporting select
> gnuCash accounts and Transaction Reports to cvs files and then loading them
> into Google Sheets or Excel.
> > Thanks.Fran LeeFlorida
> >
> Gnucash certainly can keep books on the cash basis << all the orgs I
> kept books for were cash basis >>
>
> What it can't do is support the "business features" like invoicing
> except accrual basis. That's awkward for those organizations that would
> like to send members/donors "statements". Also awkward for t

Re: [GNC] Question about Assemblies

2022-03-21 Thread Adrien Monteleone
Fred, please be sure to always copy the list address on all replies so 
the discussion stays on the list.


That way, others can benefit from the discussion, as well as chime in 
and help out.


Also keep in mind, we don't give accounting advice here. If you need 
such advice, you need the services of an accountant.


But once you know 'what' to do, we can help you with the 'how to do it 
in GnuCash.'


-

I am not familiar with Sage so I can't explain how GnuCash works in 
reference to what you were doing before.


There is no inventory management in GnuCash.

You can set up accounts to track the *value* of your inventory, but not 
the quantity. (at least not out of the box, and without lots of work)


You should make entries when you purchase ingredients/materials.

Then you should make entries when you assemble or make something from those.

Then you make more entries when you sell the assembled products.

Basic Accounting Generic Examples
-

When you purchase ingredients for soap:

Dr. Assets:Inventory:Raw Materials
Cr. Assets:Bank

This 'moves' money from your bank account to 'Raw Materials'. (which is 
now in the form of Inventory, so this records the value of that inventory)


When you make the soap:

Dr. Assets:Inventory:Work In Progress
Cr. Assets:Inventory:Raw Materials

This moves that value from Raw Materials to inventory 'in production' 
but not yet finished. (this step may be optional for you if the time 
involved in production is rather short, like one day or less and you 
package as part of the basic production process.)


When you package the final product ready for sale:

Dr. Assets:Inventory:Finished Goods
Cr. Assets:Inventory:Work In Progress

This moves the value from 'in production' to its final state as a 
Saleable Good or Finished Product.


When you sell a finished product:

Dr. Assets:Cash
Cr. Revenue:Sales
Dr. Expenses:Costs of Goods Sold
Cr. Assets:Inventory:Finished Goods

For this last one, the value of the first two splits should be equal, 
and the value of the last two splits should be equal. (but they will of 
course be less than the first two, or else you aren't making a profit!)


The first two splits record the receipt of payment (could be 
'Undeposited Funds' if by Credit Card or Paper Check instead of 'Cash') 
and 'recognizes' the revenue earned. (by type, in this case 'Sales Revenue')


The second two splits move the value of the inventory sold out of 
inventory entirely, and records it as an expense of doing business. 
(which will eventually be subtracted from revenue to obtain 'income', 
Revenue - Expenses = Income) The Profit & Loss Report or Income 
Statement Report (same report - different names) will handle that math 
for you.


Your actual transactions may differ, but this is a 'big picture' 
overview of the generic inventory-to-sales process.


--

The math for figuring out the value of raw materials that go into a 
product that you'll need for making those 'in progress'/'finished goods' 
entries in GnuCash is something you're going to have to setup outside of 
GnuCash in a spreadsheet or other inventory management software.


If you like, it is possible to export the result from the spreadsheet or 
other software into GnuCash so you don't have to manually cross-enter 
anything.


If you only have one or a small handful of products you only need do the 
math by hand once, and then you can just duplicate those transactions 
changing the dates.


You can also put in the Memo fields the proportions of each ingredient 
as a reminder, then enter that as a math equation in the transaction 
instead of just a final number. GnuCash can do the calculations for you.


--
There are no shortcuts if you're going to do your own accounting. You 
just have to learn it.


It really isn't difficult, and you don't have to learn 'all' of 
accounting, just what you need for your business. (and you won't learn 
it all at once, most likely, as you find out you need to know it)


Accounting is not about difficult or fancy math. The hard part is 
learning 'how to account' properly for your activity. That's it.



Regards,
Adrien


On Mar 17, 2022 w12d76, at 10:20 AM, Frederick  wrote:

Hi Adrian, thanks for your response.  

Unfortunately i am a bit confused by it, however.  I am sure this comes from being as guy who makes soap and the accounting is done, only as a necessity and not by way of my profession.  I am definitely trying to avoid taking an accounting course (-:  


I am a maker of stuff that wants to track assembly-build  (Sage 50 terms) as i 
do now with my Sage 50 software.  I set up my system to purchase ingredients 
and then Assemble-Build these ingredients into finished goods that i sell.  I 
track quantities and value of ingredients and finished goods. I am looking for 
a different platform to do this tracking, both monetary and quantity.  It 
sounds like you are saying the monetary tracking is possible but the 
quantity/item 

Re: [GNC] Question about Assemblies

2022-03-16 Thread Adrien Monteleone
If you're looking for 'inventory control/manangement' or 'item tracking' 
by quantity, no, GnuCash can't do it. (out of the box)


Some people have finagled it to do so using user-defined commodity 
accounts, but that seems like more trouble than it is worth.


Inventory management should be done in a separate app and the resulting 
monetary values imported into GnuCash for accounting.


If you just want to track monetary-value of your inventory, yes, 
absolutely, GnuCash can handle that, be it parts, assemblies, etc.


A good accounting reference on manufacturing accounting will show you 
the transaction entries for acquiring the raw material inventory, and 
then moving inventory from raw materials, to work in progress, to 
finished goods, then cost of goods sold and revenue.


Here's a good start: https://www.principlesofaccounting.com/

But there are plenty of others online and in your nearest library. 
Especially consider college texts for basic and 2nd level accounting. 
(usually the first two courses are from the first half and second half 
of the same text)


Regards,
Adrien

On 3/16/22 8:59 PM, Frederick wrote:

Hi there, i am a interested in abandoning my Accounting software and looking to 
see if Gnucash will work for my one person business.

The main issue is that i manufacture items to sell and need software that can 
account for assemblies.  This can go by the name of manufacture/build or 
assembly.  Sage 50 calls this Assembly.

If someone can let me know if builds are easily possible with gnucash and 
direct me to literature on this matter, it would be greatly appreciated.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Question about Assemblies

2022-03-16 Thread Liz
On Thu, 17 Mar 2022 01:59:28 +
Frederick  wrote:

> Hi there, i am a interested in abandoning my Accounting software and
> looking to see if Gnucash will work for my one person business.
> 
> The main issue is that i manufacture items to sell and need software
> that can account for assemblies.  This can go by the name of
> manufacture/build or assembly.  Sage 50 calls this Assembly.
> 
> If someone can let me know if builds are easily possible with gnucash
> and direct me to literature on this matter, it would be greatly
> appreciated.
> 
> take care,  fred
> 

I'm assuming here that you mean "manufacture a widget" for assembly and
build.
There are other meanings of build that software developers use.

When I make an invoice I can invoice different items. I can invoice
Time, different types of Service, and different Goods.

We don't know how you account for manufacturing costs when you invoice,
nor how you spread this income in your accounts. If you give some more
details, someone who is already doing similar with Gnucash can advise. 

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Question about Assemblies

2022-03-16 Thread Frederick
Hi there, i am a interested in abandoning my Accounting software and looking to 
see if Gnucash will work for my one person business.

The main issue is that i manufacture items to sell and need software that can 
account for assemblies.  This can go by the name of manufacture/build or 
assembly.  Sage 50 calls this Assembly.

If someone can let me know if builds are easily possible with gnucash and 
direct me to literature on this matter, it would be greatly appreciated.

take care,  fred




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.