[GNC] Can't run on High Sierra
Downloaded 3.8; won't open, though it's on computer. I should determine now if this is for developers, with encoded puzzles to frustrate the non-coding user. It just keeps verifying -- the scourge of the age. Then starts over -- the logo, verify, back to the beginning. I imagine it knows my income from Uncle Ed, and doesn't take me seriously. Is there an opening fix? Thanks, Jonathan Ames, PhD Clinical Psychologist 415 N. Tioga Street Ithaca NY 14850 607-319-5118 - Office 607-227-4792 - Cell jnthn.a...@gmail.com www.whatnowconnect.com Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message included in this email is for the sole use of the intended individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and you may be subject to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from all computers. ___ 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] Learning relate Gnucash to bank in 3-letter anagram world
Hi -- Obviously I'm new to Gnucash, though I've had it four years and decided after a few attempts that I had insufficient IQ, and was perhaps myself an evolutionary side-track. So on this last attempt I got accounts established; however, when time to attach to bank, or even copy and download transactions, it's alphabet city. So I don't lose my mind, someone please confirm that in 'open source' there is no automation of such transaction, as there is in Quicken, YNAB, etc.. I could download a QXF (or whatever) file to desktop, but could not bring it into Gnucash. The "import" tab doesn't seem operative, though I got the QFX from desktop into an odd file called "Imbalance" (unexplained). I then attempted to transfer the file to my home checking; would not do. The specific bank account behaves as if it were a placeholder, though it is a named account under "Bank Accounts". Of course, the bank uses its own categories; I would expect to categorize them as per "Common Accounts" list. I see on the web that others have struggled with this basic, essential function of any accounting program (such as Quickbooks, which I use and want to discontinue). I am running Sierra on an 8gb ram/512 gb storage. The help sources seem to have skipped over this function -- working with bank accounts. Sure it's there somewhere, though the three-step suggestion doesn't work. So: is automatic connection to bank accounts possible? If not, how do you "aim" downloaded QFX transaction files? Also, are Gnucash users mostly also developers, with at least some college CS (who therefore don't need to pay for commercial finance-tracking programs)? Thanks, anyone. Jonathan Ames, PhD Clinical Psychologist 415 N. Tioga Street Ithaca NY 14850 607-319-5118 - Office 607-227-4792 - Cell jnthn.a...@gmail.com www.whatnowconnect.com Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message included in this email is for the sole use of the intended individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and you may be subject to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from all computers. ___ 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] Brand new and lost...
I can keep a checkbook, but know really nothing of databases. Apparently I have to acquire a SQL database to run Gnucash? Can I keep it in the cloud, for access by 2 separate computers, or is it safe? I grew tired of Quickbooks, want to reach accounting program on Mac as well as Windows (Sierra/Win 10) -- and importantly, access and edit lists. The Gnucash manual indicates early on the need for one of three databases, and just leaves it at that. I can grasp the idea of a container for the data, but cannot imagine the linking up. I am also considering getting Filemaker, an older version. Is it possible to embed Gnucash customers and their financial status within Filemaker tables? By someone ignorant of coding? Does setting up and linking system require a STEM background, or is there a source for requisite basic DB understanding? The most confusing thing, other than the database question, is how Accounts and Customers interact -- in QB customers ARE accounts. So are they a sort of sub-account in Gnucash? Thanks Jonathan Ames, PhD Clinical Psychologist 415 N. Tioga Street Ithaca NY 14850 607-319-5118 - Office 607-227-4792 - Cell jnthn.a...@gmail.com www.whatnowconnect.com Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message included in this email is for the sole use of the intended individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and you may be subject to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from all computers. ___ 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] Editing, moving customer lists, possible child lists
Thanks, David. Appreciate your contextual placement of Gnucash in the database/SQL environment. Helps focus my thoughts, notions, etc. On Sun, Oct 21, 2018 at 11:07 PM David Cousens wrote: > Johnathon, > > It is possible to host the data files but not the application on a cloud > data storage. I use a dropbox so I can edit my files either at home, on my > laptop when I am mobile or away etc. I have also used Google Drive for the > same purpose In that case it is synchronised from the local machine I am > editing on to the dropbox server and that is not instantaneous. GnuCash's > customer data storage is not a general client information system and stores > little more than the name, some contact details and a billing and shipping > address. It is not as comprehensive as an ERP system for example. > > One reason some people use the database backends for GnuCash is so they can > access the GnuCash data from other applications using SQL queries. GnuCash > also has bindings to a Python API which can be used to access the data. It > is strictly an accounting system by design and as it is used in many > countries there tends to be an emphasis on generic accounting features > rather than being customized to a particular jurisdiction within the > program. Any specific customization would have to be external. > > I would be inclined to keep clinical patient data in a separate system > designed for that function e.g. > https://www.openclinica.com/community-edition-open-source-edc/, > https://openmrs.org/ and try to build or have someone develop a linking > system to the accounting functionality. Other possible options are listed > in > https://blog.capterra.com/top-7-free-open-source-emr-software-products/. > If > they are database based it will depend largely on how much information is > available on the database structure and how to access it as to how > difficult > that may be to achieve. This unfortunately is what you pay for in > commercial > products although they don't always deliver. > > The development and documentation teams for GnuCash are totally totally > volunteer. New features are implemented, but usually after a fair bit of > discussion and generally rely on one of the team members being interested > in > the feature or a significant demand from the user base. The main > development > effort is focussed on bug fixes and modernization of the code to stay up > with libraries GnuCash is dependent upon. > > The critical thing with flexible access to data is database design to > increase the ways in which data can be accessed. It is a highly specialized > field in and of itself to optimally design a database for such a function. > I > don't know enough about the systems I referenced above to know whether thay > are capable of meeting your needs. > > You will probably want to seriously look at the costs of customization of > software. It can be quite expensive and difficult depending on how good the > developer documentation is and the capabilities of any developer you would > hire. > > Can't really comment on database courses. There is plenty of online > material. I haven't had any experience with FileMaker as a relational dBMS. > MySQL, PostGRES, SQLite3 are largely ecosystem (Windows, MacOS) > independent > and available for most major OS's around however Access and Filemaker may > tie you to either the Windows or MacOS environments respectively. These > questions are really out of scope for the GnuCash forum however. > StackExchange and Tecmint may be more useful for more general info (among > many others) > > David > > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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. > -- Jonathan Ames, PhD Clinical Psychologist 415 N. Tioga Street #205 Ithaca NY 14850 607-227-4792 jnthn.a...@gmail.com www.whatnowconnect.com Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message included in this email is for the sole use of the intended individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, dis
Re: [GNC] Editing, moving customer lists, possible child lists
David, Thanks for your informative overview. It raises the question of whether Gnucash can be cloud and/or server-hosted, w/o adding glitch potential. Also, whether a Gnucash client/customer file can be nested within a database (e.g., Filemaker or Access-originated) perhaps as a table, which can contribute to queries originating in the host DB. For example, timeframes/costs for diagnostic categories -- when does meaningful change occur? Obviously, I'm in over my head; am not satisfied with current EMR apps -- basically, cannot afford them, and cannot retrieve meaningful data re, say, higher-functioning autism. Given that within our lifetimes kids will probably all be required to have 3-letter names, I want as much control over clinical data as my 72-year-old mind can handle. So another question: where does database 101 now reside? Thanks again, Jonathan Ames, PhD Clinical Psychologist 415 N. Tioga Street Ithaca NY 14850 607-319-5118 - Office 607-227-4792 - Cell jnthn.a...@gmail.com www.whatnowconnect.com Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message included in this email is for the sole use of the intended individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and you may be subject to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from all computers. On Sun, Oct 21, 2018 at 6:49 PM David Cousens wrote: > Jonathon, > > The customer information is separate from any account information. It is > not > generally necessary to have an account for each customer that you have as > the customer information can be linked to a specific transaction to an > account. An account in Gnucash is a register which records the movement of > funds. They may be associated with actual bank accounts for example or also > with categories of information that you require either for business > management and/or reporting purposes. > > 1. Menu->Business->Customer Overview should give you a liost of all > customers which can be sorted by any of the column including the customer > name. ( it is set as a company name, but you would use th customers name). > > 2. My understanding of the business account structure is that Accounts > Receivable and Accounts Payable only have a single account for each > currency > you use and cannot have sub-accounts. To meet your requirment, you would > likely have to raise two invoices for each transaction with a customer, one > for their personal billing and a second for billing their insurance. This > would probably require you to have two customer listing associated with > each > physical customer name, e.g. > Davy Jones personal information > Davy Jones Insurance information (you could use the insurance company > details as the billing address in this case). > It will be fairly difficult to get rate information to come up > automatically > in GnuCash. > > To use GnuCash as it is intended you shouldn't have to have any detailed > experience as a developer. It is useful to have some computing skills if > you > wish to customize it more to your specific needs. Apart from the initial > account heirarchy setup this would mainly involve customizing reports to > meet your needs. This can involve programming in Scheme ( A LISP language > implementation) and using CSS stylesheets to style the reports. > > Using the database backends will require some expertise in database > management, particularly for making backups replicating databases and > fixing > things when there are problems with a database. Sqlite3 is the easiest > option for users with limited database experience. GnuCash is not a full > database product in that it doesn't allow simultaneous access by multiple > users which is one major reason people generally want database > applications. > > GnuCash automatically produces backupsin the directory in which you store > the books, i.e. on the computer you have GnuCash running on. If that > computer fails, you have a serious problem. In addition you would want to > backup to either another computer, a Network storage device and/or > preferrably to an offsite location as well. If your computer has an > adequate backup system in place it may already cover these needs. > > David Cousens > Gnuca > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > __
[GNC] Editing, moving customer lists, possible child lists
Hello, As a solo psychotherapist, wondering relation between "Customers" and "Accounts" (in QB, customers *are* accounts). Each client I see has their own billing account, and (mostly) their insurance-related account. Aging is different: insurers avoid payments frequently until dunned repeatedly. Some issues with "Customer" listings: 1: Cannot move order of customers, as you would in Excel, maintaining alphabetical or numeric sequence. 2: wondering if a general listing can be established as in "Accounts" with Placeholder (e.g. Doe, John) and then Personal billing, Insurance billing and perhaps a place for Notes. I suppose I'm asking for a Clinical Records template -- can easily imaging my own, but hard to move or expand actual listings. One cannot group insurance co's as customers; e.g., rates are different for different plans. Finally, being new to Gnucash: I'm on this list, and don't understand much of what comes through (e.g. database aspects -- SQL choices, etc.). Are most Gnucash users also developers/coders? How code-database literate must a non-developer (e.g. a psychotherapist) become? Thanks, Jonathan Ames, PhD Clinical Psychologist 415 N. Tioga Street Ithaca NY 14850 607-319-5118 - Office 607-227-4792 - Cell jnthn.a...@gmail.com www.whatnowconnect.com ___ 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.
Getting started
I have asked these questions previously, but haven’t understood the answers. I have basically no experience with non-commercial software, and/or may be otherwise unworthy to use Gnucash. - I want to use Gnucash for both personal and business purposes. I am typing now on Mac/Sierra; I am wondering if I can access the same Gnucash accounts from my Windows 10 computer at my office, assuming program is placed in cloud (e.g., iCloud, Google Drive). Not simultaneously, though perhaps several times/day from each. To date, the windows computer comes back with 'file not found’, though I’ve installed on both. - I started setting up on the Mac — and generated a huge number of log files; disposal of which seems to require IT savvy beyond what is needed for Quicken, YNAB, et al. (despite the ease of use assurances). It appears the commercial programs either don’t generate them, or hide them in a log folder. They are covering my (Mac) desktop, and/or spreading like wildfire in ‘All My Files’. Is this the price one pays for free software — i.e., having to constantly clean up? Also, are these files important to save, or can they be deleted? Samples below. Gnucash 170715.gnucash.20180310190300.log Description: Binary data Whatnow Connect 180207.gnucash.20180211145646.log Description: Binary data Gnucash 170715.gnucash.20180318114241.log Description: Binary data Gnucash 170715.gnucash.20180318113929.log Description: Binary data Gnucash 170715.gnucash.20180318113818.log Description: Binary data Gnucash 170715.gnucash.20180317232102.log Description: Binary data These were generated by repeated attempts to work with Gnucash. The learning curve seems to be: 1. Data is organized information. 2. Data can be letters or numbers. 3. To propagate the bilateral asymmetry along the sequence, one simply factor-analyzes the cosign of the tertiary radicals appearing within the Fibonacci Sequence generated by the Grunt Imperative Command (GIC) - get my point? Any help appreciated — again. Again, 1. Non-simultaneous access by several computers/OS with the application placed in cloud’ 2. Understanding & Dealing with excess files generated by simple operations. Many thanks.___ 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.
Installation
I am a 71 yo solo psychologist, not particularly patient, unable to install Gnucash: every time I save, another icon appears on desktop; accounts, files I create disappear (“not found”) despite being saved. Wondering if this program requires programming skills to set up: other non-programmers seem it use it. Idea was to link office Windows 10 and home Mac (Sierra) systems through iCloud, replacing Windows-only Quickbooks and Mac Quicken. Is Gnucash basically for the IT-savvy, i.e. getting stable version established on systems so they work like standard software? Also, can Windows and Mac versions maintain same data sets? Will guidebook help, of is it that if you’re having my sort of issues you’re too stupid? Many thanks, Jonathan Ames, Ph.D. 415 N. Tioga Street #205 Ithaca NY 14850 Office: 607-319-5118 Cell: 607-227-4792 jnthn.a...@gmail.com www.whatnowconnect.com ___ 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.