[GNC] Scheduled Transactions Window Sorting

2023-01-13 Thread David T. via gnucash-user
Hello, 

Gnucash 4.13 Windows 10.

As I reacquaint myself with scheduled transactions, I find myself opening that 
window regularly. Each time I open the window, transactions are listed in last 
created order. This despite my having sorted the list alphabetically the 
previous time. 

My question is this: is there some material reason why the Scheduled 
Transactions Window sort order isn't sticky (like most other windows in 
GnuCash), or is this simply an oversight?

⁣David T. ​
___
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] Scheduled Transactions Question

2023-01-13 Thread Adrien Monteleone

I seem to recall having done that once or twice too!

Regards,
Adrien

On 1/14/23 12:37 AM, David T. via gnucash-user wrote:

Thanks. I did a little testing, trying both your suggestion and Stan's. Both seemed to 
have the same result: I was only prompted once. I suspect that "formula-izing" 
the transaction doesn't materially change anything here.

In retrospect, I suspect user error in the first place. I now believe that I 
had created the test transaction without paying close enough attention to the 
start date-- and that GnuCash was creating multiple instances of the 
transaction (and therefore promoting for each).


___
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] Scheduled Transactions Question

2023-01-13 Thread David T. via gnucash-user
Thanks. I did a little testing, trying both your suggestion and Stan's. Both 
seemed to have the same result: I was only prompted once. I suspect that 
"formula-izing" the transaction doesn't materially change anything here. 

In retrospect, I suspect user error in the first place. I now believe that I 
had created the test transaction without paying close enough attention to the 
start date-- and that GnuCash was creating multiple instances of the 
transaction (and therefore promoting for each).

⁣David T. ​

On Jan 14, 2023, 2:08 AM, at 2:08 AM, Adrien Monteleone 
 wrote:
>I had the same problem and I think I solved it by making all of the 
>variables part of a formula, so your transaction would look like:
>
>DB Checking TOTALAMT*1
>CR Asset TOTALAMT*1
>CR Income A TOTALAMT*1
>DB Income B TOTALAMT*1
>
>Regards,
>Adrien
>
>On 1/13/23 10:48 AM, David T. via gnucash-user wrote:
>> Hi,
>> 
>> Gnucash 4.13 Windows 10. Long time user.
>> 
>> I am trying out using a variable in a scheduled transaction for the 
>> first time, and it's not behaving the way I expect. I am creating a 
>> multi-entry transaction that transfers a single amount between two
>pairs 
>> of accounts. in other words:
>> 
>> DB Checking TOTALAMT
>> CR Asset TOTALAMT
>> CR Income A TOTALAMT
>> DB Income B TOTALAMT
>> 
>> [This is testing out how to create a transaction to track an IRA 
>> distribution]
>> 
>> I expect GnuCash to prompt me for the TOTALAMT figure once when the 
>> transaction is created, but GnuCash prompts me for *each* TOTALAMT
>entry 
>> in the transaction (i.e., four times). Is there a way to have just
>one 
>> request that gets assigned four times?
>
>___
>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] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread David T. via gnucash-user
Michael, 

Thanks again for your perspective. I admit to being a little confused by your 
comments here. 

My breakdown was based on an earlier post that emphasized the need to isolate 
the initial deposits into a "deferred income" account and add the extra entries 
at distribution time. I interpreted that to mean a separate income account; I 
don't know what a "standing account" is or where it would be placed in the 
hierarchy. Equity?

As for counting as income, most paychecks I've seen list the employee's gross 
income at the top, with contributions to tax-deferred accounts listed as 
deductions from the gross amount. This is why I placed deferred income under 
income; the income that my employer lists at year end includes this deferred 
income. I can, I imagine, chalk this up to another case of "their books, my 
books" (as in, "On their books, it's income; on my books it's not."), but I'd 
be happy to understand a little better. 

The case of an IRA can be even more confusing, in that a person can make IRA 
contributions entirely separately from income transactions and have those 
contributions affect income at tax time.

⁣David T. ​

On Jan 14, 2023, 1:10 AM, at 1:10 AM, Michael or Penny Novack 
 wrote:
