[GNC] known bug in crash while editing reconciled transactions?

2019-01-05 Thread John Clements
This bug might be reproducible, but I'd rather not spend the time if it's
already a known PR.

The issue is this: I reconciled a bundle of transactions. Then, I opened an
"edit" window, and changed the target accounts for a number of these
transactions. Then I walked away from the machine. About a day later, I
came back, and tried to import a QIF, and it crashed. That's not a big
deal, programs crash. When I restarted gnucash, though, I see that those
transactions are now listed as being unreconciled. Mercifully, I noticed it
quickly, and their amounts had also been deducted from the last reconciled
total, so fixing it was an easy matter of re-reconciling with the same
closing balance as before and ticking off all of the edited transactions.
No damage done, at least in this case, but it would have been very
unpleasant to have discovered days or years later.

So! Is this a known issue? If not, I'd be happy to try to reproduce it, and
then file a PR.

Best,

John Clements
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Screen reader support for gnu cash

2019-01-05 Thread John Ralls


> On Jan 5, 2019, at 11:32 AM, Shankar Udaya  wrote:
> 
> I tried to use nvda screen reader softwares with GNUCASH.  . But it doesn't
> seem to work it doesn't read out anything on the screen does anybody know
> how to fix this problem. want to know if the GNU cash supports any other
> screen readers other than nvda

GnuCash is a Gtk (i.e. Linux) application that has been ported to Windows. Gtk 
has its own accessibility framework that is AFAIK not compatible or 
interoperable with Windows or Mac accessibility tools, so the only screen 
reader that’s likely to work with it is Orca 
(https://wiki.gnome.org/Projects/Orca 
). It’s not AFAIK available for 
Windows. Sorry.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Getting security online quotes with user data in MySQL database.

2019-01-05 Thread John Ralls


> On Jan 5, 2019, at 4:23 PM, D Keith Higgs  wrote:
> 
> I'm reading through the current GnuCash Tutorial and Concepts Guide as I 
> attempt to configure my stock portfolio securities for online quotes and am 
> running into a gap with regard to documentation for this process when the 
> user data is in a MySQL database. I'm working on a Microsoft Windows 10 
> system with WAMPServer installed. I am able to connect to the MySQL instance 
> from the command line and query the data model.  Any guidance that may be 
> available would be very appreciated.
> 

The storage backend is irrelevant to how GnuCash works as long as you don’t 
touch the database from outside of GnuCash. If you *do* touch the database, 
you’re on your own.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tracking Reimbursable Medical Expenses

2019-01-05 Thread Stephen M. Butler
On 1/5/19 7:51 PM, David Cousens wrote:
> Aaron
>
> Asset:HSA is your savings fund. The payment of money into that account is
> exactly as you priginally proposed.
>
> The 4 way split 
>> Asset:Medical Reimbursable $5 
>> Liability:Credit Card $5 
>> Expenses:Medical$5 
>> Asset:HSA  $5
> records 2 simultaneous events. It makes a bit more sense when you consider
> the two events separately
>
> Firstly your payment of the medical expense with your credit card
> :
>  Expenses:Medical$5 
>  Liability:Credit Card $5 
>
> and the creation of an obligation to reimburse the expenditure to your bank
> account from your HSA account:
>
> Asset:Medical Reimbursable $5  this account
> tracks what you have to reimburse to your bank account
> Asset:HSA  $5   
>
> And when you actually reimbuse money
>
>> Asset:Bank$5 
>> Asset:MedicalReimbursable   $5
> If the balance of Asset:MedicalReimbursable is not 0 then you have expenses
> you have incurred but not reimbursed from the HSA.  This is exactly the same
> as the way  Asset:Account Receivable works when you extend credit to a
> customer in a business environment with the business features. In this case
> the HSA is effectively the customer, who owes you money. 
>
>
> David

Thanks David.  I was pulling out a blank sheet and scribbling T accounts
all over it.  I managed to follow by breaking each pair of lines into
numbered transactions to the various T accounts. 

I was trying to pair the Medical Expense up with the Liability account
and was stymied that that point.  This approach broke the logjam. 
Hopefully the OP follows also.

--Steve

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Screen reader support for gnu cash

2019-01-05 Thread Liz
On Sun, 6 Jan 2019 01:02:07 +0530
Shankar Udaya  wrote:

> I tried to use nvda screen reader softwares with GNUCASH.  . But it
> doesn't seem to work it doesn't read out anything on the screen does
> anybody know how to fix this problem. want to know if the GNU cash
> supports any other screen readers other than nvda
> 
> Thanks
>
Can we backtrack a bit and get some more information?
What OS is this?
Which version of Gnucash?

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Screen reader support for gnu cash

