Re: [GNC] Reconciling PayPal

2022-12-14 Thread Liz
On Thu, 15 Dec 2022 09:45:15 +0300 "David T. via gnucash-user" wrote: > At paypal.com, click the Activity tab, then click the download icon > at the top right. This takes you to a hidden area that includes a tab > for Taxes and Statements. At least, that's what I see on my machine. > > ⁣David

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread Dr. David Kirkby
On Thu, 15 Dec 2022 at 05:35, David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > David, > > I'm not sure what you mean when you say "documentation," but I don't think > the Guide or the Help would be appropriate places to make such references. > Section 2.1 of the Guide gives a few

Re: [GNC] The "purpose of reconciliation" [was: Re: Reconciling PayPal]

2022-12-14 Thread Jim DeLaHunt
On 2022-12-14 23:25, Adrien Monteleone wrote: Ooh! A Can-o-Worms to munch on! (I promise to only nibble) ... nom nom nom :-) [1] https://www.urbandictionary.com/define.php?term=nom%20nom%20nom ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: [GNC] The "purpose of reconciliation" [was: Re: Reconciling PayPal]

2022-12-14 Thread Adrien Monteleone
Ooh! A Can-o-Worms to munch on! (I promise to only nibble) On 12/14/22 4:49 PM, Jim DeLaHunt wrote: On 2022-12-14 02:58, Dr. David Kirkby wrote: My understanding is that the purpose of the reconciliation is to enable one to compare that the balances of two sets of accounts are in

Re: [GNC] Reconciling PayPal

2022-12-14 Thread David T. via gnucash-user
At paypal.com, click the Activity tab, then click the download icon at the top right. This takes you to a hidden area that includes a tab for Taxes and Statements. At least, that's what I see on my machine. ⁣David T. ​ On Dec 15, 2022, 9:29 AM, at 9:29 AM, "Dr. David Kirkby" wrote: >On Wed,

Re: [GNC] Reconciling PayPal

2022-12-14 Thread Jim DeLaHunt
On 2022-12-14 22:25, Dr. David Kirkby wrote: ...Someone wrote earlier that one can get statements from PayPal. I can not see a way of doing that, even when using a desktop computer. Here are the instructions, for Paypal in the USA.

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread David T. via gnucash-user
David, I'm not sure what you mean when you say "documentation," but I don't think the Guide or the Help would be appropriate places to make such references. Section 2.1 of the Guide gives a few basic explanations on underlying accounting concepts. This section, in fact, states that "you do

Re: [GNC] QIF Import troubles

2022-12-14 Thread john
> On Dec 14, 2022, at 6:52 PM, Liz wrote: > > On Wed, 14 Dec 2022 22:26:40 + (UTC) > Steve Silva via gnucash-user wrote: > >> Hi All, >> Thanks a lot for your input. Based on your observations, I really >> don't think I am going to make gnucash work for me, I have nearly 30 >> years

Re: [GNC] Importing Transactions from CSV

2022-12-14 Thread David Cousens
Mike, Gnucash can import a single amount column with deposits as negative amounts and withdrawals as positive amounts without any problem. You may have to experiment with whether to apply the Deposits or Withdrawals header to that data column depending on how the bank has used the signs, to get a

Re: [GNC] Importing Transactions from CSV

2022-12-14 Thread rovero
I tried this myself and the positive dollars in the amount column does indeed go to the deposit column in gnucash and the negative dollars number goes into the withdraw column. I should also add the test account I used set up is a Type ( bank). Have not tried this on other Types of accounts.

Re: [GNC] QIF Import troubles

2022-12-14 Thread Liz
On Wed, 14 Dec 2022 22:26:40 + (UTC) Steve Silva via gnucash-user wrote: > Hi All, > Thanks a lot for your input.  Based on your observations, I really > don't think I am going to make gnucash work for me, I have nearly 30 > years worth of QIF data files and it seems like this odd double

Re: [GNC] Importing Transactions from CSV

2022-12-14 Thread Jim DeLaHunt
On 2022-12-14 18:15, M wrote: My credit card company... only offer the transactions in CSV format. The issue I have is they list both deposits and withdrawals in the same "Amount" column.  They signify deposits as negative amounts, and withdrawals as positive amounts. As far as I can tell,

