Re: Reconciling an account

2017-06-16 Thread Maf. King
On Friday, 16 June 2017 17:42:32 BST David Carlson wrote: > When you have the curser in a split line of a transaction, the word 'Tot' > disappears. You only see that when the curser is in boxes that are not a > part of a split line. > So it does. I hadn't noticed that. Another mystery solved! T

Re: Reconciling an account

2017-06-16 Thread John Morris
> When you have the curser in a split line of a transaction, the word 'Tot' > disappears. You only see that when the curser is in boxes that are not a > part of a split line. I think this also depends on the view one is using. I'm using a Mac with the en-us translation and GnuCash 2.6.16. I us

Re: Reconciling an account

2017-06-16 Thread Adrien Monteleone
> On Jun 16, 2017, at 11:42 AM, David Carlson > wrote: > > When you have the curser in a split line of a transaction, the word 'Tot' > disappears. You only see that when the curser is in boxes that are not a > part of a split line. > > > David C That makes much more sense than my guess abou

Re: Reconciling an account

2017-06-16 Thread Adrien Monteleone
> On Jun 16, 2017, at 10:04 AM, EngineInstitute wrote: > > Adrien: > > Look at your bank register. It should be labeled Tot Deposit/Tot Withdraw. > > Response: > Checking account ledger tabs on the right are: Deposit/Withdraw not Tot > Deposit or Tot Withdraw > Tabs in the credit card ledger

Re: Reconciling an account

2017-06-16 Thread David Carlson
When you have the curser in a split line of a transaction, the word 'Tot' disappears. You only see that when the curser is in boxes that are not a part of a split line. David C On Fri, Jun 16, 2017 at 10:53 AM, Maf. King wrote: > On Friday, 16 June 2017 16:04:02 BST EngineInstitute wrote: > >

Re: Reconciling an account

2017-06-16 Thread Maf. King
On Friday, 16 June 2017 16:04:02 BST EngineInstitute wrote: > Adrien: > > Look at your bank register. It should be labeled Tot Deposit/Tot Withdraw. > > Response: > Checking account ledger tabs on the right are: Deposit/Withdraw not Tot > Deposit or Tot Withdraw > Tabs in the credit card ledger

Re: Reconciling an account

2017-06-16 Thread EngineInstitute
Maf, No I don't have any extra splits in the payment transaction. Thanks for the thought. - China Blue -- View this message in context: http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692201.html Sent from the GnuCash - User mailing list archive at Nabble.com. ___

Re: Reconciling an account

2017-06-16 Thread EngineInstitute
Adrien: Look at your bank register. It should be labeled Tot Deposit/Tot Withdraw. Response: Checking account ledger tabs on the right are: Deposit/Withdraw not Tot Deposit or Tot Withdraw Tabs in the credit card ledger on right are labeled: Payment/Charge/Balance without the Tot Note: I che

Re: Reconciling an account

2017-06-13 Thread Maf. King
Hi - as an addendum, after reading Adrien's reply which came in while I wasn't looking... Screengrab attached of the Ccard payment and one of the purchase txns that I posted yesterday, but in Transaction Journal view mode. thought it might be useful. You don't, by chance, have any extra splits

Re: Reconciling an account

2017-06-13 Thread Maf. King
On Tuesday, 13 June 2017 18:14:39 BST EngineInstitute wrote: > Maf, > Yes it is confusing. > Ok got 2.6.15 > In the accounts tree the credit card account is listed directly under > Liabilities. > When looking at the preferences of this account under > Edit/Preferences/Accounts it is listed under Re

Re: Reconciling an account

2017-06-13 Thread Adrien Monteleone
> On Jun 13, 2017, at 12:14 PM, EngineInstitute wrote: > > Maf, > Yes it is confusing. > Ok got 2.6.15 > In the accounts tree the credit card account is listed directly under > Liabilities. When looking at the preferences of this account under > Edit/Preferences/Accounts it is listed under Rever

Re: Reconciling an account