2019-01-05 Thread Shankar Udaya
I tried to use nvda screen reader softwares with GNUCASH.  . But it doesn't
seem to work it doesn't read out anything on the screen does anybody know
how to fix this problem. want to know if the GNU cash supports any other
screen readers other than nvda

Thanks
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Getting security online quotes with user data in MySQL database.

2019-01-05 Thread D Keith Higgs
I'm reading through the current GnuCash Tutorial and Concepts Guide as I 
attempt to configure my stock portfolio securities for online quotes and 
am running into a gap with regard to documentation for this process when 
the user data is in a MySQL database. I'm working on a Microsoft Windows 
10 system with WAMPServer installed. I am able to connect to the MySQL 
instance from the command line and query the data model.  Any guidance 
that may be available would be very appreciated.




Thanks!

D. Keith Higgs

dkhi...@gmail.com


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tracking Reimbursable Medical Expenses

2019-01-05 Thread David Cousens
Aaron

Asset:HSA is your savings fund. The payment of money into that account is
exactly as you priginally proposed.

The 4 way split 
> Asset:Medical Reimbursable $5 
> Liability:Credit Card $5 
> Expenses:Medical$5 
> Asset:HSA  $5

records 2 simultaneous events. It makes a bit more sense when you consider
the two events separately

Firstly your payment of the medical expense with your credit card
:
 Expenses:Medical$5 
 Liability:Credit Card $5 

and the creation of an obligation to reimburse the expenditure to your bank
account from your HSA account:

Asset:Medical Reimbursable $5  this account
tracks what you have to reimburse to your bank account
Asset:HSA  $5   

And when you actually reimbuse money

> Asset:Bank$5 
> Asset:MedicalReimbursable   $5

If the balance of Asset:MedicalReimbursable is not 0 then you have expenses
you have incurred but not reimbursed from the HSA.  This is exactly the same
as the way  Asset:Account Receivable works when you extend credit to a
customer in a business environment with the business features. In this case
the HSA is effectively the customer, who owes you money. 


David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] new to gnucash

2019-01-05 Thread Stephen M. Butler
On 1/5/19 1:53 PM, Adrien Monteleone wrote:
> Nothing counter-intuitive about it. It’s a matter of perspective.

And remembering.  I have to ask my wife each and every time -- even when
I wrote my earlier reply!  I'm thinking I need to hang a sign on the wall:

    DEBITS:  Assets, Expenses

    CREDITS:  Liabilities, Capital/Equity, Revenue

    Debits on the left side.  Credits on the right side.   Right side is
toward the Kitchen!

That last piece is just for me.  Your kitchen might be someplace else. 
That just keeps me from picking the other right side.

--Steve


>
> People are used to hearing the bank telling them that putting money in their 
> account is a ‘credit’ to their account. That’s correct for the bank, because 
> your account is their liability. Increasing a liability is done with a credit.
>
> But in your books, that account is an asset, which is increased by a debit.
>
> Regards,
> Adrien
>
>> On Jan 5, 2019, at 10:57 AM, Michael Hendry  wrote:
>>
>>> On 5 Jan 2019, at 16:41, Mike Kerstetter  wrote:
>>>
>>> Hello all. I'm brand new to gnucash. I want it to do just the basics of 
>>> keeping a register and reconciliation of a couple bank and credit card 
>>> accounts. I had Money Sunset Deluxe and currently have Quicken (which is 
>>> now charging a yearly subscription). I'm muddling through setting up my 
>>> accounts and I am baffled at the seemingly backward credit and debit 
>>> columns in the register. A deposit to my Checking (or payment to my credit 
>>> card account) shows up under "DEBIT" and a charge to my accounts shows up 
>>> under "CREDIT".  The balance is correct. Am I doing something wrong in my 
>>> set-up?
>>>
>>> Thanks,
>>>
>>> Mike Kerstetter
>> Hi, Mike.
>>
>> Welcome to gnucash, and to the mysterious world of double-entry bookkeeping!
>>
>> No, you haven’t made a mistake, cash received by an account is regarded as a 
>> debit and cash paid as a credit.
>>
>> I’m not an accountant and I frequently have to chant “Debit the Receiver” to 
>> remind myself how it goes.
>>
>> No doubt one of the experts in the forum can point you in the direction of 
>> an explanation of this counter-intuitive situation, or you could try 
>> Googling.
>>
>> Michael
>>
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tracking Reimbursable Medical Expenses

2019-01-05 Thread David Cousens