[GNC] Importing Transactions from CSV

2022-12-14 Thread M
My credit card company recently stopped publishing their transactions in OFX format.  They now only offer the transactions in CSV format. The issue I have is they list both deposits and withdrawals in the same "Amount" column.  They signify deposits as negative amounts, and withdrawals as

Re: [GNC] Open banking platform support

2022-12-14 Thread Murugan Muruganandam
David Open banking is a practice to share information by financial institutions to 3rd party service providers. The service providers need to get explicit customer mandate to access the data and share personalized experiences. Europe has been a pioneer in this to democratize the financial data

Re: [GNC] Open banking platform support

2022-12-14 Thread David Reiser via gnucash-user
> On Dec 14, 2022, at 6:08 PM, Kalpesh Patel wrote: > > > > Bank of America is one of the banks that has stopped supporting OFX method, > in addition to Chase Bank, for transaction download via direct connect as of > early Nov and moved to the open banking platform. Is there any roadmap to >

Re: [GNC] QIF Import troubles

2022-12-14 Thread David Carlson
"Double Entry" is an accounting method that makes it more difficult to make mistakes that cannot be easily found and corrected during the process of data entry. You don't actually see the 'other side' later unless you deliberately look for it. It is not at all odd, in fact it is universally used

Re: [GNC] Open banking platform support

2022-12-14 Thread David Carlson
Is that open banking platform a different way to get a list of transactions? If so, how does it work? On Wed, Dec 14, 2022 at 5:26 PM Phyllis Bruce wrote: > Kalpesh, I found that QFX works as well. > > > On Dec 14, 2022, at 5:08 PM, Kalpesh Patel > wrote: > > > >  > > > > Bank of America is

Re: [GNC] QIF Import troubles

2022-12-14 Thread R Losey
I had used Quicken for only about 10 years when I changed over to GnuCash. I just didn't bother to import anything (it didn't work at the time anyway). I just kept Quicken data ending in year "X" and started fresh with GnuCash in year "X+1". If I needed something from before X+1, I brought up my

Re: [GNC] New PC

2022-12-14 Thread R Losey
The data file (files) are the key thing. I recently updated both my iMac (new machine) and my Linux box (disk wipe and re-install). The data files I used are stored on my home NAS, so that all computers can see the file. I did notice that I lost the reports, but since I didn't have many of them,

Re: [GNC] New PC

2022-12-14 Thread R Losey
New versions generally come out once a quarter. On Wed, Dec 14, 2022 at 3:54 PM Deborah Millington wrote: > Hello David > > I am on GnuCash version 2.6.3 on my old machine ... and to be honest had no > idea that there were any other versions available. I'm guessing that that > will be likely

Re: [GNC] Reconciling PayPal

2022-12-14 Thread R Losey
Wow... I would have thought, if one kept a balance at Paypal, it would be relatively easy to see the balances... of course, one would need to see the transactions as well. On Wed, Dec 14, 2022 at 4:58 AM Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > On Wed, 14 Dec 2022 at 03:45, R

Re: [GNC] Open banking platform support

2022-12-14 Thread Phyllis Bruce
Kalpesh, I found that QFX works as well. > On Dec 14, 2022, at 5:08 PM, Kalpesh Patel wrote: > >  > > Bank of America is one of the banks that has stopped supporting OFX method, > in addition to Chase Bank, for transaction download via direct connect as of > early Nov and moved to the open

[GNC] Open banking platform support

2022-12-14 Thread Kalpesh Patel
Bank of America is one of the banks that has stopped supporting OFX method, in addition to Chase Bank, for transaction download via direct connect as of early Nov and moved to the open banking platform. Is there any roadmap to get that supported as part of the GNC native method for download of

Re: [GNC] The "purpose of reconciliation" [was: Re: Reconciling PayPal]

2022-12-14 Thread Michael or Penny Novack
My understanding is that the purpose of the reconciliation is to enable one to compare that the balances of two sets of accounts are in agreement Interesting. I have slightly different purpose when I do reconciliation: to compare the _transactions_ of the two sets of accounts, and

