Re: [GNC] Getting the date order in a report ?

[Finbar Mahon]

Thanks, but I have found, via various 'tests', a set of options that 
works. It requires a bit of homework, trying various combinations.


IMO, the options under edit>report options are sufficient, if a bit 
laborious to set up. There is a 'bonus' if you have any spelling errors 
in transactions, for ex, they show up as new entries in a  report!


Thanks to all  for the suggestions. Happy New Year!

Barry

On 04/01/2019 02:16, Christopher Lam wrote:
This set of options sounds about right. What's the output? You can 
attach a screenshot, blanking out confidential data.

Don't forget to set General/Add options summary to 'always'

On Thu, 27 Dec 2018 at 17:47, Finbar Mahon > wrote:


Thanks, but I am not too sure what options I should chose to get the
registry sort order.

I used the edit>report options and after bit of fiddling I have a
result
by month in 'proper' date order.

That is OK, but I would like to get Source of Salary from Income >
Salary and annual/by month, in date order.

The selection I have under report options > sorting is -

Primary Key - Account Name; Primary Subtotal clicked; Primary Sort
order
-  Ascending; Secondary Key - date; Secondary Subtotal for date key -
monthly

I am using 2.6.19 on Windows 10

Barry

On 24/12/2018 20:18, David Carlson wrote:
> I am not sure if this will help.  Check that the register sort
order
> is set to date posted.  If that does not work please let us know
which
> GnuCash release you are using and your operating system.
>
> David C
>
> On Mon, Dec 24, 2018, 4:49 AM Finbar Mahon mailto:mahon.fin...@neuf.fr>
> > wrote:
>
>     Hello, this is not urgent, just so I don't forget.
>
>     I am trying to print a listing of salary payments for the year.
>
>     I have selected the description for the transaction report
and the
>     data
>     I want appears, fine.
>
>     However the dates are random, typically the output is date, the
>     description, the amount, but the sequence of the dates is
all over
>     the
>     place.
>
>     I've looked through and selected the various options I think I
>     need but
>     cannot find a way of getting things in date order.
>
>     Ideas?
>
>     Thanks, and best wishes of the season, Barry
>
>     ___
>     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.


___
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] Tutorial for moving stock between accounts?

[Christopher Lam]

On 4/1/19 12:00 am, Jon Leech wrote:

I don't know how typical my use case is, but that seems like an
unwise thing to do, in general. I wouldn't want to realize capital gains
or losses solely as a side effect of moving shares from one broker to
another!

All brokers I have accounts with have a process for directly
transferring shares, usually just filling out a web form identifying the
other broker and the specific shares / lots to transfer.

This seems reasonable.

A major issue is not really the limitations of recording the transfer of
shares as you wish, but whether the engine supports it and whether reports
can handle such transactions.

Please be aware, and be ready to file any bugs!

(Hint: set up a shadow datafile with simple bogus data that can illustrate
your intentions, and can be shared on bugzilla)
___
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] GNU generated report in HTML to XL

[Finbar Mahon]

Hello again.

I think I solved the problem.

I did what David suggested, but copied the whole doc, title and 
all,after 'select all. Then I tried just the data, no title, it worked! 
Offered me all the 'paste' options in calc


Don't ask me why!

Thanks, Barry

On 03/01/2019 13:09, Finbar Mahon wrote:

Thanks both, but I still seem to be having a problem.

I have a file -

 /gnu p&l2018.html

If I try to cut and paste the data to a new libreoffice calc file I 
get only 'paste only' as an option under >edit, and nothing else 
recognisable from >insert.


I have tried 'insert sheet' under >insert but only get the option to 
insert before or after and then cannot copy the 'new' sheet into an 
existing one, if I add 'after'


There doesn't seem to be a method of cut and paste directly, afaics.

Thanks, Barry

On 02/01/2019 17:51, David Carlson wrote:

Finbar,

You may need to first open a new blank spreadsheet then cut and paste 
from the html document into the spreadsheet rather than trying to 
directly open HTML with Calc.


My experience with LibreOffice Calc is that it will import several 
different kinds of files.  I use it regularly to convert transaction 
detail exports from a certain department store website to a form from 
which I can manually extract data to enter into GnuCash, although I 
have not figured out how to restructure it to use the CSV importer 
for that case.