Maybe what isn't clear is that the HSA account is "just" another asset account 
in my books. It's mostly populated by my employer, but I add pre-tax money to 
it, too. 
Aaron,
I had assumed that was the case from your original description. 

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Tracking Reimbursable Medical Expenses

2019-01-05 Thread Aaron Laws
Thank you for your response; questions inline.

On Fri, Jan 4, 2019 at 5:29 PM Stephen M. Butler  wrote:

> At my previous employment (prior to retirement) the HSA account came
> with a charge card (used like a credit card) so the charges went
> directly against the HSA account.  Made tracking very simple and didn't
> have to send in reimbursement forms.  I presume that isn't the case with
> your employer's HSA processor.
>

I was issued a debit card with direct access to the HSA funds. I don't use
it because if I use my credit card, I get money back, and I don't want to
carry another card.


> I might be tempted to get a second credit card to use only for the
> medical items and pay that with reimbursement from the HSA. That way the
> balance on that card is what is still outstanding.
>

This is why I use double-entry accounting: so I don't have to do stuff like
that ;-)


> Thinking further.  If I as an employee charge something to my credit
> card that I will get reimbursed from my employer then things get trickier:
>

It's not reimbursed by my employer. If that was the case, then I think
things would get simple: it's not my expense. There would be no
expense:medical because the expense is actually my employer's expense. As
it is, the HSA money is *mine*, and the medical expense is *mine*. I think
what gets complicated is the rule that I can only transfer money from *my*
HSA to my chequing account in amounts equal to my medical expenses, and I
would like to track that accruing amount.


