Re: Accounting rules

[Adrien Monteleone]

Bert,

I’ll tackle the 2nd question first…

Just change the unused customer info to match that of another real customer you 
need to input. If you don’t have one you need to add yet, just name it ‘use 
next’ or something similar to alert you in the Customer Overview that you have 
a customer number that needs to be re-used before you create a completely new 
one. (note, the same process can be used for an errant entry in Vendors, Bills, 
and Invoices - you can’t delete them once you create them)

If the customer shows up in reports for some reason and you don’t want it to, 
just mark it as ‘inactive’. Usually though, a customer/vendor would only show 
up in reports if there are transactions associated with it. This ‘inactive’ 
feature is useful for customers/vendors who you have transaction history with, 
but who cease at some point to be current customers/vendors.

I’m not sure what you are asking in the first question. (probably a translation 
issue) What do you mean by ‘exploit?’ What’s the native word and language so I 
can decipher?

Is the attraction a property asset you own or a public venue that you use for 
events? or something else?

In either case, I wouldn’t create a customer to track anything about them. If 
this is a venue and you might have expenses paid to the venue, then you’d want 
the venue to be a Vendor.

But more likely, what you are describing is a situation that is handled by the 
‘Job’ feature in Gnucash. Unfortunately, this feature is very limited. (only 
one customer per job, only one vendor per job, and the two jobs - the customer 
job and vendor job are separate - that is, they aren’t the same job even if 
they have the same name) I also haven’t found any useful reporting with respect 
to the Jobs feature yet. What might serve you better is to use the Double Line 
view in your registers, and put a memo line for the transaction with the name 
of the attraction. Then you can run transaction reports that filter based on 
the attraction name.

If these attractions are regularly re-used as an income source, I would 
recommend creating separate income accounts for each attraction like so:

Income:Attractions:Attraction1
Income:Attractions:Attraction2

etc.

You may also need to create attraction sub-accounts for VAT:

Liabilities:VAT Payable:Attraction1
Liabilities:VAT Payable:Attraction2

But more likely, I’d use memo lines for this purpose instead and keep the VAT 
sub-accounts only for different jurisdictions you’d have to remit the VAT to. 
(unless the two are tied together)

If you regularly use a handful of attractions for revenue and you need to track 
their profit & loss separately, you could also separate the expense accounts by 
attraction. But this will be much more detailed and cumbersome. It may not be 
necessary for your needs.

You have two options:

1 - create sub-accounts of each expense account for each attraction like so:

Expenses:Supplies:Attraction1
Expenses:Supplies:Attraction2

2 - create separate ‘trees’ of expenses for each attraction like so:

Expenses:Attraction1:Supplies
Expenses:Attraction2:Supplies

The first method is probably easier to find in drop down list. The second is 
easier to customize reports for because of how accounts are selected in 
reports, but either will be appropriate. It’s really a personal preference.

If I completely misunderstood the first question, my apologies.

Finally, on the tracking of weather conditions and reservations, I think that 
would have to be handled outside of Gnucash. If these are not fixed properties 
and the location changes, then your sub-accounts above would have to be more 
generalized. You could still use memo lines though for location information 
that you can use to filter reports.

Regards,
Adrien

> On Feb 7, 2018, at 5:12 AM, Bert Heijne  wrote:
> 
> Hello everyone, 
> 
> As a new be to bookkeeping and Gnucash. I have some questions about 
> accounting. I already did some work with GC and read the manual.
> My company is a rental of party material and we have some attractions that we 
> rent and we exploit the attractions.
> 
> So we have invoice and bills, cash income from the rental (pay at delivery) 
> and Cash income from the attractions.
> 
> 1- Is it wise to give the attractions we exploit and have cash income from, 
> make them customer so we can track their income and get it to the wright Vat 
> box. Also track information about where and Weather conditions?
> Say reservation of the first 20 customer numbers for the attractions.
> 
> 2- Can I remove a customer from the customer list that i accidental made? (it 
> was suppose to be a vendor) or just change the input. customer isn't used yet 
> in any transaction. 
> 
> For now these questions, I have a lot so Thanks for the help 
> 
> Greeting Bert
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:

