Re: [GNC] Another "multi-account" logical issue - any advice on how to register this?

Hi Flavio, > I will think about whether I want to consider the shipping expense as part > of the value of the goods I bought or not. I understand the difference and > keeping shipping costs separated from the goods value looks correct to me. > However, I always considered shipping costs as part of

Re: [GNC] Cash Account

Hi R, >> >> Isn't that just a bit like stating that "your brother is a person, and >> >> your >> >> wife is a person, so what's the difference? They are all persons?" I would >> >> suggest that there is a difference . >> Yes. Exactly. What is it? -- not your biology ridicule, but the original >

Re: [GNC] Cash Account

Hi Stephen and R, >> Isn't that just a bit like stating that "your brother is a person, and your >> wife is a person, so what's the difference? They are all persons?" I would >> suggest that there is a difference . Yes. Exactly. What is it? -- not your biology ridicule, but the original question

[GNC] Cash Account

Hi Folks, These are GnuCash questions; not accounting questions: * How do "Cash", "Bank" and "Asset" accounts different from each other? They are all assets ... * How do "Liability" and "Credit Card" accounts different from each other? They are all liabilities ... Are these disti

Re: [GNC] Another "multi-account" logical issue - any advice on how to register this?

Hi Bruce, > I'm going to have to read that publication. I am selling household items on > eBay and think I would be considered a hobbiest. Sales will be less than 4k > this year - and only if I were to sell a lot in 4th quarter. Can anyone > recommend a VERY introductory guide to hobby and small b

Re: [GNC] Another "multi-account" logical issue - any advice on how to register this?

Hi Michael, >> I concur in part. In a "hobby", expenses are no longer deductible to the >> extent >> of income, as you said, > > I did not say that. I said expenses not deductible beyond the extent of > income (a hobby can generate a taxable profit but not a deducible loss). Wow! I constructed

Re: [GNC] Another "multi-account" logical issue - any advice on how to register this?

Hi Michael, A point of clarification: > Here in the US if your hobby does produce an income, that IS taxable, > but because a hobby, expenses count only toward reducing that income. In > other words, losses from the hobby cannot be used to offset other > income. For this reason, the tax folks wil

Re: [GNC] Another "multi-account" logical issue - any advice on how to register this?

Hi David, If I bought a guitar for $500 and then spent $300 to have it shipped to me, I would most definitely want that recorded as an $800 guitar, so I would not mistakenly sell it to somebody who offered me $700 because it looked like a $200 profit. The book value of an asset is

Re: [GNC] Another "multi-account" logical issue - any advice on how to register this?

Hi Stan, > I would absolutely record shipping as an expense, not an asset. The > asset has value after you receive it; the shipping is "used up" the > moment the package arrives. Only things that still have value should be > listed in Assets. I respectfully disagree: The Financial Accounting Sta

Re: [GNC] Entering my real estate and mortgage?

Hi Flavio, Your bank account "Opening Balance" is as of the beginning of this year, which includes the real estate purchase transactions from before that date. If you want to include those transactions explicitly, then you need to change your opening balance to remove their effect. Alternative

Re: [GNC] Backup Solution - Linux Desktop to Synology NAS