>On 1/13/2023 11:48 AM, R Losey wrote:
>> Thanks. The only minor drawback is that I seem to be entering the
>data 
>> twice under "Income" just to keep track of IRA distributions on their
>
>> own. But hey, it's one way to make it work.
>>
>> And, as has been pointed out, since this is not really "income", it 
>> makes sense that the transaction has no net income. I think I'll
>adopt 
>> this method for 2023.
>>
>> In hindsight, since the Fiduciary Trust that keeps the IRA has to 
>> report to me on distributions, I haven't felt a need to have an 
>> account for this and to double-check them.
>>
>>
>>
>> On Thu, Jan 12, 2023 at 10:56 PM David T. 
>wrote:
>>
>> Two separate entries. In my mind, this would best be put in one
>> transaction, to make the association obvious.
>>
>> CR - Assets: IRA $1000
>> DB - Assets: Checking $1000
>> DB - Income: Deferred Income $1000
>> CR - Income: IRA Distribution $1000 *
>>
><<< it most certainly COULD be in one entry. A transaction can have
>more 
>than two accounts. It is only when entering via the shortcut "enter 
>directly into the ledger" that gnucash allows you to do that is limited
>
>to two accounts. When entering a "split" in "journal mode" you can have
>
>more than two. In the old days ALL transactions were entered first in 
>the journal and then posted to the ledger. But even in pen and ink days
>
>we had SOME shortcut possibilities, like "cashbook accounting" << where
>
>a small subset of the ledger allowed direct entry skipping the
>journal.>>
>
>BUT -- I would not have "deferred income" under income, because it is 
>more like a standing account. The money that you put into the 401k/IRA 
>did not get counted in your income in those years. The money
>contributed 
>by your employer (401k) did not get counted as income back then, nor
>the 
>annual increases in fund value as you perhaps marked to market at year 
>end (the investment income of the fund).
>
>When you take distributions later is when it becomes income << you are 
>undeferring that amount >>
>
>This is accounting, not gnucash
>
>Michael D Novack
>
>
>>
>> * Income: IRA Distribution is used to document the distribution
>> for tax purposes.
>>
>> David T.
>> On Jan 13, 2023, at 7:21 AM, R Losey  wrote:
>>
>> Thanks for all of the information... however, getting back to
>the original
>> question, I'm not sure how to record IRA taxable
>distributions. I thought I
>> was doing it, but I am apparently not.
>>
>> Let me write through a couple of cases.  In the first one,
>I'm selling
>> $1000 worth (10 shares) of security A and having it go
>directly to my
>> checking account with no income tax withholding. (some of
>these may be
>> USA-centric terms; I apologize for that).
>>
___
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] exporting from gnucash to Excel

2023-01-13 Thread Peter West
How can this be enforced except by obliging you to use only software they 
(inland revenue?) endorse?

—
Peter West
p...@pbw.id.au
“Which is easier, to say to the paralytic, ‘Your sins are forgiven,’ or to say, 
‘Rise, take up your bed and walk’?”

> On 14 Jan 2023, at 6:40 am, Maf. King  wrote:
> 
> On Friday, 13 January 2023 04:45:20 GMT David T. via gnucash-user wrote:
>> Indeed.
>> 
>> I don't have to comply with this either, but it seems to me that "pressing a
>> button" to export to Excel provides exactly the same automated reliability
>> as CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both
>> cases will have the same reliability.
>> 
> 
> You know that,  I know that.  The gubberment want "more automation" than 
> that.   
> 
> Because all the VAT fraud in the world happens when you make an honest error 
> copying 3 numbers between programs, not systematically at the point of data 
> entry...
> 
> It's digital, and only directly linked.  must be foolproof, so say the powers 
> that be
> 
> Hmmm.  >:-)
> Maf.
> 
> 
> 
> 
> 
> 
> ___
> 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] GC 4.9

2023-01-13 Thread Les

Thanks, David.  I'll bid my time.

On 1/13/23 17:39, David H wrote:

Les,

If you mean "4.900" there already is.  Be careful though as it's a 
beta version and NOT recommended for daily/production use.  So not an 
upgrade yet.  I'm having issues with it on Ubuntu 22.10 flatpak and 
Win 10 so wouldn't recommend it just yet :-)


Cheers David H.


On Sat, 14 Jan 2023 at 09:23, Les  wrote:

When will there be a Flatpak version for GC 4.9?

Thanks,

Les
___
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] GnuCash 4.900 Released

2023-01-13 Thread David H
Hi again John and Devs,

I've just updated my Ubuntu 22.10 flatpak to the Gnucash 4.900 beta and am
having the same issues as on Win 10.  Attached are trace files from each OS
in case it helps.

Regards David H


On Thu, 12 Jan 2023 at 08:25, David H  wrote:

