Re: [GNC] Website from WIki

[David T. via gnucash-user]

Hmm. That is odd. The page identifies itself as the default page when Apache is 
installed under Ubuntu, suggesting an error in the GnuCash web server setup. 
"www.gnucash.org" works properly; "gnucash.org" does not. 

⁣David T. ​

On Jan 15, 2023, 9:32 AM, at 9:32 AM, Fred Tydeman  
wrote:
>I am doing a search (for T-bill) on the gnucash wiki.
>I get the Search Results page (with 181 results).
>On the left side of the page, I click on GnuCash Website.
>That gets me:  Apache2 Ubuntu Default Page
>That seems wrong to me.
>The URL in the address bar of Google Chrome is:  gnucash.org
>___
>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] Website from WIki

[Fred Bone]

On 14 January 2023 at 22:30, Fred Tydeman said:

> I am doing a search (for T-bill) on the gnucash wiki.
> I get the Search Results page (with 181 results).
> On the left side of the page, I click on GnuCash Website.
> That gets me:  Apache2 Ubuntu Default Page
> That seems wrong to me.
> The URL in the address bar of Google Chrome is:  gnucash.org

That's because the link in the Wiki is to
 http://www.gnucash.org
whereas it ought to be to
 https://gnucash.org
or
 https://www.gnucash.org

You'll also have noticed that the "default page" is not-secure (your 
browser should be notifying you of this).

Perhaps the maintainers of the gnucash.org website could add a redirect 
rule for incoming http:// requests.
___
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] TAX Report WAS Re: reports not working unless exported

[Phyllis Bruce]

Tommy, thanks for the new thread.

On Sat, Jan 14, 2023 at 4:35 PM Tommy Trussell 
wrote:

> reply below
>
> On Sat, Jan 14, 2023 at 3:49 PM Phyllis Bruce  wrote:
>
>> Okay, I can't stand it anymore.  I don't know what ubuntu is, or flatpak,
>> or a host of other terms you use.  I run windows and the latest version.
>> Embarrassed that I've not looked to documentation, but would that help me
>> or do I need to know?
>>
>> I will go to documentation to learn about the tax report.  There is
>> obviously something I'm not seeing but I did notice that when I chose
>> "Report Options" Start and end of accounting period, last year I got one
>> expense category for 2022.  I have so far been unable to add other income
>> or expense categories.  I know it's in the documentation and I will find it.
>>
>> Thanks
>>
>>> 
>>
>>
> The tax report is more complicated, and in fact I have never used it. But
> I just created a new subject for this thread.
>
> I believe you have to do quite a bit of setup to use the tax report -- you
> have to identify the accounts that are relevant and you have to tag each of
> those accounts with the IRS form numbers.
>
> I believe the report also works for the German equivalent of the US IRS.
>
>
>
>
>>
>>> -
>>> 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] Website from WIki

[Chris Green]

On Sun, Jan 15, 2023 at 02:19:13PM +0300, David T. via gnucash-user wrote:
> Hmm. That is odd. The page identifies itself as the default page when Apache 
> is installed under Ubuntu, suggesting an error in the GnuCash web server 
> setup. "www.gnucash.org" works properly; "gnucash.org" does not. 
> 
That suggests that someone has got their DNS configuration wrong, or,
looking more closely, the virtual hosts configuration on their web
server.

Both gnacash.org and www.gnucash.org give the same IP:-

chris@isbd$ client_loop: send disconnect: Broken pipe
chris$ host gnucash.org
gnucash.org has address 67.198.37.17
gnucash.org mail is handled by 10 lists.gnucash.org.
chris$ host www.gnucash.org
www.gnucash.org has address 67.198.37.17

So that's as it should be, so it's probably something in the web
server setup that's wrong.


-- 
Chris Green
___
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] Certificate of Deposit Early Withdrawal Penalty Account Entry

[Murugan Muruganandam]

hi Stephen

The entries can be input as follows.  I could not understand where you are 
getting orphans or imbalances  if you can explain it would be easy

