Re: [GNC] Brand new and lost...

2018-11-18 Thread David Cousens
Johnathon 

for further information see:
https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html
https://www.gnucash.org/docs/v3/C/gnucash-help/chapter_busnss.html

David Cousens



-
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.


Re: [GNC] Brand new and lost...

2018-11-17 Thread David Cousens
Johnathon,

A database is not necessary to use GnuCash. GnuCash has an XML text file,
which may be compressed as an option, as its default storage. That file can
be located in a cloud storage. I keep my data files in a dropbox account so
that I can access them from several computers. Note however that this does
not support concurrent access from multiple computers, only single access
and that when one computer has the file open another computer can normally
only open the file in read-only mode. This can be overridden, but in normal
circumstances should not be, for the  fairly obvious reason that you can end
up not knowing which computer has the most up to date version of the file.
Closing the files in the wrong order is likely to lead to a loss of data. 

The database backend is an optional extra for GnuCash. The database backends
also currently don't support concurrent access from multiple computers
although this is a future longer term objective. You can choose one of
either SQLite3, PostGreSQL or MYSQL for the database backend. If you have
limited database experience using the XML backend is probably the best
choice.  Backing up and maintaining  databases requires some considerable
investment in developing the necessary skill set. You can always open the
XML file and write it to a database (if your version of GnuCash is compiled
with database support which is the default option) at a later time of your
choosing. A Google search will provide you with tutorials on database
support, setup etc.

Customers and Vendors in GnuCash are associated and accessed with the
business features which support Invoices/Bills/Credit Notes and the
associated Accounts Receivable and Accounts Payable accounts. Similar
restrictions apply to the use of the Tax features in GnuCash. If you want to
use them you will need to use the business features which can be a bit
cumbersome for dealing with cash sales subject to VAT/GST type taxes for
example as you have to create an Invoice/Bill even though the sale is not a
credit sale. The default accounts for Invoices and Bills are Accounts
Receivable and Accounts Payable respectively.

David Cousens



-
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.


[GNC] Brand new and lost...

2018-11-17 Thread Jonathan Ames
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.