[GNC] Reconciliation Roll Back
Dear GNU Cash Users A year ago I re-started an account from 6th April in GNU Cash as my previous imports from Quicken were not working as I would have wished. It was a lot of work to re enter 3 months of transactions but the clean start has been excellent and every month the bank reconciiation has been perfect. This month it is out by more than £20K. The reason I suspect is that the opening balance that it picked up seemed way too high but I know of no way to make sure that the opening balance is the correct one. Additionally I noticed that a good handful of transactions that were reconciled in last months task now showed up as unreconciled. I am at a loss as to how to rescure this problem. What would be nice would be to be able to 'roll back' the erroneous reconciliation and probably the previous one and then begin again. Unless, of course you know a better way to get out of this hole. Regards Pete C Dr Peter Cuthbert Creuddyn Coedlan Y Plas Llangawsai Aberystwyth Sir Ceredigion SY23 1HJ 01970 623 447 ___ 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] Reconciliation Roll Back
On Tue, 28 May 2024 09:49:05 +0100 (BST) Peter Cuthbert via gnucash-user wrote: > Dear GNU Cash Users > > A year ago I re-started an account from 6th April in GNU Cash as my > previous imports from Quicken were not working as I would have > wished. It was a lot of work to re enter 3 months of transactions but > the clean start has been excellent and every month the bank > reconciiation has been perfect. This month it is out by more than > £20K. The reason I suspect is that the opening balance that it > picked up seemed way too high but I know of no way to make sure that > the opening balance is the correct one. Additionally I noticed that a > good handful of transactions that were reconciled in last months task > now showed up as unreconciled. > I am at a loss as to how to rescure this problem. What would be nice > would be to be able to 'roll back' the erroneous reconciliation and > probably the previous one and then begin again. Unless, of course > you know a better way to get out of this hole. > > Regards > > Pete C 1. make a copy of your data file. 2. Play with the copy. 3. Ensure you are not working with a backup file. 4. Try reconciling the account as it is. Mark as reconciled all the things you know were reconciled in the past and see if that improves the situation. 5. Wait for more advice 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.
Re: [GNC] Reconciliation Roll Back
On Tuesday, 28 May 2024 09:49:05 BST Peter Cuthbert via gnucash-user wrote: > The reason I suspect > is that the opening balance that it picked up seemed way too high but I > know of no way to make sure that the opening balance is the correct one. Only by visual inspection - if you completed the reconcile of last month's statement, then the reconciled balance in GC should match the end balance of that statement which should match the opening balance of the current statement which should match what GC suggests as the starting balance. If the opening balances don't match but the previous reconciled balances did then something slightly odd has happened. Maybe you inadvertently modified some reconciled txns and they lost their "reconcied" status. maybe you accidently started using a backup file at some point (look for lots of numbers in the filename) > Additionally I noticed that a good handful of transactions that were > reconciled in last months task now showed up as unreconciled. That would certainly throw off the starting balance. > > I am at a loss as to how to rescure this problem. What would be nice > would be to be able to 'roll back' the erroneous reconciliation and > probably the previous one and then begin again. Unless, of course you > > know a better way to get out of this hole. Try a reconcile to the new statement ending balance - ignore the "start". Also look at the unreconciled transactions from previous months - if they all check off OK and you hit the new statement end balance then you are good to go. If you really want to roll back the previous reconciles, then you can only do that manually by clicking on each of the "Y" in the reconciled transactions status. As always, take a back-up copey of the file before you start digging and maybe get in a worse mess! HTH, 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] do not know how to show 2 x taxes on an item in invoice
Trying to print both PST and GST separately on an invoice Thanks Peter Klassen peita...@gmail.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.
Re: [GNC] do not know how to show 2 x taxes on an item in invoice
Send them into different Accounts for tax collection. Then when you print, you can tell it to separate out the taxes. -derek On Tue, May 28, 2024 9:42 am, Peter Klassen wrote: > Trying to print both PST and GST separately on an invoice > > Thanks > > Peter Klassen > peita...@gmail.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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Reconciliation Roll Back
A tidbit of information that you may find helpful: If you hover the mouse over the "y" character in the reconcile box in an account split line, the date of the reconciliation for that account split in that transaction appears in a flyover. It may take a couple of seconds to appear. Another tidbit: Transactions with multiple accounts or splits reconcile separately for each account, but sometimes editing, unreconciling or deleting in one account can change a reconciliation for another account in that transaction. That isn't supposed to happen but sometimes it does with unusual editing methods, especially if the account name is changed for a reconciled account line. On Tue, May 28, 2024 at 5:21 AM Maf. King wrote: > On Tuesday, 28 May 2024 09:49:05 BST Peter Cuthbert via gnucash-user wrote: > > > The reason I suspect > > is that the opening balance that it picked up seemed way too high but I > > know of no way to make sure that the opening balance is the correct one. > > Only by visual inspection - if you completed the reconcile of last month's > statement, then the reconciled balance in GC should match the end balance > of > that statement which should match the opening balance of the current > statement which should match what GC suggests as the starting balance. > > If the opening balances don't match but the previous reconciled balances > did > then something slightly odd has happened. Maybe you inadvertently > modified > some reconciled txns and they lost their "reconcied" status. maybe you > accidently started using a backup file at some point (look for lots of > numbers > in the filename) > > > > Additionally I noticed that a good handful of transactions that were > > reconciled in last months task now showed up as unreconciled. > > That would certainly throw off the starting balance. > > > > > I am at a loss as to how to rescure this problem. What would be nice > > would be to be able to 'roll back' the erroneous reconciliation and > > probably the previous one and then begin again. Unless, of course you > > > know a better way to get out of this hole. > > Try a reconcile to the new statement ending balance - ignore the "start". > Also look at the unreconciled transactions from previous months - if they > all > check off OK and you hit the new statement end balance then you are good > to > go. > > If you really want to roll back the previous reconciles, then you can only > do > that manually by clicking on each of the "Y" in the reconciled > transactions > status. > > As always, take a back-up copey of the file before you start digging and > maybe > get in a worse mess! > > HTH, > 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. > -- David Carlson ___ 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] thanks for the quick answer. I have created separate accounts for PST and GST as liability subaccounts but when I go to assign the tax table I have to use the item value each time. This look
Hi Peter, First, please be sure to CC gnucash-user on all replies. Second, It helps to put your question into the email, not in the subject. It SOUNDS like you created two TaxTables (one for PST and one for GST) and then made two Invoice line-items, one with each tax table. Instead, you need to create a single tax-table with BOTH PST and GST, and then apply that to a single line-item in the invoice. Please try again. Thanks, -derek. On Tue, May 28, 2024 10:01 am, Peter Klassen wrote: > Peter Klassen > peita...@gmail.com > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] (no subject)
Hi Derek Once again your response was excellent. I have a combined tax table but how do I split the tax to show separately at the end of the invoice for all the items. pardon my ignorance. Peter Klassen peita...@gmail.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.
Re: [GNC] PST and GST Tax Tables
Hi, On Tue, May 28, 2024 10:57 am, Peter Klassen wrote: > Hi Derek > > Once again your response was excellent. I have a combined tax table but > how > do I split the tax to show separately at the end of the invoice for all > the > items. > pardon my ignorance. Make sure in the tax table that PST and GST get assigned into DIFFERENT accounts. Then when you print the invoice, go into the invoice options and select the option to show individual taxes. The exact option you use will depend on which Invoice report you use. > > Peter Klassen > peita...@gmail.com > -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Reconciliation Roll Back (Peter Cuthbert)
I find this has been a longstanding problem. Every once in a while, old transactions get unreconciled. I always open GC the same way so I'm sure I'm not opening backups. Blake Hannaford -- ___ 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] Reconciliation Roll Back (Peter Cuthbert)
Generally, I find that transactions ONLY get dereconciled due to an action I have taken-- like changing some element of said transaction. They don't just "get unreconciled"-- at least, not for me. There was a short period of time where the app was very strict about when a transaction was dereconciled, but that change was modified after user feedback. I believe that recent versions only dereconcile a transaction when you modify a material detail, like the amount or the date. If you are having this as a longstanding problem, it would be useful to everyone to figure out what is going on, so that the problem can be addressed-- regardless of where the problem lies. Dereconciling transactions is not a minor matter when it comes to accounting software. David T. On May 28, 2024, 8:51 PM, at 8:51 PM, Blake Hannaford wrote: >I find this has been a longstanding problem. Every once in a while, >old >transactions get unreconciled. I always open GC the same way so I'm >sure >I'm not opening backups. > >Blake Hannaford > >-- >___ >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] Running balance/total from search results is always $0.00
I'd like the sum of the values from entries with certain criteria in the "Memo" field in an expense account. I can get the list of transactions containing these entries by searching the Memo field. Then, everything I found says I can open a Report > Account Report to get the running balance/total, however that column always remains $0.00 for me. I wonder if this has to due with the double-entry bookkeeping I'm using? The display is also complicated by the fact that these transactions can include 3 or 4 different expenses which means instead of just 2 lines for funds in/funds out, there could be 8 lines for funds in/out of 4 different accounts, all of which are shown in the Account Report, yet I'm only interested in the values from the one account I performed the initial search from. Using Gnucash 5.6 ___ 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.
