RE: beginning balance of income and expense accounts

2018-03-26 Thread DaveC49
Lori, The Opening Balances account is an account of type equity. *It is always the offset account for the opening balances of all other accounts.* Your procedure for starting to use Gnucash from the 30/9 is fine. The entry for the opening balance for your income and expense accounts at 30/9

Re: beginning balance of income and expense accounts

2018-03-26 Thread Eric Siegerman
On Sun, Mar 25, 2018 at 09:34:58AM -0400, Mike or Penny Novack wrote: > [...] it is usual to start a set of books JUST from the balance sheet > with income and expense zero. This is what I was going to suggest -- very tentatively and with many caveats that I'm not an accountant. Since Mike (I

Re: Dealing with a bookkeeper and GNU

2018-03-26 Thread DaveC49
Martin Have you tried https://gnucashtoqif.us/ . It can apparently export to QIF and IIF formats. Haven't used it or Quickbooks so don't know how effective it is or how well it is maintained but it was updated moderately recently (2016-01-17) from a 2012 original.

Re: Gnucash and 529 plans

2018-03-26 Thread Eric Siegerman
Caveat: I'm not an accountant. On Sat, Mar 24, 2018 at 07:21:31PM -0700, Steve Kelem wrote: > How do I keep track of whether I've requested enough > disbursements? Presumably you have a GNC account for the 529 plan already, reflecting its balance, earnings, etc. Here's an approach that, while

Re: How to show the accounts in alphabetic sequence on the eguile

2018-03-26 Thread Derek Atkins
Hi, Anita Graves writes: > Dear Gnucash folks, > [snip] > But in the eguile report they are listed out of alphabetical order: > > earmarked International Fund > earmarket National Fund > debit card > earmarked Temples Fund > etc. > > Is there any way to fix this or sort

Re: database problem with invoices to more than one customer

2018-03-26 Thread Vario816
Thanks to you all for your input and guidance. Mike got the right point here! I somewhat forgot in the beginning to create a job first and then associate it with every single customer (in my case all of them were buying spare parts from me). It took some time, but gettin' there. I have to

Re: Amend a Typo in Description of Bill

2018-03-26 Thread keithwjones
More information: https://wiki.gnucash.org/wiki/Business_Features_Issues#Unposting_and_reposting_a_paid_invoice_loses_its_payment - GnuCash 2.6.19 - Windows 10 -- Sent from:

Re: Amend a Typo in Description of Bill

2018-03-26 Thread keithwjones
Adrien Monteleone wrote > If both the bill/invoice and the pre-payment are in the list, and both are > for the same full, original amount, simply select both. Make sure the date > is the same as the original payment date, the amount should be zero > (because they cancel each other out) and select

Re: Amend a Typo in Description of Bill

2018-03-26 Thread Adrien Monteleone
If the bill is paid, it won’t show up in the reminder box. You also don’t need to pay from the reminder box. That is just a convenience. Do a search for the bill as I noted, does it show as paid? (is the Paid? column checkbox checked or not?) Open a process-payment window and pull up the

Re: GnuCash 2.7.8 Released

2018-03-26 Thread Stan Brown
Hi, David. I'm assuming I can install the new release in a different folder. My question was whether the install would mess up anything less obvious. The answer seems to be yes, but in preferences and data files rather than in program files.. So I guess I'll have to create a virtual machine to

Re: Dealing with a bookkeeper and GNU

2018-03-26 Thread Stan Brown
Martijn, please don't quote stuff that's not related to your query. Especially please don't quote a whole digest. On Mon, Mar 26, 2018, at 11:53 AM, Martijn Heuts wrote: > Hello, I am in a very fustrating situation > I used GNU cash in 2017 and my bookkeeper states she can't use anything of >

Re: Amend a Typo in Description of Bill

2018-03-26 Thread keithwjones
keithwjones wrote > Perhaps I should have ignored the Bill Reminder. I've tried again unpost and repost now everything appears to match and is ok. But I have a bill reminder coming up. When i touch this I get the problem. Keith - GnuCash 2.6.19 - Windows 10 -- Sent from:

Re: Amend a Typo in Description of Bill

2018-03-26 Thread keithwjones
Adrien Monteleone wrote > I guess I should have added, I’ve unposted and reposted invoices more > times than I can count and all without any major issue. > > When you unposted, made the edit and then reposted, what was the result to > make you think something wasn’t correct. Unpost and repost

Dealing with a bookkeeper and GNU

2018-03-26 Thread Martijn Heuts
Hello, I am in a very fustrating situation I used GNU cash in 2017 and my bookkeeper states she can't use anything of GNU. So the first question would be, is it correct that even I have good reports from GNU, she couldn't use any of it to file my taxes? -she uses QuickBooks-. It's just that I

