Re: [GNC] Decimal separator on MacOS Mojave 10.14

Check your Keyboard setting in the System Preferences -> Keyboard -> Input Sources. Will On 2021 May 24, at 05-24 21:41:52, Yves Forget via gnucash-user wrote: Hello, I just upgraded from MacOS 10.13 High Sierra to 10.14.6 Mojave. Since upgrade, GnuCash uses the period instead of comma as d

Re: [GNC] GNUCash & Macros

The "Script Editor" found in the Applications->Utilities folder under Mac OS has some capabilities that might help. You can tell it to track a series of actions that turn into a script that can be edited for refinements and then used as a 'Macro'. Will On 2021 May 26, at 05-26 17:56:16, Jack

Re: [GNC] GnuCash sqlite backend on windows and linux

I have several SQLite databases that I move between and access under Mac OS and Linux. I never have had problems. Will On 2021 May 26, at 05-26 18:49:12, Geoff wrote: I haven't tested it, but the SQLite developers say that it is: "A database in SQLite is a single disk file¹. Furthermore, the

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

I am just an uninterested observer of this discussion of the location of the Imbalance account(s). It has never bothered me. But Michael's suggestion seems like a good one for those that are bothered by it. Then if the account appears, you know there are some unbalanced transactions. If there ar

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

I concur. It seems like this is a too minor an issue to warrant the number of posts on the subject. But I guess people feel strongly about it. Will On 2021 Jun 3, at 06-03 10:11:22, David T. via gnucash-user wrote: Given how easy it is to correct these problems (i.e., change the Account in th

Re: [GNC] Transaction ordering on num field

For those that care, it is perfectly easy to have numbers sort correctly with an alphanumeric sort, simply include the leading zeros. If you think your check numbers will never exceed 1000, just number the checks: 0001, 0002,... 0100, 0101, etc.If you expect to write more than 1000, add another

Re: [GNC] Reconciliation screw-up

What confuses me about the original post is it shows $1 leaving C (to D), but the text says $1 was should have been added to C (from A). Yet C was reconciled. It seems like before this was fixed, C should have been off by $2. Will On 2021 Jun 17, at 06-17 08:12:51, Michael or Penny Novack wro

Re: [GNC] GnuCash 3.905 Released

I am currently running 3.10-1 on MacOS. I am unclear how this relates to 3.905. Can someone clarify this for me. Thanks, Will On 2020 Jun 14, at 06-14 18:19:31, John Ralls wrote: The GnuCash development team announces GnuCash 3.905, the fourth testing release for what will soon be GnuCash 4.

Re: [GNC] Style Sheets - general questions

Scott, Like you I have used GnuCash for personal use for years and now am using it for an organization I belong to. I didn't like the appearance of the standard reports. Instead of trying to customize them, I just export the transactions as a csv file and open in Apple's Numbers spreadsheet pro

Re: [GNC] Fractional Hours?

That explains something I have always wondered about. I often have transactions that are in US dollars in one account and Mexican pesos in the other account. It expressed the exchange rate as a fraction, but a decimal value would be more useful. Now I know how to change that. Thanks, Will On 2

Re: [GNC] Gnucash 4.0 doesn't launch on MacOS X 10.15.4

Ditto on Mac OS 10.15.5. Opened without issues. The first time it asked for the standard permission to open since it didn't come from the App Store. But it didn't open. Then I opened it again and it was fine. Will On 2020 Jun 29, at 06-29 11:08:57, Jean Laroche wrote: I'm on 10.13.4 (High Sier

Re: [GNC] Gnucash 4.0 doesn't launch on MacOS X 10.15.4

;> been able to figure out where is the disconnect between Launch Services >> and >>> GnuCash after Gatekeeper verification is complete. Gatekeeper also >> fails to >>> remove the com.apple.quarantine xattr from the app bundle and that >> caused a >>>

Re: [GNC] Split transaction on invoices in foreign currencies

I do a lot of that since I live in Mexico and have bank accounts in both the US and Mexico. I don't remember the circumstances, but it seems like I have had the same issue on transactions that are half in one currency and half in the other. It will sometimes ask for the exchange rate, when it d

Re: [GNC] Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations

Until recently, reconciling was really my primary use of GnuCash. I also get digital statements, but reconciling is the about the only time I look at them. Will On 2020 Jul 3, at 07-03 20:45:03, Chris Good wrote: Hi Ken, I'm afraid I'm in the group that finds reconciling very useful. I want

Re: [GNC] Help required

"Decide from those whether there are new features that you want. If not, there is no reason to abandon a release that you are using successfully." I would disagree. I think it is better to keep all software current. You may not want new features in the current latest release, but down the road th

Re: [GNC] Help required

ases it is better to follow the the adage "If it ain't broke, don't fix it." David Carlson On Mon, Jul 6, 2020, 7:55 AM w...@theprescotts.com <mailto:w...@theprescotts.com> mailto:w...@theprescotts.com>> wrote: "Decide from those whether there are new featur

Re: [GNC] Help required

9:33 AM w...@theprescotts.com <mailto:w...@theprescotts.com>mailto:w...@theprescotts.com>> wrote: David, There is no one answer for everybody but I find it is better to pick a time when I have no emergencies and update, even if it will "fix something that ain't broke"

Re: [GNC] GnuCash list: gmane

When I started programming, we would mail (US Postal Service) decks of punched cards to MIT to be run on their machine. Then they would mail the printed output back to us. This was in 1963. Will On 2020 Jul 7, at 07-07 12:31:38, david whiting wrote: You beat me to it! I was going to make th

Re: [GNC] Reconcile also opens Interest Payment box?

I actually use the interest payment box to add a monthly interest transaction when I reconcile my accounts. I never use the credit card payment box that comes up when you finish reconciling a credit card account.. Will On 2020 Jul 12, at 07-12 13:32:08, jean laroche wrote: Personally, I don't

Re: [GNC] Reconcile also opens Interest Payment box?

Incidentally, I replied earlier that I use the interest popup but not the credit payment popup. I could easily do without either one. I have the credit card payment as a regularly scheduled transaction with no amounts filled in. I would probably do the same with the interest transactions if the

Re: [GNC] Reconcile also opens Interest Payment box?

Regarding reconciling. It is almost the only thing I use Gnucash for. I have 14 or 15 accounts in one Gnucash file and 5 or 6 in another. Reconciling the accounts forces me to look at the statements. Without it I would probably never notice if any fraudulent transactions were charged to my accou

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

I have a few comments on this long post. I will preface it by admitting that I am neither a tax attorney nor an accountant. I have kept my personal accounts in GnuCash for many years. I am the treasurer for two non-profits, or more accurately, two subsidiaries of one non-profit. But neither of t

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

in a modest manner) could then > discuss whether these would be easy to add/fix. Perhaps these features >have been discussed in the past? Job costing, in particular, may not > be >that hard to implement? The Cash Flow reporting might also not be too >hard to fix, once t

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