> Hi John and devs,
>
> Thanks for the update.  I had a number of problems as per the following:-
>
> System
> ---
>
> Lenovo laptop, Intel i5, 8 Gb ram, Gnucash 4.13 / Finance Quote 1.54 / Win
> 10 Pro, Version 22H2, OS Build 19044.2486, Win32 strawberry-perl 5.32.1.1
> #1 Sun Jan 24 12:17:47 2021 i386
>
> Process
> 
>
> Installed 4.900 which auto uninstalled 4.13.
> Started Gnucash 4.900 which displayed the "Tip of The Day" and then the
> "Welcome to Gnucash" dialogs.
> Unfortunately Gnucash 4.900 didn't seem to find my xml data file and the
> Most Recent file list just displays "RecentFile0Action" (Function name?)
> instead of the usual 2-3 file names.
> Manually opened the last file used which is just a copy of my usual
> Gnucash file, it opened fine and re-displayed all the tabs that were
> previously open.
> Got the message about the Budget amounts being fixed during the open
> process.
> It doesn't seem to be finding my saved report options - the report names
> are included in the save report config list but no options and the Accounts
> Selected has reverted to all accounts.
> Get quotes is now not working - the button is simply greyed out.
> Like Glenn I also can't turn off the Tip of the Day or the Display Welcome
> Dialog Again? and on exiting and restarting Gnucash I repeatedly get
> prompted to Create a new set of accounts / Import my QIF files / Open the
> new user tutorial.
>
> Also yesterday I happened to update and save Report Options for a saved
> report configuration  and it seemed Gnucash crashed, repeating the process
> today did NOT result in a crash.
>
> Hope this helps and once again thanks to you and the other devs for all
> your hard work on Gnucash.
>
> Regards David H.
>
>
>
>
>
>
> On Tue, 10 Jan 2023 at 15:03, John Ralls  wrote:
>
>> The GnuCash development team announces GnuCash 4.900, the first unstable
>> release leading to GnuCash 5.0.
>>
>> This is an unstable release for testing purposes. Do not use it with
>> production data! Make a copy of your book to test this release.
>>
>> New Features
>>
>> A new Stock Transaction Assistant to guide you through entering most
>> investment transactions for stocks, bonds, and mutual funds. You can access
>> it from Actions>Stock Assistant when you have the Accounts page ora Stock
>> or Fund account register open.
>> A new Investment Lots report showing a graph of capital gains and
>> losses in a period by investment lot. Note that if you don't use the View
>> Lots dialog to manage capital gains and losses this report won't have
>> anything to show you. Use Reports>Assets & Liabilities>Investment Lots to
>> see the report.
>> A new tab on the New/Edit Account dialog called More Properties
>> includes entries to set a high and low limit on an account. That's coupled
>> to a new column that's available on the Accounts Page, Balance Limit. If
>> you set a high or low limit and the account balance falls above or below
>> the respective limit an indicator will be shown in the Balance Limit column.
>> The description field quickfill in the register now displays a
>> drop-down list of possible completions instead of just one inline
>> completion.
>> File import menu items for the MT940, MT942, and DTAUS formats is
>> replaced with a single Import from AQBanking that supports importing any
>> file format supported by AQBanking, including the frequently requested CAMT.
>>
>> Between 4.13 and 4.900, the following bugfixes were accomplished:
>> The following fixes will also appear in GnuCash 4.14:
>>
>> Bug 798588 - sx scrubbing was using incorrect free function
>> Bug 798625 - "Last up through report date" changed in 4.12
>> Bug 798679 - Unicode normalization should be used for comparison but
>> not stored.
>> Bug 798702 - Crash in gnc_plugin_page_focus_idle_destroy() closing a
>> report before it completes.
>> Bug 798705 - New: UI string mismatch: OK vs. Next
>> Bug 798717 - Reports > Business > Fancy Invoice duplicates company
>> details
>>
>> The following additional bug fixes are in unstable only:
>>
>> Bug 403979 - Balance column shows only low order digits when too
>> narrow
>>
>> If the column is too narrow to display the whole number it will
>> display the leading digits with an ellipsis (…).
>> Bug 769256 - Change New Account Dialog
>>
>> Rearrange the New and Edit Account dialog to move the parent selector
>> under the description field followed by the account type as a combo (i.e.
>> drop down) list.
>>
>> The following fixes and improvements were not associated with bug reports:
>>
>> Unicode normalization for string matches is changed from NFKC to NFC.
>> This means that font and positional 

Re: [GNC] GC 4.9

2023-01-13 Thread David H
Les,

If you mean "4.900" there already is.  Be careful though as it's a beta
version and NOT recommended for daily/production use.  So not an upgrade
yet.  I'm having issues with it on Ubuntu 22.10 flatpak and Win 10 so
wouldn't recommend it just yet :-)

Cheers David H.


On Sat, 14 Jan 2023 at 09:23, Les  wrote:

> When will there be a Flatpak version for GC 4.9?
>
> Thanks,
>
> Les
> ___
> 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] GnuCash 4.900 Released

2023-01-13 Thread David H
I don't know, one of the devs might have an answer for you :-)

Cheers David H.


On Sat, 14 Jan 2023 at 09:23, Fred Tydeman  wrote:

>
>
> On Fri, Jan 13, 2023 at 3:00 PM David H  wrote:
>
>> Yeah seems to be a typo which will cause the remote-add to fail if you
>> already have the flathub repository installed as follows:-
>>
>> Wiki says - flatpak remote-add --user --if-not-exists *flathub*
>> https://flathub.org/beta-repo/flathub-beta.flatpakrepo
>> Should be - flatpak remote-add --user --if-not-exists *flathub-beta*
>> https://flathub.org/beta-repo/flathub-beta.flatpakrepo
>>
>
> Thanks.  That fix lets me get farther.
> I have done a fresh install of Fedora 37 with Gnome 43.2 on Intel 64-bit
> CPU.
> When I try to install the beta, I get an error saying that beta requires
> runtime org.gnome.Platform/x86_64/43
> Is there some way to force the beta to use the system wide Gnome?
>
>
___
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 4.900 Released

2023-01-13 Thread Fred Tydeman
On Fri, Jan 13, 2023 at 3:00 PM David H  wrote:

> Yeah seems to be a typo which will cause the remote-add to fail if you
> already have the flathub repository installed as follows:-
>
> Wiki says - flatpak remote-add --user --if-not-exists *flathub*
> https://flathub.org/beta-repo/flathub-beta.flatpakrepo
> Should be - flatpak remote-add --user --if-not-exists *flathub-beta*
> https://flathub.org/beta-repo/flathub-beta.flatpakrepo
>

Thanks.  That fix lets me get farther.
I have done a fresh install of Fedora 37 with Gnome 43.2 on Intel 64-bit
CPU.
When I try to install the beta, I get an error saying that beta requires
runtime org.gnome.Platform/x86_64/43
Is there some way to force the beta to use the system wide Gnome?
___
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] reports not working unless exported [solved]

2023-01-13 Thread Jeff

On 1/13/23 4:30 PM, David H wrote:

Jeff,

I seem to recall just doing a "Flatpak Update" fixed an issue with 
blank reports a little while ago - from memory it updated something 
else but I don't remember the details. So give that a shot and see if 
it fixes the issue.


