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 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
--------