> 1.  I charge the item and enter a transaction between Liability:CC and
> Expense:whatever.
>
> 2.  I eventually (monthly) pay off the credit card from checking
> (Assets:Checking and Liability:CC).
>
> 3.  Somewhere in there I fill out an expense statement and send it in.
> That expense is no longer mine so I need to transfer it out of my
> expenses.  Assets:Reimbursement:MyEmployer and Expense:whatever
> (offsetting item #1)
>

Yeah, that's what I was saying above. In this case, step one can be a
transaction between Liability:CC and AR:MedicalReimbursable


> 4.  Finally I get paid and deposit the funds into my checking account.
> Assets:Checking and Assets:Reimbursement:MyEmployer
>
> In this case the HSA replaces the Employer.  And here you are acting on
> both sides.  So, to continue:
>
> 5.  Employer (HSA) gets the reimbursement request and sends out the
> funds.  (HSA:Expense:Medical and Assets:HSA).
>
> I really like the idea of a second CC and it gets paid only when
> reimbursed by the HSA (simplifies the accounts).
>
> --Steve
>

This sounds great except that the medical expense is mine. Any more
suggestions? Thanks again!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Tracking Reimbursable Medical Expenses

2019-01-05 Thread Aaron Laws
Thank you very much. Questions in line.

On Fri, Jan 4, 2019 at 5:46 PM David Cousens 
wrote:

> Aaron,
>
> The Answer is yes but to use the inbuilt Accounts Receivable you would need
> to use the Business features Invoicing  and linking of payments to Invoices
> etc.
>
> An Accounts receivable is simply an Asset account with some additional
> reporting capability attached to it so you simple create an asset account
> Asset:MedicalReimbursable.
>
> The recording events are as follows When you pay a medical expense with
> your
> credit card use a multisplit(4) transaction as follows:
>
> Asset:Medical Reimbursable $5
> Liability:Credit Card $5
> Expenses:Medical$5
> Asset:HSA  $5


What is Asset:HSA? If it's the actual HSA account holding my money
earmarked for medical expenses, it should be funded by revenue:Employer HSA
Contributions.


> When you pay your credit card (this will be lumped in with other
> transactions):
>
> Liability:Credit Card $5
> Asset:Bank $5
>
> When you record your reimbursement:
>
> Asset:Bank$5
> Asset:MedicalReimbursable   $5
>
> The balance in the Asset:Medical Reimbursable account tells you how much
> you
> have outstanding. As there is no linking to payments it is a bit harder to
> identify which reimbursements are linked to which payments but you can
> always use the memo field to identify the date of the expense the
> remimbursment is associated with for example.
>
> David Cousens
>

Maybe what isn't clear is that the HSA account is "just" another asset
account in my books. It's mostly populated by my employer, but I add
pre-tax money to it, too.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Budget Reporting|Charting Questions and v3.4 Question

2019-01-05 Thread Andre Powell
Correct and I have a separate tab to display the budget report with those
columns. I guess in the meantime this will work for my needs.

Thanks for the feedback regarding the state of the budget module. That
would not be mission critical but a nice to have that would put some polish
on the budgeting features.

I appreciate the quick and thoughtful response.


On Sat, Jan 5, 2019 at 5:02 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> The Budget report allows you to see planned vs. actual and a variance
> column. You can pick and choose which accounts you want to include. You
> might need to play with the setting for parent accounts concerning if those
> lines show only amounts in the account or if they include child account
> balances/figures. (recommended practice is for all parent accounts to be
> placeholders only, but of course, you can choose otherwise.)
>
> Per the second request, I don’t think the budget module is going to get
> updates any time soon. But that would be a nice feature. Until then, you
> could export or copy/paste to a spreadsheet for further manipulation. (and
> write a lookup formula to insert account codes from a master list - see
> VLOOKUP and HLOOKUP functions in Calc’s Help)
>
> Regards,
> Adrien
>
> > On Jan 5, 2019, at 3:38 PM, Andre Powell  wrote:
> >
> > GnuCash version - 3.4
> > OS - Ubuntu 18.10
> >
> > I have recently moved back to using GnuCash after spending some time with
> > YNAB and moving entirely to Ubuntu. I must say that I am extremely happy
> > and almost regret not switching entirely to Linx before.
> >
> > Is there a way (and if not I would propose this as a feature) to only
> > capture the parent items in the Budget Chart. I have set up a Multicolumn
> > view that I use as a dashboard that I review upon opening my file. It
> would
> > be great just to see planned vs. actual for income and expenses. When I
> > have tried to do this I only get a blank screen.
> >
> > Secondly, it appears that adding columns in the budget is no longer
> > possible, and it can only be done on the accounts page. This would be
> > helpful in sorting the accounts by account code since there is no other
> way
> > to sort this out for the actual budget planning. I would add that the
> > budget and the budget report should mimic the same columns or at least
> have
> > the option to either display additional columns or not. A more minor
> > observation is that it including the same total information from the
> budget
> > functionality (the bottom totals) to the budget report would be helpful.
> >
> > All the best and once again thanks for all of the hard work and
> > improvements to the software.
> >
> > --
> > Andre
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
Andre
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new to gnucash

2019-01-05 Thread Stan Brown
> From: Mike Kerstetter 
> To: gnucash-user@gnucash.org
> 
> ... I am baffled at the seemingly backward credit and debit
> columns in the register. A deposit to my Checking (or payment to my 
> credit card account) shows up under "DEBIT" and a charge to my accounts 
> shows up under "CREDIT".? The balance is correct. Am I doing something 
> wrong in my set-up?

Hi, Mike.  Welcome to GnuCash. You'll find it's quirky, and there are a
significant number of bugs, but the developers are very responsive and
the user community is super-helpful.

Regarding debit and credit -- Americans especially are used to thinking
of "credit good, debit bad", because when you get a credit on your Visa
account that is favorable to you.

But GnuCash treats debits and credits as accountants do, and IMHO that's
a good thing -- it's one of the major factors in why I switched to
GnuCash a year ago.

Cash and bank accounts are among your assets, right?  Well, to
accountants an asset is a debit. A liability (such as your Visa account)
is a credit, and your net worth (same as equity) is also a credit.
Debits must always equal credits, and therefore

Assets (Debits) = Liabilities + Equity (Credits)

Income increases your net worth, which is a credit, and therefore income
is also a credit. Expenses reduce your net worth, and therefore expenses
are the opposite of credits, i.e. debits. That equation can be expanded
a bit, to

Assets (Debits) = Liability + Equity + (Income-Expenses) (credits)

Let's say you owe $1800 on your Visa account. That's an $1800 credit
balance on your books. If you pay $1100, you reduce your Visa balance (a
credit) to $700, and therefore you are debiting your Visa balance by
$1100. You are reducing your bank account (an asset, and therefore a
debit) by $1100, and therefore you are crediting your bank account by $1100.

When you return a $50 purchase, you're reducing (debiting) your Visa
balance $50 and also reducing (crediting) an asset account or an expense
account by $50. Why, then, do we think of "getting a credit" on our Visa
account in that situation? Because, unknowingly, we're using the
language from the viewpoint of the bank, not our own viewpoint. To the
bank, your Visa balance is an asset, and therefore a debit. That $50
return reduces the amount you owe them, and therefore reduces their
debit account, which makes it a credit on _their_ books. Their point of
view is exactly opposite to yours, because transactions that increase
their net worth reduce yours, and vice versa.

Now, all of that said, though you haven't done anything wrong in your
settings, you can set a preference to change "debits" and "credits" to
"deposits" and "withdrawals" for your bank accounts, and make
corresponding change for the other accounts.  Under Edit » Preferences »
Accounts, remove the tick mark for "use formal accounting labels". But
now that you know how things work, you may not feel the need to change them.

-- 
Regards,
Stan Brown
Tompkins County, New York, USA
http://BrownMath.com
http://OakRoadSystems.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Reporting|Charting Questions and v3.4 Question

2019-01-05 Thread Adrien Monteleone
The Budget report allows you to see planned vs. actual and a variance column. 
You can pick and choose which accounts you want to include. You might need to 
play with the setting for parent accounts concerning if those lines show only 
amounts in the account or if they include child account balances/figures. 
(recommended practice is for all parent accounts to be placeholders only, but 
of course, you can choose otherwise.)

Per the second request, I don’t think the budget module is going to get updates 
any time soon. But that would be a nice feature. Until then, you could export 
or copy/paste to a spreadsheet for further manipulation. (and write a lookup 
formula to insert account codes from a master list - see VLOOKUP and HLOOKUP 
functions in Calc’s Help)

Regards,
Adrien

> On Jan 5, 2019, at 3:38 PM, Andre Powell  wrote:
> 
> GnuCash version - 3.4
> OS - Ubuntu 18.10
> 
> I have recently moved back to using GnuCash after spending some time with
> YNAB and moving entirely to Ubuntu. I must say that I am extremely happy
> and almost regret not switching entirely to Linx before.
> 
> Is there a way (and if not I would propose this as a feature) to only
> capture the parent items in the Budget Chart. I have set up a Multicolumn
> view that I use as a dashboard that I review upon opening my file. It would
> be great just to see planned vs. actual for income and expenses. When I
> have tried to do this I only get a blank screen.
> 
> Secondly, it appears that adding columns in the budget is no longer
> possible, and it can only be done on the accounts page. This would be
> helpful in sorting the accounts by account code since there is no other way
> to sort this out for the actual budget planning. I would add that the
> budget and the budget report should mimic the same columns or at least have
> the option to either display additional columns or not. A more minor
> observation is that it including the same total information from the budget
> functionality (the bottom totals) to the budget report would be helpful.
> 
> All the best and once again thanks for all of the hard work and
> improvements to the software.
> 
> -- 
> Andre
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new to gnucash

2019-01-05 Thread Adrien Monteleone
Nothing counter-intuitive about it. It’s a matter of perspective.

People are used to hearing the bank telling them that putting money in their 
account is a ‘credit’ to their account. That’s correct for the bank, because 
your account is their liability. Increasing a liability is done with a credit.

But in your books, that account is an asset, which is increased by a debit.

Regards,
Adrien

> On Jan 5, 2019, at 10:57 AM, Michael Hendry  wrote:
> 
>> On 5 Jan 2019, at 16:41, Mike Kerstetter  wrote:
>> 
>> Hello all. I'm brand new to gnucash. I want it to do just the basics of 
>> keeping a register and reconciliation of a couple bank and credit card 
>> accounts. I had Money Sunset Deluxe and currently have Quicken (which is now 
>> charging a yearly subscription). I'm muddling through setting up my accounts 
>> and I am baffled at the seemingly backward credit and debit columns in the 
>> register. A deposit to my Checking (or payment to my credit card account) 
>> shows up under "DEBIT" and a charge to my accounts shows up under "CREDIT".  
>> The balance is correct. Am I doing something wrong in my set-up?
>> 
>> Thanks,
>> 
>> Mike Kerstetter
> 
> Hi, Mike.
> 
> Welcome to gnucash, and to the mysterious world of double-entry bookkeeping!
> 
> No, you haven’t made a mistake, cash received by an account is regarded as a 
> debit and cash paid as a credit.
> 
> I’m not an accountant and I frequently have to chant “Debit the Receiver” to 
> remind myself how it goes.
> 
> No doubt one of the experts in the forum can point you in the direction of an 
> explanation of this counter-intuitive situation, or you could try Googling.
> 
> Michael
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Budget Reporting|Charting Questions and v3.4 Question

2019-01-05 Thread Andre Powell
GnuCash version - 3.4
OS - Ubuntu 18.10

I have recently moved back to using GnuCash after spending some time with
YNAB and moving entirely to Ubuntu. I must say that I am extremely happy
and almost regret not switching entirely to Linx before.

Is there a way (and if not I would propose this as a feature) to only
capture the parent items in the Budget Chart. I have set up a Multicolumn
view that I use as a dashboard that I review upon opening my file. It would
be great just to see planned vs. actual for income and expenses. When I
have tried to do this I only get a blank screen.

Secondly, it appears that adding columns in the budget is no longer
possible, and it can only be done on the accounts page. This would be
helpful in sorting the accounts by account code since there is no other way
to sort this out for the actual budget planning. I would add that the
budget and the budget report should mimic the same columns or at least have
the option to either display additional columns or not. A more minor
observation is that it including the same total information from the budget
functionality (the bottom totals) to the budget report would be helpful.

All the best and once again thanks for all of the hard work and
improvements to the software.

-- 
Andre
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] new to gnucash