Account Dr  Cr  Notes
Principal   Asst: Bank Account  Asst: CD Account$ Principal 
amount
InterestAsst: Bank Account  Income: CD Interest Interest earned 
+ partial month $162.89
Penalty InterestExp: Bank: PenaltiesIncome: CD Interest Total 
penalty $1.529,51





Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Stephen 
Sent: Sunday, January 15, 2023 4:30 AM
To: gnucash-user@gnucash.org 
Cc: gnucash-user@gnucash.org 
Subject: [GNC] Certificate of Deposit Early Withdrawal Penalty Account Entry

I had a CD that I closed before it matured. The bank applied a penalty
of 90 days interest at the CD rate. In fact the total penalty was
figured as the sum of principal penalty of $1,366.62 and penalty amount
paid from interest earned for the period of a partial month of $162.89
for a total penalty of $1,529.51. The statement clearly shows a payment
of +$162.89 and a penalty of -$162.89 and a penalty amount from
principal of the $1,366.62.  The interest earned and penalized is a net
$0 so I could just book the $1,366.62 as a charge to the CD account and
as as an charge to an early withdrawal penalty account to obtain the
closing balance on the account. But it seems to me that I should be
booking at least 3 splits to show the interest earned account and
interest earned penalized account and the rest of the penalty as a
charge to the CD account but the numbers produce orphans or imbalances.
I'm treating all entries as income items so interest earned, interest
penalized, and a principal penalty. They are multiple entries and not
multiple splits in the CD income account. Is this the correct way to
book this? Some guidance would be appreciated. Thanks in advance.
___
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] exporting from gnucash to Excel

[Maf. King]

On Sunday, 15 January 2023 16:30:38 GMT Paul W wrote:
>  Thanks Maf. That seems like a neat solution. I'm almost there.
> Because I'm on the Flat Rate Scheme my Box 6 figure needs to be the total of
> sales including VAT but apart from my Accounts Receivable which goes to
> zero once the invoice is paid I don't see how to get that figure from
> anywhere. I mean my Income:Sales figure does not include the tax - that
> goes separately to my ouput VAT liability account (which I use to populate
> Box1).
> 
> By the way I'm using 100pc VAT Free Bridge to read a spreadsheet and send
> the figures to HMRC.It is free and has worked well.
> 

I've heard of but never looked at the flat rate scheme, so I can't really offer 
any words on it.

but if you invoice for £100 + VAT, are you saying that Box1= 20 and box 6 = 
120?

thanks for the tip on the VAT Bridge Free will investigate it before I do 
my return later in the month!

regards,
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] Website from WIki

[John Ralls]

> On Jan 15, 2023, at 7:40 AM, Chris Green  wrote:
> 
> On Sun, Jan 15, 2023 at 02:19:13PM +0300, David T. via gnucash-user wrote:
>> Hmm. That is odd. The page identifies itself as the default page when Apache 
>> is installed under Ubuntu, suggesting an error in the GnuCash web server 
>> setup. "www.gnucash.org" works properly; "gnucash.org" does not. 
>> 
> That suggests that someone has got their DNS configuration wrong, or,
> looking more closely, the virtual hosts configuration on their web
> server.
> 
> Both gnacash.org and www.gnucash.org give the same IP:-
> 
>chris@isbd$ client_loop: send disconnect: Broken pipe
>chris$ host gnucash.org
>gnucash.org has address 67.198.37.17
>gnucash.org mail is handled by 10 lists.gnucash.org.
>chris$ host www.gnucash.org
>www.gnucash.org has address 67.198.37.17
> 
> So that's as it should be, so it's probably something in the web
> server setup that's wrong.

VHosts. The http->https redirect seems to be broken. I've changed the link on 
the wiki to use https and told the person who maintains that server about the 
config problem.

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] TAX Report WAS Re: reports not working unless exported

[Alex Aycinena]

On Sat, Jan 14, 2023 at 10:59 PM  wrote:

-- Forwarded message --
> From: "David T." 
> To: Tommy Trussell 
> Cc: Phyllis Bruce , Gnucash Users <
> gnucash-user@gnucash.org>
> Bcc:
> Date: Sun, 15 Jan 2023 09:48:25 +0300
> Subject: Re: [GNC] TAX Report WAS Re:  reports not working unless exported
> Phyllis,
>
> Tommy is right. In order for the tax report to work, you must go to
> Edit->Tax Report Options, locate each account in the left entry box, and
> enter the IRS form and line for which the account is relevant in the right
> box. It is a tedious process, but only has to be done once for a set of
> books (aside from changes that must be made as you modify your account
> structures or the tax code changes).
>
> I did this many years ago, and have really liked the ability to get a
> quick snapshot of my overall tax situation in one quick report. Back in the
> day, you could use the report to populate several tax software packages
> (like TurboTax), but in recent years, these programs import forms directly
> from providers, rendering this aspect moot. But I still use this report
> regularly.
>
> When I set this up many years ago, it was necessary to assign each account
> separately, as in you had to exit the dialog after every account assigned;
> more recently, the interface has improved just a little bit, in that you
> can assign multiple accounts to the same IRS line at one pass (helpful for
> interest, dividend and capital gains accounts). But you cannot step through
> all your accounts and assign tax options sequentially in the one dialog. I
> don't know if this has changed, but I wouldn't expect it to have changed.
>
> David T.
>
>

Also there is a column that can be displayed in the Account Hierarchy tab
showing if a particular account is 'tagged' for the US Income Tax Report
(use the large downward pointing arrow on the right to select to display
it). This can be helpful if you want to scan quickly through accounts to
see if all necessary accounts have been 'tagged' and no inappropriate ones
have,

Alex
___
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] Certificate of Deposit Early Withdrawal Penalty Account Entry

[Gyle McCollam]

I would enter this Murugan suggested. Let's say the balance of the CD prior to 
closing on your books was $300,000.00
 Using the amounts you have given:
Debit   Credit
Asset: Acct moved to$298,633.38  (Closing Balance)
Income: CD Interest   $162.89
Exp: Bank: Penalties  $1529.51
Asset: CD  $300,000.00  (Balance just prior to this 
entry)


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Murugan Muruganandam 
Sent: Sunday, January 15, 2023 11:17 AM
To: Stephen ; gnucash-user@gnucash.org 

Subject: Re: [GNC] Certificate of Deposit Early Withdrawal Penalty Account Entry

hi Stephen

The entries can be input as follows.  I could not understand where you are 
getting orphans or imbalances  if you can explain it would be easy

Account Dr  Cr  Notes
Principal   Asst: Bank Account  Asst: CD Account$ Principal 
amount
InterestAsst: Bank Account  Income: CD Interest Interest earned 
+ partial month $162.89
Penalty InterestExp: Bank: PenaltiesIncome: CD Interest Total 
penalty $1.529,51





Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Stephen 
Sent: Sunday, January 15, 2023 4:30 AM
To: gnucash-user@gnucash.org 
Cc: gnucash-user@gnucash.org 
Subject: [GNC] Certificate of Deposit Early Withdrawal Penalty Account Entry

I had a CD that I closed before it matured. The bank applied a penalty
of 90 days interest at the CD rate. In fact the total penalty was
figured as the sum of principal penalty of $1,366.62 and penalty amount
paid from interest earned for the period of a partial month of $162.89
for a total penalty of $1,529.51. The statement clearly shows a payment
of +$162.89 and a penalty of -$162.89 and a penalty amount from
principal of the $1,366.62.  The interest earned and penalized is a net
$0 so I could just book the $1,366.62 as a charge to the CD account and
as as an charge to an early withdrawal penalty account to obtain the
closing balance on the account. But it seems to me that I should be
booking at least 3 splits to show the interest earned account and
interest earned penalized account and the rest of the penalty as a
charge to the CD account but the numbers produce orphans or imbalances.
I'm treating all entries as income items so interest earned, interest
penalized, and a principal penalty. They are multiple entries and not
multiple splits in the CD income account. Is this the correct way to
book this? Some guidance would be appreciated. Thanks in advance.
___
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.

[GNC] Merge two pairs -> one 4-way split

[Fred Tydeman]

I have one transaction moving money from A to B (one pair)
I have another transaction moving money from C to D (another pair)
I now realize I should have one transaction with 4 splits.
Is there an easy way to merge the two pairs into one 4-way split?
Or, do I have to manually re-enter 40 transactions?
___
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] Merge two pairs -> one 4-way split