David C

On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon > wrote:


    Hello,

    I exported a GNUCash report to HTMl, but I don't seem to be able to
    import it to LibreOffice Calc, the LibreOffice xl equivalent.

    Does anybody know if I must use 'real' MS XL to receive the HTML
    file?
    In LibreOffice you can save calc files in MS format. Are there any
    special tricks for importing?

    I am using 3.3 on Windows 10.

    Thanks, Barry

    ___
    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.

___
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] AqBanking help for Citi CC (continued)

[Dawid Wrobel via gnucash-user]

There was a "[GNC] AqBanking help for Citi CC" thread last October about
getting the City CC working with AqBanking. It seemed that the key was to
add a trailing space to the User ID. Specifically, the following settings
were reported to function properly by Jim Maki:

AqBanking Setup
   ==>  User Settings
   >  User Name - "YOURUSERID"
   >  User Id - "YOURUSERID " (trailing space)
   >  Client UID - not specified
   ==>  Bank Settings
   >  Bank Name - "Citi Credit Card"
   >  Broker Id - "Citigroup"
   >  FID - "24909"
   >  ORG - "Citigroup"
   >  Server URL - "
https://www.accountonline.com/cards/svc/CitiOfxManager.do";
   ==>  Application Settings
   >  Application ID - "QWIN"
   >  Application Version - "2900"
   >  Header Version - "103"
   >  No Special Settings
   ==>  Account Info
   >  Account Number - "YOUR CC NUMBER"
   >  Account Name - "Citigroup"
   >  IBAN - not specified
   >  Owner Name - not specified
   >  Currency - "US Dollar (USD)"
   >  Account Type - "Credit Card Account"
   ==>  Bank Info
   >  Country - "United States of America (US)"
   >  Bank Code - "www.accountonline.com"
   >  Bank Name - "www.accountonline.com"
   >  SWIFT BIC - not specified
   >  Selected User - the user you defined above

Unfortunately, this doesn't work on my end using GnuCash 3.4 on macOS – I
am getting the 403 error.

The full output:

AqBanking v5.7.8.0stable
Sending jobs to the bank(s)
Locking user *username*
Saving communication log to /tmp/ofx.log
Sending request...
Connecting to server...
Resolving hostname "www.accountonline.com" ...
IP address is "173.223.170.86"
Connecting to "www.accountonline.com"
Connected to "www.accountonline.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
Signer not found
Certificate is not trusted
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 403 (Forbidden)
Error parsing server response
Unlocking user *username*
Postprocessing jobs
Job Get Transactions: finished
Resetting provider queues

For what it's worth, I have no special characters in my credentials. I also
turned off the 2-step verification I had enabled on my account.

Can anyone please confirm the OFX connection still works for them with
Citi? I will much appreciate that.

Thanks,
Dawid
___
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] Tutorial for moving stock between accounts?

[John Ralls]

> On Jan 3, 2019, at 8:00 AM, Jon Leech  wrote:
> 
>   (BTW, sorry for messing up the threading. I have had a pending
> subscription request since before I started this thread, which still
> hasn't been approved, so I'm limited to responding to messages that are
> CCed directly to me, or cutting and pasting other content from the web
> archive).

If you can post, you’re subscribed. Log in to 
https://lists.gnucash.org/mailman/listinfo/gnucash-user 
 and check that Mail 
delivery is enabled for the list.

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] Gnucash errors

[Adrien Monteleone]

Thomas,

Please be sure to e-mail this list on all replies.

I’m not quite understanding.

What tabs are visible when the application starts? (at the very least you 
should have the “Accounts” tab)

What do you mean by ’shows the data that I have entered...”? Can you provide a 
screenshot? (be sure to blur any sensitive data)

And by “cannot access”? Can you not open a tab for an account register and make 
an entry?

Also, there is no “open” tab. There is the File > Open menu option but it opens 
a new book.

Regards,
Adrien

