Re: [GNC] Change account type by editing XML?

Just fishing, but wouldn't the signs change if you moved an asset account, say, to expenses? How would/should GnuCash handle existing transactions in such a moved account? David T. Original Message From: Adrien Monteleone Sent: Sat May 02 11:53:19 GMT+05:30 2020 To: Gnucas

[GNC] How do I add stock trades?

I would like to start recording my stock trades in GnuCash (3.10). Based on the instructions I could find (https://wiki.gnucash.org/wiki/Trading_Accounts) I enabled "Trading" accounts and then created a top-level Trading account with the name "Trading". I tried to fumble through the instructions b

Re: [GNC] Change account type by editing XML?

Indeed, I clicked Edit on an Asset account and I can only change it to: Bank Cash Asset Credit Card Liability I get the first three if there is going to be a limitation, but allowing the last 2 and not allowing even another debit balanced account like Expenses? Strange. I’m starting to wonder

Re: [GNC] Working with dates in Postgresql DB

Hmm, not able to get to the .sql files yet, but the xml has things like: 2019-02-14 00:00:00 -0600 ... 2014-08-05 ... 2019-04-11 21:30:12 -0500 Still digging. It would be hard to get rid of timestamps altogether, I think, and

Re: [GNC] Mortgage repayment schedule : error while inputting million

Hi DerekPlease find the screen shot -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update y

Re: [GNC] Working with dates in Postgresql DB

Was the problem that he entered variant dates, or that GnuCash reinterpreted his Perth transactions to a new date? My point is this: if he entered transactions in Perth for the 11th, and then returned to California, and they showed the 10th, wouldn't his problem have been solved if GnuCash had s

Re: [GNC] Change account type by editing XML?

The intent of my post was to report you can't reassign transactions between Asset and Expenses accounts either using the process previously described. Yes, the account in Asset was created by the import wizard. It's nothing serious, went back to the previous file and imported again. On Sat, May

Re: [GNC] Working with dates in Postgresql DB

First off, flight time between California and Australia is something like 17 hours (to Hawaii, it's about 11), so if, after all that, you have energy to do your accounting in GnuCash, well, you're more of a masochist than I. Second, if I were to land on the 10th in California, I personally woul

[GNC] Change account type by editing XML?

No it's not specific to type A/R and/or A/P accounts. I clicked the wrong account and accidentally imported an expenses account into assets. I was expecting I could just delete it and move it to Expenses:Account but it just moved to Assets. (Import Matcher pisses me off because the account was spe

Re: [GNC] Working with dates in Postgresql DB

That's exactly what happened a few years ago to a guy from California who did some updates while visiting New Zealand. Regards, John Ralls > On May 1, 2020, at 3:16 PM, David H wrote: > > Might be a problem if you were in Perth on April 11 entering txns and then > back in California on April

Re: [GNC] Working with dates in Postgresql DB

Might be a problem if you were in Perth on April 11 entering txns and then back in California on April 10 entering further txns using today's date ? i.e. if you travelled to a timezone that was still the previous day ? Cheers David H. On Sat, 2 May 2020 at 04:35, D. via gnucash-user wrote: > I

Re: [GNC] Working with dates in Postgresql DB

I hope the posted time in DB in transactions and invoices will be the same 10:59 at least after fixing these two bugs when posting the invoices and set offsets through the lots. > > On May 1, 2020 at 21:32, mailto:sunfis...@yahoo.com)> wrote: > > > > I understan

Re: [GNC] Working with dates in Postgresql DB

I understand that a lot of debate and discussion and heartache had gone into this, so I really don't mean to be a pain, but it would seem to me that if I entered April 10, 2020 for a transaction, and GnuCash then stored 2020-04-10 HH:MM:SS (where HH:MM:SS represents any arbitrary time), if GnuCa

Re: [GNC] Working with dates in Postgresql DB

David, You're not thinking it through: It's about 11:00 on Friday 1 May here in California but it's 03:00 on Saturday 2 May in Western Australia. Chopping off the time doesn't solve anything, a point illustrated by Finfort when he pointed out that just changing the time on the errant dates woul

Re: [GNC] Change account type by editing XML?

Assuming I have understood correctly, this still doesn't allow me to change the account type. See attached screenshot of the Edit Account dialogue after having moved an account to the top level. David On Fri, 1 May 2020 at 17:57, Derek Atkins wrote: > > "Stephen M. Butler" writes: > > > On 4/29

Re: [GNC] Change account type by editing XML?

"Stephen M. Butler" writes: > On 4/29/20 11:25 AM, david whiting wrote: >> Hello, >> >> When I first set up my accounts (for a local club) I knew very little >> about accounting and misinterpreted some information I was given by an >> accountant and ended up creating some sub-accounts in Accounts

Re: [GNC] AqBanking for Canadian banks

Nelson writes: > Hello everyone. > > Just wondering if anyone was successful in setting up any Canadian banks for > online banking in GnuCash. Thanks for sharing. Do they support OFX-DC? You can check OFXHome for your bank info? Good Luck, > Please remember to CC this list on all your repli

Re: [GNC] Why do Imported Transactions NEED to be Matched?

Hi, flywire writes: > Agree that import works in small chunks (as posted previously). Does that > response cover any way of getting GUIDs on the data? The GUIDs are 100% internal to GnuCash and unique per user per object (account, transaction, etc). There is no way to add GUIDs to imports, and

Re: [GNC] Mortgage repayment schedule : error while inputting million

Hi, Sorry for the delayed response (I'm still catching up on old emails). Murugan writes: > i am new to this forum. i am trying to create a mortgage repayment schedule > for 2 Million pesos , but the formula is not picking up the value and > showing a zero. can you please let me know what i a

Re: [GNC] Customer Chargeback

Hi, I don't see any responses to this question; sorry for the delay but I am catching up on 2 months of email.. Marcell Madar writes: > Hi, > > I am trying to use the chargeback function in Gnucash. The chargeback > customer and job are both specified when I create the bill and the > "Billable"

Re: [GNC] Restoring "Unable to save to database" error?

Yes, that's exactly what I did...made a copy of the Gnucash file in another directory as a backup, then "Save As" over the old file. Worked like a charm. Eric H. Bowen e...@ehbowen.net On 5/1/2020 9:48 AM, Derek Atkins wrote: > Hi Eric, > > Sorry to respond to an

Re: [GNC] Restoring "Unable to save to database" error?

Hi Eric, Sorry to respond to an old message but I didn't see any responses and I am currently catching up on ~2 months of email.. "Eric H. Bowen via gnucash-user" writes: > I've been getting the "Unable to save to database" error whenever I > import and/or save transactions in one of my asset a

Re: [GNC] Find or search all expenses in a certain account

Hi, Sorry to respond to an old thread, but I'm catching up on 2 months of emails while I was heads-down on another project.. Gio Bacareza writes: > I'll give it a try. Thanks Adrien > > On Tue, Mar 10, 2020 at 11:41 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> That was t

Re: [GNC] Invoice Date

Adrien, Sorry for the delayed response -- I'm catching up on 2 months of emails while I was heads-down on other projects. Adrien Monteleone writes: > I forgot to mention, if you didn’t notice the ‘date opened’ field in > the pop-up, and you are already in the invoice, click the Edit Invoice > b

Re: [GNC] New User - Unique Transaction Number & Dates

Hi Stan, Sorry to respond to an old message, but I'm catching up on ~2 months of mail when I was heads-down on other projects.. Stan Brown writes: > David, you may be thinking of File » Properties » Accounts » Day > Threshold for Read-Only Transactions (red-line). > > I'm not sure why the devel

Re: [GNC] Reporting transactions

Yes :) They differ from other brokerage accounts in regulations on tax and on when and how you can withdraw funds. e.g. when you use it in retirement as your pension income, withdrawals from the fund into your normal bank account are taxed as income at the point of withdrawal (again, from a tax pe

Re: [GNC] Reporting transactions

IIUC the SIPP is simply a wrapper around stock-type and cash-type investments, so, you'd handle it exactly the same as any Broker and Broker investments. See https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-setup1.html - the SIPP wrapper would be the "Brokerage Accounts" asset. You may choos

Re: [GNC] Reporting transactions

Yes sure that's one perspective and I agree with it, and that's why I have my SIPP in the same GC file as everything else. I was just noting that the way contributions are reported (i.e. as expenses eligible for tax rebates, not as income that is taxed) seems more in line with a different perspecti

Re: [GNC] Reporting transactions

I wouldn't classify sipp contributions as expense. You'd be incorrectly reducing your net worth whenever you contribute to it. On Fri, 1 May 2020, 5:23 pm Ruaraidh Sackville Hamilton, < ruaraidh...@gmail.com> wrote: > Ah yes you are right! I didn't think of the case where an employer pays > direc

Re: [GNC] Reporting transactions

Ah yes you are right! I didn't think of the case where an employer pays directly into a SIPP. In that case it is clearly an income. Not in mine. Conceptually, it might be better thought of as a business expense. The business is the SIPP and the government encourages investment in the business by g

Re: [GNC] Superannuation Co-Vid payment

Did you read thre recommendations that David Cousens gave in: https://lists.gnucash.org/pipermail/gnucash-user/2020-May/090891.html David T. Original Message From: Chris Taylor Sent: Fri May 01 11:37:46 GMT+05:30 2020 To: gnucash-user@gnucash.org Subject: [GNC] Superannuatio