[Stephen M. Butler]

On 1/15/23 11:50, Fred Tydeman wrote:

I have one transaction moving money from A to B (one pair)
I have another transaction moving money from C to D (another pair)
I now realize I should have one transaction with 4 splits.
Is there an easy way to merge the two pairs into one 4-way split?
Or, do I have to manually re-enter 40 transactions?

I do not know of a way to easily merge transactions.

On a practical note.  Why make the change retroactive?  My solution is 
to let the past be and make the change going forward.


--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Merge two pairs -> one 4-way split

[David Cousens]

Fred
If the transactions are otherwise correct, why would you need to alter them? If
you need to tie them together, put an easily found "tag' in the description for
each to link them and then in future when you need to do similar transfers use
the multi-split approach. If the books are correct making wide sweeping changes
introduces the likelihood of introducing mistakes unnecessarily.

David Cousens


On Sun, 2023-01-15 at 11:50 -0800, Fred Tydeman wrote:
> I have one transaction moving money from A to B (one pair)
> I have another transaction moving money from C to D (another pair)
> I now realize I should have one transaction with 4 splits.
> Is there an easy way to merge the two pairs into one 4-way split?
> Or, do I have to manually re-enter 40 transactions?
> ___
> 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] Certificate of Deposit Early Withdrawal Penalty Account Entry

[Stephen]

Thanks to you and Murugan I got this sorted. As usual, over-thought and 
over-wrought. Although I'm sure I could show all the changes in one 
split entry it was easiest for me to credit the interest 162.89 as one 
standalone entry first. Then I could see my way clearly to showing the 
two penalty sub-amounts totaling 1529.51. Intuitively I fairly certain I 
could have shown the interest earned among the splits all as one entry 
but I'm going to quit while I'm ahead. I just didn't want to lose the 
detail of the separate penalty amounts nor their total.  Again, many thanks.


On 1/15/2023 11:23 AM, Gyle McCollam wrote:
I would enter this Murugan suggested. Let's say the balance of the CD 
prior to closing on your books was $300,000.00

 Using the amounts you have given:
Debit   Credit
Asset: Acct moved to$298,633.38  (Closing Balance)
Income: CD Interest   $162.89
Exp: Bank: Penalties  $1529.51
Asset: CD  $300,000.00 (Balance just prior 
to this entry)


Thank You,

*Gyle McCollam*

Gyle McCollam

gmccol...@live.com email


*From:* gnucash-user 
 on behalf of 
Murugan Muruganandam 

*Sent:* Sunday, January 15, 2023 11:17 AM
*To:* Stephen ; gnucash-user@gnucash.org 

*Subject:* Re: [GNC] Certificate of Deposit Early Withdrawal Penalty 
Account Entry

hi Stephen

The entries can be input as follows.  I could not understand where you 
are getting orphans or imbalances  if you can explain it would be easy


Account Dr  Cr  Notes
Principal   Asst: Bank Account  Asst: CD Account    $ 
Principal amount
Interest    Asst: Bank Account  Income: CD Interest 
Interest earned + partial month $162.89
Penalty Interest    Exp: Bank: Penalties    Income: CD 
Interest Total penalty $1.529,51






Saludos Cordiales


Murugan


From: gnucash-user 
 on 
behalf of Stephen 

Sent: Sunday, January 15, 2023 4:30 AM
To: gnucash-user@gnucash.org 
Cc: gnucash-user@gnucash.org 
Subject: [GNC] Certificate of Deposit Early Withdrawal Penalty Account 
Entry


I had a CD that I closed before it matured. The bank applied a penalty
of 90 days interest at the CD rate. In fact the total penalty was
figured as the sum of principal penalty of $1,366.62 and penalty amount
paid from interest earned for the period of a partial month of $162.89
for a total penalty of $1,529.51. The statement clearly shows a payment
of +$162.89 and a penalty of -$162.89 and a penalty amount from
principal of the $1,366.62.  The interest earned and penalized is a net
$0 so I could just book the $1,366.62 as a charge to the CD account and
as as an charge to an early withdrawal penalty account to obtain the
closing balance on the account. But it seems to me that I should be
booking at least 3 splits to show the interest earned account and
interest earned penalized account and the rest of the penalty as a
charge to the CD account but the numbers produce orphans or imbalances.
I'm treating all entries as income items so interest earned, interest
penalized, and a principal penalty. They are multiple entries and not
multiple splits in the CD income account. Is this the correct way to
book this? Some guidance would be appreciated. Thanks in advance.
___
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.

