Re: Reconciliation Report

[David Carlson]

Adrien,

First, the reconciliation window does not have an option to show the
results of the reconciliation in a nice format 'Suitable for Framing".

Second, it does not have a feature to display results of previous
reconciliations, let alone have a way to correct errors in previous
reconciliations.

Third, there is no ability to add missing reconciliations in the past, as
well as no tracking of specific transactions being deleted or edited out of
the account by other actions on the data.

I think that your idea does have some merit, if it were possible to be
implemented.  I would like to see an ability to see which reconciliation a
particular transaction was a part of, for example, but I am not a
developer.  i think some changes have already been requested for
implementation.

David C


On Sun, Dec 3, 2017 at 9:32 AM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> Out of curiosity, how is this different from the reconciliation window
> itself? All of what has been listed in this thread is in that window. You
> can even jump to any transaction if you need more info to investigate
> something. You don’t have to close the window until you’re done. No adding
> machine tape is needed either. The window shows all relevant amounts and
> updates them as you mark items cleared or you unclear them.
>
> It seems to me the idea of a reconciliation report is trying to make
> GnuCash fit the old paper-books methods rather than utilizing the
> advantages of an electronic system.
>
> Regards,
> Adrien
>
> > On Dec 2, 2017, at 12:51 PM, C M Reinehr  wrote:
> >
> > The accounting software that I use to manage my business includes the
> following "Bank Reconciliation Report":
> >
> > 1)The bank balance as of the reconciliation date;
> >
> > 2)A list of currently unreconciled deposits & charges;
> >
> > 3)A subtotal of the above (2);
> >
> > 4)Followed by an "Adjusted Statement Balance" calculated by adding
> the above subtotal to the bank balance. This balance should be your
> register balance as of the reconciliation date or there is an error.
> >
> > This is essentially the procedure that is followed when reconciling your
> bank or credit card statement to your GNUCash register, just in the form of
> a printed report instead of an adding machine tape.
> >
> > I'm no expert at GNUCash but I haven't yet found any way to replicate
> this report in GNUCash but I think it would be a useful addition.
> >
> > HTH.
> >
> > CMR
> >
> >
> > On 11/30/2017 03:06 PM, Mike or Penny Novack wrote:
> >> On 11/29/2017 11:07 PM, Adrien Monteleone wrote:
> >>> Rick,
> >>>
> >>> Try the Transaction or Transaction by Payee report (the latter posted
> here on the list).
> >>>
> >>> You can show the Reconciled Date using the display tab in options,
> and/or sort by the reconciled date in the sorting tab.
> >>>
> >>> Unfortunately, I don’t think you can filter by
> reconciled/non-reconciled as the report currently stands.
> >>>
> >> Perhaps a more serious issue? Depending on what is meant by
> "reconciliation report".
> >>
> >> Rick, can you describe what your report is supposed to show? Let me
> explain. In the "old days" each month, when we got our bank statement, we
> "reconciled" the checking account. The bank statement showed the balance as
> of the close of the period and also all the deposits that the bank has
> during the period and all checks cleared during the period. Your books
> would have a bank account showing all deposits you made during the period
> and all checks written during the period and what you think the ending
> balance should be. Those two would normally NOT agree because:
> >> 1) A deposit made on the last day of the period might not be credited.
> >> 2) Some number of checks written during the period (or even from
> previous periods) not cleared yet.
> >>
> >> "1" rare but "2" the normal situation.
> >>
> >> So you took your balance and added to it all the checks that had not
> cleared (those NOT reconciled in the gnucash sense of "reconciled") and
> took the bank balance and added to it any deposit you made not shown on the
> bank statement and checked that those those two sums were equal.
> >>
> >> THAT what you mean?
> >>
> >> << I don't do any on-line banking (not over a dial-up connection OR a
> public access (unsecured) wifi) and the organizations for which I keep
> books have  a low enough volume of checks written each month that doing the
> old fashioned reconciliation no big chore to do that "report" by hand since
> not likely to be more than 2-3 uncleared checks >>
> >>
> >> If THAT is the report you require, unless you have a large number of
> checks still outstanding each period, automating the process perhaps a
> waste of time. So try to better describe what you have been asked to
> produce.
> >>
> >> Michael D Novack
> >>
> >>
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> https://lists.gnucash.org/mai

