Re: [GNC] Advice needed, how to handle a medical reimbursement account...

[Peter Rowed via gnucash-user]

Hi Randix,

OK, I misunderstood the $1000.00. Here is how I would do it.

1 You have set up asset accounts for MRA and checking account.
2. You have set up an income account for MRA income. (I'm not sure if that is 
treated as income in US but it's going to work)
3. You have set up a medical expense account.
4, now you need a fourth set of accounts for each MRA titled Claims in Process. 
It's a clearing account and in Australia would be treated as an asset.

The steps are

1. on day 1 you are notified that $1,000 has been deposited in a holding 
account for your MRA , let's call it membership. So in Gnucash you debit the 
holding account and credit the income account, as explained above.

2. on day 2 you pay $100 to a doctor so you credit your checking account for 
$100 and debit the expense account, as above.

3. On Day 3, you submit a claim of $100 to the MRA . So in Gnucash you credit 
the MRA account and debit the MRA claim in process account (clearing account)

4. on Day 4 you receive $100 from the MRA. You debit the checking account and 
credit the MRA claim in process account.

At the end of all of this, your MRA will have $900DR, Your clearing will have 
$0, your bank will have $0, your medical expense will have $100DR and your MRA 
income will have $1000CR.

Accounting should always reflect what is actually happening and you have a 
history of what happened.

Just as you have a hierarchy of MRA accounts, you could have a hierarchy of MRA 
clearing and income accounts. At any time you can report on what your MRA 
account balances are, what is in progress and what income you have earned.

You could skip the income and clearing account hierarchies and just have one 
and identify the MRA ownership with a comment in the memo of the transaction. I 
wouldn't do that as the effort and disk space in unique accounts is 
insignificant and not hostage to the possibility of miskeying a memo comment 
and then chasing a miscoded transaction.

This is the way I keep books for my clients and is quite normal in Australia.

Hope this helps, email me if i have confused you and i'll try again

 


​Regards Peter

Sent with ProtonMail Secure Email.​

‐‐‐ Original Message ‐‐‐

On 14 May 2018 12:07 PM, randix  wrote:

> Thanks for your suggestion.
> 
> Unless I'm misunderstanding, what you propose would work fine if one was not
> 
> interested in keeping track of the current balance(s) in the various MRA
> 
> accounts. I need to keep track of the balances, as I need to know which MRA
> 
> account still has credit balances to which I can submit claims.
> 
> So, for example, using your suggestion...
> 
> 1.  On January 1, 2018, I'm notified that I have received $1,000 which has
> 
> been deposited in my XYZ MRA Account (keep in mind, these are not funds 
> that
> 
> have been actually sent to me, rather they have been deposited in an 
> account
> 
> set up in my name). I have an ASSET account in the name of XYZ MRA, so on
> 
> January 1, 2018, when notified of the deposit, I make a "deposit" in that
> 
> asset account in the amount of $1,000, and offset it with $1,000 in an
> 
> income account titled MRA income (so I can keep track of MRA funds that 
> have
> 
> been credited to me in all MRA accounts).
> 
> 2.  On January 5, 2018, I pay out of my checking account the sum of $100.00
> 
> to Doctor 123, the offsetting entry is expense:health:medical
> 
> 3.  Using your suggestion, on January 10, 2018 when I file a claim for
> 
> reimbursement of the $100.00, I debit the ASSET XYZ MRA account, so it now
> 
> has a balance of $900.00, and credit the $100.00 in my
> 
> expense:health:medical account. All good.
> 
> 4.  *The issue is what happens when I actually receive the reimbursement in
> 
> my checking account. *
> 
> 4.1 You said, "Receive reimbursement. Deposit into checking account. Debit
> 
> checking, credit MRA". Not exactly clear what you meant, except that I get
> 
> you want a credit to end up in the MRA account. But doing so, will bring
> 
> the balance of the MRA account back up to $1,000 when we know there's only
> 
> $900 in there...if that account had a zero balance to start with, your
> 
> debit/credit approach would work fine. But I need to have it track the
> 
> balances.
> 
> Suggestion? My head is starting to spin :)
> 
> --
> 
> 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.
> 
> 
> 

Re: [GNC] Advice needed, how to handle a medical reimbursement account...

[Peter Rowed via gnucash-user]

1. Pay the $100 .credit chequing, debit medical expense.

2. Submit claim...debit MRA account,, credit medical account.

3. Receive reimbursement. Deposit into chequing account. Debit chequing, credit 
MRA.

Everything is now back to zero and you have a transaction history of what 
happened.

Sent from ProtonMail mobile

 Original Message 
On 14 May 2018, 05:10, randix wrote:

> I've been stumbling around with a particular issue for several years, and
> figure I need to finally clean up how I enter the amounts in question, once
> and for all... honestly, I'm stumped...
>
> I do contract work all over the country. When I do contract work in lovely
> (sarcasm) San Francisco, they have enacted a city ordinance that mandates
> that in certain situations, employers in the City of San Francisco, are
> required to set up a medical reimbursement account ("MRA") for employees--I
> qualify. On a quarterly basis, I get notified that an employer has deposited
> X amount in my medical reimbursement account. I can then submit my health
> related expenses, and get reimbursed.
>
> So here's what I've done in the past, and I realize there must be a better
> way that is more clean...
>
> 1. I created an ASSET account for the MRA. Actually I created several ASSET
> accounts because each employer I do contract work for in San Francisco,
> creates a separate MRA account for me. Those accounts reflect my pending
> credit balances in each MRA account. If I didn't do that, my head would be
> spinning to keep track of how much I have available in each MRA account (and
> which one I should submit a claim to...)
>
> 2. I obviously have standard EXPENSE accounts set up for healthcare, broken
> down by insurance, medical, dental, optical, etc.
>
> So let's say that on April 1 I paid $100 to Doctor X. I have a debit off
> one of my checking accounts to pay that amount, and my expense account for
> medical reflects the $100. I then submit a claim reimbursement for the $100
> from an MRA account. When the claim is approved, they deposit the $100 in
> my checking account, obviously that shows up as a credit/deposit. The
> offsetting entry is for the MRA account where the payment came from, so my
> ASSET account for that MRA reflects the new balance remaining.
>
> BUT... obviously I still have the $100 payment reflected in my expense
> account for medical. How do I get a credit into that account so it
> accurately reflects the amount of my medical expenses for which I have not
> been reimbursed? I know this makes zero sense, but in a fantasy world I
> would like to have credits be made simultaneously in both the ASSET MRA
> account as well as the EXPENSE medical account.
>
> Hope that makes sense... GnuCash suggestions to get me out of this
> accounting jungle?
>
> --
> 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] Unable to retrieve stock price quotes - Australia

[Peter Rowed via gnucash-user]

And with Alphavantge you must suffix the stock abbreviation with the bourse 
abbreviation. For example, BHP must be amended to BHP.AX for its Australian ASX 
listing

Sent from ProtonMail mobile

 Original Message 
On 13 May 2018, 13:43, prl wrote:

> Have you set Gnucash Preferences>Online Quotes>Alpha Vantage API Key to
> your API key?
>
> That's what I had to do to get AlphaVantage quotes working in 3.1 (on
> Mac OS X), because my old mechanism for doing it in 2.6.x no longer worked.
>
> Peter
>
> On 11/05/2018 07:57, Michael Gordon wrote:
>> I'm running Gnucash 3.1 with Finance Quote 1.47 on a Windows 10 PC.
>>
>> Up until today I was running 2.6.
>> For years I was able to update stock prices no problem.
>> This stopped working in 2.6 some time ago.
>> I updated to 3.1 hoping that would fix it.
>>
>> BTW I had to install Strawberry Perl to get the "Install price
>> retrieval..." working.
>>
>> I've tried all the options available in the Security editor without success.
>>
>> One odd thing is that if I choose AlphaVantage, US 'single' (I do have an
>> API key) for a few stocks they do not show up in the "Unable to
>> retrieve..." list BUT a new price is NOT added to the price database.
>>
>> Would greatly appreciate some help with this.
>>
>> Mike.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> [https://lists.gnucash.org/mailman/listinfo/gnucash-user](> href=)">https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> [https://wiki.gnucash.org/wiki/Mailing_Lists](> href=)">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]( href=)">https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> [https://wiki.gnucash.org/wiki/Mailing_Lists]( href=)">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] What if stock is from a country not in the list of types

[Peter Rowed via gnucash-user]

You have to suffix the stock abbreviation with the code for the bourse. For 
example, an Australian stock, say, ABC is to be encoded as ABC.AX as it is 
listed on the ASX

Sent from ProtonMail mobile

 Original Message 
On 4 May 2018, 19:32, Gio Bacareza wrote:

> I'm just about to start tracking my stocks. I'm reading the manual and
> tried to enter a stock which is traded in the Philippine Stock Exchange.
>
> Under type I only see AMEX, EUREX, NASDAQ, NYSE, FUND, All non currency.
>
> I assume I enter All Non Currency. But what does FUND mean?
>
> --
> cheers,
>
> Gio
> ___
> 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] Online quotes

[Peter Rowed via gnucash-user]

The .AX is appended to the symbol/abbreviation field in the edit security 
function of tools menu

