Re: [GNC] XML or database?
Interesting history... but I don't think I'll bother... I was forced into doing this under Quicken because the file was so large that it was unmanageable (possibly because Intuit said to do it) If that ever becomes a problem with GnuCash, I'll just make a copy of the datafiles, and then go through and delete older transactions On Mon, Nov 7, 2022 at 7:55 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 11/7/2022 7:11 PM, Kevin Buckley wrote: > > In the "old days" of pen and ink on paper accounting, it was common to > open new books each year. They were, after all, bound volumes of finite > size, that's why we say "the books". The process was: > > a) Do a "close the books" operation with all income and expense accounts > closed to equity. They are, after all, temporary accounts of fundamental > type equity. Usually this would be through first closing them to another > temporary account of type equity (profit and loss) and then THAT closed > to equity by the net profit or loss to bring into balance. > > b) At this point the only accounts with non-zero balances would be the > standing accounts of types asset, liability, and equity. Run the Balance > Sheet report.. > > c) Open the books for the new accounting period --- create the CoA with > all zero amounts and then the first transaction is the opening > transaction from the balance sheet << it would be a giant transaction, > split on both the debit and credit sides. > > You can do this with gnucash too. It is time consuming and a lot of work > if/f you have lots of accounts of type asset, liability, and equity. > Otherwise it is a snap. > > Michael D Novack > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Create New Gnucash File From Old One
On 11/7/22 15:59, Derek Atkins wrote: Hi, On Mon, November 7, 2022 1:49 pm, Joseph Hesse wrote: Hello, Here is what I want to accomplish. 1. Create a new gnucash file with the same accounts as an old one but no transactions from the old one. 2. Copy the transactions from a single account from the old gnu cash file to the new one. I can accomplish 1. by exporting the account tree from the old one to a csv file and then importing the csv file to the new one. There is an even easier way: File -> Export -> Export Accounts This will create a new data file with just the account tree, so all you need to do is File -> Open the "exported" file. I tried to accomplish 2. by exporting the transactions from the desired account on the old file to a csv file and then import the csv to the the new file. I can export the transactions but no amount of fiddling or trying options allows me to successfully import the csv file. What version of GnuCash? I *THOUGHT* that we fixed the issue where exported data could not be imported. Any help you can give me would be appreciated. Thank you, Joe Hesse Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek Derek, Thank you for your reply. I had no problem creating a new gnucash file with the same accounts as the old one but with no transactions. My problem is when I "File->Export Transactions to CSV" and choose a single account to export, I can not successfully import this account. I am using gnucash 4.12 on Fedora 36 linux. Joe ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API
Go figure. It appears that AlphaVantage changed back access to the CURRENCY_EXCHANGE_RATE API. It is no longer considered premium. A feature I liked about the CURRENCY_EXCHANGE_RATE API over the FX_DAILY API is that the former data included Crypto and Precious Metals. Will revert back F::Q in the next release. - Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API
hi Bruce thanks, is it possible to keep both the methods with an option to select the preferred . just to be safe in case of any future change from AlphaVantage Saludos Cordiales Murugan From: gnucash-user on behalf of Bruce Schuck Sent: Tuesday, November 8, 2022 8:12 PM To: gnucash-user@gnucash.org Subject: [GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API Go figure. It appears that AlphaVantage changed back access to the CURRENCY_EXCHANGE_RATE API. It is no longer considered premium. A feature I liked about the CURRENCY_EXCHANGE_RATE API over the FX_DAILY API is that the former data included Crypto and Precious Metals. Will revert back F::Q in the next release. - Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API
Bruce S wrote: >> Go figure. It appears that AlphaVantage >> changed back access to the CURRENCY_EXCHANGE_RATE API. It is no >> longer considered premium. A feature I liked about the >> CURRENCY_EXCHANGE_RATE API over the FX_DAILY API is that the former >> data included Crypto and Precious Metals. >> Will revert back F::Q in the next release. On 11/8/22 4:06 PM, Murugan Muruganandam wrote: thanks, is it possible to keep both the methods with an option to select the preferred . just to be safe in case of any future change from AlphaVantage Well, technically it is possible. But then any software that utilizes F::Q such as GnuCash would need to be modified to pass that option/argument to F::Q upon invocation. In my opinion, adding complexity to account for "what ifs" is a start down the rabbit hole. - Bruce S ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
