13 Column Reporting Starting July ending June plus Total

Adrien Monteleone adrien.monteleone at gmail.com
Sat Feb 10 12:36:27 EST 2018


Yes it is. Unfortunately, those reports do not have the option of breaking
down the year into monthly and/or quarterly columns as sub-reports. You
would have to create this report from scratch which is not at present, a
trivial task.

I've thought about making one myself. If and when I tackle it, I'll be sure
to CC you when I post it to the list. I'm also interested in a multi-step
Income Statement and one that is more analytic/activity oriented rather
than lumping all expenses and revenue in one block. I suppose after solving
it once, I can easily hack a version of the Balance sheet to do the same.

For now, you can save a little time by creating a multi-column report. You
can put each month and the year in their own columns and save the report
configuration. Each year, you'd have to adjust the date range option for
each column. The downside to this approach is that each column would have
the account titles repeated. And because of this, the practical number of
columns on one report is probably about 3-4 depending on your monitor size.


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


> 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

On Fri, Feb 9, 2018 at 10:19 PM, 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.
>


More information about the gnucash-user mailing list