[GNC] Example of importing Stock transactions from CSV
https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102526.html > CSV stands for "common separated variables. > data must be in the right order AND any data that is null (not present still has its space in the record. Hmm: * Comma separated variables - https://en.wikipedia.org/wiki/Comma-separated_values * First row commonly contains field names to identify data order ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is GnuCash right for me?
Yes, using a proper database for keeping track of equipment and RMA tracking makes sense. GnuCash can manage your invoicing, etc. My wife wants to run the entire business from Excel, and in one spreadsheet I think? Databases seem more proper to me :-) YES! People seem to think a spreadsheet program is a be-all-end-all application (ARG!). This is like tossing out your whole toolbox and buying a Swiss Army Knife as a replacement. Would you actually do that? Those of us who learned bookkeeping in the old pen and ink on paper days can easily see how a spreadsheet application could be used for double entry bookkeeping just substituting suitably arranged columns for the special lined accounting paper that we used to use. Simply point out to somebody who suggests this that by far the greatest number of errors were transcription errors during posting. If the want the familiar format in which they used to enter transactions, tell them to choose "journal view" to enter transactions AND POSTING IS AUTOMATIC (and error free). BUT -- gnucash is just an accounting package. It is NOT a complete "business system". THAT would have other parts to it, payroll and HR, inventory, point of sales, etc. If an integrated business system, some of these components would send "feeds" to other parts (automation of data from one of these affecting another part --- POS records the sale of something and tells inventory to adjust for widget sold and accounting to enter the transaction. If you need these other parts of your business system, you'll need other applications, databases, etc. Michael D Novack PS --- you should NOT be surprised that the free software community has not (yet) constructed a general purpose "business system". THAT would be an enormous undertaking. Some elements of business systems are common to all (general ledger -- that's what gnucash is) but many are not. Payroll/HR is only if there are employees (and a sole proprietorship or partnership might not). Billable hours relevant to a professional services business but not inventory, and vice versa for a retail store. In other words, a complete "general purpose" business system would have to have lots of parts NOT relevant to most of its users. Many/most of the commercial offerings are specialized. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is GnuCash right for me?
On 2022-08-20 09:08, Robert Heller wrote: At Sat, 20 Aug 2022 10:32:03 -0400 d...@ditdit.us wrote: HI Everyone, Sorry for the totally noob uneducated question. I'm an engineer by training, not an accountant! I recently started a home business and everyone said "Quickbooks". It's too expensive and I despise subscription software. Online/cloud options are not an option, we have limited (and expensive) internet where we live. The business is repairing custom electronic equipment. What I want/need: Basic money tracking for the checking account. Keep track of equipment based on serial number (I was thinking a database). Here I will keep a record of owner(s), data like software versions, and work done per RMA. RMA tracking (another database?). Ability to generate RMA numbers or use one supplied by the distributor. Invoicing based on what was done on an RMA (labor, parts and state tax if applicable). Simple payroll (I'm the only employee). Light duty inventory control. I have about 30 items, some are almost too cheap to track, a few items are expensive, some of those are supplied by the manufacturer so I need to settle with them at the end of the month. I use GnuCash for my business and home finances. Works well for me. I am a computer programmer and Linux Admin. GnuCash does not have support for "Payroll" functions, but with a single "employee" (yourself), there really isn't any "payroll" in the full HR sense: you are not going to need to bother with payroll taxes -- you are "self-employed", so you might do quarterly estimates & payments to the IRS (and your state) and pay SE tax when you file your 1040 schedule C. You just need the numbers you will file on the 1040 schedule C, 1040SE, etc. GnuCash will have those numbers. Inventory management is "interesting" with GnuCash, but it sounds like you could manage. GnuCash does not really have any proper tools for true inventory management (eg for a proper storefront), but for a small scale it can be made to work, possibly with a small database on the side. If you just want to keep track of how much you owe the suppliers (and if you need resupply), GnuCash can do that just fine (eg you just create account(s) for the inventory -- when you acquire more inventory you add the value to the inventory account and when you sell or use some inventory, you reduce the inventory account by the amount used/sold. Yes, using a proper database for keeping track of equipment and RMA tracking makes sense. GnuCash can manage your invoicing, etc. My wife wants to run the entire business from Excel, and in one spreadsheet I think? Databases seem more proper to me :-) YES! People seem to think a spreadsheet program is a be-all-end-all application (ARG!). This is like tossing out your whole toolbox and buying a Swiss Army Knife as a replacement. Would you actually do that? (Yes, a Swiss Army Knife is great on a camping trip or if you are MacGiver, but otherwise, probably not really.) Using a spreadsheet for something like this is going to cause trouble later on. Spreadsheet software is not going to properly validate "data" and you you could end up with missing or incompatible data "fields" (I seen this happen and it leads to all sorts of weirdnesses). I second what Robert is saying here. GnuCash plus a database is the way to go. Excel is good for analysis of data; terrible for pretty much anything else. A single database with multiple tables will do the trick: from what you wrote one for inventory, one for RMA, and one for your equipment if needed. Use Excel to pull information from Gnucash reports and database exports to reconcile the various data sources, if that becomes necessary. Cheers Cam ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of importing Stock transactions from CSV
On 8/19/2022 10:33 PM, Jon Schewe wrote: So I didn't get the CSV import tool to work. Perhaps a reminder on what CSV is and is not. CSV stands for "common separated variables. That means the data is in the form of a record consisting of a number of fields delineated by commas. Which means two important things. The fields (individual data elements) cannot contain commas but even more important, ORDER MATTERS. In other words, the record A,B,C,D is not the same a B,A,C,D << A, B, C, and D being elements of data, names, amounts, etc. >> The CSV data you are importing must not only be in CSV format but the data must be in the right order AND any data that is null (not present still has its space in the record. Thus if a record was supposed to include A, C, and DÂ (B is not relevant to this record) it would look like A,,C,D and not A,C,D But even the "wrong" examples are in CSV format. Michael ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is GnuCash right for me?
At Sat, 20 Aug 2022 10:32:03 -0400 d...@ditdit.us wrote: > > HI Everyone, > Sorry for the totally noob uneducated question. I'm an engineer by > training, not an accountant! > I recently started a home business and everyone said "Quickbooks". It's > too expensive and I despise subscription software. Online/cloud options > are not an option, we have limited (and expensive) internet where we > live. > > The business is repairing custom electronic equipment. > What I want/need: > Basic money tracking for the checking account. > Keep track of equipment based on serial number (I was thinking a > database). Here I will keep a record of owner(s), data like software > versions, and work done per RMA. > RMA tracking (another database?). Ability to generate RMA numbers or use > one supplied by the distributor. > Invoicing based on what was done on an RMA (labor, parts and state tax > if applicable). > Simple payroll (I'm the only employee). > Light duty inventory control. I have about 30 items, some are almost too > cheap to track, a few items are expensive, some of those are supplied by > the manufacturer so I need to settle with them at the end of the month. I use GnuCash for my business and home finances. Works well for me. I am a computer programmer and Linux Admin. GnuCash does not have support for "Payroll" functions, but with a single "employee" (yourself), there really isn't any "payroll" in the full HR sense: you are not going to need to bother with payroll taxes -- you are "self-employed", so you might do quarterly estimates & payments to the IRS (and your state) and pay SE tax when you file your 1040 schedule C. You just need the numbers you will file on the 1040 schedule C, 1040SE, etc. GnuCash will have those numbers. Inventory management is "interesting" with GnuCash, but it sounds like you could manage. GnuCash does not really have any proper tools for true inventory management (eg for a proper storefront), but for a small scale it can be made to work, possibly with a small database on the side. If you just want to keep track of how much you owe the suppliers (and if you need resupply), GnuCash can do that just fine (eg you just create account(s) for the inventory -- when you acquire more inventory you add the value to the inventory account and when you sell or use some inventory, you reduce the inventory account by the amount used/sold. Yes, using a proper database for keeping track of equipment and RMA tracking makes sense. GnuCash can manage your invoicing, etc. > > My wife wants to run the entire business from Excel, and in one > spreadsheet I think? Databases seem more proper to me :-) YES! People seem to think a spreadsheet program is a be-all-end-all application (ARG!). This is like tossing out your whole toolbox and buying a Swiss Army Knife as a replacement. Would you actually do that? (Yes, a Swiss Army Knife is great on a camping trip or if you are MacGiver, but otherwise, probably not really.) Using a spreadsheet for something like this is going to cause trouble later on. Spreadsheet software is not going to properly validate "data" and you you could end up with missing or incompatible data "fields" (I seen this happen and it leads to all sorts of weirdnesses). > > Thanks and enjoy the weekend. > > Dave > -- Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Is GnuCash right for me?
HI Everyone, Sorry for the totally noob uneducated question. I'm an engineer by training, not an accountant! I recently started a home business and everyone said "Quickbooks". It's too expensive and I despise subscription software. Online/cloud options are not an option, we have limited (and expensive) internet where we live. The business is repairing custom electronic equipment. What I want/need: Basic money tracking for the checking account. Keep track of equipment based on serial number (I was thinking a database). Here I will keep a record of owner(s), data like software versions, and work done per RMA. RMA tracking (another database?). Ability to generate RMA numbers or use one supplied by the distributor. Invoicing based on what was done on an RMA (labor, parts and state tax if applicable). Simple payroll (I'm the only employee). Light duty inventory control. I have about 30 items, some are almost too cheap to track, a few items are expensive, some of those are supplied by the manufacturer so I need to settle with them at the end of the month. My wife wants to run the entire business from Excel, and in one spreadsheet I think? Databases seem more proper to me :-) Thanks and enjoy the weekend. Dave -- Dit Dit Electronics ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.