2019-01-05 Thread David Cousens
Mike,

The first chapter or two of the Tutorial and Concepts guide 

https://www.gnucash.org/docs/v3/C/gnucash-guide/index.html may help with
getting this straight. 

Wikipedia also has quite good articles on double entry accounting, the
accounting equation and debits and credits.

https://en.wikipedia.org/wiki/Double-entry_bookkeeping_system
https://en.wikipedia.org/wiki/Debits_and_credits
https://en.wikipedia.org/wiki/Accounting_equation

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] new to gnucash

2019-01-05 Thread N B Day
On Sat, 2019-01-05 at 11:41 -0500, Mike Kerstetter wrote:
> Hello all. I'm brand new to gnucash. I want it to do just the basics
> of 
> keeping a register and reconciliation of a couple bank and credit
> card 
> accounts. I had Money Sunset Deluxe and currently have Quicken (which
> is 
> now charging a yearly subscription). I'm muddling through setting up
> my 
> accounts and I am baffled at the seemingly backward credit and debit 
> columns in the register. A deposit to my Checking (or payment to my 
> credit card account) shows up under "DEBIT" and a charge to my
> accounts 
> shows up under "CREDIT".  The balance is correct. Am I doing
> something 
> wrong in my set-up?
> 
> Thanks,
> 
> Mike Kerstetter

