Re: [GNC] Income and GST Statement report is GSTless

2023-11-22 Thread AP
On Thu, Nov 23, 2023 at 02:34:52PM +1100, AP wrote:
> What may I have done wrong? Should the descriptions in ...:GST:Purchases match
> the ones in my bank's account (where the money came from)? Or is it something
> else?

I went wrong in not noticing the options button. You need to select the right
accounts for the GST in order for the report to work fully. I think it tries to
pick the right ones by default but with my (sub)account structure it was lost
and needed manual intervention.

Andrew
___
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] Income and GST Statement report is GSTless

2023-11-22 Thread AP
Hi,

Just finished importing all my bills, bank account records and all and
linked them up nicely. So halfway done.

I figured now would be a good time to try figuring out how to do the GST
and tried to run an "Income and GST Statement" but, whilst it presents my
purchases there is nothing in the "Tax on Purchases" column.

The "Sales Tax Table" is filled and my "Accounts Payable" account is filled
with my paid bills and the ...:GST:Purchases account is filled with the GST
paid on purchases.

What may I have done wrong? Should the descriptions in ...:GST:Purchases match
the ones in my bank's account (where the money came from)? Or is it something
else?

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


[GNC] How to handle charge-back billing with different currencies?

2023-11-22 Thread Emir Herrera
Hello everyone!

I'm working with vendors and clients and want to do automatic chargeback,
now, i have no problem with this, the issue is that I'm paying my vendor in
MXN and I'm charging my client in USD, and the bill does not applies
currency exchange, i.e, if I paid $100.00 MXN for a service, the chargeback
entry is generated for $100.00 USD. Can anybody provide any insights about
this? Am I missing something? Should I submit it as a bug?

Greetings and thanks in advance.

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


Re: [GNC] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread Glenn Fowler
R Losey,

For me on my Windows machine when in GnuCash CTRL + TAB moves the focus
across the toolbar but to change tabs it's CTRL + ALT + PAGE UP/DOWN.

For macOS it should be CTRL + OPTION + PAGE UP/DOWN as mentioned in the
wiki: https://wiki.gnucash.org/wiki/Keyboard_Shortcuts

On Wed, Nov 22, 2023 at 5:25 PM R Losey  wrote:

> Really?  Because CTRL-tab in both MacOS and Windows allows one to change
> the activate application...
>
>
> On Wed, Nov 22, 2023 at 12:46 PM Glenn Fowler 
> wrote:
>
>>  Thank you Adrien, the OS is not affecting it in this case.
>>
>> On Wed, Nov 22, 2023 at 12:47 PM Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>
>> > Not certain, maybe someone else has, but have you checked your OS
>> > settings for this combo? That may be overriding your gtk file.
>> >
>> > Regards,
>> > Adrien
>> >
>> > On 11/22/23 10:13 AM, Glenn Fowler wrote:
>> > > I am trying to change keybindings for tab switching in GnuCash which
>> is
>> > > default CTRL + ALT + PAGE UP/DOWN.
>> > >
>> > > It would be nice to change it to a function key or CTRL + TAB. In
>> > > gtk-3.0.css I tried:
>> > >
>> > > @binding-set Switch-Page
>> > > {
>> > >bind "F2" { "change-current-page" (1) };
>> > >bind "F3" { "change-current-page" (-1) };
>> > > }
>> > >
>> > > entry
>> > > {
>> > > -gtk-key-bindings: SwitchPage;
>> > > }
>> > >
>> > > but it doesn't work. The syntax is correct as I can do other
>> keybindings
>> > > for clipboard copy, clipboard paste, move the cursor, etc.
>> > >
>> > > Anyone in the community know how to do this?
>> >
>> > ___
>> > 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.
>>
>
>
> --
> _
> 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] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread Glenn Fowler
Thanks Mark, I did try both with the hyphen and without and unfortunately
it's still not working.

On Wed, Nov 22, 2023 at 4:03 PM Mark  wrote:

> Nov 22, 2023 10:14:49 Glenn Fowler :
>
> > @binding-set Switch-Page
> > {
> >   bind "F2" { "change-current-page" (1) };
> >   bind "F3" { "change-current-page" (-1) };
> > }
> >
> > entry
> > {
> > -gtk-key-bindings: SwitchPage;
> > }
> >
> > but it doesn't work. The syntax is correct as I can do other keybindings
> > for clipboard copy, clipboard paste, move the cursor, etc.
>
> I don't know anything about it, but I see there's Switch-Page one place
> and SwitchPage (without the hyphen) another. Typo?
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread R Losey
Really?  Because CTRL-tab in both MacOS and Windows allows one to change
the activate application...


On Wed, Nov 22, 2023 at 12:46 PM Glenn Fowler  wrote:

