Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant
Hello Sunfish, Yes. That is what happened. That is a good insight that you provided. Thank you! Neal On 3/11/24 12:46 PM, sunfis...@yahoo.com wrote: I'll note that because GnuCash keeps a running really of the amount needed to balance the transaction, users adding a new line to that transaction can get confusing results. For example, a user adds a new transaction for a grocery store and places a left column entry for $35 assigned to Expenses:Groceries. They tab off the line, intending to add another split for $15 for Expenses:Household and tab to the left column and enter $15. However, in the right column, GnuCash has already supplied the balancing $35 for the first split. As user tabs of the line, GnuCash takes $15 and combines it with the $35, resulting in a right column entry for $20, rather than a left column entry in the intended amount. David T. On Mar 11, 2024, at 6:25 PM, "W. Neal Lewis" wrote: David, No, I found out very quickly that return causes that sort of result. Best regards, Neal On 3/9/24 10:32 PM, David Carlson wrote: Neal, By chance are you using the enter key during your editing? That triggers the full transactiion calculatkions. Use arrow keys, ta b key or mouse buttons until you are ready to see the transaction calculation. I think calculztions within individual amount fields happen as soon as you move out of that field unless you are creating a scheduled transaaction. On Sat, Mar 9, 2024, 8:36 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I'm not certain what you are describing, but I'll hazard a guess that you are seeing GnuCash auto-balance the transaction. That is normal. Every transaction has to be balanced. (Debits *must* equal Credits) You are free to enter the transaction however you like, as long as that holds true. If your self-entered amounts do not result in equal Debits & Credits, GnuCash will create a split initially not assigned to any account, but when you commit the transaction and that split remains, it will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a currency code) for the difference. Please read the GnuCash Help Manual and the Tutorial & Concepts Guide available in the Help Menu, or online, as you are learning the software. Then if you get stuck, come back and ask for help here. Regards, Adrien On 3/9/24 8:18 PM, W. Neal Lewis wrote: When I do the View > Transaction and put in individual numbers for each item in the Withdrawal column, it starts to mess with my figures. It puts in a number at the very top. It adds deposits to other entries. What I end up with is a mish-mash of costs that the program seems to think that I need for some mythical number it has come up with. That's exactly what happened previously. I don't want it adding numbers, or changing numbers. I just want to put in the correct values for each line, including tax, hit return and have the final value show up on the first line of the transaction. I obviously don't know what I am doing. Help! Neal 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. 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
Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant
I'll note that because GnuCash keeps a running really of the amount needed to balance the transaction, users adding a new line to that transaction can get confusing results. For example, a user adds a new transaction for a grocery store and places a left column entry for $35 assigned to Expenses:Groceries. They tab off the line, intending to add another split for $15 for Expenses:Household and tab to the left column and enter $15. However, in the right column, GnuCash has already supplied the balancing $35 for the first split. As user tabs of the line, GnuCash takes $15 and combines it with the $35, resulting in a right column entry for $20, rather than a left column entry in the intended amount. David T. On Mar 11, 2024, 6:25 PM, at 6:25 PM, "W. Neal Lewis" wrote: >David, > >No, I found out very quickly that return causes that sort of result. > >Best regards, >Neal > >On 3/9/24 10:32 PM, David Carlson wrote: >> Neal, >> >> By chance are you using the enter key during your editing? >> >> That triggers the full transactiion calculatkions. Use arrow keys, >ta b >> key or mouse buttons until you are ready to see the transaction >calculation. >> >> I think calculztions within individual amount fields happen as soon >as you >> move out of that field unless you are creating a scheduled >transaaction. >> >> On Sat, Mar 9, 2024, 8:36 PM Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> >>> I'm not certain what you are describing, but I'll hazard a guess >that >>> you are seeing GnuCash auto-balance the transaction. That is normal. >>> Every transaction has to be balanced. (Debits *must* equal Credits) >>> >>> You are free to enter the transaction however you like, as long as >that >>> holds true. If your self-entered amounts do not result in equal >Debits & >>> Credits, GnuCash will create a split initially not assigned to any >>> account, but when you commit the transaction and that split remains, >it >>> will be assigned to the account labeled: 'Imbalance-XXX' (where XXX >is a >>> currency code) for the difference. >>> >>> Please read the GnuCash Help Manual and the Tutorial & Concepts >Guide >>> available in the Help Menu, or online, as you are learning the >software. >>> Then if you get stuck, come back and ask for help here. >>> >>> Regards, >>> Adrien >>> >>> On 3/9/24 8:18 PM, W. Neal Lewis wrote: When I do the View > Transaction and put in individual numbers for >each >>> item in the Withdrawal column, it starts to mess with my figures. It >puts >>> in a number at the very top. It adds deposits to other entries. What >I end >>> up with is a mish-mash of costs that the program seems to think that >I need >>> for some mythical number it has come up with. That's exactly what happened previously. I don't want it adding >numbers, >>> or changing numbers. I just want to put in the correct values for >each >>> line, including tax, hit return and have the final value show up on >the >>> first line of the transaction. I obviously don't know what I am doing. Help! Neal >>> >>> ___ >>> 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. > >___ >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] I'm getting started in Gnucash and want to list each item that I buy from one merchant
David, No, I found out very quickly that return causes that sort of result. Best regards, Neal On 3/9/24 10:32 PM, David Carlson wrote: Neal, By chance are you using the enter key during your editing? That triggers the full transactiion calculatkions. Use arrow keys, ta b key or mouse buttons until you are ready to see the transaction calculation. I think calculztions within individual amount fields happen as soon as you move out of that field unless you are creating a scheduled transaaction. On Sat, Mar 9, 2024, 8:36 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I'm not certain what you are describing, but I'll hazard a guess that you are seeing GnuCash auto-balance the transaction. That is normal. Every transaction has to be balanced. (Debits *must* equal Credits) You are free to enter the transaction however you like, as long as that holds true. If your self-entered amounts do not result in equal Debits & Credits, GnuCash will create a split initially not assigned to any account, but when you commit the transaction and that split remains, it will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a currency code) for the difference. Please read the GnuCash Help Manual and the Tutorial & Concepts Guide available in the Help Menu, or online, as you are learning the software. Then if you get stuck, come back and ask for help here. Regards, Adrien On 3/9/24 8:18 PM, W. Neal Lewis wrote: When I do the View > Transaction and put in individual numbers for each item in the Withdrawal column, it starts to mess with my figures. It puts in a number at the very top. It adds deposits to other entries. What I end up with is a mish-mash of costs that the program seems to think that I need for some mythical number it has come up with. That's exactly what happened previously. I don't want it adding numbers, or changing numbers. I just want to put in the correct values for each line, including tax, hit return and have the final value show up on the first line of the transaction. I obviously don't know what I am doing. Help! Neal ___ 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. ___ 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] I'm getting started in Gnucash and want to list each item that I buy from one merchant
Thank you Adrien, That's what I will need to do - do some in depth reading of the Help Manual and Tutorial. Best regards, Neal On 3/9/24 8:35 PM, Adrien Monteleone wrote: I'm not certain what you are describing, but I'll hazard a guess that you are seeing GnuCash auto-balance the transaction. That is normal. Every transaction has to be balanced. (Debits *must* equal Credits) You are free to enter the transaction however you like, as long as that holds true. If your self-entered amounts do not result in equal Debits & Credits, GnuCash will create a split initially not assigned to any account, but when you commit the transaction and that split remains, it will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a currency code) for the difference. Please read the GnuCash Help Manual and the Tutorial & Concepts Guide available in the Help Menu, or online, as you are learning the software. Then if you get stuck, come back and ask for help here. Regards, Adrien On 3/9/24 8:18 PM, W. Neal Lewis wrote: When I do the View > Transaction and put in individual numbers for each item in the Withdrawal column, it starts to mess with my figures. It puts in a number at the very top. It adds deposits to other entries. What I end up with is a mish-mash of costs that the program seems to think that I need for some mythical number it has come up with. That's exactly what happened previously. I don't want it adding numbers, or changing numbers. I just want to put in the correct values for each line, including tax, hit return and have the final value show up on the first line of the transaction. I obviously don't know what I am doing. Help! Neal ___ 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] I'm getting started in Gnucash and want to list each item that I buy from one merchant
On 2024-03-09 16:33, Adrien Monteleone wrote: > You will not likely be able to easily auto-add tax per line, but can > certainly put in tax lines manually. (such as one line for food, one for > medicine, etc.) GnuCash can help with the math here. I put the rate and > amount in the memo section and then type in the formula in the debit > column. (e.g., $15.99 * .0845) GnuCash will replace your formula with > the result showing what the calculated tax amounts to. But be aware that if you compute sales tax on individual items, the total of the taxes you compute may be off by a penny or two from the tax your receipt shows for the transaction. These "rounding differences" are inevitable, as a current thread and many previous threads have discussed. It's mathematics, not any kind of software error. The only way to prevent them (if you want to prevent them, as opposed to manually tweaking the amounts) is never to buy multiple taxable items in the same transaction. 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] I'm getting started in Gnucash and want to list each item that I buy from one merchant
Neal, By chance are you using the enter key during your editing? That triggers the full transactiion calculatkions. Use arrow keys, ta b key or mouse buttons until you are ready to see the transaction calculation. I think calculztions within individual amount fields happen as soon as you move out of that field unless you are creating a scheduled transaaction. On Sat, Mar 9, 2024, 8:36 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I'm not certain what you are describing, but I'll hazard a guess that > you are seeing GnuCash auto-balance the transaction. That is normal. > Every transaction has to be balanced. (Debits *must* equal Credits) > > You are free to enter the transaction however you like, as long as that > holds true. If your self-entered amounts do not result in equal Debits & > Credits, GnuCash will create a split initially not assigned to any > account, but when you commit the transaction and that split remains, it > will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a > currency code) for the difference. > > Please read the GnuCash Help Manual and the Tutorial & Concepts Guide > available in the Help Menu, or online, as you are learning the software. > Then if you get stuck, come back and ask for help here. > > Regards, > Adrien > > On 3/9/24 8:18 PM, W. Neal Lewis wrote: > > When I do the View > Transaction and put in individual numbers for each > item in the Withdrawal column, it starts to mess with my figures. It puts > in a number at the very top. It adds deposits to other entries. What I end > up with is a mish-mash of costs that the program seems to think that I need > for some mythical number it has come up with. > > > > That's exactly what happened previously. I don't want it adding numbers, > or changing numbers. I just want to put in the correct values for each > line, including tax, hit return and have the final value show up on the > first line of the transaction. > > > > I obviously don't know what I am doing. > > > > Help! > > Neal > > > ___ > 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] I'm getting started in Gnucash and want to list each item that I buy from one merchant
I'm not certain what you are describing, but I'll hazard a guess that you are seeing GnuCash auto-balance the transaction. That is normal. Every transaction has to be balanced. (Debits *must* equal Credits) You are free to enter the transaction however you like, as long as that holds true. If your self-entered amounts do not result in equal Debits & Credits, GnuCash will create a split initially not assigned to any account, but when you commit the transaction and that split remains, it will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a currency code) for the difference. Please read the GnuCash Help Manual and the Tutorial & Concepts Guide available in the Help Menu, or online, as you are learning the software. Then if you get stuck, come back and ask for help here. Regards, Adrien On 3/9/24 8:18 PM, W. Neal Lewis wrote: When I do the View > Transaction and put in individual numbers for each item in the Withdrawal column, it starts to mess with my figures. It puts in a number at the very top. It adds deposits to other entries. What I end up with is a mish-mash of costs that the program seems to think that I need for some mythical number it has come up with. That's exactly what happened previously. I don't want it adding numbers, or changing numbers. I just want to put in the correct values for each line, including tax, hit return and have the final value show up on the first line of the transaction. I obviously don't know what I am doing. Help! Neal ___ 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] I'm getting started in Gnucash and want to list each item that I buy from one merchant
Neal, You are welcome. But please remember to hit 'reply-all' or 'reply-list' rather than just 'reply' so everyone on the list benefits and can participate in this discussion. Individual users may not always be able to help fully with any issue or question, others may have better answers or interesting suggestions. Regards, Adrien On 3/9/24 7:10 PM, W. Neal Lewis wrote: Thank you Adrien, I will see what I can do with your suggestions. And yes, I do need a high level of detail. Thank you again for your reply. Best regards, Neal ___ 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] I'm getting started in Gnucash and want to list each item that I buy from one merchant
You can certainly do so. The exact work flow can vary depending on your precise needs. I don't often have very long transactions (30 or more items) but it does happen a few times a year. I frequently have transactions with at least 5 or so 'splits'. I'd recommend experimenting with either View > Transaction Journal (my preference) or View > Auto Split. That way, if most of your transactions need to show individual line item info, you can see it when you enter the transaction (Auto Split) or always see that level of detail for all transactions. (Transaction Journal) The default view will be least helpful to you. You will not likely be able to easily auto-add tax per line, but can certainly put in tax lines manually. (such as one line for food, one for medicine, etc.) GnuCash can help with the math here. I put the rate and amount in the memo section and then type in the formula in the debit column. (e.g., $15.99 * .0845) GnuCash will replace your formula with the result showing what the calculated tax amounts to. Another (but a bit more complicated) option is to put all such transactions into 'Vendor Bills' which can do taxes per line, exclusive or inclusive of price. But this requires much more careful setup and may or may not work for your particular situation. Most importantly, if you need reporting at all on this detail, it has to be entered somehow into GnuCash. Do not just aggregate and enter the result. (don't consolidate line items. Enter each one separately as its own split, but do enter them in the same transaction if that is how they occurred.) Regards, Adrien On 3/9/24 5:40 PM, W. Neal Lewis wrote: I would like to use Gnucash to keep track of the costs and information of each of the things that I buy from a merchant, such as Kroger, Home Depot, etc. There can be 30 to more items on one transaction. The items can be for different uses, such as food, lumber, computers, etc. There can be multiple tax rates, depending on the separate tax rates for food, prescriptions, hardware, etc. This information is needed for use at tax time, since I have a small business and need to break things out accordingly. Is Gnucash the right program to use for these needs? ___ 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] I'm getting started in Gnucash and want to list each item that I buy from one merchant
I would like to use Gnucash to keep track of the costs and information of each of the things that I buy from a merchant, such as Kroger, Home Depot, etc. There can be 30 to more items on one transaction. The items can be for different uses, such as food, lumber, computers, etc. There can be multiple tax rates, depending on the separate tax rates for food, prescriptions, hardware, etc. This information is needed for use at tax time, since I have a small business and need to break things out accordingly. Is Gnucash the right program to use for these needs? Thanks. wnlewis ___ 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.