Annual High Balance Report?

[Keith Bellairs]

The US requires a report showing the highest balance in each foreign
(non-US) account during the previous year. FinCEN From 114 (FBAR)
(superseding TD F 90-22.1)

Is there a way to generate that info?

Keith
___
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: p2x modelling in gnc, help me think, please

[Adrien Monteleone]

Go to Preferences > General > Numbers. You can increase your decimal precision. 
Did that solve the small fraction issue?

As for modeling the investment, I’m not familiar with p2x. I’ll let someone 
else chime in who is.

On that note, I tried looking it up but didn’t come up with anything useful 
explaining it. Do you have a few info links I could pour over? Once I 
understand what it is, I might be able to help modeling it in Gnucash.

The only related thing I found was Peer-to-Peer lending but that didn’t involve 
negative interest rates as far as I could tell.

Regards,
Adrien

> On Feb 6, 2018, at 4:14 AM, Wm via gnucash-user  
> wrote:
> 
> Background: I am a p2x investor, I like it, it is fun and may do some good to 
> far away people and get me a better return on my money than more conventional 
> investments ... or I could lose it all.  Ho hum.
> 
> the gnc point is how best to model a p2x investment.
> 
> my p2x investments involve hundreds of fractional (or more than 2 decimal) 
> transactions a month,  gnc doesn't like dealing with 0.0001 EUR because gnc 
> takes the view than an EUR is meant to be used in chunks of 9.99 and it is 
> sort of right because there isn't a smaller unit of an EUR than a cent in 
> coins and paper.
> 
> Detail: I run the actual p2x transactions through ledger-cli and get that to 
> produce a journal per month (or whenever I'm interested) that I then enter 
> into gnc, this works well in accounting terms but fails because gnc doesn't 
> see the p2x asset as an investment for reporting purposes.
> 
> I thought the solution would be to make the asset account where the actual 
> bonds live a Mutual Fund with a security of its own equivalent to 1GBP or 
> 1EUR etc as appropriate but that didn't work because the interest doesn't get 
> recognised (possibly because I'm presenting the income as part of a tx with 8 
> splits to reflect the real world).
> 
> My understanding (which I now think might be broken) of how gnc works out 
> what is an investment or not then fell apart.
> 
> In summary:
> 
> my modelling of p2x in gnc isn't working out as I expected.
> 
> how are other people dealing with similar modern or unconventional 
> investments ?
> 
> is the concept of negative interest income really that unusual (it happens 
> all the time in real markets so why don't gnc reports know about it ?)
> 
> maybe I'm behaving stupidly and I just need a clue <-- let's hope it is this 
> :)
> 
> -- 
> Wm
> 
> ___
> 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.

___
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: Cash Flow View

[Adrien Monteleone]

I second Mike’s comments generally.

What would probably address most concerns in this regard is a default 
multi-column report that included the basics—Income Statement, Balance Sheet, 
and perhaps Income/Expense graphs. This would be auto-opened and up to date. If 
a seasoned/power user didn’t want it, they could just set a preference not to 
open it at start. Alternatively, it could be a menu entry or toolbar button for 
easy discovery.

Many questions lately seem to be asked a bit too quickly. But that’s not always 
the case. In my several years of experience as a Gnucash user, I find much of 
what I want to accomplish to be quite obtuse discovery-wise. Perhaps this is a 
consequence of the software being generalized for as many use cases as 
possible, but I’d suspect more because the reporting system has a very high 
hurdle for customization. (and the data is not yet easy to extract as with 
proper SQL, which is of course, in the works)

The recurring questions I see on this list aren’t issues with Gnucash not being 
able to provide what people are looking for, but that the ability takes some 
gymnastics, or at the least is not easily discoverable. Certainly, that is 
something I think can be improved even before the full SQL implementation is 
achieved.

With regards to the specific question, the answer is, “No, it doesn’t out of 
the box.”

There IS a ‘cash flow’ report, but this isn’t the same sort of report that I 
was expecting to see or what is described on most business accounting sites 
I’ve come across, or the one you are looking for Sean.

The built-in cash flow report shows you which accounts had money going in and 
out. It is for a time period, but it does not show you a change in position for 
a particular account over several time periods, say each month for a year. It 
also will not show you projected balances because it only shows actual recorded 
transactions. (you could fudge this with future dated transactions that you 
later delete or adjust but that could get messy)

You can however take the time to set up your recurring revenue and expenses as 
scheduled transactions. Then you can run a Future Scheduled Transactions 
Summary report. Again, this report is only for one period. (defined however you 
want) It is not for multiple periods. But you could create a custom 
multi-column report, and put consecutive periods in each column. Unfortunately, 
you don’t get consolidated account names, they will appear in each column. 
Alternatively, you could run this report for each period, copy and paste to a 
spreadsheet, then create your consolidated report/graph there.

The Income/Expense chart is the closest I’ve found to something like this, but 
it only shows historical data, not future projections. (It doesn’t allow for 
the inclusion of scheduled transactions)

 
Regards,
Adrien

> On Feb 6, 2018, at 10:56 AM, Sean Ford  wrote:
> 
> Hi,
> 
> Does GnuCash include a "cash flow" view, i.e., a simple line showing
> projected balance over time based on recurring expenses and income?
> 
> Thank you!
> ___
> 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.

___
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: Keeping track of sales and expenses for a specific craft show

[Mike or Penny Novack]

On 2/7/2018 12:22 PM, C M Reinehr wrote:

Ravenkwill,

I would suggest setting up your chart of accounts to record the 
revenues & expenses and then use the notes field of each entry to 
identify the specific craft show. Later, you can then use the notes 
field as a filter when running profit & loss reports, or specific views.


CMR 
 And I (putting on my "business analyst" hat for a moment) would ask a 
number of questions about the information desired to be answered BEFORE 
discussing "how to implement".


a) What is the volume of transactions for each fair? How likely the same 
fair to be attended for a number of years (before being able to decide 
whether THAT ONE with while)


