Re: [GNC] Reconciliation Report

[David Carlson]

Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


On Wed, Oct 5, 2022, 9:53 AM Nathan Rosenthal  wrote:

> The first sentence in your reply explains why going back further than the
> previous month did not produce any results.
>
> I will wait until the end of the month when there will be new unreconciled
> transactions in the account.
>
> Nathan
>
> On 10/4/2022 7:45 PM, David Carlson wrote:
>
> Once a transaction is reconciled it never appears in a subsequent
> reconciliation unless it has been unreconciled.
>
> Apparently I have never tried running a Reconciliation on an account where
> there were no unreconciled transactions at all, which must be what you are
> seeing,  Try creating a test transaction in that account to see if it
> appears when you run the reconciliation..  The date would not be critical
> as long as it is newly entered and not reconciled.
>
> On Tue, Oct 4, 2022 at 6:25 PM Nathan Rosenthal 
> wrote:
>
>> Yes there were transactions during the month. In fact I got the same
>> response when I used a longer time frame. There was a deposit on 9/12, a
>> withdrawal on 9/15, and an interest payment on 9/30. It is really puzzling
>> since the reconciliation process works correctly on two checking accounts.
>>
>> I can set the opening and closing balances and the start and end dates
>> but the program still reports no transactions in this account. It is not a
>> serious problem because I can always use a spreadsheet to do the
>> reconciliation. It would be nice, though, to figure out why I get this
>> result.
>>
>> Nathan
>>
>>
>>
>> On 10/4/2022 7:13 PM, David Carlson wrote:
>>
>> Nathan,  Are there actually no transactions in the share account for that
>> period?  I am surprised that the reconciliation dialog doesn't pop up
>> anyway to set the start and end balances.
>>
>> On Tue, Oct 4, 2022 at 4:21 PM Nathan Rosenthal 
>> wrote:
>>
>>> I maintain 2 accounts for an organization I belong to - a checking
>>> account at one bank and a share account at a credit union. Each of them
>>> has an account in gnucash. When I reconcile the accounts, the checking
>>> account reconciliation works properly but the share account
>>> reconciliation fails with a "no transactions in the specified period"
>>> error message even though I use the same period (monthly) for both
>>> accounts.
>>>
>>> I believe I have set them up properly. I am using ver 4.12 under Windows
>>> 10. All other functions seem to work properly.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> 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.
>>>
>>
>>
>> --
>> David Carlson
>>
>>
>>
>
> --
> David Carlson
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report

[David Carlson]

Nathan,  Are there actually no transactions in the share account for that
period?  I am surprised that the reconciliation dialog doesn't pop up
anyway to set the start and end balances.

On Tue, Oct 4, 2022 at 4:21 PM Nathan Rosenthal 
wrote:

> I maintain 2 accounts for an organization I belong to - a checking
> account at one bank and a share account at a credit union. Each of them
> has an account in gnucash. When I reconcile the accounts, the checking
> account reconciliation works properly but the share account
> reconciliation fails with a "no transactions in the specified period"
> error message even though I use the same period (monthly) for both
> accounts.
>
> I believe I have set them up properly. I am using ver 4.12 under Windows
> 10. All other functions seem to work properly.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

[Adrien Monteleone]

If you are looking for 'aging', that is, how much of an amount owed is 
say 30days, 60days, or 90+days due, then that is at the bottom each 
Customer or Vendor report. (and also shows any unused 
pre-payments/deposits in the case you use that feature)


It doesn't show any sort of average, but it does give you the exact 
amounts and how aged they are.


If you want to know the 'average' age of your AR/AP, then most likely 
you'd have to export those individual reports to a spreadsheet and do 
some math there. (there might be a way to extract this info via 
gnucash-cli or piecash and automate this process.)


If indeed you're looking for an overall average, that might be a good 
Request For Enhancement (also to be filed on bugs.gnucash.org) maybe to 
be added to the Summary Bar for each of the AR/AP accounts, and/or the 
experimental 'Dashboard' report.


Regards,
Adrien

On 10/3/22 8:50 AM, Uttam Chakravorty wrote:
If there is a way to get the average debtor/creditor days this would be 
the icing on the cake.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

[Uttam Chakravorty]

Dear Michael,



Many thanks to both you and Adrien.  Both the answers are far more considered 
than my initial comment had intended to provoke, thank you.  I had made my 
original comment by way of explaining how I was approaching the puzzle i.e. in 
the early eighties I would parse the software through a hexadecimal editor such 
as Norton and then check the search results in plain English by interrogating 
the Audit Trail.  It seems so primitive compared to what I have just learned.


In general today I'm very happy to use the TB as my critical check at the risk 
of missing out on any reciprocating errors.  I find they either prove de 
minimis or so big that they don't stay hidden.


