Re: [GNC] How to deal with income and invoices (at the end of the year)?

[Michael or Penny Novack via gnucash-user]

On 2/26/2025 9:59 AM, Jan Vlug wrote:
I do work in December. I think the Income should be booked in December 
for taxes.
But, I cannot send the invoice in December yet (because of specific 
procedures with the customer).


1. When I set the post date of the Invoice after 31 December (when I 
really sent the invoice) the date of the Income and Accounts 
Receivable transactions will be booked in the new month (January). But 
I want the income to be in the actual month of the work (December).


2. When I set the post date of the invoice on 31 December (which does 
not corresponds with the real date when I sent the invoice), the 
Income and Accounts Receivable transactions will be booked in the 
month when the work was done (December), which from a tax perspective 
seems more correct to me.


I tend to go for option 2. But the invoice date in GnuCash is not 
correct in that approach.


How would you recommend to handle this situation? 


Not a gnucash question (not really). Why do you think (for tax purposes) 
what year you DO the work has any relevance? Is that what the tax rules 
of your jurisdiction specify? Please note I am NOT "qualified" to give 
accounting or tax advice, but IMHO whether using accrual or cash basis, 
when you do the work, make the widget, contract for a future sale of the 
widget, etc. might not be relevant.


Michael D Novack



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

[GNC] How to deal with income and invoices (at the end of the year)?

[Jan Vlug]

I do work in December. I think the Income should be booked in December 
for taxes.
But, I cannot send the invoice in December yet (because of specific 
procedures with the customer).


1. When I set the post date of the Invoice after 31 December (when I 
really sent the invoice) the date of the Income and Accounts Receivable 
transactions will be booked in the new month (January). But I want the 
income to be in the actual month of the work (December).


2. When I set the post date of the invoice on 31 December (which does 
not corresponds with the real date when I sent the invoice), the Income 
and Accounts Receivable transactions will be booked in the month when 
the work was done (December), which from a tax perspective seems more 
correct to me.


I tend to go for option 2. But the invoice date in GnuCash is not 
correct in that approach.


How would you recommend to handle this situation?

___
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] deleting empty items in a split

[sunfish62--- via gnucash-user]

Why would the version of GnuCash have ANY bearing on a KNOWN GNUCASH ODDITY 
since at least 2005?

GnuCash supplies missing amounts and balances them to Imbalance if you commit 
the record, which GnuCash interprets as having occurred when a user presses 
Enter. 

This has been tripping users up FOR 20 YEARS. 

⁣David T.​

