Re: [GNC] Transaction inconsistency when deleting account
Thanks for all your responses. I guess the discussion went off track here. Again, it's not a double-entry accounting issue, nor it's a split issue, but a transaction consistency issue (probably related to database transaction implementation). Let's not to discuss whether it's a good idea or not to delete an account that contains transactions. It's a valid user function in GC to delete a non-empty account. If you follow the double-entry accounting rule, the related transactions in other accounts should be deleted. Instead, the related transactions in other accounts didn't get deleted but got assigned to the default Inbalanced-USD account (so the double-entry rule still hold here!). However, if you delete the transactions individually, this problem won't occur. Transactions in double-entried accounts will be deleted correctly. The use case: I was importing credit card transactions to an account via csv. After importing, all transactions got double-entried to the default Inbalanced-USD account. After changing the Inbalanced-USDs to the correct expense accounts for all the imported transactions, I realized that I wasn't using negated amount for the credit card before importing. So I decided to get rid of the credit card account and create and re-import everything from scratch (luckily GC allows you to do this), thus the inconsistency problem. Thanks! On 9/3/23 3:12 PM, Michael or Penny Novack wrote: On 9/3/2023 2:27 PM, Jediator wrote: Hi, I'm a new GC user after using QB for many years. One problem I encountered was when I delete an account with transactions (instead of deleting transactions manually one at a time), the corresponding transactions in other accounts won't get deleted automatically. For instance, I have a payment transaction in a credit card account related to a withdraw transaction in a checking account. When I delete the credit card account with all its transactions, the related withdraw transaction still remains in the checking account. Is this a bug to be reported? No, you are not understanding a basic concept of double entry bookkeeping. Each of those transactions in the CC account you are deleting had another account associated with it (at least one other account, could be more if a "split"). When you delete an account, you are NOT deleting the transactions that were there but instead moving them (that side of them that was in the CC account) to some other account. We'll come back to that. Meanwhile, the opposite side of each of those transactions remains where it was (in the account where it was). So .. let's look at one of those payment transactions more closely. You see it there in the account of your checking account? << you said you were >> Well LOOK at one of those transactions (would be a credit to the checking account). What is NOW the debit side of that transaction. In other words, what account? THAT is what happened when you deleted the account for that CC, they were MOVED there, not deleted. You can't delete just one side of a transaction. Question1 --- you say you were a long time QB user? QuickBooks and not Quicken? Because QuickBooks is proper double entry7 bookkeeping and would work the same way as gnucash with regard to deleting an account. Of course possibly you never tried deleting an account in QuickBooks. Question2 --- WHAT are you trying to do here? Why are you deleting the account of that CC? Normally, in proper bookkeeping you do NOT attempt to change the past. If the situation is that this CC has been closed, no longer being used, balance was zero at the time when closed, the account is now INACTIVE and you don't want to see it taking up space in your CoA, the action you want is HIDE, not delete. 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. ___ 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] How to Enter Account in CSV Before Import
In order to enter a column with the Transfer Account: I Exported Account Tree to CSV. I am able to get out of that EXPENSE:"Expenses:Auto":Auto::Auto:::USD:CURRENCY:F:F:F EXPENSE:"Expenses:Auto:Fees":Fees::Fees:::USD:CURRENCY:F:F:F EXPENSE:"Expenses:Auto:Fuel":Fuel::Gas EXPENSE:"Expenses:Auto:Parking":Parking::Parking:::USD:CURRENCY:F:F:F EXPENSE:"Expenses:Auto:Repair and Maintenance":Repair and Maintenance::Repair and Maintenance:::USD:CURRENCY:F:F:F Then I extracted the "between the double quotes text". I used =REGEXEXTRACT(A49,"\""(.*?)\""") And put that in a column named "Transfer Account" Expenses:Auto Expenses:Auto:Fees Expenses:Auto:Fuel Expenses:Auto:Parking Expenses:Auto:Repair and Maintenance But when I use the Transaction Import Assistant the Transfer accounts are still unmapped. I still have to "Select a Row to Change the Mappings". That's pretty good. And if there are multiple "Expenses:Auto:Fuel", I'm still just mapping it once. And this avoids any chance that GnuCash will just create new accounts on import. On Sun, Sep 3, 2023 at 11:20 AM Geert Janssens wrote: > Op zondag 3 september 2023 15:47:26 CEST schreef Tom Balazs: > > > I'm importing checking account transactions from a CSV file. > > > > > > I see that in the Transaction Import Assistant I can > > > A. Choose Account at the top of the Assistant (Import Preview), where I > > > would designate it Checking Account #1 > > > OR I can > > > B. Choose Account as a column heading. Where I would designate it: > Expense: > > > Auto : Auto Repair > > > I can't do both. Is there a way for me to do both? > > > That might save me the trouble of having to go in an manually choose > > > account for each transaction. > > > > > > Check Account #1 Transaction ... Date: 1/1/23, Description: Bob's Auto, > > > Account: Auto Repair, Amount: 50.00 > > A transaction in GnuCash involves (at least) two accounts. > > I assume you want to import a csv file with several transactions related > to your Checking Account #1. As the example you give doesn't have a column > with this account name in it, that's probably what you want to set as your > base account. Your csv example holds the other account related to the > transaction: "Auto Repair". In the CSV importer that's known as the > "Transfer account". You should be able to select that in the list with no > issues. > > Put differently: if your csv data has two account columns, one will be > your "Account" and the other will be "Transfer Account". If you only have > one account column, the whole csv file is assumed to go into one account. > That account is what you have to set as base account. The column in your > csv data will be the "Transfer Account" in this case. > > Regards, > > Geert > ___ 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] Advance portfolio report between two dates
On 9/4/2023 1:04 PM, Paras Desai wrote: Hello Michael Thanks for your feed back. I fully agree that Dynamic COA can create havoc while comparing two period (dates) financial report. That is the precise reason, I have very precisely structured primary account and secondary sub account so far my work accounts are concern. No one can change without authorisation. No created account to be deleted even if have zero balance and so on. There is a detailed SOP implemented as how to handle COA. I was NOT talking about "unauthorized changes". Nor was I talking about accounts no longer being used. I was talking about things like this: At time A there is an account with name X. The transactions in there almost all fit X with a couple odd ones more fitting a not yet existent Y (but still close enough to put in X). Over the course of the year, a lot more of these Y's, and less close to X. So decided it makes sense to create and account Y, move the few from X that really better fit Y to Y, and from now on use Y for the ones that best belong there. But since X and Y are related, a new parent Z for them to be children of. Or... one of your bank accounts is with bank and so naturally the name of the account reflects that. At some point in the year the bank changes its name to . Do you leave the account name alone? Do you change it to match the new bank name? Mind, you might not see this as much of an issue as I do since I have been mainly keeping books for organizations (I'd not be wanting to present reports to the BoD with the old name, would be sure to be questioned on "why not fixed") I other words, I expect the CoA to be somewhat dynamic. 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.
[GNC] Advance portfolio report between two dates
Hello Michael Thanks for your feed back. I fully agree that Dynamic COA can create havoc while comparing two period (dates) financial report. That is the precise reason, I have very precisely structured primary account and secondary sub account so far my work accounts are concern. No one can change without authorisation. No created account to be deleted even if have zero balance and so on. There is a detailed SOP implemented as how to handle COA. Having said that, i would believe that certain reports does not have much value if they are not compared. For example, balance sheet - it reflects balances. It will be one of the most important comparison for example, as how much account payable has increased between two period and stuff. Even if I have to make indirect cashflow statement, i need balance sheets between two dates to calculate increase / decrease in working capital and its effect on operating cash flow. Unfortunately, out of habit, i try to mimic such things from my personal finance too, which I know is over kill. And i must understand the limitations. But as they say old habit die hard. I have been trying to adopt GNU Cash fully, though I started using it since last few months only. My idea was to look no further, if I can get most of the things from GC. Thanks again for your time in addressing my question. With best regards Paras ___ 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.