Re: [GNC] Reconciliation Report

2022-10-05 Thread 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

Re: [GNC] Reconciliation Report

2022-10-04 Thread 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

[GNC] Reconciliation Report

2022-10-04 Thread Nathan Rosenthal
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

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

2022-10-03 Thread 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

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

2022-10-03 Thread Uttam Chakravorty
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 -> p

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

2022-10-02 Thread 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

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

2022-10-01 Thread 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

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

2022-10-01 Thread Uttam Chakravorty
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 -> p

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

2022-10-01 Thread 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

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

2022-09-30 Thread flywire
This is similar to rental payments but my experience is with cash accounting. It is easy to skip an invoice and in my jurisdiction, this eventually means it isn't required to be paid. I'd suggest providing a statement instead of pairing payments and invoices so payments are applied to the oldest

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

2022-09-30 Thread 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

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

2022-09-30 Thread 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

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

2022-09-30 Thread Uttam Chakravorty
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

Re: [GNC] Reconciliation Report Additions

2019-12-08 Thread 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

[GNC] Reconciliation Report Additions

2019-12-08 Thread Mike stagl
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

[GNC] Reconciliation Report Problem

2019-07-21 Thread sdan45
I have an account that I've reconciled and everything goes great doing that. The problem comes in when trying to do the reconciliation report. Here's what's going on. My beginning balance was on 6/21/2019 and the ending date is 7/19/2019. When I enter those beginning and ending dates in the

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

2019-01-12 Thread 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*

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

2019-01-12 Thread 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

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

2019-01-12 Thread 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

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

2019-01-07 Thread 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

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

2019-01-07 Thread 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

Re: [GNC] Reconciliation Report

2019-01-06 Thread 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

Re: [GNC] Reconciliation Report

2019-01-06 Thread 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

Re: [GNC] Reconciliation Report

2019-01-06 Thread 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

Re: [GNC] Reconciliation Report

2019-01-06 Thread 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

[GNC] Reconciliation Report

2019-01-06 Thread Stephen M. Butler
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

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

2019-01-06 Thread 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 >

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

2019-01-06 Thread 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

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

2019-01-06 Thread 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

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

2019-01-06 Thread 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

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

2019-01-06 Thread Stephen M. Butler
O/S:  Ubuntu 18.04 GnC:  3.4-18  (just recompiled after git pull) I have entered transactions for 2018 for a new startup company.  Only a handful of transactions.  Ran the reconciliation for the year.  Now my wife wants the reconciliation report to show that the checking account was reconciled

Re: [GNC] Reconciliation Report

2018-08-11 Thread Mike stagl
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

Re: [GNC] Reconciliation Report

2018-08-10 Thread Christopher Lam
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

Re: [GNC] Reconciliation Report

2018-08-10 Thread 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

Re: [GNC] Reconciliation Report

2018-08-10 Thread 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

[GNC] Reconciliation Report

2018-08-10 Thread Mike stagl
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