Re: [GNC] how to create monthly revenue and expense report for just one year

[Adrien Monteleone]

There is also:

Reports > Experimental > Income Statement (Multicolumn)

*this will be moved out of 'Experimental' for version 5.0 and into the 
regular reports menus. (I think it doesn't handle multi-currency very 
well, yet...)


In the report Options > General tab, set Period Duration to 'One Month' 
then decide on the ordering option and if you want a total column. 
(note, the 2-column option is disabled, as is the option to disable 
indenting, as that is automatic with a multi-period report)


Also set your start and end dates to be the beginning and end of last 
year. (either using an absolute date, or the descriptive drop downs)


That will get you a consolidated Monthly P with an optional YTD P 
all in the same report.


Play with this as you need, to get Quarterly, or other types of 
reporting periods and breakdowns.




Regards,
Adrien

On 1/25/23 3:39 PM, Eric Hammond wrote:

Hi Murugan,

That gives me what I need, and a better idea of how to navigate GnuCash reports 
in general.
I think some of my difficulty is that I have lived in a Microsoft world too 
long 


___
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 create monthly revenue and expense report for just one year

[Eric Hammond]

Hi Murugan,

That gives me what I need, and a better idea of how to navigate GnuCash reports 
in general.
I think some of my difficulty is that I have lived in a Microsoft world too 
long 

Thanks,
Eric

From: Murugan Muruganandam 
Sent: Wednesday, January 25, 2023 1:15 PM
To: Eric Hammond ; gnucash-user@gnucash.org
Subject: Re: how to create monthly revenue and expense report for just one year

hi Eric

you can look up in the profit and loss report

in Reports ->Income & Expenses -> Profit and Loss


Click on options ->General  you can select start and end date as start of 
previous year , end of previous year





if you want monthly overall Income and expenses



Select

Report ->Income & Expenses -> Income & Expenses bar chart



click on options -> Display -> Show table

this will give the month wise income and and expenses



you can export the report to html or csv for your further analysis



Saludos Cordiales



Murugan


From: gnucash-user 
mailto:gnucash-user-bounces+m.muruganandam=hotmail@gnucash.org>>
 on behalf of Eric Hammond mailto:e...@jehammond.net>>
Sent: Wednesday, January 25, 2023 5:44 PM
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] how to create monthly revenue and expense report for just 
one year

I record revenue and expenses separately (here income is revenue - expenses)
I need to create an "income and expense" report, only last year, for my yearly 
business taxes.
A simple two-line report would be ok, I would prefer to have it by month.
 I do not find such in the Reports menu, nor can I alter the allowed reports.
How do I create this report?

Thank you for the help,
Eric Hammond

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] coalesce the stock accounts in the report

[Mattia Rizzolo]

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] how to create monthly revenue and expense report for just one year

[Murugan Muruganandam]

hi Eric

you can look up in the profit and loss report

in Reports ->Income & Expenses -> Profit and Loss


Click on options ->General  you can select start and end date as start of 
previous year , end of previous year



if you want monthly overall Income and expenses


Select

Report ->Income & Expenses -> Income & Expenses bar chart


click on options -> Display -> Show table

this will give the month wise income and and expenses


you can export the report to html or csv for your further analysis


Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Eric 
Hammond 
Sent: Wednesday, January 25, 2023 5:44 PM
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] how to create monthly revenue and expense report for just 
one year

I record revenue and expenses separately (here income is revenue - expenses)
I need to create an "income and expense" report, only last year, for my yearly 
business taxes.
A simple two-line report would be ok, I would prefer to have it by month.
 I do not find such in the Reports menu, nor can I alter the allowed reports.
How do I create this report?

Thank you for the help,
Eric Hammond

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Fred Bone]

On 25 January 2023 at 20:35, Dr. David Kirkby said:

> On Wed, 25 Jan 2023 at 19:29, Dr. David Kirkby <
> drkir...@kirkbymicrowave.co.uk> wrote:
> 
> >
> > I have the attached transaction showing as owing $0.98 to Porkbun.com.
> > The number 0.98 happens to be the difference between what this cost in
> > USD ($6.90) and what it cost in pounds (£5.92).
> >
> >  6.90-5.92=0.98.

That sounds as though you have set a 1:1 conversion rate between the two 
currencies ...


___
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 create monthly revenue and expense report for just one year

[Eric Hammond]

I record revenue and expenses separately (here income is revenue - expenses)
I need to create an "income and expense" report, only last year, for my yearly 
business taxes.
A simple two-line report would be ok, I would prefer to have it by month.
 I do not find such in the Reports menu, nor can I alter the allowed reports.
How do I create this report?

