Re: [GNC] Reconciliation

2019-11-21 Thread David Cousens via gnucash-user
Jack, David I haven't had to do this for quite a while but to do it you need the complete set of contiguous statements. For the purposes of description lets assume my last reconciled statement was to the 20/06/2019 and I am reconciling the period 21/06/2019 until 20/07/2019 ( date format

Re: [GNC] Reconciliation

2019-11-21 Thread Jack Lockard
So I figured out what was going on. I have two sub-accounts to my checking account. I use them as faux savings accounts for my mortgage payment and a credit card payment. I use these two sub-accounts as follows: 1. My social security comes in mid-month so I transfer the mortgage

Re: [GNC] [Q]W2 Form

2019-11-21 Thread John Ralls
> On Nov 21, 2019, at 2:40 PM, ceandyek laedon via gnucash-user > wrote: > > Can we use gnucash to generate W2 Form? > No. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

Re: [GNC] Reconciliation

2019-11-21 Thread David Cousens via gnucash-user
David, > I would also want a flag of some >sort in the account tab for each account register that has a pending edit. >That should catch the complex window cases. One obvious flag here could be to change the colour of the text in the register tab header while a transaction in is open for

Re: [GNC] How to create Report on Checking & Exclude one Entity ?

2019-11-21 Thread Christopher Lam
The good news is negate search (both simple substring and regex) will be available on transaction-report based reports for 3.8 onwards due early January. Or you could try a recent build on https://code.gnucash.org/builds/win32/maint/ -- these should have a bunch of recent fixes, and no known

Re: [GNC] Reconciliation

2019-11-21 Thread David Carlson
I believe one scenario that could cause a starting balance to change might be in a case that involves multiple currencies or purchases or sales of securities, if the exchange rate embedded in a reconciled transaction changes (possibly due to editing the 'other side' of a reconciled transaction).

Re: [GNC] Reconciliation

2019-11-21 Thread Adrien Monteleone
Or if that is a warning you can turn off, the user might have done so, and would need to use the Reset Warnings function. Regards, Adrien > On Nov 21, 2019 w47d325, at 6:35 PM, Stephen M. Butler wrote: > > On 11/21/19 4:23 PM, Jack Lockard wrote: >> Here is what does not make any sense to me.

Re: [GNC] Reconciliation

2019-11-21 Thread Adrien Monteleone
It shouldn’t change without edits. My understanding is the starting balance is the last closing balance. The ‘guessed’ new closing balance is the net of all transactions that aren’t reconciled added to that starting balance. The dates are irrelevant as far as I understand. So if your last

Re: [GNC] Reconciliation

2019-11-21 Thread Stephen M. Butler
On 11/21/19 4:23 PM, Jack Lockard wrote: > Here is what does not make any sense to me. > > When I reconciled September's statement the beginning balance in GNUcash did > not match the bank statement. I went on and completed the reconciliation > process and when finished, the closing balance in

Re: [GNC] Reconciliation

2019-11-21 Thread Adrien Monteleone
I think it shouldn’t under normal use/circumstances. But if you later entered/edited transactions with a date prior to 9/30, then that *might* cause this. GnuCash will look to see what the balance was on 9/30 and that will now be different then it was when you reconciled. As long as the last

Re: [GNC] Reconciliation

2019-11-21 Thread Jack Lockard
I just tried that ending October 31, 2018 and then October 31, 2017 and the starting balance shown does not change. -Original Message- From: gnucash-user On Behalf Of David Carlson Sent: Thursday, November 21, 2019 7:16 PM To: David Cousens Cc: Gnucash Users Subject: Re: [GNC]

Re: [GNC] Reconciliation

2019-11-21 Thread Jack Lockard
Here is what does not make any sense to me. When I reconciled September's statement the beginning balance in GNUcash did not match the bank statement. I went on and completed the reconciliation process and when finished, the closing balance in GNUcash and the bank statement did match. For

Re: [GNC] Reconciliation

2019-11-21 Thread David Carlson
David Cousens, This would be a great time to provide details on how to follow your suggestion. Would it be sufficient to try setting previous reconcile dates into the reconcile dialog and see what values appear in the start and end balances? If there are usually no reconciled transactions in

[GNC] [Q]W2 Form

2019-11-21 Thread ceandyek laedon via gnucash-user
Can we use gnucash to generate W2 Form? Thanks Ceandyek ___ 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

Re: [GNC] Reconciliation

2019-11-21 Thread David Cousens
Jack, If both the starting balance and the ending balance do not agree with the statement being reconciled against, then the reconciliation for that period is actually invalid. The most likely reason for this to occur is entry of a new transaction or deletion of a previously reconciled

Re: [GNC] Reconciliation