> On Jan 4, 2019, at 8:25 AM, Thomas Hill  wrote:
> 
> Hi Adrien,
> 
> I have Gnucash 2.6.19 installed on my MacBook Pro Mojave 10.14.2. I last made 
> entries into the program in 12/18.
> 
> This morning, I opened the program to begin my accounting work. It opened, 
> showed the open tabs for my account, shows the data that I have entered for 
> the tabs, but I cannot access the data. I click on the “open” tab, it shows 
> the existing data, but I cannot access it.
> 
> Thomas Hill
> hill_...@att.net
> www.masterministries.org
> 
> 
> 
> 
> 


___
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] UK specific: any progress on MTD (Making Tax Difficult) ?

[BobBriscoe]

David Goodenough-2 wrote
> The problem is that GC needs to be allocated a program ID which we have to
> keep secret, 
> but needs to be issued to any user.  No ID and GC users can not go through
> the OAuth2 
> process every 18 months.
> 
> GC could put the code on a web site and have the GC code retrieve it,
> which is the cabinet 
> office solution to the problem, but given that the code to retreive it
> would be open source 
> GC would have no control over how the code was used.  If HMRC decide that
> someone 
> using the GC code is messing with their systems then they would ban that
> code and thus 
> all legitimate GC users.

I read through the  MTD (VAT) API documentation

  
yesterday, and although the API itself looks relatively straightforward, I
agree that the Authorization aspect is the hard part if you are not used to
writing this type of application.

By my reading of  HMRC's OAuth 2.0 documentation

 
, the client_id (which I assume is what you mean by a program ID) is not a
secret, it's merely a unique identifier for the application. It looks like
communication with the app uses i) a URI for the app (which can be local);
ii) the client_id to ensure it is talking to the right type of app; and iii)
an optional state variable that the app can generate to distinguish
different interactions.

The basic idea seems to be that your software is expected to be able to make
the HMRC's login page visible to the user, and give a redirect URI so that,
once the user has logged in, the HMRC server can return a code to the
original calling app at this URI. The original app then has 10 minutes to
POST this code to HMRC's token endpoint to get back an access token that it
can use against the MTD (VAT) API for the next 4 hours before having to
refresh it. Caveat: I haven't tried it yet.

I'm not planning on using GnuCash, but I'm considering writing bridging
software from LibreOffice calc, and I came across this thread while
searching for MTD solutions that will work on Linux. I don't really want to
spend my time on this, but I might have to, given I do the accounting for
two small VAT-registered businesses.


Bob



--
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.

[GNC] Tracking Reimbursable Medical Expenses

[Aaron Laws]

I have a Health Savings Account in the United States as part of a
high-deductible health insurance plan. It is an Asset account that holds my
income tax-deductible money for use on medical expenses only. Every so
often money is put into it:

Assets:HSA$10
Revenue:Employer   $10

When I incur a medical expense, I use my personal credit card to pay for it:

Expenses:Medical $5
Liability:Credit Card $5

After a while, I reimburse myself for the medical expenses that have
accumulated to date:

Assets:Chequing $5
 Assets:HSA $5

The trouble with this is it doesn't track the current amount of unpaid
claims. Is there a way to work in an Assets:Accounts Receivable:Outstanding
Medical Reimbursements or something like that? I would appreciate any
feedback about how to deal with this situation. Thank you!

In Christ,
Aaron Laws
___
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

[Stephen M. Butler]

On 1/4/19 10:59 AM, Aaron Laws wrote:
> I have a Health Savings Account in the United States as part of a
> high-deductible health insurance plan. It is an Asset account that holds my
> income tax-deductible money for use on medical expenses only. Every so
> often money is put into it:
>
> Assets:HSA$10
> Revenue:Employer   $10
>
> When I incur a medical expense, I use my personal credit card to pay for it:
>
> Expenses:Medical $5
> Liability:Credit Card $5
>
> After a while, I reimburse myself for the medical expenses that have
> accumulated to date:
>
> Assets:Chequing $5
>  Assets:HSA $5
>
> The trouble with this is it doesn't track the current amount of unpaid
> claims. Is there a way to work in an Assets:Accounts Receivable:Outstanding
> Medical Reimbursements or something like that? I would appreciate any
> feedback about how to deal with this situation. Thank you!
>
> In Christ,
> Aaron Laws

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 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.

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:

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)

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

-- 
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