Thank you for the help,
Eric Hammond 

___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Dr. David Kirkby]

On Wed, 25 Jan 2023 at 20:35, Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

>
> I forgot one of the attachments.
>

The money shown outstanding to RS Components Ltd, in GBP, is correct. It's
the USD and HKD ones that are wrong.

Dave
___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Dr. David Kirkby]

On Wed, 25 Jan 2023 at 19:29, Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

>
> I have the attached transaction showing as owing $0.98 to Porkbun.com. The
> number 0.98 happens to be the difference between what this cost in USD
> ($6.90) and what it cost in pounds (£5.92).
>
>  6.90-5.92=0.98.
>

I forgot one of the attachments.
___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Dr. David Kirkby]

On Wed, 25 Jan 2023 at 20:10, Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> can you try running Check & Repair all and check if it solves your issue
>
>
> Saludos Cordiales
>
>
> Murugan
>

I have tried that, and it does not.

Dave
___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Dr. David Kirkby]

On Wed, 25 Jan 2023 at 20:04, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I'm not saying this is particularly necessary, (I'm not sure myself) but
> just for completeness of information:
>
> Do you have Trading Accounts turned on?
>
> Regards,
> Adrien
>

No.
___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Murugan Muruganandam]

can you try running Check & Repair all and check if it solves your issue




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Dr. 
David Kirkby 
Sent: Wednesday, January 25, 2023 4:29 PM
To: GNU Cash User 
Subject: [GNC] Have I screwed up with my Accounts Payable and Accounts 
Receivable?

I have some issue with some non-GBP transactions showing as outstanding if
I look at

Business -> Reports -> Payable Aging.
Business -> Reports -> Receivable Ageing.

An amount of money appears to be payable on some transactions, despite I
believe they are all paid.

I have the following structure

Assets :Accounts Receivable
Assets :Accounts Receivable:Accounts Receivable (USD)
Assets :Accounts Receivable:Accounts Receivable (EUR)

Assets :Accounts Receivable is *not* a placeholder account, but a GBP
account. This means there are non-GBP accounts under a GBP account. Is that
a bad idea?

I initially had
Assets :Accounts Receivable (placeholder)
Assets :Accounts Receivable:Accounts Receivable (GBP)
Assets :Accounts Receivable:Accounts Receivable (USD)
Assets :Accounts Receivable:Accounts Receivable (EUR)

but got fed up having to select Assets :Accounts Receivable:Accounts
Receivable (GBP) for 99% of the transactions. So now Assets :Accounts
Receivable is a GBP account, and is selected by default. I'm wondering if
my layout is fundamentally flawed, having a non-GBP account as a
sub-account of a GBP account.

I have the same issues on Liabilities: Accounts Payable. In that case there
are USD and HKD accounts under a GBP account.

I have the attached transaction showing as owing $0.98 to Porkbun.com. The
number 0.98 happens to be the difference between what this cost in USD
($6.90) and what it cost in pounds (£5.92).

 6.90-5.92=0.98.

So I'm starting to wonder if my accounts structure is wrong, and I should
make Assets :Accounts Receivable and Liabilities: Accounts Payable into
placeholder accounts,

If I have made a fundamental error, it would be good in GnuCash could spot
these, and non allow sub-accounts like this. If I have not made an error,
then I need to resolve why these transactions are appearing to have money
outstanding, despite there is not.

Of course, the next problem is, if I should indeed have messed up, whether
it's possible to recover. The GBP side of these has been reconciled, so
deleting the transactions is probably not a good idea. Maybe setting up new
accounts is possible, and changing the accounts things are debited or
credited to.
___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Adrien Monteleone]

I'm not saying this is particularly necessary, (I'm not sure myself) but 
just for completeness of information:


Do you have Trading Accounts turned on?

Regards,
Adrien

On 1/25/23 1:29 PM, Dr. David Kirkby wrote:

I have some issue with some non-GBP transactions showing as outstanding if
I look at

Business -> Reports -> Payable Aging.
Business -> Reports -> Receivable Ageing.

An amount of money appears to be payable on some transactions, despite I
believe they are all paid.

I have the following structure

Assets :Accounts Receivable
Assets :Accounts Receivable:Accounts Receivable (USD)
Assets :Accounts Receivable:Accounts Receivable (EUR)

Assets :Accounts Receivable is *not* a placeholder account, but a GBP
account. This means there are non-GBP accounts under a GBP account. Is that
a bad idea?

I initially had
Assets :Accounts Receivable (placeholder)
Assets :Accounts Receivable:Accounts Receivable (GBP)
Assets :Accounts Receivable:Accounts Receivable (USD)
Assets :Accounts Receivable:Accounts Receivable (EUR)