b) To what extent want to be able to report the totals of certain 
expenses that can be fair related but also not. Thus taking just hotels 
for an example, might also use on vacations.


The point is, there can be multiple WAYS of doing these things, reports 
with fancy filters can extract information, BUT there are other 
considerations like clutter in main books, likelihood of data entry 
items < if you have under "hotels" a child for each event, can 
accidentally stick a transaction to the wrong one >   The which way 
easiest, which way less error prone, which way nothing special to do, 
which way less duplication of effort entering data, etc. choices cannot 
be intelligently made until these things have been considered. There are 
trade offs.


Michael D Novack

PS: Some examples might help. Thus, an organization of which I was 
treasurer was going to host the annual gathering for the organization. 
The event was going to have it's own bank account and for a period of 
two months there would be hundreds of transactions related to the event 
and then nothing ever again (or at least not for many years when the 
local might again host the national gathering). That was sort of a no 
brainer for choosing the "separate set of books" solution.  Why?
1) There would be very few transactions between the (local) 
organization's books and the event books.

2) No special reports (special filters) would  be needed.
3) Would be a great deal of "clutter" in the local's books << and yes 
you can hide that, but why have to hide >>
4) The national organization's treasurer would need access to the books 
(of the event)
BTW, take a close look at that one. Suppose what your org did (as a 
major activity) was put on events for other organizations. Do you not 
see that "separate books" would make it a LOT easier to show the 
treasurer's of these organizations JUST the data which belonged to them,.

___
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: Accounting rules

[Bert Heijne]

Adrien,

Q1 has been answered. was easy so have don that.

Q2 - I'm Dutch [Hollander] and you have it quite right.

Q1-  My story is that we own some attractions carousel's, a train and other 
smaller stands with food.
We Have 2 VAT categorized for us , the low one 6% and high 21%

