If you subscribe to getting all messages instead of the digest, then most mail clients will do this. I use both Gmail and Thunderbird and they work nicely for lists like this.
Then adding a filter to put the list messages in a separate folder so that I can read it later. On Sat, Feb 10, 2018, 00:37 Roger Hatton <[email protected]> wrote: > I hope this is the correct way to start a new topic? > > Quote > Send gnucash-user mailing list submissions to > [email protected] > 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, <[email protected]> wrote: > > > Send gnucash-user mailing list submissions to > > [email protected] > > > > 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 > > [email protected] > > > > You can reach the person managing the list at > > [email protected] > > > > 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 <[email protected]> > > To: [email protected] > > Subject: Re: Check writing > > Message-ID: <[email protected]> > > 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 <[email protected]> > > To: Ronal B Morse <[email protected]> > > Cc: Gnucash Users <[email protected]> > > Subject: Re: Check writing > > Message-ID: > > <CADYgSbkcnMURpqGF959YA8-qqBP+ZSPvWNz5ziUH+QKLLDzqpQ@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" <[email protected]> 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 > > > [email protected] > > > 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 <[email protected]> > > To: [email protected] > > 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, <[email protected]> > > wrote: > > > > > Send gnucash-user mailing list submissions to > > > [email protected] > > > > > > 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 > > > [email protected] > > > > > > You can reach the person managing the list at > > > [email protected] > > > > > > 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 <[email protected]> > > > To: Gnucash userlist <[email protected]> > > > Subject: Re: How to relate Transfer Sales to Cash to Customer? > > > Message-ID: > > > <CAB7LH29wYiAmmVErTCr+dKSRa1mWdc+iEyXdces8QX7OJ6ngMA@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 < > > > [email protected]> 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: AC <[email protected]> > > > Cc: GnuCash users group <[email protected]> > > > Subject: Re: Tracking credit card points > > > Message-ID: > > > <CADu-kvcsTKQNPkAoEC7ucRYu15zLQ+w0JGAVMPMSnxYgCvx4hA@mail. > > > gmail.com> > > > Content-Type: text/plain; charset="UTF-8" > > > > > > On Mon, Feb 5, 2018 at 3:40 PM, AC <[email protected]> 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 <[email protected]> > > > To: cicko <[email protected]> > > > Cc: [email protected] > > > Subject: Re: Latest version for Windows? > > > Message-ID: <[email protected]> > > > Content-Type: text/plain; charset=utf-8 > > > > > > > > > > > > > On Feb 9, 2018, at 7:41 AM, John Ralls <[email protected]> wrote: > > > > > > > > > > > > > > > >> On Feb 9, 2018, at 5:57 AM, cicko <[email protected]> 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 <[email protected]> > > > To: [email protected] > > > Subject: Multi column reports methodology? > > > Message-ID: > > > <CADsj1Q77cKRJvCd3L+hSaGUieP=o57oXjgMmrJxDZjbw1EtsBQ@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 <[email protected]> > > > To: "[email protected]" <[email protected]> > > > Subject: Re: Duplicating Accounts? > > > Message-ID: > > > <CAB7LH29FDhaJYRsyW7-4oDkzh63Jo5T1zYws6TgmQJd515DJH > > > [email protected]> > > > 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 < > > > [email protected]> 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Gnucash userlist <[email protected]> > > > Subject: Re: 13 Column Reporting Starting July ending June plus Total > > > Message-ID: > > > <CAB7LH2_fxpJb+LNJiSSKj5NkHr_r_okLQqD59q9VLxTOkFJ8bg@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 <[email protected]> > 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Gnucash Users <[email protected]> > > > Subject: Re: GNUCASH Free Accounting Software > > > Message-ID: > > > <CAB7LH297_rDwW3+ofAerQm58QAGy-7WxC+Q8uGh=G42wS > > > [email protected]> > > > 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 < > > > [email protected]> wrote: > > > > > > > Or run a transaction report and set the dates accordingly. > > > > > > > > > On Feb 9, 2018, at 5:20 AM, David Carlson < > > [email protected] > > > > > > > > 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 <[email protected] > > > > > > 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 < > > > > >> [email protected]> wrote: > > > > >>> > > > > >>> the > > > > >> > > > > >> _______________________________________________ > > > > >> gnucash-user mailing list > > > > >> [email protected] > > > > >> 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 > > > > > [email protected] > > > > > 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Alan Johnson <[email protected]> > > > Cc: Gnucash userlist <[email protected]> > > > Subject: Re: Applying Customer overpayments > > > Message-ID: > > > <CAB7LH2-eWHc+bK4h0m3FhyB7C5rgUmcpTjzPxwhQ46 > > > [email protected]> > > > 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 <[email protected]> > > 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Gnucash userlist <[email protected]> > > > Subject: Re: Applying Customer overpayments > > > Message-ID: > > > <CAB7LH2_6-hqhdpx4nhmOMaqBP_xHvUdCWS3yxz3pzz6GVWytAA@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 <[email protected]> > > 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Adrien Monteleone <[email protected]> > > > Cc: Gnucash Users <[email protected]> > > > Subject: Re: GNUCASH Free Accounting Software > > > Message-ID: <[email protected]> > > > 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 < > > > [email protected]> 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 < > > > > [email protected]> wrote: > > > > > > > >> Or run a transaction report and set the dates accordingly. > > > >> > > > >>> On Feb 9, 2018, at 5:20 AM, David Carlson < > > [email protected] > > > > > > > >> 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 <[email protected] > > > > > >> 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 < > > > >>>> [email protected]> wrote: > > > >>>>> > > > >>>>> the > > > >>>> > > > >>>> _______________________________________________ > > > >>>> gnucash-user mailing list > > > >>>> [email protected] > > > >>>> 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 > > > >>> [email protected] > > > >>> 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 > > > >> [email protected] > > > >> 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: [email protected] > > > Subject: Check writing > > > Message-ID: <[email protected]> > > > 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 > > > [email protected] > > > 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 <[email protected]> > > To: Roger Hatton <[email protected]>, Gnucash Users > > <[email protected]> > > Subject: Re: 13 Column Reporting Starting July ending June plus Total > > Message-ID: <[email protected]> > > 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 <[email protected]> > 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, <[email protected]> > > wrote: > > > > > Send gnucash-user mailing list submissions to > > > [email protected] > > > > > > 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 > > > [email protected] > > > > > > You can reach the person managing the list at > > > [email protected] > > > > > > 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 <[email protected]> > > > To: Gnucash userlist <[email protected]> > > > Subject: Re: How to relate Transfer Sales to Cash to Customer? > > > Message-ID: > > > <CAB7LH29wYiAmmVErTCr+dKSRa1mWdc+iEyXdces8QX7OJ6ngMA@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 < > > > [email protected]> 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: AC <[email protected]> > > > Cc: GnuCash users group <[email protected]> > > > Subject: Re: Tracking credit card points > > > Message-ID: > > > <CADu-kvcsTKQNPkAoEC7ucRYu15zLQ+w0JGAVMPMSnxYgCvx4hA@mail. > > > gmail.com> > > > Content-Type: text/plain; charset="UTF-8" > > > > > > On Mon, Feb 5, 2018 at 3:40 PM, AC <[email protected]> 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 <[email protected]> > > > To: cicko <[email protected]> > > > Cc: [email protected] > > > Subject: Re: Latest version for Windows? > > > Message-ID: <[email protected]> > > > Content-Type: text/plain; charset=utf-8 > > > > > > > > > > > > > On Feb 9, 2018, at 7:41 AM, John Ralls <[email protected]> wrote: > > > > > > > > > > > > > > > >> On Feb 9, 2018, at 5:57 AM, cicko <[email protected]> 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 <[email protected]> > > > To: [email protected] > > > Subject: Multi column reports methodology? > > > Message-ID: > > > <CADsj1Q77cKRJvCd3L+hSaGUieP=o57oXjgMmrJxDZjbw1EtsBQ@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 <[email protected]> > > > To: "[email protected]" <[email protected]> > > > Subject: Re: Duplicating Accounts? > > > Message-ID: > > > <CAB7LH29FDhaJYRsyW7-4oDkzh63Jo5T1zYws6TgmQJd515DJH > > > [email protected]> > > > 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 < > > > [email protected]> 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Gnucash userlist <[email protected]> > > > Subject: Re: 13 Column Reporting Starting July ending June plus Total > > > Message-ID: > > > <CAB7LH2_fxpJb+LNJiSSKj5NkHr_r_okLQqD59q9VLxTOkFJ8bg@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 <[email protected]> > 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Gnucash Users <[email protected]> > > > Subject: Re: GNUCASH Free Accounting Software > > > Message-ID: > > > <CAB7LH297_rDwW3+ofAerQm58QAGy-7WxC+Q8uGh=G42wS > > > [email protected]> > > > 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 < > > > [email protected]> wrote: > > > > > > > Or run a transaction report and set the dates accordingly. > > > > > > > > > On Feb 9, 2018, at 5:20 AM, David Carlson < > > [email protected] > > > > > > > > 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 <[email protected] > > > > > > 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 < > > > > >> [email protected]> wrote: > > > > >>> > > > > >>> the > > > > >> > > > > >> _______________________________________________ > > > > >> gnucash-user mailing list > > > > >> [email protected] > > > > >> 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 > > > > > [email protected] > > > > > 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Alan Johnson <[email protected]> > > > Cc: Gnucash userlist <[email protected]> > > > Subject: Re: Applying Customer overpayments > > > Message-ID: > > > <CAB7LH2-eWHc+bK4h0m3FhyB7C5rgUmcpTjzPxwhQ46 > > > [email protected]> > > > 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 <[email protected]> > > 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Gnucash userlist <[email protected]> > > > Subject: Re: Applying Customer overpayments > > > Message-ID: > > > <CAB7LH2_6-hqhdpx4nhmOMaqBP_xHvUdCWS3yxz3pzz6GVWytAA@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 <[email protected]> > > 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 > > > > [email protected] > > > > 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 <[email protected]> > > > To: Adrien Monteleone <[email protected]> > > > Cc: Gnucash Users <[email protected]> > > > Subject: Re: GNUCASH Free Accounting Software > > > Message-ID: <[email protected]> > > > 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 < > > > [email protected]> 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 < > > > > [email protected]> wrote: > > > > > > > >> Or run a transaction report and set the dates accordingly. > > > >> > > > >>> On Feb 9, 2018, _______________________________________________ gnucash-user mailing list [email protected] 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.
