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

[GNC] Fwd: Reconciliation Report

2022-10-04 Thread David Carlson
Nathan, Please reply to all so the group can follow the thread. This time, since I missed that you didn't, I will forward this to the group. -- Forwarded message - From: David Carlson Date: Tue, Oct 4, 2022 at 6:45 PM Subject: Re: [GNC] Reconciliation Report To: Nathan

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

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

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

Re: [GNC] Reconciliation Report Additions

2019-12-08 Thread Stephen M. Butler
t 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

[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

Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-04 Thread Adrien Monteleone
. To explain the report more: If you reconciled transactions from June in your July reconciliation, then yes, they should appear in the July Reconciliation Report because they are part of the formula that got you from the balance on 6/30/19 to the balance on 7/31/19. And they should also show up

Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-04 Thread Dale Alspach
this is just about my personal finances: checking > account, credit cards, and so on. Nothing that will be audited, nor > likely requested by an accountant. What I am used to > seeing in a reconciliation report is (a) a list of cleared > transactions for the period covered by the current

Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-04 Thread Art Chimes
edit cards, and so on. Nothing that will be audited, nor likely requested by an accountant. What I am used to seeing in a reconciliation report is (a) a list of cleared transactions for the period covered by the current statement, the one I have just reconciled; and (b) a list of transactions t

Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-03 Thread Christopher Lam
onciled transactions? If this is the case please file bug. On Sat, 3 Aug 2019 at 13:58, Art Chimes wrote: > I want to produce a Reconciliation Report for a credit card account. I set > the date range to correspond to the period covered by the statement. What I > get, however, is a report t

Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-03 Thread David Carlson
e, as adrian suggests, there may be a better > one. > > On Sat, Aug 3, 2019, 12:24 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> The Reconciliation Report shows transactions *reconciled* during the >> period chosen, not necessarily transaction

Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-03 Thread David Carlson
Arr, If you are trying to match your bank statement, that report seems to be the one you want. Otherwise, as adrian suggests, there may be a better one. On Sat, Aug 3, 2019, 12:24 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Reconciliation Report shows tra

Re: [GNC] Last month's transactions included in Reconciliation Report

2019-08-03 Thread Adrien Monteleone
The Reconciliation Report shows transactions *reconciled* during the period chosen, not necessarily transactions that *occurred* during the period chosen. If you want a report of reconciled transactions that occurred during a certain period, open that account register, go to View > Fil

[GNC] Last month's transactions included in Reconciliation Report

2019-08-03 Thread Art Chimes
I want to produce a Reconciliation Report for a credit card account. I set the date range to correspond to the period covered by the statement. What I get, however, is a report that includes all of last month's transactions. This is apparently because those transactions were *reconciled* within

[GNC] Problem with reconciliation report dates

2019-07-21 Thread sdan45
I'm trying to reconcile my account. The beginning date is on 6/21/2019 and the ending date is 7/19/2019. The actually reconciliation when fine. The problem comes in the report section, when I enter the beginning and ending dates as shown above it wants to give me dates starting with 5/21/2019.

[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

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

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

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

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

2019-01-12 Thread Stephen M. Butler
gt; 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) > >

Re: [GNC] Bank Reconciliation Report with Beginning and Ending Balances

2019-01-11 Thread Adrien Monteleone
be reconciled. (indicating transactions left to reconcile, or an adjusting entry needs to be made) Note that you can leave that window open as long as you like. You don’t have to complete the reconciliation in one go. 2. Run the reconciliation report, and either export or copy/paste

Re: [GNC] Bank Reconciliation Report with Beginning and Ending Balances

2019-01-11 Thread Mark Phillips
en use the report configuration options to define what I want in the report. Sorry to be shooting in the dark for your answer. Your images did not come through. Mark On Fri, Jan 11, 2019 at 12:11 PM eNews wrote: > I have run the reconciliation report for my checking account; however, it >

[GNC] Bank Reconciliation Report with Beginning and Ending Balances

2019-01-11 Thread eNews
I have run the reconciliation report for my checking account; however, it only shows the "funds in" and the "funds out" for the period. I was hoping for a more traditional reconciliation that shows the ending balance that I can agree to my bank statement. If this can be done,

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
gt; 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 th

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 double

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

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

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

Re: [GNC] Reconciliation Report

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

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

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 su

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

Re: Reconciliation Report

2017-12-03 Thread David Carlson
ne. 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 utili

Re: Reconciliation Report

2017-12-02 Thread 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 b

Re: Reconciliation Report

2017-12-02 Thread 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 sys

RE: Reconciliation Report

2017-11-30 Thread 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

Reconciliation Report

2017-11-29 Thread Rick Halvorson
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