[GNC] How to treat managed accounts or funds with fixed price

2020-08-14 Thread rsbrux via gnucash-user
unt?  If so, which equity type should I use? Thanks in advance for any advice. ___________ 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

Re: [GNC] How to treat managed accounts or funds with fixed price

2020-08-14 Thread rsbrux via gnucash-user
Thanks David. The reason I wanted to use the Portfolio reports was to show ROI. From: David Carlson Sent: Friday, August 14, 2020 7:42 PM To: rsbrux Cc: GnuCash List Subject: Re: [GNC] How to treat managed accounts or funds with fixed price Portfolio reports only show security

Re: [GNC] How to treat managed accounts or funds with fixed price

2020-08-14 Thread rsbrux via gnucash-user
Datum: 14.08.20 22:19 (GMT+01:00) An: rsbrux Cc: GnuCash List Betreff: Re: [GNC] How to treat managed accounts or funds with fixed price Some managed accounts not only have a registered symbol but are also price reported .  If yours is not reported you could make up a symbol and still call it a m

Re: [GNC] help increasing size of font in GnuCash?

2020-08-14 Thread nor via gnucash-user
/out with control key +or- does notwork either.Appreciate your advise,Regards,norUnquote.Regards, - nor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] help increasing size of font in GnuCash?

2020-08-15 Thread nor via gnucash-user
Sorry I missed to mention that I am on Window 10 platform and using GNU 4.1Can you please explain zoom in/out w.r.t. windows and GNU CashRegardsnor - nor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash

Re: [GNC] Inconsistency Between Balance of Stock Account and Display in Accounts, File Integrity Check

2020-08-16 Thread rsbrux via gnucash-user
misrepresentation? Is there some way of troubleshooting it, or should I just hide the (now empty) account and forget about it? Thanks for any advice! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe

Re: [GNC] Inconsistency Between Balance of Stock Account and Display in Accounts, File Integrity Check

2020-08-16 Thread rsbrux via gnucash-user
? Is there some way of troubleshooting it, or should I just hide the (now empty) account and forget about it? Thanks for any advice! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: h

Re: [GNC] Get quote - online price retrieval

2020-08-17 Thread D. via gnucash-user
Of course, if you're using amfiindia as your price source, it's not technically necessary to add an AlphaVantage key, since you're not using AlphaVantage as a source. Original Message From: Geoff Sent: Mon Aug 17 01:41:22 EDT 2020 To: gnucash-user@gnucash.

Re: [GNC] Get quote - online price retrieval

2020-08-17 Thread D. via gnucash-user
Ah, yes. ISTR that AlphaVantage is used for all currency conversions. That would suggest that users should be told that outright somewhere. Original Message From: Geoff Sent: Mon Aug 17 08:32:10 EDT 2020 To: "D." Cc: David Reiser via gnucash-user , gnucash-user@g

Re: [GNC] help increasing size of font in GnuCash?

2020-08-17 Thread nor via gnucash-user
suggestion for the developers .nor - nor -- 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.gnuca

Re: [GNC] help increasing size of font in GnuCash?

2020-08-17 Thread D. via gnucash-user
John, I wondered about that as well; a check of the wiki turns that location up in this section: https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_DATA_HOME Original Message From: John Ralls Sent: Mon Aug 17 12:13:08 EDT 2020 To: Peter West Cc: gnucash-u

Re: [GNC] GTK Inspector blowing up on Mint 20 (was Re: help increasing size of font in GnuCash?)

2020-08-19 Thread nor via gnucash-user
Hello John/Andrian, It is pretty heavy for me, non IT. Please work out so we have options in preferences. Regards, Nor - nor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash

[GNC] How do I add notes to my columns?

2020-08-21 Thread ToddAndMargo via gnucash-user
Hi All, gnucash-4.1-1.fc32.x86_64 I see I can View->Sort by "Notes" How do I add a "notes" column to my accounts: Many thanks, -T _______ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription prefer

Re: [GNC] How do I add notes to my columns?

2020-08-21 Thread ToddAndMargo via gnucash-user
On Fri, 21 Aug 2020 at 18:44, ToddAndMargo via gnucash-user mailto:gnucash-user@gnucash.org>> wrote: Hi All, gnucash-4.1-1.fc32.x86_64 I see I can View->Sort by "Notes" How do I add a "notes" column to my accounts: Many thanks, -T

[GNC] Monthly Payments on posted Liability?