Re: Reconciliation Report

[Adrien Monteleone]

Out of curiosity, how is this different from the reconciliation window itself? 
All of what has been listed in this thread is in that window. You can even jump 
to any transaction if you need more info to investigate something. You don’t 
have to close the window until you’re done. No adding machine tape is needed 
either. The window shows all relevant amounts and updates them as you mark 
items cleared or you unclear them.

It seems to me the idea of a reconciliation report is trying to make GnuCash 
fit the old paper-books methods rather than utilizing the advantages of an 
electronic system.

Regards,
Adrien

> On Dec 2, 2017, at 12:51 PM, C M Reinehr  wrote:
> 
> The accounting software that I use to manage my business includes the 
> following "Bank Reconciliation Report":
> 
> 1)The bank balance as of the reconciliation date;
> 
> 2)A list of currently unreconciled deposits & charges;
> 
> 3)A subtotal of the above (2);
> 
> 4)Followed by an "Adjusted Statement Balance" calculated by adding the 
> above subtotal to the bank balance. This balance should be your register 
> balance as of the reconciliation date or there is an error.
> 
> This is essentially the procedure that is followed when reconciling your bank 
> or credit card statement to your GNUCash register, just in the form of a 
> printed report instead of an adding machine tape.
> 
> I'm no expert at GNUCash but I haven't yet found any way to replicate this 
> report in GNUCash but I think it would be a useful addition.
> 
> HTH.
> 
> CMR
> 
> 
> On 11/30/2017 03:06 PM, Mike or Penny Novack wrote:
>> On 11/29/2017 11:07 PM, Adrien Monteleone wrote:
>>> Rick,
>>> 
>>> Try the Transaction or Transaction by Payee report (the latter posted here 
>>> on the list).
>>> 
>>> You can show the Reconciled Date using the display tab in options, and/or 
>>> sort by the reconciled date in the sorting tab.
>>> 
>>> Unfortunately, I don’t think you can filter by reconciled/non-reconciled as 
>>> the report currently stands.
>>> 
>> Perhaps a more serious issue? Depending on what is meant by "reconciliation 
>> report".
>> 
>> Rick, can you describe what your report is supposed to show? Let me explain. 
>> In the "old days" each month, when we got our bank statement, we 
>> "reconciled" the checking account. The bank statement showed the balance as 
>> of the close of the period and also all the deposits that the bank has 
>> during the period and all checks cleared during the period. Your books would 
>> have a bank account showing all deposits you made during the period and all 
>> checks written during the period and what you think the ending balance 
>> should be. Those two would normally NOT agree because:
>> 1) A deposit made on the last day of the period might not be credited.
>> 2) Some number of checks written during the period (or even from previous 
>> periods) not cleared yet.
>> 
>> "1" rare but "2" the normal situation.
>> 
>> So you took your balance and added to it all the checks that had not cleared 
>> (those NOT reconciled in the gnucash sense of "reconciled") and took the 
>> bank balance and added to it any deposit you made not shown on the bank 
>> statement and checked that those those two sums were equal.
>> 
>> THAT what you mean?
>> 
>> << I don't do any on-line banking (not over a dial-up connection OR a public 
>> access (unsecured) wifi) and the organizations for which I keep books have  
>> a low enough volume of checks written each month that doing the old 
>> fashioned reconciliation no big chore to do that "report" by hand since not 
>> likely to be more than 2-3 uncleared checks >>
>> 
>> If THAT is the report you require, unless you have a large number of checks 
>> still outstanding each period, automating the process perhaps a waste of 
>> time. So try to better describe what you have been asked to produce.
>> 
>> 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.
> 
> -- 
> “Jurors should acquit, even against the judge’s instruction… if exercising 
> their judgment with discretion and honesty, they have a clear conviction the 
> charge of the court is wrong.” -- Alexander Hamilton
> 
> 
> ___
> 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: Reconciliation Report