Cheers David H.

On Sat, 14 Jan 2023 at 07:12, Jeff  wrote:

Running:

Version: 4.13
Build ID: Flathub 4.13
Finance::Quote: 1.5301

on:

Ubuntu 22.04.1 LTS

I went to generate some reports for the year 2022 and not one of the
standard reports will work within GNC now.  (Not sure from which
version
from Flathub this started.)  ALL of the reports built into GNC now
have
to be exported to see them and time wise that is a problem right now,
especially if I screw up and include/exclude a wrong account.

I vaguely remember reading a post on how to correct this problem. 
Any
help appreciated.

-- 
--JEffrey Black M.B.A.


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

Thanks David.  It was a Flatpak update problem.  For whatever reason, 
after the last set of updates to Ubuntu, the Flatpak package program did 
not update 4 files (looked like system files and one video driver).  A 
forced update from a superuser terminal fixed it.


--
--JEffrey Black M.B.A.
___
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] GC 4.9

2023-01-13 Thread Les

When will there be a Flatpak version for GC 4.9?

Thanks,

Les
___
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] Scheduled Transactions Question

2023-01-13 Thread Adrien Monteleone
I had the same problem and I think I solved it by making all of the 
variables part of a formula, so your transaction would look like:


DB Checking TOTALAMT*1
CR Asset TOTALAMT*1
CR Income A TOTALAMT*1
DB Income B TOTALAMT*1

Regards,
Adrien

On 1/13/23 10:48 AM, David T. via gnucash-user wrote:

Hi,

Gnucash 4.13 Windows 10. Long time user.

I am trying out using a variable in a scheduled transaction for the 
first time, and it's not behaving the way I expect. I am creating a 
multi-entry transaction that transfers a single amount between two pairs 
of accounts. in other words:


DB Checking TOTALAMT
CR Asset TOTALAMT
CR Income A TOTALAMT
DB Income B TOTALAMT

[This is testing out how to create a transaction to track an IRA 
distribution]


I expect GnuCash to prompt me for the TOTALAMT figure once when the 
transaction is created, but GnuCash prompts me for *each* TOTALAMT entry 
in the transaction (i.e., four times). Is there a way to have just one 
request that gets assigned four times?


___
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 4.900 Released

2023-01-13 Thread David H
Hi Fred,

Yeah seems to be a typo which will cause the remote-add to fail if you
already have the flathub repository installed as follows:-

Wiki says - flatpak remote-add --user --if-not-exists *flathub*
https://flathub.org/beta-repo/flathub-beta.flatpakrepo
Should be - flatpak remote-add --user --if-not-exists *flathub-beta*
https://flathub.org/beta-repo/flathub-beta.flatpakrepo

Cheers David H.


On Fri, 13 Jan 2023 at 15:02, Fred Tydeman  wrote:

> I have installed Fedora 37 with Gnome to a different partition (so I can
> run different versions).
> When I try to follow the instructions in
> https://wiki.gnucash.org/wiki/Flatpak,
> to install the beta, I get:
>
> [tydeman@x1car2 ~]$ flatpak remote-add --user --if-not-exists flathub
> https://flathub.org/beta-repo/flathub-beta.flatpakrepo
> [tydeman@x1car2 ~]$ flatpak install --user flathub-beta
> org.gnucash.GnuCash
> Looking for matches…
> error: No remote refs found for ‘flathub-beta’
> [tydeman@x1car2 ~]$
>
> Since I am doing cut and paste, there should not be any typos.
> So, it seems like the Flatpak writeup on betas has something wrong.
>
> On Mon, Jan 9, 2023 at 9:02 PM John Ralls  wrote:
>
> > The GnuCash development team announces GnuCash 4.900, the first unstable
> > release leading to GnuCash 5.0.
> >
> > This is an unstable release for testing purposes. Do not use it with
> > production data! Make a copy of your book to test this release.
> >
> ___
> 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] reports not working unless exported

2023-01-13 Thread Jeff

On 1/13/23 4:13 PM, Michael or Penny Novack wrote:



I went to generate some reports for the year 2022 and not one of the 
standard reports will work within GNC now.



Explain what you mean by "will not work" Are you having a DATE 
problem? (you don't know how to specify the effective date(s) for a 
report?)



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.


I've tried custom date ranges and using beginning of previous year/end 
of previous year.  All I get is a blank tab or window, unless I export 
the report to say an HTML file, which will display properly in Firefox.


--
--JEffrey Black M.B.A.

___
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] Scheduled Transactions Question

2023-01-13 Thread Stan Brown (using GC 2.6.19)
That may have been me. I'm running 2.6.19, and I could swear that I
tried a scheduled transaction over a year ago, and I got prompted
multiple times.

When I posted about that again a few days ago, I tried again and found
that I had misinterpreted what I was seeing on screen. In fact, GC was
simply putting up the one and only prompt again because after entering
the amount I clicked OK instead of using Tab to commit the amount.

David T,
After you enter the value of your variable, don't click OK but use Tab
or Enter to commit the amount, and you should get only the one prompt.
You may have to experiment a bit -- it may be that whether you use Tab
or Enter depends on which version of GC you're using.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2023-01-13 14:33, David Carlson wrote:
> I do recall this same issue came up in another thread and I thought there
> was already a solution mentioned,  but it is really difficult to search for
> it on a phone .
> 
> Perhaps someone else remembers where to find it?