2020-08-24 Thread Fran_3 via gnucash-user
shows you.. upcoming expenses, item by item for the next x days... upcoming revenue, item by item for the next x days I ask because clicking Reports > Vendor > Process Payments seems to only look in AP... or does it? Thanks for any help. ___ gnuc

Re: [GNC] Monthly Payments on posted Liability?

2020-08-24 Thread Fran_3 via gnucash-user
n 2020-08-24 09:01, Fran_3 via gnucash-user wrote: >>> For a posted liability of say $1,000with an agreement to pay in 10 >>> monthly installments of $100 each.How do you enter those monthly >>> payments and...1 - have the payment applied to the liability Also, s

Re: [GNC] Capital Gain Calculations on Split Stocks

2020-08-24 Thread D. via gnucash-user
on so that the open lot is the lot selected last. I could imagine an impossible-to-achieve in gnucash situation, where a sale used multiple incomplete lots, leaving them both open. Lots as currently implemented couldn't do this, although i honestly can't imagine a real world use fo

Re: [GNC] Capital Gain Calculations on Split Stocks

2020-08-24 Thread D. via gnucash-user
h you generally about making sure I'm tracking it all the same as the broker, since that's where the tax folks are going. David Original Message From: peterb Sent: Mon Aug 24 22:52:23 EDT 2020 To: "David T." Cc: Gnucash Users Subject: Re: [GNC] Capital Gain Cal

Re: [GNC] How do I add notes to my columns?

2020-08-25 Thread ToddAndMargo via gnucash-user
>> Any way to get it in single line mode? On 2020-08-21 03:31, david whiting wrote: Not that I am aware of. Dang! Thank you anyway. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsub

Re: [GNC] Capital Gain Calculations on Split Stocks

2020-08-25 Thread D. via gnucash-user
Oh! I like that solution! I knew someone would have a way to make this work. Now, if only the assistant would handle it this way... Original Message From: Geoff Sent: Tue Aug 25 02:04:38 EDT 2020 To: "D." , peterb Cc: Gnucash Users Subject: Re: [GNC] Ca

Re: [GNC] How do I add notes to my columns?

2020-08-25 Thread ToddAndMargo via gnucash-user
> On 25/08/2020 9:25 pm, ToddAndMargo via gnucash-user wrote: >> >> Any way to get it in single line mode? >> >> On 2020-08-21 03:31, david whiting wrote: >>> Not that I am aware of. >> >> >> Dang! Thank you anyway. On 2020-08-25 19:22,

[GNC] Importing transactions in multi-currency accounting

2020-08-26 Thread andrepd via gnucash-user
rates when, for example, debiting a current account in USD and crediting an expense account in EUR. I import my bank statements monthly using OFX/CSV. However, after using gnucash for over a year and a half, I just noticed now that when currencies differ gnucash automatically and silently sets the exc

[GNC] How to transfer multiple bills from Vendor A to Vendor B? Journal Entry or what & how?

2020-08-27 Thread Fran_3 via gnucash-user
ls > General Journal How can I do this so I have a record in the system of what happened? Thanks for any help. ___________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mai

Re: [GNC] How to transfer multiple bills from Vendor A to Vendor B? Journal Entry or what & how?

2020-08-27 Thread Fran_3 via gnucash-user
mns > Links > Simple Complicated maybe but we only have a few instances where this must be done... and it seems to work :-) Thanks again for the help. On Thursday, August 27, 2020, 12:37:29 PM EDT, Derek Atkins wrote: HI, On Thu, August 27, 2020 11:50 am, Fran_3 via gnucash-user wr

Re: [GNC] Importing transactions in multi-currency accounting

2020-08-30 Thread andrepd via gnucash-user
Bump? -- 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

Re: [GNC] Importing transactions in multi-currency accounting

2020-08-30 Thread andrepd via gnucash-user
I'm using the flatpak version, so I'm on the latest version (4.1). Build ID: Flathub 4.1-2, on Linux Mint 18.3. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _______ gnucash-user mailing list gnucash-user@gnuc

[GNC] 1) search list 2) gnucash-u...@lists.gnucash.org vs gnucash-user@gnucash.org

2020-09-01 Thread Fran_3 via gnucash-user
1 - Is there anyway to search the list archives... like maybe you would do an online forum? 2 - I've ended up with two emails addresses for GnuCash... gnucash-user@lists.gnucash.organdgnucash-u...@gnucash.org What is the difference?Will both get my email distributed to the list members? T

Re: [GNC] Unexpected change in reconcile status