2017-06-13 Thread Adrien Monteleone
From the perspective of the credit card account register, ‘decrease’ for the bank split is incorrect as well. Look at your bank register. It should be labeled Tot Deposit/Tot Withdraw. (a cash account would say ‘Tot Receive/Tot Spend’ which is much easier to follow, a basic asset account will s

Re: Reconciling an account

2017-06-13 Thread EngineInstitute
Maf, Yes it is confusing. Ok got 2.6.15 In the accounts tree the credit card account is listed directly under Liabilities. When looking at the preferences of this account under Edit/Preferences/Accounts it is listed under Reverse Balance Accounts as a Credit account. This category I understand is a

Re: Reconciling an account

2017-06-12 Thread Adrien Monteleone
> On Jun 12, 2017, at 12:10 PM, EngineInstitute wrote: > > David: > > It is account is under the Liabilities and labeled as a Credit account. > Note: it shows deposits on left and withdrawals on right. Is that because it > was originally an income & expense account and I changed it? You should

Re: Reconciling an account

2017-06-12 Thread Maf. King
On Monday, 12 June 2017 22:00:35 BST Maf. King wrote: > > Steps taken: > > Down graded the program to 2.4.15 (there is no 2.6.15) > > There is. > https://sourceforge.net/projects/gnucash/files/gnucash %28stable%29/2.6.15/ > Sorry, Link got mangled. https://sourceforge.net/projects/gnucash/file

Re: Reconciling an account

2017-06-12 Thread Maf. King
On Monday, 12 June 2017 18:10:47 BST EngineInstitute wrote: > David: > > It is account is under the Liabilities and labeled as a Credit account. > Note: it shows deposits on left and withdrawals on right. Is that because it > was originally an income & expense account and I changed it? Hi ChinaBl

Re: Reconciling an account

2017-06-12 Thread EngineInstitute
David: It is account is under the Liabilities and labeled as a Credit account. Note: it shows deposits on left and withdrawals on right. Is that because it was originally an income & expense account and I changed it? Steps taken: Down graded the program to 2.4.15 (there is no 2.6.15) No change.

Re: Reconciling an account

2017-06-07 Thread Derek Atkins
Hi, EngineInstitute writes: > Dave, > No worries about raining on my parade. > I figured it was probably a preferences issue. I did check the account and I don't think it's a preferences issue. > it was marked income & expense not credit. So I changed it to credit. So > that shows the balance

Re: Reconciling an account

2017-06-07 Thread Christopher Lam
Perhaps you may share a partial screenshot of your liability account register? Zap confidential data, however, some data has already been shared :) On 7 June 2017 at 10:26, EngineInstitute wrote: > Dave, > No worries about raining on my parade. > I figured it was probably a preferences issue. I

Re: Reconciling an account

2017-06-06 Thread EngineInstitute
Dave, No worries about raining on my parade. I figured it was probably a preferences issue. I did check the account and it was marked income & expense not credit. So I changed it to credit. So that shows the balance correctly as a negative (which I overlooked). Also it is positioned correctly as a

Re: Reconciling an account

2017-06-06 Thread David Carlson
I really hate to rain on your parade... Check your Edit>Preferences>Accounts>Reverse Balanced Accounts. I believe the default is labelled Credit, but that means Credit Card, Payable, Liability Equity and Income, and that is probably what is checked in your file. If that is so, then the balance s

Re: Reconciling an account

2017-06-06 Thread Derek Atkins
That means your transactions are entered backwards. -derek -- Sent from my Android device with K-9 Mail. Please excuse my brevity or typos. On June 6, 2017 7:36:25 PM EDT, EngineInstitute wrote: >Thanks for that hint David, I did check the running totals in the >register >and I did not find any

Re: Reconciling an account

2017-06-06 Thread EngineInstitute
Thanks for that hint David, I did check the running totals in the register and I did not find anything but what I did was realize what the source of the problem is. This is a liability account. In the reconciliation window the funds in should create a decrease on the balance and the funds out an in

Re: Reconciling an account

2017-06-06 Thread EngineInstitute
Yes, Mark. - China Blue -- View this message in context: http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993p4692062.html Sent from the GnuCash - User mailing list archive at Nabble.com. ___ gnucash-user mailing list gnucash-user

Re: Reconciling an account

2017-06-06 Thread David Carlson
Ok, the next thing to do is to go into your register view and look at the running total next to each of the transactions that you show in your images, to see if the value was correctly added or subtracted by GnuCash. Also set the register view to Transaction Journal to see if there are any suspicio

Re: Reconciling an account

2017-06-06 Thread Mark Phillips
Is your opening balance for this account correct? Mark On Tue, Jun 6, 2017 at 2:20 PM, EngineInstitute wrote: > Yes I tried the manual way using the transaction report to check against > both > the Gnu reconciliation as well as the statement. Nothing is obvious. > I also checked by applying th

Re: Reconciling an account

2017-06-06 Thread EngineInstitute
Yes I tried the manual way using the transaction report to check against both the Gnu reconciliation as well as the statement. Nothing is obvious. I also checked by applying the filter without the reconciled items and what came up are the items in the to be reconciled in the reconcile register. Fi