The first part part of what I was seeking has been addressed by Adrien.  If 
there is a way to get the average debtor/creditor days this would be the icing 
on the cake.


 
Returning to Gnucash I find it the best piece of software I have used in 40yrs 
and it handles our needs brilliantly.  I love the way it sticks to the T-bar 
principles, I'm sure the Medici would have loved it and could have avoided so 
much bloodshed.  I appreciate it is far more capable than simple bookkeeping, 
the limitation is that is all I know.  I was put out to grass nearly a decade 
ago and I only get to do this as it is a small business (just my wife and son 
evangelising Linux - fun but not particularly business-like).  The multi-user 
issues that you recall bring a smile to my face as they can no longer strike 
terror into my soul.



With many thanks and best wishes, Uttam (and a beer or three (who's counting) 
if you are ever in my neighbourhood)






 From:   Michael or Penny Novack  
 To:
 Sent:   02/10/2022 3:46 PM 
 Subject:   Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing 
transactions 

 
> 
> And in that case of 'breadcrumbs' the entirety of GnuCash is an audit  
> trail, as that is how double-entry accounting works. 
> 
> If you are looking for some record of exactly who entered which  
> transactions and the date/time stamps, no, that is not available.  
> Technically I think the posting date/time does get recorded, but it is  
> not readily available to users. If you really need it, perhaps start a  
> thread just on that question. 
> 
> Certainly the 'who' will be impossible, because GnuCash is not a  
> multi-user application. Whomever has access to run the app, and access  
> to the file, can post or edit transactions.  
 
As somebody who used to do this (for one of the world's largest  
"financials") my comment might (or might not) be useful. 
 
a) The accounting system itself (its own reporting functions) would not  
provide a way of reporting when/who by. It is important to understand  
that this information is NOT part of the accounting system. Accounting  
is not a "real time" process nor would who by (what worker bee) be  
relevant to the question of correctness in an accounting sense. 
 
b) But there are OTHER ways in which general ledger might be audited.  
Internally correct is one matter, but externally correct is another. For  
example,here we have an invoice marked paid by check. But WAS there  
actually such a check, and if not, who (falsely) entered that invoice as  
paid and when. How many of you when first learning to use gnucash  
created a set of "test books" and into these entered a number of "test  
transactions"? Understand? There was nothing wrong internally with this  
set of test books you were using to learn gnucash but they matched  
nothing in the real world. 
 
c) Like I said, there would be no functions PART of the accounting  
system to be used for this sort of purpose. But when the auditors  
(checking against the real world) found something suspicious, this sort  
of problem would come t my desk. "Mike, figure out who entered THIS  
transaction and when". So I would figure out what feed to the system  
would have fed that transaction to general ledger, get the right backup  
tape recovered from the vaults, and with a little "ad hoc" program I'd  
write for the purpose, get that information. It's not as if I'd be  
writing a lot of these ad hoc programs from scratch, just take to one I  
used last time and change a line or two of code. 
 
    THIS sort of "check against the real world" was rare. I [probably  
did only a few times a year. More often it was personal and quickly  
enough after that fact I didn't have to have backups recovered from the  
vault. Thus suppose I was handed a problem from a client area "here's  
what one of our worker bees entered but it didn't "take", figure out the  
bug". Well actually MOST of the time no bug. Just a typo, what was on  
the piece of paper (as what was entered) didn't match what the worker  
bee actually entered at

Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

[Michael or Penny Novack]

And in that case of 'breadcrumbs' the entirety of GnuCash is an audit 
trail, as that is how double-entry accounting works.


If you are looking for some record of exactly who entered which 
transactions and the date/time stamps, no, that is not available. 
Technically I think the posting date/time does get recorded, but it is 
not readily available to users. If you really need it, perhaps start a 
thread just on that question.


Certainly the 'who' will be impossible, because GnuCash is not a 
multi-user application. Whomever has access to run the app, and access 
to the file, can post or edit transactions. 


As somebody who used to do this (for one of the world's largest 
"financials") my comment might (or might not) be useful.


a) The accounting system itself (its own reporting functions) would not 
provide a way of reporting when/who by. It is important to understand 
that this information is NOT part of the accounting system. Accounting 
is not a "real time" process nor would who by (what worker bee) be 
relevant to the question of correctness in an accounting sense.


b) But there are OTHER ways in which general ledger might be audited. 
Internally correct is one matter, but externally correct is another. For 
example,here we have an invoice marked paid by check. But WAS there 
actually such a check, and if not, who (falsely) entered that invoice as 
paid and when. How many of you when first learning to use gnucash 
created a set of "test books" and into these entered a number of "test 
transactions"? Understand? There was nothing wrong internally with this 
set of test books you were using to learn gnucash but they matched 
nothing in the real world.