2020-09-01 Thread Michael via gnucash-user
Hi Janet, I'm just another user, but I believe that is normal behavior.  I haven't changed anything recently but seem to remember being annoyed in the past when any little change unreconciled a transaction.  Michael On 9/1/20 8:52 AM, Jan Bates via gnucash-user wrote: I sometimes

Re: [GNC] Asset accounts: cost, or value?

2020-09-02 Thread D. via gnucash-user
Michael, Could you go into more detail about how one would enter, e.g., title insurance in GnuCash so that it would apply to the cost basis of a property? TIA, David Original Message From: Michael or Penny Novack Sent: Wed Sep 02 09:53:54 EDT 2020 To: gnucash-user

Re: [GNC] Import quicken

2020-09-04 Thread D. via gnucash-user
Hello, Reading the available help is a great way to start. Start with: https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_importing.html Next: https://wiki.gnucash.org/wiki/Quicken_Migration Original Message From: PhilipChaban Sent: Thu Sep 03 08:57:11 EDT 2020 To

[GNC] Import transactions with expenses in a different currency

2020-09-08 Thread andrepd via gnucash-user
In the latest version of gnucash (4.1-2 from flathub) I noticed that, when importing transactions in .ofx/.csv into a GBP-denominated bank account, and matching them to expense accounts in EUR, I get the following error message: The account 'Electronics' has a different commodity fr

Re: [GNC] Installing GnuCash 4.1 There is no Disk - Insert a Disk on Windows 7 x64

2020-09-08 Thread D. via gnucash-user
me to put your financial information on... Original Message From: Enrique Garza Sent: Tue Sep 08 09:04:44 EDT 2020 To: gnucash-user@gnucash.org Subject: [GNC] Installing GnuCash 4.1 There is no Disk - Insert a Disk on Windows 7 x64 GnuCash     I have installed the GnuCas

[GNC] reindex?

2020-09-09 Thread ToddAndMargo via gnucash-user
Fedora 32 gnucash-4.1-1.fc32.x86_64 Without going into the particulars of why, is there a way to re-index the database on one of my accounts? Or is there some integrity check on the data that I can run? ___ gnucash-user mailing list gnucash-user

[GNC] Negative numbers

2020-09-09 Thread ToddAndMargo via gnucash-user
Fedora 32 gnucash-4.1-1.fc32.x86_64 I have a number of program that accept negative numbers with the minus sign at the end `123.45-` or inside parenthesis `(123.56)`. Is there a way to tell GnuCash to do this also? I keep entering it the other way and having to go back and put the minus sign

Re: [GNC] Negative numbers

2020-09-10 Thread ToddAndMargo via gnucash-user
On 9/9/20 1:05 PM, Adrien Monteleone wrote: Not that I'm aware of, but just tab or shift-tab to the other column. A negative credit is a positive debit and vice versa. If you try entering a negative, you'll see GnuCash moves it to the other column as a positive anyway. Regards, Adri

Re: [GNC] reindex?

2020-09-10 Thread ToddAndMargo via gnucash-user
On 9/9/20 12:28 PM, ToddAndMargo via gnucash-user wrote: Fedora 32 gnucash-4.1-1.fc32.x86_64 Without going into the particulars of why, is there a way to re-index the database on one of my accounts?  Or is there some integrity check on the data that I can run? On 2020-09-09 13:03, Adrien

Re: [GNC] reindex?

2020-09-10 Thread ToddAndMargo via gnucash-user
On 9/9/20 12:28 PM, ToddAndMargo via gnucash-user wrote: Fedora 32 gnucash-4.1-1.fc32.x86_64 Without going into the particulars of why, is there a way to re-index the database on one of my accounts?  Or is there some integrity check on the data that I can run? On 2020-09-09 13:03, Adrien

Re: [GNC] Import transactions with expenses in a different currency

2020-09-11 Thread andrepd via gnucash-user
Hmm I see. Thanks for the suggestion. However I don't think this solves the issue. I would still need to go manually through all the accounts, and also this would introduce a layer of complexity in importing my monthly statements that I don't really want... -- Sent from: http://gnuca

[GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Fran_3 via gnucash-user
I'm looking for an easy way list all paid expenses for a defined period. I poked around under Reports and maybe I missed it. How can I do this? Thanks for any help. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscri

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Fran_3 via gnucash-user
also lets you group them, so you can group by Payee (description) or by Month for example. Regards, Adrien On 9/11/20 11:45 AM, Fran_3 via gnucash-user wrote: > I'm looking for an easy way list all paid expenses for a defined period. > I poked around under Reports and maybe I misse

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Fran_3 via gnucash-user
Michael, maybe I got my words mixed up. What we want is a report that shows paid expenses for a defined period. Thanks On Friday, September 11, 2020, 6:02:48 PM EDT, Michael or Penny Novack wrote: On 9/11/2020 5:16 PM, Fran_3 via gnucash-user wrote: >  How can I limit the report

Re: [GNC] Is there a Report for All Expenses Paid between Date A & Date B

2020-09-11 Thread Fran_3 via gnucash-user
nd then include them in the summary data. ---- Another option is to learn Scheme and design this report from within GnuCash, or hire someone to do so. But I'd first play with spreadsheets so you see exactly how the data appears and the minimum parts of it you need to make the determinatio

Re: [GNC] Negative numbers

2020-09-11 Thread ToddAndMargo via gnucash-user
On 2020-09-10 21:42, ToddAndMargo via gnucash-user wrote: On 9/9/20 1:05 PM, Adrien Monteleone wrote: Not that I'm aware of, but just tab or shift-tab to the other column. A negative credit is a positive debit and vice versa. If you try entering a negative, you'll see GnuCash moves

Re: [GNC] Negative numbers

2020-09-12 Thread ToddAndMargo via gnucash-user
On 2020-09-12 10:27, John Ralls wrote: On Sep 11, 2020, at 11:33 PM, ToddAndMargo via gnucash-user wrote: On 2020-09-10 21:42, ToddAndMargo via gnucash-user wrote: On 9/9/20 1:05 PM, Adrien Monteleone wrote: Not that I'm aware of, but just tab or shift-tab to the other column. A neg

Re: [GNC] Negative attitudes [was: Re: Negative numbers]

2020-09-12 Thread ToddAndMargo via gnucash-user
On 2020-09-12 19:26, Michael or Penny Novack wrote: ToddAndMargo, I don't know what to conclude from what you are saying. One sentence seems to show you understand that GnuCash only reaches you by lots of people doing lots of things. The next sentence seems to show you having a treme

Re: [GNC] Negative numbers

2020-09-12 Thread ToddAndMargo via gnucash-user
On 2020-09-12 15:20, David Carlson wrote: The developers love volunteers.  Care to help? I program in Raku. What is Gnu Cash written in? If Raku, I'd love to look at the parcer. ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] Negative numbers

2020-09-14 Thread ToddAndMargo via gnucash-user
On 2020-09-13 00:39, Chris Green wrote: On Sat, Sep 12, 2020 at 02:40:51PM -0700, ToddAndMargo via gnucash-user wrote: You ever get a letter from Red hat or Wine or Libre Office explaining that you need to "hire" them to get your bugs fixed? This is the open source model. Open sourc

Re: [GNC] Negative attitudes [was: Re: Negative numbers]

2020-09-14 Thread ToddAndMargo via gnucash-user
On 2020-09-13 03:31, Liz wrote: On Sat, 12 Sep 2020 22:37:02 -0700 ToddAndMargo via gnucash-user wrote: Folks do not understand that Open Source is not free. We have a way of describing this to deal with the various meanings of "free" in English. You are describing "

[GNC] Importing Liability Transactions to AP/Bills

2020-09-14 Thread Fran_3 via gnucash-user
king account. I also don't know how to make the importer identify the double entry accounts for each imported transaction... like...- Accounts Payable and Utilities... or...- Accounts Payable and Office Supplies... etc Thanks for any help. _______ gnuc

[GNC] Subject Correction: How to import CSV into AP Register?

2020-09-14 Thread Fran_3 via gnucash-user
king account. I also don't know how to make the importer identify the double entry accounts for each imported transaction... like...- Accounts Payable and Utilities... or...- Accounts Payable and Office Supplies... etc Thanks for any help. _______ gnuc

Re: [GNC] Importing Liability Transactions to AP/Bills

2020-09-14 Thread Fran_3 via gnucash-user
Fran, I import lots of bills and use File -> Import -> Import bills and Invoices (not transactions). See this help page for details: https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html For my purposes I found it useful to create a spreadsheet for entering details that has a str

Re: [GNC] Importing Liability Transactions to AP/Bills

2020-09-15 Thread Fran_3 via gnucash-user
FYI, this has been solved. Thanks. On Monday, September 14, 2020, 7:20:55 PM EDT, Fran_3 via gnucash-user wrote: David, That worked great. thanks! Next question... anyway to import payments? And, actually, instead of Assets: Checking making the payments...I want the payments to come

Re: [GNC] Tabs Behaviors in GNC4.1

2020-09-15 Thread D. via gnucash-user
On putting the Chart of Accounts at the end: presumably that would work, but it really messes with the Order of Things in my head.  ;) As for the size changes, well, I have been using gnucash a while... Original Message From: Stan Brown Sent: Tue Sep 15 15:55:35 EDT 2020 To