As I said earlier, I am not an accountant just a volunteer keeping the books for a couple of groups. Michael comments: "and NOT currency sitting around undeposited (of course don't do THAT)." I do do that and wonder why it is a bad idea. I frequently get incoming cash, mostly from T-shirt sales.

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

uld be very much to your advantage to have followed the rules. Regards, John Ralls [1] R.F. Salmonson, James Don Edwards, Roger H. Hermanson; A Survey of Basic Accounting, Fourth Edition; Richard D. Irwin, Inc., Homewood IL; 1985; ISBN 0-256-03203-3; p144ff > On Jul 25, 2020, at 11:02 AM, w...@thepr

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

On 2020 Jul 26, at 07-26 11:25:10, Michael or Penny Novack wrote: On 7/26/2020 11:39 AM, John Ralls wrote: > Did nobody read the footnote? The book was published in 1985, long before > electronic payments became widely available. No doubt the 2020 edition would > say something like "indepe

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

Recently someone called the treaurer of a group associated with mine. They told her the chair of the group had an emergency and needed funds. The treasurer did not have access to their Paypal account so he sent funds from his personal account. It turned out to be a scam. Actually a pretty well k

Re: [GNC] Can't find file

Michael, Thank you for your message. I didn't have the problem that Dan had. I am well aware of where the .gnucash file is stored. But I use two different Gnucash files and am always switching between them. I have always used the Open... menu item, then navigated to the correct file. Until I sa

Re: [GNC] Can't find file

h the second instance to a different file, the first instance switches to that file and the second instance quits. Will On 2020 Jul 30, at 07-30 16:24:14, Liz Dodd wrote: On Thu, 30 Jul 2020 11:38:50 -0500 "w...@theprescotts.com" wrote: > On that topic, if I someone asked me what

Re: [GNC] Can't find file