Most of the time we operate the carousel (attractions) by ourself,  so we earn 
cash money so thats low VAT 6% going from city to city or village. Most of the 
city's we have to pay rent for the spot we are standing on.
For city's we regularly visit I would like to make a report of revenue for that 
city. but for now thats not a priority.

When we rent our carousel and ourselves for a day with free rides for the kits 
it is high VAT 21% and get payed in cash on delivery or afterwards but also by 
invoice (hopefully in advance by reservation)

Al the things we own and rent out is high VAT by a rent contract and so we can 
make invoices.

If we selling food only is 6% VAT but when we rent out a food stand with food 
it is High VAT. (with gnucash we can make a high and low specific VAT invoice 
but for now we only rent out with high VAT)

The expenses for maintenance of the attractions can go into another total 
expense account and make reports from the memo fields

I hope this explains to you how my business works.

Q 3 because we have much cash flow do we need a payment condition for cash 
payment invoices and also VAT rates for Cash?

Ps I can send you my Accounts overview, its in dutch but can translate it for u.

Bert.



Van: Bert Heijne
Verzonden: woensdag 7 februari 2018 12:12
Aan: gnucash-user@gnucash.org
Onderwerp: Accounting rules

Hello everyone,

As a new be to bookkeeping and Gnucash. I have some questions about accounting. 
I already did some work with GC and read the manual.
My company is a rental of party material and we have some attractions that we 
rent and we exploit the attractions.

So we have invoice and bills, cash income from the rental (pay at delivery) and 
Cash income from the attractions.

1- Is it wise to give the attractions we exploit and have cash income from, 
make them customer so we can track their income and get it to the wright Vat 
box. Also track information about where and Weather conditions?
Say reservation of the first 20 customer numbers for the attractions.

2- Can I remove a customer from the customer list that i accidental made? (it 
was suppose to be a vendor) or just change the input. customer isn't used yet 
in any transaction.

For now these questions, I have a lot so Thanks for the help

Greeting Bert



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

2.7.4 install

[Michael via gnucash-user]

Hello all, I haven't seen much about 2.7.4, so maybe this is not the 
place.  Anyway I was able to install on linux using cmake (first time 
for me).  Went reasonably well given all.  It worked! Used yahoo as json 
for quotes as the financial data file is set up that way.  Overall, 
seems to be a lag when bringing up a new view or resizing windows, etc 
and to be somewhat slower loading the XML datafile.  On trying SQLite 
says no back end, even though earlier versions worked on this machine.  
Seem to have lost my tax item selections.  Otherwise, on a quick look, 
seems quite good for a beta version.  Thanks for your efforts.  Mike


___
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: Creating and Posting an Invoice

