Re: how to balance a loan to a director against expenses made by him?

[DaveC49]

Hi,

The most direct transaction to record this is:
  Debit
Credit
Liability:DirectorsBusiness Expenses      
Asset:LoansToDirector   .

The most important thing is to annotate the transaction description field to
indicate that a reimbursement of the expenses incurred by the director has
been offset against the loan to the director. 

To record the loan to the director, if you had a need to record the original
value of the loan as well as repayment of the loan and the outstanding
balance you could use a header account with two child accounts as follows 

Asset:LoanToDirectorBalance
Asset:LoanToDirector:InitialLoanValue
Asset:LoanToDirector:LoanRepayments

The InitialLoanValue sub account which is debited by the amount of the loan
when the loan is first made and a second child account which is credited by
the amount of the repayments/reimbursements of expenses  incurred as in the
transaction shown above. 

If the loan had interest payments one could use a third child account to
record the interest payable on the loan (a debit split to this account would
record the interest with a corresponding credit split to an
Income:InterestonLoans account). The child accounts as described above would
all sum into the header account, which then records the current balance of
the loan.

Which you would choose really depends upon the level of detail you are
required to report to the company and external reporting requirements and
the  level of detail you need for your internal management of the loan.

David Cousens 



-
David Cousens
--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/how-to-balance-a-loan-to-a-director-against-expenses-made-by-him-tp4692636p4692639.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@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.

Re: Mortgage/Loan Scheduled Transaction Way Off

[John Ralls]

> On Jul 10, 2017, at 2:23 PM, ITWarrior  wrote:
> 
> Thank you both for your replies.
> 
> I've tried setting the "Month's Remaining" value to 782, but nothing changes
> at all as though this field is completely ignored. I don't see anywhere else
> where I could set the payment frequency other than in the Repayment
> Frequency section which does set the /payment frequency/ correctly but the
> /payment value/ wrong as in the earlier screenshot. It's as though there's a
> hard-coded monthly figure set that's not tied to the defined repayment
> frequency. That is, changing the repayment frequency seems to only change
> the transaction dates, not the transactions values.
> 
> Would you recommend I raise this as a bug, or is there somewhere I can
> correct this 'under the hood' that you're aware of?


It’s a bug, so please file one. Something is broken in the payment logic, it 
uses the same payment amount regardless of what one sets in the repayment box..

You could fudge it by saying that it’s a 720-month loan for 2.295%/year and 
you’d get close, but that’s not really the right answer.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@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.

Re: Fil recovery

[esris]

Maf

Thanks very much.
Greate help

esris 



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Fil-recovery-tp4692606p4692614.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@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.

Re: Mortgage/Loan Scheduled Transaction Way Off

[ITWarrior]

Thank you both for your replies.

I've tried setting the "Month's Remaining" value to 782, but nothing changes
at all as though this field is completely ignored. I don't see anywhere else
where I could set the payment frequency other than in the Repayment
Frequency section which does set the /payment frequency/ correctly but the
/payment value/ wrong as in the earlier screenshot. It's as though there's a
hard-coded monthly figure set that's not tied to the defined repayment
frequency. That is, changing the repayment frequency seems to only change
the transaction dates, not the transactions values.

Would you recommend I raise this as a bug, or is there somewhere I can
correct this 'under the hood' that you're aware of?



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Mortgage-Loan-Scheduled-Transaction-Way-Off-tp4692580p4692631.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@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.

how to balance a loan to a director against expenses made by him?

[__]

I have scenario where a company's director has received loans from the
company and wants to balance expenses made by the director (travel
costs, i.e.) against those loans.