[C M Reinehr]

The accounting software that I use to manage my business includes the 
following "Bank Reconciliation Report":


1)    The bank balance as of the reconciliation date;

2)    A list of currently unreconciled deposits & charges;

3)    A subtotal of the above (2);

4)    Followed by an "Adjusted Statement Balance" calculated by adding 
the above subtotal to the bank balance. This balance should be your 
register balance as of the reconciliation date or there is an error.


This is essentially the procedure that is followed when reconciling your 
bank or credit card statement to your GNUCash register, just in the form 
of a printed report instead of an adding machine tape.


I'm no expert at GNUCash but I haven't yet found any way to replicate 
this report in GNUCash but I think it would be a useful addition.


HTH.

CMR


On 11/30/2017 03:06 PM, Mike or Penny Novack wrote:

On 11/29/2017 11:07 PM, Adrien Monteleone wrote:

Rick,

Try the Transaction or Transaction by Payee report (the latter posted 
here on the list).


You can show the Reconciled Date using the display tab in options, 
and/or sort by the reconciled date in the sorting tab.


Unfortunately, I don’t think you can filter by 
reconciled/non-reconciled as the report currently stands.


Perhaps a more serious issue? Depending on what is meant by 
"reconciliation report".


Rick, can you describe what your report is supposed to show? Let me 
explain. In the "old days" each month, when we got our bank statement, 
we "reconciled" the checking account. The bank statement showed the 
balance as of the close of the period and also all the deposits that 
the bank has during the period and all checks cleared during the 
period. Your books would have a bank account showing all deposits you 
made during the period and all checks written during the period and 
what you think the ending balance should be. Those two would normally 
NOT agree because:

1) A deposit made on the last day of the period might not be credited.
2) Some number of checks written during the period (or even from 
previous periods) not cleared yet.


"1" rare but "2" the normal situation.

So you took your balance and added to it all the checks that had not 
cleared (those NOT reconciled in the gnucash sense of "reconciled") 
and took the bank balance and added to it any deposit you made not 
shown on the bank statement and checked that those those two sums were 
equal.


THAT what you mean?

<< I don't do any on-line banking (not over a dial-up connection OR a 
public access (unsecured) wifi) and the organizations for which I keep 
books have  a low enough volume of checks written each month that 
doing the old fashioned reconciliation no big chore to do that 
"report" by hand since not likely to be more than 2-3 uncleared checks >>


If THAT is the report you require, unless you have a large number of 
checks still outstanding each period, automating the process perhaps a 
waste of time. So try to better describe what you have been asked to 
produce.


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.


--
“Jurors should acquit, even against the judge’s instruction… if exercising 
their judgment with discretion and honesty, they have a clear conviction the 
charge of the court is wrong.” -- Alexander Hamilton


___
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: Reconciliation Report

[prl]

On 1/12/2017 08:06, Mike or Penny Novack wrote:
Perhaps a more serious issue? Depending on what is meant by 
"reconciliation report".


Rick, can you describe what your report is supposed to show?
Way back when I used Quicken for Mac, a reconciliation report on that 
system showed:


Reconciliation Report
Reconcile balance as of 
=

Bank Statement - Cleared Transactions
-
Previous balance
Checks & Payments
Deposits and other credits
Ending balance of bank statement

Your Records - Unreconciled Transactions

Cleared Balance
Checks & Payments
Deposits and other credits
Register balance as of 
Checks & Payments (post close of bank statement)
Deposits and other credits(post close of bank statement)
Register ending balance (as of )

Unreconciled Transaction Detail Up To
---


So, a list of any cheques or other payments made before close of the 
statement and not yet cleared, deposits made before close of the 
statement and not yet entered into the account and *any unexpected 
differences between the register and the bank statement*.


The last one being, surely, the main motivation for doing the 
reconciliation in the first place?