Re: [GNC] Tabs Behaviors in GNC4.1

2020-09-15 Thread D. via gnucash-user
David Carlson Sent: Tue Sep 15 18:24:53 EDT 2020 To: "D." Cc: Stan Brown , Gnucash Users Subject: Re: [GNC] Tabs Behaviors in GNC4.1 I need to ask if this change in sorting order also applies to the default tabs at the top configuration. Also, is it still possible to manually move tabs

Re: [GNC] Tabs Behaviors in GNC4.1

2020-09-16 Thread D. via gnucash-user
... While it might seem overkill to discuss something as seemingly minor as this change, I think *any* change in the user interface should be discussed more, rather than less. Now, we get to have that discussion. At the risk of repeating myself, let me re-present. In my usage of Gnucash, I

Re: [GNC] Tabs Behaviors in GNC4.1

2020-09-16 Thread D. via gnucash-user
Geert, I stopped contributing in any way to the project at the beginning of 2019, in large part because of problems with the workflow, culture, and environment that GnuCash operates within. So, I can definitely relate to your feeling like you want to step back. Given that my observations

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

2020-09-16 Thread Fran_3 via gnucash-user
ctions Description and ignoring the warning? Any other way to do this? 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/lis

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

2020-09-16 Thread Fran_3 via gnucash-user
The below should read "y" for "reconciled and not "r" On Wednesday, September 16, 2020, 8:06:32 PM EDT, Fran_3 via gnucash-user wrote: Under Liabilities I have an account named "Reimbursable" I want to change the Description field of each Transact

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