Re: [GNC] Merge two pairs -> one 4-way split

[Phyllis Bruce]

I agree, why change them.  However, I question the need to make a single 4
way split unless one of the transactions is to or from a single account.

On Sun, Jan 15, 2023 at 1:51 PM Fred Tydeman  wrote:

> I have one transaction moving money from A to B (one pair)
> I have another transaction moving money from C to D (another pair)
> I now realize I should have one transaction with 4 splits.
> Is there an easy way to merge the two pairs into one 4-way split?
> Or, do I have to manually re-enter 40 transactions?
> ___
> 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] TAX Report WAS Re: reports not working unless exported

[Phyllis Bruce]

Thanks Alex, that is a neat feature and will be helpful as I slog through
the accounts.

>
> Also there is a column that can be displayed in the Account Hierarchy tab
> showing if a particular account is 'tagged' for the US Income Tax Report
> (use the large downward pointing arrow on the right to select to display
> it). This can be helpful if you want to scan quickly through accounts to
> see if all necessary accounts have been 'tagged' and no inappropriate ones
> have,
>
> Alex
>
>
___
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] Certificate of Deposit Early Withdrawal Penalty Account Entry

[Murugan Muruganandam]

stephen

one inquisitive question. did you receive any interest on the CD at all earlier 
and if so how did you account it




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Stephen 
Sent: Sunday, January 15, 2023 5:38 PM
To: Gyle McCollam ; gnucash-user@gnucash.org 

Subject: Re: [GNC] Certificate of Deposit Early Withdrawal Penalty Account Entry

Thanks to you and Murugan I got this sorted. As usual, over-thought and
over-wrought. Although I'm sure I could show all the changes in one
split entry it was easiest for me to credit the interest 162.89 as one
standalone entry first. Then I could see my way clearly to showing the
two penalty sub-amounts totaling 1529.51. Intuitively I fairly certain I
could have shown the interest earned among the splits all as one entry
but I'm going to quit while I'm ahead. I just didn't want to lose the
detail of the separate penalty amounts nor their total.  Again, many thanks.

On 1/15/2023 11:23 AM, Gyle McCollam wrote:
> I would enter this Murugan suggested. Let's say the balance of the CD
> prior to closing on your books was $300,000.00
>  Using the amounts you have given:
> Debit   Credit
> Asset: Acct moved to$298,633.38  (Closing Balance)
> Income: CD Interest   $162.89
> Exp: Bank: Penalties  $1529.51
> Asset: CD  $300,000.00 (Balance just prior
> to this entry)
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.com email
>
> 
> *From:* gnucash-user
>  on behalf of
> Murugan Muruganandam 
> *Sent:* Sunday, January 15, 2023 11:17 AM
> *To:* Stephen ; gnucash-user@gnucash.org
> 
> *Subject:* Re: [GNC] Certificate of Deposit Early Withdrawal Penalty
> Account Entry
> hi Stephen
>
> The entries can be input as follows.  I could not understand where you
> are getting orphans or imbalances  if you can explain it would be easy
>
> Account Dr  Cr  Notes
> Principal   Asst: Bank Account  Asst: CD Account$
> Principal amount
> InterestAsst: Bank Account  Income: CD Interest
> Interest earned + partial month $162.89
> Penalty InterestExp: Bank: PenaltiesIncome: CD
> Interest Total penalty $1.529,51
>
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user
>  on
> behalf of Stephen 
> Sent: Sunday, January 15, 2023 4:30 AM
> To: gnucash-user@gnucash.org 
> Cc: gnucash-user@gnucash.org 
> Subject: [GNC] Certificate of Deposit Early Withdrawal Penalty Account
> Entry
>
> I had a CD that I closed before it matured. The bank applied a penalty
> of 90 days interest at the CD rate. In fact the total penalty was
> figured as the sum of principal penalty of $1,366.62 and penalty amount
> paid from interest earned for the period of a partial month of $162.89
> for a total penalty of $1,529.51. The statement clearly shows a payment
> of +$162.89 and a penalty of -$162.89 and a penalty amount from
> principal of the $1,366.62.  The interest earned and penalized is a net
> $0 so I could just book the $1,366.62 as a charge to the CD account and
> as as an charge to an early withdrawal penalty account to obtain the
> closing balance on the account. But it seems to me that I should be
> booking at least 3 splits to show the interest earned account and
> interest earned penalized account and the rest of the penalty as a
> charge to the CD account but the numbers produce orphans or imbalances.
> I'm treating all entries as income items so interest earned, interest
> penalized, and a principal penalty. They are multiple entries and not
> multiple splits in the CD income account. Is this the correct way to
> book this? Some guidance would be appreciated. Thanks in advance.
> ___
> 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