>>> On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user <
>>> gnucash-user@gnucash.org> wrote:
>>>
 Gnucash 4.13 Windows 10. Long time user.

 I am trying out using a variable in a scheduled transaction for the
 first time, and it's not behaving the way I expect. I am creating a
 multi-entry transaction that transfers a single amount between two pairs
 of accounts. in other words:

 DB Checking TOTALAMT
 CR Asset TOTALAMT
 CR Income A TOTALAMT
 DB Income B TOTALAMT

 [This is testing out how to create a transaction to track an IRA
 distribution]

 I expect GnuCash to prompt me for the TOTALAMT figure once when the
 transaction is created, but GnuCash prompts me for *each* TOTALAMT entry
 in the transaction (i.e., four times). Is there a way to have just one
 request that gets assigned four times?
___
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] Scheduled Transactions Question

2023-01-13 Thread David Carlson
I do recall this same issue came up in another thread and I thought there
was already a solution mentioned,  but it is really difficult to search for
it on a phone .

Perhaps someone else remembers where to find it?

On Fri, Jan 13, 2023, 12:52 PM David Carlson 
wrote:

> Never mind, I can't read your whole message at once on my phone
>
> On Fri, Jan 13, 2023, 12:50 PM David Carlson 
> wrote:
>
>> David,
>>
>> Which version of GnuCash are you using?
>>
>> On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>>
>>> Hi,
>>>
>>> Gnucash 4.13 Windows 10. Long time user.
>>>
>>> I am trying out using a variable in a scheduled transaction for the
>>> first time, and it's not behaving the way I expect. I am creating a
>>> multi-entry transaction that transfers a single amount between two pairs
>>> of accounts. in other words:
>>>
>>> DB Checking TOTALAMT
>>> CR Asset TOTALAMT
>>> CR Income A TOTALAMT
>>> DB Income B TOTALAMT
>>>
>>> [This is testing out how to create a transaction to track an IRA
>>> distribution]
>>>
>>> I expect GnuCash to prompt me for the TOTALAMT figure once when the
>>> transaction is created, but GnuCash prompts me for *each* TOTALAMT entry
>>> in the transaction (i.e., four times). Is there a way to have just one
>>> request that gets assigned four times?
>>>
>>> David T.
>>>
>>> ___
>>> 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] reports not working unless exported

2023-01-13 Thread David H
Jeff,

I seem to recall just doing a "Flatpak Update" fixed an issue with blank
reports a little while ago - from memory it updated something else but I
don't remember the details. So give that a shot and see if it fixes the
issue.

Cheers David H.

On Sat, 14 Jan 2023 at 07:12, Jeff  wrote:

> Running:
>
> Version: 4.13
> Build ID: Flathub 4.13
> Finance::Quote: 1.5301
>
> on:
>
> Ubuntu 22.04.1 LTS
>
> I went to generate some reports for the year 2022 and not one of the
> standard reports will work within GNC now.  (Not sure from which version
> from Flathub this started.)  ALL of the reports built into GNC now have
> to be exported to see them and time wise that is a problem right now,
> especially if I screw up and include/exclude a wrong account.
>
> I vaguely remember reading a post on how to correct this problem.  Any
> help appreciated.
>
> --
> --JEffrey Black M.B.A.
>
> ___
> 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] reports not working unless exported

2023-01-13 Thread Michael or Penny Novack



I went to generate some reports for the year 2022 and not one of the 
standard reports will work within GNC now.



Explain what you mean by "will not work" Are you having a DATE 
problem? (you don't know how to specify the effective date(s) for a report?)



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.


Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread Michael or Penny Novack

On 1/13/2023 11:48 AM, R Losey wrote:
Thanks. The only minor drawback is that I seem to be entering the data 
twice under "Income" just to keep track of IRA distributions on their 
own. But hey, it's one way to make it work.


And, as has been pointed out, since this is not really "income", it 
makes sense that the transaction has no net income. I think I'll adopt 
this method for 2023.


In hindsight, since the Fiduciary Trust that keeps the IRA has to 
report to me on distributions, I haven't felt a need to have an 
account for this and to double-check them.




On Thu, Jan 12, 2023 at 10:56 PM David T.  wrote:

Two separate entries. In my mind, this would best be put in one
transaction, to make the association obvious.

CR - Assets: IRA $1000
DB - Assets: Checking $1000
DB - Income: Deferred Income $1000
CR - Income: IRA Distribution $1000 *

<<< it most certainly COULD be in one entry. A transaction can have more 
than two accounts. It is only when entering via the shortcut "enter 
directly into the ledger" that gnucash allows you to do that is limited 
to two accounts. When entering a "split" in "journal mode" you can have 
more than two. In the old days ALL transactions were entered first in 
the journal and then posted to the ledger. But even in pen and ink days 
we had SOME shortcut possibilities, like "cashbook accounting" << where 
a small subset of the ledger allowed direct entry skipping the journal.>>


BUT -- I would not have "deferred income" under income, because it is 
more like a standing account. The money that you put into the 401k/IRA 
did not get counted in your income in those years. The money contributed 
by your employer (401k) did not get counted as income back then, nor the 
annual increases in fund value as you perhaps marked to market at year 
end (the investment income of the fund).


When you take distributions later is when it becomes income << you are 
undeferring that amount >>


This is accounting, not gnucash

Michael D Novack




* Income: IRA Distribution is used to document the distribution
for tax purposes.

David T.
On Jan 13, 2023, at 7:21 AM, R Losey  wrote:

Thanks for all of the information... however, getting back to the 
original
question, I'm not sure how to record IRA taxable distributions. I 
thought I
was doing it, but I am apparently not.

Let me write through a couple of cases.  In the first one, I'm selling
$1000 worth (10 shares) of security A and having it go directly to my
checking account with no income tax withholding. (some of these may be
USA-centric terms; I apologize for that).



___
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] reports not working unless exported

