Re: Installing GnuCash using GoDaddy MySQL Server

On 16 January 2018 at 06:34, Jim_S wrote: > I am trying to install gnuCash using a MySQL database hosted by GoDaddy. We > also use GoDaddy for our WordPress web page, so I already have the hosting > account. GnCash keeps giving me an error "The server at URL >

Re: Manually entering historic records

On Tue, 16 Jan 2018 15:03:04 +1000 Dave H wrote: > I use Dropbox however I maintain my gnucash data file on my local > drive rather than directly in Dropbox. I think from memory the lock > file hangs around in Dropbox so when you try to re-open your data > file the LCK file

Re: Filtered account report

Or just add the new transaction report to GnuCash. It’s an attachment here on the list from a few months ago. Sorry I don’t have the link to the thread directly. But I’m sure a Google search will turn it up. Regards, Adrien > On Jan 15, 2018, at 11:57 PM, Christopher Lam

Re: Year end issues

On Tue, 16 Jan 2018 07:08:23 +0100 Jeff Abrahamson wrote: > In France, even for small clubs like ours, we face a regulatory > requirement that the books be immutable after end of year.  This makes > sense in that if the tax authorities (even though we don't have to > file taxes) ask

Re: Validation of OFX TLS Certificates?

Hi Jeff, I do not think that aqbanking checks against the system certificates. But you should have to accept a certificate only once. BUT when called directly from Gnucash aqbanking this does not work. It only remembers the certificate when called from the the command line e.g. with

Installing GnuCash using GoDaddy MySQL Server

I am trying to install gnuCash using a MySQL database hosted by GoDaddy. We also use GoDaddy for our WordPress web page, so I already have the hosting account. GnCash keeps giving me an error "The server at URL mysql://gnuc...@gnucash.db.3879949.hostedresource.com/GnuCash experienced an error or

Re: Year end issues

In France, even for small clubs like ours, we face a regulatory requirement that the books be immutable after end of year.  This makes sense in that if the tax authorities (even though we don't have to file taxes) ask us a question and then find out that our books for some past year have changed,

Re: Installation on Windows 10

Did you install GnuCash using the same user account as you are using now?  Or with an Administrator account? If you installed GnuCash while logged in as an administrator or different user GnuCash may not have the correct permissions to access the directory in which the data file is located

Re: Filtered account report

The description for each split does have the specific loan to which it applies. I used the search to filter on all of those but the transaction report still pulls everything in. On 2018-01-15 21:14, Adrien Monteleone wrote: > Have you tagged each interest payment split with the loan name? You

Re: Filtered account report

Have you tagged each interest payment split with the loan name? You could use that as the filter, though I would think the memo field would suffice. Regards, Adrien > On Jan 15, 2018, at 10:29 PM, AC wrote: > > No, that didn't work. It still pulls the interest payments

Re: Invoices: multilingual & tax detail questions

Thanks Derek, On 2018-01-15 11:51 AM, Derek Atkins wrote: > Unfortunately the report translation is based on your system locale. Ah, of course! I can just run Gnucash from terminal after changing the locale environment variable whenever I want to print French invoices. Excellent! > >> Is there

Re: Manually entering historic records

I use Dropbox however I maintain my gnucash data file on my local drive rather than directly in Dropbox. I think from memory the lock file hangs around in Dropbox so when you try to re-open your data file the LCK file is still the and triggers the warning dialog. As others have said you can just

Re: Manually entering historic records

Trevor, Have you tried making a copy of the file on your local drive and working on it there. I have never worked with dropbox so I have no idea if it could confused by the way GnuCash makes backups, for example. David C On Mon, Jan 15, 2018 at 9:39 PM, Chris Smith wrote:

Re: Manually entering historic records

I’d choose “Open Anyway” as well, but you could also delete that LCK file. That’s the one causing the problem. (Note, it is supposed to be there if you have the file already open, but since you know for a fact you don’t, you can delete it. Normally, this file is deleted when you close the

Re: Filtered account report

Try the Transaction Report which has an Account Filter in the first tab. On 16 Jan 2018 11:54 AM, "AC" wrote: > I was looking at some of my loans and wanted to get an idea of how much > I paid in interest to each loan over their life. I've got one account > that collects

Filtered account report

I was looking at some of my loans and wanted to get an idea of how much I paid in interest to each loan over their life. I've got one account that collects the amount of loan interest every time I pay (as part of a split transaction) while the principal portion of the payment goes to the specific

Re: Installation on Windows 10

Try run in gnucash as administrator by right clicking on the icon and selecting "Run as administrator" What does that do? On Jan 15, 2018 9:13 PM, "David Carlson" wrote: > Can you save other documents such as spreadsheets to that folder? Is there > plenty of free

Re: Manually entering historic records

If you don't have it open elsewhere you can click "Open anyway" Depending on how it shutdown the lock file may be there. On Jan 15, 2018 9:31 PM, "Trevor Richards via gnucash-user" < gnucash-user@gnucash.org> wrote: I'm not making much progress... I see I got some replies to my manual entry

Validation of OFX TLS Certificates?

I haven't been able to find much on getting past AqBanking not verifying certificates for OFX connections. https://wiki.gnucash.org/wiki/De/Setting_up_OFXDirectConnect_in_GnuCash_2 says to "blindly" accept them, which seems risky in this day and age. I found a question around it asked on the

Re: Installation on Windows 10

Can you save other documents such as spreadsheets to that folder? Is there plenty of free space on your C: drive (like several GIG's)? is this machine owned by someone else such as your employer? David C On Mon, Jan 15, 2018 at 8:17 PM, Snarky Email wrote: > David, > > I

Re: Installation on Windows 10

David, I did create subfolder but the same error pops up. I definetly have full access to the folder and subfolder. Is there any special first time steps that I could be missing? Sent: Sunday, January 14, 2018 at 3:51 PM From: "David Carlson"

[MAINT] VM System upgrade tonight at 2100 EST (0200 UTC)

Hi, I need to upgrade the VM system so I'd like to take it down at 2100 US/EST (0200 UTC) tonight. I expect only ~1 hour (or less) of downtime. I'll make a quick announcement on IRC before I start. Please let me know if this is a problem. -derek -- Derek Atkins, SB '93 MIT EE, SM '95

Re: Year end issues

This is what I do, but I'm only dealing with household and personal accounts and smallish investment portfolios. Because the statement closing dates for the investment and personal bank and credit accounts don't correspond exactly with the beginning date of the new book, there's always some

Re: Year end issues

Let's discuss this (and possible options) First, you need to understand what "close the books" does do and what is does not do. It creates a transaction (or transactions) to zero out income and expense accounts to equity. It does NOT remove transactions and so will not make your file smaller.

Recording transactions

I’ve become very confused and am hoping someone can provide some basic help. I’m attempting to transition from Quicken to GnuCash. I will be starting from a set of accounts that I already have in Quicken, but I have no intention of importing data from Quicken. I’ll be obtaining balance

Re: Year end issues

On 1/15/2018 10:26 AM, Jack Whyte wrote: > Thanks Ken > > I wrote a reply before reading yours! > > The file is very large and unwieldy already - are there any limits on the > file size? One of the impacts is also that each time I update the file at > least one copy is made - the folder on my MAC

Re: Year end issues

On Monday, 15 January 2018 15:03:33 GMT Jack Whyte wrote: > I am concerned the file, currently at around 1.3MB, will > become unwieldy and unmanageable. > > Thanks & regards > Jack Hi Jack, My business data file is around the 25 MB mark at the moment, my personal file is more like 5.6MB, so

Re: NUM Column Defaults

I suspect that it is not easy to have both auto increment and auto fill at the same time. You can still ask. David C On Jan 15, 2018 11:18 AM, "Jack Slater" wrote: > Is there a place/method I should use to request? > > > On Jan 15, 2018, at 11:12 AM, Kenneth Schneider

Where Does GnuCash store exchange rates

Hello I hope this is the right forum/email address to ask questions. This is the first time I am posting a question on GnuCash. My question is: where does GnuCash store exchange rates for balance sheet items, where the balance sheet items have two (or more) currencies? I will illustrate my

RE: Correcting Opening Balances

Thank you for the responses to date. I will work on the bank accounts first, then go back to the manual for direction before turning to investment accounts. Here is an example of what I am encountering: One of the accounts that popped up after the conversion from Quicken is a credit card that I

RE: Year end issues

Jack - - Not sure on the size constraints – someone else can maybe answer. With respect to getting it down to a manageable size – I can only speak from my experience. When I transferred over from Quicken, I had transactions dating back to 2003. Bringing them all over was messy. But I did

Re: NUM Column Defaults

Auto fill is not enabled for the NUM column. Maybe a feature request would get it added in a future release. Ken Schneider > On Jan 15, 2018, at 12:04 PM, Jack Slater wrote: > > I was hoping AutoFill was an option as well but it’s not seeming to remember > what I’ve

Re: NUM Column Defaults

I was hoping AutoFill was an option as well but it’s not seeming to remember what I’ve typed. > On Jan 15, 2018, at 10:53 AM, Derek Atkins wrote: > > Hi, > > Jack Slater writes: > >> Is it possible to create/save default NUM items such as: >> >>

Re: [GNUCASH] Commas on graph

Hi David, Yes, that is exactly what I am referring to and yes, that is what I have noticed as well :). Adrien - I took a look, but still no commas in my graphs :(. Maybe this could be a feature request, but for now I can keep surviving without it :) - it would just be a nice to have. Thank

Re: NUM Column Defaults

Hi, Jack Slater writes: > Is it possible to create/save default NUM items such as: > > EFT (electronic funds transfer) > DEP (deposit) > TRN (transfer) > ATM (auto teller machine) > And a simple free form text entry (this would allow for sequenced check > number entries)

Re: Invoices: multilingual & tax detail questions

Hi, Macho Philipovich writes: > Dear fellow Gnucash users, > > I have two questions about invoices. > > First, I deal with some of my clients in French, some in English. I'd > like to be able to provide invoices in either language. Gnucash reports > generally allow me to

Re: Year end issues

Thanks Ken I wrote a reply before reading yours! The file is very large and unwieldy already - are there any limits on the file size? One of the impacts is also that each time I update the file at least one copy is made - the folder on my MAC for December grew to >130MB. JACK On 15 January

Re: Year end issues

Thanks David Yes but as it’s a double entry system, the net effect of deleting a year’s worth of transactions in an account where close book has been applied should be nil so the Checking account should not be effected? Am I missing something? It could be a bit laborious deleting all these

RE: Year end issues

David -- Excellent point. To expand upon it let's demonstrate this: At 12/31/2017 -- you have balances in all your accounts -- for brevity, will just use one real simple example: At 12/31/2017 - let's assume the checking account has a balance of $500. If you eliminate all 2017

Re: Year end issues

No, there isn’t. The Close book feature simply creates a transaction that zeroes out your income and expense accounts as of a given date. In a double entry accounting system, if you delete the expense side of the transaction, what do you suggest doing for the Checking account side? If you are

Re: Year end issues

I was about to ask the same question! Thanks. On Mon, Jan 15, 2018 at 9:03 AM, Jack Whyte wrote: > Hi there > > I have used GNU Cash for a number of years to monitor my personal > finances. I have just run the Tools > Close book function to clear down > all my expense &