I'm not sure if that's quite what Rick was looking for, but that's what 
I was getting from Quicken for Mac.


Peter
___
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: Reconciliation Report

[Mike or Penny Novack]

On 11/29/2017 11:07 PM, Adrien Monteleone wrote:

Rick,

Try the Transaction or Transaction by Payee report (the latter posted here on 
the list).

You can show the Reconciled Date using the display tab in options, and/or sort 
by the reconciled date in the sorting tab.

Unfortunately, I don’t think you can filter by reconciled/non-reconciled as the 
report currently stands.

Perhaps a more serious issue? Depending on what is meant by 
"reconciliation report".


Rick, can you describe what your report is supposed to show? Let me 
explain. In the "old days" each month, when we got our bank statement, 
we "reconciled" the checking account. The bank statement showed the 
balance as of the close of the period and also all the deposits that the 
bank has during the period and all checks cleared during the period. 
Your books would have a bank account showing all deposits you made 
during the period and all checks written during the period and what you 
think the ending balance should be. Those two would normally NOT agree 
because:

1) A deposit made on the last day of the period might not be credited.
2) Some number of checks written during the period (or even from 
previous periods) not cleared yet.


"1" rare but "2" the normal situation.

So you took your balance and added to it all the checks that had not 
cleared (those NOT reconciled in the gnucash sense of "reconciled") and 
took the bank balance and added to it any deposit you made not shown on 
the bank statement and checked that those those two sums were equal.


THAT what you mean?

<< I don't do any on-line banking (not over a dial-up connection OR a 
public access (unsecured) wifi) and the organizations for which I keep 
books have  a low enough volume of checks written each month that doing 
the old fashioned reconciliation no big chore to do that "report" by 
hand since not likely to be more than 2-3 uncleared checks >>


If THAT is the report you require, unless you have a large number of 
checks still outstanding each period, automating the process perhaps a 
waste of time. So try to better describe what you have been asked to 
produce.


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: Reconciliation Report

[Christopher Lam]

Hi Rick

As per Adrien, there’s no specific Reconciliation Report.
You can, however, run the Transaction Report, choose select:
- Accounts/Accounts – choose your Bank account (or Credit Card account)
- Display/Reconciled Date - ticked
- Sorting/Primary Sortkey - Reconciled Date

This may help. I believe the next release will sport a reconciled status filter.

HTH

From: Rick Halvorson
Sent: Thursday, 30 November 2017 11:56 AM
To: gnucash-user@gnucash.org
Subject: Reconciliation Report

I have been asked to produce a printed Reconciliation Report each month after 
reconciling the checking account bank statement in the gnucash software. I have 
been unable to find such a report included. Can you help me find it if it is 
there and if not is it something that can be produced?

Thank you,
Rick H.

Get Outlook for Android

___
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: Reconciliation Report

[Adrien Monteleone]

Rick,

Try the Transaction or Transaction by Payee report (the latter posted here on 
the list).

You can show the Reconciled Date using the display tab in options, and/or sort 
by the reconciled date in the sorting tab.

Unfortunately, I don’t think you can filter by reconciled/non-reconciled as the 
report currently stands.

I would think running the report for the full date range desired and showing a 
reconciled date would be sufficient to show all transactions and also indicate 
which have been (or not) reconciled.

As for sub-totals of total vs. reconciled, you’ll have to adjust this report or 
create your own as needed.

If you don’t see the options I describe in your standard Transaction report I 
suspect they were added by the updated one posted here on the list. I don’t 
know if that new report made it into the newest version or not.

Regards,
Adrien

> On Nov 29, 2017, at 9:51 PM, Rick Halvorson  wrote:
> 
> I have been asked to produce a printed Reconciliation Report each month after 
> reconciling the checking account bank statement in the gnucash software. I 
> have been unable to find such a report included. Can you help me find it if 
> it is there and if not is it something that can be produced?
> 
> Thank you,
> Rick H.
> 
> Get Outlook for Android
> 
> ___
> 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.