The loan and the expenses to be balanced against those are not
directly related (which I assume shouldn't matter)

gnucash accounts involved:

- Liability account:business expenses made by director
- Asset account:   loans to director
- Expense account:   travel espenses

What logically works is to add transactions between the Asset account
(loan to director) and the Liability account (director's business
expenses account).
Maybe at the end of each month  does that sound reasonable, or is
there any other best practice for such a scenario?
___
gnucash-user mailing list
gnucash-user@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.

Re: Login help

[pfwoolver...@juno.com]

Jean-David,

Given Dave's response and my response to Dave, I am surprised that you still 
don't seem to understand that my question was about my gnucash-user account, 
and not about the GnuCash program.



Date: Sun, 9 Jul 2017 17:02:51 -0400
From: Jean-David Beyer 
To: gnucash-user@gnucash.org
Subject: Re: Login help
Message-ID: <19f5d2b0-16d6-47a7-959f-90a5b4998...@verizon.net>
Content-Type: text/plain; charset=utf-8

On 07/09/2017 09:50 AM, pfwoolver...@juno.com wrote:
> Dave,  Thanks for the info.  I viewed that page several times in recent weeks 
> and never noticed the login point. Jean-David,  Sorry for not being clear 
> about what I wanted. -- Original Message --

You are still not clear at all.

Do you have GnuCash installed on your computer or do you not? I do not
know how you could expect to run a program without installing it first.
And once it is installed all you have to do is run it. You do not login
to it.

What operating system are you running on your machine? I know only
Linux, though I know a version is available for Window (if I am not
mistaken), but even there you need to install it and run it. You do not
log into a program.


___
gnucash-user mailing list
gnucash-user@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.

Re: category removal

[Derek Atkins]

Hi,

On Mon, July 10, 2017 3:53 pm, John Heinze via gnucash-user wrote:
> How do you remove a category from the register?
> For example: Expenses:Clothes

Go to the Chart of Accounts page, select the account (Expenes:Clothes),
and then click the "Delete Account" toolbar button (or right-click delete
account).  If there are any transactions into that account it will ask if
you want to move (reassign) them.  You want to do that -- otherwise they
will all go into an Orphan account and cause more work for you later.

Hope this helps..

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@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.

category removal

[John Heinze via gnucash-user]

How do you remove a category from the register?
For example: Expenses:Clothes


."The only real mistake is the one from which we learn nothing."  
   John Powell (1834-1902)"Patience is the companion of wisdom." 
    Saint Augustine (354 AD - 430 AD)"Success is the ability to go from one 
failure 
   to another with no loss of enthusiasm."
   Sir Winston Churchill (1874 - 1965)
___
gnucash-user mailing list
gnucash-user@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.

Re: Where do I find gnucash data?

[JOHN OGDEN]

Thanks guys, big help! It was indeed where I had put it several years ago -- 
and forgotten the 'safe place'. John Revd Dr John Ogden 0118 969 6319 07746 
621447

  From: Maf. King 
 To: gnucash-user@gnucash.org; JOHN OGDEN  
 Sent: Monday, 10 July 2017, 11:55
 Subject: Re: Where do I find gnucash data?
   
Hi John,

This is in the FAQ.  see 

https://wiki.gnucash.org/wiki/FAQ#Q:_Where_is_my_GnuCash_data_file.3F

You may also want to consider the following 2 or 3 questions in the FAQ with 
regard to migrating to a new PC.

HTH,
Maf.


On Monday, 10 July 2017 11:39:02 BST JOHN OGDEN wrote:
> I'm reaching the stage of envisaging the possibility of porting all my
> gnucash data to a new PC. Problem: I can't locate the current data files.
> The program files are on drive D. (Why? My PC had a significant rebuild
> five years ago in which the two HDs were configured as two drives, D and E,
> and a new SSD was installed as drive C). It has been absolutely fine so far
> -- never put a foot wrong -- but I'm beginning to feel that I must soon
> prepare for worst case. All data files (at least, those I know about) are
> backed up regularly on an external HD. One obvious answer (I guess) is
> export/import) but is there no better way? John Revd Dr John Ogden 0118 969
> 6319 07746 621447
> ___
> gnucash-user mailing list
> gnucash-user@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.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





   
___
gnucash-user mailing list
gnucash-user@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.

Re: Matching Gifts ?

[Mike or Penny Novack]

On 7/9/2017 11:53 PM, aegross wrote:

Part of the benefits of my employer is that I have $X per year in matching
gifts for charities I support.  If I wanted to track the remaining amount of
money I have to allocate, what would the GAAP be for recording such?
Currently I do this work in a spreadsheet but it would be handy to have this
info in in GC.  But, it's not a liability and it's not an asset.

Kind regards,
Andrew Gross
This is a case where if you want to use gnucash instead of a spreadsheet 
you create a separate set of books for a virtual entity. In other words, 
it isn't something on YOUR books that you are accounting for, not even a 
REAL entity (but a right to have donations made up to a certain amount). 
Besides the actual entities for which I keep books I also keep books for 
a couple of virtual entities (example: our solar system considered as if 
it were an investment paying back the amount loaned to it).


If you want to do this and are asking how to:
a) Yes, you could consider the initial amount allocated each year by 
your employer to be an asset (of this entity) and its "income".
b) Every time you instruct your employer to make a matching donation you 
can credit that "available" account and debit the "expense" of a 
donation to that particular charity.


Michael D Novack


___
gnucash-user mailing list
gnucash-user@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.

Re: Mortgage/Loan Scheduled Transaction Way Off

[Mike or Penny Novack]

On 7/9/2017 5:33 AM, ITWarrior wrote:

Hello,

I have a problem with setting up a mortgage. By the time I've added the
details and reach the 'Loan Review' page, the results are way off. Here are
my values:

Amount: 172,000
Interest Rate: 4.590%
Type: Fixed Rate
Start date: 01/01/17
Length: 30 years

The PMT for this is calculated by gnucash as:
pmt( 0.04590 / 12.00 : 360.00 : 172,000.00 : 0 : 0 )

Loan payments are every two weeks on a Friday, starting 01/01/17.

My bank calculates these bi-weekly repayments at ~$400, but gnucash shows
the payments as $880. I could understand these being off a few dollars
depending on how the interested is calculated (it's calculated daily here in
NZ), but out by more than twice as much?
OK, first of all, the "more than twice as much" is obviously correct 
(you would expect a MONTHLY payment to be at least twice a BI-WEEKLY 
payment). And since 28 days (two biweekly payments) is less than a month 
you expect more (from that) and you are paying a total of less interest 
on the mortgage because of the more frequent adjusts downward of 
principle owed.


Michael D Novack

PS: But even once this is sorted (it will be either 782 or 783 payments 
depending on how your lender treats the end) do not expect an exact 
match between the bank and the gnucash calculator. This is NOT just a 
matter of how rounding is handled but other choices in figuring the 
amortization schedule.

___
gnucash-user mailing list
gnucash-user@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.

Re: Where do I find gnucash data?

[David T. via gnucash-user]

John,

The files are presumably on the D: drive where you saved them. You can copy 
your files to another PC by using Windows Explorer to copy them to another 
location. Try looking also at Chapter 2.6 and 2.7 in the Tutorial and Concepts 
Guide. They cover the various questions about backups and copying information 
around.

HTH,
David

> On Jul 10, 2017, at 3:39 PM, JOHN OGDEN  wrote:
> 
> I'm reaching the stage of envisaging the possibility of porting all my 
> gnucash data to a new PC. Problem: I can't locate the current data files.
> The program files are on drive D. (Why? My PC had a significant rebuild five 
> years ago in which the two HDs were configured as two drives, D and E, and a 
> new SSD was installed as drive C). It has been absolutely fine so far -- 
> never put a foot wrong -- but I'm beginning to feel that I must soon prepare 
> for worst case. All data files (at least, those I know about) are backed up 
> regularly on an external HD.
> One obvious answer (I guess) is export/import) but is there no better way? 
> John
> Revd Dr John Ogden 0118 969 6319 07746 621447
> ___
> gnucash-user mailing list
> gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: Mortgage/Loan Scheduled Transaction Way Off

[Derek Atkins]

Hi, 
The issue is the 360 payments. If you're paying every 2 weeks for 30 years then 
there are more than 720 payments.  Fix that and the numbers should be correct.  
I suspect the assistant only handles monthly repayments. 
-derek
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity or typos.