[Cliff McDiarmid]

   Sent: Monday, February 05, 2018 at 11:55 PM
   From: "Adrien Monteleone" 
   To: "Gnucash Users" 
   Subject: Re: Creating and Posting an Invoice
   >That’s the same account.
   >Accounts Receivable is a Current Asset account. That is what the
   invoice posts to. (other than the chosen Income account)
   >In order to increase the balance, you post a debit to it.
   >If you want to increase an Asset or an Expense, you debit the account.
   >If you want to increase Income, Liabilities or Equity, you credit the
   respective account
   > On Feb 5, 2018, at 4:18 PM, Cliff McDiarmid
    wrote:
   >
   >
   >
   > Sent: Sunday, February 04, 2018 at 11:53 PM
   > From: "Maf. King" 
   > To: gnucash-user@gnucash.org
   > Cc: "Cliff McDiarmid" 
   > Subject: Re: Creating and Posting an Invoice
   > On Sunday, 4 February 2018 23:30:32 GMT Cliff McDiarmid wrote:
   >> Hi
   >>
   >> I've nearly got gnucash running as i want it but i need some advice
   > on
   >> posting an invoice which is proving confusing.
   >>
   >> I create an invoice where one has to select an Income account; in my
   >> case a current account. But when it gets to posting the invoice one
   >> has to select a 'Post to Account' where one has to create a 'A/c
   >> receivable'. I assume this because of the double accounting, but why
   >> can't I just select an Income account such as 'Wages' at this stage?
   >>
   >> OK, so GC's invoice subsystem uses a concept called "accrual
   > accounting". You
   >> write the invoice and expect to be paid at some point in the future.
   > (end of
   >> month, 30 days, that sort of thing)
   >> With that in mind, the income is generated when you create the
   > invoice, even
   >> though you don't physically have the cash yet.
   >> As you write out the line items on the invoice in GC, you select the
   > relevant
   >> income account (eg Income:Sales or Income:consulting etc.) When the
   > invoice
   >> is "posted" into the GC books, this has the effect of increasing
   your
   > income
   >> totals. (your bank account isn't income, it is an asset account)
   >> But where to post it to balance the double entry? As far as gnucash
   > knows,
   >> you probably don't have the money yet, (assuming you are running
   > accruals
   >> "properly"), so clearly the bank account is the wrong place. This is
   > the
   >> purpose of the special A/R account. It stores the "earned but not
   yet
   >> received" money - and it is the other half of double-entry.
   >> At some point in the future, when the money actually arrives (maybe
   in
   > your
   >> case that is 1 second later, not 1 month or so!) you "process
   > payment", which
   >> decreases the A/R and increases the bank account (income is
   untouched
   > at this
   >> stage. you already earned it!)
   > One more thing on this subject. Why, when posting the invoice does it
   > place the amount in the A/R account as you explained, BUT also in the
   > receivable account(current)as a DEBIT!

   Thanks got it now.   The mistake I was making was putting my current
   a/c as the income a/c.

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

mailing list

[Graham Jacks]

A few days ago I asked you a question about GnuCash, as I was wondering whether 
to start using it.   Since then I seem to have been put on your mailing list, 
and have been seeing a lot of  email messages about issues related to GnuCash 
which mean nothing to me.   

After studying GnuCash, I don’t think it would be the program/app/system that I 
need, so could I ask you to take me off the mailing list?  

I will delete the messages that have already arrived.

Best wishes, Graham Jacks  
___
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.

QBO and QFX files VS QIF and OFX files ?

[Fran_3 via gnucash-user]

 Our bank offers QBO and QFX files but I see gnuCash works with QIF and OFX 
files.
Are QBO and QFX files imprtable into gnuCash?
Thanks for any help
  
___
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: mailing list

[C M Reinehr]

Likewise, there is a link to instructions as to how to manage your 
subscription in the signature of every list email:



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.



On 02/07/2018 03:51 PM, Kurt Padilla wrote:

Graham,

Please check your inbox for instructions on how to unsubscribe. These
should have been automatically emailed to you when you signed up for the
mailing list.

Kurt

On Wed, Feb 7, 2018, 16:45 Graham Jacks  wrote:


A few days ago I asked you a question about GnuCash, as I was wondering
whether to start using it.   Since then I seem to have been put on your
mailing list, and have been seeing a lot of  email messages about issues
related to GnuCash which mean nothing to me.

After studying GnuCash, I don’t think it would be the program/app/system
that I need, so could I ask you to take me off the mailing list?

I will delete the messages that have already arrived.

Best wishes, Graham Jacks
___
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.





--
"The spirit of resistance to government is so valuable on certain occasions that I 
wish it to be always kept alive. It will often be exercised when wrong, but better so 
than not to be exercised at all." -- Thomas Jefferson


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

Online quotes fetching the wrong price

[Justin Smith]

Hi,

I use gnc to track my stock portfolio of mostly Australian ASX stocks.
After yahoo closed their quoting service I set up alphavantage as per the
instructions in the gnc FAQ (with key etc).

I've just noticed that the online quotes for *all* my ASX stocks are now in
USD, and that they are meaningless values too (i.e. not the ASX stock in
USD).

This is confirmed when testing using gnc-fq-dump. E.g.

ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB
Finance::Quote fields Gnucash uses:
symbol: NAB  <=== required
  date: 03/13/2017   <=== recommended
  currency: USD  <=== required
  last: 1.0800   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

The price of $1.08 USD is what gnc fetches today.