2020-09-17 Thread Fran_3 via gnucash-user
se, if you unreconcile then you can simply reconcile again (but you can't reconcile using old statement date, must be recent). On Thu, 17 Sep 2020, 8:08 am Fran_3 via gnucash-user, wrote: Under Liabilities I have an account named "Reimbursable" I want to change the Description field of each

[GNC] How to upgrade from 3.8 to 4.1 on Win10?

2020-09-17 Thread Fran_3 via gnucash-user
nks in advance 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 h

Re: [GNC] How to upgrade from 3.8 to 4.1 on Win10?

2020-09-17 Thread Fran_3 via gnucash-user
Windows 10 without any issues. In the event of any problems, you can always revert to 3.8 as long as you have a clean backup of your data. Good luck. Geoff = On 18/09/2020 7:36 am, Fran_3 via gnucash-user wrote: > Just now getting around to upgrading 3.4 to 4.1 on Win10. > 1

Re: [GNC] Error with Advanced portfolio report

2020-09-20 Thread D. via gnucash-user
Thanks. Original Message From: John Ralls Sent: Sat Sep 19 16:46:42 EDT 2020 To: mike823 Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Error with Advanced portfolio report > On Sep 19, 2020, at 1:15 PM, mike823 wrote: > > It is a bug and it was reported a

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-21 Thread D. via gnucash-user
No need.  https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html Original Message From: Chris Green Sent: Mon Sep 21 03:47:20 EDT 2020 To: gnucash-user@gnucash.org Subject: Re: [GNC] Can't "Save As" to sqlite, is it a compile option? On Sun, Sep 20

[GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread Fran_3 via gnucash-user
s... 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

Re: [GNC] Transaction Report Filter for keyword in Description ?

2020-09-21 Thread Fran_3 via gnucash-user
lp John... I was moving so fast to get done that I skipped right over the obvious... Too. Tips. On Monday, September 21, 2020, 12:43:05 PM EDT, John Ralls wrote: > On Sep 21, 2020, at 8:57 AM, Fran_3 via gnucash-user > wrote: > > How can I create a Transaction Repor

Re: [GNC] Reconcile Status Redux: New Odd Behavior, or Is It Me Again?

2020-09-22 Thread D. via gnucash-user
-- From: Adrien Monteleone Sent: Tue Sep 22 16:45:39 EDT 2020 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Reconcile Status Redux: New Odd Behavior, or Is It Me Again? I can confirm the same behavior on MacOS. (however, which field do you mean by: "The only instance in which I've

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-23 Thread D. via gnucash-user
Yes. I did. Original Message From: Geert Janssens Sent: Wed Sep 23 16:10:11 EDT 2020 To: gnucash-user@gnucash.org Subject: Re: [GNC] Can't "Save As" to sqlite, is it a compile option? Op dinsdag 22 september 2020 10:13:37 CEST schreef Chris Green: > On Mo

[GNC] How to have Transaction Report show Debit Totals (&/or Credit Totals) ?

2020-09-25 Thread Fran_3 via gnucash-user
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 inform

Re: [GNC] How to have Transaction Report show Debit Totals (&/or Credit Totals) ?

2020-09-25 Thread Fran_3 via gnucash-user
er or income or expense account I will keep the Register Report in my bag of tricks however so thanks! On Friday, September 25, 2020, 2:51:15 PM EDT, Derek Atkins wrote: Hi, On Fri, September 25, 2020 2:40 pm, Fran_3 via gnucash-user wrote: > Is there anyway to have a Transaction Report

[GNC] clip board paste across catagories

2020-09-26 Thread ToddAndMargo via gnucash-user
Hi All, Fedora 32, x64 Xfce 4.14 gnucash-4.1-1.fc32.x86_64 I has a situation where I have the Date, Number, Description, Transfer, Payment, Charge loaded into the secondary clipboard (, ctrl). (Linux has four clipboards.) When I paste (ctrl) into GnuCash, I can't get it to paste a

Re: [GNC] clip board paste across catagories

2020-09-26 Thread ToddAndMargo via gnucash-user
On 2020-09-26 23:44, ToddAndMargo via gnucash-user wrote: Hi All, Fedora 32, x64 Xfce 4.14 gnucash-4.1-1.fc32.x86_64 I has a situation where I have the Date, Number, Description, Transfer, Payment, Charge loaded into the secondary clipboard (, ctrl).  (Linux has four clipboards.) When I

Re: [GNC] clip board paste across catagories

2020-09-27 Thread ToddAndMargo via gnucash-user
On Sun, Sep 27, 2020, 1:51 AM ToddAndMargo via gnucash-user mailto:gnucash-user@gnucash.org>> wrote: On 2020-09-26 23:44, ToddAndMargo via gnucash-user wrote: > Hi All, > > Fedora 32, x64 > Xfce 4.14 > gnucash-4.1-1.fc32.x86_64 &g

Re: [GNC] clip board paste across catagories

2020-09-27 Thread ToddAndMargo via gnucash-user
On 2020-09-27 01:08, Liz wrote: On Sun, 27 Sep 2020 00:23:50 -0700 ToddAndMargo via gnucash-user wrote: On 2020-09-27 00:02, David Carlson wrote: > AFAIK ctrl-v has always pasted entire contents of the clipboard > only into the currently selected field. > Any special charac

Re: [GNC] clip board paste across catagories

2020-09-28 Thread ToddAndMargo via gnucash-user
On 2020-09-26 23:44, ToddAndMargo via gnucash-user wrote: Hi All, Fedora 32, x64 Xfce 4.14 gnucash-4.1-1.fc32.x86_64 I has a situation where I have the Date, Number, Description, Transfer, Payment, Charge loaded into the secondary clipboard (, ctrl).  (Linux has four clipboards.) When I

Re: [GNC] clip board paste across catagories

2020-09-28 Thread ToddAndMargo via gnucash-user
On 2020-09-28 21:37, John Ralls wrote: On Sep 28, 2020, at 9:25 PM, ToddAndMargo via gnucash-user wrote: On 2020-09-26 23:44, ToddAndMargo via gnucash-user wrote: Hi All, Fedora 32, x64 Xfce 4.14 gnucash-4.1-1.fc32.x86_64 I has a situation where I have the Date, Number, Description

Re: [GNC] clip board paste across catagories

2020-09-29 Thread ToddAndMargo via gnucash-user
On Sep 27, 2020, at 12:23 AM, ToddAndMargo via gnucash-user wrote: Any special character I can throw at it to get it to paste across fields? I can insert anything I want into the string On 2020-09-29 08:55, John Ralls wrote: No. Aside from the special transaction copy-paste that

Re: [GNC] clip board paste across catagories

2020-09-29 Thread ToddAndMargo via gnucash-user
On 2020-09-29 13:29, David T. via gnucash-user wrote: I am not an expert, but perhaps if you're writing the format yourself, maybe you could adopt an existing standard (e.g., QIF, QFX, CSV) and import that into GnuCash? Also, Chapter 18 in the Guide is all about importing business

Re: [GNC] clip board paste across catagories

2020-09-29 Thread ToddAndMargo via gnucash-user
On 2020-09-29 13:37, Stephen M. Butler wrote: On 9/29/20 1:20 PM, ToddAndMargo via gnucash-user wrote: On Sep 27, 2020, at 12:23 AM, ToddAndMargo via gnucash-user wrote: Any special character I can throw at it to get it to paste across fields?  I can insert anything I want into the string

Re: [GNC] clip board paste across catagories

2020-09-29 Thread ToddAndMargo via gnucash-user
Create --> table --> LibreOffice --> writer --> Table --> Insert table They do look a little like a spread sheet though with all those rows and columns -T _______ gnucash-user mailing list gnucash-use

Re: [GNC] clip board paste across catagories

2020-09-29 Thread ToddAndMargo via gnucash-user
On 2020-09-29 15:39, John Ralls wrote: Not that it's germane to GnuCash, but your example of the column of text doesn't work with LibreOffice: Paste a column of text into a table cell and you get a cell containing the column of text. Select 4 cells and paste and you get 4 cell

Re: [GNC] clip board paste across catagories

2020-09-29 Thread ToddAndMargo via gnucash-user
On 2020-09-29 13:29, David T. via gnucash-user wrote: I am not an expert, but perhaps if you're writing the format yourself, maybe you could adopt an existing standard (e.g., QIF, QFX, CSV) and import that into GnuCash? Also, Chapter 18 in the Guide is all about importing business

Re: [GNC] clip board paste across catagories

2020-09-29 Thread D. via gnucash-user
I've no idea. Original Message From: ToddAndMargo via gnucash-user Sent: Tue Sep 29 20:58:30 EDT 2020 To: gnucash-user@gnucash.org Subject: Re: [GNC] clip board paste across catagories On 2020-09-29 13:29, David T. via gnucash-user wrote: > I am not an expert, but pe

Re: [GNC] clip board paste across catagories

2020-09-29 Thread ToddAndMargo via gnucash-user
On 2020-09-29 20:13, John Ralls wrote: On Sep 29, 2020, at 5:58 PM, ToddAndMargo via gnucash-user wrote: On 2020-09-29 13:29, David T. via gnucash-user wrote: I am not an expert, but perhaps if you're writing the format yourself, maybe you could adopt an existing standard (e.g., QIF

Re: [GNC] clip board paste across catagories

2020-09-30 Thread ToddAndMargo via gnucash-user
automation task like this for breakfast. Attached is a sample script to scrape transactions from an Excel spreadsheet and insert them directly into a GnuCash ledger.  Seeing is believing: https://www.youtube.com/watch?v=wpO1SSJIgu4 Of course this can be done via CSV import, but that's no

Re: [GNC] clip board paste across catagories

2020-09-30 Thread ToddAndMargo via gnucash-user
On 2020-09-30 03:12, Geert Janssens wrote: If you want to use double quotes as data, you will have to escape them. There are two escape methods gnucash understands: prepend with a backslash (\") or put two double-quotes in a row ("") Are you referring to inside my program

Re: [GNC] clip board paste across catagories

2020-09-30 Thread ToddAndMargo via gnucash-user
On 9/30/20 4:51 AM, ToddAndMargo via gnucash-user wrote: Hi Geoff, The current game plane is to 1) learn how to import a CSV into GnuCash 2) take my data that I was going to place in the clipboard     and instead write it to a standard CSV file and location     the GnuCash can easily and

Re: [GNC] clip board paste across catagories

2020-09-30 Thread ToddAndMargo via gnucash-user
On 2020-09-30 17:40, John Ralls wrote: On Sep 30, 2020, at 11:49 AM, ToddAndMargo via gnucash-user wrote: On 9/30/20 4:51 AM, ToddAndMargo via gnucash-user wrote: Hi Geoff, The current game plane is to 1) learn how to import a CSV into GnuCash 2) take my data that I was going to place

