[GNC] Invoice question
I am a brand new user and am very impresses with what you have created. I checked the FAQ and could not fid an answer to me question. How can I delete a column from appearing on an invoice? I would like to make the column titled "Discount" to disappear as I don't want my customers to think that is a possibility. -- Eric Ahrens (916) 765-5363 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] adjusting sizes
I am a 1st time user. Excited about this pgm. Thank you so much for providing it. I am trying to adjust visual sizes of fields on the check register display. I can move the size but it won't stay to adjusted width. Please advise. Marie -- Stop search tracking use: https://duckduckgo.com/ as your default search engine *Avoid spamming. Use BCC when sending to more than one person.* ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Reordering splits in a transaction
> > On 15 May 2020 at 9:03, peterb said: > > > * I have a recurring transaction with a very complicated split. At some *> > * point, the splits in the recurring transaction seem to have organized *> > * themselves in a confusing way - seemingly not related to the order in *> > * which I entered them. *> > > > * Is there any way to reorder splits within a transaction short of "Type * > > > * everything over again from top to bottom?" Is the (seeming) > self-ordering *> > * of the splits themselves inevitable, and if so, is there some underlying > *> > * principle by which they are arranging themselves? *> > > > * -P * I also have a recurring SX with multiple splits and messy > calculations (5 > parameters, 8 splits). The splits mostly show up in the same order > (modulo debits-before-credits) but not always. It seems the sort order is > nondeterminate. I don't regard it as important. Understood. The reason it matters to me is that my recurring transaction is _almost_ identical, but not exactly - several values tend to fluctuate by a few pennies every month. This means that I end up having to play hunt-the-split, whereas if the order was preserved I could use that to quickly zero in on the changed value. But it sounds like this is just the way the cards have been dealt, so maybe I'll file an enhancement request on the bug tracker and go on with my life. Thanks! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 stock transaction amount and quantity from csv
Hey Elias, I tried to do this recently as well, and with the helpful responses of Geert and David, I think it is working. Like what you described, there is rounding in my transaction histories from my financial institution, and all I really want to get correct in gnucash is (i) the number of shares purchased and (ii) the amount of my contribution. In order to do this, my "hack" was to process the csv transaction history and compute an effective price with high precision. Now when I import the number of shares and price into gnucash, the "amount" (which is rounded to the nearest cent) is correct. As an example, on 01/01/2020 I contributed $49.25 and purchased 0.5721 shares of XYZ. The multi-line multi-split transaction I import into gnucash looks like the following in the csv file: "DATE","DESCRIPTION","CURRENCY","ACCOUNT","DEPOSIT","PRICE" "01/01/2020","Contribution","CURRENCY::USD","Assets:Retirement Account:Securities:Stock XYZ","0.57210","86.0863485405" "","","","Assets:Retirement Account:Cash","-49.25","1.0" When I import this into gnucash I make the following adjustment/associations in the main box that interprets the csv file: * Toggle "Multi-split" * Increase "Leading Lines to Skip" to 1 * Associate "DATE" column to "Date" * Associate "DESCRIPTION" column to "Description" * Associate "CURRENCY" column to "Transaction Commodity" * Associate "ACCOUNT" column to "Account" * Associate "DEPOSIT" column to "Deposit" * Associate "PRICE" column to "Price" The transaction is reported as balanced by gnucash and I see -49.25 in my "Cash" account and +0.5721 shares in the "Stock XYZ" account. I am not sure if this is a good/acceptable practice, but it seems to work for now and gives me consistent results with the statements from my financial institution (e.g., the fractional number of shares over many statements is still correct, etc.). In order to get to this point, however, I had to write some python code to process the thousands of transactions in the csv file. It would be great if in the future the user could select the number of shares and the total amount, and leave the share price as a derived quantity. Sincerely, Matthew Clay ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice question
Op zaterdag 16 mei 2020 17:52:26 CEST schreef Eric Ahrens: > I am a brand new user and am very impresses with what you have created. I > checked the FAQ and could not fid an answer to me question. > > How can I delete a column from appearing on an invoice? I would like to > make the column titled "Discount" to disappear as I don't want my > customers to think that is a possibility. When you have the invoice report in front of you, select "Report Options", go to the display tab and untick the "Discount" box. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reordering splits in a transaction
> On May 16, 2020, at 5:26 PM, peterb wrote: > >> >> On 15 May 2020 at 9:03, peterb said: >>> >> * I have a recurring transaction with a very complicated split. At some *> >> * point, the splits in the recurring transaction seem to have organized *> >> * themselves in a confusing way - seemingly not related to the order in *> >> * which I entered them. *> >>> >> * Is there any way to reorder splits within a transaction short of "Type * >>> >> * everything over again from top to bottom?" Is the (seeming) >> self-ordering *> >> * of the splits themselves inevitable, and if so, is there some underlying >> *> >> * principle by which they are arranging themselves? *> >>> >> * -P * I also have a recurring SX with multiple splits and messy >> calculations (5 >> parameters, 8 splits). The splits mostly show up in the same order >> (modulo debits-before-credits) but not always. It seems the sort order is >> nondeterminate. I don't regard it as important. > > > Understood. The reason it matters to me is that my recurring transaction is > _almost_ identical, but not exactly - several values tend to fluctuate by a > few pennies every month. This means that I end up having to play > hunt-the-split, whereas if the order was preserved I could use that to > quickly zero in on the changed value. > > But it sounds like this is just the way the cards have been dealt, so maybe > I'll file an enhancement request on the bug tracker and go on with my > life. Thanks! Change the amount to a variable in the SX template transaction, then the SLR dialog box will ask you for the amount when it runs. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] adjusting sizes
Hi Marie, Welcome to gnucash. "Description" column automatically expands to fill available remaining space so double click headers of ALL OTHER COLUMNS individually to set them to reasonable widths and see how you go. You can also click and hold right hand side column divider to adjust column width if you don't like the default width. If you just try adjusting Description column it will just spring back to where it was usually. Cheers David H. On Sun, 17 May 2020 at 20:08, Marie Ybarra wrote: > I am a 1st time user. Excited about this pgm. Thank you so much for > providing it. > I am trying to adjust visual sizes of fields on the check register display. > I can move the size but it won't stay to adjusted width. Please advise. > Marie > > -- > Stop search tracking use: https://duckduckgo.com/ as your default search > engine > *Avoid spamming. Use BCC when sending to more than one person.* > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cash Flow with Split Transaction
I solve for this problem by using a suspense account.
Set up an asset account. On each payday, record your gross pay as a debit,
all of your various taxes, with holdings, etc. as credits, with one or more
final credit(s) to the suspense account to cover your net pay.
You can now run a cash flow report for your checking account that only
shows the net pay into your checking account.
You can also run a cash flow report for the suspense account and compare
that to your pay stub. (If you’re in the US, you can also compare your
calendar year report to your W-2)
I’ve had a lot of success with this method. I have several such suspense
accounts for non-cash transactions like this.
On Sat, May 16, 2020 at 3:44 PM Matthew Clay wrote:
> Gnucash Community,
>
> I have a question about the "Cash Flow" report. When I set up a simple
> paycheck with splits for taxes and net pay, why is it that when I run
> a "Cash Flow" report on my checking account the entirety of the split
> transaction is reflected in the report?
>
> For example, for a $100 paycheck with $10 going to taxes and $90 going
> to my checking account, the "Cash Flow" report looks like:
>
> ---
> Selected Account
> * Assets
>
> Money into selected accounts comes from
> Income:Salary $100
>
> Money out of selected accounts goes to
> Expenses:Taxes $10
>
> Difference
> $90.00
> ---
>
> While the net pay ("Difference") is correct, it's not like the taxes I
> pay "flow into and out of" my checking account --- the account never
> sees anything more than the net deposit.
>
> Is it possible to set the "Cash Flow" report to only show what
> actually "flows" into and out of a selected account(s) with split
> transactions, or is it on the user to mentally keep track of this?
> Maybe there is another kind of report that can do this? Thank you for
> your time and help.
>
> Sincerely,
> Matthew Clay
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
--
--- Typed with my thumbs and sent from my iPad.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a better way enter multi-currency split transaction?
Just want to share what I will do as I don't think there will be a solution soon. I will create a sub-account for each currency under all my income and expense accounts. Foreign income/expenses will be transferred to respective currency. At the end of each month, I will then transfer all foreign income/expense to home currency. This way, I can still use the memorized transaction, I just have to key in the amount twice and it is easier to spot the error (typo will create imbalance entry). Without converting the income/expense account to home currency, I noticed the annual total of the multi-column P/L report won't match the sum the individual months due to the fluctuation in exchange rates. Anyway, I have submitted a feature request. If memorized transaction can add some extra logic to ignore dummy split with 0 qty and treat it as a normal debit/credit transaction, everything will be perfect. Hope someone can look into it. Feature request: https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/40444765-ignore-dummy-split-in-memorized-transaction-for-pr -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] adjusting sizes
These adjustments are also ‘per register’ if I recall correctly. So you can set different widths depending on the account you are viewing. But that also means if you want to change a column width for every account, you have to do so *for every account*. Regards, Adrien > On May 17, 2020 w21d138, at 4:11 PM, David H wrote: > > Hi Marie, > > Welcome to gnucash. "Description" column automatically expands to fill > available remaining space so double click headers of ALL OTHER COLUMNS > individually to set them to reasonable widths and see how you go. You can > also click and hold right hand side column divider to adjust column width > if you don't like the default width. If you just try adjusting Description > column it will just spring back to where it was usually. > > Cheers David H. > > > On Sun, 17 May 2020 at 20:08, Marie Ybarra wrote: > >> I am a 1st time user. Excited about this pgm. Thank you so much for >> providing it. >> I am trying to adjust visual sizes of fields on the check register display. >> I can move the size but it won't stay to adjusted width. Please advise. >> Marie ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] adjusting sizes
Just to add to this discussion, Register column width settings are also 'per user' which means that they assume that they are on a single display attached to a single computer. When or if you try to migrate user settings (which also include custom report settings and a few other things, for example font settings) to a different computer or to use a different display with higher screen resolution you will then probably want to reset widths again. Fortunately, once we have them adequately working, we don't really need to fiddle with them much, but we do have to remember that if we make a change that we want to 'stick', we need to not only explicitly save the data file, but, in addition, we must close the GnuCash program and restart it. This is an artifact of the fact that the code that controls the register windows was originally written literally decades ago and only superficially modified since. The code may be reviewed again sometime, but not very soon. David Carlson On Sun, May 17, 2020 at 8:26 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > These adjustments are also ‘per register’ if I recall correctly. So you > can set different widths depending on the account you are viewing. But that > also means if you want to change a column width for every account, you have > to do so *for every account*. > > Regards, > Adrien > > > On May 17, 2020 w21d138, at 4:11 PM, David H wrote: > > > > Hi Marie, > > > > Welcome to gnucash. "Description" column automatically expands to fill > > available remaining space so double click headers of ALL OTHER COLUMNS > > individually to set them to reasonable widths and see how you go. You can > > also click and hold right hand side column divider to adjust column width > > if you don't like the default width. If you just try adjusting > Description > > column it will just spring back to where it was usually. > > > > Cheers David H. > > > > > > On Sun, 17 May 2020 at 20:08, Marie Ybarra > wrote: > > > >> I am a 1st time user. Excited about this pgm. Thank you so much for > >> providing it. > >> I am trying to adjust visual sizes of fields on the check register > display. > >> I can move the size but it won't stay to adjusted width. Please advise. > >> Marie > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Is there a better way enter multi-currency split transaction?
Bugzilla will be a better forum to discuss issues with the multicolumn P&L report: bugs.gnucash.org On Mon, 18 May 2020, 7:31 am davygc, wrote: > Just want to share what I will do as I don't think there will be a solution > soon. > > I will create a sub-account for each currency under all my income and > expense accounts. Foreign income/expenses will be transferred to respective > currency. At the end of each month, I will then transfer all foreign > income/expense to home currency. This way, I can still use the memorized > transaction, I just have to key in the amount twice and it is easier to > spot > the error (typo will create imbalance entry). > > Without converting the income/expense account to home currency, I noticed > the annual total of the multi-column P/L report won't match the sum the > individual months due to the fluctuation in exchange rates. > > Anyway, I have submitted a feature request. If memorized transaction can > add > some extra logic to ignore dummy split with 0 qty and treat it as a normal > debit/credit transaction, everything will be perfect. Hope > someone can look into it. > > Feature request: > > https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/40444765-ignore-dummy-split-in-memorized-transaction-for-pr > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