On July 9, 2017 5:33:59 AM EDT, ITWarrior  wrote:
>Hello,
>
>I have a problem with setting up a mortgage. By the time I've added the
>details and reach the 'Loan Review' page, the results are way off. Here
>are
>my values:
>
>Amount: 172,000
>Interest Rate: 4.590%
>Type: Fixed Rate
>Start date: 01/01/17
>Length: 30 years
>
>The PMT for this is calculated by gnucash as:
>pmt( 0.04590 / 12.00 : 360.00 : 172,000.00 : 0 : 0 )
>
>Loan payments are every two weeks on a Friday, starting 01/01/17.
>
>My bank calculates these bi-weekly repayments at ~$400, but gnucash
>shows
>the payments as $880. I could understand these being off a few dollars
>depending on how the interested is calculated (it's calculated daily
>here in
>NZ), but out by more than twice as much?
>
>It gets even stranger when you look at the review page:
>
>
>
>It's as though the 30 year term is ignored and instead the figures are
>applied to a ~13 year term. This would actually make sense given the
>stated
>repayments of ~$880, but the mortgage in the review actually does carry
>on
>beyond 13 years although it actually stops at 29 years (15/12/45) with
>an
>interest payment of $3.36 for the 16 years after the loan interest
>appears
>to actually end.
>
>Am I driving this wrong, or is this a bug? This happens on the latest
>version in the Ubuntu repositories (2.6.12) and the latest Window
>version
>(2.6.17). I have searched the mailing lists for this problem but
>haven't
>found a specific mention of it, although have found a long history of
>confusion over the scheduled transaction tool.
>
>Thanks,
>ITWarrior
>
>
>
>--
>View this message in context:
>http://gnucash.1415818.n4.nabble.com/Mortgage-Loan-Scheduled-Transaction-Way-Off-tp4692580.html
>Sent from the GnuCash - User mailing list archive at Nabble.com.
>___
>gnucash-user mailing list
>gnucash-user@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.
___
gnucash-user mailing list
gnucash-user@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.

Re: Where do I find gnucash data?

[Maf. King]

Hi John,

This is in the FAQ.  see 

https://wiki.gnucash.org/wiki/FAQ#Q:_Where_is_my_GnuCash_data_file.3F

You may also want to consider the following 2 or 3 questions in the FAQ with 
regard to migrating to a new PC.

HTH,
Maf.


On Monday, 10 July 2017 11:39:02 BST JOHN OGDEN wrote:
> I'm reaching the stage of envisaging the possibility of porting all my
> gnucash data to a new PC. Problem: I can't locate the current data files.
> The program files are on drive D. (Why? My PC had a significant rebuild
> five years ago in which the two HDs were configured as two drives, D and E,
> and a new SSD was installed as drive C). It has been absolutely fine so far
> -- never put a foot wrong -- but I'm beginning to feel that I must soon
> prepare for worst case. All data files (at least, those I know about) are
> backed up regularly on an external HD. One obvious answer (I guess) is
> export/import) but is there no better way? John Revd Dr John Ogden 0118 969
> 6319 07746 621447
> ___
> gnucash-user mailing list
> gnucash-user@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.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542



___
gnucash-user mailing list
gnucash-user@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.

Where do I find gnucash data?

[JOHN OGDEN]

I'm reaching the stage of envisaging the possibility of porting all my gnucash 
data to a new PC. Problem: I can't locate the current data files.
The program files are on drive D. (Why? My PC had a significant rebuild five 
years ago in which the two HDs were configured as two drives, D and E, and a 
new SSD was installed as drive C). It has been absolutely fine so far -- never 
put a foot wrong -- but I'm beginning to feel that I must soon prepare for 
worst case. All data files (at least, those I know about) are backed up 
regularly on an external HD.
One obvious answer (I guess) is export/import) but is there no better way? John
Revd Dr John Ogden 0118 969 6319 07746 621447
___
gnucash-user mailing list
gnucash-user@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.