What others have said.

In the meantime

Uncheck the "Use formal accounting labels" box under Edit ->
Preferences -> Accounts.


-- 
N. B. Day
39.4042 North, 119.7377 West and 1387 meters up, Temp: -3.9 C (KRNO)
Sat, 2019-01-05 at 09:34 PST (UTC -0800)
Epicurus up 21:15,  1 user,  load average: 1.27, 0.66, 0.35
Linux 4.18.0-13-generic
Ubuntu Disco Dingo (development branch), GNOME Shell 3.30.1
This computer in service for 2900 days.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] new to gnucash

2019-01-05 Thread Michael Hendry
> On 5 Jan 2019, at 16:41, Mike Kerstetter  wrote:
> 
> Hello all. I'm brand new to gnucash. I want it to do just the basics of 
> keeping a register and reconciliation of a couple bank and credit card 
> accounts. I had Money Sunset Deluxe and currently have Quicken (which is now 
> charging a yearly subscription). I'm muddling through setting up my accounts 
> and I am baffled at the seemingly backward credit and debit columns in the 
> register. A deposit to my Checking (or payment to my credit card account) 
> shows up under "DEBIT" and a charge to my accounts shows up under "CREDIT".  
> The balance is correct. Am I doing something wrong in my set-up?
> 
> Thanks,
> 
> Mike Kerstetter

Hi, Mike.

Welcome to gnucash, and to the mysterious world of double-entry bookkeeping!

No, you haven’t made a mistake, cash received by an account is regarded as a 
debit and cash paid as a credit.

I’m not an accountant and I frequently have to chant “Debit the Receiver” to 
remind myself how it goes.

No doubt one of the experts in the forum can point you in the direction of an 
explanation of this counter-intuitive situation, or you could try Googling.

Michael



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new to gnucash

2019-01-05 Thread Steve Butler
Sounds right to me.

Remember that Asset and Expense accounts are Debit accounts.  So Debit
increases and Credit decreases the balances in the accounts.

Liability, Income, and Equity/Capital accounts are Credit accounts.  So
Debit decreases and Credit increases the balance.

On Sat, Jan 5, 2019, 08:44 Mike Kerstetter  Hello all. I'm brand new to gnucash. I want it to do just the basics of
> keeping a register and reconciliation of a couple bank and credit card
> accounts. I had Money Sunset Deluxe and currently have Quicken (which is
> now charging a yearly subscription). I'm muddling through setting up my
> accounts and I am baffled at the seemingly backward credit and debit
> columns in the register. A deposit to my Checking (or payment to my
> credit card account) shows up under "DEBIT" and a charge to my accounts
> shows up under "CREDIT".  The balance is correct. Am I doing something
> wrong in my set-up?
>
> Thanks,
>
> Mike Kerstetter
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] new to gnucash