2023-01-13 Thread Jeff

Running:

Version: 4.13
Build ID: Flathub 4.13
Finance::Quote: 1.5301

on:

Ubuntu 22.04.1 LTS

I went to generate some reports for the year 2022 and not one of the 
standard reports will work within GNC now.  ALL of the reports built 
into GNC now have to be exported to see them and time wise that is a 
problem right now, especially if I screw up and include/exclude a wrong 
account.


I vaguely remember reading a post on how to correct this problem. Any 
help appreciated.


--
--JEffrey Black M.B.A.

___
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] reports not working unless exported

2023-01-13 Thread Jeff

Running:

Version: 4.13
Build ID: Flathub 4.13
Finance::Quote: 1.5301

on:

Ubuntu 22.04.1 LTS

I went to generate some reports for the year 2022 and not one of the 
standard reports will work within GNC now.  (Not sure from which version 
from Flathub this started.)  ALL of the reports built into GNC now have 
to be exported to see them and time wise that is a problem right now, 
especially if I screw up and include/exclude a wrong account.


I vaguely remember reading a post on how to correct this problem.  Any 
help appreciated.


--
--JEffrey Black M.B.A.

___
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] exporting from gnucash to Excel

2023-01-13 Thread Maf. King
On Friday, 13 January 2023 04:45:20 GMT David T. via gnucash-user wrote:
> Indeed.
> 
> I don't have to comply with this either, but it seems to me that "pressing a
> button" to export to Excel provides exactly the same automated reliability
> as CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both
> cases will have the same reliability.
> 

You know that,  I know that.  The gubberment want "more automation" than that.  
 

Because all the VAT fraud in the world happens when you make an honest error 
copying 3 numbers between programs, not systematically at the point of data 
entry...

It's digital, and only directly linked.  must be foolproof, so say the powers 
that be

Hmmm.  >:-)
Maf.






___
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] exporting from gnucash to Excel

2023-01-13 Thread Maf. King
On Thursday, 12 January 2023 14:05:04 GMT Paul W via gnucash-user wrote:
> To submit VAT data to HMRC here in the UK I am obliged to use a method which
> is automatic. So I need to find a way to trasnfer the balances from a
> couple of accounts to an Excel spreadsheet automatically ie not by copying
> and pasting. I need to press a button and it is done without the
> opportunity for errors to be introduced to the figures.Then I use some
> pre-approved software which reads the spreadsheet and uploads the data to
> HMRC. Is there some way to transfer a balance from an account to an Excel
> spreadsheet? ___

Hi Paul.

Yes. quite easy.

You need the report called Income and GST statement, which I find under the 
Reports -> Income & Expenses menu.

Then options -> Format -> UK VAT return
(and any other tweaking you need)

Export -> as CSV

boom, open the CSV in your spreadsheet...

(I use one from CHM software in LibreOffice Calc to file the return, I've 
persuaded it to open the exported CSV and self-populate.  Not an endorsment, 
no connection etc, but I find it does the job.)

good luck.
Maf.


___
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] Scheduled Transactions Question

2023-01-13 Thread David Carlson
Never mind, I can't read your whole message at once on my phone

On Fri, Jan 13, 2023, 12:50 PM David Carlson 
wrote:

> David,
>
> Which version of GnuCash are you using?
>
> On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> Hi,
>>
>> Gnucash 4.13 Windows 10. Long time user.
>>
>> I am trying out using a variable in a scheduled transaction for the
>> first time, and it's not behaving the way I expect. I am creating a
>> multi-entry transaction that transfers a single amount between two pairs
>> of accounts. in other words:
>>
>> DB Checking TOTALAMT
>> CR Asset TOTALAMT
>> CR Income A TOTALAMT
>> DB Income B TOTALAMT
>>
>> [This is testing out how to create a transaction to track an IRA
>> distribution]
>>
>> I expect GnuCash to prompt me for the TOTALAMT figure once when the
>> transaction is created, but GnuCash prompts me for *each* TOTALAMT entry
>> in the transaction (i.e., four times). Is there a way to have just one
>> request that gets assigned four times?
>>
>> David T.
>>
>> ___
>> 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] Scheduled Transactions Question

2023-01-13 Thread David Carlson
David,

Which version of GnuCash are you using?

On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,
>
> Gnucash 4.13 Windows 10. Long time user.
>
> I am trying out using a variable in a scheduled transaction for the
> first time, and it's not behaving the way I expect. I am creating a
> multi-entry transaction that transfers a single amount between two pairs
> of accounts. in other words:
>
> DB Checking TOTALAMT
> CR Asset TOTALAMT
> CR Income A TOTALAMT
> DB Income B TOTALAMT
>
> [This is testing out how to create a transaction to track an IRA
> distribution]
>
> I expect GnuCash to prompt me for the TOTALAMT figure once when the
> transaction is created, but GnuCash prompts me for *each* TOTALAMT entry
> in the transaction (i.e., four times). Is there a way to have just one
> request that gets assigned four times?
>
> David T.
>
> ___
> 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] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread R Losey
I suppose a way to handle the "Income but not really income" would be ao
follows (see what people think about this):