c) Like I said, there would be no functions PART of the accounting 
system to be used for this sort of purpose. But when the auditors 
(checking against the real world) found something suspicious, this sort 
of problem would come t my desk. "Mike, figure out who entered THIS 
transaction and when". So I would figure out what feed to the system 
would have fed that transaction to general ledger, get the right backup 
tape recovered from the vaults, and with a little "ad hoc" program I'd 
write for the purpose, get that information. It's not as if I'd be 
writing a lot of these ad hoc programs from scratch, just take to one I 
used last time and change a line or two of code.


   THIS sort of "check against the real world" was rare. I [probably 
did only a few times a year. More often it was personal and quickly 
enough after that fact I didn't have to have backups recovered from the 
vault. Thus suppose I was handed a problem from a client area "here's 
what one of our worker bees entered but it didn't "take", figure out the 
bug". Well actually MOST of the time no bug. Just a typo, what was on 
the piece of paper (as what was entered) didn't match what the worker 
bee actually entered at the terminal. We all do typos, and that's how I 
would report the problem as solved. No harm done. I probably did a few 
of THESE per week. It'd have been a waste of programmer time my handing 
off to one of our programmers to try to find a bug that didn't exist.


Michael D Novack






___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

[Adrien Monteleone]

Glad to have pointed you in the right direction.

And in that case of 'breadcrumbs' the entirety of GnuCash is an audit 
trail, as that is how double-entry accounting works.


If you are looking for some record of exactly who entered which 
transactions and the date/time stamps, no, that is not available. 
Technically I think the posting date/time does get recorded, but it is 
not readily available to users. If you really need it, perhaps start a 
thread just on that question.


Certainly the 'who' will be impossible, because GnuCash is not a 
multi-user application. Whomever has access to run the app, and access 
to the file, can post or edit transactions.


*note, on the point of timestamps, I don't think *edits* get a stamp, so 
only the original entry is dated, which is likely of little 'audit' 
utility. Perhaps, if you save all log files, you might be able to 
reconstruct timings of when edits were made, but of course, those logs 
themselves are editable, so certainly not useful in a real audit.


Regards,
Adrien

On 10/1/22 7:52 PM, Uttam Chakravorty wrote:

I used 'breadcrumb' as an alternative to 'audit trail'.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

[Uttam Chakravorty]

Dear Adrien



Your advice meets all my needs.  Many thanks to all the others who offered 
advice, they add to my knowledge.  Its good to know I was peering through the 
wrong end of the telescope.



I used 'breadcrumb' as an alternative to 'audit trail'.


Buoyed by the wonderful support I have received I would like to ask the 
community another question.  I will raise it as a separate topic = 'Reconciling 
subaccounts'.


Many thanks again, Uttam



 From:   Adrien Monteleone  
 To:
 Sent:   30/09/2022 7:23 PM 
 Subject:   Re: [GNC] Reconciliation Report -> Trade Debtors -> pairing 
transactions 

On 9/30/22 12:48 PM, Uttam Chakravorty wrote: 
> Dear All, 
>  
> I am using the Reconciliation Report configured as: 
>  
>  
>  
> Accounts = Trade Debtors ->Currency / Display / Filter = defaults -> 
> General - current period selected -> 
>  
> Sorting by Description then Date. 
>  
>  
> Is there a way to use this pool of information and pair a receipt with an 
> Invoice as per the case when the transaction was entered? 
 
If you mean to match up payments with Invoices, yes, but not with that  
report. What you are looking for is the Customer Report. (Reports >  
Business > Customer Report — or from an Accounts Payable Report, click  
an *amount* for a customer.) 
 
You'll want to set Options > Display Columns > Transaction Links to  
either 'simple' or 'detailed' per your preference for the level of  
information. (I personally like detailed best) 
 
Note, this requires using the Business Features to enter invoices &  
payments. (using the Process Payment feature to link payments to invoices) 
 
The result is a Statement of Account type report showing which payments  
were applied to which invoices & vice versa. 
 
 
> Is there a breadcrumb trail? 
 
Not sure what you mean by this. 'Breadcrumbs' leading you from where to  
where? 
 
Regards, 
Adrien 
 
 
 



If this email has been sent to you in error please delete it and accept my 
apologies
Company number: 4324700

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

[Adrien Monteleone]

The Business Features handle all of that with ease. There is no need for 
myriad accounts or convoluted account structure.


"invoices as sub-categories for each business"? What is that about?

The official process is fairly simple and straightforward.

Set up Customers.

Post Invoices linked to those Customers for services rendered/goods sold.

Process Payments on those invoices.

Run a Customer Report to see their balance and activity. (and aging too!)

No need for separate accounts under A/R, just create Customers and 
GnuCash will handle it.


Regards,
Adrien

On 9/30/22 1:35 PM, R Losey wrote:

Would it help to have each client as an account? (to easily see the
balances)

Alternatively, I assume you already ask them to put the invoice number of
the receipts, but some do not do so... perhaps when you issue bills, it can
have a matching part that they return... this would help you pair invoices
with receipts.

It would be a lot of accounts, but you could set up invoices as
sub-categories for each business.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

[R Losey]

Would it help to have each client as an account? (to easily see the
balances)

Alternatively, I assume you already ask them to put the invoice number of
the receipts, but some do not do so... perhaps when you issue bills, it can
have a matching part that they return... this would help you pair invoices
with receipts.

It would be a lot of accounts, but you could set up invoices as
sub-categories for each business.

On Fri, Sep 30, 2022 at 12:50 PM Uttam Chakravorty 
wrote:

> Dear All,
>
> I am using the Reconciliation Report configured as:
>
>
>
> Accounts = Trade Debtors ->Currency / Display / Filter = defaults ->
> General - current period selected ->
>
> Sorting by Description then Date.
>
>
> Is there a way to use this pool of information and pair a receipt with an
> Invoice as per the case when the transaction was entered?
> Is there a breadcrumb trail?
> Am I going about this the wrong way?
>
>
> Background: we are a small business supporting small businesses.  We are
> sympathetic to some clients needing to pay us monthly.  However simple we
> try to be a few still manage to lose their way and then we have to go back
> and match receipts to invoices made difficult by the fact that the monthly
> sums are the same.  The good thing is if we hold their hand eventually they
> get organised and the problem goes away.  Sadly we have only managed to use
> this as an opportunity to move them to Gnucash on only one occasion so
> far.  We live in hope.
>
>
> --
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report -> Trade Debtors -> pairing transactions

[Adrien Monteleone]

On 9/30/22 12:48 PM, Uttam Chakravorty wrote:

Dear All,

I am using the Reconciliation Report configured as:



Accounts = Trade Debtors ->Currency / Display / Filter = defaults ->
General - current period selected ->

Sorting by Description then Date.


Is there a way to use this pool of information and pair a receipt with an 
Invoice as per the case when the transaction was entered?


If you mean to match up payments with Invoices, yes, but not with that 
report. What you are looking for is the Customer Report. (Reports > 
Business > Customer Report — or from an Accounts Payable Report, click 
an *amount* for a customer.)


You'll want to set Options > Display Columns > Transaction Links to 
either 'simple' or 'detailed' per your preference for the level of 
information. (I personally like detailed best)


Note, this requires using the Business Features to enter invoices & 
payments. (using the Process Payment feature to link payments to invoices)


The result is a Statement of Account type report showing which payments 
were applied to which invoices & vice versa.




Is there a breadcrumb trail?


Not sure what you mean by this. 'Breadcrumbs' leading you from where to 
where?


Regards,
Adrien


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Reconciliation Report Additions

[Stephen M. Butler]

Chris was working on it early in the summer (or late spring).  Other
items got in the way and I'm not sure where it is at now (I was doing
some testing for him).


