[GNC] Last reconciled transactions have an error.
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.
Re: [GNC] Last reconciled transactions have an error.
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] How do I change keybindings for tab switching in GnuCash?
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] How do I change keybindings for tab switching in GnuCash?
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.
Re: [GNC] Can I find transactions into an account that has only one split?
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] Last reconciled transactions have an error.
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?
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] How do I change keybindings for tab switching in GnuCash?
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] How do I change keybindings for tab switching in GnuCash?
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?
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?
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?
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.
[GNC] How to handle charge-back billing with different currencies?
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.
[GNC] Income and GST Statement report is GSTless
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.
Re: [GNC] Income and GST Statement report is GSTless
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.
