gnucash-user Digest, Vol 179, Issue 34
Jon Schewe
jpschewe at gmail.com
Sun Feb 11 09:40:46 EST 2018
If you subscribe to getting all messages instead of the digest, then most
mail clients will do this. I use both Gmail and Thunderbird and they work
nicely for lists like this.
Then adding a filter to put the list messages in a separate folder so that
I can read it later.
On Sat, Feb 10, 2018, 00:37 Roger Hatton <roghat3 at gmail.com> wrote:
> I hope this is the correct way to start a new topic?
>
> Quote
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
> Unquote
>
> New Topic ... Threaded Discussions
>
> While I am immensely impressed with the speed and diligence shown
> in these messages (particularly to new unskilled members) I do
> wonder whether there is not much better software for
> topic discussions where each thread has its
> original title and the discussion of
> each topic is separate using
> dated messages, and
> author names in
> a clear format.
>
> The message board systems I've encountered have this extra clarity.
> Are there no free ones?
>
> On Sat, Feb 10, 2018 at 3:13 PM, <gnucash-user-request at gnucash.org> wrote:
>
> > Send gnucash-user mailing list submissions to
> > gnucash-user at gnucash.org
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > or, via email, send a message with subject or body 'help' to
> > gnucash-user-request at gnucash.org
> >
> > You can reach the person managing the list at
> > gnucash-user-owner at gnucash.org
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of gnucash-user digest..."
> >
> >
> > Today's Topics:
> >
> > 1. Re: Check writing (Ronal B Morse)
> > 2. Re: Check writing (David Carlson)
> > 3. Re: gnucash-user Digest, Vol 179, Issue 33 (Roger Hatton)
> > 4. Re: 13 Column Reporting Starting July ending June plus Total (D)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Fri, 9 Feb 2018 19:25:07 -0700
> > From: Ronal B Morse <ron at morsehouse.com>
> > To: gnucash-user at gnucash.org
> > Subject: Re: Check writing
> > Message-ID: <01b8614e-734d-af03-18f9-e52758440f8e at morsehouse.com>
> > Content-Type: text/plain; charset=utf-8; format=flowed
> >
> > On 02/09/2018 01:39 PM, Ronald Mocny via gnucash-user wrote:
> > > Can I write checks in GnuCash and if so is it compatible with
> > > VersaCheck. Thanks
> > >
> >
> > I'm not familiar with Versacheck, but GnuCash has a flexible and fully
> > user configurable check writing facility.? Personally, the pre-defined
> > Quicken three-part voucher check option meets my needs.
> >
> > At the beginning of every month I pay ten - twelve bills by check with
> > GNC and it's a simple and easy task.? The hardest part is remembering
> > which way to feed the blank forms into whatever printer I'm using at the
> > time.
> >
> > If your forms have accompanying window envelopes, GNC does the
> > addressing, too.
> >
> > RBM
> >
> >
> >
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Fri, 9 Feb 2018 20:53:11 -0600
> > From: David Carlson <david.carlson.417 at gmail.com>
> > To: Ronal B Morse <ron at morsehouse.com>
> > Cc: Gnucash Users <gnucash-user at gnucash.org>
> > Subject: Re: Check writing
> > Message-ID:
> > <CADYgSbkcnMURpqGF959YA8-qqBP+ZSPvWNz5ziUH+QKLLDzqpQ at mail.
> > gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Ronal,
> >
> > I used to use Versa checks with Gnucash several years ago before the
> > computer that had the printer connected died.
> >
> > I used personal size checks and I remember that there was an issue with
> > some sizes or voucher checks or Check 21 or something.
> >
> > That was several years ago.
> >
> > David C
> >
> > On Feb 9, 2018 8:27 PM, "Ronal B Morse" <ron at morsehouse.com> wrote:
> >
> > > On 02/09/2018 01:39 PM, Ronald Mocny via gnucash-user wrote:
> > >
> > >> Can I write checks in GnuCash and if so is it compatible with
> > >> VersaCheck. Thanks
> > >>
> > >>
> > > I'm not familiar with Versacheck, but GnuCash has a flexible and fully
> > > user configurable check writing facility. Personally, the pre-defined
> > > Quicken three-part voucher check option meets my needs.
> > >
> > > At the beginning of every month I pay ten - twelve bills by check with
> > GNC
> > > and it's a simple and easy task. The hardest part is remembering which
> > way
> > > to feed the blank forms into whatever printer I'm using at the time.
> > >
> > > If your forms have accompanying window envelopes, GNC does the
> > addressing,
> > > too.
> > >
> > > RBM
> > >
> > >
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at 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.
> >
> >
> > ------------------------------
> >
> > Message: 3
> > Date: Sat, 10 Feb 2018 14:19:32 +1000
> > From: Roger Hatton <roghat3 at gmail.com>
> > To: gnucash-user at gnucash.org
> > Subject: Re: gnucash-user Digest, Vol 179, Issue 33
> > Message-ID:
> > <CADsj1Q4bqU18D80PqGWUA_N9W5d83sbTsa0j3CDEHd1GC3sbFw@
> > mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Isn't creating 13 monthly reports a somewhat labour intensive
> > way of creating what could be a single report for 12 months
> > plus the total for the year?
> >
> > On Sat, Feb 10, 2018 at 11:57 AM, <gnucash-user-request at gnucash.org>
> > wrote:
> >
> > > Send gnucash-user mailing list submissions to
> > > gnucash-user at gnucash.org
> > >
> > > To subscribe or unsubscribe via the World Wide Web, visit
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > or, via email, send a message with subject or body 'help' to
> > > gnucash-user-request at gnucash.org
> > >
> > > You can reach the person managing the list at
> > > gnucash-user-owner at gnucash.org
> > >
> > > When replying, please edit your Subject line so it is more specific
> > > than "Re: Contents of gnucash-user digest..."
> > >
> > >
> > > Today's Topics:
> > >
> > > 1. Re: How to relate Transfer Sales to Cash to Customer?
> > > (Adrien Monteleone)
> > > 2. Re: Tracking credit card points (Aaron Laws)
> > > 3. Re: Latest version for Windows? (John Ralls)
> > > 4. Multi column reports methodology? (Roger Hatton)
> > > 5. Re: Duplicating Accounts? (Adrien Monteleone)
> > > 6. Re: 13 Column Reporting Starting July ending June plus Total
> > > (Adrien Monteleone)
> > > 7. Re: GNUCASH Free Accounting Software (Adrien Monteleone)
> > > 8. Re: Applying Customer overpayments (Adrien Monteleone)
> > > 9. Re: Applying Customer overpayments (Adrien Monteleone)
> > > 10. Re: GNUCASH Free Accounting Software (James Fuller)
> > > 11. Check writing (Ronald Mocny)
> > >
> > >
> > > ----------------------------------------------------------------------
> > >
> > > Message: 1
> > > Date: Fri, 9 Feb 2018 12:47:03 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Gnucash userlist <gnucash-user at gnucash.org>
> > > Subject: Re: How to relate Transfer Sales to Cash to Customer?
> > > Message-ID:
> > > <CAB7LH29wYiAmmVErTCr+dKSRa1mWdc+iEyXdces8QX7OJ6ngMA at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Certainly that is possible now. You can export transactions from a POS
> > and
> > > import them to Gnucash. This can either be done on a per-sale basis or
> > as a
> > > daily aggregate.
> > >
> > > Since it is possible to import invoices, the OP could do so as step
> one,
> > > and then record the payments as before as step 2. The importing step
> > would
> > > just save clicks within Gnucash.
> > >
> > > It would be nice though to be able to choose a customer/vendor on the
> > > Payor/Payee line and be able to have that manual transaction show up
> in a
> > > customer/vendor report.
> > >
> > > On Thu, Feb 8, 2018 at 3:38 PM, Mike or Penny Novack <
> > > stepbystepfarm at dialup4less.com> wrote:
> > >
> > > > On 2/8/2018 4:00 PM, Greg Feneis wrote:
> > > >
> > > >> I suspect Gnu Cash needs a point of sale (POS) module to handle this
> > > >> functionality.
> > > >>
> > > >> I think not exactly a module withing gnucash.
> > > >
> > > > What gnucash would need is the ability to accept a feed from a
> > (typical)
> > > > POS system. Whether a POS system is practical as an open source
> project
> > > is
> > > > another matter. Many (most?) that exist are tied to some company's
> cash
> > > > registers, may be scanning in customer ID << I am going by what I see
> > out
> > > > there as a customer >>
> > > >
> > > > Keep in mind, in the usual situation, you would NOT be wanting the
> > sales
> > > > clerks (who are ringing through customers) to have any access to the
> > > > accounting system.
> > > >
> > > > Open source POS (and inventory, see below) more practical based on
> the
> > > > assumption that instead of a cash register would be a general purpose
> > > small
> > > > computer the sales clerk used. Would be an app where a customer
> number
> > > was
> > > > entered, purchases one at a time (know what is taxable), total the
> bill
> > > and
> > > > note how paid (cash, check, credit card). Then feed the accounting
> and
> > > > inventory systems.
> > > >
> > > > Michael D Novack
> > > >
> > > > PS: Interfaces with an inventory system similar. There, ideally you
> > would
> > > > want POS to feed inventory as well as "general ledger" and inventory
> to
> > > > feed general ledger. In our case, the general ledger system would be
> > > > gnucash.
> > > >
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 2
> > > Date: Fri, 9 Feb 2018 14:00:53 -0500
> > > From: Aaron Laws <dartme18 at gmail.com>
> > > To: AC <gnucash at acarver.net>
> > > Cc: GnuCash users group <gnucash-user at gnucash.org>
> > > Subject: Re: Tracking credit card points
> > > Message-ID:
> > > <CADu-kvcsTKQNPkAoEC7ucRYu15zLQ+w0JGAVMPMSnxYgCvx4hA at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > On Mon, Feb 5, 2018 at 3:40 PM, AC <gnucash at acarver.net> wrote:
> > >
> > > > I've decided to start tracking my points on my cards because the
> > monthly
> > > > statements do a poor job of showing me the activity.
> > >
> > >
> > > Sounds like a good idea. For what it's worth, I don't track this sort
> of
> > > thing until it shows up on my statement at which time I credit
> > > Revenue:Credit Card Rewards. For instance, with Amazon, I can use these
> > > points directly at time of purchase, so
> > > Expense:CD Player $400
> > > Revenue:Credit Card Rewards $200
> > > Liabilities:Credit Card $200
> > > but with other credit cards, they are applied as a statement credit
> > > betimes:
> > > Assets:Chequing Account $200
> > > Revenue:Credit Card Rewards $200
> > >
> > > I thought I would mention it in case it is helpful in any way. Your way
> > > sounds more careful because you'll know how much of these points you
> have
> > > before you spend them.
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 3
> > > Date: Fri, 9 Feb 2018 11:32:29 -0800
> > > From: John Ralls <jralls at ceridwen.us>
> > > To: cicko <alen.siljak at gmx.com>
> > > Cc: gnucash-user at gnucash.org
> > > Subject: Re: Latest version for Windows?
> > > Message-ID: <636F19BB-F7BF-4321-B3A7-BBCAA3E5F193 at ceridwen.us>
> > > Content-Type: text/plain; charset=utf-8
> > >
> > >
> > >
> > > > On Feb 9, 2018, at 7:41 AM, John Ralls <jralls at ceridwen.us> wrote:
> > > >
> > > >
> > > >
> > > >> On Feb 9, 2018, at 5:57 AM, cicko <alen.siljak at gmx.com> wrote:
> > > >>
> > > >> I find a bit confusing as to where to find the latest version for
> > > Windows.
> > > >> The maintainance releases are apparently going out but somehow I
> can't
> > > >> figure out what the flow is.
> > > >>
> > > >> The main www.gnucash.org page points to
> > > >> http://downloads.sourceforge.net/sourceforge/gnucash/
> > > gnucash-2.6.19-1.setup.exe
> > > >> which does not exist.
> > > >>
> > > >> The Installation page simply points to the Windows directory on
> > > SourceForge.
> > > >> The Stable version there is
> > > >> https://sourceforge.net/projects/gnucash/files/
> > > gnucash%20%28stable%29/2.6.19/gnucash-2.6.19-setup.exe/download
> > > >> which looks like the first 2.6.19 version?
> > > >> However, on the same page there is a hash
> > > >> 1fa83d9578e8c62bd7dcef3b953e0e7610bf03bed9c1a037a72a6eee1ac79e37
> > > >> gnucash-2.6.19-3.setup.exe
> > > >> which refers to 2.6.19-3 version for Windows(!).
> > > >>
> > > >> And, finally, Windows wiki page (https://wiki.gnucash.org/
> > wiki/Windows)
> > > >> points to
> > > >> https://code.gnucash.org/builds/win32/maint/
> > > >> which shows what I believe are the weekly maintenance builds, based
> on
> > > the
> > > >> info in their names and the description on the wiki page.
> > > >>
> > > >> So, if I want to get the *latest stable version* for Windows, which
> > one
> > > >> should I use?
> > > >
> > > > You should use https://sourceforge.net/projects/gnucash/files/
> > > gnucash%20%28stable%29/2.6.19/gnucash-2.6.19-setup.exe/download<
> > > https://sourceforge.net/projects/gnucash/files/
> > gnucash%20(stable)/2.6.19/
> > > gnucash-2.6.19-setup.exe/download> or https://github.com/Gnucash/
> > > gnucash/releases/download/2.6.19/gnucash-2.6.19-setup.exe<ht
> > > tps://github.com/Gnucash/gnucash/releases/download/2.6.
> > > 19/gnucash-2.6.19-setup.exe>
> > > >
> > > > (They?re the same file; Github lacks SourceForge?s annoying
> > advertising).
> > > >
> > > > And I?ll get the mess of wrong pointers and names cleaned up.
> > > >
> > >
> > > The pointer on www.gnucash.org and the README.txt on SourceForge are
> > > fixed now. Sorry for the confusion.
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 4
> > > Date: Sat, 10 Feb 2018 06:18:23 +1000
> > > From: Roger Hatton <roghat3 at gmail.com>
> > > To: gnucash-user at gnucash.org
> > > Subject: Multi column reports methodology?
> > > Message-ID:
> > > <CADsj1Q77cKRJvCd3L+hSaGUieP=o57oXjgMmrJxDZjbw1EtsBQ at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Is there a simple way to generate a 13 column Profit and Loss
> > > and a 13 column Balance Sheet showing monthly movements?
> > >
> > > My apology if this question has been asked often before but
> > > being new I can't see the answer to what I hope is a simple
> > > question, with one menu item to action these two reports?
> > >
> > > Is there also a cumulative monthly balance sheet function
> > > over 12 columns (no 13th Column needed)?
> > >
> > > With thanks and congratulations on an interesting system.
> > >
> > > Roger H
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 5
> > > Date: Fri, 9 Feb 2018 14:38:33 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> > > Subject: Re: Duplicating Accounts?
> > > Message-ID:
> > > <CAB7LH29FDhaJYRsyW7-4oDkzh63Jo5T1zYws6TgmQJd515DJH
> > > Q at mail.gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > I thought perhaps the route to go would be create a new hierarchy
> > template,
> > > but it seems that is not possible, at least from within the software.
> > Then
> > > I looked at exporting and importing an account tree, but again, while
> > > export is possible, I don't see how to import a partial tree.
> > >
> > > Best of luck.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Thu, Feb 8, 2018 at 3:54 PM, Steve Isenberg via gnucash-user <
> > > gnucash-user at gnucash.org> wrote:
> > >
> > > >
> > > > I figured out how to do this once before and now for thelife of I
> > cannot
> > > > remember. I am trying to duplicate an expense account and allof its
> > > > sub-accounts, with a new name of course, and zero balances.
> > > >
> > > > This is not a transfer of funds and I'm not duplicatingtransactions.
> It
> > > is
> > > > basically a copy of one account hierarchy to a new expenseaccount
> > > hierarchy.
> > > >
> > > > Anyone remember how to do this without creating a newaccount and
> eight
> > > new
> > > > sub-accounts?
> > > >
> > > > Thanks
> > > >
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 6
> > > Date: Fri, 9 Feb 2018 14:40:28 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Gnucash userlist <gnucash-user at gnucash.org>
> > > Subject: Re: 13 Column Reporting Starting July ending June plus Total
> > > Message-ID:
> > > <CAB7LH2_fxpJb+LNJiSSKj5NkHr_r_okLQqD59q9VLxTOkFJ8bg at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Sadly, no.
> > >
> > > You'd either have to create this report from scratch, or run the
> > individual
> > > reports and export them to a spreadsheet for a consolidated view.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Thu, Feb 8, 2018 at 10:24 PM, Roger Hatton <roghat3 at gmail.com>
> wrote:
> > >
> > > > Is there a simple way to generate a 13 column Profit and Loss
> > > > and a 13 column Balance Sheet showing monthly movements?
> > > >
> > > > My apology if this question has been asked often before but
> > > > being new I can't see the answer to what I hope is a simple
> > > > question, with one menu item to action these two reports?
> > > >
> > > > Is there also a cumulative monthly balance sheet function
> > > > over 12 columns (no 13th Column needed)?
> > > >
> > > > With thanks and congratulations on an interesting system.
> > > >
> > > > Roger H
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 7
> > > Date: Fri, 9 Feb 2018 14:46:20 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Gnucash Users <gnucash-user at gnucash.org>
> > > Subject: Re: GNUCASH Free Accounting Software
> > > Message-ID:
> > > <CAB7LH297_rDwW3+ofAerQm58QAGy-7WxC+Q8uGh=G42wS
> > > _apOA at mail.gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > James,
> > >
> > > The date range selectors are in the General Tab of the Options window
> for
> > > any report. There are some quick choices such as 'start of last year'
> or
> > > you can pick specific dates.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Thu, Feb 8, 2018 at 11:28 PM, David T. via gnucash-user <
> > > gnucash-user at gnucash.org> wrote:
> > >
> > > > Or run a transaction report and set the dates accordingly.
> > > >
> > > > > On Feb 9, 2018, at 5:20 AM, David Carlson <
> > david.carlson.417 at gmail.com
> > > >
> > > > wrote:
> > > > >
> > > > > If you want to do a register report for a certain time range open
> the
> > > > > register window and choose View > Filter by.. > Date to select your
> > > time
> > > > > window then select Reports > Account Report.
> > > > >
> > > > > David C
> > > > >
> > > > > On Thu, Feb 8, 2018 at 5:44 PM, James fuller <james at plateautel.net
> >
> > > > wrote:
> > > > >
> > > > >> Adrian,
> > > > >> I saw your reply below. I cannot seem to print by date range.
> What
> > > I?m
> > > > >> trying to do is print the bank account transactions by date.
> > > > Specifically
> > > > >> the year 2017. I also need to print out a couple of expense
> account
> > > > >> transactions for the same period. I did not close
> > > > >> 2016 and every report I have printed shows all of 2016 along with
> > > 2017.
> > > > >> What am I missing?
> > > > >>
> > > > >> Thanks
> > > > >> James Fuller
> > > > >>
> > > > >> Sent from my iPad
> > > > >>
> > > > >>> On Feb 3, 2018, at 3:43 PM, Adrien Monteleone <
> > > > >> adrien.monteleone at gmail.com> wrote:
> > > > >>>
> > > > >>> the
> > > > >>
> > > > >> _______________________________________________
> > > > >> gnucash-user mailing list
> > > > >> gnucash-user at 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 at 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 at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 8
> > > Date: Fri, 9 Feb 2018 14:57:39 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Alan Johnson <alan at argentwolf.org>
> > > Cc: Gnucash userlist <gnucash-user at gnucash.org>
> > > Subject: Re: Applying Customer overpayments
> > > Message-ID:
> > > <CAB7LH2-eWHc+bK4h0m3FhyB7C5rgUmcpTjzPxwhQ46
> > > L_p9z1sQ at mail.gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Alan,
> > >
> > > When making the payment, you should have had the option to choose the
> > > balancing account, you would have had to select AR instead of Checking
> > if I
> > > recall correctly.
> > >
> > > I'd delete the entire payment and re-apply it.
> > >
> > > The overpayment resides in AR as a contra-balance. You could transfer
> > this
> > > to a Customer Deposits liability account if you think you won't apply
> it
> > > for some time and don't want to lose track or just want to keep things
> > neat
> > > and tidy. Doing this also allows you to see WHO has overpaid/pre-paid
> and
> > > by how much. If the money stays in AR it's just a lump total for all
> > > customers. You could also end up with odd balances in AR and not see
> > > clearly why at a glance without sifting through historical
> transactions.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Fri, Feb 9, 2018 at 12:45 AM, Alan Johnson <alan at argentwolf.org>
> > wrote:
> > >
> > > >
> > > > *replying to the list
> > > >
> > > > Geert,
> > > >
> > > > Thanks. That worked. However it wanted to apply the funds to the
> > checking
> > > > account (which were already deposited/received). I deleted that part
> of
> > > the
> > > > transaction from the AR register, and the balance offset still works,
> > > just
> > > > does not reflect as a payment on the customer report. Is there a
> better
> > > > account to debit the funds? In the balance sheet / P&L I don't see
> any
> > > sort
> > > > of customer funds held/liability that would be where the offset would
> > go.
> > > >
> > > > Also, this feature wasn't in the documentation (at least that I could
> > > > find). The documentation merely states that GnuCash would keep track
> of
> > > any
> > > > overpayment. It sounds like a feature like QuickBoox payment system
> > check
> > > > box "Apply customer balance to invoice" is needed.
> > > > Alan
> > > >
> > > >
> > > >
> > > > On 2/8/2018 1:09 PM, Geert Janssens wrote:
> > > >
> > > >> Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson:
> > > >>
> > > >>> Hello, I'm having an issue with GnuCash. A customer has a
> > > >>> overpayment/credit balance. How do I apply it to an invoice so that
> > it
> > > >>> comes out of the AR report at the bottom of the customer report?
> The
> > > >>> total due / sums are correct, but the customer report has a 91+ day
> > > >>> balance of (0.03). I would like to apply the payment to an invoice
> /
> > > fix
> > > >>> the AR box on the customer report. This is on version 2.6.19.
> > > >>>
> > > >>> - Go to Business->Customer->Process Payment
> > > >> - Select the customer you refer to above
> > > >> - You should get a list of open invoices and overpayments
> > > >> - Select both the 0.03 overpayment and the invoice you want to apply
> > it
> > > to
> > > >> (using shift- or ctrl-click)
> > > >> - If you only want to apply this 0.03, adjust the amount to exactly
> > that
> > > >> 0.03
> > > >> - Click Ok
> > > >>
> > > >> Regards,
> > > >>
> > > >> Geert
> > > >>
> > > >>
> > > >>
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 9
> > > Date: Fri, 9 Feb 2018 14:58:53 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Gnucash userlist <gnucash-user at gnucash.org>
> > > Subject: Re: Applying Customer overpayments
> > > Message-ID:
> > > <CAB7LH2_6-hqhdpx4nhmOMaqBP_xHvUdCWS3yxz3pzz6GVWytAA at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > copying to list - sorry still using a webmail interface I'm not used
> to.
> > > -------------
> > >
> > > Alan,
> > >
> > > When making the payment, you should have had the option to choose the
> > > balancing account, you would have had to select AR instead of Checking
> > if I
> > > recall correctly.
> > >
> > > I'd delete the entire payment and re-apply it.
> > >
> > > The overpayment resides in AR as a contra-balance. You could transfer
> > this
> > > to a Customer Deposits liability account if you think you won't apply
> it
> > > for some time and don't want to lose track or just want to keep things
> > neat
> > > and tidy. Doing this also allows you to see WHO has overpaid/pre-paid
> and
> > > by how much. If the money stays in AR it's just a lump total for all
> > > customers. You could also end up with odd balances in AR and not see
> > > clearly why at a glance without sifting through historical
> transactions.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Fri, Feb 9, 2018 at 12:45 AM, Alan Johnson <alan at argentwolf.org>
> > wrote:
> > >
> > > >
> > > > *replying to the list
> > > >
> > > > Geert,
> > > >
> > > > Thanks. That worked. However it wanted to apply the funds to the
> > checking
> > > > account (which were already deposited/received). I deleted that part
> of
> > > the
> > > > transaction from the AR register, and the balance offset still works,
> > > just
> > > > does not reflect as a payment on the customer report. Is there a
> better
> > > > account to debit the funds? In the balance sheet / P&L I don't see
> any
> > > sort
> > > > of customer funds held/liability that would be where the offset would
> > go.
> > > >
> > > > Also, this feature wasn't in the documentation (at least that I could
> > > > find). The documentation merely states that GnuCash would keep track
> of
> > > any
> > > > overpayment. It sounds like a feature like QuickBoox payment system
> > check
> > > > box "Apply customer balance to invoice" is needed.
> > > > Alan
> > > >
> > > >
> > > >
> > > > On 2/8/2018 1:09 PM, Geert Janssens wrote:
> > > >
> > > >> Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson:
> > > >>
> > > >>> Hello, I'm having an issue with GnuCash. A customer has a
> > > >>> overpayment/credit balance. How do I apply it to an invoice so that
> > it
> > > >>> comes out of the AR report at the bottom of the customer report?
> The
> > > >>> total due / sums are correct, but the customer report has a 91+ day
> > > >>> balance of (0.03). I would like to apply the payment to an invoice
> /
> > > fix
> > > >>> the AR box on the customer report. This is on version 2.6.19.
> > > >>>
> > > >>> - Go to Business->Customer->Process Payment
> > > >> - Select the customer you refer to above
> > > >> - You should get a list of open invoices and overpayments
> > > >> - Select both the 0.03 overpayment and the invoice you want to apply
> > it
> > > to
> > > >> (using shift- or ctrl-click)
> > > >> - If you only want to apply this 0.03, adjust the amount to exactly
> > that
> > > >> 0.03
> > > >> - Click Ok
> > > >>
> > > >> Regards,
> > > >>
> > > >> Geert
> > > >>
> > > >>
> > > >>
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 10
> > > Date: Fri, 9 Feb 2018 16:51:40 -0700
> > > From: James Fuller <james at plateautel.net>
> > > To: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > Cc: Gnucash Users <gnucash-user at gnucash.org>
> > > Subject: Re: GNUCASH Free Accounting Software
> > > Message-ID: <DADB9E54-48B7-4460-A3C1-82B532648E46 at plateautel.net>
> > > Content-Type: text/plain; charset=utf-8
> > >
> > > Hi Adrian,
> > >
> > > Thank you VERY much for your help.
> > >
> > > James Fuller
> > >
> > > Sent from my iPad
> > >
> > > > On Feb 9, 2018, at 1:46 PM, Adrien Monteleone <
> > > adrien.monteleone at gmail.com> wrote:
> > > >
> > > > James,
> > > >
> > > > The date range selectors are in the General Tab of the Options window
> > for
> > > > any report. There are some quick choices such as 'start of last year'
> > or
> > > > you can pick specific dates.
> > > >
> > > > Regards,
> > > > Adrien
> > > >
> > > > On Thu, Feb 8, 2018 at 11:28 PM, David T. via gnucash-user <
> > > > gnucash-user at gnucash.org> wrote:
> > > >
> > > >> Or run a transaction report and set the dates accordingly.
> > > >>
> > > >>> On Feb 9, 2018, at 5:20 AM, David Carlson <
> > david.carlson.417 at gmail.com
> > > >
> > > >> wrote:
> > > >>>
> > > >>> If you want to do a register report for a certain time range open
> the
> > > >>> register window and choose View > Filter by.. > Date to select your
> > > time
> > > >>> window then select Reports > Account Report.
> > > >>>
> > > >>> David C
> > > >>>
> > > >>> On Thu, Feb 8, 2018 at 5:44 PM, James fuller <james at plateautel.net
> >
> > > >> wrote:
> > > >>>
> > > >>>> Adrian,
> > > >>>> I saw your reply below. I cannot seem to print by date range.
> What
> > > I?m
> > > >>>> trying to do is print the bank account transactions by date.
> > > >> Specifically
> > > >>>> the year 2017. I also need to print out a couple of expense
> account
> > > >>>> transactions for the same period. I did not close
> > > >>>> 2016 and every report I have printed shows all of 2016 along with
> > > 2017.
> > > >>>> What am I missing?
> > > >>>>
> > > >>>> Thanks
> > > >>>> James Fuller
> > > >>>>
> > > >>>> Sent from my iPad
> > > >>>>
> > > >>>>> On Feb 3, 2018, at 3:43 PM, Adrien Monteleone <
> > > >>>> adrien.monteleone at gmail.com> wrote:
> > > >>>>>
> > > >>>>> the
> > > >>>>
> > > >>>> _______________________________________________
> > > >>>> gnucash-user mailing list
> > > >>>> gnucash-user at 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 at 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 at 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 at 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.
> > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 11
> > > Date: Fri, 9 Feb 2018 14:39:56 -0600
> > > From: Ronald Mocny <ronmocny at reagan.com>
> > > To: gnucash-user at gnucash.org
> > > Subject: Check writing
> > > Message-ID: <e9bad553-7c81-7130-7988-715027ffc367 at reagan.com>
> > > Content-Type: text/plain; charset="utf-8"
> > >
> > > Can I write checks in GnuCash and if so is it compatible with
> > > VersaCheck. Thanks
> > >
> > >
> > >
> > > ------------------------------
> > >
> > > Subject: Digest Footer
> > >
> > > _______________________________________________
> > >
> > > gnucash-user mailing list
> > > gnucash-user at 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.
> > >
> > > ------------------------------
> > >
> > > End of gnucash-user Digest, Vol 179, Issue 33
> > > *********************************************
> > >
> >
> >
> > ------------------------------
> >
> > Message: 4
> > Date: Sat, 10 Feb 2018 10:13:31 +0500
> > From: D <sunfish62 at yahoo.com>
> > To: Roger Hatton <roghat3 at gmail.com>, Gnucash Users
> > <gnucash-user at gnucash.org>
> > Subject: Re: 13 Column Reporting Starting July ending June plus Total
> > Message-ID: <gnqntkcan0duhltmxxha6i60.1518239611213 at email.android.com>
> > Content-Type: text/plain; charset=utf-8
> >
> > Roger,
> >
> > The reports system is not known for its general flexibility. Creating a
> > new report (such as your 13 period report) would take writing that new
> > report in the Scheme language, which is (contrary to its advocates) not a
> > trivial matter.
> >
> > Compiling 13 iterations of the existing balance sheet will be easier in
> > the short run since it relies on existing mechanisms, although if you
> were
> > to try writing the new report in Scheme, I'm sure others will be willing
> to
> > offer help and feedback.
> >
> > David
> >
> > P.S. In the future, please edit your reply so that it a) refers to your
> > specific topic (rather than "Gnucash digest"), and b) edit away the parts
> > of the digest that don't apply to your thread.
> >
> > On February 10, 2018, at 9:20 AM, Roger Hatton <roghat3 at gmail.com>
> wrote:
> >
> > Isn't creating 13 monthly reports a somewhat labour intensive
> > way of creating what could be a single report for 12 months
> > plus the total for the year?
> >
> > On Sat, Feb 10, 2018 at 11:57 AM, <gnucash-user-request at gnucash.org>
> > wrote:
> >
> > > Send gnucash-user mailing list submissions to
> > > gnucash-user at gnucash.org
> > >
> > > To subscribe or unsubscribe via the World Wide Web, visit
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > or, via email, send a message with subject or body 'help' to
> > > gnucash-user-request at gnucash.org
> > >
> > > You can reach the person managing the list at
> > > gnucash-user-owner at gnucash.org
> > >
> > > When replying, please edit your Subject line so it is more specific
> > > than "Re: Contents of gnucash-user digest..."
> > >
> > >
> > > Today's Topics:
> > >
> > > 1. Re: How to relate Transfer Sales to Cash to Customer?
> > > (Adrien Monteleone)
> > > 2. Re: Tracking credit card points (Aaron Laws)
> > > 3. Re: Latest version for Windows? (John Ralls)
> > > 4. Multi column reports methodology? (Roger Hatton)
> > > 5. Re: Duplicating Accounts? (Adrien Monteleone)
> > > 6. Re: 13 Column Reporting Starting July ending June plus Total
> > > (Adrien Monteleone)
> > > 7. Re: GNUCASH Free Accounting Software (Adrien Monteleone)
> > > 8. Re: Applying Customer overpayments (Adrien Monteleone)
> > > 9. Re: Applying Customer overpayments (Adrien Monteleone)
> > > 10. Re: GNUCASH Free Accounting Software (James Fuller)
> > > 11. Check writing (Ronald Mocny)
> > >
> > >
> > > ----------------------------------------------------------------------
> > >
> > > Message: 1
> > > Date: Fri, 9 Feb 2018 12:47:03 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Gnucash userlist <gnucash-user at gnucash.org>
> > > Subject: Re: How to relate Transfer Sales to Cash to Customer?
> > > Message-ID:
> > > <CAB7LH29wYiAmmVErTCr+dKSRa1mWdc+iEyXdces8QX7OJ6ngMA at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Certainly that is possible now. You can export transactions from a POS
> > and
> > > import them to Gnucash. This can either be done on a per-sale basis or
> > as a
> > > daily aggregate.
> > >
> > > Since it is possible to import invoices, the OP could do so as step
> one,
> > > and then record the payments as before as step 2. The importing step
> > would
> > > just save clicks within Gnucash.
> > >
> > > It would be nice though to be able to choose a customer/vendor on the
> > > Payor/Payee line and be able to have that manual transaction show up
> in a
> > > customer/vendor report.
> > >
> > > On Thu, Feb 8, 2018 at 3:38 PM, Mike or Penny Novack <
> > > stepbystepfarm at dialup4less.com> wrote:
> > >
> > > > On 2/8/2018 4:00 PM, Greg Feneis wrote:
> > > >
> > > >> I suspect Gnu Cash needs a point of sale (POS) module to handle this
> > > >> functionality.
> > > >>
> > > >> I think not exactly a module withing gnucash.
> > > >
> > > > What gnucash would need is the ability to accept a feed from a
> > (typical)
> > > > POS system. Whether a POS system is practical as an open source
> project
> > > is
> > > > another matter. Many (most?) that exist are tied to some company's
> cash
> > > > registers, may be scanning in customer ID << I am going by what I see
> > out
> > > > there as a customer >>
> > > >
> > > > Keep in mind, in the usual situation, you would NOT be wanting the
> > sales
> > > > clerks (who are ringing through customers) to have any access to the
> > > > accounting system.
> > > >
> > > > Open source POS (and inventory, see below) more practical based on
> the
> > > > assumption that instead of a cash register would be a general purpose
> > > small
> > > > computer the sales clerk used. Would be an app where a customer
> number
> > > was
> > > > entered, purchases one at a time (know what is taxable), total the
> bill
> > > and
> > > > note how paid (cash, check, credit card). Then feed the accounting
> and
> > > > inventory systems.
> > > >
> > > > Michael D Novack
> > > >
> > > > PS: Interfaces with an inventory system similar. There, ideally you
> > would
> > > > want POS to feed inventory as well as "general ledger" and inventory
> to
> > > > feed general ledger. In our case, the general ledger system would be
> > > > gnucash.
> > > >
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 2
> > > Date: Fri, 9 Feb 2018 14:00:53 -0500
> > > From: Aaron Laws <dartme18 at gmail.com>
> > > To: AC <gnucash at acarver.net>
> > > Cc: GnuCash users group <gnucash-user at gnucash.org>
> > > Subject: Re: Tracking credit card points
> > > Message-ID:
> > > <CADu-kvcsTKQNPkAoEC7ucRYu15zLQ+w0JGAVMPMSnxYgCvx4hA at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > On Mon, Feb 5, 2018 at 3:40 PM, AC <gnucash at acarver.net> wrote:
> > >
> > > > I've decided to start tracking my points on my cards because the
> > monthly
> > > > statements do a poor job of showing me the activity.
> > >
> > >
> > > Sounds like a good idea. For what it's worth, I don't track this sort
> of
> > > thing until it shows up on my statement at which time I credit
> > > Revenue:Credit Card Rewards. For instance, with Amazon, I can use these
> > > points directly at time of purchase, so
> > > Expense:CD Player $400
> > > Revenue:Credit Card Rewards $200
> > > Liabilities:Credit Card $200
> > > but with other credit cards, they are applied as a statement credit
> > > betimes:
> > > Assets:Chequing Account $200
> > > Revenue:Credit Card Rewards $200
> > >
> > > I thought I would mention it in case it is helpful in any way. Your way
> > > sounds more careful because you'll know how much of these points you
> have
> > > before you spend them.
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 3
> > > Date: Fri, 9 Feb 2018 11:32:29 -0800
> > > From: John Ralls <jralls at ceridwen.us>
> > > To: cicko <alen.siljak at gmx.com>
> > > Cc: gnucash-user at gnucash.org
> > > Subject: Re: Latest version for Windows?
> > > Message-ID: <636F19BB-F7BF-4321-B3A7-BBCAA3E5F193 at ceridwen.us>
> > > Content-Type: text/plain; charset=utf-8
> > >
> > >
> > >
> > > > On Feb 9, 2018, at 7:41 AM, John Ralls <jralls at ceridwen.us> wrote:
> > > >
> > > >
> > > >
> > > >> On Feb 9, 2018, at 5:57 AM, cicko <alen.siljak at gmx.com> wrote:
> > > >>
> > > >> I find a bit confusing as to where to find the latest version for
> > > Windows.
> > > >> The maintainance releases are apparently going out but somehow I
> can't
> > > >> figure out what the flow is.
> > > >>
> > > >> The main www.gnucash.org page points to
> > > >> http://downloads.sourceforge.net/sourceforge/gnucash/
> > > gnucash-2.6.19-1.setup.exe
> > > >> which does not exist.
> > > >>
> > > >> The Installation page simply points to the Windows directory on
> > > SourceForge.
> > > >> The Stable version there is
> > > >> https://sourceforge.net/projects/gnucash/files/
> > > gnucash%20%28stable%29/2.6.19/gnucash-2.6.19-setup.exe/download
> > > >> which looks like the first 2.6.19 version?
> > > >> However, on the same page there is a hash
> > > >> 1fa83d9578e8c62bd7dcef3b953e0e7610bf03bed9c1a037a72a6eee1ac79e37
> > > >> gnucash-2.6.19-3.setup.exe
> > > >> which refers to 2.6.19-3 version for Windows(!).
> > > >>
> > > >> And, finally, Windows wiki page (https://wiki.gnucash.org/
> > wiki/Windows)
> > > >> points to
> > > >> https://code.gnucash.org/builds/win32/maint/
> > > >> which shows what I believe are the weekly maintenance builds, based
> on
> > > the
> > > >> info in their names and the description on the wiki page.
> > > >>
> > > >> So, if I want to get the *latest stable version* for Windows, which
> > one
> > > >> should I use?
> > > >
> > > > You should use https://sourceforge.net/projects/gnucash/files/
> > > gnucash%20%28stable%29/2.6.19/gnucash-2.6.19-setup.exe/download<
> > > https://sourceforge.net/projects/gnucash/files/
> > gnucash%20(stable)/2.6.19/
> > > gnucash-2.6.19-setup.exe/download> or https://github.com/Gnucash/
> > > gnucash/releases/download/2.6.19/gnucash-2.6.19-setup.exe<ht
> > > tps://github.com/Gnucash/gnucash/releases/download/2.6.
> > > 19/gnucash-2.6.19-setup.exe>
> > > >
> > > > (They?re the same file; Github lacks SourceForge?s annoying
> > advertising).
> > > >
> > > > And I?ll get the mess of wrong pointers and names cleaned up.
> > > >
> > >
> > > The pointer on www.gnucash.org and the README.txt on SourceForge are
> > > fixed now. Sorry for the confusion.
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 4
> > > Date: Sat, 10 Feb 2018 06:18:23 +1000
> > > From: Roger Hatton <roghat3 at gmail.com>
> > > To: gnucash-user at gnucash.org
> > > Subject: Multi column reports methodology?
> > > Message-ID:
> > > <CADsj1Q77cKRJvCd3L+hSaGUieP=o57oXjgMmrJxDZjbw1EtsBQ at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Is there a simple way to generate a 13 column Profit and Loss
> > > and a 13 column Balance Sheet showing monthly movements?
> > >
> > > My apology if this question has been asked often before but
> > > being new I can't see the answer to what I hope is a simple
> > > question, with one menu item to action these two reports?
> > >
> > > Is there also a cumulative monthly balance sheet function
> > > over 12 columns (no 13th Column needed)?
> > >
> > > With thanks and congratulations on an interesting system.
> > >
> > > Roger H
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 5
> > > Date: Fri, 9 Feb 2018 14:38:33 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> > > Subject: Re: Duplicating Accounts?
> > > Message-ID:
> > > <CAB7LH29FDhaJYRsyW7-4oDkzh63Jo5T1zYws6TgmQJd515DJH
> > > Q at mail.gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > I thought perhaps the route to go would be create a new hierarchy
> > template,
> > > but it seems that is not possible, at least from within the software.
> > Then
> > > I looked at exporting and importing an account tree, but again, while
> > > export is possible, I don't see how to import a partial tree.
> > >
> > > Best of luck.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Thu, Feb 8, 2018 at 3:54 PM, Steve Isenberg via gnucash-user <
> > > gnucash-user at gnucash.org> wrote:
> > >
> > > >
> > > > I figured out how to do this once before and now for thelife of I
> > cannot
> > > > remember. I am trying to duplicate an expense account and allof its
> > > > sub-accounts, with a new name of course, and zero balances.
> > > >
> > > > This is not a transfer of funds and I'm not duplicatingtransactions.
> It
> > > is
> > > > basically a copy of one account hierarchy to a new expenseaccount
> > > hierarchy.
> > > >
> > > > Anyone remember how to do this without creating a newaccount and
> eight
> > > new
> > > > sub-accounts?
> > > >
> > > > Thanks
> > > >
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 6
> > > Date: Fri, 9 Feb 2018 14:40:28 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Gnucash userlist <gnucash-user at gnucash.org>
> > > Subject: Re: 13 Column Reporting Starting July ending June plus Total
> > > Message-ID:
> > > <CAB7LH2_fxpJb+LNJiSSKj5NkHr_r_okLQqD59q9VLxTOkFJ8bg at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Sadly, no.
> > >
> > > You'd either have to create this report from scratch, or run the
> > individual
> > > reports and export them to a spreadsheet for a consolidated view.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Thu, Feb 8, 2018 at 10:24 PM, Roger Hatton <roghat3 at gmail.com>
> wrote:
> > >
> > > > Is there a simple way to generate a 13 column Profit and Loss
> > > > and a 13 column Balance Sheet showing monthly movements?
> > > >
> > > > My apology if this question has been asked often before but
> > > > being new I can't see the answer to what I hope is a simple
> > > > question, with one menu item to action these two reports?
> > > >
> > > > Is there also a cumulative monthly balance sheet function
> > > > over 12 columns (no 13th Column needed)?
> > > >
> > > > With thanks and congratulations on an interesting system.
> > > >
> > > > Roger H
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 7
> > > Date: Fri, 9 Feb 2018 14:46:20 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Gnucash Users <gnucash-user at gnucash.org>
> > > Subject: Re: GNUCASH Free Accounting Software
> > > Message-ID:
> > > <CAB7LH297_rDwW3+ofAerQm58QAGy-7WxC+Q8uGh=G42wS
> > > _apOA at mail.gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > James,
> > >
> > > The date range selectors are in the General Tab of the Options window
> for
> > > any report. There are some quick choices such as 'start of last year'
> or
> > > you can pick specific dates.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Thu, Feb 8, 2018 at 11:28 PM, David T. via gnucash-user <
> > > gnucash-user at gnucash.org> wrote:
> > >
> > > > Or run a transaction report and set the dates accordingly.
> > > >
> > > > > On Feb 9, 2018, at 5:20 AM, David Carlson <
> > david.carlson.417 at gmail.com
> > > >
> > > > wrote:
> > > > >
> > > > > If you want to do a register report for a certain time range open
> the
> > > > > register window and choose View > Filter by.. > Date to select your
> > > time
> > > > > window then select Reports > Account Report.
> > > > >
> > > > > David C
> > > > >
> > > > > On Thu, Feb 8, 2018 at 5:44 PM, James fuller <james at plateautel.net
> >
> > > > wrote:
> > > > >
> > > > >> Adrian,
> > > > >> I saw your reply below. I cannot seem to print by date range.
> What
> > > I?m
> > > > >> trying to do is print the bank account transactions by date.
> > > > Specifically
> > > > >> the year 2017. I also need to print out a couple of expense
> account
> > > > >> transactions for the same period. I did not close
> > > > >> 2016 and every report I have printed shows all of 2016 along with
> > > 2017.
> > > > >> What am I missing?
> > > > >>
> > > > >> Thanks
> > > > >> James Fuller
> > > > >>
> > > > >> Sent from my iPad
> > > > >>
> > > > >>> On Feb 3, 2018, at 3:43 PM, Adrien Monteleone <
> > > > >> adrien.monteleone at gmail.com> wrote:
> > > > >>>
> > > > >>> the
> > > > >>
> > > > >> _______________________________________________
> > > > >> gnucash-user mailing list
> > > > >> gnucash-user at 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 at 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 at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 8
> > > Date: Fri, 9 Feb 2018 14:57:39 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Alan Johnson <alan at argentwolf.org>
> > > Cc: Gnucash userlist <gnucash-user at gnucash.org>
> > > Subject: Re: Applying Customer overpayments
> > > Message-ID:
> > > <CAB7LH2-eWHc+bK4h0m3FhyB7C5rgUmcpTjzPxwhQ46
> > > L_p9z1sQ at mail.gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > Alan,
> > >
> > > When making the payment, you should have had the option to choose the
> > > balancing account, you would have had to select AR instead of Checking
> > if I
> > > recall correctly.
> > >
> > > I'd delete the entire payment and re-apply it.
> > >
> > > The overpayment resides in AR as a contra-balance. You could transfer
> > this
> > > to a Customer Deposits liability account if you think you won't apply
> it
> > > for some time and don't want to lose track or just want to keep things
> > neat
> > > and tidy. Doing this also allows you to see WHO has overpaid/pre-paid
> and
> > > by how much. If the money stays in AR it's just a lump total for all
> > > customers. You could also end up with odd balances in AR and not see
> > > clearly why at a glance without sifting through historical
> transactions.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Fri, Feb 9, 2018 at 12:45 AM, Alan Johnson <alan at argentwolf.org>
> > wrote:
> > >
> > > >
> > > > *replying to the list
> > > >
> > > > Geert,
> > > >
> > > > Thanks. That worked. However it wanted to apply the funds to the
> > checking
> > > > account (which were already deposited/received). I deleted that part
> of
> > > the
> > > > transaction from the AR register, and the balance offset still works,
> > > just
> > > > does not reflect as a payment on the customer report. Is there a
> better
> > > > account to debit the funds? In the balance sheet / P&L I don't see
> any
> > > sort
> > > > of customer funds held/liability that would be where the offset would
> > go.
> > > >
> > > > Also, this feature wasn't in the documentation (at least that I could
> > > > find). The documentation merely states that GnuCash would keep track
> of
> > > any
> > > > overpayment. It sounds like a feature like QuickBoox payment system
> > check
> > > > box "Apply customer balance to invoice" is needed.
> > > > Alan
> > > >
> > > >
> > > >
> > > > On 2/8/2018 1:09 PM, Geert Janssens wrote:
> > > >
> > > >> Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson:
> > > >>
> > > >>> Hello, I'm having an issue with GnuCash. A customer has a
> > > >>> overpayment/credit balance. How do I apply it to an invoice so that
> > it
> > > >>> comes out of the AR report at the bottom of the customer report?
> The
> > > >>> total due / sums are correct, but the customer report has a 91+ day
> > > >>> balance of (0.03). I would like to apply the payment to an invoice
> /
> > > fix
> > > >>> the AR box on the customer report. This is on version 2.6.19.
> > > >>>
> > > >>> - Go to Business->Customer->Process Payment
> > > >> - Select the customer you refer to above
> > > >> - You should get a list of open invoices and overpayments
> > > >> - Select both the 0.03 overpayment and the invoice you want to apply
> > it
> > > to
> > > >> (using shift- or ctrl-click)
> > > >> - If you only want to apply this 0.03, adjust the amount to exactly
> > that
> > > >> 0.03
> > > >> - Click Ok
> > > >>
> > > >> Regards,
> > > >>
> > > >> Geert
> > > >>
> > > >>
> > > >>
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 9
> > > Date: Fri, 9 Feb 2018 14:58:53 -0600
> > > From: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > To: Gnucash userlist <gnucash-user at gnucash.org>
> > > Subject: Re: Applying Customer overpayments
> > > Message-ID:
> > > <CAB7LH2_6-hqhdpx4nhmOMaqBP_xHvUdCWS3yxz3pzz6GVWytAA at mail.
> > > gmail.com>
> > > Content-Type: text/plain; charset="UTF-8"
> > >
> > > copying to list - sorry still using a webmail interface I'm not used
> to.
> > > -------------
> > >
> > > Alan,
> > >
> > > When making the payment, you should have had the option to choose the
> > > balancing account, you would have had to select AR instead of Checking
> > if I
> > > recall correctly.
> > >
> > > I'd delete the entire payment and re-apply it.
> > >
> > > The overpayment resides in AR as a contra-balance. You could transfer
> > this
> > > to a Customer Deposits liability account if you think you won't apply
> it
> > > for some time and don't want to lose track or just want to keep things
> > neat
> > > and tidy. Doing this also allows you to see WHO has overpaid/pre-paid
> and
> > > by how much. If the money stays in AR it's just a lump total for all
> > > customers. You could also end up with odd balances in AR and not see
> > > clearly why at a glance without sifting through historical
> transactions.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On Fri, Feb 9, 2018 at 12:45 AM, Alan Johnson <alan at argentwolf.org>
> > wrote:
> > >
> > > >
> > > > *replying to the list
> > > >
> > > > Geert,
> > > >
> > > > Thanks. That worked. However it wanted to apply the funds to the
> > checking
> > > > account (which were already deposited/received). I deleted that part
> of
> > > the
> > > > transaction from the AR register, and the balance offset still works,
> > > just
> > > > does not reflect as a payment on the customer report. Is there a
> better
> > > > account to debit the funds? In the balance sheet / P&L I don't see
> any
> > > sort
> > > > of customer funds held/liability that would be where the offset would
> > go.
> > > >
> > > > Also, this feature wasn't in the documentation (at least that I could
> > > > find). The documentation merely states that GnuCash would keep track
> of
> > > any
> > > > overpayment. It sounds like a feature like QuickBoox payment system
> > check
> > > > box "Apply customer balance to invoice" is needed.
> > > > Alan
> > > >
> > > >
> > > >
> > > > On 2/8/2018 1:09 PM, Geert Janssens wrote:
> > > >
> > > >> Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson:
> > > >>
> > > >>> Hello, I'm having an issue with GnuCash. A customer has a
> > > >>> overpayment/credit balance. How do I apply it to an invoice so that
> > it
> > > >>> comes out of the AR report at the bottom of the customer report?
> The
> > > >>> total due / sums are correct, but the customer report has a 91+ day
> > > >>> balance of (0.03). I would like to apply the payment to an invoice
> /
> > > fix
> > > >>> the AR box on the customer report. This is on version 2.6.19.
> > > >>>
> > > >>> - Go to Business->Customer->Process Payment
> > > >> - Select the customer you refer to above
> > > >> - You should get a list of open invoices and overpayments
> > > >> - Select both the 0.03 overpayment and the invoice you want to apply
> > it
> > > to
> > > >> (using shift- or ctrl-click)
> > > >> - If you only want to apply this 0.03, adjust the amount to exactly
> > that
> > > >> 0.03
> > > >> - Click Ok
> > > >>
> > > >> Regards,
> > > >>
> > > >> Geert
> > > >>
> > > >>
> > > >>
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> > > >
> > >
> > >
> > > ------------------------------
> > >
> > > Message: 10
> > > Date: Fri, 9 Feb 2018 16:51:40 -0700
> > > From: James Fuller <james at plateautel.net>
> > > To: Adrien Monteleone <adrien.monteleone at gmail.com>
> > > Cc: Gnucash Users <gnucash-user at gnucash.org>
> > > Subject: Re: GNUCASH Free Accounting Software
> > > Message-ID: <DADB9E54-48B7-4460-A3C1-82B532648E46 at plateautel.net>
> > > Content-Type: text/plain; charset=utf-8
> > >
> > > Hi Adrian,
> > >
> > > Thank you VERY much for your help.
> > >
> > > James Fuller
> > >
> > > Sent from my iPad
> > >
> > > > On Feb 9, 2018, at 1:46 PM, Adrien Monteleone <
> > > adrien.monteleone at gmail.com> wrote:
> > > >
> > > > James,
> > > >
> > > > The date range selectors are in the General Tab of the Options window
> > for
> > > > any report. There are some quick choices such as 'start of last year'
> > or
> > > > you can pick specific dates.
> > > >
> > > > Regards,
> > > > Adrien
> > > >
> > > > On Thu, Feb 8, 2018 at 11:28 PM, David T. via gnucash-user <
> > > > gnucash-user at gnucash.org> wrote:
> > > >
> > > >> Or run a transaction report and set the dates accordingly.
> > > >>
> > > >>> On Feb 9, 2018,
More information about the gnucash-user
mailing list