CR - Assets: IRA $1000
DB - Income: IRA Distribution $1000
CR - Income: IRA Distribution $1000
DB - Assets: Checking $1000

This way, the income change is zero, but I can still track the "Income" for
tax purposes by looking at the debits for the year.

What do ye readers think of that?

Richard

On Thu, Jan 12, 2023 at 11:14 PM Stan Brown 
wrote:

>
> On 2023-01-12 20:55, David T. via gnucash-user wrote:
> > Two separate entries. In my mind, this would best be put in one
> transaction, to make the association obvious.
> >
> > CR - Assets: IRA $1000
> > DB - Assets: Checking $1000
> > DB - Income: Deferred Income $1000
> > CR - Income: IRA Distribution $1000 *
> >
> > * Income: IRA Distribution is used to document the distribution for tax
> purposes.
>
> My only problem with that is that a distribution from an IRS is not
> income, any more that the currency you receive when you cash a check is
> income.
>
> It's simply moving a portion of your assets from one bucket to another.
> And it seems very strange to me that the one event should be recorded in
> a four-split transaction.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
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.


Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread R Losey
Sorry about "category" versus "account" -- I still, after 7 years, have
Quicken habits... but I would argue that many people see an "account" as
something that has both debits and credits (like a bank account), as
opposed to "categories", which, for the most part, only have credits or
debits (like "Groceries" or "Salary"). I do know that they are actually
accounts, and I like that.

While this may not be "Income" in the accounting sense, it is income in the
practical sense... but of course you are correct that the net worth isn't
changing; it's just a transfer of assets, like paying off a credit card or
making a house payment.


On Thu, Jan 12, 2023 at 11:09 PM Stan Brown 
wrote:

> On 2023-01-12 20:19, R Losey wrote:
> > Let me write through a couple of cases.  In the first one, I'm selling
> > $1000 worth (10 shares) of security A and having it go directly to my
> > checking account with no income tax withholding. (some of these may be
> > USA-centric terms; I apologize for that).
> >
> > If I can create a "Sell" transaction that sells 10 shares at $1000; the
> > other entry would be to increase my taxable distribution category by
> $1000.
> > But what next? My checking account doesn't have the $1000 increase, but
> > then what is the "other" category to use for that transaction??
>
> Please forget the notion of "category". Some accounting packages have
> that, but it seems to be basically a confusing synonym for "expense-type
> account" and maybe "income-type account).
>
> GnuCash has _accounts_. You have an asset-type account for your checking
> account, and another asset0type account for your security(ies).
>
> When you sell shares for cash, you increase the balance in your checking
> account and decrease the balance in your security account, like this:
>
> Debit (left-hand number column) to Assets:Checking Account
> Credit (right-hand column) to Assets:Security(ies).
>
> Taxable distribution is not an account, and the distribution is _not_
> _income_. Your net worth is the same after the sale and distribution as
> it was before the sale.
>
> Yes,I know that the amount of an IRA distribution must be reported as
> taxable income on your form 1040, but in an accounting sense it is not
> income.
>
> And speaking of distributions, did you miss the note I posted at 11:33
> this morning (Pacific time)? I really don't know why you have no choice
> about having withholding taken from an IRA distribution. You can
> _choose_ to do it, or you can file estimated taxes, or maybe your income
> is low enough that you don't even need to do that. But -- unless the
> money is going outside the United States -- you have a _choice_ about
> whether to have withholding. I gave citations and quotes from the IRS
> website.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
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.


Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread R Losey
Thanks. The only minor drawback is that I seem to be entering the data
twice under "Income" just to keep track of IRA distributions on their own.
But hey, it's one way to make it work.

And, as has been pointed out, since this is not really "income", it makes
sense that the transaction has no net income. I think I'll adopt this
method for 2023.

In hindsight, since the Fiduciary Trust that keeps the IRA has to report to
me on distributions, I haven't felt a need to have an account for this and
to double-check them.



On Thu, Jan 12, 2023 at 10:56 PM David T.  wrote:

> Two separate entries. In my mind, this would best be put in one
> transaction, to make the association obvious.
>
> CR - Assets: IRA $1000
> DB - Assets: Checking $1000
> DB - Income: Deferred Income $1000
> CR - Income: IRA Distribution $1000 *
>
> * Income: IRA Distribution is used to document the distribution for tax
> purposes.
>
> David T.
> On Jan 13, 2023, at 7:21 AM, R Losey  wrote:
>>
>> Thanks for all of the information... however, getting back to the original
>> question, I'm not sure how to record IRA taxable distributions. I thought I
>> was doing it, but I am apparently not.
>>
>> Let me write through a couple of cases.  In the first one, I'm selling
>> $1000 worth (10 shares) of security A and having it go directly to my
>> checking account with no income tax withholding. (some of these may be
>> USA-centric terms; I apologize for that).
>>
>> If I can create a "Sell" transaction that sells 10 shares at $1000; the
>> other entry would be to increase my taxable distribution category by $1000.
>> But what next? My checking account doesn't have the $1000 increase, but
>> then what is the "other" category to use for that transaction??
>>
>> I looked at my data, and what I've been doing is that the other side of the
>> Sell transaction is a deposit to my bank account, but this fails because
>> there is no record of a taxable distribution.
>>
>>
>> On Thu, Jan 12, 2023 at 2:42 PM Michael or Penny Novack <
>> stepbystepf...@comcast.net> wrote:
>>
>>  On 1/12/2023 12:41 PM, R Losey wrote:
>>>
  Thanks; I know the information is out there, but intuitively, it doesn't
  make sense to me that depositing funds to my bank account is a "debit"
  transaction to the bank. It comes from the concept of credit being "added
  to" and debit being "substracted from", I suppose.

  Is the "Debit on the left" and "Credit on the right" true in general
  accounting, or just GnuCash?

