gnucash-user Digest, Vol 139, Issue 5
Guy K
theguy at san.rr.com
Fri Oct 3 13:23:18 EDT 2014
SaSA
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: Shared asset with brother, mortgage involved, not mine,
> how to account for that? (Daniel Farf?n Mu?oz)
> 2. Re: Shared asset with brother, mortgage involved, not mine,
> how to account for that? (Aaron Laws)
> 3. Re: Cash versus Accrual Accounting (Mike or Penny Novack)
> 4. Re: Shared asset with brother, mortgage involved, not mine,
> how to account for that? (Mike or Penny Novack)
> 5. RE: Cash versus Accrual Accounting (Mark Seeba)
> 6. Re: Does GnuCash possess a Journal Entry numbering facility
> (Derek Atkins)
> 7. Re: Cash Flow Report (Derek Atkins)
> 8. Re: Setting up recurring mortgage payment (Derek Atkins)
> 9. RE: Setting up recurring mortgage payment (Scott Roe)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Fri, 3 Oct 2014 10:38:05 -0300
>From: Daniel Farf?n Mu?oz <dfarfanmunoz at gmail.com>
>To: Aaron Laws <dartme18 at gmail.com>
>Cc: GnuCash users group <gnucash-user at gnucash.org>
>Subject: Re: Shared asset with brother, mortgage involved, not mine,
> how to account for that?
>Message-ID:
> <CACXU5T=tJybzbedq-8rSQr3=HZr64o5k-_HLVO8T1R4kB9372g at mail.gmail.com>
>Content-Type: text/plain; charset=UTF-8
>
>Thanks. We are doing business as ourselves, no company involved.
>
>
>2014-10-03 10:34 GMT-03:00 Aaron Laws <dartme18 at gmail.com>:
>
>> (Not an accountant.)
>>
>> Is there a business or company involved, or are you two doing business as
>> yourselves?
>>
>>
>> In Christ,
>> Aaron Laws
>>
>> On Fri, Oct 3, 2014 at 6:24 AM, Daniel Farf?n Mu?oz <
>> dfarfanmunoz at gmail.com> wrote:
>>
>>> Hi everyone, I hope someone can help me with this:
>>>
>>> My brother and I bought an office together. I did a downpayment of 5% of
>>> the value of the office. My brother paid the other 5%. He got a mortgage
>>> of
>>> 90%. We rent the office to someone else, I receive the monthly rent, and
>>> then I transfer the money (minus some operational charges) to his account
>>> so he can pay the mortgage.
>>>
>>> So, I own the 5% of the value of the office, plus some money I earn from
>>> the rent. But how do I account for that in gnucash? How do I know how much
>>> of the office I own? Or how much I'm earning by renting it?
>>>
>>> Thanks in advance.
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> 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, 3 Oct 2014 09:51:08 -0400
>From: Aaron Laws <dartme18 at gmail.com>
>To: Daniel Farf?n Mu?oz <dfarfanmunoz at gmail.com>
>Cc: GnuCash users group <gnucash-user at gnucash.org>
>Subject: Re: Shared asset with brother, mortgage involved, not mine,
> how to account for that?
>Message-ID:
> <CADu-kvcYoyu-EOfqSDp_r6Mm-7RFCBPe00-FPabBz0afCycUOg at mail.gmail.com>
>Content-Type: text/plain; charset=UTF-8
>
>(Not an accountant)
>
>I hate to speak out before a more experienced hand, but then again, I
>certainly won't speak *after* another! Perhaps I can stumble forward to
>provide a starting place for one of the greater.
>
>When rent comes in, if the rent cheque is written to your brother, then he
>writes you a cheque:
>
>assets:chequing R/2
>revenue:rent R/2
>
>Where R is the full rent amount. When the mortgage payment is due, assuming
>you both write a cheque to the mortgage holder:
>
>assets:myoffice (P/2-I/2)+E
>expense:interest I/2
>assets:chequing P/2+E
>
>Where P is the full mortgage payment, I is the interest acrued, and E is
>any extra payment you make. When work is done or bills come in for the
>building:
>
>expense:repairs B/2
>assets:chequing B/2
>
>Where B is the amount of the bill. Does that make sense? With this scheme,
>the timing of rent payments and mortgage payments is disconnected: you can
>pay mortgage quarterly and earn rent weekly, for instance. I'm assuming you
>split the rent income and mortgage payment down the middle. I'm also
>assuming that your brother would be okay with you paying extra and owning
>more of the building with extra payments!
>
>
>
>
>
>
>In Christ,
>Aaron Laws
>
>On Fri, Oct 3, 2014 at 9:38 AM, Daniel Farf?n Mu?oz <dfarfanmunoz at gmail.com>
>wrote:
>
>> Thanks. We are doing business as ourselves, no company involved.
>>
>>
>> 2014-10-03 10:34 GMT-03:00 Aaron Laws <dartme18 at gmail.com>:
>>
>>> (Not an accountant.)
>>>
>>> Is there a business or company involved, or are you two doing business as
>>> yourselves?
>>>
>>>
>>> In Christ,
>>> Aaron Laws
>>>
>>> On Fri, Oct 3, 2014 at 6:24 AM, Daniel Farf?n Mu?oz <
>>> dfarfanmunoz at gmail.com> wrote:
>>>
>>>> Hi everyone, I hope someone can help me with this:
>>>>
>>>> My brother and I bought an office together. I did a downpayment of 5% of
>>>> the value of the office. My brother paid the other 5%. He got a mortgage
>>>> of
>>>> 90%. We rent the office to someone else, I receive the monthly rent, and
>>>> then I transfer the money (minus some operational charges) to his account
>>>> so he can pay the mortgage.
>>>>
>>>> So, I own the 5% of the value of the office, plus some money I earn from
>>>> the rent. But how do I account for that in gnucash? How do I know how
>>>> much
>>>> of the office I own? Or how much I'm earning by renting it?
>>>>
>>>> Thanks in advance.
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> -----
>>>> 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: Fri, 03 Oct 2014 10:08:49 -0400
>From: Mike or Penny Novack <stepbystepfarm at mtdata.com>
>To: John Morris <johnjeff at editide.us>
>Cc: gnucash mailinglist <gnucash-user at gnucash.org>
>Subject: Re: Cash versus Accrual Accounting
>Message-ID: <542EADF1.4050109 at mtdata.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>John Morris wrote:
>
>>
>> So, does anyone have ideas of how to make cash accounting work in GnuCash? I found http://wiki.gnucash.org/wiki/Cash_Based_Accounting suggesting that GnuCash support for cash-based accounting is still in the discussion stage, so I don't expect to find a setting anywhere.
>>
>
>It isn't that gnucash doesn't support cash based accounting (it does)
>but that the "business features" extension doesn't. I doubt it will make
>you feel any better, but even the "accrual" business features don't
>support some bits (and this is true for many of the commercial
>alternatives). For example, there is no way to have invoices indicating
>some items not "due" till a future date and so those show up in the
>"overdue" reports before they should <<for example, a non-profit often
>has PLEDGES made to it and those ARE "receivables" as a pledge is
>technically enforceable. But a pledge might be in the form $1000/year
>for the next five years and that is NOT the same as $5000 due
>immediately. Ideally the non-profit would like to be able to produce
>statements showing any balance due NOW. Trust me, I see statements from
>non-profits using this or that commercial product getting this wrong>>
>
>What you want here is an invoice feature separate from "receivables".
>
>Suggestion. Gnucash MIGHT be able to deliver what you want via a set of
>subsidiary books. In other words, separate from your main books (used to
>show income and expenses for tax purposes, kept on a cash basis) you
>might be able to devise a set of books for "billing" kept on an accrual
>basis that would let you produce invoices and the aging reports, etc. I
>haven't put on my analyst hat enough to see exactly how best to be done
>and of course there is the added work of entering the incoming payments
>in two places, but I think would be possible. In large systems would be
>a separate receivables system that fed the main books instead of
>manually entering twice.
>
>Michael D Novack, FLMI
>
>
>------------------------------
>
>Message: 4
>Date: Fri, 03 Oct 2014 10:24:28 -0400
>From: Mike or Penny Novack <stepbystepfarm at mtdata.com>
>To: Daniel Farf?n Mu?oz <dfarfanmunoz at gmail.com>
>Cc: GnuCash users group <gnucash-user at gnucash.org>
>Subject: Re: Shared asset with brother, mortgage involved, not mine,
> how to account for that?
>Message-ID: <542EB19C.6060408 at mtdata.com>
>Content-Type: text/plain; charset=UTF-8; format=flowed
>
>Daniel Farf?n Mu?oz wrote:
>
>>Thanks. We are doing business as ourselves, no company involved.
>>
>>
>>
>Even so, the "enterprise" can have its own set of books (and should,
>especially in a case like this with lots of transfers between the
>partners). Look up how to do accounting for "general partnerships" (not
>gnucash specific)
>
>Michael
>
>
>------------------------------
>
>Message: 5
>Date: Fri, 3 Oct 2014 15:12:20 +0000
>From: Mark Seeba <mseeba at streamwrite.com>
>To: John Morris <johnjeff at editide.us>, gnucash mailinglist
> <gnucash-user at gnucash.org>
>Subject: RE: Cash versus Accrual Accounting
>Message-ID:
> <b317a5c20e80404e9a6251432f9c5da2 at SN2PR0801MB560.namprd08.prod.outlook.com>
>
>Content-Type: text/plain; charset="us-ascii"
>
>I use GnuCash for cash accounting for my business. Here is how I handle it:
>
>
>
>1. Sometimes I send invoices to customers unposted - You can still print and send them
>
>2. If I need to track them on my receivables report, I have to post them
>
>a. You can post with a future post date
>
>b. Before closing the books at the end of the accounting period, you can unpost and repost any unpaid invoices into the next accounting period
>
>
>
>
>
>Mark Seeba
>
>MCSE: Communication
>
>Streamwrite
>
>Latest News: http://streamwrite.com/blog/
>
>Direct: 510-923-9210
>
>Fax: 510-420-4970
>
>Service Desk: 800.333.8394 (Option 4)
>
>www.streamwrite.com
>
>
>
>
>
>
>
>This e-mail (including any attachments) may contain information confidential to ATI and is intended only for the use of the intended recipient(s). If the reader of this message is not the intended recipient(s), you are notified that you have received this message in error and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this message in error, please delete this message and notify the sender immediately.
>
>
>
>-----Original Message-----
>From: gnucash-user [mailto:gnucash-user-bounces+mseeba=streamwrite.com at gnucash.org] On Behalf Of John Morris
>Sent: Friday, October 3, 2014 6:27 AM
>To: gnucash mailinglist
>Subject: Cash versus Accrual Accounting
>
>
>
>Hi All,
>
> I started using GnuCash last summer, and I'm getting used to it for my personal finances. Therefore, I'm starting to learn the invoicing features so my wife can use GnuCash for the business accounting. Our business is very small and simple: no bills, no taxes, just customers and invoices for the editing work we do. However, I seem to have run into a small complication and I'm hoping someone with more experience will take pity on me and tell me how to make this work for us.
>
>
>
> The issue is that we use cash accounting for our income taxes. Therefore, if we bill a customer in December 2014 but receive payment in January 2015, that payment goes on our 2015 income tax return, not the 2014 income tax return. Unfortunately, it appears that the posting date determines when the income account gets hit for each new invoice, not when the payment is received. This gives us a conflict because we would like to be able to pull a report showing how much we billed in each of the last few weeks so we can know that we are on track there. However, we want the income account to show the income only when we get paid.
>
>
>
> I thought of simply posting the invoice after we receive payment; I'm not using the invoice printing facility because it is not customizable enough for our needs. However, that would leave us without a way to know when the work was billed.
>
>
>
> So, does anyone have ideas of how to make cash accounting work in GnuCash? I found http://wiki.gnucash.org/wiki/Cash_Based_Accounting suggesting that GnuCash support for cash-based accounting is still in the discussion stage, so I don't expect to find a setting anywhere. I thought of once a year creating a single transaction in the income account for all outstanding invoices, moving them from the current year to the next year. That seems like it could be workable as long as I remember to do it, but it would be nice to have something more automatic and less like a kludge.
>
>
>
>
>
> As a second question, it would also be nice to be able to see how much we are owed in weekly increments. I found the Receivables Aging report, but it does not exactly meet my need. First, it lumps all invoices due in the future into a single category, but I would like to know how much is due this week, how much is due next week and so on. Second, it shows how much is 0 to 30 days late and how much is 60 to 90 days late. I would like to change those periods to 0 to 7, 7 to 14, etc. Is there another report that would come closer to what I need or do I have to learn Scheme?
>
>
>
>Thanks,
>
>John
>
>
>
>
>
>_______________________________________________
>
>gnucash-user mailing list
>
>gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
>
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>-----
>
>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, 03 Oct 2014 11:42:53 -0400
>From: Derek Atkins <warlord at MIT.EDU>
>To: "David Britton" <bbaruu at gmail.com>
>Cc: 'gnucash-user' <gnucash-user at gnucash.org>
>Subject: Re: Does GnuCash possess a Journal Entry numbering facility
>Message-ID: <sjmoattrwg2.fsf at securerf.ihtfp.org>
>Content-Type: text/plain
>
>I would just add:
>
>If you want to see it, submit a patch... :)
>It is unlikely that the existing developers will ever implement it.
>
>-derek
>
>"David Britton" <bbaruu at gmail.com> writes:
>
>> OK then! That sounds firm. LOL
>>
>> -----Original Message-----
>> From: John Ralls [mailto:jralls at ceridwen.us]
>> Sent: Thu, 02 Oct, 2014 11:22 AM
>> To: David Britton
>> Cc: Michael Hendry; gnucash-user
>> Subject: Re: Does GnuCash possess a Journal Entry numbering facility
>>
>>
>> On Oct 2, 2014, at 6:48 AM, David Britton <bbaruu at gmail.com> wrote:
>>
>>> I see, Michael. Decent workaround.
>>>
>>> @John Ralls: you emailed me with your response. In it, you state that
>>> "a Journal Entry Number wouldn't mean anything in the normal accounting
>> sense."
>>> I think Michael and I could agree that the action of posting should be
>>> the trigger to create a JE# which then would mean something; you're
>>> saying that the posting trigger is already by-passed. It's here the
>>> process hits the rocks where Michael and I are concerned. In contrast
>>> the old Bedford Accounting/Simply Accounting booked transactions in
>>> real-time like Gnucash but did generate a Number. So, conceptually
>>> there's a way through. And it makes a lot of sense from an Audit
>>> Trail perspective since Gnucash could be seen as an indexing system.
>>> Personally, I don't use the suggested internal reconciliation facility
>>> that you mention - never found it useful to mark entries; good to know,
>> though, that there's technique out there.
>>>
>>> @Michael and @John: So there's a history here. A number of folks
>>> find that Gnucash has this perceived shortcoming. I strongly suggest
>>> that the team look hard at adding this feature. It's likely a lot of
>>> work; I can appreciate that. But I think it's key. Has there been
>>> any developer team debate around this?
>>
>> Please remember to copy the list on all replies. Use "reply all" or, if your
>> client supports it, "reply list".
>>
>> Yes. We're not going to do it. Auditability is not a design goal of GnuCash:
>> GnuCash is intended for home and very small business use where reconciling
>> with one's monthly bank statements is the only required auditing. If that
>> doesn't meet your needs, then GnuCash isn't the right program for you.
>>
>> Regards,
>> John Ralls
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>
>--
> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> Member, MIT Student Information Processing Board (SIPB)
> URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
> warlord at MIT.EDU PGP key available
>
>
>------------------------------
>
>Message: 7
>Date: Fri, 03 Oct 2014 11:53:07 -0400
>From: Derek Atkins <warlord at MIT.EDU>
>To: Charles Brescia <clbrescia at gmail.com>
>Cc: gnucash-user at gnucash.org
>Subject: Re: Cash Flow Report
>Message-ID: <sjmk34hrvz0.fsf at securerf.ihtfp.org>
>Content-Type: text/plain
>
>Hi,
>
>This sounds like you want a P&L Report, not a Cash Flow report.
>
>-derek
>
>Charles Brescia <clbrescia at gmail.com> writes:
>
>> Hello:
>> I am currently running GnuCash 2.4.15 in Linux Ubuntu 14.04. I use
>> cash flow reports extensively and would like to see them display a
>> little differently. Currently if I have an expense category/account
>> that has either rebates or reimbursements the rebates/reimbursements
>> display as an income category as the same name as the expense category,
>> and then the expenses show under expenses.
>> What I would prefer is that the rebates/reimbursements to an expense
>> category show as a negative expense or in other words to reduce the
>> total amount of the expense. The same would hold true for negative
>> incomes as well, as they are currently showing up under expenses rather
>> than adjusting the main income category.
>> Also when you initially run a report (any report) the progress bar
>> in the lower right hand corner works. But if you select options make
>> changes and rerun the report the progress bar no longer shows the
>> progress. Not a big deal but it would be nice particularly for a large
>> report that may take a while to load.
>> Thank you for your time.
>>
>> Charles
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>
>--
> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> Member, MIT Student Information Processing Board (SIPB)
> URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
> warlord at MIT.EDU PGP key available
>
>
>------------------------------
>
>Message: 8
>Date: Fri, 03 Oct 2014 11:59:57 -0400
>From: Derek Atkins <warlord at MIT.EDU>
>To: Scott Roe <scott384 at hotmail.com>
>Cc: GnuCash List <gnucash-user at lists.gnucash.org>
>Subject: Re: Setting up recurring mortgage payment
>Message-ID: <sjmfvf5rvnm.fsf at securerf.ihtfp.org>
>Content-Type: text/plain; charset=utf-8
>
>Hi,
>
>I think there is a way -- you can set the number of "months remaining"
>on the first page of the M&L Druid (along with the length of the
>mortgage). So e.g. you can set it to 360 months, with 264 months
>remaining.
>
>-derek
>
>Scott Roe <scott384 at hotmail.com> writes:
>
>> Hi John:
>>
>> Thanks for that. Since the mortgage has been running for 8 years,
>> David told me there is no way to jump in on a mortgage already
>> underway so I've reverted to manually putting in the transactions.
>>
>> Thanks,
>>
>> Scott
>>
>>> Subject: Re: Setting up recurring mortgage payment
>>> From: jralls at ceridwen.us
>>> Date: Tue, 30 Sep 2014 15:02:08 -0700
>>> CC: gnucash-user at lists.gnucash.org
>>> To: scott384 at hotmail.com
>>>
>>>
>>> On Sep 26, 2014, at 4:01 PM, John Ralls <jralls at ceridwen.us> wrote:
>>>
>>> >
>>> > On Sep 26, 2014, at 2:03 PM, Scott Roe <scott384 at hotmail.com> wrote:
>>> >
>>> >> Hi John:
>>> >>
>>> >> Just a quick note to thank you again for your assistance below.
>>> >> The initial cause of my errors with split entry were the two
>>> >> currencies, and from there I discovered, through further
>>> >> investigation, and some trial and error, that I was making
>>> >> several other small errors, and many of the split entries were in
>>> >> the imbalance folder, and I was able to clear them all off.
>>> >>
>>> >> I have another issue and I've been trying to make it work with no
>>> >> success, so hope you don't mind me asking. I have a mortgage that
>>> >> I've been paying for 8 years. Originally a 20 year mortgage,
>>> >> I've made some extra payments over time. I would now like to set
>>> >> up the loan recurring payments in gnucash to save manually
>>> >> entering them and be able to calculate my interest paid at the
>>> >> end of the year for my tax filing rather then to ask the Bank
>>> >> every year to give me the figure. I was attempting to take the
>>> >> remaining principal, the interest rate, the payment frequency,
>>> >> and payment amount to set up the recurring. It is a weekly paid
>>> >> mortgage, and when I complete the mortgage loan wizard, the
>>> >> principal and interest are the monthly amounts although I've
>>> >> entered weekly everywhere that I can.
>>> >>
>>> >> Any assistance appreciated,
>>> >
>>> > Scott,
>>> >
>>> > Please use the mailing list for all questions. There are more
>>> > developers there along with a bunch of expert users, so you'll
>>> > have a better chance of getting a useful answer from the list than
>>> > from a single developer. That's especially true in this case, as
>>> > I'm not particularly familiar with the Mortgage Assistant.
>>> >
>>> > The setting for how often the scheduled transaction runs is set on
>>> > the editor's Frequency tab, but changing that isn't going to help
>>> > much if the Mortgage Assistant insists on calculating the monthly
>>> > amount. Is that the case?
>>>
>>> I just tested this and setting the frequency to ?weekly? and picking
>>> a day (I picked Friday) in the ?Repayment Frequency? box on the
>>> fourth screen of the assistant, the one where you also set the
>>> payment-from and interest-to accounts, generated a correct SX with
>>> weekly payments.
>>>
>>> Regards,
>>> John Ralls
>>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>
>--
> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> Member, MIT Student Information Processing Board (SIPB)
> URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
> warlord at MIT.EDU PGP key available
>
>
>
>------------------------------
>
>Message: 9
>Date: Fri, 3 Oct 2014 12:11:42 -0400
>From: Scott Roe <scott384 at hotmail.com>
>To: Derek Atkins <warlord at mit.edu>
>Cc: GnuCash List <gnucash-user at lists.gnucash.org>
>Subject: RE: Setting up recurring mortgage payment
>Message-ID: <BLU173-W19EF29A5B00E9F660E56FB8FA60 at phx.gbl>
>Content-Type: text/plain; charset="Windows-1252"
>
>Hi Derek:
>
>Thanks, I'll try that!
>
>Scott
>
>> From: warlord at MIT.EDU
>> To: scott384 at hotmail.com
>> CC: jralls at ceridwen.us; gnucash-user at lists.gnucash.org
>> Subject: Re: Setting up recurring mortgage payment
>> Date: Fri, 3 Oct 2014 11:59:57 -0400
>>
>> Hi,
>>
>> I think there is a way -- you can set the number of "months remaining"
>> on the first page of the M&L Druid (along with the length of the
>> mortgage). So e.g. you can set it to 360 months, with 264 months
>> remaining.
>>
>> -derek
>>
>> Scott Roe <scott384 at hotmail.com> writes:
>>
>> > Hi John:
>> >
>> > Thanks for that. Since the mortgage has been running for 8 years,
>> > David told me there is no way to jump in on a mortgage already
>> > underway so I've reverted to manually putting in the transactions.
>> >
>> > Thanks,
>> >
>> > Scott
>> >
>> >> Subject: Re: Setting up recurring mortgage payment
>> >> From: jralls at ceridwen.us
>> >> Date: Tue, 30 Sep 2014 15:02:08 -0700
>> >> CC: gnucash-user at lists.gnucash.org
>> >> To: scott384 at hotmail.com
>> >>
>> >>
>> >> On Sep 26, 2014, at 4:01 PM, John Ralls <jralls at ceridwen.us> wrote:
>> >>
>> >> >
>> >> > On Sep 26, 2014, at 2:03 PM, Scott Roe <scott384 at hotmail.com> wrote:
>> >> >
>> >> >> Hi John:
>> >> >>
>> >> >> Just a quick note to thank you again for your assistance below.
>> >> >> The initial cause of my errors with split entry were the two
>> >> >> currencies, and from there I discovered, through further
>> >> >> investigation, and some trial and error, that I was making
>> >> >> several other small errors, and many of the split entries were in
>> >> >> the imbalance folder, and I was able to clear them all off.
>> >> >>
>> >> >> I have another issue and I've been trying to make it work with no
>> >> >> success, so hope you don't mind me asking. I have a mortgage that
>> >> >> I've been paying for 8 years. Originally a 20 year mortgage,
>> >> >> I've made some extra payments over time. I would now like to set
>> >> >> up the loan recurring payments in gnucash to save manually
>> >> >> entering them and be able to calculate my interest paid at the
>> >> >> end of the year for my tax filing rather then to ask the Bank
>> >> >> every year to give me the figure. I was attempting to take the
>> >> >> remaining principal, the interest rate, the payment frequency,
>> >> >> and payment amount to set up the recurring. It is a weekly paid
>> >> >> mortgage, and when I complete the mortgage loan wizard, the
>> >> >> principal and interest are the monthly amounts although I've
>> >> >> entered weekly everywhere that I can.
>> >> >>
>> >> >> Any assistance appreciated,
>> >> >
>> >> > Scott,
>> >> >
>> >> > Please use the mailing list for all questions. There are more
>> >> > developers there along with a bunch of expert users, so you'll
>> >> > have a better chance of getting a useful answer from the list than
>> >> > from a single developer. That's especially true in this case, as
>> >> > I'm not particularly familiar with the Mortgage Assistant.
>> >> >
>> >> > The setting for how often the scheduled transaction runs is set on
>> >> > the editor's Frequency tab, but changing that isn't going to help
>> >> > much if the Mortgage Assistant insists on calculating the monthly
>> >> > amount. Is that the case?
>> >>
>> >> I just tested this and setting the frequency to ?weekly? and picking
>> >> a day (I picked Friday) in the ?Repayment Frequency? box on the
>> >> fourth screen of the assistant, the one where you also set the
>> >> payment-from and interest-to accounts, generated a correct SX with
>> >> weekly payments.
>> >>
>> >> Regards,
>> >> John Ralls
>> >>
>> >
>> > _______________________________________________
>> > gnucash-user mailing list
>> > gnucash-user at gnucash.org
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -----
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>> >
>>
>> --
>> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>> Member, MIT Student Information Processing Board (SIPB)
>> URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
>> warlord at MIT.EDU PGP key available
>
>
>------------------------------
>
>Subject: Digest Footer
>
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
>------------------------------
>
>End of gnucash-user Digest, Vol 139, Issue 5
>********************************************
More information about the gnucash-user
mailing list