e first with > gnucash --nofile > or explicitly > gnucash path/to/file > > Each OS/desktop environment should have abilities to create > corresponding links. > > Regards > Frank > > Am 30.07.20 um 23:24 schrieb Liz Dodd: >> On Thu, 30 Jul 2020 11:38:50 -0500 &

Re: [GNC] Can't find file

you want to open, and you may substitute the path to a gnucash file for --nofile. Regards, John Ralls > On Jul 31, 2020, at 11:14 AM, w...@theprescotts.com wrote: > > John, > > I have played around with trying to open multiple instances of gnucash from > the Terminal (Mac OS Cat

Re: [GNC] mysql gnucash

Probably should not be a space in "localhost". Will On 2020 Aug 18, at 08-18 17:42:09, Joseph Vernice wrote: You can set up the MySQL to point to 127.0.0.1 and the alias “local host” On Tue, Aug 18, 2020 at 4:31 PM andy ngo wrote: > Thank you for your help. > > I don't remember using Flatpa

Re: [GNC] mysql gnucash

king code. Regards, John Ralls > On Aug 18, 2020, at 5:29 PM, w...@theprescotts.com wrote: > > Probably should not be a space in "localhost". > > Will > > On 2020 Aug 18, at 08-18 17:42:09, Joseph Vernice wrote: > > You can set up the MySQL to point to 127.0.0.

[GNC] Location of gtk css file on MacOS

I am running Gnucash 4.1.4 on MacOS 10.15.6 and I am looking for the location of the gtk.css file that is controlling the display. I have seen discussion of it here and have looked at the wiki but I am still having trouble. I have files: ~/Library/Application Support/Gnucash/gtk-3.0.css ~/Librar

Re: [GNC] Location of gtk css file on MacOS

on Support/Gnucash/gtk-3.0.css) which only has the following in it ... * { font-size: 12px; } If I change the 12px to 18 px and restart GnuCash I can see the difference right away. Cheers David H. On Wed, 2 Sep 2020 at 08:58, w...@theprescotts.com <mailto:w...@theprescotts.

Re: [GNC] I'm still a bit confused about when things get saved.

The modern MacOS is pretty amazing at preserving work in most apps now even if you have not saved to disk. I have shut down my computer with unsaved changes and they are still there when it reboots. And where I live power failures are common and I am not on a UPS (long story there). So even when

Re: [GNC] Location of gtk css file on MacOS

use. Regards, John Ralls > On Sep 1, 2020, at 7:33 PM, David H wrote: > > Will, > > The other file ~/Library/Application Support/Gnucash/config/gtk-3.0.css > that you said also existed only exists as an empty folder on my system ??? > > Cheers David H. > > On Wed, 2

Re: [GNC] Location of gtk css file on MacOS

; anything in another one. That's why the old Update Finance Quote applet > stopped working. > > Regards, > John Ralls > >> On Sep 11, 2020, at 2:50 PM, w...@theprescotts.com wrote: >> >> John, >> >> I'm just getting back to investigating th

Re: [GNC] Tabs Behaviors in GNC4.1

I don't have a preference for where new tabs open, I can see advantages to either location, and can adjust easily to either location. But i just discovered that one can give accounts colors and specify that the color be used on the tab. If one has some tabs that they want to keep open all the t

Re: [GNC] Tabs Behaviors in GNC4.1

If I respond to this post with "Reliable?", am I the one bringing irrelevance and controversy to the thread or was it David C. Will On 2020 Sep 16, at 09-16 19:34:43, David Carlson wrote: There is a story in a very reliable book about David being a giant killer. _

Re: [GNC] Tabs Behaviors in GNC4.1

So am I. I regretted mentioning it. Will On 2020 Sep 16, at 09-16 20:30:09, David Carlson wrote: I wasn't the first to go off topic, but I'm willing to stop On Wed, Sep 16, 2020 at 8:01 PM w...@theprescotts.com <mailto:w...@theprescotts.com> mailto:w...@theprescotts.c

Re: [GNC] Need to - Mark Split as Un-reconciled - in GC 3.8