>>>
>>>  a) Double entry bookkeeping goes back a long way, long enough that Latin
>>>  still in use for communications among the educated in Europe. Think of
>>>  "debit" and "credit" not in terms of plus and minus (before European
>>>  math had negative numbers) but as "he owes"(me) and "he trusts" (me). In
>>>  other words  he owes me that amount and he trusts me for that amount (I
>>>  owe him)
>>>
>>>  Now look again at the bank account.In YOUR books a debit (the bank
>>>  owes you this money) and in the bank's book a credit (the bank owes you
>>>  this money)
>>>
>>>  b) Debit on the left and credit on the right. In the old days ledger
>>>  pages had two sides, one side for the debits and the other for the
>>>  credits (and no balance column). Perhaps within my lifetime it became
>>>  more common to use three column paper with debit and credit transactions
>>>  with one date, check number, description, and journal reference column
>>>  then a left for debit, a right (middle) for credit, and a balance. o a
>>>  running balance was kept << finding the balance was a process in the old
>>>  days before that >>
>>>
>>>  NOTICE -- so far pen and ink on paper, and gnucash is simply modelling that
>>>
>>>  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.
>>
>>
>>
>>

-- 
_
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.


[GNC] Scheduled Transactions Question

2023-01-13 Thread David T. via gnucash-user

Hi,

Gnucash 4.13 Windows 10. Long time user.

I am trying out using a variable in a scheduled transaction for the 
first time, and it's not behaving the way I expect. I am creating a 
multi-entry transaction that transfers a single amount between two pairs 
of accounts. in other words:


DB Checking TOTALAMT
CR Asset TOTALAMT
CR Income A TOTALAMT
DB Income B TOTALAMT

[This is testing out how to create a transaction to track an IRA 
distribution]


I expect GnuCash to prompt me for the TOTALAMT figure once when the 
transaction is created, but GnuCash prompts me for *each* TOTALAMT entry 
in the transaction (i.e., four times). Is there a way to have just one 
request that gets assigned four times?


David T.

___
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] exporting from gnucash to Excel

2023-01-13 Thread Thomas Forrester
Scripts can also make redundant tasks less of a burden through hands-off
automation.  That's what scripts do well, too.  I'm seeing a few posts in
this topic verging on berating the OP for wanting to do something and
asking if there's a way.  Maybe you stop second-guessing the OP's needs and
motives.  If you have no real idea how to do something, or have nothing
constructive to add, maybe just remain silent.

On Fri, Jan 13, 2023 at 4:37 AM Liz Dodd  wrote:

> On Fri, 13 Jan 2023 07:45:20 +0300
> "David T. via gnucash-user"  wrote:
>
> > Indeed.
> >
> > I don't have to comply with this either, but it seems to me that
> > "pressing a button" to export to Excel provides exactly the same
> > automated reliability as CTRL-C/CTRL-V (two buttons, if you will)
> > into Excel. The data in both cases will have the same reliability.
> >
> > ⁣David T. ​
>
> It's come from the same purveyors as many other things which sound good
> but don't work in the real world.
> Data can get changed at any point, and it doesn't have to be as obvious
> as a lightning bolt hitting your house. Automating the proceedings
> doesn't guarantee accuracy, it hides the potentials for error.
>
> When you write your script to do this little task, there are
> opportunities to add to or subtract from the data. That's what scripts
> do well ;)
>
> 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.


Re: [GNC] Recommended Method of Entry for IRA Distributions

2023-01-13 Thread Mark Penner via gnucash-user



Jan 11, 2023 18:07:03 R Losey :

I apologize for not using "debit" and "credit" terms, but I'm not sure 
I'd

get them right.


I also have to think a bit sometimes to get them right. As someone(s) 
said, debits are always on the left, credits on the right. I just 
remember that money flows from right to left, from the credited accounts 
to the debited accounts. I find that easier to remember than which types 
of accounts increase with debits, etc.


HTH
Mark
___
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] exporting from gnucash to Excel

2023-01-13 Thread Liz Dodd
On Fri, 13 Jan 2023 07:45:20 +0300
"David T. via gnucash-user"  wrote:

> Indeed. 
> 
> I don't have to comply with this either, but it seems to me that
> "pressing a button" to export to Excel provides exactly the same
> automated reliability as CTRL-C/CTRL-V (two buttons, if you will)
> into Excel. The data in both cases will have the same reliability. 
> 
> ⁣David T. ​

It's come from the same purveyors as many other things which sound good
but don't work in the real world.
Data can get changed at any point, and it doesn't have to be as obvious
as a lightning bolt hitting your house. Automating the proceedings
doesn't guarantee accuracy, it hides the potentials for error.

When you write your script to do this little task, there are
opportunities to add to or subtract from the data. That's what scripts
do well ;)

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.