Re: [GNC] Bank reconciliation after messy migration
This, with one minor change - If you're happy that everything is 100% just reconcile up to your latest statement closing balance and date. Ignore the Gnucash generated starting balance because when all said and done it's all about the final closing balance. Cheers David H. On Sat, 7 Jan 2023 at 04:59, Fred Tydeman wrote: > Here is a fast way to Reconcile everything (not what you asked for, but it > might help) > > Reconcile > "t" in Statement date == Today > Left click OK > Ctrl-A == Select All items in Funds In column > Space == Mark as Reconciled > Tab == Move to Funds Out column > Ctrl-A == Select All items in Funds Out column > Space == Mark as Reconciled > Left click Finish > > On Fri, Jan 6, 2023 at 10:08 AM Eric Hammond wrote: > > > > > I have finally completed replacing Quicken with GnuCash. > > One of the casualties is my ability to reconcile my bank account. > > The account covers from 2014 to present, and matches all bank statements > > and balances properly. > > The reconciliation function opens but starts at some random date and > > incorrect beginning balance. > > Is there a way to reset the reconciliation to all unreconciled and start > > fresh? > > > > Alternatively, can I repair this using NotePad++? Which entries need to > > be changed, and which ones should not be messed with? > > (I am fine with a bit of slow tedious work) > > > > Thanks for all help, > > Eric H. > > ___ > > 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] Bank reconciliation after messy migration
There isn't an easy way to unreconcile many transactions, but because reconciliation dates aren't very easy to see or care about once they get old, many users will ignore starting dates and balances if they know that there is a reason that they don't match the bank statement this month. One point to keep in mind is that reconciliations are only concerning the split lines involving that account, so, if for example there are transactions that involve both a bank account and a credit card account, ignore the 'other' side during the reconciliation. Those transactions may have dates that don't match both sides. On Fri, Jan 6, 2023, 12:08 PM Eric Hammond wrote: > > I have finally completed replacing Quicken with GnuCash. > One of the casualties is my ability to reconcile my bank account. > The account covers from 2014 to present, and matches all bank statements > and balances properly. > The reconciliation function opens but starts at some random date and > incorrect beginning balance. > Is there a way to reset the reconciliation to all unreconciled and start > fresh? > > Alternatively, can I repair this using NotePad++? Which entries need to > be changed, and which ones should not be messed with? > (I am fine with a bit of slow tedious work) > > Thanks for all help, > Eric H. > ___ > 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] Bank reconciliation after messy migration
Here is a fast way to Reconcile everything (not what you asked for, but it might help) Reconcile "t" in Statement date == Today Left click OK Ctrl-A == Select All items in Funds In column Space == Mark as Reconciled Tab == Move to Funds Out column Ctrl-A == Select All items in Funds Out column Space == Mark as Reconciled Left click Finish On Fri, Jan 6, 2023 at 10:08 AM Eric Hammond wrote: > > I have finally completed replacing Quicken with GnuCash. > One of the casualties is my ability to reconcile my bank account. > The account covers from 2014 to present, and matches all bank statements > and balances properly. > The reconciliation function opens but starts at some random date and > incorrect beginning balance. > Is there a way to reset the reconciliation to all unreconciled and start > fresh? > > Alternatively, can I repair this using NotePad++? Which entries need to > be changed, and which ones should not be messed with? > (I am fine with a bit of slow tedious work) > > Thanks for all help, > Eric H. > ___ > 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] Bank reconciliation after messy migration
I have finally completed replacing Quicken with GnuCash. One of the casualties is my ability to reconcile my bank account. The account covers from 2014 to present, and matches all bank statements and balances properly. The reconciliation function opens but starts at some random date and incorrect beginning balance. Is there a way to reset the reconciliation to all unreconciled and start fresh? Alternatively, can I repair this using NotePad++? Which entries need to be changed, and which ones should not be messed with? (I am fine with a bit of slow tedious work) Thanks for all help, Eric H. ___ 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] Bank Reconciliation Report with Beginning and Ending Balances
Thanks all for the replies. Many many good ideas. Personally, I think doing it with each bank statement as soon as received, with the relevant dates entered, is the most foolproof, if boring, way to see what is happening. Afaik, it is the best way to keep track of 'finger problems' putting stuff in the wrong place, wrong amount, etc., etc. Barry On 11/01/2019 20:18, Mark Phillips wrote: Kate, Are you trying to reconcile your account? If so, then select your account tab and go to Actions -> Reconcile for an interactive account reconciliation process for your account. If you want a report post-reconciliation of your account, I normally use Reports -> Transactions, then use the report configuration options to define what I want in the report. Sorry to be shooting in the dark for your answer. Your images did not come through. Mark On Fri, Jan 11, 2019 at 12:11 PM eNews wrote: I have run the reconciliation report for my checking account; however, it only shows the "funds in" and the "funds out" for the period. I was hoping for a more traditional reconciliation that shows the ending balance that I can agree to my bank statement. If this can be done, how do I do it? [I am using Windows 10 Home, Version 1803; GnuCash Version 3.2, Build ID: 3.2+ (2018-06-24)] My comments are marked as: I searched for an existing string of comments on this matter and did not find any. If it has already been discussed, perhaps you could explain how I could find it on my own. Thank you, Kate --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Bank Reconciliation Report with Beginning and Ending Balances
Kate, I did see the images, so I understand what you are looking for, but I can’t seem to make the report produce anything similar. Here are your options: 1. The reconciliation tool provides this info at the bottom right, along with the variance of what has been reconciled to what should be reconciled. (indicating transactions left to reconcile, or an adjusting entry needs to be made) Note that you can leave that window open as long as you like. You don’t have to complete the reconciliation in one go. 2. Run the reconciliation report, and either export or copy/paste to a spreadsheet and add the formulas for the additional calculations you want to see. If you really need a piece of paper with this info, this is the only route. But if that isn’t important, the reconciliation tool is the better option. With regard to searching the mailing list archives, prefix your search terms with “site:lists.gnucash.org ” (without the quotes) and most search engines will limit your search to that domain rather than the entire internet. Some search engines like DuckDuckGo have shorthand versions of the “site:” part. (which is pretty short already) For this example, keep your query simple and then narrow down as needed. I’d start with “site:lists.gnucash.org reconciliation”. Regards, Adrien > On Jan 11, 2019, at 1:11 PM, eNews wrote: > > I have run the reconciliation report for my checking account; however, it > only shows the "funds in" and the "funds out" for the period. I was hoping > for a more traditional reconciliation that shows the ending balance that I > can agree to my bank statement. If this can be done, how do I do it? [I am > using Windows 10 Home, Version 1803; GnuCash Version 3.2, Build ID: 3.2+ > (2018-06-24)] > > > > My comments are marked as: > > > > > > > > > > I searched for an existing string of comments on this matter and did not > find any. If it has already been discussed, perhaps you could explain how I > could find it on my own. > > > > Thank you, > > Kate > > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Bank Reconciliation Report with Beginning and Ending Balances
Kate, Are you trying to reconcile your account? If so, then select your account tab and go to Actions -> Reconcile for an interactive account reconciliation process for your account. If you want a report post-reconciliation of your account, I normally use Reports -> Transactions, then use the report configuration options to define what I want in the report. Sorry to be shooting in the dark for your answer. Your images did not come through. Mark On Fri, Jan 11, 2019 at 12:11 PM eNews wrote: > I have run the reconciliation report for my checking account; however, it > only shows the "funds in" and the "funds out" for the period. I was hoping > for a more traditional reconciliation that shows the ending balance that I > can agree to my bank statement. If this can be done, how do I do it? [I am > using Windows 10 Home, Version 1803; GnuCash Version 3.2, Build ID: 3.2+ > (2018-06-24)] > > > > My comments are marked as: > > > > > > > > > > I searched for an existing string of comments on this matter and did not > find any. If it has already been discussed, perhaps you could explain how > I > could find it on my own. > > > > Thank you, > > Kate > > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Bank Reconciliation Report with Beginning and Ending Balances
I have run the reconciliation report for my checking account; however, it only shows the "funds in" and the "funds out" for the period. I was hoping for a more traditional reconciliation that shows the ending balance that I can agree to my bank statement. If this can be done, how do I do it? [I am using Windows 10 Home, Version 1803; GnuCash Version 3.2, Build ID: 3.2+ (2018-06-24)] My comments are marked as: I searched for an existing string of comments on this matter and did not find any. If it has already been discussed, perhaps you could explain how I could find it on my own. Thank you, Kate --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus image006.emz Description: Binary data image008.emz Description: Binary data image010.emz Description: Binary data image012.emz Description: Binary data ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Bank reconciliation question
It should be no problem at all. Just record the original transactions you already have recorded against something like a miscellaneous expenses account. Add notes to the description that they were direct debits in error. The refunds should also appear in your OFX records so just load then and use the same miscellaneous expense account to record the refund against. Attach notes in the Description field referencing the orignal incorrect transactions in error so that your auditors will be happy. Reconciliation should be no problem as your bank statements should have both the original debits to the account(credits in your books) and the credits (debits in your books) to the account so they should reconcile against your account as normal. When you prepare the financial statements, you could put in an explanatory note, referencing the transactions in error. Transactions hould appear something like Original transaction: debit credit Asset: Bank Expenses:Miscellaneous corresponding Refund Asset: Bank Expense: Miscellaneous You may need to consult any local legislation which governs your association and its recording of financial matters or your auditors. As long as the explanation is clear and references any external documentation/correspondence from your bank, your auditors should be happy. Note that you can also create links from transactions to associated documents. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Bank reconciliation question
On 24 January 2018 at 10:31, David Goodenough < david.goodeno...@linkchoose.co.uk> wrote: > A community association for which I am treasurer for recently had someone > succeed in > getting our bank to open a Direct Debit on our account without our > authorisation. > They took 4 payments before we noticed, and now the DD has been cancelled > and the > money refunded. We use GnuCash to manage the association's money. > > How do we reconcile this? I know how to reconcile a pay transaction > against an > invoice, but here I need to reconcile four payments for which there are no > invoices > against one receipt. We have already imported the OFX file with the four > payments in > it (which is when we noticed them), and will shortly import a subsequent > one with the > re-payment in it. > You could just enter them (and the refund) against one of your expense accounts, expense:miscellaneous or whatever you put small items against, or invent a new expense acct Expenses:BankErrors or something. Since it will go out and then back in again it will have no effect on the end result. Colin > > Thank you > > David > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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.
Bank reconciliation question
A community association for which I am treasurer for recently had someone succeed in getting our bank to open a Direct Debit on our account without our authorisation. They took 4 payments before we noticed, and now the DD has been cancelled and the money refunded. We use GnuCash to manage the association's money. How do we reconcile this? I know how to reconcile a pay transaction against an invoice, but here I need to reconcile four payments for which there are no invoices against one receipt. We have already imported the OFX file with the four payments in it (which is when we noticed them), and will shortly import a subsequent one with the re-payment in it. Thank you David ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Bank reconciliation
On 11/13/2017 1:14 PM, Cam Ellison wrote: On 13/11/17 09:45 AM, David Goodenough wrote: Does no-one else have this problem? I have dealt with this by setting up a separate Asset account for receiving payments, similar to what you have. When a payment is received, it goes into this "Payment" account, and then when the bank deposit is made the appropriate amount is debited from the Payment account. This process adds a step between receipt of the cheque (thus acknowledging the invoice as paid) and depositing it. Not JUST acknowledging as paid. The customer is NOT responsible for your delay in depositing a check. Nor does any government I know of consider the date you received money to be the date you got around to depositing it << the LEGAL date might in fact be the date of "constructive delivery" which is why the postmark on a mailed payment might be important >> The common name for an account of this sort is "undeposited cash". Especially if you normally are depositing several payments/checks at one time you might prefer to always have them first go to "undeposited cash" (each can be split on the other side as needed) and then the deposit transaction itself is simple/clean/uncluttered. BTW , another account of this sort often used by businesses is "suspense". Say you receive a check but there is uncertainty what it is for, the correctness of the amount, etc. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Bank reconciliation
That’s what I use as well. I think the usual terminology is Assets:Current Assets:Undeposited Funds. Some people also call this the ‘check clearing’ account though 'Undeposited Funds' is more generalized and could include cash. A business which maintains a ‘Petty Cash’ account and otherwise deposits everything else would use this to ‘hold’ funds until that deposit is made. This way you never co-mingle physical cash with Petty Cash and you can easily audit your payment receipts vs. deposits. Regards, Adrien > On Nov 13, 2017, at 12:14 PM, Cam Ellison wrote: > > On 13/11/17 09:45 AM, David Goodenough wrote: >> Does no-one else have this problem? >> >> When we try to split the transaction in the imbalance account to allocate >> the payment to >> invoices we notice that it almost lets us add one split, but it does not >> automatically >> decrement the amount allocated to the imbalance account and so try to end up >> with an >> unbalanced split. It will also only allow us to allocate one payment (after >> we have made >> the split balance), there is still an amount in the imbalance account which >> we can not >> allocate to another payment. >> >> > I have dealt with this by setting up a separate Asset account for receiving > payments, similar to what you have. When a payment is received, it goes into > this "Payment" account, and then when the bank deposit is made the > appropriate amount is debited from the Payment account. This process adds a > step between receipt of the cheque (thus acknowledging the invoice as paid) > and depositing it. In effect, it is a buffer. It works whether the invoice is > paid in full or only in part. No need to do any splits, which is where things > seem to go south for you. > > Cheers > > Cam > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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: Bank reconciliation
The importer cannot manage multiple split transactions, so it does the only thing it can--it puts the entry to imbalance. Once there,the imbalance split is just another split to Gnucash, so subsequent adjustments have to address the imbalance split. To add correct info to such a transaction, I put in the corrected splits , which creates a new imbalance split, and then I clear the imbalance split in the transaction. I always preferred to correct the imported transaction in this way, rather than create phantom accounts. The imbalance transactions helped to remind me to check things after an import. "Trust but verify," as some people say! David On November 13, 2017, at 11:15 PM, Cam Ellison wrote: On 13/11/17 09:45 AM, David Goodenough wrote: > Does no-one else have this problem? > > When we try to split the transaction in the imbalance account to allocate the > payment to > invoices we notice that it almost lets us add one split, but it does not > automatically > decrement the amount allocated to the imbalance account and so try to end up > with an > unbalanced split. It will also only allow us to allocate one payment (after > we have made > the split balance), there is still an amount in the imbalance account which > we can not > allocate to another payment. > > I have dealt with this by setting up a separate Asset account for receiving payments, similar to what you have. When a payment is received, it goes into this "Payment" account, and then when the bank deposit is made the appropriate amount is debited from the Payment account. This process adds a step between receipt of the cheque (thus acknowledging the invoice as paid) and depositing it. In effect, it is a buffer. It works whether the invoice is paid in full or only in part. No need to do any splits, which is where things seem to go south for you. Cheers Cam ___ gnucash-user mailing list gnucash-user@gnucash.org 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 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: Bank reconciliation
On 13/11/17 09:45 AM, David Goodenough wrote: Does no-one else have this problem? When we try to split the transaction in the imbalance account to allocate the payment to invoices we notice that it almost lets us add one split, but it does not automatically decrement the amount allocated to the imbalance account and so try to end up with an unbalanced split. It will also only allow us to allocate one payment (after we have made the split balance), there is still an amount in the imbalance account which we can not allocate to another payment. I have dealt with this by setting up a separate Asset account for receiving payments, similar to what you have. When a payment is received, it goes into this "Payment" account, and then when the bank deposit is made the appropriate amount is debited from the Payment account. This process adds a step between receipt of the cheque (thus acknowledging the invoice as paid) and depositing it. In effect, it is a buffer. It works whether the invoice is paid in full or only in part. No need to do any splits, which is where things seem to go south for you. Cheers Cam ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Bank reconciliation
Does no-one else have this problem? When we try to split the transaction in the imbalance account to allocate the payment to invoices we notice that it almost lets us add one split, but it does not automatically decrement the amount allocated to the imbalance account and so try to end up with an unbalanced split. It will also only allow us to allocate one payment (after we have made the split balance), there is still an amount in the imbalance account which we can not allocate to another payment. David On Thursday, 9 November 2017 14:54:06 GMT David Goodenough wrote: > I imported transactions from my bank using "import ofx" which has > populated an account called "Imbalance-GBP" with various transactions. > > One of the transactions represents paying in three cheques we had > received as payments for ads from three different customers which the > bank lumped together as one transaction. > > From googling I had come to the conclusion that I should set up a temporary > holding account (Account type: Asset), have that transaction pay into said > account and then make three different transactions to Assets:Checking > Account and use them to pay the invoices. However, when I (using the right > click menu option while viewing all transactions in said holding account) > assigned these > transactions as payments for the invoices the transaction was moved to > Accounts Receivable automatically and moving it back (by editing the > other end of the transaction in Assets:Checking Account) causes the > invoices to become unpaid. > > Clearly I am doing something wrong, quite possibly by not even using the > right solution to begin with and I don't think banging my head against > the problem/google any more will be productive, what should I do? > > In short, what is the proper way to handle the case where a single paying-in > transaction needs to be reconciled against several invoices for multiple > customers? > > We try to encourage people to pay electronically, then none of this happens, > and in future if we can not find a solution to this we will ensure that > cheques are paid in individually, but we need to handle these historic > transactions. > > David > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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.
Bank reconciliation
I imported transactions from my bank using "import ofx" which has populated an account called "Imbalance-GBP" with various transactions. One of the transactions represents paying in three cheques we had received as payments for ads from three different customers which the bank lumped together as one transaction. >From googling I had come to the conclusion that I should set up a temporary >holding account (Account type: Asset), have that transaction pay into said account and then make three different transactions to Assets:Checking Account and use them to pay the invoices. However, when I (using the right click menu option while viewing all transactions in said holding account) assigned these transactions as payments for the invoices the transaction was moved to Accounts Receivable automatically and moving it back (by editing the other end of the transaction in Assets:Checking Account) causes the invoices to become unpaid. Clearly I am doing something wrong, quite possibly by not even using the right solution to begin with and I don't think banging my head against the problem/google any more will be productive, what should I do? In short, what is the proper way to handle the case where a single paying-in transaction needs to be reconciled against several invoices for multiple customers? We try to encourage people to pay electronically, then none of this happens, and in future if we can not find a solution to this we will ensure that cheques are paid in individually, but we need to handle these historic transactions. David ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Bank reconciliation history
> Am going to look at writing some SQL to pull this out of the GNU cash database You will be looking for the "reconcile_date" column on the "splits" table. I use PostgreSQL and I'm curious to hear about any fancy SQL you come up with! Wiliam ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Bank reconciliation history
Thanks everyone with you help with this. Am going to look at writing some SQL to pull this out of the GNU cash database (I happen to be a SQL developer). Mark roworthrowor...@yahoo.co.uk07870 575707 From: Christopher Lam To: Mark Roworth Cc: "gnucash-user@gnucash.org" Sent: Monday, 30 October 2017, 13:27 Subject: Re: Bank reconciliation history Don't think this information is stored in the database. I think the closest approach is use Transaction Report, enable Display/Reconciled Date, set Sorting/Primary Key to Reconciled date, Sorting/Secondary Key to None. But I don't think the 'reconciled balance at reconciliation date' is ever stored. Interestingly from the account register, there's View/Sort By... "Statement Date" which doesn't seem to do what the tooltip says. On 30 October 2017 at 18:00, Mark Roworth via gnucash-user wrote: Hi all, Is there anyway I can see a list of bank statements and which transactions were reconciled to which statements? For the life of me I can't find it? Thanks for any help received, Mark Mark roworthrowor...@yahoo.co.uk __ _ gnucash-user mailing list gnucash-user@gnucash.org 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 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: Bank reconciliation history
If you open the GNucash account that you use to record your bank transactions, there is a "Reconciled" indicator. By default it is set to 'N'. If you click this it will change to "C", and when you complete the reconciliation this indicator is changed to "Y". When I reconcile my GN account, I click on this indicator as I check items off on my bank statement, and when I get to the end of the period I click "Reconcile" and confirm everything in the display is checked. Any discrepancy is easily seen and can be investigated further. Not sure if you might be able to include this column in a transaction report though. Hope this helps! Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Tue, Oct 31, 2017 at 2:08 AM, Derek Atkins wrote: > Hi, > > Mark Roworth via gnucash-user writes: > > > Hi all, > > Is there anyway I can see a list of bank statements and which > > transactions were reconciled to which statements? For the life of me I > > can't find it? > > Thanks for any help received, > > Even though the reconcile date is stored, there is currently no report > that will show/access that data. > > > Mark > > Mark roworthrowor...@yahoo.co.uk > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > -- >Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory >Member, MIT Student Information Processing Board (SIPB) >URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH >warl...@mit.eduPGP key available > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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: Bank reconciliation history
Hi, Mark Roworth via gnucash-user writes: > Hi all, > Is there anyway I can see a list of bank statements and which > transactions were reconciled to which statements? For the life of me I > can't find it? > Thanks for any help received, Even though the reconcile date is stored, there is currently no report that will show/access that data. > Mark > Mark roworthrowor...@yahoo.co.uk > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Bank reconciliation history
Mark, The simple answer is “No.” There isn’t any way from the GnuCash application to see which transactions were reconciled on which statements. I believe that the GnuCash data file does store reconcile information in the data file, but that information is not exposed in the GUI. You might be able to save your data in SQL format and then open your data in an SQL tool that would allow you to create an SQL query to extract this information. But that is not for the faint of heart. HTH, David > On Oct 30, 2017, at 3:00 PM, Mark Roworth via gnucash-user > wrote: > > Hi all, > Is there anyway I can see a list of bank statements and which transactions > were reconciled to which statements? For the life of me I can't find it? > Thanks for any help received, > Mark > Mark roworthrowor...@yahoo.co.uk > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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: Bank reconciliation history
Don't think this information is stored in the database. I think the closest approach is use Transaction Report, enable Display/Reconciled Date, set Sorting/Primary Key to Reconciled date, Sorting/Secondary Key to None. But I don't think the 'reconciled balance at reconciliation date' is ever stored. Interestingly from the account register, there's View/Sort By... "Statement Date" which doesn't seem to do what the tooltip says. On 30 October 2017 at 18:00, Mark Roworth via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi all, > Is there anyway I can see a list of bank statements and which transactions > were reconciled to which statements? For the life of me I can't find it? > Thanks for any help received, > Mark > Mark roworthrowor...@yahoo.co.uk > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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.
Bank reconciliation history
Hi all, Is there anyway I can see a list of bank statements and which transactions were reconciled to which statements? For the life of me I can't find it? Thanks for any help received, Mark Mark roworthrowor...@yahoo.co.uk ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
