Re: [GNC] Transaction inconsistency when deleting account
On 9/3/2023 5:57 PM, Stan Brown (using GC 4.14) wrote: On 2023-09-03 12:12, Michael or Penny Novack wrote: 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"). I am not familiar with your usage of the word "split", but I don't think it's standard for GnuCash. A "split transaction" --- entered by starting the transaction and then hitting the "split" button. This switches to "journal mode" thus allowing you to enter a transaction that affects more than just two accounts. Note that entering transactions first with a "journal" entry is what we old timers used to do for all transactions (even those affecting just two accounts) unless we had a subsection of the ledger set up for "cashbook accounting" where "popular" transactions affecting just this subset were entered directly into the ledger with no journal entry. In practice that might be >90% of transactions saving a lot of time and reducing the chance of error (during the "posting" process). Essentially gnucash is using "cashbook accounting" where the subset is the entire ledger when the transaction only affects two accounts. 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.
Re: [GNC] Transaction inconsistency when deleting account
On 2023-09-03 12:12, Michael or Penny Novack wrote: > > 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"). I am not familiar with your usage of the word "split", but I don't think it's standard for GnuCash. "Data Entry Concepts":"Transactions" in the Tutorial and Concepts Guide says: "A line within a transaction that records the account and amount of money involved is called a split. A transaction can contain an arbitrary number of splits." Thus, we should never call a transaction a split, but we can speak of the number of splits in a transaction. With trivial exceptions, every transaction contains two or more splits, though in Basic Ledger view of an account register the splits for that account are hidden. Please, let's use standard GnuCash terminology, especially in conversation with newer users. They have enough to learn without being confused by inconsistent terminology. Stan Brown Tehachapi, CA, USA https://BrownMath.com/ ___ 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
If you look at any of the reports with the word Chart in their name you will find that they chart values over time, which is what you want. You get a pretty chart as a bonus. Depending on your account structure it may be easy or not to include the accounts that you want. On Sun, Sep 3, 2023 at 2:34 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 9/3/2023 2:43 PM, Paras Desai wrote: > > Hi Ken > > > > Thanks for your kind reply and efforts in explaining a way. > > > > Apparently, it appears that there is no alternative but to run reports > on two dates and compare or do some analysis. > > > > Any reports comparing two period is a desirable thing in finance and > accounting, may it be personal accounting. > > > > Thanks > > > > Paras > > You are quite correct, comparing two periods is desirable. > > What perhaps is confusing you is "a report" vs "comparing two runs of > that report". Yes of course, there COULD be a report Y that compared two > X reports. But there are some good reasons where that might best be done > "outside". There might quite possibly be the need for some human > decision making. I'll give a different report as an example (but one > where "as of date A" is commonly compared to "as of date B") > > Consider the Balance Sheet report. We are suggesting that to produce a > report comparing "as of date A" with "as of date B" you rut the two > reports, export, bring into a spreadsheet or something else you can > edit, and there produce the final report. Why? Why not an automatically > generated report? Well IF there is a one to one correspondence of > accounts "as of date A" vs "as of date B" this would be simple << you > can imagine a new report in gnucash called "Compare Balance Sheets" to > which you would supply two dates >> But what if the CoA "as of date A" > does NOT correspond 1:1 to the CoA "as of date B"? Accounts could have > been added, accounts could have been deleted, accounts could have > changed names, etc. You expect a computer (even with a pretty good AI > application) to be able to figure out what has happened and to line > things up properly? > > Situation 1:Account A present at date 1, absent at date 2, while > account B present at date 2 not present at date 2. > > Situation 2: No actual change except account A was renamed account B > > As a human bookkeeper, you know which happened (hopefully you remember) > > 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. > -- David Carlson ___ 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/3/2023 2:43 PM, Paras Desai wrote: Hi Ken Thanks for your kind reply and efforts in explaining a way. Apparently, it appears that there is no alternative but to run reports on two dates and compare or do some analysis. Any reports comparing two period is a desirable thing in finance and accounting, may it be personal accounting. Thanks Paras You are quite correct, comparing two periods is desirable. What perhaps is confusing you is "a report" vs "comparing two runs of that report". Yes of course, there COULD be a report Y that compared two X reports. But there are some good reasons where that might best be done "outside". There might quite possibly be the need for some human decision making. I'll give a different report as an example (but one where "as of date A" is commonly compared to "as of date B") Consider the Balance Sheet report. We are suggesting that to produce a report comparing "as of date A" with "as of date B" you rut the two reports, export, bring into a spreadsheet or something else you can edit, and there produce the final report. Why? Why not an automatically generated report? Well IF there is a one to one correspondence of accounts "as of date A" vs "as of date B" this would be simple << you can imagine a new report in gnucash called "Compare Balance Sheets" to which you would supply two dates >> But what if the CoA "as of date A" does NOT correspond 1:1 to the CoA "as of date B"? Accounts could have been added, accounts could have been deleted, accounts could have changed names, etc. You expect a computer (even with a pretty good AI application) to be able to figure out what has happened and to line things up properly? Situation 1: Account A present at date 1, absent at date 2, while account B present at date 2 not present at date 2. Situation 2: No actual change except account A was renamed account B As a human bookkeeper, you know which happened (hopefully you remember) 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.
Re: [GNC] Transaction inconsistency when deleting account
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.
[GNC] Advance portfolio report between two dates
Hi Ken Thanks for your kind reply and efforts in explaining a way. Apparently, it appears that there is no alternative but to run reports on two dates and compare or do some analysis. Any reports comparing two period is a desirable thing in finance and accounting, may it be personal accounting. Thanks 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.
[GNC] Transaction inconsistency when deleting account
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? I am using GC version 5.3 for MacOS with Postgresql version 14 as the backend database. Is the Windows version of GC more stable than Mac? Thanks a lot! -- JC ___ 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] Import Transactions: Withdrawals vs Deposits, and Account
Op zondag 3 september 2023 17:25:48 CEST schreef Geert Janssens: > ... The other would have been (although non-obvious) to set > both accounts as "Deposit"... I meant "amounts" rather than accounts here. Sorry for the confusion. 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] Import Transactions: Withdrawals vs Deposits, and Account
That's one solution. The other would have been (although non-obvious) to set both accounts as "Deposit". That's allowed in the csv importer. Deposit and Withdrawal come from the early days of the importer and don't cover all use cases very well. "Deposit" here really means, use the number unchanged (positive numbers will be imported as positive numbers, negative numbers as negative ones) while "Withdrawal" means reverse the sign of these numbers before importing them. So if your column already had negative numbers where you wanted these, "Deposit" is the number type that does what you want. In GnuCash 5.x these names have been changed in an attempt to make them more generic, to "Amount" and "Amount (negated)", but even that requires some interpretation due to the many possible ways csv data can be structured. Regards, Geert Op zondag 3 september 2023 15:48:43 CEST schreef Tom Balazs: > Problem solved: the withdrawal columns were all negative numbers. I changed > them to positive and it worked correctly. > > On Sun, Sep 3, 2023 at 9:20 AM Tom Balazs wrote: > > I'm importing transactions into a checking account. Why do all transaction > > amounts go into the deposits column? > > > > I'm trying to import transactions one month at a time for a checking > > account. > > I have a CSV file with one month of transactions. I went through the > > Transaction Import Assistant / Import Preview. I set "Import Account" to > > the checking account. I use the column headings map Date column, > > Description column, Withdrawals, and Deposits. Many > > withdrawal transactions, few deposit transactions. I import. And then I > > view the ledger for that checking account and all the transactions are put > > in the Deposits column. How do I fix this problem? > > ___ > 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
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] Import Transactions: Withdrawals vs Deposits, and Account
Problem solved: the withdrawal columns were all negative numbers. I changed them to positive and it worked correctly. On Sun, Sep 3, 2023 at 9:20 AM Tom Balazs wrote: > I'm importing transactions into a checking account. Why do all transaction > amounts go into the deposits column? > > I'm trying to import transactions one month at a time for a checking > account. > I have a CSV file with one month of transactions. I went through the > Transaction Import Assistant / Import Preview. I set "Import Account" to > the checking account. I use the column headings map Date column, > Description column, Withdrawals, and Deposits. Many > withdrawal transactions, few deposit transactions. I import. And then I > view the ledger for that checking account and all the transactions are put > in the Deposits column. How do I fix this problem? > > ___ 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] How to Enter Account in CSV Before Import
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 ___ 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] Import Transactions: Withdrawals vs Deposits, and Account
I'm importing transactions into a checking account. Why do all transaction amounts go into the deposits column? I'm trying to import transactions one month at a time for a checking account. I have a CSV file with one month of transactions. I went through the Transaction Import Assistant / Import Preview. I set "Import Account" to the checking account. I use the column headings map Date column, Description column, Withdrawals, and Deposits. Many withdrawal transactions, few deposit transactions. I import. And then I view the ledger for that checking account and all the transactions are put in the Deposits column. How do I fix this problem? ___ 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] Import question
Good evening all, Apologies for wasting everyone's time and thanks again for those who responded. After looking at the csv import dialog with a fresh head, I realise I had both comma AND semicolon ticked as separators. The software was doing exactly as instructed to do. Another instance of "problem between chair and keyboard". Now I'm going to find a deep hole to bury myself in... Regards, Nicolas On 31/08/2023 23:07, Nicolas de La Chaise via gnucash-user wrote: Hello all, First of all, I want to take this opportunity to thank all the posters and developers who dedicate so much of their time to help the ungrateful mass I belong to. You guys rock. Now, my silly problem... My bank only offers 2 formats when exporting transactions: either QIF or CSV. If I choose to import in QIF, there is no way to see the amount of the transaction that is being imported. I find it quite useful as some online shopping transactions can fall into many different accounts. Would it be possible to see it added in an upcoming version? Now, to go around this I was hoping to use the csv format. Only to hit a different problem. The CSV I import has French number formatting (decimal separator is ','). And when the import tool runs it seems to get awfully confused by it. In the screenshot below, amounts should be (for UK/US readers) -50.8 / -40.0 / -5.7 / -1.6 I already poked around with encoding and currency format to no avail. The amount is split in two and cannot be glued back together. Do anyone has a workaround? Note: GNC 4.4 Debian 10 Thanks a lot! N. ___ 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] Issues
On 9/2/23 4:05 PM, Greg wrote: We're both still working on a custom "Weekly Payroll Report" that I designed and created with 2.4.13, but it disappeared. It worked great! It was a fantastic template - all you had to do was change the date each week. I showed (taught) him about the style sheets. I also showed him about the accounts tab under options in the transaction reports. Check the Wiki concerning file locations. (just do a search on the wiki for "file locations") and you'll find a very detailed breakdown of where everything GnuCash related is stored. While it seems you are describing an entirely custom report, I do know the 'saved reports' file changed names and the migration for many involved manually renaming the file accordingly. (I'm not entirely certain why this file is named with the version as part of the file name, but it is what we live with) This may or may not address your exact issue, but I'd bet something in examining those file locations will shed some light on why your report 'disappeared'. Yes, Windows 10 will tab. However, I am talking about the separate account register tabs displayed within GNUcash, that you can display: top, bottom, left, or right. (Which gives him more options) His screen resolution is x1080, My screen resolution is 4K (3840x2160) with NVIDIA display. Does that matter? Okay, good to know we're discussing the GnuCash tabs. Note my followup reply about the arrows at the ends of the tab bar, and about the tab list via right-click. Does that help? As for resolution, x1080 is most likely 1920x1080 which is standard HD. That is plenty large enough for more than 5 tabs. (It is what I use) Something else is definitely wrong. I'd say it is time for a bug report. Regards, Adrien ___ 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.