[David Cousens]

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

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



-
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] Car loan with downpayment using a credit card

[Taymour A. El Erian]

>
> 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.
___
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] Line entry creates incorrect balance

[Ted]

Sirs,

I am using GnuCash and I am trying to make a simple ledger checking account 
register.  I have it set to date of entry and after I get down to line 44 of 
my entries I notice that the running balance is off.  I have found that it 
take the amount in the line expense amount in line 44 and adding it the the 
expense amount in line 42 and getting a totally different amount the in the 
balance column in line 44.  I have deleted the information in line 44 
several times and the answer still remains the same.  What am I doing wrong 
and what can be done to correct it?
I have no accounting background and I want to keeps thing as simply as I 
can.
Thanks for you time and assistance.

Ted













THANK YOU for deleting ALL PRIOR e-mail addresses before forwarding this 
message. 
And PLEASE use Bcc: for any "bulk" e-mailings, instead of To: or Cc:.
By helping to keep our addresses private, we might be able to cut down on spam 
and computer identity theft.




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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

[David T. via gnucash-user]

Of course, one could implement an accounts receivable structure without using 
the business features. The user would create the appropriate accounts, and add 
transactions to document things manually. 

 
 
  On Sat, Jan 5, 2019 at 4:14, 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

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



-
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] Line entry creates incorrect balance

[David Carlson]

Ted,

This is my initial advice to a new user:

First skim through the Help manual up to chapter 6

https://www.gnucash.org/docs.phtml

Then start GnuCash following the instructions in chapter 3 and create a
test file with a minimal set of accounts.  You should consider it to be a
throw-away test, so name it as such and save it in some sub-directory off
of your home page.

There are a couple of videos available on U-Tube that you may find helpful,
even tho they are rather out of date, very little has changed in the basic
program and they should be easy to follow.

There are a couple of preferences that should be set before going further.
While you have your first bank account register in view select View > Auto
Split Ledger and View > Double Line.  You can change those later but start
there to have a view that you can relate to the examples that you will
encounter later in the Help Manual.
Also check View > Sort by > and set it to Standard Order.

Then the highlight will show the selected transaction with two yellow lines
at the top.  When you start entering a new transaction the curser starts in
the yellow highlight and as you tab from box to box you eventually move the
yellow highlight into the next line where you can enter memo, the
Asset:bank account, then Deposit or Withdrawal amount.  Tab again to enter
another memo, then the transfer Expense:Account or Income:Account and the
opposite value will automatically appear.  When you press Enter the lines
may swap so the first line is always on the left or deposit side and the
second line is on the right or Withdrawal side.

Enter several sample transactions. Since you are in a bank account register
your deposits should increase the balance and withdrawals decrease the
balance.  If you get one backwards, just highlight the value, then left
arrow > minus, tab to the other value and again left arrow > minus, Enter.

When you enter another transaction the yellow highlight is at the top and
it shows the value that, when added to the Balance in the transaction
above, results in the new Balance.

If not, be prepared to tell us what version of GnuCash you installed into
what operating system and exactly what steps you followed to get to a
result that does not add up.

Good Luck,

David C


On Fri, Jan 4, 2019 at 8:35 PM Ted  wrote:

>
> Sirs,
>
> I am using GnuCash and I am trying to make a simple ledger checking
> account
> register.  I have it set to date of entry and after I get down to line 44
> of
> my entries I notice that the running balance is off.  I have found that it
> take the amount in the line expense amount in line 44 and adding it the
> the
> expense amount in line 42 and getting a totally different amount the in
> the
> balance column in line 44.  I have deleted the information in line 44
> several times and the answer still remains the same.  What am I doing
> wrong
> and what can be done to correct it?
> I have no accounting background and I want to keeps thing as simply as I
> can.
> Thanks for you time and assistance.
>
> Ted
>
>
>
>
>
>
>
>
>
>
>
>
>
> THANK YOU for deleting ALL PRIOR e-mail addresses before forwarding this
> message.
> And PLEASE use Bcc: for any "bulk" e-mailings, instead of To: or Cc:.
> By helping to keep our addresses private, we might be able to cut down on
> spam and computer identity theft.
>
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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

[David Cousens]

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.