On 12/8/19 12:00 PM, Mike stagl wrote:
> I know this has been mentioned more than once in the past...
>
> Has anyone yet created a custom reconciliation report that adds to the
> report the current account balance?  Perhaps even the current
> reconciled balance and the current available balance?
>
> My non-profit requires non-executives to audit my monthly
> reconciliations.  At present, all I can do is show that my GnuCash
> "Funds In" and "Funds Out" match the bank statement.  It would be very
> helpful for GnuCash to print the current Reconciled Balance to show
> that my records match the Bank Statement exactly.
>
> I have tried to delve into building a custom report myself but the
> language and syntax quickly stops me!
>
> Thanks to all the contributors,
>
> Mike
>
>
> ___
> 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 Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[Christopher Lam]

The "Reconciliation Report" was modified to search via Reconciliation 
Date as per following bug. https://bugs.gnucash.org/show_bug.cgi?id=796614


I think the date filter is irrelevant in the reconciliation report.

Perhaps it should be removed altogether; and should by default show 
*all* unreconciled & cleared (i.e. exclude reconciled) transactions?


C

On 13/1/19 1:44 am, Adrien Monteleone wrote:

I just discovered the same thing myself yesterday. (I never use the report) I 
can’t imagine what utility that has. I also think it is a bug since the primary 
sort order was ‘date’ and there was an option to choose ‘reconciled date’ 
instead, but the general tab date range only operates on reconciled date.

This is quite strange. I certainly didn’t expect that behavior.

If one edits a transaction that is reasonably far back in history (say for some 
minor spelling error, or a refactoring of expense accounts) which then gets the 
reconcile flag unset and you have to re-reconcile to reset it, now that old 
transaction is going to show up on your current reconciliation report.

I had to re-reconcile some periods from 2016 not long ago for this very reason. 
When I ran the report yesterday to see reconciled transactions from 2018, I had 
old transactions mixed in. It seems it is impossible to get a report (without 
resorting to a spreadsheet workflow) that shows me what I wanted to see. (yes, 
I can run a filter on the register and then run a register report - I’m talking 
about using *this* report)