On Feb 26, 2025, 1:40 PM, at 1:40 PM, Brad Morrison  
wrote:
>Hi John/GNUCash users, 
>
>Lots of good tips have been shared already, but maybe my contribution
>will be to go over the basics (if you have not already solved the issue
>you noticed): 
>
>What operating system are you using? 
>
>What version of GnuCash are you using?
>https://gnucash.org/download.phtml - 5.10 is the current version 
>
>---
>Thanks, 
>
>Brad - https://www.facebook.com/brad.morrison.12327/ &
>https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
>https://norcal.social/@BradMorrison 
>
>On 2025-02-25 17:35, David Carlson wrote:
>
>> If you take a moment while editing a multi-line transaction to be
>sure
>> there is no residual balance at the bottom with no account assigned
>before
>> hitting Enter, all is good.
>> 
>> A trick I found recently is to highlight the unassigned value at the
>> bottom, then (Ctrl)Copy, move the curser to the line where the
>correction
>> should go, then (Ctrl)Paste.  The unassigned value will disappear. 
>You may
>> need to include a plus or minus sign if there is already a value
>present.
>> Note that if there are values on both sides, GnuCash reduces them to
>a
>> single positive value.  Easier than using a minus sign!
>> 
>> On Tue, Feb 25, 2025 at 4:30 PM William Prescott
>
>> wrote:
>> 
>> It happens to me once in a while as well. However, it is easy to
>delete
>> the line. If your cursor is in the imbalance line, clicking on the
>delete
>> button will delete the line. If your cursor is on the first line of
>an
>> entry, the delete button deletes the whole transaction.
>> 
>> Best wishes,
>> Will
>> 
>> On 25 Feb 2025, at 15:41, Gyle McCollam  wrote:
>> 
>> When you get down to the final amount, you can also change the
>imbalance
>> account to the proper account for the remaining amount
>> 
>> Thank You,
>> 
>> Gyle McCollam
>> 
>> Gyle McCollam
>> 
>> gmccol...@live.com   email
>> 
>> 
>> From: gnucash-user
> on
>> behalf of R Losey 
>> Sent: Tuesday, February 25, 2025 4:13 PM
>> To: n...@neoscenes.net 
>> Cc: gnucash-user@gnucash.org 
>> Subject: Re: [GNC] deleting empty items in a split
>> 
>> Hello.
>> 
>> I have had this problem as well -- usually when I am entering split
>data
>> and forget to replace the Imbalance or Orphan line with the correct
>> account. You can right-click over any unwanted account and select
>"Delete
>> Split" and it removes only that entry; the option "Remove Other
>Splits"
>> deletes all of the splits.
>> 
>> On Tue, Feb 25, 2025 at 2:22 PM John Hopkins 
>wrote:
>> 
>> halló folk s--
>> 
>> I am having some issues when I am populating a split entry, a line
>item
>> appears
>> as "Imbalance-USD". Once I finish assigning the rest of the various
>> values/line
>> items in the split, that line item stays even with a zero value.
>These
>> accumulate in the account "Imbalance-USD". Same with "Orphan-USD"
>entries
>> (as
>> part of a split).
>> 
>> It's quite useless, and just makes everything more complicated. I've
>read
>> quite
>> a bit online and cannot find a fix for deleting those line items.
>It's
>> easy to
>> delete the whole split, but ...
>> 
>> And advice would be welcom!
>> 
>> Takk!
>> 
>> Jon
>> --
>> +++
>> Dr. John Hopkins, BSc, MFA, PhD
>> subscribe to the neoscenes blog::
>> https://neoscenes.net/blog/87903-subscribe-to-neoscenes
>> +++
>> ___
>> 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.
>> 
>> --
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
>> _

Re: [GNC] How to deal with income and invoices (at the end of the year)?

[Murugan Mariappan]

Your Option 2 is the clean way of doing it.  Why does your invoice date matter 
to you as your AR is correctly reflecting.





Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Jan 
Vlug 
Sent: 26 February 2025 11:59
To: GnuCash User eMail List 
Subject: [GNC] How to deal with income and invoices (at the end of the year)?

I do work in December. I think the Income should be booked in December
for taxes.
But, I cannot send the invoice in December yet (because of specific
procedures with the customer).

1. When I set the post date of the Invoice after 31 December (when I
really sent the invoice) the date of the Income and Accounts Receivable
transactions will be booked in the new month (January). But I want the
income to be in the actual month of the work (December).

2. When I set the post date of the invoice on 31 December (which does
not corresponds with the real date when I sent the invoice), the Income
and Accounts Receivable transactions will be booked in the month when
the work was done (December), which from a tax perspective seems more
correct to me.

I tend to go for option 2. But the invoice date in GnuCash is not
correct in that approach.

How would you recommend to handle this situation?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C0d3ca16e67d64cf866e408dd56769637%7C84df9e7fe9f640afb435%7C1%7C0%7C638761789543991462%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=8MmK3vXaVBTk9nsGoUsHM0MKFULt5miAKo%2FdXUVATME%3D&reserved=0
-
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] OFX DirectConnect seems disconnected

[Frank Revi via gnucash-user]

Hi
Trying to set up GnuCash 5.10+(2024-12-14) on Win11.
When I go to OFX DirectConnect Setup Wizard, no banks ever appear, no matter 
what I type into the Bank Name field (and then click Select and type into the 
Select a Bank dialog), like there's no connection to anything upstream. So I 
can't even create an online banking user.
How can I get GnuCash/AqBanking to connect to my bank please?
 
___
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] Error message

[Marilyn Wagner]

I've recently started using this program - entered all 2024 entries - just
got this message - how can I fix this?

[image: image.png]

*Thanks, Marilyn*

Stamping Creations With Marilyn

Marilyn Wagner, Independent Canadian Stampin' Up! Demonstrator

Call or text - 780-916-7587

See all my links here - https://bit.ly/linkbioSCWM
___
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] Hidden Account Transactions Export

[Felix Yu]

Hello,