Re: [GNC] Certificate of Deposit Early Withdrawal Penalty Account Entry

[Stephen]

Interest is accounted for as income per CD account. The way I ended up 
doing it allows me to see how much interest I have earned by each and 
all accounts and the interest penalty and principal penalties are noted 
as to which account they were applicable but I do not track the 
penalties account by account (because the penalty is for closing the 
account -- a one time event).


On 1/15/2023 2:59 PM, Murugan Muruganandam wrote:

stephen

one inquisitive question. did you receive any interest on the CD at 
all earlier and if so how did you account it




Saludos Cordiales


Murugan


*From:* gnucash-user 
 on 
behalf of Stephen 

*Sent:* Sunday, January 15, 2023 5:38 PM
*To:* Gyle McCollam ; gnucash-user@gnucash.org 

*Subject:* Re: [GNC] Certificate of Deposit Early Withdrawal Penalty 
Account Entry

Thanks to you and Murugan I got this sorted. As usual, over-thought and
over-wrought. Although I'm sure I could show all the changes in one
split entry it was easiest for me to credit the interest 162.89 as one
standalone entry first. Then I could see my way clearly to showing the
two penalty sub-amounts totaling 1529.51. Intuitively I fairly certain I
could have shown the interest earned among the splits all as one entry
but I'm going to quit while I'm ahead. I just didn't want to lose the
detail of the separate penalty amounts nor their total. Again, many 
thanks.


On 1/15/2023 11:23 AM, Gyle McCollam wrote:
> I would enter this Murugan suggested. Let's say the balance of the CD
> prior to closing on your books was $300,000.00
>  Using the amounts you have given:
> Debit   Credit
> Asset: Acct moved to$298,633.38  (Closing Balance)
> Income: CD Interest   $162.89
> Exp: Bank: Penalties  $1529.51
> Asset: CD  $300,000.00 (Balance just prior
> to this entry)
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.com >email

>
> 
> *From:* gnucash-user
>  on behalf of
> Murugan Muruganandam 
> *Sent:* Sunday, January 15, 2023 11:17 AM
> *To:* Stephen ; gnucash-user@gnucash.org
> 
> *Subject:* Re: [GNC] Certificate of Deposit Early Withdrawal Penalty
> Account Entry
> hi Stephen
>
> The entries can be input as follows.  I could not understand where you
> are getting orphans or imbalances  if you can explain it would be easy
>
> Account Dr  Cr  Notes
> Principal   Asst: Bank Account  Asst: CD Account    $
> Principal amount
> Interest    Asst: Bank Account  Income: CD Interest
> Interest earned + partial month $162.89
> Penalty Interest    Exp: Bank: Penalties Income: CD
> Interest Total penalty $1.529,51
>
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user
>  on
> behalf of Stephen 
> Sent: Sunday, January 15, 2023 4:30 AM
> To: gnucash-user@gnucash.org 
> Cc: gnucash-user@gnucash.org 
> Subject: [GNC] Certificate of Deposit Early Withdrawal Penalty Account
> Entry
>
> I had a CD that I closed before it matured. The bank applied a penalty
> of 90 days interest at the CD rate. In fact the total penalty was
> figured as the sum of principal penalty of $1,366.62 and penalty amount
> paid from interest earned for the period of a partial month of $162.89
> for a total penalty of $1,529.51. The statement clearly shows a payment
> of +$162.89 and a penalty of -$162.89 and a penalty amount from
> principal of the $1,366.62.  The interest earned and penalized is a net
> $0 so I could just book the $1,366.62 as a charge to the CD account and
> as as an charge to an early withdrawal penalty account to obtain the
> closing balance on the account. But it seems to me that I should be
> booking at least 3 splits to show the interest earned account and
> interest earned penalized account and the rest of the penalty as a
> charge to the CD account but the numbers produce orphans or imbalances.
> I'm treating all entries as income items so interest earned, interest
> penalized, and a principal penalty. They are multiple entries and not
> multiple splits in the CD income account. Is this the correct way to
> book this? Some guidance would be appreciated. Thanks in advance.
> ___
> 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
> -