Is that intended?

With no way out?

Regards,
Adrien



On Jan 12, 2019, at 10:32 AM, Stephen M. Butler  wrote:

On 1/12/19 12:20 AM, Liz wrote:

On Sun, 6 Jan 2019 14:44:56 -0600 (CST)
David Cousens  wrote:


Steve,

I just ran it on an account in my recordsin 3.4  and it worked fine.
I had to explicitly select the account/accounts and period it was to
be prepared for in the Accounts tab in the Report Options dialog
(Edit Menu) once I had opened the report (initially blank) and then
the entries all came up.

David


I was just experimenting here (Debian Buster/Sid; Gnucash 3.4+ 30/12/18)

I opened the reconciliation report
Select options
Select an asset account, apply
All I had was the unreconciled amounts

Try a second and a third account, with the dates set to beginning of
last quarter to end of last quarter.
I got the reconciled and the unreconciled amounts (which I was
expecting)

Tried first account again, wouldn't change to the altered dates,
wouldn't show the reconciled amounts. Reload made no difference.

I closed Gnucash, restarted and tried again with identical results.
Output.pdf is the first account, not showing a large number of
reconciled transactions (77 missing transactions)
Output1.pdf is the second account.

Liz


I found that my reconciliation date was in 2019 while I was running the
report thru the end of 2018.  Once I opened up the dates to include up
through "Today", the reports worked.

Reminder (to self), dates on the reconciliation report are not the
transaction dates.  Instead, they are the reconciliation date!
Important difference.

--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[Adrien Monteleone]

I just discovered the same thing myself yesterday. (I never use the report) I 
can’t imagine what utility that has. I also think it is a bug since the primary 
sort order was ‘date’ and there was an option to choose ‘reconciled date’ 
instead, but the general tab date range only operates on reconciled date.

This is quite strange. I certainly didn’t expect that behavior.

If one edits a transaction that is reasonably far back in history (say for some 
minor spelling error, or a refactoring of expense accounts) which then gets the 
reconcile flag unset and you have to re-reconcile to reset it, now that old 
transaction is going to show up on your current reconciliation report.

I had to re-reconcile some periods from 2016 not long ago for this very reason. 
When I ran the report yesterday to see reconciled transactions from 2018, I had 
old transactions mixed in. It seems it is impossible to get a report (without 
resorting to a spreadsheet workflow) that shows me what I wanted to see. (yes, 
I can run a filter on the register and then run a register report - I’m talking 
about using *this* report)

Is that intended?

With no way out?

Regards,
Adrien


> On Jan 12, 2019, at 10:32 AM, Stephen M. Butler  wrote:
> 
> On 1/12/19 12:20 AM, Liz wrote:
>> On Sun, 6 Jan 2019 14:44:56 -0600 (CST)
>> David Cousens  wrote:
>> 
>>> Steve,
>>> 
>>> I just ran it on an account in my recordsin 3.4  and it worked fine.
>>> I had to explicitly select the account/accounts and period it was to
>>> be prepared for in the Accounts tab in the Report Options dialog
>>> (Edit Menu) once I had opened the report (initially blank) and then
>>> the entries all came up.
>>> 
>>> David
>>> 
>> I was just experimenting here (Debian Buster/Sid; Gnucash 3.4+ 30/12/18)
>> 
>> I opened the reconciliation report
>> Select options
>> Select an asset account, apply
>> All I had was the unreconciled amounts
>> 
>> Try a second and a third account, with the dates set to beginning of
>> last quarter to end of last quarter.
>> I got the reconciled and the unreconciled amounts (which I was
>> expecting)
>> 
>> Tried first account again, wouldn't change to the altered dates,
>> wouldn't show the reconciled amounts. Reload made no difference.
>> 
>> I closed Gnucash, restarted and tried again with identical results.
>> Output.pdf is the first account, not showing a large number of
>> reconciled transactions (77 missing transactions)
>> Output1.pdf is the second account.
>> 
>> Liz
> 
> 
> I found that my reconciliation date was in 2019 while I was running the
> report thru the end of 2018.  Once I opened up the dates to include up
> through "Today", the reports worked.
> 
> Reminder (to self), dates on the reconciliation report are not the
> transaction dates.  Instead, they are the reconciliation date! 
> Important difference.
> 
> -- 
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
> 
> ___
> 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 Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[Stephen M. Butler]