I regularly use the Export Transactions to CSV function in GNUCash for 
financial analyses on other platforms. My standard work flow is as follows:

  1.
Choose Export Settings (Options: Use Quotes - unchecked, Simplified Layout - 
unchecked; Comma separator)
  2.
Account Selection - Select All accounts; Select All dates

However, I am noticing some strange behaviours around hidden accounts, 
specifically:

  *
When exporting transactions, hidden accounts are not selectable, but their 
transactions appear if split with non-hidden acounnts. However, transactions 
entirely within hidden accounts are not exported at all
  *
I understand that un-hiding accounts resolves the issue, however, that may not 
be a feasible solution and goes against the purpose of hiding accounts 
(presumably for clutter management)
  *
Is there a way to work around the issue? Is it possible to add a "Select All, 
Visible and Hidden" button on the Account Selection page (given the Select All 
accounts button is more like, Select All Visible accounts as of now)

Thank you!
___
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] Error message

[Gyle McCollam]

This usually occurs when the program is not shutdown properly.  If you know 
that no one else is using the program, just select "Open Anway".  Exit the 
program before shutting down your computer or this may have occurred if the 
computer rebooted when the program was open.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Marilyn Wagner 
Sent: Tuesday, February 25, 2025 7:07 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Error message

I've recently started using this program - entered all 2024 entries - just
got this message - how can I fix this?

[image: image.png]

*Thanks, Marilyn*

Stamping Creations With Marilyn

Marilyn Wagner, Independent Canadian Stampin' Up! Demonstrator

Call or text - 780-916-7587

See all my links here - https://bit.ly/linkbioSCWM
___
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] deleting empty items in a split

[Brad Morrison]

Hi John/GNUCash users, 

Lots of good tips have been shared already, but maybe my contribution
will be to go over the basics (if you have not already solved the issue
you noticed): 

What operating system are you using? 

What version of GnuCash are you using?
https://gnucash.org/download.phtml - 5.10 is the current version 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
https://norcal.social/@BradMorrison 

On 2025-02-25 17:35, David Carlson wrote:

> If you take a moment while editing a multi-line transaction to be sure
> there is no residual balance at the bottom with no account assigned before
> hitting Enter, all is good.
> 
> A trick I found recently is to highlight the unassigned value at the
> bottom, then (Ctrl)Copy, move the curser to the line where the correction
> should go, then (Ctrl)Paste.  The unassigned value will disappear.  You may
> need to include a plus or minus sign if there is already a value present.
> Note that if there are values on both sides, GnuCash reduces them to a
> single positive value.  Easier than using a minus sign!
> 
> On Tue, Feb 25, 2025 at 4:30 PM William Prescott 
> wrote:
> 
> It happens to me once in a while as well. However, it is easy to delete
> the line. If your cursor is in the imbalance line, clicking on the delete
> button will delete the line. If your cursor is on the first line of an
> entry, the delete button deletes the whole transaction.
> 
> Best wishes,
> Will
> 
> On 25 Feb 2025, at 15:41, Gyle McCollam  wrote:
> 
> When you get down to the final amount, you can also change the imbalance
> account to the proper account for the remaining amount
> 
> Thank You,
> 
> Gyle McCollam
> 
> Gyle McCollam
> 
> gmccol...@live.com   email
> 
> 
> From: gnucash-user  on
> behalf of R Losey 
> Sent: Tuesday, February 25, 2025 4:13 PM
> To: n...@neoscenes.net 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] deleting empty items in a split
> 
> Hello.
> 
> I have had this problem as well -- usually when I am entering split data
> and forget to replace the Imbalance or Orphan line with the correct
> account. You can right-click over any unwanted account and select "Delete
> Split" and it removes only that entry; the option "Remove Other Splits"
> deletes all of the splits.
> 
> On Tue, Feb 25, 2025 at 2:22 PM John Hopkins  wrote:
> 
> halló folk s--
> 
> I am having some issues when I am populating a split entry, a line item
> appears
> as "Imbalance-USD". Once I finish assigning the rest of the various
> values/line
> items in the split, that line item stays even with a zero value. These
> accumulate in the account "Imbalance-USD". Same with "Orphan-USD" entries
> (as
> part of a split).
> 
> It's quite useless, and just makes everything more complicated. I've read
> quite
> a bit online and cannot find a fix for deleting those line items. It's
> easy to
> delete the whole split, but ...
> 
> And advice would be welcom!
> 
> Takk!
> 
> Jon
> --
> +++
> Dr. John Hopkins, BSc, MFA, PhD
> subscribe to the neoscenes blog::
> https://neoscenes.net/blog/87903-subscribe-to-neoscenes
> +++
> ___
> 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.
> 
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo

Re: [GNC] Trading Accounts Balance

[Bo Buckley]

Thank you for your response John, but I have to say I've completely lost
sight of the original question, so allow me to summarize from the beginning:

I want to understand the meaning and underlying usage of the "Total" amount
listed next to "Trading" in the "Accounts" tab. The docs appear to explain
it as a trading loss if positive or a gain if negative.

You further explained:

> The Accounts page Total column *does use the most recent price database
> entry to value each commodity* that isn’t the book currency and that will
> make the trading accounts reflect an unrealized gain or loss.
>
> The Totals column on the Accounts page presents the ending balance for
> each account (even if that’s in the future), *converted to the book
> currency using the most recent exchange rate* available from the
> account’s commodity to the book currency.
>
> *The price database has nothing to do with this. Nothing!* It’s entirely
> about differences in book-currency value between conversions to and from
> other commodities. You must use the Average Cost price source—that
> calculates the effective price of the non-book-currency commodities based
> on the transactions into and out of each of those currencies—when running
> the trial balance report


I'm not sure how to resolve the last statement against the first two. They
appear to be conflicting information to me. What am I misunderstanding
here? Are you referring to something other than the Trading Accounts page
Total when you wrote "nothing to do with __this__"?

You must book trading gains to keep your book in balance.
>

When you say "keep your book in balance" you mean the debit and credits
match in the Trial Balance report, yes?

Since both the creation of the JPY opening balance and the transfer from
> USD were on the same day, for accounting purposes the exchange rate is the
> same: 67/1. Your purchase the following day with ¥1500 at a rate of
> 70/1 reflects a difference of 3/1, multiplied by ¥1500 yields a
> loss of $0.45. That third transaction will be

Checking_jpy.   ¥1500

Expenses:Groceries   $10.50

Income:Trading Gains.  $0.45

Trading:JPY.   ¥1500

Trading:USD   $10.95


Given the attached trading_test.gnucash book, I am unable to manually
change the values in the Trading:USD split. If I enter the 70/1
exchange rate, it will automatically be reentered as $10.50. In other
words, with "Use Trading Accounts" on, I cannot make the above mentioned
transaction. Is the fundamental point that I'm misunderstanding that one
cannot account for trading gains/losses if "Use Trading Accounts" is turned
on??

Also I'm still lost as to why you refer to the $0.45 as a loss rather than
a gain. The JPY was "sold" for a higher value than when it was "bought".
No?

As always, thank you for your responses.

On Fri, Feb 21, 2025 at 2:45 AM John Ralls  wrote:

> Bo,
>
> It doesn’t matter whether or not the gain is taxable. You must book
> trading gains to keep your book in balance. Please study
> https://www.gnucash.org/docs/v5/C/gnucash-guide/chapter_capgain.html for
> the different ways to accomplish that in GnuCash.
>
> One more time: The price database has nothing to do with this. Nothing!
> It’s entirely about differences in book-currency value between conversions
> to and from other commodities. You must use the Average Cost price
> source—that calculates the effective price of the non-book-currency
> commodities based on the transactions into and out of each of those
> currencies—when running the trial balance report. You can run a regular
> balance sheet, or any other, report with that price source if you find it
> helpful. Just be careful with period reports like the Income Statement
> because the average cost report calculates based on all transactions, not
> just those for the past year. You should also be aware that the average
> cost calculation does not work with three-or-more commodity transactions,
> see https://bugs.gnucash.org/show_bug.cgi?id=797796.
>
> Having an opening balance in JPY also will create trouble with calculating
> the trading gain unless the Equity account is in USD because there’s no USD
> value and no trading account splits for it.
>
> Since both the creation of the JPY opening balance and the transfer from
> USD were on the same day, for accounting purposes the exchange rate is the
> same: 67/1. Your purchase the following day with ¥1500 at a rate of
> 70/1 reflects a difference of 3/1, multiplied by ¥1500 yields a
> loss of $0.45. That third transaction will be
>
> Checking_jpy.   ¥1500
> Expenses:Groceries   $10.50
> Income:Trading Gains.  $0.45
> Trading:JPY.   ¥1500
> Trading:USD   $10.95
>
> Regards.
> John Ralls
>
>
> On Feb 20, 2025, at 00:22, Bo Buckley  wrote:
>
> Dear John,
>
> Thank you for the detailed example. Yes, yo

