gnucash-user Digest, Vol 179, Issue 34

Roger Hatton roghat3 at gmail.com
Sat Feb 10 01:36:32 EST 2018


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, 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
> > *********************************************
> >
> _______________________________________________
> 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.
>
> ------------------------------
>
> 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 34
> *********************************************
>


More information about the gnucash-user mailing list