On 1/12/19 12:20 AM, Liz wrote:
> On Sun, 6 Jan 2019 14:44:56 -0600 (CST)
> David Cousens  wrote:
>
>> Steve,
>>
>> I just ran it on an account in my recordsin 3.4  and it worked fine.
>> I had to explicitly select the account/accounts and period it was to
>> be prepared for in the Accounts tab in the Report Options dialog
>> (Edit Menu) once I had opened the report (initially blank) and then
>> the entries all came up.
>>
>> David
>>
> I was just experimenting here (Debian Buster/Sid; Gnucash 3.4+ 30/12/18)
>
> I opened the reconciliation report
> Select options
> Select an asset account, apply
> All I had was the unreconciled amounts
>
> Try a second and a third account, with the dates set to beginning of
> last quarter to end of last quarter.
> I got the reconciled and the unreconciled amounts (which I was
> expecting)
>
> Tried first account again, wouldn't change to the altered dates,
> wouldn't show the reconciled amounts. Reload made no difference.
>
> I closed Gnucash, restarted and tried again with identical results.
> Output.pdf is the first account, not showing a large number of
> reconciled transactions (77 missing transactions)
> Output1.pdf is the second account.
>
> Liz


I found that my reconciliation date was in 2019 while I was running the
report thru the end of 2018.  Once I opened up the dates to include up
through "Today", the reports worked.

Reminder (to self), dates on the reconciliation report are not the
transaction dates.  Instead, they are the reconciliation date! 
Important difference.

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[David Cousens]

Just helps me make sure I put things in the right account type



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[Finbar Mahon]

Wow, very comprehensive, love the colour scheme ;-)

On 06/01/2019 23:17, David Cousens wrote:

Steve,

The attached screenshot shows what I get and the Report Options setting I
used. Have you tried saving, closing GnuCash and Opening again? (I have
closed and reopened Gnucash since putting that data in 2 days ago).

screen_20180107.jpg


David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[Stephen M. Butler]

On 1/6/19 5:29 PM, David Cousens wrote:
> Steve,
>
> I must confess I agree with your wife. I would like to see a Starting
> Balance and a Closing Balance in the report as well as the transactions in
> and out fro the period of the report along with outstanding transactions .
> Makes it much easier to isolate problems. I would expect to get something I
> could compare directly with an external statement for the same period.
>
> Additionally I would expect a signoff that the report matched the external
> statement and a signature and date although that could be easily added by
> hand.
>
> Maybe an enhancement request is justified.
>
> David


Feel free to add to the one I just created.

>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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 Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[David Cousens]

Steve,

I must confess I agree with your wife. I would like to see a Starting
Balance and a Closing Balance in the report as well as the transactions in
and out fro the period of the report along with outstanding transactions .
Makes it much easier to isolate problems. I would expect to get something I
could compare directly with an external statement for the same period.

Additionally I would expect a signoff that the report matched the external
statement and a signature and date although that could be easily added by
hand.

Maybe an enhancement request is justified.

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[Stephen M. Butler]

On 1/6/19 4:03 PM, Christopher Lam wrote:
> Hi Stephen
>
> Both your questions are answerable
>
>> When doing double columns for the amount (DR/CR), the sub-totals/totals
>> only show the combined total.  Is there an option to show the totals per
>> column?  (similar to what the Reconciliation report shows).
>
>
> There's no option to disable double-column combined total. To change
> this behaviour will require hacking report code.
Enhancement request 797020 filed.
>  
>
> On 7/1/19 7:15 am, Stephen M. Butler wrote:
>> David,
>>
>> The wife took one look and sighed deeply "This is not a reconciliation
>> report".
>>
>> So, a little clicking of options and it came closer (I was showing
>> multi-line and reduced that to single line).
>>
>> However, she is still upset that the account balance (as of the
>> reconciliation date) doesn't show.  I don't see an option to do that?
> Please file a bug as enhancement-request and this can be discussed.


Enhancement request 797019 filed.


Who knows, if I get the Ubuntu PPA figured out, I might be able to
tackle one or both of these.  Looks like it is in the same source code file.

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[Christopher Lam]

Hi Stephen

Both your questions are answerable


When doing double columns for the amount (DR/CR), the sub-totals/totals
only show the combined total.  Is there an option to show the totals per
column?  (similar to what the Reconciliation report shows).



There's no option to disable double-column combined total. To change this 
behaviour will require hacking report code.
 


On 7/1/19 7:15 am, Stephen M. Butler wrote:

David,

The wife took one look and sighed deeply "This is not a reconciliation
report".

So, a little clicking of options and it came closer (I was showing
multi-line and reduced that to single line).

However, she is still upset that the account balance (as of the
reconciliation date) doesn't show.  I don't see an option to do that?

Please file a bug as enhancement-request and this can be discussed.
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[Stephen M. Butler]

On 1/6/19 2:17 PM, David Cousens wrote:
> Steve,
>
> The attached screenshot shows what I get and the Report Options setting I
> used. Have you tried saving, closing GnuCash and Opening again? (I have
> closed and reopened Gnucash since putting that data in 2 days ago).
>
> screen_20180107.jpg
>   
>
> David

David,