Re: [GNC] Report headings, can one separate the company name from the report name?

2020-09-30 Thread D. via gnucash-user
I don't use those reports, but I can't see why your solution is a "hack." Seems perfectly legitimate to me. Original Message From: Chris Green Sent: Wed Sep 30 12:40:43 EDT 2020 To: gnucash-user@gnucash.org Subject: Re: [GNC] Report headings, can one

Re: [GNC] Account view question

2020-10-08 Thread D. via gnucash-user
23:37:58 EDT 2020 To: David Cousens Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Account view question The Account view which we sometimes call the chart of accounts is simply a list of all the accounts in the current book or data file. It happens to show the current balance of each account in it&#x

[GNC] Transaction Report issue when using GC from 2 locations via Google Drive

2020-10-08 Thread Fran_3 via gnucash-user
The GnuCash file entityA.gnucash is saved on Google Drive.GnuCash is installed on both pcX and pcY at locations X and Y. Google Drive is sync'd on both pcX and on pcY...So the entityA.gnucash file is available locally on both computers hard drive. This way  work can be done from either loc

[GNC] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?

2020-10-09 Thread Fran_3 via gnucash-user
payment into the system as opposed to first creating a bill then posting a bill and then paying the bill. How do you all choose which things to create Bills for and which things just Pay? Thanks. ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