Re: [GNC] Scheduled Transactions Window Sorting

[John Layman]

I'm running 4.13 on Windows 10 and can tell you that sort order is 'sticky' 
only if you are sorting on one of the two occurrence columns. It's a 
calendar-oriented feature, so I can't say I consider that an oversight.

-Original Message-
From: gnucash-user  On 
Behalf Of David T. via gnucash-user
Sent: Saturday, January 14, 2023 1:44 AM
To: Gnucash Users 
Subject: [GNC] Scheduled Transactions Window Sorting

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.

___
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] Printing invoices to PDF on OSX/Mac

[Waltr via gnucash-user]

This message is in response to a referral in a comment to the GnuCash 
suggestions concerning the PDF printing implementation change going to v4.4.

I probably don't update gnucash as often as I should and we missed the 4.4 ... 
4.12 versions.

In the comment Frank Ellenberger referred to this list.

My comments follow, followed by a link to the original referring page.

There is a serious operational issue with the move to the print dialog in OSX 
environments. The functionality in the print dialog defaults to a general file 
and does not remember the customer file where it belongs. This requires one of 
two actions: a.) a cumbersome change to the file name/location which in our 
operations requires a time consuming multistep directory change or b.) allowing 
the document to print to the default directory then moving that invoice to a 
proper customer directory for emailing.

The risk in the latter option is that the invoices will get mixed, or misnamed 
at generation time, or not moved at all and lost in the crowd of documents. In 
addition, for more structured systems environments, the documents directory is 
largely devoid of end documents and will rapidly become cluttered unless they 
are deleted which increases the risk of an inadvertent deletion of other 
mission critical data.

For the Mac OSX environment, the printer dialogues themselves permit a PDF 
option in the system dialogues.
I suggest a modification to make this much more efficient and safe in one of 
two ways:

-  Allow a system print dialog option which on OSX and some Unix system (we use 
FreeBSD) which will permit a rapid and efficient and most importantly 
recallable pdf selection.
- Gnucash is fabulous about remembering things about journal entries, which 
most of the time works really well. Extend this capability to the "Print to a 
File option" in the invoice printer.

Right now, the window block for file/directory storage function is very small, 
defaults to a single directory which is generic on osx, (/Users//Documents) 
and because of this must be made more globally readable than some systems 
implementations would like.

Permit either a recall the prior for that customer/invoice combination to store 
new invoices printed to a file, or the modify the menu button to allow 
selection of HTML or PDF export with the ability to efficiently select where 
the pdf file will be placed.

Thank you.

Link to original post:
https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/42356944-make-pdf-icon

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

[Paul W via gnucash-user]

 Thanks Maf. That seems like a neat solution. I'm almost there.
Because I'm on the Flat Rate Scheme my Box 6 figure needs to be the total of 
sales including VAT but apart from my Accounts Receivable which goes to zero 
once the invoice is paid I don't see how to get that figure from anywhere. I 
mean my Income:Sales figure does not include the tax - that goes separately to 
my ouput VAT liability account (which I use to populate Box1). 

By the way I'm using 100pc VAT Free Bridge to read a spreadsheet and send the 
figures to HMRC.It is free and has worked well.

On Friday, 13 January 2023 at 23:36:21 GMT+3, Maf. King  
wrote:  
 
 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] Certificate of Deposit Early Withdrawal Penalty Account Entry