The correct quote for ASX.NAB is around $28.24 AUD (or around $22.18 USD).

A quick search didn't even find a NYSE or NASDAQ NAB so I have no idea
where F::Q is getting this quote from.

Also I don't know why the date returned by gnc-fq-dump is 3/13/2017. Very
odd.

How does gnc-fq-dump determine the stock type? (e.g. ASX or NYSE)

For all my ASX stocks, in the Security Editor, I have the following
settings:
* Type = ASX
* ISIN/CUSIP =  (is that a problem?)
* Get Online Quotes is ticked
* Type of Quote = Unknown/alphavantage

I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (yes, end of life).
And Finance::Quote 1.48 (installed from git).

Any clues?


Cheers,
Justin.
___
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: QBO and QFX files VS QIF and OFX files ?

[John Ralls]

Dunno what a QBO is, but QFX and OFX are the same thing. The import menu item 
in GnuCash is even called OFX/QFX.

Regards,
John Ralls


> On Feb 7, 2018, at 12:33 PM, Fran_3 via gnucash-user 
>  wrote:
> 
> Our bank offers QBO and QFX files but I see gnuCash works with QIF and OFX 
> files.
> Are QBO and QFX files imprtable into gnuCash?
> Thanks for any help
> 
> ___
> 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.

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

p2x modelling in gnc, help me think, please

[Wm via gnucash-user]

Background: I am a p2x investor, I like it, it is fun and may do some 
good to far away people and get me a better return on my money than more 
conventional investments ... or I could lose it all.  Ho hum.


the gnc point is how best to model a p2x investment.

my p2x investments involve hundreds of fractional (or more than 2 
decimal) transactions a month,  gnc doesn't like dealing with 0.0001 EUR 
because gnc takes the view than an EUR is meant to be used in chunks of 
9.99 and it is sort of right because there isn't a smaller unit of an 
EUR than a cent in coins and paper.


Detail: I run the actual p2x transactions through ledger-cli and get 
that to produce a journal per month (or whenever I'm interested) that I 
then enter into gnc, this works well in accounting terms but fails 
because gnc doesn't see the p2x asset as an investment for reporting 
purposes.


I thought the solution would be to make the asset account where the 
actual bonds live a Mutual Fund with a security of its own equivalent to 
1GBP or 1EUR etc as appropriate but that didn't work because the 
interest doesn't get recognised (possibly because I'm presenting the 
income as part of a tx with 8 splits to reflect the real world).


My understanding (which I now think might be broken) of how gnc works 
out what is an investment or not then fell apart.


In summary:

my modelling of p2x in gnc isn't working out as I expected.

how are other people dealing with similar modern or unconventional 
investments ?


is the concept of negative interest income really that unusual (it 
happens all the time in real markets so why don't gnc reports know about 
it ?)


maybe I'm behaving stupidly and I just need a clue <-- let's hope it is 
this :)


--
Wm

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

Cash Flow View

[Sean Ford]

Hi,

Does GnuCash include a "cash flow" view, i.e., a simple line showing
projected balance over time based on recurring expenses and income?

Thank you!
___
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: can't change preferences [SOLVED]

[Graham Menhennitt]

On 05/02/2018 22:54, Geert Janssens wrote:

Op zondag 4 februari 2018 09:48:49 CET schreef Graham Menhennitt:

Hi GnuCashers,

I'm running GnuCash 2.6.19 on FreeBSD 11-stable. Everything seems to
work correctly except that I can't change any preferences. I try to
click on the tick boxes/radio buttons etc. in the Edit Preferences
dialog, but nothing happens. It's as if everything is read-only.

I presume that the reason for this also causes that it doesn't remember
my most recent open files, and it always shows tips on startup even
though I unticked the "show tips" box.

Does anybody have any clues, please?


The gnucash preferences are stored in gsettings. This is a generic preferences
store that requires a platform dependent backend. On linux this backend is
dconf. I presume this is also what would be used on FreeBSD. Can you check if
dconf is installed (and used) ?


Thanks for replying, Geert.

