Re: [GNC] Transaction inconsistency when deleting account

2023-09-05 Thread sunfish62--- via gnucash-user
ISTR many years back encountering this discrepancy (that is, GnuCash saying it was deleting transactions only to find them still there after). I chalked it up to GnuCash being GnuCash, and decided that deleting accounts with transactions in them was more confusing than stepping through an accou

Re: [GNC] Expenses by Account

2023-09-06 Thread sunfish62--- via gnucash-user
Or you could use the Asset Barchart or Liability Barchart report. Ticking the Show table option has the added benefit of displaying the figures for each account included. ⁣David T. ​ On Sep 7, 2023, 5:19 AM, at 5:19 AM, Alan Hopkins wrote: > Hello Tom > It's fairly straightforward, if I u

Re: [GNC] Where are GC log files located on Mac with remote database server?

2023-09-11 Thread sunfish62--- via gnucash-user
Others will correct me, but my understanding is that the log files are not used with the database backend, since the changes are committed immediately. ⁣David T.​ On Sep 11, 2023, 9:03 AM, at 9:03 AM, Jediator wrote: >Hi GC users, I am using GC (version 5.3) on Mac.  I noticed that the >log

[GNC] Porting Auto Completion from v4 to v5

2023-09-13 Thread sunfish62--- via gnucash-user
Hello, In another thread, it was noted that the latest version of auto complete in version 5 of GnuCash restarts the auto completion data store. That gave me pause, as I make use of the feature extensively to speed the entry of transactions for a large number of stocks and mutual funds. (I sta

Re: [GNC] Porting Auto Completion from v4 to v5

2023-09-14 Thread sunfish62--- via gnucash-user
e auto complete data set based on existing data. Others have said that this isn't the case, though. So, I don't know whose experience is more true. ⁣David T. ​ On Sep 14, 2023, 8:20 PM, at 8:20 PM, john wrote: > > >> On Sep 13, 2023, at 21:01, sunfish62--- via gnucash-user

Re: [GNC] Porting Auto Completion from v4 to v5

2023-09-14 Thread sunfish62--- via gnucash-user
So, I don't know whose experience is more true. >> >> David T. >> On Sep 14, 2023, at 8:20 PM, john wrote: >> >> >> On Sep 13, 2023, at 21:01, sunfish62--- via gnucash-user > wrote: >> >> Hello, >> >> In another thread, it was

Re: [GNC] Request for the addition of the SLE (Sierra Leone Leone (New)) currency...

2023-09-14 Thread sunfish62--- via gnucash-user
Since GnuCash bases its currency lists on the ISO standard, presumably a specific enhancement request for this to be added would be unnecessary, and patience will see the desired result? ⁣David T. ​ On Sep 15, 2023, 2:26 AM, at 2:26 AM, Murugan Muruganandam wrote: >please raise a enhancement

Re: [GNC] Importing stock prices from a CSV file

2023-09-29 Thread sunfish62--- via gnucash-user
I'll refer you to a process I sent in to the lists a while back. https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html ⁣David T. ​ On Sep 30, 2023, 1:38 AM, at 1:38 AM, flywire wrote: >I'll work with the Price Import Assistant druid. Is it actually >documented? >I found >htt

Re: [GNC] Columns

2023-10-08 Thread sunfish62--- via gnucash-user
Hi, Welcome to GnuCash! You can add columns to the Chart of Accounts by clicking the triangle at the upper right corner of the accounts page. ⁣David T. ​ On Oct 8, 2023, 10:41 AM, at 10:41 AM, Jose Fuenzalida wrote: >Hi , my name is Jose and I stared using Gnucash about a month ago and I

Re: [GNC] Arranging column sizes

2023-10-08 Thread sunfish62--- via gnucash-user
Hi, You don't quite say what exactly you're doing that isn't working, but does this help? https://www.gnucash.org/docs/v5/C/gnucash-guide/basics-running-gnucash.html#basics-register2 ⁣David T. ​ On Oct 8, 2023, 10:52 AM, at 10:52 AM, Veli Izzet wrote: >Hi, > >I am using 5.4-1 on W11. > >I a

Re: [GNC] GnuCash_user: rounding errors and significant digits

2023-10-08 Thread sunfish62--- via gnucash-user
FWIW, Jeff reported his problem in 2014, and was happy when Derek advised him to enter the number of shares and the total dollar amount of the transaction, leaving the price to be calculated. I'm not sure whose problem is being solved by this drawn out discussion. ⁣David T. ​ On Oct 8, 2023,

Re: [GNC] I need basic help

2023-10-23 Thread sunfish62--- via gnucash-user
Doesn't Chapter 2.1 Accounting Concepts cover exactly this? ⁣David T. ​ On Oct 22, 2023, 11:46 PM, at 11:46 PM, David Cousens wrote: >Adrien, > >This needs to make it into the Basics section of the Guide. I am >planning to >revise it when I get a break from grandchildren and other activities i

Re: [GNC] I need basic help

2023-10-25 Thread sunfish62--- via gnucash-user
While the generic subject line of this thread could cover practically any subject (and seemingly has), I'd like to recommend that users get in the habit of creating new threads for new topics. ⁣David T. ​ On Oct 25, 2023, 8:23 PM, at 8:23 PM, Fred Tydeman wrote: >At top left of screen, click

Re: [GNC] Gnucash 5.4 process stays running after closing Gnucash

2023-11-11 Thread sunfish62--- via gnucash-user
That's a known bug that's been fixed. The fix will appear in the next release. ⁣David T.​ On Nov 11, 2023, 9:29 PM, at 9:29 PM, Ruaraidh Sackville Hamilton wrote: >I've just upgraded from 4.14 to 5.4 on Windows 11 and have noticed that >the >latest log file now remains open and locked even afte

Re: [GNC] Reconciling Accounts, Month 6, but not Months 1-5?

2023-11-12 Thread sunfish62--- via gnucash-user
Further to these answers, you could simply select the June statement, enter that closing balance listed when prompted, and start by selecting everything prior to that month's statement. Then continue reconciling June as normal. If the closing balance in GnuCash matches the statement balance whe

Re: [GNC] Is it safe to change description of reconciled translation?

2023-11-14 Thread sunfish62--- via gnucash-user
Changing the description won't change the reconciled status of a transaction in most versions of GnuCash. There was a period of time when any edits of a reconciled transaction would cause everything associated with the transaction to de-reconcile, but maybe you're not using one of those versio

Re: [GNC] Moving from Quicken

2024-01-06 Thread sunfish62--- via gnucash-user
Yes. These topics are all covered in the documentation and the wiki. ⁣David T.​ On Jan 7, 2024, 4:50 AM, at 4:50 AM, barry milliken wrote: >I've been frustrated using Quicken for years. Maybe GNUcash will do >what I want. > >My list of functions is small: >I use Quicken for personal accounting

Re: [GNC] QIF import Failed

2024-01-07 Thread sunfish62--- via gnucash-user
The problem with that Wikipedia article is that it focuses solely on Quicken, but the QIF format has essentially become an open format that other applications use (and implement). Since that article doesn't mention the designation of bracketed accounts as fitting in any particular category, it

Re: [GNC] Moving from Quicken

2024-01-08 Thread sunfish62--- via gnucash-user
For the record, the US tax features in GnuCash function by assigning accounts to specific tax lines, much like your approach. It's helpful insofar as it guides your accounting decisions (what types of entries I need to track for tax purposes, etc.), but it doesn't make your decisions for you.

Re: [GNC] End of Year?

2024-01-13 Thread sunfish62--- via gnucash-user
https://wiki.gnucash.org/wiki/Closing_Books Does that cover it? ⁣David T.​ On Jan 13, 2024, 4:25 PM, at 4:25 PM, Adrien Monteleone wrote: >You could add A2b: > >Export your Chart of Accounts and write down the ending balances as >needed. Start a new file, import your exported chart of account

Re: [GNC] How can I visualize financial spending in gnucash?

2024-02-03 Thread sunfish62--- via gnucash-user
Personally, I'd export the data I wanted (from a report, say) to a spreadsheet. ⁣David T. ​ On Feb 3, 2024, 7:09 PM, at 7:09 PM, Phyllis Bruce wrote: >🤣🤣🤣 > > >> On Feb 3, 2024, at 9:53 AM, G R Hewitt wrote: >> >> 'Visualise' is the horizontal wavy line that hovers in your field of >> vision

Re: [GNC] Advanced portfolio report picking up wrong price

2024-02-03 Thread sunfish62--- via gnucash-user
Still nope on the screenshot. Images must be attached, not inline. ⁣David T. ​ On Feb 3, 2024, 10:14 PM, at 10:14 PM, Dan O'Brien wrote: >(With screen shot attached this time). > >I can’t make heads or tails of scheme code, so I’m not sure where to >even look for the issue here. > >I’m using th

Re: [GNC] New user error (was: gnucash-user Digest, Vol 251, Issue 12)

2024-02-07 Thread sunfish62--- via gnucash-user
Also, you need to read the manual to understand double entry accounting and its implementation in GnuCash. (Stephen's previous reply to your question about Equity applies here as well.) And GnuCash list etiquette. ⁣David T. ​ On Feb 7, 2024, 5:27 PM, at 5:27 PM, accounting Billing wrote: >A

Re: [GNC] New user error (was: gnucash-user Digest, Vol 251, Issue 12)

2024-02-07 Thread sunfish62--- via gnucash-user
You keep entering the second entry in your transaction **into the same account you're in. ** Think of it this way, you take $20 out of your right pocket, and then put $20 into your right pocket. Assuming your right pocket started with $20, how much is left after this transaction? ($20) GnuCas

Re: [GNC] New user error (was: gnucash-user Digest, Vol 251, Issue 12)

2024-02-07 Thread sunfish62--- via gnucash-user
Your register shows transactions. They add up to zero (as I and others have noted)  and so don't show in the Chart of Accounts. RTFM ⁣David T. ​ On Feb 7, 2024, 9:40 PM, at 9:40 PM, accounting Billing wrote: >I think this is a technical difficulty. Because none of the >transactions >are show

Re: [GNC] New user error (was: gnucash-user Digest, Vol 251, Issue 12)

2024-02-07 Thread sunfish62--- via gnucash-user
Agreed. ⁣David T. ​ On Feb 7, 2024, 10:02 PM, at 10:02 PM, Patrick James wrote: >After suggesting that the manual was read, and that "the double entry >is understood," at some point the best answer becomes "it's time to >hire an accountant." > >>

Re: [GNC] New user error (was: gnucash-user Digest, Vol 251, Issue 12)

2024-02-08 Thread sunfish62--- via gnucash-user
Sure. Is that short enough for you? ⁣David T.​ On Feb 8, 2024, 8:17 AM, at 8:17 AM, Fred Bone wrote: >On 07 February 2024 at 22:17, sunfis...@yahoo.com said: > >> Agreed. >> >> ⁣David T. > >followed by 15k of someone else's message including quotes about six >levels deep featuring the whole

Re: [GNC] borrom margins on pdf export

2024-03-02 Thread sunfish62--- via gnucash-user
Or save the report to HTML, open in a browser, and print.  ⁣David T. ​ On Mar 1, 2024, 6:46 PM, at 6:46 PM, Murugan Muruganandam wrote: >you can alter the bottom margins from file->page setup. > >you may have to do couple of trials to get it correct. again each >report you may have different m

Re: [GNC] Blank reports

2024-03-03 Thread sunfish62--- via gnucash-user
So, If you think it's theme related; naming the theme might help. Also, to me, the theme you choose is beyond the GnuCash scope. And you don't explicitly say, but it appears you're running GnuCash 5.5 on Fedora 39, based on the package name. As I happen to have Fedora 39 running here, I hav

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

2024-03-11 Thread sunfish62--- via gnucash-user
I'll note that because GnuCash keeps a running really of the amount needed to balance the transaction, users adding a new line to that transaction can get confusing results. For example, a user adds a new transaction for a grocery store and places a left column entry for $35 assigned to Expens

Re: [GNC] Scheduled Transactions

2024-03-23 Thread sunfish62--- via gnucash-user
Weekly, every 4 weeks ⁣David T.​ On Mar 23, 2024, 8:45 AM, at 8:45 AM, David Jordan wrote: >Hello, > > > >I am trying to schedule a Deposit transaction that is paid every 4 >weeks >(i.e. 13 times per year) but unlike Quicken GNUCash doesn't seem to >allow a >scheduled transaction that happens

Re: [GNC] Updating gnucash

2024-03-26 Thread sunfish62--- via gnucash-user
The update process depends on your operating system. But keep in mind that GnuCash is only up to 5.5 (soon to be 5.6). ⁣David T.​ On Mar 27, 2024, 4:35 AM, at 4:35 AM, Nathan Rosenthal wrote: >I am currently running version 4.12 for two different organizations. > >If I was to update to 5.12 wo

Re: [GNC] Finance::Quote Default Currency Module

2024-03-31 Thread sunfish62--- via gnucash-user
In recent years, I've been using GnuCash on Windows machines, and the idea of environment variables is foreign, so providing that option is, perhaps, less than ideal. Although the developers of GnuCash dislike it, I wonder whether it would be possible to have a user-visible setting for the cur

Re: [GNC] ANNOUNCE: GnuCash 5.6 Released

2024-04-02 Thread sunfish62--- via gnucash-user
Upgrading is usually pretty straightforward, but it differs depending on your OS and platform. For example, on Windows, the new version uninstalls the earlier version, regardless. On Mac, you drag the new version into Applications (but you can keep earlier versions with simple renaming). On Linu

Re: [GNC] IRA conversion

2024-04-06 Thread sunfish62--- via gnucash-user
I am not really knowledgeable in this area (or many other areas, to be honest), but I found the following discussion (in a Quicken forum) that might lead you towards an answer: https://community.quicken.com/discussion/7931315/tax-summary-report-does-not-include-income-for-conversions-to-roth-ira

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-06 Thread sunfish62--- via gnucash-user
That's not always the case. Some brokerages (Schwab, for example) pull the money into an account directly, from which shares are purchased at some later date. It's essentially a cash based asset account, but it doesn't appear separately to the user. One way to handle this is to place these tran

Re: [GNC] Forgotten Splits

2024-04-07 Thread sunfish62--- via gnucash-user
Phyllis, I have many questions about this issue. 1. Are you importing the transactions with all their splits defined, and splits within those imported transactions are not actually getting in to the GnuCash data file? 2. Are you importing a record from another account (for instance, your ch

Re: [GNC] IRA conversion

2024-04-07 Thread sunfish62--- via gnucash-user
Again, nothing that I'm no expert: It seems to me that your solution has four splits, while mine has... four splits. Depending on the actual event, either could be valid. For example, a conversion between accounts at a single brokerage might look like your example, while one from one brokerage

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread sunfish62--- via gnucash-user
In the past, I have used a Google sheet that captured all my stock prices in one fell swoop, using Google's financial functions and a pasted copy of the Advanced Portfolio report. I put the AP in one tab, and retrieve all quotes using references in a second tab. Save the sheet as CSV, which can

Re: [GNC] FYI Web tables, CSV, prices info and inquiry

2024-04-12 Thread sunfish62--- via gnucash-user
Several years back, I sent this in to the list: https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html Pretty sure it still works. ⁣David T. ​ On Apr 12, 2024, 10:02 PM, at 10:02 PM, "David G. Pickett via gnucash-user" wrote: >Not all users know that the nice table of your s

Re: [GNC] Finance::quote YahooJSON

2024-04-12 Thread sunfish62--- via gnucash-user
n convert them to semi-colon separated files >through LibreOffice Calc, and then it works. > >/Jacob > >On 2024-04-11 17:16, sunfish62--- via gnucash-user wrote: > >> In the past, I have used a Google sheet that captured all my stock >> prices in one fell swoop, using Go

Re: [GNC] FYI Web tables, CSV, prices info and inquiry

2024-04-13 Thread sunfish62--- via gnucash-user
David, My goal in the example was not pedagogical; it was to give others in the community information that they might use for themselves. I'm pretty sure that in the earlier thread, I gave all the information necessary (including actual cell formulae) for others to test it for themselves. If m

Re: [GNC] Please address broken QIF import

2024-04-24 Thread sunfish62--- via gnucash-user
While I am uncomfortable with Jim's overall tone, he makes valid points to consider. Also, https://code.gnucash.org/builds/win32/releases/gnucash-5.6-1.setup.exe was pushed out a couple of weeks ago and announced as a fix to an import problem, I believe. I admit I don't pay too much attention

Re: [GNC] QIF imports fails in 5.6

2024-04-26 Thread sunfish62--- via gnucash-user
That's a known issue that is being worked on. ⁣David T. ​ On Apr 27, 2024, 8:23 AM, at 8:23 AM, coolnodje wrote: >Hi, > >QIF imports is failing in 5.6. >I had to revert to 5.5 to be able to be able ro import as usual. > >The error message is "Missing QIF investment action for transaction >date

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread sunfish62--- via gnucash-user
For your example, I simply use a report that subtotals by description. One account (Expenses:Charity). Each transaction uses the charity name for the description. Report Subtotal set to use Description. Report tells me each charity and its annual total. Easy. As for why this hadn't been implem

Re: [GNC] Delay during data entry

2024-05-01 Thread sunfish62--- via gnucash-user
My 4.12 copy on my older Windows 10 laptop has had significant delays (2-4 secs) for a couple of years now. I've chalked it up to my particular hardware configuration. ⁣David T. ​ On May 1, 2024, 8:28 AM, at 8:28 AM, David Carlson wrote: >The delay is much shorter in very recent releases such

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread sunfish62--- via gnucash-user
Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread sunfish62--- via gnucash-user
Further to the point, I've used Google Sheets financial functions to retrieve stock prices pretty quickly. Those functions can pull prices for any given date, so you could set some dates and import them that way. It's not ideal, but it could get things done in a pinch. ⁣David T. ​ On May 10,

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread sunfish62--- via gnucash-user
And if your currency is using character strings ("USD", "CHF", etc.), you can customize the currency designator so that Excel can process them. ⁣David T. ​ On May 19, 2024, 8:50 PM, at 8:50 PM, "Stan Brown (using GC 4.14)" wrote: >On 2024-05-19 09:39, David Long wrote: >> When I copy data fro

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-28 Thread sunfish62--- via gnucash-user
Generally, I find that transactions ONLY get dereconciled due to an action I have taken-- like changing some element of said transaction. They don't just "get unreconciled"-- at least, not for me. There was a short period of time where the app was very strict about when a transaction was dereco

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

2024-05-30 Thread sunfish62--- via gnucash-user
With all due respect, most of the issues raised by Peter are covered in some way in section 2.9.4 of the Guide, especially in the notes and warnings embedded there. A deeper exploration of the different methods a user can implement to recover from some of these more challenging situations migh

Re: [GNC] Adding ASSETS & LIABILITIES to sub accounts

2024-05-31 Thread sunfish62--- via gnucash-user
Thanks for the insights. For the record, the app you're intending to reference is "skrooge" not "skoorage". ⁣David T. ​ On Jun 1, 2024, 8:20 AM, at 8:20 AM, Paras Desai wrote: > >On 31-05-2024 20:46, gnucash-user-requ...@gnucash.org wrote: >> Re: [GNC] Adding ASSETS & LIABILITIES to sub account

Re: [GNC] Problem with New Account Creation

2024-06-01 Thread sunfish62--- via gnucash-user
Multiple screens? ⁣David T.​ On Jun 1, 2024, 6:30 PM, at 6:30 PM, Bruno Barros wrote: >Recently starting having trouble creating new accounts. When I right >click >and select the New Account option, GnuCash "flashes" (as if the GnuCash >window is getting selected and then deselected) but no pop

Re: [GNC] Delete acct + move txns - can't specify acct

2024-06-02 Thread sunfish62--- via gnucash-user
Is the missing account set to Placeholder? ⁣David T. ​ On Jun 3, 2024, 1:22 AM, at 1:22 AM, Chris Skudder wrote: >I'm on Flathub 5.4.1, on Xubuntu 22.04 (xml db). > >I tried to delete a closed checking acct, and move the transactions to >another checking acct. > >When in the "Delete Acct" dial

Re: [GNC] Can I set an option to stop auto-fill ?

2024-06-03 Thread sunfish62--- via gnucash-user
It doesn't exist. ⁣David T. ​ On Jun 3, 2024, 11:00 PM, at 11:00 PM, Mark at Lorimark wrote: >I don't see an option to turn off the auto-complete. > >~mark petryk >~w:http://www.lorimarksolutions.com > >On 6/3/24 14:44, fromvendor wrote: >> Hi y'all! >> >> I am finding the auto-complete funct

Re: [GNC] Selling security using specified (arbitrary) lots

2024-06-22 Thread sunfish62--- via gnucash-user
Actually, the lot manager allows a user to select specific lots for a sale. I was impressed by this aspect of the lot manager. However, be aware that the manager will recalculate already-cleared transactions without notice, which is a primary reason why I don't use lots any more. Presumably, i

Re: [GNC] Imbalance Records with zero amounts

2024-06-27 Thread sunfish62--- via gnucash-user
Paul, When you press ENTER, you commit the transaction, thus creating a permanent split that must be deleted. Were you to press TAB to navigate to the next split, the transaction would not yet be committed, and the temporarily-created imbalance split *should* be removed when it returns to ze

Re: [GNC] Entering Stock Demerger, with reduced cost base

2024-07-21 Thread sunfish62--- via gnucash-user
Not an expert, but if you create a transaction that creates 48 TGS shares at the assumed value (against the cost basis of FGL), wouldn't that get you across the line? The sale of FGL is secondary to this, except insofar as it helps define what 79.96% is. I'll note that this sale value most lik

Re: [GNC] Check & Repair

2024-07-21 Thread sunfish62--- via gnucash-user
ISTR that the feature runs silently, and that in recent versions it runs rather quickly, such that the user doesn't even see any action. I agree it would be nice to have some concluding pop-up for informational purposes. ⁣David T. ​ On Jul 22, 2024, 5:57 AM, at 5:57 AM, Art Chimes wrote: >I d

Re: [GNC] Tracking Unrealized Capital Gains

2024-07-23 Thread sunfish62--- via gnucash-user
That's a very interesting approach, and one that I'll be looking into. The crux for me will be whether the return on time invested will be worth it. Others have made their points on the topic already, so I'll just focus on your second question. Personally, I'd go with the single account approach

Re: [GNC] Move working files

2024-08-11 Thread sunfish62--- via gnucash-user
David, I agree. Additionally, there are many different ways to remedy the situation-- as noted by others in the thread (omitting log files for backup, for example). Moreover, it doesn't take a huge effort to work out your own solution. I, for example, took a half hour and threw together the fo

Re: [GNC] Stock w/ no shares, but get quotes

2024-08-18 Thread sunfish62--- via gnucash-user
I haven't looked recently, but can you add the Get Online Quotes setting to the security listing? I thought that was possible... that would at least allow you to see it. ⁣David T. ​ On Aug 18, 2024, 9:21 PM, at 9:21 PM, Fred Tydeman wrote: >Is there an easy way to get a list of stocks >that

Re: [GNC] GnuCash modifications

2024-09-03 Thread sunfish62--- via gnucash-user
David, I think you misconstrue what GnuCash is and intends to be. 1. GnuCash is not multi user. As such it does not provide user based audit controls. 2. GnuCash is open source, so anyone can modify the code base, when following GPL guidelines. The GnuCash developer base is exceedingly smal

Re: [GNC] Turn off automatically saving changed transaction

2024-09-03 Thread sunfish62--- via gnucash-user
You are looking for Reset Warnings. https://lists.gnucash.org/docs/C/gnucash-manual/reset-warning.html ⁣David T.​ On Sep 3, 2024, 1:01 PM, at 1:01 PM, Keith Lewis wrote: >Previously, if I edited a transaction and then clicked in another >transaction, GNUCash would ask if I wanted to save the c

Re: [GNC] Scheduled Transaction with Currency Conversion

2024-09-04 Thread sunfish62--- via gnucash-user
In my (limited) experience, the conversion rate dialog allows you to enter a rate *or a destination amount*. I always use the destination amount in this dialog, since I know how many CHF (to use your example) I received, but never the rate to 34 decimal places, which is what GnuCash seems to wan

Re: [GNC] Adjusting Column Widths

2024-09-07 Thread sunfish62--- via gnucash-user
A couple points about editing this file: First, it should go without saying that you should edit the file when GnuCash is not/not running. Second, while the gcm file manages a major portion of the UX, it does not (I believe) disrupt GnuCash actually running-- and it has no bearing on your fi

Re: [GNC] Detailed Search

2024-09-07 Thread sunfish62--- via gnucash-user
I use the approach that Tommy describes for my charitable donations and it works pretty well for comparing a moderate number of entries. I created two reports that are identical except for the date range (one for current year, the other for previous) and put them side by side on a multi column r

Re: [GNC] Project and Design Documentation

2024-09-07 Thread sunfish62--- via gnucash-user
I haven't seen that page mentioned in the lists; do you mean that there have been discussions on the list related to GnuCash design generally? If the latter, then I'd point out that a wiki page covering this active project's design and development that has seen edits only once every three year

Re: [GNC] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?

2024-09-09 Thread sunfish62--- via gnucash-user
Can't resist noting that using a Raspberry Pi in this way can be very slow. Using USB for file transfer and storage is a bottleneck that loses its luster after a time. ⁣David T. ​ On Sep 10, 2024, 2:31 AM, at 2:31 AM, Kalpesh Patel wrote: >Raspberry PI can handle USB drives no problem -- get

Re: [GNC] Vendor posting

2024-09-10 Thread sunfish62--- via gnucash-user
All of which begs the questions that Derek asked earlier: do you have accounts of *type* A/P and A/R, and are they in the proper currency? ⁣David T.​ On Sep 10, 2024, 9:05 AM, at 9:05 AM, David Cousens wrote: >Heidi, > >The invoice/bill dialogue automatically posts an invoice or bill to >Accou

Re: [GNC] New Australian user questions

2024-09-10 Thread sunfish62--- via gnucash-user
If it were me, I'd just register everything in AUD, as an earlier person suggested. If everything comes through PayPal as AUD, why engage in this complexity? Is there a compelling reason to track costs in the original currencies? Having lived in a number of different countries around the world

Re: [GNC] need help with Vendor post bill

2024-09-10 Thread sunfish62--- via gnucash-user
Geoff, I believe that the business features allow tracking by vendor *without* using the multiple accounts you mention. Others might be able to confirm this better than I, though. ⁣David T. ​ On Sep 11, 2024, 3:15 AM, at 3:15 AM, Geoff Jankowski via gnucash-user wrote: >Hi Heidi, > >You sho

Re: [GNC] Heidi still can't Edit company name.

2024-09-15 Thread sunfish62--- via gnucash-user
It appears there is some disconnect here. Heidi, when you say you want to edit the company name, to what name do you refer? Since you keep telling us that changing the company name in Preferences isn't working, I suspect you're referring to the text that appears in the title bar of the applica

Re: [GNC] cut/paste problem in 3.4?

2019-07-02 Thread sunfish62--- via gnucash-user
Paul, I don't use the cut and paste transaction feature. If I want to move a transaction, I will change the account assignment for that split, which effectively moves the transaction from one register to another. I would wonder at the utility of cut and paste in this example. A transaction contai

Re: [GNC] Bulk export/import of transactions?

2019-07-05 Thread sunfish62--- via gnucash-user
Ok. This comes up from time to time. Others may chime in with additional pointers, but here's how I'd go about it. 1) I would change the date of the Opening Balance transaction to the day before your starting date (December 31, 2017 for example), and change the amounts of both lines in this tra

Re: [GNC] ANNOUNCE: GnuCash 5.9 Released

2024-10-13 Thread sunfish62--- via gnucash-user
Try www.gnucash.org ⁣David T. ​ On Oct 13, 2024, 1:45 PM, at 1:45 PM, Boniforti Flavio wrote: >Hi all. >Does anybody know when the latest 5.9 release will be available for >Windows >via winget? >F. > >Adrien Monteleone schrieb am So., 13. >Okt. >2024, 03:20: > >> Joseph, >> >> Those are the d

Re: [GNC] ANNOUNCE: GnuCash 5.9 Released

2024-10-13 Thread sunfish62--- via gnucash-user
Perhaps I should be a little verbose, and say that GnuCash has its own installation package available at www.gnucash.org. I'm not exactly sure why you'd need to use a package manager to install it. ⁣David T. ​ On Oct 13, 2024, 5:20 PM, at 5:20 PM, "sunfis...@yahoo.com" wrote: >Try www.gnucas

Re: [GNC] ANNOUNCE: GnuCash 5.9 Released

2024-10-13 Thread sunfish62--- via gnucash-user
Then you should ask the maintainers of winget when (or whether) they plan to add GnuCash to their system. ⁣David T. ​ On Oct 13, 2024, 6:07 PM, at 6:07 PM, Boniforti Flavio wrote: >Simply because I rely on winget to keep all my applications updated. >F. > >sunfis...@yahoo.com schrieb am So.,

Re: [GNC] ANNOUNCE: GnuCash 5.9 Released

2024-10-13 Thread sunfish62--- via gnucash-user
a reasonable first assumption though, to ask on this list. >(or the -dev list) > >Regards, >Adrien > >On 10/13/24 10:23 AM, sunfish62--- via gnucash-user wrote: >> Then you should ask the maintainers of winget when (or whether) they >plan to add GnuCash to their system. > >

Re: [GNC] How to handle the renaming of stocks

2024-10-12 Thread sunfish62--- via gnucash-user
I thought you could just change the name in the stock editor and also change the ticker symbol. At least, I've done that before, I think. Can't you? I'll note that if you change the identity of the asset, the entire history will use the new nomenclature. Technically, you would be better creatin

Re: [GNC] Database backend for gnucash?

2024-10-12 Thread sunfish62--- via gnucash-user
Indeed, there does appear to be a (large) gap in terms of instruction regarding the database back ends. Having been around for a long time (back to 2006 or so), I remember the implementation. There has been a lot of instruction on this topic in the lists over the years, and I seem to recall so

Re: [GNC] Convert xml <-> sqlite on command line

2024-10-07 Thread sunfish62--- via gnucash-user
I guess I'd just ask what the purpose would be. Why change back and forth? If you need SQL for some purpose (e.g., to probe your financial data outside of GnuCash) then why not keep the data in SQL all the time? I generally don't have that need, so I've kept my data in xml, but I've occasiona

Re: [GNC] gnucash stackoverflow tag

2024-10-05 Thread sunfish62--- via gnucash-user
Just noting that the referenced page was created 15 years ago and states that it has 250 views over that time. The "recent" hot topic is on envelope budgeting, which is a corner use case for GnuCash. And it's 15 months old. While it's commendable to increase information flow, I wonder whether t

Re: [GNC] Negative stock dividend

2024-10-05 Thread sunfish62--- via gnucash-user
How does a negative dividend work? I've never heard of one. Does the company force shareholders to pay more money to keep their shares? ⁣David T. ​ On Oct 5, 2024, 5:51 PM, at 5:51 PM, Fred Tydeman wrote: >Will Gnucash work with a stock dividend that is negative? >

Re: [GNC] Negative stock dividend

2024-10-05 Thread sunfish62--- via gnucash-user
Actually, now that you describe it, I've had many such transactions, although the brokerage called them "adjustments". I've always just entered them the same as other dividends, with the amounts reversed. It's never caused any problems. ⁣David T. ​ On Oct 5, 2024, 7:19 PM, at 7:19 PM, R Losey

Re: [GNC] Font size

2024-10-19 Thread sunfish62--- via gnucash-user
For the record, AppData is hidden by default in Windows. You can tell Explorer to display hidden files and folders, but It is possible to open it in Explorer without changing the setting by typing %APPDATA% in the address bar. ⁣David T. ​ On Oct 19, 2024, 3:49 PM, at 3:49 PM, Ken Pyzik wrote:

Re: [GNC] Thank you to developers

2024-10-21 Thread sunfish62--- via gnucash-user
But not after you've imported them. You assign them during import, and that's when it learns. ⁣David T. ​ On Oct 22, 2024, 12:18 AM, at 12:18 AM, Derek Atkins wrote: >Theoretically you can "train" it... >-derek > >On Mon, October 21, 2024 4:54 pm, William Prescott wrote: >> I used a .qfx file.

Re: [GNC] Set up a security, what now?

2024-10-16 Thread sunfish62--- via gnucash-user
I am no expert, but I see that you have the namespace as ARCA. What happens if you change it to NYSEARCA? I've seen quotes fail when this is entered incorrectly, although it may not change anything. ⁣David T. ​ On Oct 16, 2024, 10:52 PM, at 10:52 PM, Boniforti Flavio wrote: >I think it's not

Re: [GNC] Set up a security, what now?

2024-10-16 Thread sunfish62--- via gnucash-user
It's not automatic. You trigger it from Tools-> Price Database -> Get Quotes ⁣David T. ​ On Oct 16, 2024, 11:45 AM, at 11:45 AM, Boniforti Flavio wrote: >Hi John. >Sure, you're right! Found it. > >Now, seems that the value is not updating. I've added the VT security, >but >in the list I still s

Re: [GNC] Font size

2024-10-22 Thread sunfish62--- via gnucash-user
My suspicion is that Phyllis is not aware that Windows Explorer has put the local drives into a container that displays as "My Computer." Were she to open this, she would see C: listed as one of the resources that can be opened. ⁣David T. ​ On Oct 23, 2024, 7:47 AM, at 7:47 AM, "Stan Brown (us

Re: [GNC] Showing account totals as of today

2024-10-28 Thread sunfish62--- via gnucash-user
FWIW, the "Present" value is also displayed in the footer of the account register. As someone else noted, the register also includes by default a thick blue line to separate past entries from future ones. ⁣David T. ​ On Oct 28, 2024, 8:03 PM, at 8:03 PM, R Losey wrote: >It's called "Present"

Re: [GNC] Character size adjustment

2024-10-22 Thread sunfish62--- via gnucash-user
Odd that you should bring this up at this very moment. Try looking at the thread that begins at: https://lists.gnucash.org/pipermail/gnucash-user/2024-October/113708.html ⁣David T.​ On Oct 22, 2024, 11:36 AM, at 11:36 AM, SFR via gnucash-user wrote: >Naive (as usual), > >Moved from W10 to W1

Re: [GNC] Changing fonts

2024-10-24 Thread sunfish62--- via gnucash-user
Just a note about Notepad: it is quite insistent about creating only txt files. If you save your file as "gtk-3.0.css" *without* setting "Save as type" to "All Files (*.*)", Notepad will save your file as "gtk-3.3.css.txt" And that won't work for GnuCash. David T. ​ On Oct 24, 2024, 6:49 AM,

Re: [GNC] Dealing with mutual funds

2024-11-04 Thread sunfish62--- via gnucash-user
Note: I am not an accountant, and am based in the US, whose laws will differ from Switzerland's. I agree that the Dividends account belongs under Income. As an overview, Richard, I'd point out that if you buy something for 1000, and 10 of the cost is for tax (or delivery, or service charges, o

Re: [GNC] Error deleting scheduled transaction split

2024-11-01 Thread sunfish62--- via gnucash-user
I experience this in normal transactions as well. To your point regarding the strength of the anchor, I've found that clearing the fields in the split and tabbing off the end will allow you to delete that same split without raising the error. ⁣David T. ​ On Nov 2, 2024, 12:46 AM, at 12:46 AM,

Re: [GNC] Setting up a Transaction Report

2024-11-01 Thread sunfish62--- via gnucash-user
I think you can accomplish this using the Transaction Report and adjusting the settings accordingly. Have you tried that? There is also the report that is available when you are in the register in question (I'm forgetting its name)... ⁣David T. ​ On Nov 2, 2024, 8:52 AM, at 8:52 AM, Megan Tille

Re: [GNC] Dealing with mutual funds

2024-11-08 Thread sunfish62--- via gnucash-user
The point for me is that (for the US at least), separating out the fees and commissions actually masks the true cost of the investment. When I first started tracking investments, I separated the fees and commissions, and it took me forever to figure out why my gains calculations never matched th

Re: [GNC] "Starting Balance", Reconcile Window, Reconciling Credit Card Statement

2024-11-08 Thread sunfish62--- via gnucash-user
An alternative is simply to take the latest statement you have and reconcile everything up to and including the transactions in the statement you are using. Presumably, if everything is OK, then the closing balance should match. Of course, any discrepancies force you to follow David C.'s advice.

Re: [GNC] "Starting Balance", Reconcile Window, Reconciling Credit Card Statement

2024-11-08 Thread sunfish62--- via gnucash-user
I see that your original question, "Where does the Starting Balance come from?" was not answered. The starting balance is calculated from *all* the transactions in the register that are marked as reconciled already. Past, present, and future (if you happen to accidentally create a transaction

Re: [GNC] Font size

2024-10-23 Thread sunfish62--- via gnucash-user
David C., She's rooting around in hidden system folders because that's where GnuCash stores the application font settings. Phyllis, I agree with you that this is not particularly user friendly. Unfortunately, I cannot see your computer to guide you. Suffice to say that if your computer is act

  1   2   3   >