Hi Fred, >> I believe that this can be changed if you perform the magical and possibly >> mythical NTFS configuration setting that preserves case sensitivity on >> Windows systems ... > > Just to note that it's not mythical. It's a per-directory setting (which > you can only change on an empty -

Re: [GNC] Backup Solution - Linux Desktop to Synology NAS

Hi Folks, > I've been using rsnapshot for years, now, to do nightly, weekly, and > monthly backups. I concur. I will add that rsnapshot can also backup databases, but it needs a short script to do it. I'm willing to offer copies of my scripts, with explanations, if anybody is interested. I als

Re: [GNC] How to treat a sale which involves more accounts?

Hi Folks, Pardon the interruption; I'm breaking into the middle of this conversation, so please forgive me if I misunderstand or repeat something that has already been discussed. I believe the discussion is recording the acquisition of musical instruments and the occasional sale and how to acc

Re: [GNC] "Help"

Hi Folks, On my Fedora system I installed the gnucash-docs package: "yum install gnucash-docs", and that did exactly what you'd expect. When I tried to read any of them, I got nothing. The reason is my system was configured to use the "KDE Help Center" application, which didn't understand DocB

[GNC] Importing Accounts

Hi Folks, I am importing accounts. The third step of the import dialog shows a row with column headers. Does my import CSV file have to use that *order*, or simply use those *names*? If "order" is discretionary, can I create a column mapping with the first row? Will the "Import Map Editor" d

Re: [GNC] "Help"

Hi Jim, > What exactly did you install, and how? Did you install a flatpack > package named "gnucash-docs"? Something via apt-get? MacPorts port > "gnucash-docs" on macOS? One of the downloadable documentation files > from ? I am running Fedora. I tried the naive a

Re: [GNC] Importing Data

Hi David, > The CSV importer can also work with tab separated data. There is a > setup screen in which you can set the separator so there is no need to > change it. Yes. There was an option to change the separator, but "tab" was not one of the choices. See the dialog below. > The confusion may

Re: [GNC] "Help"

Hi David, > I usually find it easier to use the links to the docs on the GnuCash > website and view them in a browser. Possibly, but if this fairly basic feature is misconfigured and not working, what else have I misconfigured? Thanks for the help -- Chris. V:916.799.9461 F:916.974.0428

Re: [GNC] Importing Data

Hi Murugan, > Please refer the following link for the steps to import transactions > [ https://lists.gnucash.org/docs/C/gnucash-manual/trans-import.html | > https://lists.gnucash.org/docs/C/gnucash-manual/trans-import.html ] As I have said, I'm importing "Accounts", not "Transactions" . These ar

Re: [GNC] Importing Data

Hi Folks, > There are couple of steps and queries > 1. > Create the account structure in GNC. you can import your existing structure if > you have a file for the same I was very much hoping that "File ==> Import ==> Accounts from CSV" would do that. > On the column mapping it is straight

[GNC] "Help"

Hi Folks, I have installed "gnucash-docs", but there seems to be no benefit. Before I installed "gnucash-doc", "man gnucash" gave me a short, one page set of instructions and this did not change. I find I have /usr/share/doc/gnucash-docs/ but there are four files there and no manual pages. Wh

[GNC] Importing Data

Hi Folks, QuickBooks does not give up its data graciously, but it will export many things as an IIF -- "Intuit Interchange File", which is almost like a "CSV", except with "tab" instead of "comma". I can replace the "tab" with ";" and I'm good to go. Almost. The first line is a header to ident

[GNC] Inactive/Hidden accounts

Hi Folks, Can I set an account inactive or hidden? As I flee QuickBooks I have a number of accounts that I no longer use and have hidden but I dare not delete them because it will require an adjusting entry somewhere to preserve "assets + liability + equity = zero" Thanks for the

Re: [GNC] Multiple accounts

Hi Robert, >> It looks like I can only see one account at a time. I can't find a way to >> open >> several for cross-reference and comparison. Am I missing something? > The accounts should be as tabs. ... "Why, Yes, Chris. You're missing something." Thanks for the help, -- Chris. V:916.799

[GNC] Multiple accounts

Hi Folks, It looks like I can only see one account at a time. I can't find a way to open several for cross-reference and comparison. Am I missing something? Thanks for the help, -- Chris. V:916.799.9461 F:916.974.0428 A: Because we read from top to bottom, left to right. Q: > Why sho

[GNC] TXF

Hi Folks, Does GnuCash export data in TXF format for inclusion in tax preparation software? This would require that I could label accounts according to their IRS form and form line number. Thanks for the help, -- Chris. V:916.799.9461 F:916.974.0428 A: Because we read from top to bottom

Re: [GNC] Database storage

Hi Mark, > I have ~some~ knowledge. > In SQL, these are the 'tables' used for storage; >> sqlite> .tables >> accounts employees orders taxtables >> billterms entries prices transactions >> books gnclock recurrences vendors >> budget_amounts gnucashew_vars schedxactions versions >> budgets invoic

Re: [GNC] Database storage

Hi Robert, > One thing that all of the *SQL backends do provide over the flat XML file > storage: accessing the data (*read-only!*) between runs of GnuCash is easier. > Instead of either trying to parse the XML or using Python bindings to the > GnuCash API, one can write code using SQL (in any la

Re: [GNC] Database storage

Hi Jim, > Beware of confusion: the word "transaction" is already used on this list > to mean an "accounting record of an exchange of value". But I suspect > that here you use the word "transaction" to mean a "controlled and > reliable change to data stored in a database". Yes. They are similar. B

Re: [GNC] Database storage

Hi Roberts, > I found the best of both worlds is to use SQLite backend - because it is > fastest and most portable - you just need to copy the file. It allows me to > run quite complex reports from R using standard SQL approach. Even more - I > made some bash scripts with SQL queries utilizing re

Re: [GNC] Database storage

Hi Liz, > Looking at my 2 biggest data files with data from about 1990 for one > and 1995 for the other > 2.2 MiB (2351153 bytes) > 1.5 MiB (1537242 bytes) > and I don't notice any delays on using these files. How many transactions do you suppose are saved? My personal case would be ten or fift

Re: [GNC] Database storage

Hi David, > I have over 14 years of personal data and some business data in one > file and no performance issues. For my own purposes, I will be incurring ten or fifteen transactions per month, however the other use case might be two hundred transactions a month. That would accumulate five thou

Re: [GNC] Database storage

> It should be noted: GnuCash does *not* do database queries as it processes > transactions. Well, that's disappointing ... and definitive. If this content is stored as flat XML, then I would expect it not to scale very well. When does it start having performance problems? Thanks for the help,

[GNC] Database storage

Hi Folks, The FAQ talks about PostgreSQL storage and how it was tired and discontinued, but then tried again. This was around version 2 - 3. We are now at version 5.8. Is there support for database storage? I see reference to sqlite3, PostgreSQL, and MySQL. Sqlite3 is obviously supported, sin

[GNC] AQBanking

Hi Folks, There are at least two ways for AQBanking to synchronize with the bank, but I'm most interested in OFX "Direct Connect" and "Web Connect" "Direct Connect" is supported by QuickBooks and I have been using it for many years. It is a bi-directional update, meaning, in addition to recei