[Gyle McCollam]

Stephen,
I could be wrong, but I bet when you get the 1099 for the CD both the interest 
and principal penalties will be combined in the penalty box.  Technically, the 
penalty is defined as simple interest for x days (depending on the term of the 
CD).  I would bet the interest earned on the CD will also be the total 
interest, including that which was accrued and listed as the interest penalty.  
If that is the case, it would be more accurate to show the total penalty so you 
can match it to the 1099.  This is the 1st year I have cashed CD early, because 
of the rapid change in rates, so I will find out which way is better myself.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: Stephen 
Sent: Sunday, January 15, 2023 5:54 PM
To: Murugan Muruganandam ; Gyle McCollam 
; gnucash-user@gnucash.org 
Subject: Re: [GNC] Certificate of Deposit Early Withdrawal Penalty Account Entry

Interest is accounted for as income per CD account. The way I ended up doing it 
allows me to see how much interest I have earned by each and all accounts and 
the interest penalty and principal penalties are noted as to which account they 
were applicable but I do not track the penalties account by account (because 
the penalty is for closing the account -- a one time event).

On 1/15/2023 2:59 PM, Murugan Muruganandam wrote:
stephen

one inquisitive question. did you receive any interest on the CD at all earlier 
and if so how did you account it




Saludos Cordiales


Murugan


From: gnucash-user 

 on behalf of Stephen 

Sent: Sunday, January 15, 2023 5:38 PM
To: Gyle McCollam ; 
gnucash-user@gnucash.org 

Subject: Re: [GNC] Certificate of Deposit Early Withdrawal Penalty Account Entry

Thanks to you and Murugan I got this sorted. As usual, over-thought and
over-wrought. Although I'm sure I could show all the changes in one
split entry it was easiest for me to credit the interest 162.89 as one
standalone entry first. Then I could see my way clearly to showing the
two penalty sub-amounts totaling 1529.51. Intuitively I fairly certain I
could have shown the interest earned among the splits all as one entry
but I'm going to quit while I'm ahead. I just didn't want to lose the
detail of the separate penalty amounts nor their total.  Again, many thanks.

On 1/15/2023 11:23 AM, Gyle McCollam wrote:
> I would enter this Murugan suggested. Let's say the balance of the CD
> prior to closing on your books was $300,000.00
>  Using the amounts you have given:
> Debit   Credit
> Asset: Acct moved to$298,633.38  (Closing Balance)
> Income: CD Interest   $162.89
> Exp: Bank: Penalties  $1529.51
> Asset: CD  $300,000.00 (Balance just prior
> to this entry)
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> gmccol...@live.com 
> email
>
> 
> *From:* gnucash-user
> 
>  on behalf of
> Murugan Muruganandam 
> 
> *Sent:* Sunday, January 15, 2023 11:17 AM
> *To:* Stephen 
> ; 
> gnucash-user@gnucash.org
> 
> *Subject:* Re: [GNC] Certificate of Deposit Early Withdrawal Penalty
> Account Entry
> hi Stephen
>
> The entries can be input as follows.  I could not understand where you
> are getting orphans or imbalances  if you can explain it would be easy
>
> Account Dr  Cr  Notes
> Principal   Asst: Bank Account  Asst: CD Account$
> Principal amount
> InterestAsst: Bank Account  Income: CD Interest
> Interest earned + partial month $162.89
> Penalty InterestExp: Bank: PenaltiesIncome: CD
> Interest Total penalty $1.529,51
>
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user
> 
>  on
> behalf of Stephen 
> 
> Sent: Sunday, January 15, 2023 4:30 AM
> To: gnucash-user@gnucash.org 
> 
> Cc: gnucash-user@gnucash.org 
> 
> Subject: [GNC] Certificate of Deposit Early Withdrawal Penalty Account
> Entry
>
> I had a CD that I closed before it matured. The bank applied a penalty
> of 90 days interest at the CD rate. In fact the total penalty was
> figured as the sum of principal penalty of $1,36