Thanks for hanging in there with me.  I must confess that I'm going to
pull the frying pan out and fry those eggs on my face.  I'll remove the
face first.

So, this also turned out to be a misunderstanding around the Date
selection.  While all the transactions were in 2018, they were
reconciled earlier this morning.  So, I had to expand the dates to
include today!

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[David Cousens]

Steve,

The attached screenshot shows what I get and the Report Options setting I
used. Have you tried saving, closing GnuCash and Opening again? (I have
closed and reopened Gnucash since putting that data in 2 days ago).

screen_20180107.jpg
  

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[Stephen M. Butler]

On 1/6/19 12:44 PM, David Cousens wrote:
> Steve,
>
> I just ran it on an account in my recordsin 3.4  and it worked fine. I had
> to explicitly select the account/accounts and period it was to be prepared
> for in the Accounts tab in the Report Options dialog (Edit Menu) once I had
> opened the report (initially blank) and then the entries all came up.
>
> David
As you can see I have the Checking account selected and picked the
prev-year start/end.  No matching transactions.


Reconciliation Report:


No matching transactions found

No transactions were found that match the time interval and account
selection specified in the Options panel.

Edit report options 

*Sorting / Primary Key* : reconciled-status
*Sorting / Secondary Subtotal for Date Key* : none
*Sorting / Secondary Key* : date
*Display / Memo* : Disabled
*Display / Reconciled Date* : Enabled
*Display / Detail Level* : multi-line
*Accounts / Accounts* : Checking
*General / Start Date* : relative . start-prev-year
*General / End Date* : relative . end-prev-year

If I select all accounts, then I see the non-reconciled transactions
(for all the other accounts), but not the reconciled transactions).





-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8


___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report -- Can't find transactions

[David Cousens]

Steve,

I just ran it on an account in my recordsin 3.4  and it worked fine. I had
to explicitly select the account/accounts and period it was to be prepared
for in the Accounts tab in the Report Options dialog (Edit Menu) once I had
opened the report (initially blank) and then the entries all came up.

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[Christopher Lam]

Hi Mike


Perhaps your report would need to set "Filter / Reconcile Status" then?


C


On 12/08/18 05:03, Mike stagl wrote:


That was my suspicion. I am trying to print reports for archiving to 
show that our account was reconciled to the prior month's bank statement.



I am able to show what I need to show in the Reconciliation Report, I 
was just hoping to be able to remove the transactions after the first 
of the current month as they are not needed for my purposes.



Thanks for the help!


Mike




*From:* Christopher Lam 
*Sent:* Friday, August 10, 2018 12:19 PM
*To:* gnucash-user@gnucash.org
*Subject:* Re: [GNC] Reconciliation Report
The reconcile report 'date' selection applies to the 'reconcile date',
so any reconciled transaction whose reconcile-date falls between
start-date and end-date is included. I think this behaviour applies from
3.2 onwards.

Any unreconciled transactions are also included. The reasoning was that
any unreconciled transactions were deemed likely to be useful in a
reconciliation report. This also roughly matches the behaviour of the
formal reconcile tool -- it lists any cleared or unreconciled
transactions (income on left, expense on right), ready for ticking prior
to clicking 'Finalise'.


On 11/08/18 01:04, Mike stagl wrote:
> Sorry, I forgot the basics.  GnuCash 3.2 on Windows 7.
>
>
> I've attached a screenshot as well.
>
> Thanks in advance!
>
>
> Mike
>
> 
> From: David Carlson 
> Sent: Friday, August 10, 2018 11:23 AM
> To: Mike stagl
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Reconciliation Report
>
> Which version of GnuCash are you using and which OS?
>
> On Fri, Aug 10, 2018 at 8:59 AM, Mike stagl 
mailto:m_st...@hotmail.com>> wrote:
> When running a stock reconciliation report, I cannot get the Start 
Date and End Date to work correctly.  If I choose Start of Previous 
Month and End of Previous Month, or even use actual dates, I get 
transactions from the start date all the way to the current date.

>
>
> This month I am seeing un-reconciled transactions from August, when 
I am running a report with the dates 7/1/2018 to 7/31/2018.

>
>
> For what it's worth, other reports appear to correctly implement the 
date.

>
>
> Thanks for any help,
>
>
> Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
gnucash-user Info Page 
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>

lists.gnucash.org
This (occasionally high-volume) mailing list is devoted to the 
discussion of general accounting topics as well as how to use GnuCash 
to implement specific



> If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists 
<https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.

> -
> 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists 
<https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.

> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[Mike stagl]

That was my suspicion.  I am trying to print reports for archiving to show that 
our account was reconciled to the prior month's bank statement.


I am able to show what I need to show in the Reconciliation Report, I was just 
hoping to be able to remove the transactions after the first of the current 
month as they are not needed for my purposes.


