Re: [GNC] how to total up all "stock transactions" in a year
all the values changed thanks to updates in the Price Database. See the attached screenshot for example: in this broker I did no transactions this year (as shown by the 0s in the stock/funds accounts), however it shows a €2,092.87 increment in the parent account, which is due to the increased value of the holdings this year. I think this pretty normal? On Wed, Aug 21, 2024 at 08:31:24PM -0500, Adrien Monteleone wrote: > What changes in stock values do you see in those accounts that isn't part of > a buy/sell transaction? > > > Regards, > Adrien > > On 8/21/24 1:06 PM, Mattia Rizzolo wrote: > > That I do, however that column seems to hold also changes in the value > > of the assets therein (I believe?), whilst I only need the actual > > purchase/sell price. > > ___ > 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. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- ___ 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 total up all "stock transactions" in a year
On Wed, Aug 21, 2024 at 10:43:44AM -0700, Stephen M. Butler wrote:
> I presume you have an asset account that holds all these transactions --
> most likely a parent account. If so, I would add the "Total (Period)"
> column on the accounts tab. That way you have nothing further to do and
> have the number available at all times for instant inspection.
That I do, however that column seems to hold also changes in the value
of the assets therein (I believe?), whilst I only need the actual
purchase/sell price.
> The other option is to do a transaction report to pick the relevant accounts
> (and their children) for the current (or specified) year and maybe just ask
> for the grand total.
Mhh this might have been much easier than I thought it would be…
Trying it out I can indeed have what I was looking for. I probably need
to filter things a bit but I am seeing a final value that is off by
single-digit EUR from what I manually counted so it's indeed great.
Thank you for the suggestion!
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
___
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 total up all "stock transactions" in a year
Hello,
for… tax reasons¹… I need to be able to tell if in a given year the sum
of money I used to buy/sell financial instruments is above a certain
number (so I need to sum up money used to buy and deduct all money
received when selling).
In practice I'd like to sum up all transactions that involved trading
non-currencies in a given year.
I don't do a ton of transactions, but still enough and across plenty of
instruments and across several brokerage firms, so my CoA is quite
convoluted.
How would you recommend I do such query in gnucash?
¹ In Italy, this is then used to compute the "ISEE" (an indicator of the
economic condition of the family). But tbh it is an interesting number
to have on its own. :)
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
___
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 record tax credit for capital loss
Thank you Geoff! Yours is probably closer to what I had in mind when I started the thread. Thank you in particular for your precise screenshot, that's very helpful. I'll try to decide what's effectively best for me now, since it's not so obviously clear. On Thu, Jan 25, 2024 at 6:36 AM Geoff wrote: > Hi Mattia > > Please see attached a screenshot showing my suggestion - I am not an > accountant. For simplicity I have not split the Tax Credit accounts by > Broker and Year, but you already have this in hand. I have also > included the transaction for writing off a lapsed tax credit after 4 years. > > In words: > (1) Book the tax credit as an asset at the time of sale. > (2) Transfer the relevant tax credits to offset your income at tax time. > (3) Book any expired tax credits as an expense. > > > Hope this helps. > > Regards > > Geoff > = > > On 24/01/2024 8:43 am, Mattia Rizzolo wrote: > > Hello, > > > > I'd like some input on how to best record a tax credit due to capital > > loss, and possibly the following usage of such credit. > > Disclaimer: I'm not doing this for anything worth, it's a personal book > > that nobody but me sees, so I can take a few liberties and not follow > > whatever regulation to the letter. Besides, I have no formal education > > on accounting. > > > > > > The case is the following: > > > > 1 buy security A, cost $100 > > 2 buy security B, cost $100 > > 3 sell security A, get $90 > > 3a → record $10 loss > > 3b → get a $10 tax credit on following capital gains > > 4 sell security B, get $120 > > 4a → record $20 gain > > 4b → offset $10 from 3b > > 4c → pay tax on the remaining $10 (26%, $2.6 over here) > > > > I reckon all jurisdictions have something similar in concept, all with > > their differences in details. > > > > This is a tad further complicated by the fact that each broker has its > > own "bucket" of credits (can't comingle losses and gains across > > different brokers). Also the credits expire after 4 years, so I should > > record under which year they matured. As such, I expect an addition to > > my CoA, such as: > > Assets > >|- Credits > > |- Capital Loss credits > > |- broker 1 > > |- 2020 > > |- 2021 > > |- 2022 > > |- 2023 > > |- 2024 > > |- broker 2 > > |- 2022 > > . > > > > > > > > I've been using gnucash for ~3 years now, but I always procrastinated on > > figuring out the 3b/4b steps, just posting the resulting net tax > > transaction as computed by the broker. > > For me it's really not obvious what's the opposing account from where > > the money should come/go... > > How do people do it here? :) > > > > > > Thank you for all the hints! > > > > > > ___ > > 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. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. more about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- ___ 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 record tax credit for capital loss
On Wed, Jan 24, 2024 at 08:26:02AM -0800, Patrick James wrote: > So if you have a DR balance in your Brokerage 1 2020 account, then > you'd credit that account if you sold for a gain today, until the > account balance is zero, and then you'd credit 2021 for the leftover > CR amount, up to the 2021 DR balance, and so on and so forth. Exactly. > Eventually you'll run out of gain, or you'll have to credit the remaining CR > balance to the current year account (Brokerage 1 2024), which you might be > able to offset with a future DR, if you sold something for a loss, and that > future transaction meets the right windows of time. If I run out of past credits then that's a final gain, that's taxable the moment it's realized (and some brokers straightly withold it from the selling price!), it's not possible to offset with a future loss within the same year. For a bit of background: here in Italy there are 2 main tax regimes for securities: this one I'm having, where brokers do all the work, where load prices is the average of the buys, and it has its quirks; and then the other where the owner does all the work, and the prices are accounted with a LIFO, and it has its quirks; in this letter regime indeed I could offset gains and losses as you expect them to, just summing up all the gains and losses in a year, and pay tax on the difference, but it's usually not really as convinient as it seems due to additional reporting requirements. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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 record tax credit for capital loss
(and the attachemnt) On Wed, Jan 24, 2024 at 04:53:57PM +0100, Mattia Rizzolo wrote: > Here we don't do LT/ST, but it's only possible to offset losses up to > the end of the 4th year after the loss was realized. Meaning that 2019 > losses are now in stone. Besides, one offests losses by fist pickin the > furtherst year first, so it's good to know how much is left to offset > from each given year for each broker (it's common practice in Q4 to look > at what's left over from 3-4 years before and evaluate what to do to not > lose the credit). > > See the screenshot of what I got right now, for example. > Wouldn't obtaining these numbers, by putting both losses and gains in > the same bucket and then using the standard-provided reports, be > unnecessarily hard? > > > Again, note that I'm not using this to compute my own taxes, that's done > by the brokers already (I'm nowhere near the volume where it would make > sense for me to take over that "job" - which I could fwiw), but I do > want my data to match theirs. > > > On Wed, Jan 24, 2024 at 06:32:08PM +0300, David T. via gnucash-user wrote: > > Likewise not an accountant. > > > > In the US (my tax authority), gains are taxed at two rates (long term and > > short term), and gains and losses offset each other. I maintain separate > > income accounts for short term and long term gains/losses (income accounts > > because I'm an optimist!). These are placed in parent accounts for the > > brokerage (since each broker sends its own tax reports). There's no need to > > separate by year, since a saved report gives me last year's data instantly. > > > > To summarize: > > > > Income > > - Realized gains > > - - Broker 1 > > - - - LT gains > > - - - ST gains > > - - Broker 2 > > - - - LT gains > > - - - ST gains > > > > David T. > > > > On Jan 24, 2024, 5:22 PM, at 5:22 PM, Patrick James > > wrote: > > >Again keeping in mind that I am NOT a tax authority. > > > > > >Now that we're on the equity side, let's move forward with your > > >tracking. > > > > > >I very much doubt that you need two separate accounts for the losses > > >and gains; from what you're suggesting, you need to match some gains > > >with some losses. I would match these in a single account " Capital > > >Gains" where it is known that CR is "gain" (the expected/desired > > >'normal' balance) and DR is "loss." Just labeling an account "Capital" > > >is difficult when looking back/keeping track of what is what. And one > > >need not label it "Capital Gain or Loss," as the "or loss" part is > > >understood based on the balance in the account. > > > > > >Given what you are requesting, I'd have something like this: > > > > > >Capital Gain > > >2017 Broker 1 > > >2017 Broker 2 > > >2018 Broker 1 > > >2018 Broker 2 > > > > > >You would know what is best in terms of subaccounts. > > > > > >Then run reports if you need some specific information, which could > > >include separating the losses from the gains based on the debits and > > >credits. > > > > > >Keep in mind that I'm providing some ideas about how to use GNUCash as > > >a tool, and I have no idea about your tax requirements. > > > > > > > > >> On 01/24/2024 3:11 AM PST Mattia Rizzolo wrote: > > >> > > >> > > >> Thank you Patrick for your suggestion! > > >> > > >> I see what you are suggesting here… Mh. > > >> > > >> It could easily become very messy as the rules for offsetting gains > > >is > > >> fairly annoying here: gains some financial instruments can offset > > >losses > > >> only from some other particular financial instruments (i.e., "gains" > > >> from the dividends can *never* be offeset, or losses from stocks > > >can't > > >> be offset by gain on ETFs, etc)… Plus the fact that I'd need to > > >split > > >> losses by years and brokers… it's going to be annoying to have an > > >> account clearly state the "correct" credit I'm due this way. > > >> > > >> > > >> But I think you may have pointed me to the right direction, of > > >keeping > >
Re: [GNC] how to record tax credit for capital loss
Here we don't do LT/ST, but it's only possible to offset losses up to the end of the 4th year after the loss was realized. Meaning that 2019 losses are now in stone. Besides, one offests losses by fist pickin the furtherst year first, so it's good to know how much is left to offset from each given year for each broker (it's common practice in Q4 to look at what's left over from 3-4 years before and evaluate what to do to not lose the credit). See the screenshot of what I got right now, for example. Wouldn't obtaining these numbers, by putting both losses and gains in the same bucket and then using the standard-provided reports, be unnecessarily hard? Again, note that I'm not using this to compute my own taxes, that's done by the brokers already (I'm nowhere near the volume where it would make sense for me to take over that "job" - which I could fwiw), but I do want my data to match theirs. On Wed, Jan 24, 2024 at 06:32:08PM +0300, David T. via gnucash-user wrote: > Likewise not an accountant. > > In the US (my tax authority), gains are taxed at two rates (long term and > short term), and gains and losses offset each other. I maintain separate > income accounts for short term and long term gains/losses (income accounts > because I'm an optimist!). These are placed in parent accounts for the > brokerage (since each broker sends its own tax reports). There's no need to > separate by year, since a saved report gives me last year's data instantly. > > To summarize: > > Income > - Realized gains > - - Broker 1 > - - - LT gains > - - - ST gains > - - Broker 2 > - - - LT gains > - - - ST gains > > David T. > > On Jan 24, 2024, 5:22 PM, at 5:22 PM, Patrick James > wrote: > >Again keeping in mind that I am NOT a tax authority. > > > >Now that we're on the equity side, let's move forward with your > >tracking. > > > >I very much doubt that you need two separate accounts for the losses > >and gains; from what you're suggesting, you need to match some gains > >with some losses. I would match these in a single account " Capital > >Gains" where it is known that CR is "gain" (the expected/desired > >'normal' balance) and DR is "loss." Just labeling an account "Capital" > >is difficult when looking back/keeping track of what is what. And one > >need not label it "Capital Gain or Loss," as the "or loss" part is > >understood based on the balance in the account. > > > >Given what you are requesting, I'd have something like this: > > > >Capital Gain > >2017 Broker 1 > >2017 Broker 2 > >2018 Broker 1 > >2018 Broker 2 > > > >You would know what is best in terms of subaccounts. > > > >Then run reports if you need some specific information, which could > >include separating the losses from the gains based on the debits and > >credits. > > > >Keep in mind that I'm providing some ideas about how to use GNUCash as > >a tool, and I have no idea about your tax requirements. > > > > > >> On 01/24/2024 3:11 AM PST Mattia Rizzolo wrote: > >> > >> > >> Thank you Patrick for your suggestion! > >> > >> I see what you are suggesting here… Mh. > >> > >> It could easily become very messy as the rules for offsetting gains > >is > >> fairly annoying here: gains some financial instruments can offset > >losses > >> only from some other particular financial instruments (i.e., "gains" > >> from the dividends can *never* be offeset, or losses from stocks > >can't > >> be offset by gain on ETFs, etc)… Plus the fact that I'd need to > >split > >> losses by years and brokers… it's going to be annoying to have an > >> account clearly state the "correct" credit I'm due this way. > >> > >> > >> But I think you may have pointed me to the right direction, of > >keeping > >> everything within the equities, here is what I've done: > >> (yes, I realize that income/expenses are "the same thing") > >> > >> Expenses > >> |- Capital Loss > >> |- Broker 1 > >> |- 2017 > >> |- 2020 > >> |- 2021 > >> |- 2023 > >> Income > >> |- Capital Gain > >> > >> So, I changed my losses to be posted against the proper "capital > >loss" > >> account instead of being
[GNC] transaction impossible to reconcile
I'm fixing up a couple of old transactions that I didn't really record
correctly, and here is one that is baffling me.
Attached you can find a screenshot of the journal.
What happened is that this company issued some options to its
shareholders to to some capital increase.
So, the regular stock effectively got "split-off" for its option (that
is also regularly traded, etc).
I've done pretty much the same in other situations with more standard
business spin-offs (the O → ONL one comes to mind), but somehow here
gnucash is refusing to let me go.
What is going on?
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
signature.asc
Description: PGP signature
___
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 record tax credit for capital loss
Thank you Patrick for your suggestion! I see what you are suggesting here… Mh. It could easily become very messy as the rules for offsetting gains is fairly annoying here: gains some financial instruments can offset losses only from some other particular financial instruments (i.e., "gains" from the dividends can *never* be offeset, or losses from stocks can't be offset by gain on ETFs, etc)… Plus the fact that I'd need to split losses by years and brokers… it's going to be annoying to have an account clearly state the "correct" credit I'm due this way. But I think you may have pointed me to the right direction, of keeping everything within the equities, here is what I've done: (yes, I realize that income/expenses are "the same thing") Expenses |- Capital Loss |- Broker 1 |- 2017 |- 2020 |- 2021 |- 2023 Income |- Capital Gain So, I changed my losses to be posted against the proper "capital loss" account instead of being a negative gain, and then I'm posting the future gains as compensation of that loss (and only for the part that can be compensated). This way indeed the balance of the Broker1 account does match with what the broker is showing me. Do anybody believe I may be missing something out when recording capital gains/losses this way? On Tue, Jan 23, 2024 at 03:43:03PM -0800, Patrick James wrote: > Let's start with your best bet is to work with your tax professional as to > how best to keep track of what's needed for taxes. > > In the US, what you call a "credit" generally would not be an asset account. > The "credit" would be a potential offset to some future gain, if there is any > future gain, so I would leave all this over on the equity side. > > Day 0 Purchase: > > Stock (asset) $100DR > Cash $100CR > Purchase of 100 shares of Stock Y for $1 per share > > Day 365 Sale: > > Cash $90DR > Capital Gain $10DR > Stock (asset) $100CR > Sale of 100 shares of Day 0 Stock Y for $0.90 per share. > > NOTE: One hopes that capital gains has a CR (gain) balance, rather than the > DR balance above (loss). > > Later, if there was some sale for a gain, then the CR recorded to Capital > Gain would offset some or all of the DR. > > Also note that matching the shares as I have done above is not always as > simple as this single stock sale where all shares are purchased on a single > day and the entire holding is sold a year later. > > Again, talk to your tax professional about how to best keep the records > necessary for tax compliance. > > > > On 01/23/2024 1:43 PM PST Mattia Rizzolo wrote: > > > > > > Hello, > > > > I'd like some input on how to best record a tax credit due to capital > > loss, and possibly the following usage of such credit. > > Disclaimer: I'm not doing this for anything worth, it's a personal book > > that nobody but me sees, so I can take a few liberties and not follow > > whatever regulation to the letter. Besides, I have no formal education > > on accounting. > > > > > > The case is the following: > > > > 1 buy security A, cost $100 > > 2 buy security B, cost $100 > > 3 sell security A, get $90 > > 3a → record $10 loss > > 3b → get a $10 tax credit on following capital gains > > 4 sell security B, get $120 > > 4a → record $20 gain > > 4b → offset $10 from 3b > > 4c → pay tax on the remaining $10 (26%, $2.6 over here) > > > > I reckon all jurisdictions have something similar in concept, all with > > their differences in details. > > > > This is a tad further complicated by the fact that each broker has its > > own "bucket" of credits (can't comingle losses and gains across > > different brokers). Also the credits expire after 4 years, so I should > > record under which year they matured. As such, I expect an addition to > > my CoA, such as: > > Assets > > |- Credits > > |- Capital Loss credits > > |- broker 1 > > |- 2020 > > |- 2021 > > |- 2022 > > |- 2023 > > |- 2024 > > |- broker 2 > > |- 2022 > > . > > > > > > > > I've been using gnucash for ~3 years now, but I always procrastinated on > > figuring out the 3b/4b steps, just posting the resulting net tax > > transaction as computed by the broker. > &g
[GNC] how to record tax credit for capital loss
Hello, I'd like some input on how to best record a tax credit due to capital loss, and possibly the following usage of such credit. Disclaimer: I'm not doing this for anything worth, it's a personal book that nobody but me sees, so I can take a few liberties and not follow whatever regulation to the letter. Besides, I have no formal education on accounting. The case is the following: 1 buy security A, cost $100 2 buy security B, cost $100 3 sell security A, get $90 3a → record $10 loss 3b → get a $10 tax credit on following capital gains 4 sell security B, get $120 4a → record $20 gain 4b → offset $10 from 3b 4c → pay tax on the remaining $10 (26%, $2.6 over here) I reckon all jurisdictions have something similar in concept, all with their differences in details. This is a tad further complicated by the fact that each broker has its own "bucket" of credits (can't comingle losses and gains across different brokers). Also the credits expire after 4 years, so I should record under which year they matured. As such, I expect an addition to my CoA, such as: Assets |- Credits |- Capital Loss credits |- broker 1 |- 2020 |- 2021 |- 2022 |- 2023 |- 2024 |- broker 2 |- 2022 . I've been using gnucash for ~3 years now, but I always procrastinated on figuring out the 3b/4b steps, just posting the resulting net tax transaction as computed by the broker. For me it's really not obvious what's the opposing account from where the money should come/go... How do people do it here? :) Thank you for all the hints! -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] overdue column in customer/vendor overview
Hello,
I know that what I want is partially covered by the "Invoice due
reminder" e "Bills due reminder", but I think I would like to have in
the customer/vendors overview a dedicated column for this. One with the
total current balance, and one with the currently overdue
invoices/bills, especially as this would let me sort late customers by
"how much they owe me".
Is this something possible, or doable?
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
___
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] Payment of invoice in downloaded transactions?
On Fri, Sep 22, 2023 at 03:42:29PM -0600, Simon Roberts wrote:
> Today I did an import of bank transactions using OFX, and one of the
> transactions is a payment of an invoice. How to I tie the two together?
Right click on the transaction > "Assign as payment..."
?
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
___
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] moving stocks across accounts lost the basis price in the Portfolio report
Hello, A couple of weeks ago I had some stocks moved across different accounts. In gnucash, I tried recording them as this, for example: shares price debit credit A:Investements:Broker1:P1:USD:AMZN -10 A:Investements:Broker1:P2:USD:AMZN 10 I left price/debit/credit completely empty, and no other split. I noticed a few days later that these transactions (I moved roughly a dozen titles) generated some prices in the Price Database, adding a recorded price of $0 for all the stocks that were involved in this move; I noticed this when I had a glance at the net worth report and noticed a stupid downward peak. So I removed the faulty prices from the database and now that looks correct. Even more recently I was looking at the "Advance Portfolio" report, and realized now that all the stocks that were involved in this move seem to have a "Basis" of €0.00 (and also money-in/money-out). This seems to be caused by the fact that in the Advanced Portfolio each account is on its own, so unticking the "Include accounts with no shares" I noticed that, limiting to my example above, I have two AMZN lines: * one with 0 shares, 0€ money out, -100.00% realized loss. * one with 10 shares, 0€ money in/out, 0€ basis, and empty cells (due to the 0€ basis, which I guess would cause divide-by-zero errors) (I mentioned a related issue I had with this here: https://lists.gnucash.org/pipermail/gnucash-user/2023-January/105229.html ) How do you recommend I fix this situation? Should I just add a price to the transactions to give them a basis, or what else? If I did that, how could I also "carry over" the fees accrued till now? Just manually compute them in the "new basis"? Thank you for your suggestions. PS: For some stocks I could potentially rename the accounts instead of doing this move, but this wouldn't be possible for all stocks, as both portfolios (in the same broker, yes) have shares of the same companies that I need to keep separate. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] coalesce the stock accounts in the report
Hello,
I own several stocks across multiple brokers, so I have an account
structure that, roughly, looks like this:
Assets
|- Bank1
| |- EUR
| |- Stocks EUR
| |- AAA
| |- BBB
| |- CCC
|- Bank2
|- EUR
|- Stocks EUR
|- BBB
So, in this simple case, I hold 4 different stocks across two brokers,
of which one (BBB) is held in two places at the same time.
In this situation the "Advanced Portfolio" report lists:
AAA
BBB
CCC
BBB
Duplicating BBB and listing it separately between the accounts.
I get why this might be interesting in some cases, but for my uses I
have really have no interest in having a separated view in this report;
it's actually quite confusing right now as I had cases in the past where
I moved holdings across different brokers (without liquidating the
position, directly moving the titles), and this seems to be recorded
actually as a 100% loss (?!!) in the report. Sure I can tick the "hide
accounts with no shares" options, but I also had cases where I only
partially moved a position so I still hold some shares in both places.
Any suggestion on what I could do?
Clearly I can't unify the accounts as I do need to keep them separated.
Thank you in advance for your insights!
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
signature.asc
Description: PGP signature
___
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] gnucash on debian
Hello Anne, could you be more descriptive on what went wrong when running gnucash on Debian? I run gnucash on Debian unstable myself (so it's quite similar to bookworm), and it seems just fine. Personally I use i3, but I don't see gnucash making a fuss across different DEs/WMs. On Tue, Jan 10, 2023 at 12:23:38AM +0100, Anne Possoz wrote: > Hello, > > Although I used gnucash 16 year ago on fedora (being satisfied) > I failed to get a working gnucash on the latest debian > (bullseye or bookworm). > > My preference would be to use it under mate with lightdm as > window manager. > > Anybody close to that environment that could give advice as the > documentation is disparate and a little old. > I do not plan to use database. > > Kind regards, > Anne > ___ > 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. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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 do I get rid of broken invoices?
On Mon, Dec 12, 2022 at 10:31:42AM -0600, steven stern wrote:
> Without changing any account balances...
>
> See https://i.imgur.com/GpKSbid.png
>
> I have old invoices that were underpaid and I just want this warning gone.
> What happened, happened. How do I get this reminder to go away? I cannot
> currently edit these invoices.
It depends on the regulations that governs whatever business you have,
but those are pretty much bad debts, and if you want to write-off those
you'd "pay" them against an Expenses account.
I.e.
Dr. Expenses:Write-Offs 0.01
Cr. Assets:AP:USD0.01
See
https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html#busnss-ar-baddebt
And also similar mailing list threads like
https://lists.gnucash.org/pipermail/gnucash-user/2021-March/095696.html
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
signature.asc
Description: PGP signature
___
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] Tracking Travel expenses
On Tue, Nov 15, 2022 at 08:18:02AM -0800, Stan Brown wrote: > > On 2022-11-15 00:28, Mattia Rizzolo wrote: > > Note that both the A:AR:ToBeReimbursed and A:AR:Other accounts are of > > type "Bank", not of type A/R, since I'm not using the business > > features with those accounts. > > Out of curiosity -- My AR accounts are just of type Asset. What was your > reason for choosing Bank type? I wonder if I missed something. I haven't deeply verified this, but my understanding is that gnucash treats all of "Asset" "Bank" and "Cash" exactly the same with no difference whatsoever. So in my mind I somehow assign "Asset" to something that isn't exactly liquid (like, real estate or other physical assets that should tracked on a balance sheet), and "Bank" for everything that translates directly to "actual money". So I don't think you missed anything and also it doesn't really matter. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] Tracking Travel expenses
What I do while traveling on somebody else's money, I do the following: * Charge all expenses to an account Assets:AccountsReceivable:ToBeReimbursed * I use lots in the ToBeReimbursed accounts to group together expenses related to the same journey (as sometimes I actually have overlapping periods, say I buy a flight ticket to somewhere while I'm already traveling somewhere else, so it's handy to group them) https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101835.html * Once the journey is done, and I'm filing in whatever reimbursement form I need to use for that specific entity I do a transaction from the aforementioned account to Assets:AccountsReceivable:Other (this also closes up the lot in the ToBeReimbursed account) * When the reimbursement money arrives, that will be a transaction between Assets:AccountsReceivable:Other and Assets:Banks: Note that both the A:AR:ToBeReimbursed and A:AR:Other accounts are of type "Bank", not of type A/R, since I'm not using the business features with those accounts. I also employ the same workflow also when traveling with friends when I'm paying for everything (sometimes it's just easier…) or when I'm doing generic expenses that will be reimbursed later by somebody else. On Mon, Nov 14, 2022 at 05:08:52PM -0300, Esteban Maringolo wrote: > What is the recommended account setup and procedure to track > travel expenses (and refund of these) when I use my personal accounts > (cash/credit card) to pay these? > > I don't want the travel expenses to mix with my regular "monthly" expenses, > although I'd like to split them into different categories (food, gas, > hotel, etc.). > > Thanks! > > Esteban A. Maringolo > ___ > 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. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] more integrated lots features
Hi people! Recently I've been noticing and using the "lots" feature a bit more, and I'm finding it quite handy after all. For example, as a FOSS contributor I find myself attending some events and being sponsored for it, or have some expenses on behalf of projects (say, I could buy promotional items (stickers, shirts, etc)) and later be reimbursed for them. In those cases I don't really want to use an invoice (in which case I could record a bill for the expense and "charge" it toward a given client), as I'm not actually invoicing any clients and I don't really want to have invoices in gnucash that don't actually exist also by the national revenue agency So, I created an account Assets:AR:ToBeReimbursed where I charge all the expenses that I plan to ask reimbursement for. In that account I create a lot for each reimbursement request collecting all related expenses (for example, all expenses that I incur while going attending and coming back from an event) and a final transaction crediting this account and debiting a different AR account when sending off the actual reimbursement ticket to whatever organization. The goal is that making sure that the lot is zero-ed out. Now, I suspect I could create a new account for each event (or whatever I have to do), but I found that this "lots" feature makes more sense in my mind, as its own goal is exactly to link together related expenses. So, concluding: I'm not sure if I'm doing justice to the feature by using it this way, but if I am, I can likely find more uses for it. As such, I wonder if any of the developers have any further plan for it? I don't really have any particular UX/UI in mind, besides some kind of sign (colour?) in the transaction ledger that highlight how a particular transaction is related to another. Perhaps with some extra report also highlighting them? -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] Deleting customer
On Sat, Jun 25, 2022 at 09:29:49AM -0400, Derek Atkins wrote:
> You can't.
> Just change it and reuse it for another customer.
Incidentally, in the past I found myself manually editing the .xml and
carefully deleted the gnc:GncCustomer object (and looked up the whole
file for the relevant cust:guid code to check if there were references).
Nothing bad came from it after several months, so I suspect I did it
properly and didn't break anything in it…
But this left me wondering: is this (and the same for vendors and
invoices/bills) just a lacking feature that nobody implemented, or a
design decision?
It doesn't strike me as something incredibly hard to implement (just
check if there is any reference (which IIRC can only be in
bills/invoices objects) before deleting), but perhaps I'm missing
something big in this topic.
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
signature.asc
Description: PGP signature
___
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] Crypto trade directly - not converting to local currency first
Hi, yes, in that example the 50 and the 4M are in local currency. Expenses (which are fondamentally a type of Equity) in gnucash can only be defined and valued in a Currency that is recognized by gnucash as such. Realistically, if you are in situation where you want (and can!) treat cryptos as full currencies, you'll likely be better served by abusing another random currency in the list of known currencies and treat it as btc/eth. See: https://lists.gnucash.org/pipermail/gnucash-user/2022-April/100780.html (which is a recent thread explaining why equities needs to be valued with a currency). On Sun, May 22, 2022 at 12:55:15AM +0700, Suseno Dermawan wrote: > Hi Mattia, > > Thank you for the explanation. > > just a couple question, > in this example: > > Assets:BTC -12333,123.00 4,074,129 > Assets:ETH 456 8,934.38 4,074,079 > Expenses:CryptoFees50 > Trading:Crypto:BTC.. > Trading:Crypto:ETH.. > > is the value is in local currency (e.g. USD)? and expenses also in local > currency ? > because the trading place it charges the expenses in the crypto currency, > for example. > if trade BTC to ETH, then the expenses is in ETH, > if trade from ETH to BTC, the expenses is in BTC. > > if this is the case, then the expenses is converted to local currency ? > > Thank you > > Suseno > > > On Sat, May 21, 2022 at 11:49 PM Mattia Rizzolo wrote: > > > Nothing particularly odd about that. You'll have to do something like: > > > > > >tot shares price tot buy tot sell > > Assets:BTC -123 > > Assets:ETH 456 > > Trading:Crypto:BTC 123 > > Trading:Crypto:ETH -456 > > > > (the Trading: splits should be created automatically, but regardless, > > that's how it'll look). > > > > leave empty the 3 columns on the right, just touch the first column > > labeled "tot shares"; that column is visible only for "Stock" or "Mutual > > fund" kind of accounts, which is what I already expect your accounts to > > be like. > > > > Then again, it might make sense to give value to those shares. If so, > > you could do this: > > > > Assets:BTC -12333,123.00 4,074,129 > > Assets:ETH 456 8,934.49 4,074,129 > > Trading:Crypto:BTC.. > > Trading:Crypto:ETH.. > > > > (I made up the values of BTC and ETH here…) > > > > > > This will also make possible to track the relevant fees in doing such > > transaction: > > > > Assets:BTC -12333,123.00 4,074,129 > > Assets:ETH 456 8,934.38 4,074,079 > > Expenses:CryptoFees50 > > Trading:Crypto:BTC.. > > Trading:Crypto:ETH.. > > > > That most likely make a lot of sense. > > > > > > > > That's something very commonly done when, for example, mutual funds are > > merged into each other, redefined, or something else. Or when you > > instruct your asset management company to switch your investments from > > one fund to another without cashing out in-between. > > Something similar is also done when there are stock splitoffs (but it's > > not exactly the same). > > > > > > BTW, it's not possible to "add btc as a currency type", as the currency > > types in gnucash are hardcoded and only formal currencies as to defined > > by ISO 4217. > > > > > > On Fri, May 20, 2022 at 07:10:22AM +0700, Suseno Dermawan wrote: > > > Hi All, > > > > > > I've been wondering, is there a way to trade between 1 crypto token to > > > another directly? > > > My use case as follows: > > > > > > Ideally able to trade "btc -> eth" vice versa. > > > > > > But for now, I use the registering method as follows: > > > > > > "btc -> local currency -> eth" vice versa > > > Btc sell to local currency, then from local currency buy eth. > > > > > > Btw, I use crypto type as FUND. > > > > > > With using "btc - local currency - eth" way of registering the > > transaction, > > > I found that the loss n gain report is not really accurate. > > > > > > Is it possible to have btc to eth directly? I imagine this will need to > > add > > > both btc n eth as a curre
Re: [GNC] Crypto trade directly - not converting to local currency first
Nothing particularly odd about that. You'll have to do something like: tot shares price tot buy tot sell Assets:BTC -123 Assets:ETH 456 Trading:Crypto:BTC 123 Trading:Crypto:ETH -456 (the Trading: splits should be created automatically, but regardless, that's how it'll look). leave empty the 3 columns on the right, just touch the first column labeled "tot shares"; that column is visible only for "Stock" or "Mutual fund" kind of accounts, which is what I already expect your accounts to be like. Then again, it might make sense to give value to those shares. If so, you could do this: Assets:BTC -12333,123.00 4,074,129 Assets:ETH 456 8,934.49 4,074,129 Trading:Crypto:BTC.. Trading:Crypto:ETH.. (I made up the values of BTC and ETH here…) This will also make possible to track the relevant fees in doing such transaction: Assets:BTC -12333,123.00 4,074,129 Assets:ETH 456 8,934.38 4,074,079 Expenses:CryptoFees50 Trading:Crypto:BTC.. Trading:Crypto:ETH.. That most likely make a lot of sense. That's something very commonly done when, for example, mutual funds are merged into each other, redefined, or something else. Or when you instruct your asset management company to switch your investments from one fund to another without cashing out in-between. Something similar is also done when there are stock splitoffs (but it's not exactly the same). BTW, it's not possible to "add btc as a currency type", as the currency types in gnucash are hardcoded and only formal currencies as to defined by ISO 4217. On Fri, May 20, 2022 at 07:10:22AM +0700, Suseno Dermawan wrote: > Hi All, > > I've been wondering, is there a way to trade between 1 crypto token to > another directly? > My use case as follows: > > Ideally able to trade "btc -> eth" vice versa. > > But for now, I use the registering method as follows: > > "btc -> local currency -> eth" vice versa > Btc sell to local currency, then from local currency buy eth. > > Btw, I use crypto type as FUND. > > With using "btc - local currency - eth" way of registering the transaction, > I found that the loss n gain report is not really accurate. > > Is it possible to have btc to eth directly? I imagine this will need to add > both btc n eth as a currency type? > > Thanks for your help > > Suseno > ___ > 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. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] GNC Fails to load Data File
ase 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. > > > > > > > > > -- > >Derek Atkins 617-623-3745 > >de...@ihtfp.com www.ihtfp.com > >Computer and Internet Security Consultant > > > > > ___ > 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. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] report subaccounts totals on stacked barchart
Hi! My liabilities have this (pretty common, I think) structure: Liabilities |-AP | |- x | |- y | |- z | |-Credit Cards | |- Bank1 | | |- x | | |- y | | | |- Bank2 | |- Bank3 | |-Loans | |- Bank1 | | |- Loan1 | |-Security Deposits # this is money I'm keeping as deposit | |-Apartment1 # for an apartment I'm renting out | |-Tax Provision | |-2021 | | |- Tax1 | | |- Tax2 | | | |-2022 | | |- Tax | | |- Tax2 In this, only the leaf accounts actually contain transactions, all the others are marked as "placeholder". Now, I'd like to have 2 different "Liabilities barchart"s: * one very detailed that contains all possibile stacks * one that contains only the branch totals plus some subaccounts I'm having troubles figuring out which options I should pick in the report settings to get the latter. I'd like to see a barchart containing a stack for each of the following: * AP * Credit Cards:Bank1:x * Credit Cards:Bank1:y * Credit Cards:Bank2 * Credit Cards:Bank3 * Loans * Tax Provision:2021 * Tax Provision:2022 Basically, I want specific stacks for all of the credit cards, but only the total of the other categories. Currently, if in the report account selection I pick the higher level account, nothing is shown on the report, probably because it's not considering the subaccounts. If I click the "Select Children" button, then it goes and shows all subaccounts with each subaccounts with one stack (which is the "detailed" variant that I do want in the other case). I'm using gnucash 4.8, I'd be glad if anybody can show me if and how to accomplish my goal! :) Thank you in advance! -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- ___ 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] Transaction Date issues during import OFX file (TD Bank)
On Wed, Jan 12, 2022 at 5:46 PM xraive . wrote:
> I changed [-5:EST] to [+2:EST] and the dates are working. But I don't know
> why that would work.
FWIW, +2:EST doesn't make sense. If you want UTC+2, that would be
+2:EET (for example).
(though TBH I'm not sure what are the actual parsing rules (according
to the standard) of that datetime string, so it might or might not
change the result)
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
more about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
___
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] problem with a transaction involving 3 securities
Hi, I'm trying out something that until now I didn't try, and that's buying a stock from a broker that handles FX itself "silently" at the time of the transaction (normally for my USD purchases I use an account in USD). I have liquidity account in EUR, and the stock is in USD. So what I attempted is this (seen from the security register, that is in USD): A:Investments:BrokerA:USD:RUSG 2358.28 716.56 A:Investments:BrokerA:Liquidity -634.14 Expenses:Fees:BrokerA0.50 A:Investments:BrokerA:Liquidity -0.50 Trading:CURRENCY:EUR 634.14 Trading:CURRENCY:USD 716.56 Inbalance-USD 716.46 Trading:LSE:RUSG.L -2358.28 716.46 I must add that the Trading:* slices were added automatically. I'm pretty lost on how to balance this transation, after trying a variety of alternatives. My original approach was to add a bunch of Trading: slices (e.g. show the EUR→USD,USD→RUSG.L in a total of 4 Trading: slices, basically turning that Inbalance-USD into Trading:CURRENCY:USD), but it looks like gnucash doesn't let me to have multiple Trading:CURRENCY:USD slices in the same transaction. The only way I found to make this work, is to add a "USD liquidity" account, exchange the EUR for USD there, and from there to buy the shares, but that would split the transactions in two making it a bit less easy to follow what happened. FTR, my broker shows it like this: description fx rate change total Buy 2 RUSG @ 358.28 USD $-716.56$-716.56 Fees €-0.50€ Withdrawal FX €-634.14€ Credit FX 1.13 $716.56$0.00 Do you have an idea on to best record this transaction in gnucash? :) -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] show unposted invoices in customer report?
On Tue, Jan 04, 2022 at 12:46:33PM -0500, Derek Atkins wrote: > The Customer Report is designed to be an "account status" for you to send > to the Customer. Unposted Invoices effectively "do not exist" as far as > the customer is concerned, so should not be in that report. Right, but what about something for *me* to see as well? :D > Having said that, you can do a search for invoice "is not" "posted" and it > will bring a list of all unposted invoices for you. Right, which is similar to what I do, except that it takes 6 clicks to bring up a list, then a double click to open up the search result, then another click to close the search window. And most of those clicks require focus as I need to click the right label in a list, plus the small checkbox to disable the "is posted" selection. I mean, I totally see there is a way, but I'm arguing it's so much harder than it needs be, IMHO. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] show unposted invoices in customer report?
Hi! I like that I'm able to draft an invoice and then keep it open until I'm ready to post it. It makes trivial to me to take note in a place I'm sure I won't forget (because I won't right?) of jobs I completed for a customer, before it comes the time to invoice them for it. However, finding those invoices later on is quite hard. Currently, the only way I found is: business > find invoice > start some search that hopefully will return the unposted invoice I need that (especially the last step) is very bothersome. I'd love to see those invoices in the "customer report" that I get, for example, by double-clicking on a line in the "customers overview" page, then it would be trivial to spot. Such invoices could easily be sorted in an "unposted invoices" section under (or over?) the current table. That feels like the optimal spot for such data, instead of burying them into the deep crevices of the "find invoice" gorge. Am I the only one that feels bothered by the current state of this feature? Anybody has a suggestion on how to improve this? Should I turn my suggestion in a bug report to improve the current "customer report" report? -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] Closing Books - Pros & Cons
On Mon, Jan 03, 2022 at 08:39:26PM -0600, Adrien Monteleone wrote: > You're welcome, and you did right by changing the subject. Unfortunately, > replying to a digest doesn't thread to your original post. (as discussed in > another thread) No way around that of which I am aware, but at least the > subject is the same so we know what you are discussing! Technically, the threading is implemented by following headers such as "References" and "In-Reply-To", which points to all the relevant Message-IDs. One could add those headers manually, but that's clearly behind what's to be expected of anybody who doesn't actually work on IT (and even then, it's too bothersome). -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] Cannot select A/P Account to post Bill to
On Thu, Dec 30, 2021 at 10:06:56PM +0100, Sebastian Naumann wrote:
> And of course you're right. I had classified it as a "Liability", which, in
> my opinion, might be setup a little confusing.
Well, A/P is a type of liability anyway. And it should be under the
bigger "Libility" parent account in the CoA.
But for gnucash A/P and A/R accounts are special as they are meant to be
handled by the bill and invoices features, and you never ever touch the
transations from inside those registers manually (else you're very
easily going to screw up something).
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
signature.asc
Description: PGP signature
___
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] Cannot select A/P Account to post Bill to
On Thu, Dec 30, 2021 at 05:59:47PM +0100, Sebastian Naumann wrote: > I wanted to test out GnuCash, including posting a bill. > > Unfortunately, I am unable to select an A/P Account to post the bill to. The > dropdown in the post modal is simply blank. > > If I try creating a new account via the "NEW" button, everything works fine > and the account shows up in the dropdown, allowing me to post the bill. In my experience, that's usually a sign that the A/P account is not actually of "type" A/P. Try clicking "edit account" and check the "account type" section. If it's not of type "A/Payable" then you'll need to create a new account and select the correct type (for some reason it seems impossible to change an existing account to be of A/P type, at least here it seems to be restricted as a valid option only during account creation). > Also, I want to wish everyone a great start into the New Year. Happy new year to you too! :) -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] The correct way to account for prepaid things that comes with bonuses
Hi David, Gyle. Thank you for your input. It looks both of you agree that this should be a negative expense rather than in income. On Tue, Dec 07, 2021 at 06:35:22AM +1000, davidcousen...@gmail.com wrote: > This would allow you to keep track on > both the original expense and the economic benefit you receive by the bulk > purchase Good point, indeed. > However if your jurisdiction were to tax such discounts, treating it as income > will likely be more appropriate. It is really the tax treatment which decides > how best to account for it. > If you are unsure consult an accountant in your jurisdiction. This book is for personal porpuses, and in any case that purchase is done for me, rather than for my business. I'm not sure about the tax implication of such bonuses for business, but for people it's not taxable (I'm sure here!), so marking it down as a negative expense is fine here. Regardless, then, another question that I didn't consider it earlier. The negative charge in that's going to be Expenses:Travel:Rental: should it be credited in bulk at the time of the purchase of the pack, or somehow split over multiple accounting periods? If yes, how would I go about splitting this? Thanks again for your help! :) -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] The correct way to account for prepaid things that comes with bonuses
Hi!
I wanted to more correctly account for the local "moped sharing" company
we have here, which offers to buy a prepaid package that comes with a
bonus.
In this case, I bought a 90€ package that comes with a 40€ bonus, so my
in-app wallet is credited with 130€.
I planned to store that 130€ in Assets:PrepaidExpenses, to be whittled
down whenever I do rent a moped, at which point it's expensed.
Now, that sounds all fine to me, but I'm not really sure where those 40€
should come from.
Right now I did:
2021-10-08 Buy package
Assets:PrepaidExpenses:Moped 130.00
Liabilities:CreditsCards:…… 90.00
Income:Bonuses 40.00
2021-11-04 Rental
Assets:PrepaidExpenses:Moped4.93
Expenses:Travel:Rental4.93
(etc)
But I don't think that should really come from Income: :\
Opinion/suggestions/recommendations? :)
Thank you in advance!
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
signature.asc
Description: PGP signature
___
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] Backports in Ubuntu? was: Ubuntu binary fairly dated
Disclaimer: I'm actually an Ubuntu developer (and a Debian Developer too!), though I'm not actually involved on the maintenance of the gnucash package :) On Sat, Dec 04, 2021 at 12:13:04AM +0100, Frank H. Ellenberger wrote: > Am 03.12.21 um 22:19 schrieb Mike Brady: > > Have been following this thread because I use Linux Mint, which is based > > on the LTS version of Ubuntu. Yes, the GnuCash version in the Ubuntu LTS > > repository is way out of date (3.8). > > AFAIK the Ubuntu family is a branch of the Debian family. And Debian has > usually recent GnuCash versions in their Backports repos. That's not totally correct. Debian currently ships: Debian release gnucash release * 10 (oldstable) 3.4 * 10 (oldstable-backports) 4.4 * 11 (stable) 4.4 * 11 (stable-backports)-nothing- * 12 (testing) 4.6 * (unstable) 4.8 (this was literally uploaded today) > Q1: Offers Ubuntu no backports repos? It does. I just so happen (!) to be involved in the Backports team. Ubuntu backports have been basically not-functional for years now, but we have been re-bootstrapping the project. So, I suppose, I could see about backporting it to ubuntu focal-backports (20.04-bpo). But I'm currently very busy with other projects, so this won't happen extremely soon at least. > If the answer is No, Why? > Perhhaps worth to discuss with the Ubuntu user base? The place to discuss these things, rather than with the "user base" (what's that? ;) would be either ubuntu-devel-disc...@lists.ubuntu.com (for general stuff) or ubuntu-backpo...@lists.ubuntu.com (for the backports project specifically), both MLs require subscription. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] read-only accounts
On Fri, Dec 03, 2021 at 06:52:57PM -0500, D. via gnucash-user wrote: > Placeholder account registers are displayed as greyed out. While it's > not necessarily obvious upon first viewing, it becomes clearer when > you try to add a transaction (and it prevents you). Indeed, I agree there are plenty of details that are telling you to not touch those splits (the number and effectivness of which depends from where you are actually trying to touch them). But well, it feels like all of them are subpar. > I do agree with the OP that the way gnucash handles transactions in > placeholder accounts is very confusing. I've raised this point in the > past > (https://lists.gnucash.org/pipermail/gnucash-devel/2017-February/040345.html). > > Clearly, it's a complicated issue. I have a feeling that this "placeholder" flag ought to be split. It might just the way I'm using gnucash, but the way I started using placeholder accounts is basically to use them only as an internal nodes (<https://en.wikipedia.org/wiki/Tree_(data_structure)>), which do not contain any data (transactions in this case) (incidentally, I also do not have any internal node that is not a placeholder account). I think that ought to be the real "placeholder", whereas a separate "read-only" flag coule be useful to set for all the other cases where you want to freeze the account from any possible future change whatsoever. However I realize such change is likely to be: 1) not trivial to implement 2) not easy at all to deploy to already existing books (because neither the "new placeholder" I described above nor the "read-only" flags match the current behaviour) 3) possibly controversial due to the plenty of ways one might be managing their books So I guess for now the way is to set them to placeholder and pay attention to the edits one does :D -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] read-only accounts
On Fri, Dec 03, 2021 at 11:50:11AM -0500, Michael or Penny Novack wrote: > On 12/3/2021 10:27 AM, Glenn Fowler wrote: > > Hi, > > > > What about just making the file read only with no write permission? > > > > On Fri, Dec 3, 2021 at 9:17 AM Mattia Rizzolo wrote: > > THAT is looking in the right direction. If you want to "freeze" the books as > of a certain state make a copy of the file that is "read only". You could > use the Julian date in the name you give this file so you can tell it apart > from "freezes" made at other times. Oh, reading it again my mail I noticed I wrote "I reconciled the whole book" - apologies, that wasn't what I meant. I accidentally typed "book" instead of "account". I'm really only referring to a single account across the whole book, that is still otherwise in active use. You can see it similarly to when you close a bank account or a credit card: you totally want to keep it around, but you don't want to touch the transactions involved with it anymore. In those cases, do you just go on with life hoping you're not going to mess with it? -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] How to record accrued interest
Hi Stan!
On Thu, Dec 02, 2021 at 01:35:35PM -0800, Stan Brown wrote:
> I think you have done it exactly right!(*) Here interest is paid
> monthly, as it's accrued, so I don't have your exact issue. But banks
> often give rebates on credit-card purchases, and I record those the same
> way you are recording interest.
>
> One suggestion: Rather than AccountsReceivable:EUR, you might think
> about AccountsReceivable:Bank1. That way if you are owed money by some
> other bank, or a refund from a taxing authority, you could put that into
> AccountsReceivable:{name of other agency}.
Thanks for confirming!
So I went ahead and moved those transactions to A:AR:Bank1 (and
L:AP:Bank2 for the interest I'll have to pay). It does "look" correct
to me as well, so guess I'll go this way! ^^
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
___
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] read-only accounts
On Thu, Dec 02, 2021 at 08:33:51PM -0500, Derek Atkins wrote: > Mark the account as a PlaceHolder account and it'll be read-only. Oh, that's a nice trick I didn't think of! Thanks! Howver, it seems to me that it doesn't fully lock down the account. If I tried to change a split belonging to that account from "the other side", it first nags me about changing a reconciled split, then it errors out saying that "the account doesn't allow transactions" (because it's read-only), but it then still proceeds to record the changes, regardless of the warning. Is that the expected behaviour? -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- ___ 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] read-only accounts
Hi! while moving data that I used to keep into spreadsheets into more decent books, I found myself looking for a way to mark whole accounts as "read-only". For example: here I have an Income account that records all of the rent that came through a given tenant in a given apartment. Everything's great, but now I'd really like to make sure I'm not going to accidentally edit that data, while still keeping it there and visible. I reconciled the whole book, which helps a bit, but I'd like something more… "hard" (for lack of better words right now".") Do anybody have any good suggestion for such use case? :) TIA! -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- ___ 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] How to record accrued interest
Hi! I'd like a suggestion on how to best record accrued interest from my checking accounts. (please consider I'm in Europe, so interest is *low* heh). Banks here calculate interest in various periods of competence (that I'd like to record in gnucash), but it normally becomes eligible once a year (at least for people, positive interest is normally credited onto the account with a value date of 1st of January, negative interest is charged on the 31st of March). So, here is an example of "positive interest" that a bank owes to me. Here is what I did: Dr. Cr. 2021-06-30 Expenses:Taxes:CapitalGain:Bank10.01 Assets:AccountsReceivable:EUR 0.02 Income:InterestIncome:Checking 0.03 2021-09-30 Expenses:Taxes:CapitalGain:Bank10.02 Assets:AccountsReceivable:EUR 0.06 Income:InterestIncome:Checking 0.08 My plan is to credit AR and debit the actual Assets:Banks:Bank1 account of whatever it's going to come to by the end of the year. Is this the proper way to do it? Now, the documentation says that I should avoid directly using the AR account by myself, bypassing the business' customer features, otoh it feels silly to record my bank as a "customer" and issue an invoice for interest I'm owed :3 Should I just create a random "asset" account for all of the ARs that I'm going to manually track? Would it be fine to create it as a subaccount of the main Assets:AccountsReceivable hierarchy, perhaps still of type "A/R"? Likewise, I actually have the same situation with negative interest that I owe to another bank where I operate with a negative balance: I have a monthly report of how much interest I accrued, which I'll have to pay next year, so I'd like to set this up under Liabilities:A/P (even more important because clearly the numbers are a tad higher than the example above u.U), but I guess it's the same thing as above, so just referring to that ought to be fine. Thank you for your guidance! :) -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- ___ 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] link bank statement to all reconciled transactions?
Hi all,
somehow my googling doesn't even suggest anybody ever asked this…
Is there a way so that all reconciled transactions link to a document
(say, the actual bank statement) while also linking to their own
attached documents?
It feels like this would be solved if a document was property of a
split, but being a property of the whole transaction it means only one
document per transaction right?
Or perhaps a property of the "split:reconciled-state" element, but then
it would be even more something attached to the split and not to the
transaction I guess.
This is even ignoring the fact that there doesn't seem a UI to link the
same document to multiple transactions.
How do people normally link their "official" bank statement to their
books in gnucash?
--
regards,
Mattia Rizzolo
GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
More about me: https://mapreri.org : :' :
Launchpad user: https://launchpad.net/~mapreri `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
signature.asc
Description: PGP signature
___
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] how to link an expense (a tax) to a invoice being issued
Very well David, I shall do as you suggest then! Thank you! On Fri, Oct 22, 2021 at 10:50 PM wrote: > > Hi Mattia, > > I think you summay has captured the essentials. Whether you use a Liability or > an Asset Acciunt to record the value of the stamps will not matter in practice > but an asset account more correctly reflects the actual situation. > > My description is appropriate when your business is using an "accrual" > counting > methodology. This primarily relates to the timing of the recording of income > and > expenses. Some jurisdictions allow a "cash" accounting basis usually unde a > specific turnover or income threshold where events are recorded at the time > the > money actuallyexchanges hands. > > If you are passing the tax through to the customer, it is the customer who is > actually paying the tax. You are in effect acting as an unpaid agent for the > tax > office. You are receiving back from the customer the amount you paid for the > tax > stamps so it is revenue and expense neutral. This is the primary reason it is > not an expense for you. > > David Cousens > > On Fri, 2021-10-22 at 11:59 +0200, Mattia Rizzolo wrote: > > Hi David, thank you for your insights! > > > > So, to highlight the differences between my thoughts and yours: > > > > * prepaid stamps as an asset, not a negative liability > > * tax passed as-is to the customers are not actually expensed (since > >the invoice would have as the "income account" to debit the > >Assets:TaxStampsPrepaid or Liabilities:TaxPayableDeferred accounts > >directly) > > * when not passing the tax stamp onto the customer, that would be my > >expense, without any direct link to the actual invoice. > > > > > > Is my understanding here correct? > > Especially, from a formality point of view, is it really correct to *not* > > expense the tax stamps I'm passing over to customers? > > > > -Mattia > > > > On Fri, Oct 22, 2021 at 12:26:18PM +1000, davidcousen...@gmail.com wrote: > > > Mattia, > > > > > > When you purchase tax stamps in advance, they become a temporary asset of > > > your > > > business which you would expense at the time you attach then to an > > > invoice.when > > > you purchase the stamps you would credit your bank account by the amount > > > of > > > the > > > purchase and debit an appropriate asset account (e.g. > > > Asset:Current:TaxStampsPrepaid). > > > > > > If you don't pass the tax onto the customer it won't appear as a line item > > > in > > > the invoice and simply becomes an expense on your business. You would at > > > the > > > same time as you raise the invoice and attach the tax stamp create a > > > transaction > > > which credits the above asset account and debits an Expense:TaxPaid > > > account. > > > > > > If you are passing it on to the customerthen create a secondline in the > > > invoice, > > > Add an appropriate description,set the Income account to > > > Asset:Current:TaxStampsPrepaid and set the amount of the attached tax > > > stamp. > > > This will add the value of the tax stamp to the A/R account and credit > > > Asset:Current:TaxStampsPrepaid > > > > > > On the other hand when you raise an electronic invoice and payment is > > > deferred > > > to a future date, then the tax component is a liability on your business > > > which > > > you would record inan account labelled something like > > > Liabilities:TaxPayableDeferred. > > > > > > Again if your business is paying the tax and it is not being passed onto > > > the > > > customer then in parallel to raising the customer invoice you would > > > create a > > > separate transaction which credits Liabilities:TaxPayableDeferred and > > > debits > > > an > > > expense account Expense:TaxPaid and there would be no line item in the > > > invoice > > > to the customer. > > > > > > If you are passing the tax onto the customer, then when you raise the > > > invoice > > > you add a second line for the tax , set the Income Account to your > > > Liabilities:TaxPayableDeferred account and enter the amount of the tax > > > payable > > > in that line. This will create a credit to the > > > Liabilities:TaxPayableDeferred > > > account with a matching debit added to the sum of the other lines to the > > > A
Re: [GNC] how to link an expense (a tax) to a invoice being issued
Hi David, thank you for your insights! So, to highlight the differences between my thoughts and yours: * prepaid stamps as an asset, not a negative liability * tax passed as-is to the customers are not actually expensed (since the invoice would have as the "income account" to debit the Assets:TaxStampsPrepaid or Liabilities:TaxPayableDeferred accounts directly) * when not passing the tax stamp onto the customer, that would be my expense, without any direct link to the actual invoice. Is my understanding here correct? Especially, from a formality point of view, is it really correct to *not* expense the tax stamps I'm passing over to customers? -Mattia On Fri, Oct 22, 2021 at 12:26:18PM +1000, davidcousen...@gmail.com wrote: > Mattia, > > When you purchase tax stamps in advance, they become a temporary asset of your > business which you would expense at the time you attach then to an > invoice.when > you purchase the stamps you would credit your bank account by the amount of > the > purchase and debit an appropriate asset account (e.g. > Asset:Current:TaxStampsPrepaid). > > If you don't pass the tax onto the customer it won't appear as a line item in > the invoice and simply becomes an expense on your business. You would at the > same time as you raise the invoice and attach the tax stamp create a > transaction > which credits the above asset account and debits an Expense:TaxPaid account. > > If you are passing it on to the customerthen create a secondline in the > invoice, > Add an appropriate description,set the Income account to > Asset:Current:TaxStampsPrepaid and set the amount of the attached tax stamp. > This will add the value of the tax stamp to the A/R account and credit > Asset:Current:TaxStampsPrepaid > > On the other hand when you raise an electronic invoice and payment is deferred > to a future date, then the tax component is a liability on your business which > you would record inan account labelled something like > Liabilities:TaxPayableDeferred. > > Again if your business is paying the tax and it is not being passed onto the > customer then in parallel to raising the customer invoice you would create a > separate transaction which credits Liabilities:TaxPayableDeferred and debits > an > expense account Expense:TaxPaid and there would be no line item in the invoice > to the customer. > > If you are passing the tax onto the customer, then when you raise the invoice > you add a second line for the tax , set the Income Account to your > Liabilities:TaxPayableDeferred account and enter the amount of the tax payable > in that line. This will create a credit to the Liabilities:TaxPayableDeferred > account with a matching debit added to the sum of the other lines to the A/R > account. > > Wehn your tax liability is paid your check account is credited by the total of > the amount paid and the Liabilities:TaxPayableDeferred account is debited by > the > same amount. > > This is of course a generic treatment and may be altered by specific > regulations > and law which may apply in your jurisdiction. > > > David Cousens > > > On Fri, 2021-10-22 at 00:01 +0200, Mattia Rizzolo wrote: > > Hi people! > > > > With the disclaimer that I'm keeping these books for myself, as I'm not > > required by law to keep them at all, here I come ask you about this > > specific tax. > > > > Also, this turned quite longer than I thought it would, actually while > > writing my thoughts cleared quite a bit... :) Guess that's a kind of > > "rubber duck debugging"! > > For the quicker version go straight to below where I describe my case in > > way more practical terms. > > > > > > > > Background: > > When I issue an invoice I may (or may not) have to pay a 2€ duty stamp > > and attach it to the invoice. That's an effect specific to the fact > > that I produced a document, and I also need to attach such duty stamp > > to credit notes, for example. > > Now, if I do a paper invoice, I most likely already bought weeks/months > > prior a stash of those duty stamps. Instead, if I'm doing an electronic > > invoice, the payment for those stamp is deferred to the next quarter. > > Furthermore, I may or may not (my choice) bill the customer for the > > expense of this duty stamp. > > > > So I am a bit lost on how to properly account for this thing. To me is > > an expense, that may or may not be charged back to the customer, but I > > would also like to gather data on, like, how many invoices I'm issuing > > that I am not billing the duty stamp on, so I wouldn't like to "hide&
Re: [GNC] Imbalance on Fixed Income Transaction
Hi Bruce! I believe you are missing something foundamental on how double-entry bookkeeping works. Every time you make a change to one account (in your case FI1 and FI2) there *need* to be another corresponding and opposite change to another. In your case, that's likely means some kind of checking account. If you write nothing there and just press return, GnuCash will automatically match whatever is not matched already to an "Imbalance" account, which collects all kind of splits that weren't properly assigned. More practically, you are using the "basic ledger" that means that you'll have to move on where "Imbalance-USD" is and change it to, say, Assets:Banks:Checking or somesuch, depending on where the money actually went. You should probably have a look at the manual at https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-accounting1.html to have a better idea on how that should work. Reconciling doesn't really help for that, since that really should only be used for things like checking if your account transactions match what your bank think it should be and is not going to re-assign splits to other accounts on its own. Hope to have been of help! On Thu, Oct 21, 2021 at 11:44:00PM +0200, Bruce wrote: > Just setting up GnuCash 3.8b+(2019-12-29) for the first time > on an HP EliteDesk 800 G1 running LinuxMint v20.02 Cinnamon. > And yes, I've had Bookkeeping-101 in College, 40+ yrs ago. > And it was processed by an IBM 360 Mainframe. > > What I'm not understanding is the basics behind the "Imbalance" result. > I have set up all the top level accounts, and then added FI1 and FI2 (Fixed > Income 1&2) as subs below the 'Income' top level account. > > My two FI's come in at different times, one on the first of each month, the > other on the Second Wednesday, which I will eventually want to set up > recurring automatic transactions for those two sources (which I basically > already have figured out). > > After opening the register (ledger) for FI1 and entering a transaction for > that allotment, lets say $1000.00 and saving it, then opening the transaction > register for account FI2, and doing the same, for the same amount and saving > that... The main top level account page shows a total income of $2000.00, > which is correct and I understand, but directly above that is the > "Imbalance-USD" line, and if each transaction is once again opened each shows > an 'Imbalance' for the Transfer field in the amount of the transaction. > > I have reconciled both of these transactions basically meaning that I have > seen proof that the transaction occurred by statement or by funds-in-hand and > ticked the "R" box in the respective line, which changed to a "c", and is now > a "y". But the 'Imbalance' notice remains and the amount does not change. > > Once the transactions are reconciled, should not the imbalance go away ? > > I realize the answer to this is likely a simple one, > but it is alluding me at the moment, input appreciated. > > And lastly... Is it advisable to update to v4.8 under Mint ? > I notice that the doc page says it should be available through the 'Software > Center' on Ubuntu, but I just installed THIS version (3.8) from the Mint > 'Software Manager', and I'm limited to Cellular downloads at the moment, so > I'd rather not do the 800+MB FlatHub (which is v4.8). > > Bruce > (just another old retired Vet trying to keep his funds straight) > > ___ > 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. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] how to link an expense (a tax) to a invoice being issued
this magic linking that I would love to have with these 2 splits and the actual invoice, I think nothing more is needed. 6. For the paper invoice claiming back the duty stamp, it should be like case 4 with the :Pre account, nothing else. 7. When I go to settle the postponed duty stamp and the end of the quarter I suppose I'll simply do: Debit Credit Balance Liabilities:Tax:DutyStamps:Post4.000.00 Assets:Banks:Checking 4.00 496.00 And be done. Am I in the right direction? Do you spot anything totally wrong? And how would you handle these details I'm unsure about? Thank you in advance for any thought and input you might be able to give to me! :) -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] Handling personal yet-to-pay bills
Hi Gyle! Thanks for answering. I already tried adding transactions with a future date, and that indeed turned out to be as useful as I expected. So far I've done that for things like bank transfers or direct debits that are already issued with a future date. Examples recently were some credit card bills coming in, for which I recorded the payments at the date they will be debited to my checking account, since that was sure to happen. As a more practical example, right now I have two outstanding payments: the electricity bill that is due on November 22nd (that I'll pay with my credit card; the electric company doesn't do recurring charges to credit cards, go figure…), and a tax payment due on November 30th. I have no idea *yet* when I'm going to execute those two payments so, I suppose I'll either have to edit the already-recorded transaction if I simply handle it as you suggests (googling past similar question I saw somebody using a special string in the "memo" field to recognize them). On Sat, Oct 16, 2021 at 02:29:18PM +, Gyle McCollam wrote: > You could go the more accounting route and use an accounts payable > account or you could do what I do, since I use it for personal > accounting purposes, and just record it in the usual account say debit > electric and credit your bank account (Checking I assume) on the date > you actually are going to pay it. What that does, it shows your > "future balance". GNUCash shows a blue line at the current date and > all future payments below the line. You could either write the check > now or refer to your checking account to see when you actually need to > write the checks. I was a bit surprised that you can't have those > expenses automatically deducted when they are due. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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] Handling personal yet-to-pay bills
Hi people! I'm a new gnucash user, starting pretty much now. I'll start by saying that despite being a self-employed contractor (and such I am making use of some of the business features of gnucash), my fiscal position in my country (Italy) doesn't impose me any kind of obligation concerning account reports. As such the focus of my set up is really personal, and for now I'm not trying to do things like figuring my tax filings from this. Furthermore I'm allowed to mix "my" money and "my business" money, so effectively my assets are mixed. I have been looking for a more featureful tool than a crude spreadsheet to track all of my assets (and changes to them), that span multiple banks and brokerages (and I also believe I do relatively complex/unusual things that I'd love to be able to track, but I'll come back at a later moment to those). In fact I've been quite happy to discover that the grand total was actually more than what I thought I had at hand :D So thank you to the devs for this program that for now made me very satisfied! :) With that out of the way, today I would like to start with asking the wider community how you'd suggest to track "personal bills" that come and needs to be paid. I'm referring to things like utility bills (phone, electricity, etc) or tax payments that needs to be done; especially those payments that are done manually and don't direct debit to the checking account or credit card. I'd like to have those kind of things filed in even if the actual payment has not been instructed yet, in which case it should count toward a liability (since after all it would an A/P). That would likely also help me remind me of the deadlines. I'm aware of the "bills" feature (that I already started to use with a business vendor, and looks like it's behaving exactly as I'd expect), but I'd like to double check with you if as a user in my situation I'm expected to use the same "business feature" also for personal things? Thanks in advance for your support and sorry for being long-winded! -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ 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.