>  Thank you Adrien, the OS is not affecting it in this case.
>
> On Wed, Nov 22, 2023 at 12:47 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > Not certain, maybe someone else has, but have you checked your OS
> > settings for this combo? That may be overriding your gtk file.
> >
> > Regards,
> > Adrien
> >
> > On 11/22/23 10:13 AM, Glenn Fowler wrote:
> > > I am trying to change keybindings for tab switching in GnuCash which is
> > > default CTRL + ALT + PAGE UP/DOWN.
> > >
> > > It would be nice to change it to a function key or CTRL + TAB. In
> > > gtk-3.0.css I tried:
> > >
> > > @binding-set Switch-Page
> > > {
> > >bind "F2" { "change-current-page" (1) };
> > >bind "F3" { "change-current-page" (-1) };
> > > }
> > >
> > > entry
> > > {
> > > -gtk-key-bindings: SwitchPage;
> > > }
> > >
> > > but it doesn't work. The syntax is correct as I can do other
> keybindings
> > > for clipboard copy, clipboard paste, move the cursor, etc.
> > >
> > > Anyone in the community know how to do this?
> >
> > ___
> > 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.
>


-- 
_
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] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread Mark via gnucash-user
Nov 22, 2023 10:14:49 Glenn Fowler :

> @binding-set Switch-Page
> {
>   bind "F2" { "change-current-page" (1) };
>   bind "F3" { "change-current-page" (-1) };
> }
>
> entry
> {
> -gtk-key-bindings: SwitchPage;
> }
>
> but it doesn't work. The syntax is correct as I can do other keybindings
> for clipboard copy, clipboard paste, move the cursor, etc.

I don't know anything about it, but I see there's Switch-Page one place and 
SwitchPage (without the hyphen) another. Typo?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread Glenn Fowler
 Thank you Adrien, the OS is not affecting it in this case.

On Wed, Nov 22, 2023 at 12:47 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Not certain, maybe someone else has, but have you checked your OS
> settings for this combo? That may be overriding your gtk file.
>
> Regards,
> Adrien
>
> On 11/22/23 10:13 AM, Glenn Fowler wrote:
> > I am trying to change keybindings for tab switching in GnuCash which is
> > default CTRL + ALT + PAGE UP/DOWN.
> >
> > It would be nice to change it to a function key or CTRL + TAB. In
> > gtk-3.0.css I tried:
> >
> > @binding-set Switch-Page
> > {
> >bind "F2" { "change-current-page" (1) };
> >bind "F3" { "change-current-page" (-1) };
> > }
> >
> > entry
> > {
> > -gtk-key-bindings: SwitchPage;
> > }
> >
> > but it doesn't work. The syntax is correct as I can do other keybindings
> > for clipboard copy, clipboard paste, move the cursor, etc.
> >
> > Anyone in the community know how to do this?
>
> ___
> 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] Can I find transactions into an account that has only one split?

2023-11-22 Thread Adrien Monteleone

Also, please remember to copy the list on all replies.

Regards,
Adrien


On 11/22/23 3:53 AM, David Kirkby wrote:
Unfortunately that's a bit difficult, as a lot of times I buy things 
with PayPal, so there's an entry in the PayPal account where no fees 
need to be paid, as the seller pays the fees, not the buyer. So not 
every transaction in the PayPal account needs 3 splits - most need 2.


___
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] Last reconciled transactions have an error.

2023-11-22 Thread Adrien Monteleone
There is no issue with transactions not being reconciled and having 
later transactions reconciled. What matters is did those transactions 
that are reconciled really clear the bank? Do they explain how you got 
from the opening balance to the ending balance?


That is all reconciliation is doing—answering that question.

Otherwise, as Maf. noted, yes, you can just change their flag as needed 
and re-reconcile as needed.


Regards,
Adrien

On 11/22/23 5:25 AM, David Kirkby wrote:

I have discovered a problem with my accounts. A transaction moved money
from the PayPal account to the Bank account, but this is not recorded in
the bank account. Unfortunately, about a dozen transactions have been
marked as reconciled after this date.

Reconciled on 06/02/23 - I believe they are all okay.
*Transaction on 18/02/2023 - should be recorded but is not. *
Reconciled 23/2/2023
Reconciled 28/2/2023
Reconciled 17/3/2023- last time reconciled.

I'm not sure how this mess happened, but I'm wondering the best way to
resolve it.

Can I simply unreconcile them in this order?

1) 17/3/2023,
2)  28/2/2023
3)  23/2/2023

To my knowledge, this is the first time I have managed to reconcile
transactions that should not have been, but that's the state I'm in.

Retrieving a backup is possible, but I have done a lot of work on
reconciling the PayPal account and picking up a couple of errors on PayPal
transactions, so I'd rather not use an earlier backup if possible. But if
that's the safest way, maybe I should.