Re: [GNC] OFX DirectConnect seems disconnected

[John Ralls]

> On Feb 24, 2025, at 18:04, Frank Revi via gnucash-user 
>  wrote:
> 
> 
> Hi
> Trying to set up GnuCash 5.10+(2024-12-14) on Win11.
> When I go to OFX DirectConnect Setup Wizard, no banks ever appear, no matter 
> what I type into the Bank Name field (and then click Select and type into the 
> Select a Bank dialog), like there's no connection to anything upstream. So I 
> can't even create an online banking user.
> How can I get GnuCash/AqBanking to connect to my bank please?

Yes, the service that provided that information, ofxhome.com 
, shut down a couple of years ago. It’s archived on the 
Wayback Machine so you may be able to look up the parameters there and enter 
them manually, but you probably want to check with your bank to make sure they 
still support OFX Direct Connect with plain-text authentication. Very few do 
any more.

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

Re: [GNC] Trading Accounts Balance

[John Ralls]

Bo,

We got started in this discussion because you had trouble understanding that 
price isn’t necessarily concrete across splits because of forced rounding of 
commodities to their minimum fractions.

Clarifications first:

You’re right, buying at $0.67/¥100 and spending (selling) at $0.70/¥100 is a 
gain, not a loss.

Your books are out of balance when Assets ≠ Liabilities + Equity. The easiest 
way to see when that’s the case is with the Trial Balance Report. The trading 
accounts balances by themselves reflect an imbalance when all of the 
non-book-currency positions have been closed out. Otherwise gain/loss errors 
are reflected in differences between the trading account balances and the 
corresponding asset account balances. The Peter Selinger paper linked in the 
documentation explains it thoroughly. It might take a bit of study to fully 
understand it.

You’re right that the amounts in the Total column on the accounts page are 
converted to the book currency using the most recent price from the price 
database. That’s a feature for people who want to see something resembling what 
their brokerage account tells them. It’s rather less helpful when trying to use 
trading accounts to assess whether you’ve booked all of your realized gains and 
losses. That’s also the case with the single price per day in the price 
database. Consider the simple case where you transfer $100 to your JPY Checking 
at ¥14925 (about $0.67/¥100), then use Finanace::Quote to update the exchange 
rate and it retrieves $0.70/¥100 and overwrites the entry for that day in the 
price database. The Total column on the accounts page will show that’s worth 
$104.48, but there’s no change in the book value of the ¥14925: That’s still 
$100. The $4.46 is an unrealized gain.

A few days later you enter a purchase for ¥1500 and fetch the exchange rate 
from F::Q. It’s about $0.65/¥100 so you book it as $9.75. You neglect to record 
the trading loss and you again run F::Q later in the day and get some different 
rate, say $0.72/¥100, overwriting the earlier one from that day when you 
recorded the transaction.

You get to the end of the month and run a trial balance, and it doesn’t because 
you missed the trading loss in that ¥1500 transaction. The book cost of the 
¥1500 was $10.05, the booked expense was $9.75 That difference is an imbalance 
in your book: A $10.05 reduction in Assets but only a $9.75 reduction in Equity 
(income and expense are equity accounts). Using the prices in the price 
database would lead you do a different number and wouldn’t balance your book.

In the case of normal investment transactions where you’re directly converting 
book currency money into shares and back—or even Forex trading where you’re 
doing the same with other countries' or crypto currencies in place of 
shares—it’s concrete as I explained it. It gets a bit more complicated in cases 
like yours where you’re converting USD into JPY and then converting JPY into 
living expenses because you have a fair amount of wiggle room on the exchange 
rate that you  use to book the expense in USD. You could use the average cost 
(I don’t know of a way to get GnuCash to tell you what it is, sorry) and have 
no trading gains or losses. I have no idea if that would be legal, but as a 
private person it’s unlikely that either the Japanese or American tax 
authorities would put any effort into checking. 