Thanks for the help!


Mike



From: Christopher Lam 
Sent: Friday, August 10, 2018 12:19 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Reconciliation Report

The reconcile report 'date' selection applies to the 'reconcile date',
so any reconciled transaction whose reconcile-date falls between
start-date and end-date is included. I think this behaviour applies from
3.2 onwards.

Any unreconciled transactions are also included. The reasoning was that
any unreconciled transactions were deemed likely to be useful in a
reconciliation report. This also roughly matches the behaviour of the
formal reconcile tool -- it lists any cleared or unreconciled
transactions (income on left, expense on right), ready for ticking prior
to clicking 'Finalise'.


On 11/08/18 01:04, Mike stagl wrote:
> Sorry, I forgot the basics.  GnuCash 3.2 on Windows 7.
>
>
> I've attached a screenshot as well.
>
> Thanks in advance!
>
>
> Mike
>
> 
> From: David Carlson 
> Sent: Friday, August 10, 2018 11:23 AM
> To: Mike stagl
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Reconciliation Report
>
> Which version of GnuCash are you using and which OS?
>
> On Fri, Aug 10, 2018 at 8:59 AM, Mike stagl 
> mailto:m_st...@hotmail.com>> wrote:
> When running a stock reconciliation report, I cannot get the Start Date and 
> End Date to work correctly.  If I choose Start of Previous Month and End of 
> Previous Month, or even use actual dates, I get transactions from the start 
> date all the way to the current date.
>
>
> This month I am seeing un-reconciled transactions from August, when I am 
> running a report with the dates 7/1/2018 to 7/31/2018.
>
>
> For what it's worth, other reports appear to correctly implement the date.
>
>
> Thanks for any help,
>
>
> Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
gnucash-user Info Page<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
lists.gnucash.org
This (occasionally high-volume) mailing list is devoted to the discussion of 
general accounting topics as well as how to use GnuCash to implement specific


> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[Christopher Lam]

The reconcile report 'date' selection applies to the 'reconcile date', 
so any reconciled transaction whose reconcile-date falls between 
start-date and end-date is included. I think this behaviour applies from 
3.2 onwards.


Any unreconciled transactions are also included. The reasoning was that 
any unreconciled transactions were deemed likely to be useful in a 
reconciliation report. This also roughly matches the behaviour of the 
formal reconcile tool -- it lists any cleared or unreconciled 
transactions (income on left, expense on right), ready for ticking prior 
to clicking 'Finalise'.



On 11/08/18 01:04, Mike stagl wrote:

Sorry, I forgot the basics.  GnuCash 3.2 on Windows 7.


I've attached a screenshot as well.

Thanks in advance!


Mike


From: David Carlson 
Sent: Friday, August 10, 2018 11:23 AM
To: Mike stagl
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Reconciliation Report

Which version of GnuCash are you using and which OS?

On Fri, Aug 10, 2018 at 8:59 AM, Mike stagl 
mailto:m_st...@hotmail.com>> wrote:
When running a stock reconciliation report, I cannot get the Start Date and End 
Date to work correctly.  If I choose Start of Previous Month and End of 
Previous Month, or even use actual dates, I get transactions from the start 
date all the way to the current date.


This month I am seeing un-reconciled transactions from August, when I am 
running a report with the dates 7/1/2018 to 7/31/2018.


For what it's worth, other reports appear to correctly implement the date.


Thanks for any help,


Mike
___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[David Carlson]

Which version of GnuCash are you using and which OS?

On Fri, Aug 10, 2018 at 8:59 AM, Mike stagl  wrote:

> When running a stock reconciliation report, I cannot get the Start Date
> and End Date to work correctly.  If I choose Start of Previous Month and
> End of Previous Month, or even use actual dates, I get transactions from
> the start date all the way to the current date.
>
>
> This month I am seeing un-reconciled transactions from August, when I am
> running a report with the dates 7/1/2018 to 7/31/2018.
>
>
> For what it's worth, other reports appear to correctly implement the date.
>
>
> Thanks for any help,
>
>
> Mike
> ___
> 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 Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation Report

[Christopher Lam]

Which version? There was a change in date strategy for reconciliation 
report in the past couple releases.


Would you mind attaching a screenshot?

If you need to hide sensitive data, any paint program such as MSPaint 
can hide data.


Please switch option "General / Add options summary" to "always".


On 10/08/18 21:59, Mike stagl wrote:

When running a stock reconciliation report, I cannot get the Start Date and End 
Date to work correctly.  If I choose Start of Previous Month and End of 
Previous Month, or even use actual dates, I get transactions from the start 
date all the way to the current date.


This month I am seeing un-reconciled transactions from August, when I am 
running a report with the dates 7/1/2018 to 7/31/2018.


For what it's worth, other reports appear to correctly implement the date.


Thanks for any help,


Mike
___
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 Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.