2020-10-09 Thread Fran_3 via gnucash-user
In this case the PC"s are running the latest GnuCash download version for Windows. I haven't explored the "App" yet. I assume you are talking about an app to run on a smart phone... right? Regardless, I want to learn more about the  App but I think that will be another

Re: [GNC] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?

2020-10-09 Thread Fran_3 via gnucash-user
ng my business buys how on a credit card. 🤷 Kind regards, Greg Feneis (Pixel 3) On Fri, Oct 9, 2020, 08:41 Fran_3 via gnucash-user wrote: > Posting Bills allows you to keep track of AP and provides data to the > Bills Due Reminder... > However some routine expenses may just get pai

[GNC] Will the file myStuff.gnucash work on Linux & Windows machines?

2020-10-11 Thread Fran_3 via gnucash-user
Given a GnuCash file myStuff.gnucash... Can that file be shared and worked on on both a Windows 10 machine and a Linux Mint 20.0 Cinnamon machine? Or does GnuCash save the two files differently for Windows 10 and Linux Mint? (In our case the .gnucash file lives in the cloud so either computer can

Re: [GNC] Will the file myStuff.gnucash work on Linux & Windows machines?

2020-10-11 Thread Fran_3 via gnucash-user
file on whatever pc I happen to be in front off at the time Cheers David H. On Mon, 12 Oct 2020 at 10:10, David H wrote: I have been using the same Gnucash file on Win 7, Win 10, Ubuntu Linux & MacOS Big Sur without issue so yes. Cheers David H On Mon, 12 Oct 2020 at 10:04 am, Fran_3

[GNC] Best way to Auto Sync GC Checking Transactions with the Bank?

2020-10-16 Thread Fran_3 via gnucash-user
Given a checking account with a number incidental and auto pay transactions ocuring daily... Is there a way to automate...- logging on to the bank daily- determining which transactions have hit the bank but are not posted in GnuCash- then updating GnuCash with those unrecorded transactions

Re: [GNC] transaction report missing subtotals

2020-10-16 Thread Fran_3 via gnucash-user
I missed the OP but saw a followup on this question. Here is my attempt to explain Transaction Reports Monthly Totals. I'm running Windows 10 and GnuCash Version 4.1 and getting Transaction Reports Monthly Totals seems to work perfectly here. My Process: - Click Reports - Click Transa

Re: [GNC] transaction report missing subtotals

2020-10-17 Thread Fran_3 via gnucash-user
I see the problem. After some experimentation I failed to discover a solution. Hopefully someone else here can chip in. On Saturday, October 17, 2020, 3:57:15 AM EDT, Gal wrote: GnuCash - User mailing list wrote > .. On Sorting Tab - set Primary Key to Date to "enable &

Re: [GNC] Best way to Auto Sync GC Checking Transactions with the Bank?

2020-10-18 Thread Fran_3 via gnucash-user
) Now days there are often several incidental debit card charges plus a number of auto-pay charges that hit the bank. We check the bank transactions daily to make sure we didn't miss recording any of these. The reason for my post was to get some guidance on using the GnuCash built in tools to

Re: [GNC] Best way to Auto Sync GC Checking Transactions with the Bank?

2020-10-18 Thread Fran_3 via gnucash-user
iding the downloading and importing a CSV file. Ditto for GnuCash Checking if we bring it up in a Transaction Report And, as I mentioned to Adrien, I have created an App Script to help me compare the Bank Transactions to the GnuCash TransactionsThe process...- Sort the Bank Transactions by Amoun

<    1   2   3   4   5   6   7   8   9   10   >