Don't know about Windows. On Mac OS, I have 2.6.1.1, 3.0.1, 3.10, 4.0, 4.1, 4.1.4 all currently installed. Don't ask why. Will On 2020 Sep 17, at 09-17 13:04:53, Fran_3 via gnucash-user wrote: Thanks Chris. Question - Do I have to remove GC 3.8 before installing 4.1 or what? (On Windows

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

The group I keep books for has a policy of only accepting restricted or directed donations in the case where the donation is very large. Large in our case is over $10,000 or $20,000 Mexican pesos, $500 or $1000 US dollars. So far we have not had to deal with any. We have had a couple of donation

Re: [GNC] How to balance correctly a particular transaction which involves debt?

IANAA (I am not an accountant), but I handle that situation in my personal books with an expense account named "Reimbursable expenses". When the money is spent I credit it to Reimbursables, and when the money is repaid, I debit it to Reimbursables. Will On 2020 Sep 21, at 09-21 09:35:39, Chris

Re: [GNC] Register columns: The balance column is no longer visible

To reinforce what John said. I am also occasionally having issues with column widths. Running 4.1.4 on MacOS 10.15.6. Sometimes the columns are not wide enough to display all of the digits. Yesterday the cleared/reconciled column was too narrow to see anything, just two vertical column separator

Re: [GNC] Shortcuts and Sorts

Walter, In my opinion the advantage of the auto-filled transactions is not the amounts but that it adds lines for the required accounts. When you tab into the amount columns it doesn't matter whether it is blank or filled with something from the previous transaction. It is selected and when you

Re: [GNC] Register columns: The balance column is no longer visible

umn widths but account registers are still one-at-a-time.) For all columns *other* than Description, drag to the RIGHT, or double-click for auto sizing. For the Description, drag far LEFT and release. Regards, Adrien On 9/23/20 8:32 AM, w...@theprescotts.com wrote: > To reinforce what John sa

Re: [GNC] Just installed 4.2

I just downloaded and installed the MacOS version. The first time I tried to open it, it asks me if I want to trust it, I say yes, then nothing happens. The second time I open it, it runs fine. I think this is the standard behavior with every release. Will On 2020 Sep 27, at 09-27 17:00:30,

Re: [GNC] Just installed 4.2

Mike, I use Gnucash with two different data files and switch between them all the time. Occasionally, when Gnucash opens I will get a message that the database is locked by another user. I just tell it to go ahead anyway, and it works fine. Will On 2020 Sep 27, at 09-27 17:41:24, mike823 wro

Re: [GNC] Exchange rate of income statement report

I am not sure this is responsive to the original question. I keep records for two different currencies in Gnucash. Every account is set to one or the other of them. And every transaction is entered in the currency of the account. The only time there is ever an issue of converting between curren

Re: [GNC] Simultaneous Users? Cloud Access? Split FE & BE?

Just to chime in on the terminology... In my current job I do back-end development for an NGO. We have another developer who works on the front end and a couple people working on a mobile app. The back end is an application that runs on an Amazon Web Service instance. The front end is a web ap

Re: [GNC] Multi split transactions using csv import

Is this a one time chore. I don't know about doing it on the Gnucash side, but it seems relatively easy to do in in a spreadsheet. Insert a column for numbering the rows. Duplicate all the rows as a block, i.e. with the second copy of all the rows following the first block e.g. 1 a ... 2 b ...

Re: [GNC] Your Classification / Tagging Implementation

IANA (I am no accountant), but don't you have the credit/debit reversed on the example Assets:Checking and Expenses:Eating out. I would think it would be debit to checking (withdrawal) and a credit to Eating out. Maybe I don't know what Cr and Dr stand for. Will On 2020 Nov 7, at 11-07 15:49:

Re: [GNC] Your Classification / Tagging Implementation

se excuse any typos. On November 7, 2020 7:27:04 PM "w...@theprescotts.com" wrote: > IANA (I am no accountant), but don't you have the credit/debit reversed on > the example Assets:Checking and Expenses:Eating out. > > I would think it would be debit to checking

Re: [GNC] List Replies

Adrien, For your reference, in the MacOS Mail.app: clicking Reply: puts the sender in the To: field clicking Reply All: puts gnucash-u...@lists.gnucash.org in the To: field, and the sender in the cc: field. Usually what I do is hit 'Reply All', delete th

Re: [GNC] List Replies

Sorry, I had that reversed clicking Reply All: puts gnucash-u...@lists.gnucash.org <mailto:gnucash-u...@lists.gnucash.org> in the cc: field, and the sender in the To: field. On 2020 Nov 18, at 11-18 12:17:03, w...@theprescotts.com wrote: Adrien, For your reference, in the MacOS Ma

Re: [GNC] List Replies