2019-01-05 Thread Jeff Abrahamson
In accounting, a debit is a movement of funds towards something, a
credit away from.  So you debit a bank account when you move money into
it, credit it when you move money out.

The confusion arises from popular usage: for example, when your bank
sends you a statement, they are showing the credit and debit columns
from /their/ perspective.  To the bank, your account is a liability
(payable to you).  The debits are movements of funds that reduce that
liability, the credits are movements of funds that increase the liability.

It eventually feels natural, but it's also natural to find this quite
weird when you first start using proper accounting language.

Jeff Abrahamson

http://p27.eu/jeff/
http://transport-nantes.com/


On 05/01/19 17:41, Mike Kerstetter wrote:
> Hello all. I'm brand new to gnucash. I want it to do just the basics
> of keeping a register and reconciliation of a couple bank and credit
> card accounts. I had Money Sunset Deluxe and currently have Quicken
> (which is now charging a yearly subscription). I'm muddling through
> setting up my accounts and I am baffled at the seemingly backward
> credit and debit columns in the register. A deposit to my Checking (or
> payment to my credit card account) shows up under "DEBIT" and a charge
> to my accounts shows up under "CREDIT".  The balance is correct. Am I
> doing something wrong in my set-up?
>
> Thanks,
>
> Mike Kerstetter
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.com/

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] new to gnucash

2019-01-05 Thread Mike Kerstetter
Hello all. I'm brand new to gnucash. I want it to do just the basics of 
keeping a register and reconciliation of a couple bank and credit card 
accounts. I had Money Sunset Deluxe and currently have Quicken (which is 
now charging a yearly subscription). I'm muddling through setting up my 
accounts and I am baffled at the seemingly backward credit and debit 
columns in the register. A deposit to my Checking (or payment to my 
credit card account) shows up under "DEBIT" and a charge to my accounts 
shows up under "CREDIT".  The balance is correct. Am I doing something 
wrong in my set-up?


Thanks,

Mike Kerstetter
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Stocks/Equities queries (Australian Based)

2019-01-05 Thread David Cousens
XboxBoy

I've done this recently with a superannuation pension fund. I had initially
entered an Opening Balance from mid last year and the transactions forward
from that. I already had data for the pension payments entered as income
(not taxable in my case for this fund which is taxed in the hands of the
fund administrator), but not the fund itself as an asset and the investment
returns and fees charged, payments to me out of it etc. I took it back six
months  at a time using the six monthly statements/transaction records I had
on file. Just changed the date on the opening balance transaction to the new
starting date and the balance at that date, then entered the investment
returns, fees pension payments etc between the new opening balance date and
the previous one. Checked that the opening and closing balances for that
period still agreed with my statements. 

I had to do a bit  of trickery as I receive the pension payments paid
directly into my bank account from the fund administrator. To be able to
reconcile that with the bank statements, I could not record my pension
payments simply as decreases (credits) to the fund and increases in my bank
account. I set up a separate Income and Expenses account to record the
Investment return to the fund and expenses associated with that. An
additional Expenses account recorded the pension payments as decreases
(credits) to the asset account for the fund. My entries for the pension
payment are a bit complex. a 4 way split records both the payment into my
bank account as income and the reduction in the asset value as an expense
against the fund. 

Asset:Bank  

Db 
Income:non-taxablePension   

Cr 
Expenses:non-taxablePensionFund:pensionPayments   Db 
Asset:non-taxablePensionFund
   
Cr 

where  is the pension payment I receive from the fund. Recording the 6
monthly investment returns looked like:

Asset:non-taxablePensionFund   Db
nett investment return
Expense:non-taxablePensionFund:Fees Db  fees and taxes
Income:non-taxablePensionFund:InvestmentReturn  

Cr  Gross invetment return

Once your back to the original purchase transaction and have entered it you
can then delete the opening balance transaction for that stock completely. 
Once I had it all in, I reconciled it forward against the statements to
check I had it right. As others have noted you have to be careful. If you
are in Australia, you aren't taxed on unrealized gains/losses. You can still
track them in an equity account though if you have access to the historical
price information.

Regards

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Tracking Reimbursable Medical Expenses

2019-01-05 Thread David Cousens
David

No problem. I wasn't aware that the previous reply didn't show up outside
Nabble.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Stocks/Equities queries (Australian Based)

2019-01-05 Thread D via gnucash-user
I'd go further and say that, while it is possible to do as Maf says, it can be 
quite confusing to manage, especially where investments are concerned. Capital 
gains and basis calculations are tricky enough to manage without having to 
jigger balances.

I'd recommend choosing one or the other: either start at the beginning, or use 
an opening balance.