Re: Amend a Typo in Description of Bill

2018-03-26 Thread Adrien Monteleone
I guess I should have added, I’ve unposted and reposted invoices more times than I can count and all without any major issue. When you unposted, made the edit and then reposted, what was the result to make you think something wasn’t correct? Regards, Adrien > On Mar 26, 2018, at 7:20 AM, Maf.

Re: finance::quote does not produce results

2018-03-26 Thread John Ralls
> On Mar 25, 2018, at 4:54 AM, Henrik tom Wörden wrote: > > Hi, > > I had gnucash working with finance quote, but for quite some time now it > does not work anymore. I tried to figure out what the problem is, but I > could not find it so far. > > In the following I will

Re: Amend a Typo in Description of Bill

2018-03-26 Thread Maf. King
On Monday, 26 March 2018 12:13:25 BST keithwjones wrote: > Adrien Monteleone wrote > > > Unpost the bill, edit it, then repost. Gnucash ’should’ manage to re-apply > > the correct payment automatically. If not, you can assign it manually > > using the context/right-click menu. > > I backed the

Re: Budgets: showing total-to-date in budget period, and previous month totals only

2018-03-26 Thread Phil Longstaff
I have attached a report which does this. I have attached ytd-budget.scm. I have this file in c:\Users\phill\.gnucash\reports. I then add this line to c:\Users\phill\.gnucash\config.user: (load "c:\\Users\\phill\\.gnucash\\reports\\ytd-budget.scm") This gives me a new "YTD budget" with 3

Re: Fwd: What is the blue line all about?

2018-03-26 Thread Robert Heller
At Sun, 25 Mar 2018 17:52:43 +0300 Anita Graves wrote: > > Folks, I understand myself now what the blue line is for. I entered the > transaction today 25 March 2018 and the actual transaction date shown on my > bank statement is tomorrow 26 March 2018. Since we have not

Re: Amend a Typo in Description of Bill

2018-03-26 Thread keithwjones
Adrien Monteleone wrote > Unpost the bill, edit it, then repost. Gnucash ’should’ manage to re-apply > the correct payment automatically. If not, you can assign it manually > using the context/right-click menu. I backed the file up using Save As then tried. I thought that GnuCash was not happy

Re: What is the blue line all about?

2018-03-26 Thread Dave H
Nothing to do with fiscal year it just marks the difference between today and future transactions you may have entered. Cheers Dave H. On 26 March 2018 at 00:43, Anita Graves wrote: > Today I entered a transaction that is clearly within the dates set for the > start of our

Re: How to show the accounts in alphabetic sequence on the eguile

2018-03-26 Thread Maf. King
On Sunday, 25 March 2018 17:36:42 BST Anita Graves wrote: > Dear Gnucash folks, > > I would very much appreciate help to know why the eguile report does not > list my sub-accounts in alphabetical order under each parent account. > > For example, I have the checking account with sub-accounts > >

Re: Fwd: What is the blue line all about?

2018-03-26 Thread Maf. King
On Sunday, 25 March 2018 15:52:43 BST Anita Graves wrote: > Folks, I understand myself now what the blue line is for. I entered the > transaction today 25 March 2018 and the actual transaction date shown on my > bank statement is tomorrow 26 March 2018. Since we have not yet reached > the date

How to show the accounts in alphabetic sequence on the eguile

2018-03-26 Thread Anita Graves
Dear Gnucash folks, I would very much appreciate help to know why the eguile report does not list my sub-accounts in alphabetical order under each parent account. For example, I have the checking account with sub-accounts debit card earmarked International Fund earmarked National Fund

Fwd: What is the blue line all about?

2018-03-26 Thread Anita Graves
Today I entered a transaction that is clearly within the dates set for the start of our fiscal year and the end of our fiscal year. These dates are: Start: 28.03.2017 and End: 01.04.2018 However, a blue line is drawn across the checking account above my entry of 26.03.2018 and below an

Estimating budget not working

2018-03-26 Thread Peter Barnshaw
Hi, I am a long-time user of GnuCash and have a question regarding budgeting. I am on GnuCash 2.6.17. When I try estimate the budget, it comes up with 0 as the budget number despite there being over 18 months of data in my accounts. Why is this the case and can I get the estimate to work rather

finance::quote does not produce results

2018-03-26 Thread Henrik tom Wörden
Hi, I had gnucash working with finance quote, but for quite some time now it does not work anymore. I tried to figure out what the problem is, but I could not find it so far. In the following I will show you the output that some commands produce. >> gnc-fq-check ("1.47" "adig" "aex" "aiahk"