Sent from ProtonMail mobile

 Original Message 
On 24 Apr. 2018, 18:51, TFT wrote:

> Hi Peter
>
> Also in Aus can get American quotes via yahoo JSON but nothing for Aus
>
> Running 2.6.21 and have entered the Alphavantage key but no joy- you talk 
> about appending .ax where do you do that?
>
> Sent from my iPad
>
> On 24 Apr 2018, at 4:46 pm, Peter Rowed  wrote:
>
>> My solution to this problem was to go to Gnucash version 3. Once upgraded 
>> you have to go into preferences->on line quotes and set the Alphavantge key. 
>> As I am in Australia I had to append a .AX to each security abbreviation (eg 
>> BHP becomes BHP.AX) as these are listed on the Australian ASX.
>>
>> Slower than Yahoo but it works.
>>
>> Good luck
>>
>> Sent from ProtonMail mobile
>>
>>  Original Message 
>> On 24 Apr. 2018, 18:01, TFT < thornefamilytr...@bigpond.com> wrote:
>>
>>> Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47
>>>
>>> Previously had all setup to fetch quotes using Alphavantage then it 
>>> stopped. I have since upgraded to the version above and entered my AV key 
>>> into the software.
>>>
>>> Alphavantage is selected in the security editor, when I try to retrieve 
>>> quotes the Perl window opens and the pointer icon spins away - but nothing 
>>> happens until eventually Gnucash stops responding.
>>>
>>> I have followed the wiki as best I can and am sure that all is installed as 
>>> should be.
>>>
>>> Please help, or is there another solution?
>>>
>>> Sent from my iPad
>>> ___
>>> 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] Online quotes

[Peter Rowed via gnucash-user]

My solution to this problem was to go to Gnucash version 3. Once upgraded you 
have to go into preferences->on line quotes and set the Alphavantge key. As I 
am in Australia I had to append a .AX to each security abbreviation (eg BHP 
becomes BHP.AX) as these are listed on the Australian ASX.

Slower than Yahoo but it works.

Good luck

Sent from ProtonMail mobile

 Original Message 
On 24 Apr. 2018, 18:01, TFT wrote:

> Running Gnucash 2.2.26 and as far as can tell running finance quote 1.47
>
> Previously had all setup to fetch quotes using Alphavantage then it stopped. 
> I have since upgraded to the version above and entered my AV key into the 
> software.
>
> Alphavantage is selected in the security editor, when I try to retrieve 
> quotes the Perl window opens and the pointer icon spins away - but nothing 
> happens until eventually Gnucash stops responding.
>
> I have followed the wiki as best I can and am sure that all is installed as 
> should be.
>
> Please help, or is there another solution?
>
> Sent from my iPad
> ___
> 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] Gnucash 3 unable to recognise SQLITE files on MAC OSX

[Peter Rowed via gnucash-user]

Hello Adrien,

Thank you. It worked. 

I am an long time user of Gnucash but newbie in this support network. Do you 
recommend I report this to issue to support for incorporation in next Gnucash 
release?


​Regards Peter

Sent with ProtonMail Secure Email.​

‐‐‐ Original Message ‐‐‐

On 19 April 2018 7:50 AM, Adrien Monteleone  
wrote:

> Peter,
> 
> Check this thread and see if that fixes your issue: 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-April/075937.html
> 
> Regards,
> 
> Adrien
> 
> 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] Gnucash 3 unable to recognise SQLITE files on MAC OSX

[Peter Rowed via gnucash-user]

Hello,

My Gnucash v3.0 install cannot recognise my Gnucash 2.x SQLITE data base

I am running on Gnucash Version 3.0., Build ID git 3.0+(2018-04-01) on:

- MacOS High Sierra Version 10.13.14
- iMac Mid 2010

On starting Gnucash, get message:

- "No suitable backend was found for /Users/peterrowed/Data/HC.gnucash

where it is trying to open HC.gnucash which is my live Gnucash 2.6.18 file 
(SQLITE).

I have tried 2 other databases that give the same error. All 3 database are 
functioning normally with Gnucash 2.6.18

Ignoring the error and going to create a new data base and save (as SQLITE) I 
am only presented with the XML format in the drop down of the Save As tile.

I downloaded the dmg, opened it and dragged the Gnucash.app to the Applications 
directory.

in the 
[Gnucash.app/Contents/Resources/lib](http://Gnucash.all/Contents/Resources/lib) 
there is a file called libsqlite3.0.dylib

However I have not changed my $PATH. I have never had to do that in the past.

Can you help me

Thanks

Regards Peter

Sent with [ProtonMail](https://protonmail.com) Secure Email.
___
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.