Re: [GNC] QIF Import troubles

2022-12-14 Thread Phyllis Bruce
Steve, I’ve kept a copy of Microsoft Money that holds my data going back that far. Anytime I need it, I can find my old records there. I started anew with GnuCash in 2022. Might that work for you? On Wed, Dec 14, 2022 at 4:27 PM Steve Silva via gnucash-user < gnucash-user@gnucash.org> wrote: >

[GNC] The "purpose of reconciliation" [was: Re: Reconciling PayPal]

2022-12-14 Thread Jim DeLaHunt
On 2022-12-14 02:58, Dr. David Kirkby wrote: My understanding is that the purpose of the reconciliation is to enable one to compare that the balances of two sets of accounts are in agreement Interesting. I have slightly different purpose when I do reconciliation: to compare the

Re: [GNC] QIF Import troubles

2022-12-14 Thread Steve Silva via gnucash-user
Hi All, Thanks a lot for your input.  Based on your observations, I really don't think I am going to make gnucash work for me, I have nearly 30 years worth of QIF data files and it seems like this odd double entry method is something I can't control, nor can I go back through 30 years of data

Re: [GNC] New PC

2022-12-14 Thread Deborah Millington
Hello David Thanks for your reply, and for the advice which is much appreciated. Apologies for not providing the right information upfront. I'm afraid I don't tend to use this kind of mailing list format and it all feels a bit unfamiliar, so I'm probably not thinking through what I need to say

Re: [GNC] Online Banking

2022-12-14 Thread rovero
Got past the online banking setup, but now have the following: AqBanking v6.5.3.0stable Sending jobs to the bank(s) Sorting commands by account Sorting account queues by provider Send commands to providers Send commands to provider "aqofxconnect" Locking customer "2" Sending request...

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread David Cousens
Michael, I agree that rather than trying to include Accounting 101 in the GnuCash documentation is likely inapprpriate. It may be appropriate however to provide a list of basic accounting textbooks that new users can refer to including books from a number of the different jurisdictions and in the

Re: [GNC] New PC

2022-12-14 Thread David H
Deborah, You might want to read this post from Adrien about upgrading from an older version to the latest version - https://lists.gnucash.org/pipermail/gnucash-user/2020-September/093209.html Cheers David H. On Thu, 15 Dec 2022 at 06:45, David H wrote: > Hi Deborah and welcome to Gnucash. >

Re: [GNC] New PC

2022-12-14 Thread David H
Hi Deborah and welcome to Gnucash. When posting, always include your OS and current version of Gnucash as it matters and we don't want to be making too many assumptions and also what your new pc OS is. For config file Locations - read (and bookmark) the wiki -

Re: [GNC] New PC

2022-12-14 Thread Stephen M. Butler
I can help with (b)  and (c). On 12/14/22 11:51, Deborah Millington wrote: Hello, I'm looking for a bit of help please. I've used GnuCash for many years on a laptop which is now struggling to keep going. I've got a newer (second hand) laptop and need to do a one off transfer of my GnuCash

[GNC] New PC

2022-12-14 Thread Deborah Millington
Hello, I'm looking for a bit of help please. I've used GnuCash for many years on a laptop which is now struggling to keep going. I've got a newer (second hand) laptop and need to do a one off transfer of my GnuCash files to it so I can use it instead in future. I'm familiar with backing up my

Re: [GNC] Does it matter the other transactions are entered?

2022-12-14 Thread Dr. David Kirkby
On Wed, 14 Dec 2022 at 17:36, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > To each their own, but that seems like lots of work. > > You can cancel a reconciliation once started, so if you discover > transactions are missing, and can't find the data, just start over later > when

[GNC] i did it!

