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 <cmr at reinehr.net> 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 at 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 at 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.