Re: [GNC] Securities Namespace

On Sun, Jun 5, 2022 at 1:20 AM Geoff wrote: > Q1. Use the Security Editor and type over the incorrect Namespace (in > the "Type" field). > I tried to change NONCURRENCY to Cash-Crypto by typing over NONCURRENTCY. That did not change it. Instead, it left NONCURRENCY alone and made a new Namespac

[GNC] Investment report by Namespace

Is there a way to get an Investment Report sorted and sub-totaled by Namespace? ___ 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 yo

Re: [GNC] GST Report - not showing tax amounts

Did you set the Tax accounts correctly as suggested in the report? On Sat, 4 June 2022, 3:14 am Nora, wrote: > Hi Gnucash Users, > > I'm trying to get a report that shows my last 6 months of GST/HST amounts > for both sales and expenses. > I've used the GST report - the headings are correct - l

Re: [GNC] Startup issue - two windows

Fred, Your screenshot came through, thanks. First, that looks like the Splash Screen is either hung, or you just took the screen shot before it finished. But your earlier reply seem to indicate it is hanging. (or just really slow at finishing loading and then exiting) Second, the transient

Re: [GNC] Startup issue - two windows

Fred, Just to add to what Adrian said, you can also start tip of the day from "Help" if it is causing problems during startup. Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com email __

Re: [GNC] Securities Namespace

CURRENCY and NONCURRENCY are built in; the former applies to the ISO4217 currencies that are also built in, the latter is a default for everything else that a user hasn't created a namespace for. Regards, John Ralls > On Jun 5, 2022, at 6:44 AM, Fred Tydeman wrote: > > On Sun, Jun 5, 2022 a

Re: [GNC] Startup issue - two windows

This looks like a problem with the Scheduled Transaction (SX) window rather than a general focus problem. Try this in order: 1. Uncheck: Preferences > Scheduled Transactions > Since Last Run > 'Run when data file opened'. Does the Splash still appear to hang? Can you close the Tip window?

Re: [GNC] Startup issue - two windows

On Sun, Jun 5, 2022 at 10:48 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > This looks like a problem with the Scheduled Transaction (SX) window > rather than a general focus problem. > > Try this in order: > For each of these tests, I made sure I had a scheduled transaction to r

[GNC] Transfer Dates

I have transferred money back and forth between bank1 and bank2. 1. I first imported my transactions from bank2. 2. I then imported my transactions from bank1. The transfers between the accounts are matched and are therefore not imported to bank1 (as expected). However, the dates of the transf

Re: [GNC] Transfer Dates

If you want to be exact you probably need to use something like a "Funds in Transit" account - transfer from bank2 to funds in transit on date 1 and then transfer from funds in transit to bank1 3-5 days later. Effectively you'd be splitting each transaction into 2 transactions. Cheers David H. O

[GNC] Export as text or CSV

Is there a way to export either the Accounts main screen or an Accounts Summary report as either a plain text file or a CSV file? The best I have found so far is Select via mouse the text on the multiple screens, then Ctrl-C to copy to clipboard, then Ctrl-V to paste into a file in an editor. Unfo

Re: [GNC] Transfer Dates

Mate, keep it on-list so others can offer suggestions/chip in where relevant. Case in point I NEVER import anything so I can't comment on how the matching works, others that do obviously can. I ALWAYS manually enter txns that way when I reconcile I'm not reconciling the bank's txns against the bank

Re: [GNC] Export as text or CSV

On 2022-06-05 15:19, Fred Tydeman wrote: > Is there a way to export either the Accounts main screen or an Accounts > Summary report as either a plain text file or a CSV file? > > The best I have found so far is Select via mouse the text on the multiple > screens, > then Ctrl-C to copy to clipboar

Re: [GNC] Export as text or CSV

Fred, File >> Export >> Export to CSV doesn't do it for you ? Cheers David H. On Mon, 6 Jun 2022 at 08:20, Fred Tydeman wrote: > Is there a way to export either the Accounts main screen or an Accounts > Summary report as either a plain text file or a CSV file? > > The best I have fou

Re: [GNC] Transfer Dates

I am sorry David. I hit “reply” when I should have hit “reply all”, right? I sent the previous mail to the group as well. I am importing because I am trying to create a new GnuCash file with a lot of transactions from different financial institutions; all of them are in CSV (xls). When done, I

Re: [GNC] Transfer Dates

@David, If I use an intermediary “Funds in Transit account”, wouldn’t I run into the same issue when importing bank1? It would match the original transfer date of bank2 in the “Funds in Transit account”. I would need to force it to not match. A disadvantage of using a “Funds in Transit accou

Re: [GNC] Transfer Dates

If you import from bank 1 with the transfers to a Funds in transit account as the transfer account rather than bank 2 and then import the records from bank 2 with the transfer account as funds in transit, the dates will be correct in each of the bank accounts. The funds in transit account will end

Re: [GNC] Transfer Dates

When you enter the transfer, it should be something like this in the description: In Bank 1 you would enter a credit "Transfer to Bank 2" or Bank 3, etc. with the date of the transfer and the debit account being the "in transit account". Then in Bank 2 you would enter "Transfer from Bank 1" as

Re: [GNC] Transfer Dates

@Gyle, The suggested approach may work well when entering the transactions manually and then reconciling. However, I am not entering the transactions manually. I am importing all the bank transactions, including the transfers, from several CSV files to an empty GnuCash file. From: Gyle McC

Re: [GNC] GST Report - not showing tax amounts - got it!!!

You're welcome. Please reply to the user list directly. On Sun, 5 Jun 2022 at 21:19, Nora wrote: > HI Christopher > > > > I checked on my accounts and yes they’re set up correctly and there is a > total amount in each, however, I also checked my report options and didn’t > realize I could pick m

Re: [GNC] Transfer Dates

Ah my bad, I thought you'd just replied to me and wouldn't get more advice from the list especially from the user's that do use the importers :-) Cheers David H. On Mon, 6 Jun 2022 at 10:10 am, wrote: > I am sorry David. I hit “reply” when I should have hit “reply all”, right? > I sent the pre

Re: [GNC] Export as text or CSV

On Sun, Jun 5, 2022 at 5:02 PM David H wrote: > Fred, > > File >> Export >> Export to CSV doesn't do it for you ? > Already tried that. It does not have the account values. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] Transfer Dates

Viking2ev, There is no way to automate the creation of perfect data from imperfect sources. Whatever method you choose, you will need to do some massaging manually. Sometimes it may make sense to edit a CSV file, sometimes it may make more sense to use the import matching function, or even to us