I can run the dconf command. But I can't seem to get anything out of it:

    dconf list /
    dconf list /org.gnucash/
    dconf list /org/gnucash/

all print nothing.

I can see /usr/local/share/glib-2.0/schemas/ contains lots of files 
including 16 org.gnucash.* ones. I can also see the file 
gschemas.compiled in that directory and it has the same date/time as the 
gnucash files.


I built GnuCash from the FreeBSD port system using the guile2 option 
(after having used older versions of GnuCash and guile for many years). 
Maybe that's when I started having this problem. I can try switching 
back to guile1, or even going back to an older version of GnuCash.


Hang on, I'm going to try something...

... ok, back again and solved it!

It appears that my dconf settings were corrupt. I installed dconf-editor 
and, when I ran it and tried to edit something, it said:


    (dconf-editor:25665): dconf-WARNING **: failed to commit changes to 
dconf: 
GDBus.Error:org.gtk.GDBus.UnmappedGError.Quark._g_2dfile_2derror_2dquark.Code17: 
Cannot open dconf database: invalid gvdb header


So I renamed ~/.config/dconf to ~/.config/dconf_save and tried it again, 
and it worked. And now I can change the GnuCash preferences too! So, 
it's all working now.


Thanks again for your help,
    Graham
___
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.

Accounting rules

[Bert Heijne]

Hello everyone, 

As a new be to bookkeeping and Gnucash. I have some questions about accounting. 
I already did some work with GC and read the manual.
My company is a rental of party material and we have some attractions that we 
rent and we exploit the attractions.

So we have invoice and bills, cash income from the rental (pay at delivery) and 
Cash income from the attractions.

1- Is it wise to give the attractions we exploit and have cash income from, 
make them customer so we can track their income and get it to the wright Vat 
box. Also track information about where and Weather conditions?
Say reservation of the first 20 customer numbers for the attractions.

2- Can I remove a customer from the customer list that i accidental made? (it 
was suppose to be a vendor) or just change the input. customer isn't used yet 
in any transaction. 

For now these questions, I have a lot so Thanks for the help 

Greeting Bert



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

Keeping track of sales and expenses for a specific craft show

[ravenkwill]

My wife is an artist, and is beginning to do craft shows. I want to be able
to track the profitability for each show by collecting expenses and sales.
I've read through the manuals about jobs, but that doesn't seem to be quite
right. Do I need to create a separate sub-account for each fair? That seems
cumbersome.  

Examples of entries: show fees, hotel fees, food while traveling, and of
course the sales during the event.

I'd love ideas and suggestions about how to handle this.

Thanks!



--
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: Scheduled Transactions

[cicko]

Hi, Dennis,

I don't think that scheduled transactions can even be exported from Quicken
into .qif file. Therefore, it is almost certain that they won't be found in
GnuCash after import. This only depends on what you consider the scheduled
transactions to be. 
If you are using Bill and Income Reminders for the upcoming scheduled
transactions, these definitely won't be exported by Quicken and yes, you'll
have to manually recreate them. 
I currently have 140 records created with plenty still left to migrate.
Hence I will really appreciate any progress on the Scheduled Transactions
window. :) But, more likely in the short-term, I will have to find (read:
code) a way to enter transactions from the scheduled reminders outside
GnuCash.

Cheers



--
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: Instructions for GST India

[Amish]

On Wednesday 07 February 2018 05:52 PM, Deva - wrote:

Frank,

Read the wiki and spent better part of my day trying to generate a template, 
but I am sorry to say I give up.

The wiki assumes one is familiar with xml and how gnucash uses xml - neither of 
which I am comfortable with.


I have created XML file and created pull request too.
https://github.com/Gnucash/gnucash/pull/275


Having spent all day thinking about this, I am now wondering whether it would 
have been a futile effort even if I had succeeded in making a template.

Reason being - my use case for GST is only a subset of what Amish laid out. 
Even if we attempt to put Amish's comprehensive setup as a template, it cannot 
be used by all GST users in India. What we have posted is only one aspect of 
GST in India, mainly covering GSTR-3B and GSTR-1/2 components of the return. 
Then there are other aspects such as -

