Re: [GNC] Reporting Tools

2019-04-30 Thread Adrien Monteleone
Unless you’re up for learning SQL, there is an easier path if all you want are pretty reports. You can copy/paste reports to a spreadsheet and manipulate from there. You can get part of the way to a ‘dashboard’ with the multi-column report. Look into it. Otherwise, probably an intermediate

[GNC] Reporting Tools

2019-04-30 Thread Sachin Danave
Hi All, I am not a programmer and have been using MS Money for years. While I love the Gnucash features, I miss the MS Money colorful reports (and yes a beautiful dashboard). I came across a post (I think it was Reddit) that suggests that you can save Gnucash file to a MySQL database and then

Re: [GNC] Handling Prepayments

2019-04-30 Thread Adrien Monteleone
I forgot to mention, it is okay to use the Process Payment for pre-payments, but you’ll still need to link that to the posted invoice to clear it. Simply use Process Payment again after posting and select both the pre-payment and the invoice. GnuCash will use up the portion it needs to cover

Re: [GNC] Handling Prepayments

2019-04-30 Thread Adrien Monteleone
Be certain not to manually enter pre-payments into AP. Ideally, create a Current Asset account called something like ‘Pre-Paid Expenses’. (and make subs for each such service if you have more than one) Enter the payments between your cash/checking/card account and this pre-paid expense

Re: [GNC] Handling Prepayments

2019-04-30 Thread David Cousens
David The section headed "I entered a payment directly instead of using Process Payment" in the wiki page I referenced will give you a method for associating a payment to a bill. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: [GNC] Check Printing Question

2019-04-30 Thread David Reiser via gnucash-user
> On Apr 30, 2019, at 8:11 PM, Jay Ridgley wrote: > > Good evening, > > I use Quicken Wallet Style checks. Is there a way to include a line of text > between the amount and the signature line? I need is to place the text "Void > after ninety days" on every check written. I don't need to

Re: [GNC] Please respond to this request for help!

2019-04-30 Thread David Cousens
David, The inability to create the backup file tends to suggest that you may have permission issues to the location the datafile is stored in. The .LCK file is not an issue of itself. You can open the folder and delete the .LCK file manually. This is usually done automatically when you select

Re: [GNC] UK VAT and "Making Tax Digital"

2019-04-30 Thread Christopher Lam
Oops realised that recording the capital purchase as expense then immediately create a kludge txn from expense to capital-asset won't work: it would be classed as a 'refund'. I have no other workaround. Just wondering what exactly are the parameters for your reports? On Tue, 30 Apr 2019 at

[GNC] Check Printing Question

2019-04-30 Thread Jay Ridgley
Good evening, I use Quicken Wallet Style checks. Is there a way to include a line of text between the amount and the signature line? I need is to place the text "Void after ninety days" on every check written. I don't need to order more checks since the account will be closed in July.

Re: [GNC] Handling Prepayments

2019-04-30 Thread David Cousens
David, If the payments is made before the bill is posted it is likely that the payment has not become associated with the bill so that GNuCash can recognize that it has been paid. The section on unposting invoices(bills) in the following wiki page may help. You can perhaps use the procedure

Re: [GNC] Finance::Quotes stopped working for me