Regards,
John Ralls
> On Feb 26, 2025, at 01:58, Bo Buckley  wrote:
> 
> Thank you for your response John, but I have to say I've completely lost 
> sight of the original question, so allow me to summarize from the beginning:
> 
> I want to understand the meaning and underlying usage of the "Total" amount 
> listed next to "Trading" in the "Accounts" tab. The docs appear to explain it 
> as a trading loss if positive or a gain if negative. 
> 
> You further explained:
>> The Accounts page Total column does use the most recent price database entry 
>> to value each commodity that isn’t the book currency and that will make the 
>> trading accounts reflect an unrealized gain or loss. 
>> 
>> The Totals column on the Accounts page presents the ending balance for each 
>> account (even if that’s in the future), converted to the book currency using 
>> the most recent exchange rate available from the account’s commodity to the 
>> book currency.
>> 
>> The price database has nothing to do with this. Nothing! It’s entirely about 
>> differences in book-currency value between conversions to and from other 
>> commodities. You must use the Average Cost price source—that calculates the 
>> effective price of the non-book-currency commodities based on the 
>> transactions into and out of each of those currencies—when running the trial 
>> balance report
> 
> I'm not sure how to resolve the last statement against the first two. They 
> appear to be conflicting information to me. What am I misunderstanding here? 
> Are you referring to something other than the Trading Accounts

[GNC] Error when saving

[Dennis Powless]

Sometimes when I save the file, I get an error message:
You do not have permission to access J:\Dropbox\gnucash\xyz

If I click close and then re-click close, it saves.


Dennis
___
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] Hidden Account Transactions Export

[sunfish62--- via gnucash-user]

Felix,

I would expect the behavior that you describe. Transactions have at least two 
entries in double entry accounting. If you've selected an account with a 
transaction that links to a hidden account, not showing that transaction would 
leave holes in the report. 

One thing: why it is you have active transactions that interact with hidden 
accounts? The use cases I know for hiding accounts only involve accounts that 
are no longer active-- for example, a closed account. Once hidden, such an 
account is no longer intended for active use. Transactions between visible and 
hidden accounts would seem to contradict this. 

Alternatively, I ask why it is you "regularly" export these transactions? 
Again, once an account is no longer in use, I can't see why you need to 
regularly access the data in those accounts. 

Third, why is un-hiding accounts not feasible? It may be inconvenient, but it 
is not "unfeasible." I will note that you can add the hidden attribute as a 
checkbox to the Chart of Accounts page, which you can use to quickly change 
this setting for any account. Just be sure to change the View setting to show 
hidden accounts. 

⁣David T. ​

On Feb 26, 2025, 11:42 PM, at 11:42 PM, Felix Yu  wrote:
>Hello,
>
>I regularly use the Export Transactions to CSV function in GNUCash for
>financial analyses on other platforms. My standard work flow is as
>follows:
>
>  1.
>Choose Export Settings (Options: Use Quotes - unchecked, Simplified
>Layout - unchecked; Comma separator)
>  2.
>Account Selection - Select All accounts; Select All dates
>
>However, I am noticing some strange behaviours around hidden accounts,
>specifically:
>
>  *
>When exporting transactions, hidden accounts are not selectable, but
>their transactions appear if split with non-hidden acounnts. However,
>transactions entirely within hidden accounts are not exported at all
>  *
>I understand that un-hiding accounts resolves the issue, however, that
>may not be a feasible solution and goes against the purpose of hiding
>accounts (presumably for clutter management)
>  *
>Is there a way to work around the issue? Is it possible to add a
>"Select All, Visible and Hidden" button on the Account Selection page
>(given the Select All accounts button is more like, Select All Visible
>accounts as of now)
>
>Thank you!
>___
>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] Error when saving

[Geoff]

Hi Dennis

That will most likely be due to a transient network connectivity issue 
between your computer and DropBox's infrastructure.


Retrying as you did is the correct action.

Regards

Geoff
=

On 27/02/2025 3:16 pm, Dennis Powless wrote:

Sometimes when I save the file, I get an error message:
You do not have permission to access J:\Dropbox\gnucash\xyz

If I click close and then re-click close, it saves.


Dennis
___
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.