Re: Reconciling an account

2017-06-06 Thread EngineInstitute
Mike, I did do it the old way eg: pen and paper and checked so I did not overlook transpositions by checking my total payments noted in Gnucash against the statement which agree as well as the credits. And indeed there are no outstanding amounts for 195.14 or 97.57. Since the statement and Gnucash

Re: Reconciling an account

2017-06-06 Thread Colin Law
Have you tried the earlier suggestion of splitting the statement every few transactions and treating each group of three or four transactions as a separate statement and reconciling each group separately. Then you will tie the problem down to three or four so you should be able to see what is causi

Re: Reconciling an account

2017-06-06 Thread Mike or Penny Novack
On 6/5/2017 8:08 PM, EngineInstitute wrote: Colin, When this happens it should be a cake walk right? Not for me. I check off all of the credits and debits and compare their totals (reflected on the bottom) with the statement and everything is in order yet I am faced with a difference of $1

Re: Reconciling an account

2017-06-05 Thread Mark Phillips
I seriously doubt you have found a bug. You probably have a transaction in GnuCash that does not match the bank's transaction. Digits are transposed, debits/credits are reversed, a transaction is in the wrong account (so not in the one you are reconciling) or something like that. I have had this p

Re: Reconciling an account

2017-06-05 Thread EngineInstitute
Colin, I was thinking it was a version problem so I updated my software to make sure this was not the case. I love your suggestion. I did not know about the filter option. So I implemented it and cleared the reconciled items, then went back to the reconcile for that month and all agrees. Yeh for

Re: Reconciling an account

2017-06-05 Thread David Carlson
Wow, now we are getting some well detailed suggestions! I will add a couple: To quickly see if all previous transactions were really reconciled, select View > Filter by .> Status > uncheck Reconciled. If you don't have too many transactions with dates earlier than the bank cleared them, your run

Re: Reconciling an account

2017-06-05 Thread Colin Law
Have you possibly entered a transaction the wrong way round (debit instead of credit or vise versa)? Then not noticed this when you tick it off? A suggestion earlier may be a good one if you still cannot find where you are going wrong. Draw lines on your statement after every, say, 4 entries. Then

Re: Reconciling an account

2017-06-05 Thread Dale Alspach
Some possibilities that have not been mentioned: Old uncleared/unreconciled transactions will alter the suggested balance. You entered and cleared a transaction that is not readily visible because the date is long past. Note this can happen by editing a transaction in another account. Gnucash he

Re: Reconciling an account

2017-06-05 Thread Dean Gibson
I misspoke. I meant the ending date. When I change the ending date to match the statement, that gives me the corresponding ending balance, every time, so I don't have to adjust it (assuming I've downloaded all the bank/CC transactions). My only "complaint" with the GnuCash reconciliation pro

Re: Reconciling an account

2017-06-05 Thread Derek Atkins
Hi Dean, On Mon, June 5, 2017 2:52 pm, Dean Gibson wrote: > Make sure that the reconciliation "beginning date" is the same as that > on your statement. A different date will create a different beginning > balance. This is not correct. You cannot change the beginning date. That date is the "clo

Re: Reconciling an account

2017-06-05 Thread Adrien Monteleone
Have you checked against the possibility that GC isn’t the location of the error? If all the transactions on your statement match GC and you’ve checked off only those transactions in the reconciliation window, and the starting balances line up, then if the statement ending balance and GC don’t

Re: Reconciling an account

2017-06-05 Thread Dean Gibson
Make sure that the reconciliation "beginning date" is the same as that on your statement. A different date will create a different beginning balance. In any case, don't change the balance manually, unless you have a good reason to. On 2017-06-05 10:10, EngineInstitute wrote: John, What baf

Re: Reconciling an account

2017-06-05 Thread David Carlson
I often have duplicate entries appear in transfer accounts when I import transactions resulting from imperfect matching during the import process. While these are usually easy to find and fix, sometimes I make an error and "fix" the wrong transaction or split. If a previously reconciled transacti

Re: Reconciling an account

2017-06-05 Thread Derek Atkins
Hi, On Mon, June 5, 2017 1:10 pm, EngineInstitute wrote: > John, > > What baffles me is that I am balancing a credit card statement with little > activity. It was reconciled correctly the prior month, so the starting > balance for the following month is correct. > > In this case the initial reconc

Re: Reconciling an account