David

On January 5, 2019, at 4:25 PM, "Maf. King"  wrote:

On Saturday, 5 January 2019 06:42:58 GMT Xboxboy Mageia wrote:

> But for the time being, my question is:
> If I setup my accounts as they are now, using an opening balance, can I at
> a later date go back and adjust, and enter the earlier purchases/dividends
> of stocks/equities?
> 

Yes, but you'll need to pay attention & reduce the opening balance transaction 
if you go further "back in time" amd add detail - it won't auto adjust!

HTH,Maf.
 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Tracking Reimbursable Medical Expenses

2019-01-05 Thread D via gnucash-user
Your reply used a phrase similar to "to implement this you need to use the 
business features" (I don't see the text of your previous reply here because 
you're using Nabble). My sense was that you were saying the OP had to use them.

That was why I posted my comment.

David T.

On January 5, 2019, at 12:02 PM, David Cousens  wrote:

David T,

That is what the above transactions and account structure does - implement
an accounts receivable structure without using the business features.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Stocks/Equities queries (Australian Based)

2019-01-05 Thread Maf. King
On Saturday, 5 January 2019 06:42:58 GMT Xboxboy Mageia wrote:

> But for the time being, my question is:
> If I setup my accounts as they are now, using an opening balance, can I at
> a later date go back and adjust, and enter the earlier purchases/dividends
> of stocks/equities?
> 

Yes, but you'll need to pay attention & reduce the opening balance transaction 
if you go further "back in time" amd add detail - it won't auto adjust!

HTH,Maf.
 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Car loan with downpayment using a credit card

2019-01-05 Thread Maf. King
On Saturday, 5 January 2019 00:34:59 GMT Taymour A. El Erian wrote:
> > Message: 5
> > Date: Thu, 3 Jan 2019 19:59:55 -0600
> > From: Adrien Monteleone 
> > To: Gnucash Users 
> > Subject: Re: [GNC] Car loan with downpayment using a credit card
> > Message-ID: 
> > Content-Type: text/plain;   charset=utf-8
> > 
> > When you imported transactions, were the downpayment(s) not part of that
> > download?
> > 
> > If so, how were they assigned on the other end of the transaction at
> > import?
> > 
> > Something that might help, if you aren?t already using it, is to turn on
> > Transaction Journal view in the View menu. You can also set this as a
> > default setting from Preferences. This will show you all splits in all
> > transactions at all times. One split will always be for the current
> > account
> > register you are viewing, the others will be for the other side(s) of the
> > transaction.
> > 
> > For each downpayment, you should have something similar to:
> > 
> > Cr. Assets:Checking OR Liabilities:Credit Card
> > Dr. Liabilities:Car Loan
> > 
> > Thus the three credit card payments would offset the Car Loan liability
> > with increases (credits) to the respective Credit Card liabilities, and
> > the
> > Cheque would reflect a decrease (credit) in your checking account.
> > 
> > Hope that helps.
> > 
> > Regards,
> > Adrien
> > 
> > 
> > All the downpayments were part of the download, when I imported them I put
> 
> them in Liabilities:CC. All CC settlements were matched to Assets:Checking
> account and all that was before I added the loan and the car as an asset
> Now all down payments made on the CC show under Liabilities:Car loan so
> offsetting the car loan correctly but that is not the problem. The problem
> is the car as Assets:Car. I put the total car selling price as an Asset and
> I want to show the down payment but right now all CC payments show in
> Liabilities and my Assets:checking is decreasing by the bulk amount of CC
> settlement.

Hi,

If you've put the downpayments from the CC against Liab:CarLoan, then the 
initial opening balance of the Loan should be for the full value of the car.

therefore the opening loan transaction should be to increase the asset account 
by the full value of the car.

alternatively, re-book the CC transactions to Assets:Car, if the loan was only 
ever for part of the total value of the car.

HTH,
Maf.
  



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


[GNC] Stocks/Equities queries (Australian Based)

2019-01-05 Thread Xboxboy Mageia
Hi all. Just getting all my stocks entered into GNC. Reading the
concepts/tutorial last night, I see 2 methods of setting up: Purchasing or
setting up with an opening balance.

I have records stretching back to the early 80's. Being Australian stocks,
most spit out yearly/6 monthly or even quarterly dividends, and where
possible, I use the DRIP (Dividend Re-Investment Plan) So if possible, I'd
like to get that ALL entered.

But for the time being, my question is:
If I setup my accounts as they are now, using an opening balance, can I at
a later date go back and adjust, and enter the earlier purchases/dividends
of stocks/equities?

Regards,
Xboxboy
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.