2019-11-21 Thread David Carlson
On Thu, Nov 21, 2019 at 3:32 PM David Cousens wrote: > David, > > Thanks for your question. > In your experience are the "pending edits" preserved if the register > containing them is closed or are the edits to the transaction discarded on > closing the register. If you try to edit a

Re: [GNC] A question on loans

2019-11-21 Thread Michael or Penny Novack
On 11/21/2019 1:06 PM, Mark Phillips wrote: David, Thanks for your emails and explanations. What I am really looking for, is how to do this transaction: Increase the loan amount by $30,000 to bring it to the current value. I don't know where to put the offsetting entry for the $30,00 When

Re: [GNC] Reconciliation

2019-11-21 Thread David Cousens
David, In your experience are the "pending edits" preserved if the register containing them is closed or are the edits to the transaction discarded on closing the register. If you try to edit a transaction in two registers AFAIK you get a warning that the transaction is opened for editing in

Re: [GNC] A question on loans

2019-11-21 Thread David Cousens
Mark, OK so you want to record a single transaction to bring the balance up to date without recording all of the intervening transactions which you have not recorded. This is a similar situation to an opening balance on an existing account. The simplest way to manage this is to create an

Re: [GNC] A question on loans

2019-11-21 Thread Adrien Monteleone
> On Nov 20, 2019 w47d324, at 12:08 PM, Mark Phillips > wrote: > > My apologies, I did a very poor job of asking my question the first time. > Let me try again. > > My accounts (with simplified names) > Asset - Condo and Checking > Liability - Mortgage > Expenses - Mortgage Interest > > I

Re: [GNC] A question on loans

2019-11-21 Thread Adrien Monteleone
I concur with Stephen here. The answer to your question (as with all accounting questions in my opinion) is to model as closely as possible the real-world transactions. As I recall from your earlier post, you stopped using GnuCash for several years, now want to pick it back up and be all

Re: [GNC] A question on loans

2019-11-21 Thread Stephen M. Butler
On 11/21/19 10:06 AM, Mark Phillips wrote: > David, > > Thanks for your emails and explanations. What I am really looking for, is > how to do this transaction: > > Increase the loan amount by $30,000 to bring it to the current value. > > I don't know where to put the offsetting entry for the

Re: [GNC] Reconciliation

2019-11-21 Thread David Carlson
It is interesting that the condition that I call 'pending edits' appears in several of the previous comments. GnuCash has allowed users to start an edit to a transaction then navigate away from the incomplete edit, leaving it out of view, and incredibly difficult to find and resolve later in some

Re: [GNC] A question on loans

2019-11-21 Thread Mark Phillips
David, Thanks for your emails and explanations. What I am really looking for, is how to do this transaction: Increase the loan amount by $30,000 to bring it to the current value. I don't know where to put the offsetting entry for the $30,000. It does not go into checking, as I don't have a

Re: [GNC] Reconciliation

2019-11-21 Thread Adrien Monteleone
Simply re-reconciling and checking off those transactions should be sufficient. You just want to set the flag. I wouldn’t necessarily call this a bug, but perhaps file an RFE to add a check that there are no transactions in the affected register in an ‘editing state’ when the reconcile window

Re: [GNC] Reconciliation

2019-11-21 Thread Finbar Mahon
I have had a similar experience. Afaicr, the starting balance never coincided, so I thought it was because of (particularly?) income transaction(s) that hadn't cleared. I was able after a bit of detective work, based on my Quicken experiences, to find the anomalies. Now however, like Jack, it

Re: [GNC] Reconciliation

2019-11-21 Thread Dale Alspach
Something like this has happened to me (on linux Mint, several recent versions of gnucash) though not exactly what you are reporting. I do not usually check the starting balance so it could be the same. Here is a description of what happens. I mark the reconciliation box for some transactions in

Re: [GNC] Reconciliation

2019-11-21 Thread Stephen M. Butler
On 11/21/19 8:11 AM, Jack Lockard wrote: > For the past few months the starting balance shown by GNUcash did not match > with the starting balance on the bank statement even though the reconciled > balance shown by GNUcash for the previous months statement did indeed match > the bank statement.

[GNC] Reconciliation

2019-11-21 Thread Jack Lockard
For the past few months the starting balance shown by GNUcash did not match with the starting balance on the bank statement even though the reconciled balance shown by GNUcash for the previous months statement did indeed match the bank statement. I have completed the new reconciliation and the

Re: [GNC] UK. Value added tax.

2019-11-21 Thread Maf. King
I didn't make it clear that they offer a bridge spreadsheet for Linux... On Wednesday, 20 November 2019 21:23:33 GMT Maf. King wrote: > I have used this bridge product twice now, with experimental CSV report > directly output by GC > > https://www.chm-software.co.uk/ > > Christopher Lam has a