- composition dealers
- e-way bills (launched recently)
- export related services and such…
Yes but there are many more normal GST dealers than GST composition 
dealers. For composition dealers I guess there will be even less 
accounts. So they can use template and remove unwanted accounts.


E-way bill - not sure if that would be part of Gnucash anyway. User can 
put a note in Invoice stating e-way bill number


Export services - I have no idea about their returns but that should not 
stop us from creating normal templates which can become a starting point.


Thanks and regards,

Amish.
___
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: Keeping track of sales and expenses for a specific craft show

[C M Reinehr]

Ravenkwill,

I would suggest setting up your chart of accounts to record the revenues 
& expenses and then use the notes field of each entry to identify the 
specific craft show. Later, you can then use the notes field as a filter 
when running profit & loss reports, or specific views.


CMR


On 02/05/2018 06:59 PM, ravenkwill wrote:

My wife is an artist, and is beginning to do craft shows. I want to be able
to track the profitability for each show by collecting expenses and sales.
I've read through the manuals about jobs, but that doesn't seem to be quite
right. Do I need to create a separate sub-account for each fair? That seems
cumbersome.

Examples of entries: show fees, hotel fees, food while traveling, and of
course the sales during the event.

I'd love ideas and suggestions about how to handle this.

Thanks!



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


--
"A free people ought not only to be armed and disciplined, but they should have 
sufficient arms and ammunition to maintain a status of independence from any who might 
attempt to abuse them, which would include their own government." -- George 
Washington


___
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: Scheduled Transactions

[Colin Law]

On 7 February 2018 at 12:23, cicko  wrote:

> Hi, Dennis,
>
> I don't think that scheduled transactions can even be exported from Quicken
> into .qif file. Therefore, it is almost certain that they won't be found in
> GnuCash after import. This only depends on what you consider the scheduled
> transactions to be.
> If you are using Bill and Income Reminders for the upcoming scheduled
> transactions, these definitely won't be exported by Quicken and yes, you'll
> have to manually recreate them.
> I currently have 140 records created with plenty still left to migrate.
> Hence I will really appreciate any progress on the Scheduled Transactions
> window. :)


Are there features lacking that you want?

Colin



> But, more likely in the short-term, I will have to find (read:
> code) a way to enter transactions from the scheduled reminders outside
> GnuCash.
>
> Cheers
>
>
>
> --
> 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.
>
___
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: Scheduled Transactions

[Alen Siljak]

   Yep,

   It would be fantastic if I could pick which transaction to enter and
   ignore all others from the Since Last Run window. With
   not-so-strictly-dated transactions I have to set the due date to the
   latest when they usually occur, and then add a reminder ahead so that I
   can enter them if they happen earlier.
   This could happen either by setting all the (i.e. "To-Create")
   transactions to "Reminder" and then manually choosing one to actually
   enter.
   Also, I like to always double-check on created transactions so ability
   to set the "Check the created transactions" default would be great.
   Reviewing created transactions is also mandatory when the actual
   transaction happens earlier than scheduled because then I need to
   modify the date after entering into register.

   Whether this happens on Since Last Run window or the scheduled
   transactions editor (i.e. having an Enter and/or Skip buttons), does
   not matter much.

   I've already submitted something along those lines at BugZilla:

   https://bugzilla.gnome.org/show_bug.cgi?id=791857
   https://bugzilla.gnome.org/show_bug.cgi?id=792121
   https://bugzilla.gnome.org/show_bug.cgi?id=792241

   It's just that I'm not sure how much time the devs would dedicate to
   this, having more important priorities. However, some of these are
   really not that difficult so perhaps someone picks them up.

   Cheers!

   Sent: Wednesday, February 07, 2018 at 1:39 PM
   From: "Colin Law" 
   To: cicko 
   Cc: gnucash-user 
   Subject: Re: Scheduled Transactions


 Hence I will really appreciate any progress on the Scheduled
 Transactions
 window. :)


   Are there features lacking that you want?

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