___
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] Can I find transactions into an account that has only one split?

2023-11-22 Thread Adrien Monteleone
Then I'm at a loss as even with a well crafted Find operation, or using 
the Transaction Report as Chris suggested, you can't end up with a list 
that doesn't include transactions where no fee was paid by you. Only 
*you* know if a split needs to be added for that fee. How do you expect 
GnuCash to magically know?


At best, you can find/report all transactions that have a split 
involving the PayPal asset account that don't also involve the Fee 
expense account. (which is what you initially asked for)


If this is strictly a case of items you are selling (not buying) then 
further restrict your Find results or Report to filter on Debits only to 
the PayPal asset account. (A Find can do this, not certain of reports) 
Any Credits to that account should be when you spend rather than 
receive. (assuming you entered all transactions correctly)


If the Report path is the easiest or only method that works, and you 
can't filter out Credits to that asset account, you should at least be 
able to sort by debit/credit, or in an absolute worst case, show the 
debits and credits splits individually and then you can go over it with 
a fine comb to pick out which transactions to adjust.


Regards,
Adrien

On 11/22/23 3:53 AM, David Kirkby wrote:

Unfortunately that's a bit difficult, as a lot of times I buy things with 
PayPal, so there's an entry in the PayPal account where no fees need to be 
paid, as the seller pays the fees, not the buyer. So not every transaction in 
the PayPal account needs 3 splits - most need 2.


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


Re: [GNC] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread Adrien Monteleone
Not certain, maybe someone else has, but have you checked your OS 
settings for this combo? That may be overriding your gtk file.


Regards,
Adrien

On 11/22/23 10:13 AM, Glenn Fowler wrote:

I am trying to change keybindings for tab switching in GnuCash which is
default CTRL + ALT + PAGE UP/DOWN.

It would be nice to change it to a function key or CTRL + TAB. In
gtk-3.0.css I tried:

@binding-set Switch-Page
{
   bind "F2" { "change-current-page" (1) };
   bind "F3" { "change-current-page" (-1) };
}

entry
{
-gtk-key-bindings: SwitchPage;
}

but it doesn't work. The syntax is correct as I can do other keybindings
for clipboard copy, clipboard paste, move the cursor, etc.

Anyone in the community know how to do this?


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


[GNC] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread Glenn Fowler
Hi,

I am trying to change keybindings for tab switching in GnuCash which is
default CTRL + ALT + PAGE UP/DOWN.

It would be nice to change it to a function key or CTRL + TAB. In
gtk-3.0.css I tried:

@binding-set Switch-Page
{
  bind "F2" { "change-current-page" (1) };
  bind "F3" { "change-current-page" (-1) };
}

entry
{
-gtk-key-bindings: SwitchPage;
}

but it doesn't work. The syntax is correct as I can do other keybindings
for clipboard copy, clipboard paste, move the cursor, etc.

Anyone in the community know how to do this?

Thanks!
___
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] Last reconciled transactions have an error.

2023-11-22 Thread Maf. King
On Wednesday, 22 November 2023 11:25:16 GMT David Kirkby wrote:
>
> 
> Can I simply unreconcile them in this order?
> 
> 1) 17/3/2023,
> 2)  28/2/2023
> 3)  23/2/2023
> 

Yes.  just unreconcile back to the known good date and work forwards again.  I 
don't foresee any harm to your records (and a lot less work than 6 months 
carching up from a backup)

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.


[GNC] Last reconciled transactions have an error.

2023-11-22 Thread David Kirkby
I have discovered a problem with my accounts. A transaction moved money
from the PayPal account to the Bank account, but this is not recorded in
the bank account. Unfortunately, about a dozen transactions have been
marked as reconciled after this date.

Reconciled on 06/02/23 - I believe they are all okay.
*Transaction on 18/02/2023 - should be recorded but is not. *
Reconciled 23/2/2023
Reconciled 28/2/2023
Reconciled 17/3/2023- last time reconciled.

I'm not sure how this mess happened, but I'm wondering the best way to
resolve it.

Can I simply unreconcile them in this order?

1) 17/3/2023,
2)  28/2/2023
3)  23/2/2023

To my knowledge, this is the first time I have managed to reconcile
transactions that should not have been, but that's the state I'm in.

Retrieving a backup is possible, but I have done a lot of work on
reconciling the PayPal account and picking up a couple of errors on PayPal
transactions, so I'd rather not use an earlier backup if possible. But if
that's the safest way, maybe I should.

-- 
Dr David Kirkby Ph.D
Kirkby Microwave Ltd
Email: drkir...@kirkbymicrowave.co.uk
Web: https://www.kirkbymicrowave.co.uk/
Telephone 07910 441670 (UK) or +44 7910 441670 (international)
Registered in England and Wales, company number 08914892.
Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3 6DT
___
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.