27;t have an *iOS* device though. > > And the question wasn't about the buttons' current behaviors, but rather > how easy it is to send to *any* e-mail address in any part of the > header, or the body of the message. (and not just the list address or > reply-to he

[GNC] Tab bar icon text

This should be easy to find, but I haven't found it yet. Running Gnucash 4.2 on Mac OS 11.0.1. On my laptop machine, the tool bar shows the icons with text labels below them. On my desktop machine, the text labels are missing. I find some of the icons totally mystifying, and the text labels are

Re: [GNC] Tab bar icon text

else's file who did so. By default, the labels are visible. (an early iteration of 3.x had them not there at all if I recall, but that change was soon reverted.) Regards, Adrien On 11/28/20 12:36 PM, w...@theprescotts.com wrote: > This should be easy to find, but I haven't found i

Re: [GNC] Possible Jump Enhancement

If someone is taking a poll, I don't think it is worth the effort either. But then I mostly use either the split view or auto-split view. Will On 2020 Dec 8, at 12-08 11:39:36, Derek Atkins wrote: Just a devil's advocate question, but how is hitting the Jump button to get a popup to see the sp

Re: [GNC] systemd / sqlite 3 file not found error

Usually jobs that work for some types of logins and fail for others are either due to differences in file access permission or differences in environment variables. Maybe when it runs as root, the $PATH variable is different and it is not finding something. Or some other environment variable is

Re: [GNC] ofx.chase.com?

Not specific to this, but… I find the continual push towards more security a mixed blessing. In the effort to keep bad guys out, it creates problems for good guys. I am probably hypersensitive to these issues, because I live in one country and have lots of my personal banking and other activiti

Re: [GNC] Help

I noticed one quirk about using opening balances: If you do add opening balances when creating new accounts, GnuCash creates an Equity:Opening balances account for you for the other side of the transaction. However, should you want to change the opening balance for any reason after the account

Re: [GNC] Recent list in file menu

Note: If you have Gnucash in a non-standard location like I do, you probably will have to give the full path to the application. e.g. defaults read -app /Applications/Gnucash/Gnucash-4.4/Gnucash.app On 2021 Jan 18, at 01-18 04:20:33, Michael Hendry wrote: > On 17 Jan 2021, at 20:11, David H

Re: [GNC] Recent list in file menu

It is maybe worth mentioning that the Gnucash preferences plist on Mac OS is stored in: ~/Library/Preferences/org.gnucash.Gnucash.plist Will On 2021 Jan 18, at 01-18 12:55:51, John Ralls wrote: And that turns out to be necessary: Unless you tell defaults -int it writes a string and GSettings

Re: [GNC] Switching to trading accounts in existing database

I am probably missing something here. I have bank accounts in two countries and regularly transfer money between them. Whenever I move money, I record the transaction and the amount for each side of the transaction. Gnucash automatically makes an entry in the Price Database recording the conver

Re: [GNC] Linux question

Steve, When you say "multiple data accounts", do you mean that you can open more than one Gnucash file at once on Mac OS? How do you do that? I haven't been able to and it would be convenient. Regards, Will On 2021 Mar 1, at 03-01 10:39:42, Stephen C. Camidge wrote: I am starting to learn a

Re: [GNC] Moving to Linux

Be careful with 'rm' and the asterisk. rm ._* will remove files with names that start with anything followed by '_' rm ._ * will remove everything in the directory. Will On 2021 Mar 13, at 03-13 19:04:16, Peter West wrote: If these files are on linux try $ ls ._* That should show you those fi

Re: [GNC] Importing Accounts with non-English Characters

On MacOS, you can access all those special characters from the Keyboard menu. One of the tabs in the Keyboard System Preference has an option to 'Show Input menu in the menu bar'. Then from any app you can open up an 'Emoji and Symbol Viewer' that will allow you to insert any symbol or character

Re: [GNC] Translation style (formal/informal you) in Spanish

Guille, I live in México and speak Spanish as a second language. My vote is for the informal. What about the second person plural? My vote there would be to go with what most of Latin America uses since that is the largest Spanish speaking population. i.e. 'tu' and 'ustedes'. Will On 2021

Re: [GNC] Importing XLM into GNUCash

I am new to this mailing list although I have used GnuCash for years. I don't know if there exists a current solution to importing xml data, but it would seem to me to be a simple matter to write a translator that could convert xml into csv or some other format. Most languages (python, ruby, per