2019-04-30 Thread Bruno Acklin
Thanks David, I am a retired Physicist - so likely even further from solving this ;-( My use is similar, trying to update quotes weekly - for now forcedly connecting to my neighbors network.. Gnucash is phantastic SW and well maintained and supported (THANKS to John and others !!!), even if so

[GNC] Handling Prepayments

2019-04-30 Thread David Burleigh
I have a vendor (a VOIP service provider) that requires prepayments for all services. So the way I have been doing this is to process a payment to that vendor, which gives me a credit balance with them. Then, at the end of the month, I post a bill from that service provider for the total cost of

Re: [GNC] Please respond to this request for help!

2019-04-30 Thread Colin Law
I think the Unable to Create Backup File usually means that gnucash cannot write to the folder where the accounts file is stored. What is the path to that folder? You are not running out of disk space are you? Colin On Tue, 30 Apr 2019 at 21:08, David Jaggar wrote: > > Hello Maf King, > >

Re: [GNC] Please respond to this request for help!

2019-04-30 Thread Adrien Monteleone
Removing the .lck file in your data directory before trying to re-open might do the trick. Normally choosing ‘open anyway’ will do this for you, but perhaps it is getting stuck. Also, be sure you are not accidentally opening a backup file. (contains a date string in the filename) Be certain to

Re: [GNC] Please respond to this request for help!

2019-04-30 Thread Sachin Danave
Hi David Some basic points. Did you try downloading the program again and reinstalling it? Can you try installing on another computer? I have installed and am using Gnucash on Windows 10 without much hiccups. If you have a good RAM on your machine, you can install a VM of a Linux distro and try

Re: [GNC] Please respond to this request for help!

2019-04-30 Thread David Jaggar
Hello Maf King, Thanks for getting back to me. Since I sent my post to the list, I actually did find an earlier version and installed that with no problem. However, I then ended up with more problems! The GnuCash software program seems to work OK, but when I open my Gnucash data file, I have this

Re: [GNC] UK VAT and "Making Tax Digital"

2019-04-30 Thread Christian Kluge
Hello All, since the General GST/VAT report is discussed I just wanted to add that in the German VAT forms normal purchases aren’t filled in, only the deductible input VAT thereof. For acconting of it for tax purposes an asset account is used for cash based accounting. The only time purchases

Re: [GNC] representing shared accounts (personal)

2019-04-30 Thread Adrien Monteleone
I think the wiki in the ‘using GnuCash’ section has just this very example of sharing living expenses. I would create either an asset or liability account called “reimbursements”. (I have a sub account for each family member under this, but in your case, you’d only need one) It doesn’t matter

[GNC] representing shared accounts (personal)

2019-04-30 Thread Jeff Abrahamson
I have a bank account that I share 50/50 with my spouse.  We each pay in a certain amount each month, we use the money to pay utilities and things like that, occasionally to reimburse individual expenses. When I calculate my net worth, I include half of the value of that account. When I compute

Re: [GNC] Please respond to this request for help!

2019-04-30 Thread Maf. King
On Tuesday, 30 April 2019 19:02:07 BST David Jaggar wrote: > Hello All: > This is my second request; no response to my first one. > I cannot get Gnucash 3.5 to install on Windows 10. The dtaus.xml file is > suspended during the installation process and the whole installation hangs > up. Gnucash

Re: [GNC] CN?

2019-04-30 Thread Maf. King
On Tuesday, 30 April 2019 18:30:55 BST David Burleigh wrote: > On the "Due Bills Reminder" that pops up whenever I start GnuCash, what > does the column heading "CN?" mean? I believe that is "Credit Note" HTH, Maf. ___ gnucash-user mailing list

[GNC] Please respond to this request for help!

2019-04-30 Thread David Jaggar
Hello All: This is my second request; no response to my first one. I cannot get Gnucash 3.5 to install on Windows 10. The dtaus.xml file is suspended during the installation process and the whole installation hangs up. Gnucash 3.5 has removed the earlier version, so I can't go back to that. Right

[GNC] CN?

2019-04-30 Thread David Burleigh
On the "Due Bills Reminder" that pops up whenever I start GnuCash, what does the column heading "CN?" mean? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] UK VAT and "Making Tax Digital"

2019-04-30 Thread Christopher Lam
Hi Maf I agree your asset purchases are not going to be accounted for in the current iteration. This was not thought of during the design. A short workable answer is to record this asset purchase as an expense, and immediately create an expense->asset transaction which will satisfy your VAT

Re: [GNC] UK VAT and "Making Tax Digital"

2019-04-30 Thread Maf. King
Hi Christopher. Finally got round to completing my final quarter VAT return with the manual error-prone process of typing 7 numbers into boxes on the HMRC website. I'm now trying to make the Income & GST report give me sensible numbers that match my existing saved transaction reports and

Re: [GNC] I can't see above the current widow

2019-04-30 Thread Nigel Stapley
I, too, am using 3.5 on WIndows 10 with no apparent problems. Nigel On Tue, 30 Apr 2019 at 06:00, Tony Vanson wrote: > Hi Jonathan, > For the record, I'm using Gnucash V 3.5+(2019-03-30) and Windows 10 > V10.0.17134 Build 17134. > I have attempted to duplicate your problem, with no result. > I

Re: [GNC] Quicken import and duplicate records

2019-04-30 Thread David T. via gnucash-user
Priit, When I migrated over, I did it the same way as you describe here-- that is, I imported the entire file in one pass. I went back to quicken numerous times to clean up the exported data, but eventually got an import that was clean enough.  I offer that simply as a counter story to that of

Re: [GNC] Quicken import and duplicate records

2019-04-30 Thread David Cousens
Hi Priit I hope the import was successful. The hard part is now going thyrough and checking and correcting the errors that have crept in. David Carlson's comment re the handling of duplicate transactions is in aprt why small batch imports are generally recommended and processing one account at a

Re: [GNC] Quicken import and duplicate records

2019-04-30 Thread Priit Lilleleht
Good, thanks! I'll try a new import by account. Best Regards, Priit Kontakt David Carlson () kirjutas kuupäeval E, 29. aprill 2019 kell 23:57: > The wiki that David Cousins pointed you to does not mention the fact that > GnuCash can only find duplicates to transactions that already exist in the