2017-06-05 Thread EngineInstitute
John, What baffles me is that I am balancing a credit card statement with little activity. It was reconciled correctly the prior month, so the starting balance for the following month is correct. In this case the initial reconcile box reflects a different balance, so I put in the new balance to

Re: Reconciling an account

2017-06-04 Thread Michael via gnucash-user
On Sun, 04 Jun 2017 12:48:35 -0400 Derek Atkins wrote: > He's wrong. > You should absolutely change the ending balance in the dialog to > match your statement because you may have transactions that haven't > cleared yet. -derek It sounded like the OP was changing the balance but not the date. I

Re: Reconciling an account

2017-06-04 Thread Derek Atkins
ch the statement then >>>more work >>>> is needed. Mike >>>> >>>> >>>> >>>> >>>> Sent from Samsung tablet >>>> >>>> >>>> >>>> Original message >>

Re: Reconciling an account

2017-06-04 Thread Colin Law
t; >>> >>> Original message >>> From Colin Law >>> Date: 06/04/2017 6:08 AM (GMT-08:00) >>> To stepbystepf...@dialup4less.com >>> Cc gnucash-user@gnucash.org >>> Subject Re: Reconciling an account >>> >>

Re: Reconciling an account

2017-06-04 Thread Derek Atkins
> From Colin Law >> Date: 06/04/2017 6:08 AM (GMT-08:00) >> To stepbystepf...@dialup4less.com >> Cc gnucash-user@gnucash.org >> Subject Re: Reconciling an account >> >> >> Michael, Do you mean you do not start by setting the ending balance >in >>

Re: Reconciling an account

2017-06-04 Thread Colin Law
/04/2017 6:08 AM (GMT-08:00) > To stepbystepf...@dialup4less.com > Cc gnucash-user@gnucash.org > Subject Re: Reconciling an account > > > Michael, Do you mean you do not start by setting the ending balance in > the reconcile opening dialog to that from the statement that you are >

Re: Reconciling an account

2017-06-04 Thread mjchurchill via gnucash-user
message From Colin Law Date: 06/04/2017 6:08 AM (GMT-08:00) To stepbystepf...@dialup4less.com Cc gnucash-user@gnucash.org Subject Re: Reconciling an account Michael, Do you mean you do not start by setting the ending balance in the reconcile opening dialog to that from the statement

Re: Reconciling an account

2017-06-04 Thread Colin Law
Michael, Do you mean you do not start by setting the ending balance in the reconcile opening dialog to that from the statement that you are reconciling against? Colin On 4 June 2017 at 12:29, Mike or Penny Novack wrote: > On 6/3/2017 6:51 PM, EngineInstitute wrote: >> >> I am having problems rec

Re: Reconciling an account

2017-06-04 Thread Mike or Penny Novack
On 6/3/2017 6:51 PM, EngineInstitute wrote: I am having problems reconciling an account. The starting balance agrees with the statement but ending balance does not. OK so I changed the ending balance to the correct one in the initial dialog box. I then went on to the next task of checking all of

Re: Reconciling an account

2017-06-04 Thread Liz
On Sun, 4 Jun 2017 08:28:04 +0100 Colin Law wrote: > Chris > If the reconcile window shows the same starting balance as your > statement does and you have set the ending balance to that from the > statement then after you tick off all the transactions from the > statement then you should end up w

Re: Reconciling an account

2017-06-04 Thread Colin Law
Chris If the reconcile window shows the same starting balance as your statement does and you have set the ending balance to that from the statement then after you tick off all the transactions from the statement then you should end up with a reconcile difference of zero. If you don't get zero then

Re: Reconciling an account

2017-06-03 Thread David T. via gnucash-user
John,  That sounds way more complicated than using the reconcile feature in Gnucash and following the guidance in the concept guide at chapter 4.4 & 5.4. When I reconcile using this method, I click reconcile, I select the correct ending date, adjust the closing balance to match the statement. The

Re: Reconciling an account

2017-06-03 Thread John Walker
Hi China Blue This particular issue baffled me for some time until I came up with a process that tells me what to expect. My GnuAccount opening balance hardly ever is the starting balance in the relevant statement because inputs and outputs from previous statements as well as the current sta

Re: Reconciling an account

2017-06-03 Thread Michael via gnucash-user
On Sat, 3 Jun 2017 15:51:01 -0700 (PDT) EngineInstitute wrote: > I am having problems reconciling an account. The starting balance > agrees with the statement but ending balance does not. OK so I > changed the ending balance to the correct one in the initial dialog > box. I then went on to the ne