but got fed up having to select Assets :Accounts Receivable:Accounts
Receivable (GBP) for 99% of the transactions. So now Assets :Accounts
Receivable is a GBP account, and is selected by default. I'm wondering if
my layout is fundamentally flawed, having a non-GBP account as a
sub-account of a GBP account.

I have the same issues on Liabilities: Accounts Payable. In that case there
are USD and HKD accounts under a GBP account.

I have the attached transaction showing as owing $0.98 to Porkbun.com. The
number 0.98 happens to be the difference between what this cost in USD
($6.90) and what it cost in pounds (£5.92).

  6.90-5.92=0.98.

So I'm starting to wonder if my accounts structure is wrong, and I should
make Assets :Accounts Receivable and Liabilities: Accounts Payable into
placeholder accounts,

If I have made a fundamental error, it would be good in GnuCash could spot
these, and non allow sub-accounts like this. If I have not made an error,
then I need to resolve why these transactions are appearing to have money
outstanding, despite there is not.

Of course, the next problem is, if I should indeed have messed up, whether
it's possible to recover. The GBP side of these has been reconciled, so
deleting the transactions is probably not a good idea. Maybe setting up new
accounts is possible, and changing the accounts things are debited or
credited to.


___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Dr. David Kirkby]

I have some issue with some non-GBP transactions showing as outstanding if
I look at

Business -> Reports -> Payable Aging.
Business -> Reports -> Receivable Ageing.

An amount of money appears to be payable on some transactions, despite I
believe they are all paid.

I have the following structure

Assets :Accounts Receivable
Assets :Accounts Receivable:Accounts Receivable (USD)
Assets :Accounts Receivable:Accounts Receivable (EUR)

Assets :Accounts Receivable is *not* a placeholder account, but a GBP
account. This means there are non-GBP accounts under a GBP account. Is that
a bad idea?

I initially had
Assets :Accounts Receivable (placeholder)
Assets :Accounts Receivable:Accounts Receivable (GBP)
Assets :Accounts Receivable:Accounts Receivable (USD)
Assets :Accounts Receivable:Accounts Receivable (EUR)

but got fed up having to select Assets :Accounts Receivable:Accounts
Receivable (GBP) for 99% of the transactions. So now Assets :Accounts
Receivable is a GBP account, and is selected by default. I'm wondering if
my layout is fundamentally flawed, having a non-GBP account as a
sub-account of a GBP account.

I have the same issues on Liabilities: Accounts Payable. In that case there
are USD and HKD accounts under a GBP account.

I have the attached transaction showing as owing $0.98 to Porkbun.com. The
number 0.98 happens to be the difference between what this cost in USD
($6.90) and what it cost in pounds (£5.92).

 6.90-5.92=0.98.

So I'm starting to wonder if my accounts structure is wrong, and I should
make Assets :Accounts Receivable and Liabilities: Accounts Payable into
placeholder accounts,

If I have made a fundamental error, it would be good in GnuCash could spot
these, and non allow sub-accounts like this. If I have not made an error,
then I need to resolve why these transactions are appearing to have money
outstanding, despite there is not.

Of course, the next problem is, if I should indeed have messed up, whether
it's possible to recover. The GBP side of these has been reconciled, so
deleting the transactions is probably not a good idea. Maybe setting up new
accounts is possible, and changing the accounts things are debited or
credited to.
___
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] Gift of stock

[David T. via gnucash-user]

I think it's even more confusing in this case, because tax law does 
occasionally push the original cost basis to the later generation. I do not 
understand how it works, but the recipient "inherits" the original cost basis, 
while the donor declares the value of the gift at market price. I don't profess 
to understand this fully, and I wouldn't ask for advice on this here. It really 
needs an expert in estate planning. 

⁣David T. ​

On Jan 25, 2023, 4:03 AM, at 4:03 AM, David Carlson 
 wrote:
>The US allows gifts to go untaxed within certain limits.   Capital
>gains
>can get interesting as well.  If you're not certain,  talk to your
>accountant.
>
>On Tue, Jan 24, 2023, 6:48 PM Liz Dodd  wrote:
>
>> On Wed, 25 Jan 2023 10:34:51 +1100
>> flywire  wrote:
>>
>> > I doubt your jurisdiction is that naive. I'd expect you'd pay tax
>on
>> > the $25k capital gain on disposal and your son would have a $30k
>> > basis price.
>>
>>
>> I agree, you gave your son the equivalent of $30K, and you get to pay
>> tax on the capital gain.
>> However if your jurisdiction sees it as your son paying the capital
>> gain, then you gave him $5K in your books.
>>
>> Liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.