2022-12-14 Thread Orith
Thank you all for trying to help me to upload the Gnu 4.12 on my new Lenovo laptop with windows11. I finally followed, step by step, [ https://www.youtube.com/watch?v=OchTcwdf10U=203s] and it worked! there are changes from earlier versions and also there are no duplicates of saved files showing

Re: [GNC] QIF Import troubles

2022-12-14 Thread David Carlson
Hi Steve, As Michael suggested, it is best to start with baby steps to learn how to get good results with the import process. If you import more than one account at a time you risk getting duplicates if both accounts in a transaction are in the same import. There is a step in the import process

Re: [GNC] Online Banking

2022-12-14 Thread john
> On Dec 13, 2022, at 11:22 PM, rov...@comcast.net wrote: > > When I try to setup online banking in ver 4.12 of GNUCash nothing happens > when I click on Start Aqbanking setup. I am using windows 10. > > I checked and the and the aqbanking-cli.exe file is in C:\Program Files >

Re: [GNC] Does it matter the other transactions are entered?

2022-12-14 Thread Adrien Monteleone
To each their own, but that seems like lots of work. You can cancel a reconciliation once started, so if you discover transactions are missing, and can't find the data, just start over later when you do. Maybe I'm misunderstanding the issue? Regards, Adrien On 12/14/22 11:09 AM, Dr. David

Re: [GNC] Reconciling credit card

2022-12-14 Thread Adrien Monteleone
Glad to hear that helps! Regards, Adrien On 12/14/22 4:53 AM, Mahon Finbar wrote: "This is essentially a 'reversing' transaction. (which you could enter manually, or via Transaction > Add reversing transaction, with the original expense transaction selected)" Aha, the solution, thank you so

Re: [GNC] Does it matter the other transactions are entered?

2022-12-14 Thread Dr. David Kirkby
On Tue, 13 Dec 2022 at 17:28, Derek Atkins wrote: > Hi, > > Yes, you can enter transactions in whatever order you like. > > However you can you only RECONCILE in date-order, because reconciliation > is always "from the beginning of time". So once you reconcile, you cannot > (easily) add

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread David T. via gnucash-user
Michael, I'll note that my suggestion was specifically and purposefully to add the text to the wiki, and not to the Guide or Help. ⁣David T. ​ On Dec 14, 2022, 5:25 PM, at 5:25 PM, Michael or Penny Novack wrote: > >>> Given the length of this thread and the apparent confusion >documenting

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread Michael or Penny Novack
Given the length of this thread and the apparent confusion documenting PayPal in GnuCash, it might be helpful for someone to add a section to the wiki page at "Using GnuCash" on the different methods people have outlined. IMHO, the Guide and Help cover the overall concepts well enough. I

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread David T. via gnucash-user
I think you're thinking of so-called "suspense" accounts? It would seem to me that tracking what PayPal won't release isn't necessary in my books-- any more than I need to track when the bank freezes a large check I deposit. I just carry that balance until it can be used. David T. ​ On Dec

Re: [GNC] Reconciling PayPal

2022-12-14 Thread David T. via gnucash-user
I get pdf PayPal statements that can be downloaded, just like from my bank. ⁣David T. ​ On Dec 14, 2022, 2:00 PM, at 2:00 PM, "Dr. David Kirkby" wrote: >On Wed, 14 Dec 2022 at 03:45, R Losey wrote: > >> I assume you can reconcile an asset account like any other bank >> account you can

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread Dr. David Kirkby
On Wed, 14 Dec 2022 at 05:04, David T. wrote: > Given the length of this thread and the apparent confusion documenting > PayPal in GnuCash, it might be helpful for someone to add a section to the > wiki page at "Using GnuCash" on the different methods people have outlined. > IMHO, the Guide and

Re: [GNC] Reconciling PayPal

2022-12-14 Thread Dr. David Kirkby
On Wed, 14 Dec 2022 at 03:45, R Losey wrote: > I assume you can reconcile an asset account like any other bank > account you can tell it the date you want to reconcile, but it lists > all of the transactions... > My understanding is that the purpose of the reconciliation is to enable one to

Re: [GNC] Reconciling credit card

2022-12-14 Thread Mahon Finbar
"This is essentially a 'reversing' transaction. (which you could enter manually, or via Transaction > Add reversing transaction, with the original expense transaction selected)" Aha, the solution, thank you so much, and it works just fine when you enter the date the reimbursement was received