[GNC] Fwd: ^F Find not finding recently entered text in Memo field

[David Carlson]

I will never learn how Gmail works.

-- Forwarded message -
From: David Carlson 
Date: Mon, Jan 23, 2023 at 10:22 PM
Subject: Re: [GNC] ^F Find not finding recently entered text in Memo field
To: Jeff Albrecht , 


Jeff,
Please reply to list so others can contribute to the discussion.  I took
the liberty of posting this reply to the list.

Looking at your illustration, if you search for that text string
"Detection" starting from the register for "Expenses:Household:Misc"  or
from the Accounts tab, it will be found, but it will not be found if you
start your search from that bank account register.  That is no different
from GnuCash behavior over the last several years.

On Mon, Jan 23, 2023 at 6:10 PM Jeff Albrecht  wrote:

> On 1/23/2023 4:36 PM, David Carlson wrote:
>
> Jeff,
> Is the text that you are searching for  in a split line for the home bank
> register or is it in the "other" split line?
>
> Here is an image previously removed by the list. Sorry, I don't know how
> to answer you precisely. However if my memory of using find in the past is
> correct find is not currently, in my installation, behaving as it has in
> the past for me.
>
> This image is my search from the bank register where the transaction with
> the string I'm trying to find resides.
>
> Today, I have entered a couple splits to a transaction with what I believe
> is 'memo' detail which were not found by the find command executed in the
> containing banking register. Note that the find did list some transactions
> found in that register from previous years - ?possibly pointing to version
> 4.13 as the culprit? It appears to be finding as I would expect for
> transactions entered previous to my upgrade to 4.13
>
>
>
>
>  - Jeff
>
>
> On Mon, Jan 23, 2023, 4:41 PM Jeff Albrecht  wrote:
>
>> On 1/23/2023 3:27 PM, David H wrote:
>> > Jeff,
>> >
>> > If you do a find from the accounts tab it will search in all splits,
>> > if however you do a find in a Register tab it only looks at splits for
>> > that particular Register, it doesn't search in splits belonging to
>> > other Register's.  Are you falling into this trap ?
>>
>> Thanks David. Interesting,
>>
>> If I do the find from the Accounts tab it does find the transaction. But
>> I have been searching in the bank register where the transaction I'm
>> looking for resides. It doesn't find the transaction that is in the bank
>> register searched from that specific bank register where the transaction
>> I'm looking for resides.
>>
>>   - Jeff
>>
>>
>> >
>> > Cheers David H.
>> >
>> >
>> > On Tue, 24 Jan 2023 at 08:06, Jeff Albrecht  wrote:
>> >
>> > Windows 11
>> > Version: 4.13
>> > Build ID: 4.13+(2022-12-17)
>> >
>> > FWIW I've been, happily, using GNUCash for several years.
>> >
>> > I'm working on my 2022 taxes importing .OFX files from my banks. I
>> > generally want to add a memo on most transactions with notes found
>> > from
>> > the vendor transaction details on their respective sites. Since this
>> > adding memos isn't currently possible during the import I move
>> > transaction to a temporary 'unaccounterd for 2022' register where
>> > I add
>> > notes in the memo field, categorize the transaction and save.
>> >
>> > Occasionally I want to verify that I entered the correct notes in
>> the
>> > Memo field. I do a find with 'contains' searching in the
>> > 'description,
>> > notes or memo' This find operation doesn't appear to be finding
>> > transactions I've entered today although if I search visually
>> through
>> > the register they have been entered. I did upgrade to 4.13 from some
>> > 4.xx version before I started working on this .OFX import. I haven't
>> > used Find for some time but if my memory is correct I've used find
>> > similarly in the past successfully.
>> >
>> > I tried to find some kind of re-indexing function. Does such an
>> > option
>> > exist?
>> >
>> > I did try exiting and restarting GNUCash and repeating the find
>> > with the
>> > same results, not finding transaction with memos entered today.
>> >
>> >
>> >
>> >
>> >
>> > --
>> > Jeff Albrecht KF7CRU @jhalbrecht
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>>
>> --
>> Jeff Albrecht KF7CRU @jhalbrecht
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using 

[GNC] Fwd: Delivery Status Notification (Failure)

[David Carlson]

I cut and pasted an incomplete address.  This should work

-- Forwarded message -
From: Mail Delivery Subsystem 
Date: Mon, Jan 23, 2023 at 10:22 PM
Subject: Delivery Status Notification (Failure)
To: 


[image: Error Icon]
Address not found
Your message wasn't delivered to *u...@gnucash.org* because the address
couldn't be found, or is unable to receive mail.
The response from the remote server was:

550 5.1.1 : Recipient address rejected: User unknown



-- Forwarded message --
From: David Carlson 
To: Jeff Albrecht , u...@gnucash.org
Cc:
Bcc:
Date: Mon, 23 Jan 2023 22:22:28 -0600
Subject: Re: [GNC] ^F Find not finding recently entered text in Memo field
- Message truncated -


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] No Online Banking List of Banks

[john]

That is/was provided by ofxhome.com , which has new 
owners: https://www.ofxhome.com/ofxforum/viewtopic.php?pid=109005

Maybe something has changed that broke whatever API AQBanking uses. You can 
still do your queries on the website and copy the info into AQBanking setup 
yourself.

Regards,
John Ralls


> On Jan 23, 2023, at 9:10 AM, Nicholas Rood via gnucash-user 
>  wrote:
> 
> Hello,
> 
> I've been using GnuCash for quite a while mainly on Linux but haven't
> added any new online banking info in a long time.  In the online
> banking setup there is no longer a list of banks populated in the bank
> settings for OFX DirectConnect User Setup.
> 
> GnuCash 4.13
> Build ID: Flathub 4.13
> 
> AqBanking-CLI: 6.5.3
> Gwenhywfar : 5.10.1.0
> AqBanking : 6.5.3.0
> 
> Any ideas?
> 
>  
> 
> Thanks,
> 
> Nicholas Rood
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions about setting up new accounts from brand new user

[R Losey]

I agree.  I let GnuCash create a chart of accounts and then modify it to
meet my needs.

On Mon, Jan 23, 2023 at 12:21 PM David Carlson 
wrote:

> Maf showed you how to start to create a single account.
>
> If you want to create an entire chart of accounts click File > New and
> select the option to create New Account Hierarchy Setup
> You might want to try this more than once because it will then give you a
> lot of choices for different applications and you may be a little
> overwhelmed the first time around.
>
> On Mon, Jan 23, 2023 at 11:29 AM Maf. King  wrote:
>
> > On Monday, 23 January 2023 17:10:51 GMT Ann Bowes wrote:
> > > Hi folks,
> > >
> > > I'm trying to set up a simple manual checking account for a small farm
> > > business.  I've down-loaded the gnucash program to my laptop (linux
> > > zorin OS), and have tried to open new accounts, but am completely
> > > stumped as to how to do this.  I've read through the tutorial (at
> > > https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm
> > > still stumped  Can anyone give me some pointers?
> > >
> >
> > Hi Ann,
> >
> > you mean you need to create an account in your Gnucash books?
> >
> > see the attached image for a pointer...
> >
> > 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
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entering Dividend Confusion

[R Losey]

On Sat, Jan 21, 2023 at 3:28 PM flywire  wrote:

> R Losey wrote:
>
>> You need to make sure that your... stock is set up as an account type of
>> "Mutual Fund" or "Stock"
>
> No you don't, dividends can be entered into a dividend account like any
> other transaction. The main feature of a "Stock" account type  is easier
> revaluation of a portfolio, ie what is my portfolio worth on the day prices
> were updated. It is also a stock classification feature on the payment.
>
>
As I recall, the original question was why the account was missing the
stock and price options.


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there any way to find all outstanding bills?

[Dr. David Kirkby]

On Tue, 24 Jan 2023 at 01:50, Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> have you tried looking at the Payable ageing report
>
>
> Saludos Cordiales
>
>
> Murugan
>

No, I had not, and that seems to have what I wanted. I'm just a bit puzzled
that some of the figures don't make sense. If I look at Accounts Payable,
which is in GBP, the data seems correct - I owe RS £210.41.

Accounts Payable for USD and HKD are both zero, but the report indicates
monies are owed. But when I click on the vendors, it shows nothing owed.
When I click on the bills, it shows these are paid.

These seem to have a pre-payment on these couple of transactions. I assume
I have done something wrong with these transactions, It's a lot more
complicated dealing with payments in another currency. I assume this means
there's a good chance reports I generate will be wrong. One of the amounts
(USD amount) is very small, but the one in HKD is not so small.

BTW, I was in the pub a couple of weeks ago, and somehow got chatting to a
chartered accountant. I was telling him about issues when invoicing people
in USD or Euros (my native currency is GBP). He said that I should not be
billing people in anything other than GBP. I asked him whether he thought I
was breaking the law in invoicing in USD and Euros, and he said that* in
his opinion, it is against the law for me to invoice customers in anything
other than GBP*. My accountant has never had a problem with this, but it
obviously caused me to research it more. Our government website clearly
states we can invoice in any currency. The only requirement is that if VAT
is payable, then that amount needs to be in GBP. But it would be quite rare
to invoice someone in USD if they are in the UK.

I'm pretty sure this guy in the pub was wrong, despite him saying he was a
chartered accountant. From our own government website.

https://www.gov.uk/guidance/foreign-currency-transactions-vat-and-tour-operators

*You can invoice in any currency for the goods and services that you
supply. If UK VAT is due on the transaction your invoices must also show
the following in sterling:*

   - *the total net value of goods and services at each VAT rate*
   - *the amount of VAT, if any, at each rate*

*You do not need to show sterling figures for each line on the invoice.*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] No Online Banking List of Banks

[Nicholas Rood via gnucash-user]

Hello,

I've been using GnuCash for quite a while mainly on Linux but haven't
added any new online banking info in a long time.  In the online
banking setup there is no longer a list of banks populated in the bank
settings for OFX DirectConnect User Setup.

GnuCash 4.13
Build ID: Flathub 4.13

AqBanking-CLI: 6.5.3
Gwenhywfar : 5.10.1.0
AqBanking : 6.5.3.0

Any ideas?

 

Thanks,

Nicholas Rood

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there any way to find all outstanding bills?

[Murugan Muruganandam]

have you tried looking at the Payable ageing report




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Dr. 
David Kirkby 
Sent: Monday, January 23, 2023 7:25 PM
To: GNU Cash User 
Subject: [GNC] Is there any way to find all outstanding bills?

A look at* Liabilities:Accounts Payable* allows me to find out how much. If
the bills are due, then looking at Business -> Vendor -> Bills Due
Reminder, will allow me to find any that need to be paid soon. But is there
any way of finding a list of everyone owed money at some time in the
future? I believe one can tweak the reminder period, so one could set it to
remind one 6 months in advance of any bills due. But I'm wondering if
there's a quicker way.

Dave
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there any way to find all outstanding bills?

[Adrien Monteleone]

The Bills Due Reminder is not just short term, it should show all unpaid 
bills *that are posted*. (in conjunction with setting the reminder 
window via Preferences > Business > Bills > Notify when due & Days in 
advance.)


You can also do Business > Vendor > Find Bill and set the criteria to 
find unpaid bills.


GnuCash does not have a projection feature to automatically guess if 
certain bills continue or not. However, the Budget module may be useful 
there, (and it does have an estimating function based on historical 
activity) or you can employ future Scheduled Transactions (SX) which 
make a few reports designed for them a bit more useful for such a 
scenario. If you choose the SX route, you can get them to fire, run your 
report, delete them and then turn off the SXs till needed again. (*note, 
going the SX route is 'outside' the cognizance of the Business Features, 
so really only useful for projection reports, not as a regular 
data-entry substitute)


Regards,
Adrien

On 1/23/23 4:25 PM, Dr. David Kirkby wrote:

A look at* Liabilities:Accounts Payable* allows me to find out how much. If
the bills are due, then looking at Business -> Vendor -> Bills Due
Reminder, will allow me to find any that need to be paid soon. But is there
any way of finding a list of everyone owed money at some time in the
future? I believe one can tweak the reminder period, so one could set it to
remind one 6 months in advance of any bills due. But I'm wondering if
there's a quicker way.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions about setting up new accounts from brand new user

[Adrien Monteleone]

On 1/23/23 2:33 PM, flywire wrote:

that isn't the latest, nor official documentation.


No, it's not but it is the version I recommend. Feedback on how it compares
with the official version would be useful.


The official documentation should always be the recommendation. It is 
actively maintained, refined and updated to match the current app 
version. (not perfect, but it is always the best version)


You'd have to diff the two or find a way to merge/copy the gnucash-docs 
PRs to that readthedocs repo.


Also, that link is just the Tutorial & Concepts Guide. It doesn't look 
that Repo contains the Help documentation, and I didn't find a separate 
link for one.



Two farm-related use issues for me are no automatic sales tax calculations
for cash accounting (only business features with accrual accounting) and no
classification on transactions (eg classify your vehicle expenses for lamb
and tourism enterprises then report by classification). There are
workarounds.


And those workarounds aren't terribly difficult:

1. Create invoices as needed, and either wait to post until they are 
paid, or unpost/repost/process-payment. (or handle 
point-of-sales/invoicing outside of GnuCash and import the result)


2. Use any free-form 'tag' in your transactions using various or 
multiple fields and use the Transaction Report with filters. (not 
perfect, I know, and it would be nicer if the Income Statement supported 
the same filters)



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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ^F Find not finding recently entered text in Memo field

[David Carlson]

Jeff,
Is the text that you are searching for  in a split line for the home bank
register or is it in the "other" split line?


On Mon, Jan 23, 2023, 4:41 PM Jeff Albrecht  wrote:

> On 1/23/2023 3:27 PM, David H wrote:
> > Jeff,
> >
> > If you do a find from the accounts tab it will search in all splits,
> > if however you do a find in a Register tab it only looks at splits for
> > that particular Register, it doesn't search in splits belonging to
> > other Register's.  Are you falling into this trap ?
>
> Thanks David. Interesting,
>
> If I do the find from the Accounts tab it does find the transaction. But
> I have been searching in the bank register where the transaction I'm
> looking for resides. It doesn't find the transaction that is in the bank
> register searched from that specific bank register where the transaction
> I'm looking for resides.
>
>   - Jeff
>
>
> >
> > Cheers David H.
> >
> >
> > On Tue, 24 Jan 2023 at 08:06, Jeff Albrecht  wrote:
> >
> > Windows 11
> > Version: 4.13
> > Build ID: 4.13+(2022-12-17)
> >
> > FWIW I've been, happily, using GNUCash for several years.
> >
> > I'm working on my 2022 taxes importing .OFX files from my banks. I
> > generally want to add a memo on most transactions with notes found
> > from
> > the vendor transaction details on their respective sites. Since this
> > adding memos isn't currently possible during the import I move
> > transaction to a temporary 'unaccounterd for 2022' register where
> > I add
> > notes in the memo field, categorize the transaction and save.
> >
> > Occasionally I want to verify that I entered the correct notes in the
> > Memo field. I do a find with 'contains' searching in the
> > 'description,
> > notes or memo' This find operation doesn't appear to be finding
> > transactions I've entered today although if I search visually through
> > the register they have been entered. I did upgrade to 4.13 from some
> > 4.xx version before I started working on this .OFX import. I haven't
> > used Find for some time but if my memory is correct I've used find
> > similarly in the past successfully.
> >
> > I tried to find some kind of re-indexing function. Does such an
> > option
> > exist?
> >
> > I did try exiting and restarting GNUCash and repeating the find
> > with the
> > same results, not finding transaction with memos entered today.
> >
> >
> >
> >
> >
> > --
> > Jeff Albrecht KF7CRU @jhalbrecht
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
> --
> Jeff Albrecht KF7CRU @jhalbrecht
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Merge two pairs -> one 4-way split

[Justin Vallon]

Maybe unrelated, but when entering reimbursable transactions, I enter a 
second transaction to indicate a reimbursable expense. Mostly so I don't 
lose it.


For example:

Day1 Doctor Visit - Copay
                         Amex  -20
                     Doc       +20
                         FSA Funds -20
 Memo: DocVisitDay1  FSA Unclaimed +20

Now, I have an FSA Unclaimed account with non-zero balance. Since there 
is a non-zero balance there, I need to enter some claims.  When I enter 
the claim:


Day2 Submit claim
 Memo: DocVisitDay1  FSA Unclaimed  -20
Memo: DocVisitDay1  FSA Submitted  +20

If I don't have the "FSA" account on the original visit, it becomes 
difficult to locate that original Doctor Visit transaction, since it is 
in a different account.  Or, I would need to make sure that I 
simultaneously enter the Copay entry and submit the insurance claim, 
otherwise I might lose track of the original expense that I need to submit.


This is from the GNUCash manual: 
https://www.gnucash.org/docs/v4/C/gnucash-guide/accts-oa5.html - 
reimbursable expenses, travel advances


For example, when you use your personal card on a business trip, you 
enter CreditCard -X, Dining +X and Employer -X, Reimbursable +X in the 
same transaction.  At the end of the trip, submit all Reimbursable 
entries, and wait for a check from your employer. The check is entered 
as Reimbursable -X, Checking +X.


For an out-of-network doctor:

Day1  DocVisit  Medical +200
    Doc +200
Day1  DocPay        Amex -200
            Doc +200
Medical -200
Unclaimed +200
Day2  Submit DocVisit to insurance  Unclaimed -200
Claimed +200
Day20 EOB                           Claimed -200
  Covered 75% Covered +150
  Copay, etc Uncovered +50
Uncovered -50
FSA Unclaimed +50
Day21 Insurance Check   Covered -150
    Checking +150
Day22 FSA Submit    FSA Unclaimed -50
            Submitted +50
Day25 FSA Approved                  Submitted -50
    Approved +50
Day28 FSA Reimburse                 Approved -50
            Checking +50

You can shorten some of these A>B>C transfers, but since the processing 
period is sometimes weeks, the dates on the doctor visit, insurance 
check, and FSA reimburse might be days or weeks apart.  The date of the 
Insurance check deposit should correspond to the deposit date, not the 
doctor visit date; same for the FSA reimbursement.


-Justin

On 1/15/23 3:46 PM, Phyllis Bruce wrote:

I agree, why change them.  However, I question the need to make a single 4
way split unless one of the transactions is to or from a single account.

On Sun, Jan 15, 2023 at 1:51 PM Fred Tydeman  wrote:


I have one transaction moving money from A to B (one pair)
I have another transaction moving money from C to D (another pair)
I now realize I should have one transaction with 4 splits.
Is there an easy way to merge the two pairs into one 4-way split?
Or, do I have to manually re-enter 40 transactions?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] python bindings: How to add or get commodity quotation records in python?

[Arkadiusz Dabrowski]

Hi all
In GnuCash GUI I'm able to add commodity quotations manually.
But I'd like to add some quotations using my own script
Surprisingly I don't see any related operation in GncCommodity class. Also
I haven't found anything interesting in gnc-commodity.h
Have I missed something?
Is it possible at 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ^F Find not finding recently entered text in Memo field

[Jeff Albrecht]

On 1/23/2023 3:27 PM, David H wrote:

Jeff,

If you do a find from the accounts tab it will search in all splits, 
if however you do a find in a Register tab it only looks at splits for 
that particular Register, it doesn't search in splits belonging to 
other Register's.  Are you falling into this trap ?


Thanks David. Interesting,

If I do the find from the Accounts tab it does find the transaction. But 
I have been searching in the bank register where the transaction I'm 
looking for resides. It doesn't find the transaction that is in the bank 
register searched from that specific bank register where the transaction 
I'm looking for resides.


 - Jeff




Cheers David H.


On Tue, 24 Jan 2023 at 08:06, Jeff Albrecht  wrote:

Windows 11
Version: 4.13
Build ID: 4.13+(2022-12-17)

FWIW I've been, happily, using GNUCash for several years.

I'm working on my 2022 taxes importing .OFX files from my banks. I
generally want to add a memo on most transactions with notes found
from
the vendor transaction details on their respective sites. Since this
adding memos isn't currently possible during the import I move
transaction to a temporary 'unaccounterd for 2022' register where
I add
notes in the memo field, categorize the transaction and save.

Occasionally I want to verify that I entered the correct notes in the
Memo field. I do a find with 'contains' searching in the
'description,
notes or memo' This find operation doesn't appear to be finding
transactions I've entered today although if I search visually through
the register they have been entered. I did upgrade to 4.13 from some
4.xx version before I started working on this .OFX import. I haven't
used Find for some time but if my memory is correct I've used find
similarly in the past successfully.

I tried to find some kind of re-indexing function. Does such an
option
exist?

I did try exiting and restarting GNUCash and repeating the find
with the
same results, not finding transaction with memos entered today.





-- 
Jeff Albrecht KF7CRU @jhalbrecht

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
Jeff Albrecht KF7CRU @jhalbrecht
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ^F Find not finding recently entered text in Memo field

[David H]

Jeff,

If you do a find from the accounts tab it will search in all splits, if
however you do a find in a Register tab it only looks at splits for that
particular Register, it doesn't search in splits belonging to other
Register's.  Are you falling into this trap ?

Cheers David H.


On Tue, 24 Jan 2023 at 08:06, Jeff Albrecht  wrote:

> Windows 11
> Version: 4.13
> Build ID: 4.13+(2022-12-17)
>
> FWIW I've been, happily, using GNUCash for several years.
>
> I'm working on my 2022 taxes importing .OFX files from my banks. I
> generally want to add a memo on most transactions with notes  found from
> the vendor transaction details on their respective sites. Since this
> adding memos isn't currently possible during the import I move
> transaction to a temporary 'unaccounterd for 2022' register where I add
> notes in the memo field, categorize the transaction and save.
>
> Occasionally I want to verify that I entered the correct notes in the
> Memo field. I do a find with 'contains' searching in the 'description,
> notes or memo' This find operation doesn't appear to be finding
> transactions I've entered today although if I search visually through
> the register they have been entered. I did upgrade to 4.13 from some
> 4.xx version before I started working on this .OFX import. I haven't
> used Find for some time but if my memory is correct I've used find
> similarly in the past successfully.
>
> I tried to find some kind of re-indexing function. Does such an option
> exist?
>
> I did try exiting and restarting GNUCash and repeating the find with the
> same results, not finding transaction with memos entered today.
>
>
>
>
>
> --
> Jeff Albrecht KF7CRU @jhalbrecht
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Is there any way to find all outstanding bills?

[Dr. David Kirkby]

A look at* Liabilities:Accounts Payable* allows me to find out how much. If
the bills are due, then looking at Business -> Vendor -> Bills Due
Reminder, will allow me to find any that need to be paid soon. But is there
any way of finding a list of everyone owed money at some time in the
future? I believe one can tweak the reminder period, so one could set it to
remind one 6 months in advance of any bills due. But I'm wondering if
there's a quicker way.

Dave
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] ^F Find not finding recently entered text in Memo field

[Jeff Albrecht]

Windows 11
Version: 4.13
Build ID: 4.13+(2022-12-17)

FWIW I've been, happily, using GNUCash for several years.

I'm working on my 2022 taxes importing .OFX files from my banks. I 
generally want to add a memo on most transactions with notes  found from 
the vendor transaction details on their respective sites. Since this 
adding memos isn't currently possible during the import I move 
transaction to a temporary 'unaccounterd for 2022' register where I add 
notes in the memo field, categorize the transaction and save.


Occasionally I want to verify that I entered the correct notes in the 
Memo field. I do a find with 'contains' searching in the 'description, 
notes or memo' This find operation doesn't appear to be finding 
transactions I've entered today although if I search visually through 
the register they have been entered. I did upgrade to 4.13 from some 
4.xx version before I started working on this .OFX import. I haven't 
used Find for some time but if my memory is correct I've used find 
similarly in the past successfully.


I tried to find some kind of re-indexing function. Does such an option 
exist?


I did try exiting and restarting GNUCash and repeating the find with the 
same results, not finding transaction with memos entered today.






--
Jeff Albrecht KF7CRU @jhalbrecht
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting Reports to CSV

[Phyllis Bruce]

Thanks David, my first try of copy and paste showed me it would be too much
work. I found this site:  www.myofficetricks.com › how-to-import-data-from

How to Import Data from HTML into Excel - My Microsoft Office ...
That
gave clear instructions on how to do it.  My Tax Schedule Report came in
with hardly an edit being needed.


On Jan 23, 2023, at 3:27 PM, David Cousens  wrote:

Phyllis ,

You can copy and paste from the html opened in a browser into Excel or Libre
Office. Certainly isn't perfect but most of the alignment is kept but if
you are
going that route, you are going to reformat it anyway.

David Cousens

On Mon, 2023-01-23 at 10:35 -0600, Phyllis Bruce wrote:

I found out how to export transactions, but how can I export my Tax report

as CSV?  My only options are HTML or TXF, neither allow me to reformat in

Excel.


Thanks, Pobruce

___

gnucash-user mailing list

gnucash-user@gnucash.org

To update your subscription preferences or to unsubscribe:

https://lists.gnucash.org/mailman/listinfo/gnucash-user

-

Please remember to CC this list on all your replies.

You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions about setting up new accounts from brand new user

[David Cousens]

Ann,
I you are getting the window with the Accounts tab (it is the default until you
open an account register) click on it then right click on whichever of the top
level accounts you wish to create the account under and slect New Account and
the account creation dialogue will come up. You can edit account details at any
time but changing the parent account will change the position in the account
tree. The choices for account type are usually limited to appropriate choices
for the parent account you selected in the first step.
David Cousens
On Mon, 2023-01-23 at 09:10 -0800, Ann Bowes wrote:
> Hi folks,
> 
> I'm trying to set up a simple manual checking account for a small farm 
> business.  I've down-loaded the gnucash program to my laptop (linux 
> zorin OS), and have tried to open new accounts, but am completely 
> stumped as to how to do this.  I've read through the tutorial (at 
> https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm 
> still stumped  Can anyone give me some pointers?
> 
> Much thanks,
> 
> Ann
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting Reports to CSV

[David Cousens]

Phyllis ,

You can copy and paste from the html opened in a browser into Excel or Libre
Office. Certainly isn't perfect but most of the alignment is kept but if you are
going that route, you are going to reformat it anyway.

David Cousens

On Mon, 2023-01-23 at 10:35 -0600, Phyllis Bruce wrote:
> I found out how to export transactions, but how can I export my Tax report
> as CSV?  My only options are HTML or TXF, neither allow me to reformat in
> Excel.
> 
> Thanks, Pobruce
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Getting OFX files via the command line: (was: Re: Morgan Stanley Portfolio)

[Stephen]

This is quite interesting. I'm not sure if I'm a future user but I do 
love to learn and explore things. I know zip about Python. I did explore 
the links a bit. I'm way over my head. One thing I did notice was the 
SSL Failed validation msgs in the ofxhome directory for Morgan Stanley 
and for another bank (JP Morgan Chase). Looking further into it both 
banks have SSL Failed Validation for every day since August 3, 2022. 
What is the significance of this, please? May one take it that the OFX 
non-fails is a good thing and data was obtained? Thanks,

 Stephen

On 1/23/2023 9:37 AM, Ed Greenberg wrote:

This was a great success.   I'll embellish a bit for the sake of others.

1. Install ofxtools.  For Windows, you may need python. For Mac and 
Linux, it's probably there.


Go to  https://ofxtools.readthedocs.io/en/latest/index.html to get the 
documentation, which includes an "Installing" section.


2. Find your bank.   do an 'ofxget list'  command.  You'll get a text 
table of institutions, each with a number.


Steve Brown pointed to a URL below, 
https://www.ofxhome.com/index.php/institution/view/500


where 500 is the number in 'ofxget list' output

3. Following the instructions under 'Using ofxget' do something like 
ofxget acctinfo ... and then ofxget stmt.


I was able to download an OFX from Morgan Stanley of my entire year's 
transaction history.


Thanks for the pointer, Steve.

Ed

On 1/22/2023 8:35:32 AM, Steve Brown wrote:

Morgan Stanley is running an OFX server. I'd see if I could get online
banking to connect with it and download that.

I haven't tried it as I don't have an account there, but I think all
the info you need to set it up is here:

https://www.ofxhome.com/index.php/institution/view/500

I was able to download the profile with ofxget from ofxtools and it
promises to support investments.

Good luck,

Steve


On Sun, 2023-01-22 at 06:29 -0500, Ed Greenberg wrote:

I have a portfolio at Morgan Stanley which generates some dividends,
income, cap gains distribution, etc. All sorts of odd transactions.
MS
does not offer a QFX/OFX, but only an excel download which is
inadequate
for import. Near as I can tell.

Does anybody have suggestions for interacting with Morgan Stanley?

I'm considering writing a transformation program that will read the
csv
and rewrite it in a more importable set of csv columns. Or just
biting
the bullet and keying it all in manually.

On the other hand, what procedures have people developed to track
just
the asset value of the entire portfolio and update it each month?

Thanks,

Ed Greenberg


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Questions about setting up new accounts from brand new user

[flywire]

If you do the "Putting It All Together" sections as you go through the
guide you will learn the basics and have a sample set of books. It starts
with:
https://gnucash-docs-rst.readthedocs.io/en/latest/guide/C/ch_basics.html#putting-it-all-together

> that isn't the latest, nor official documentation.

No, it's not but it is the version I recommend. Feedback on how it compares
with the official version would be useful.

Two farm-related use issues for me are no automatic sales tax calculations
for cash accounting (only business features with accrual accounting) and no
classification on transactions (eg classify your vehicle expenses for lamb
and tourism enterprises then report by classification). There are
workarounds.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] farm

[James Baxter via gnucash-user]

Miss Ann.I am a Gnucash user. I use it to keep up with my check book and 
others.  But I don't need to get away from Gnucash. 
There is Quick Books out there. I don't know if Gnucash will help you. There 
are alot of things that go into farming. As I am looking to get to that point.  
As like you. I have not seen it for Quick books.
You have Pay roll, If you grown hay and sell it. then you have payroll.   I am 
looking at that. so I don't know if I help you or not.
Good LuckJames BaxterGnucash user 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting Reports to CSV

[Adrien Monteleone]

For completeness,

Once you have the report in the spreadsheet app of choice, you can then 
save/export from there as CSV if that format is otherwise still needed.


Regards,
Adrien

On 1/23/23 11:32 AM, Phyllis Bruce wrote:

Oops, never mind.  Found good instructions on Chrome.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions about setting up new accounts from brand new user

[Adrien Monteleone]

Ann, that isn't the latest, nor official documentation.

For that, see https://gnucash.org/docs.phtml (the Documentation link 
from the left-hand menu under either Downloads or Support)


There is the 'Help' and the 'Tutorial & Concepts Guide'.

Both should be accessible from the Help menu when running GnuCash as well.

-
*The Read the Docs version was created 3 years ago as a proof of concept 
for a different formatting and delivery means for the documentation but 
was not necessarily intended as 'ready for public consumption'. It has 
not been adopted for official use by the developers as of yet, and is 
not maintained or kept up to date. (and appears to be quite incomplete 
as well)


-
If you read the official documentation, it describes an Account creation 
wizard that helps you get the basic accounts set up to get you started. 
If it did not run initially for some reason, you can proceed without it 
and individually create accounts, or try starting a new file to see if 
it will trigger the wizard. If it does not, report back here and we can 
help.



Regards,
Adrien

On 1/23/23 11:10 AM, Ann Bowes wrote:

Hi folks,

I'm trying to set up a simple manual checking account for a small farm 
business.  I've down-loaded the gnucash program to my laptop (linux 
zorin OS), and have tried to open new accounts, but am completely 
stumped as to how to do this.  I've read through the tutorial (at 
https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm 
still stumped  Can anyone give me some pointers?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions about setting up new accounts from brand new user

[David Carlson]

Maf showed you how to start to create a single account.

If you want to create an entire chart of accounts click File > New and
select the option to create New Account Hierarchy Setup
You might want to try this more than once because it will then give you a
lot of choices for different applications and you may be a little
overwhelmed the first time around.

On Mon, Jan 23, 2023 at 11:29 AM Maf. King  wrote:

> On Monday, 23 January 2023 17:10:51 GMT Ann Bowes wrote:
> > Hi folks,
> >
> > I'm trying to set up a simple manual checking account for a small farm
> > business.  I've down-loaded the gnucash program to my laptop (linux
> > zorin OS), and have tried to open new accounts, but am completely
> > stumped as to how to do this.  I've read through the tutorial (at
> > https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm
> > still stumped  Can anyone give me some pointers?
> >
>
> Hi Ann,
>
> you mean you need to create an account in your Gnucash books?
>
> see the attached image for a pointer...
>
> 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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting Reports to CSV

[Phyllis Bruce]

Oops, never mind.  Found good instructions on Chrome.

On Mon, Jan 23, 2023 at 11:26 AM Phyllis Bruce  wrote:

> Thanks Maf.  Do I assume a comma delimiter or what?  I'm familiar with
> importing delimited files into excel.
>
> On Mon, Jan 23, 2023 at 10:54 AM Maf. King  wrote:
>
>>
>>
>> On Monday, 23 January 2023 16:35:21 GMT Phyllis Bruce wrote:
>> > I found out how to export transactions, but how can I export my Tax
>> report
>> > as CSV?  My only options are HTML or TXF, neither allow me to reformat
>> in
>> > Excel.
>> >
>>
>> LibreOffice calc can work on the HTML export; I imagine that excel is
>> able to do
>> the same?
>>
>> 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
>> -
>> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting Reports to CSV

[Dan Black]

Copy and paste into Excel is also an option.

Dan


On January 23, 2023 12:26:49 PM Phyllis Bruce  wrote:


Thanks Maf.  Do I assume a comma delimiter or what?  I'm familiar with
importing delimited files into excel.

On Mon, Jan 23, 2023 at 10:54 AM Maf. King  wrote:




On Monday, 23 January 2023 16:35:21 GMT Phyllis Bruce wrote:
> I found out how to export transactions, but how can I export my Tax
report
> as CSV?  My only options are HTML or TXF, neither allow me to reformat in
> Excel.
>

LibreOffice calc can work on the HTML export; I imagine that excel is able
to do
the same?

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
-
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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions about setting up new accounts from brand new user

[Maf. King]

On Monday, 23 January 2023 17:10:51 GMT Ann Bowes wrote:
> Hi folks,
> 
> I'm trying to set up a simple manual checking account for a small farm
> business.  I've down-loaded the gnucash program to my laptop (linux
> zorin OS), and have tried to open new accounts, but am completely
> stumped as to how to do this.  I've read through the tutorial (at
> https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm
> still stumped  Can anyone give me some pointers?
> 

Hi Ann,

you mean you need to create an account in your Gnucash books?

see the attached image for a pointer...

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting Reports to CSV

[Phyllis Bruce]

Thanks Maf.  Do I assume a comma delimiter or what?  I'm familiar with
importing delimited files into excel.

On Mon, Jan 23, 2023 at 10:54 AM Maf. King  wrote:

>
>
> On Monday, 23 January 2023 16:35:21 GMT Phyllis Bruce wrote:
> > I found out how to export transactions, but how can I export my Tax
> report
> > as CSV?  My only options are HTML or TXF, neither allow me to reformat in
> > Excel.
> >
>
> LibreOffice calc can work on the HTML export; I imagine that excel is able
> to do
> the same?
>
> 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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Questions about setting up new accounts from brand new user

[Ann Bowes]

Hi folks,

I'm trying to set up a simple manual checking account for a small farm 
business.  I've down-loaded the gnucash program to my laptop (linux 
zorin OS), and have tried to open new accounts, but am completely 
stumped as to how to do this.  I've read through the tutorial (at 
https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm 
still stumped  Can anyone give me some pointers?


Much thanks,

Ann

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting Reports to CSV

[Maf. King]

On Monday, 23 January 2023 16:35:21 GMT Phyllis Bruce wrote:
> I found out how to export transactions, but how can I export my Tax report
> as CSV?  My only options are HTML or TXF, neither allow me to reformat in
> Excel.
> 

LibreOffice calc can work on the HTML export; I imagine that excel is able to 
do 
the same?

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Exporting Reports to CSV

[Phyllis Bruce]

I found out how to export transactions, but how can I export my Tax report
as CSV?  My only options are HTML or TXF, neither allow me to reformat in
Excel.

Thanks, Pobruce
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] exporting from gnucash to Excel

[Maf. King]

Just a thought - can you mangle the VAT spreadsheet to sum the CSV exported 
box 1 and box 6 (nett) figures to give you a grossed-up number?

Maf.



On Thursday, 19 January 2023 17:20:31 GMT you wrote:
>  How could I organise my accounts such that I can pull my total sales
> including VAT into the Box 6 total in the Income and GST Statement? At
> present my sales go to one account and the VAT charged goes to another. But
> VAT is paid from this latter account to HMRC so the balance of the account
> in a quarter does not equal the total VAT received / charged.
> 
> On Sunday, 15 January 2023 at 19:39:36 GMT+3, Maf. King
>  wrote:
>  On Sunday, 15 January 2023 16:30:38 GMT Paul W wrote:
> >  Thanks Maf. That seems like a neat solution. I'm almost there.
> >
> > Because I'm on the Flat Rate Scheme my Box 6 figure needs to be the total
> > of sales including VAT but apart from my Accounts Receivable which goes
> > to zero once the invoice is paid I don't see how to get that figure from
> > anywhere. I mean my Income:Sales figure does not include the tax - that
> > goes separately to my ouput VAT liability account (which I use to
> > populate Box1).
> > 
> > By the way I'm using 100pc VAT Free Bridge to read a spreadsheet and send
> > the figures to HMRC.It is free and has worked well.
> 
> I've heard of but never looked at the flat rate scheme, so I can't really
> offer any words on it.
> 
> but if you invoice for £100 + VAT, are you saying that Box1= 20 and box 6 =
> 120?
> 
> thanks for the tip on the VAT Bridge Free will investigate it before I
> do my return later in the month!
> 
> regards,
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Getting OFX files via the command line: (was: Re: Morgan Stanley Portfolio)

[Ed Greenberg]

This was a great success.   I'll embellish a bit for the sake of others.

1. Install ofxtools.  For Windows, you may need python. For Mac and 
Linux, it's probably there.


Go to  https://ofxtools.readthedocs.io/en/latest/index.html to get the 
documentation, which includes an "Installing" section.


2. Find your bank.   do an 'ofxget list'  command.  You'll get a text 
table of institutions, each with a number.


Steve Brown pointed to a URL below, 
https://www.ofxhome.com/index.php/institution/view/500


where 500 is the number in 'ofxget list' output

3. Following the instructions under 'Using ofxget' do something like 
ofxget acctinfo ... and then ofxget stmt.


I was able to download an OFX from Morgan Stanley of my entire year's 
transaction history.


Thanks for the pointer, Steve.

Ed

On 1/22/2023 8:35:32 AM, Steve Brown wrote:

Morgan Stanley is running an OFX server. I'd see if I could get online
banking to connect with it and download that.

I haven't tried it as I don't have an account there, but I think all
the info you need to set it up is here:

https://www.ofxhome.com/index.php/institution/view/500

I was able to download the profile with ofxget from ofxtools and it
promises to support investments.

Good luck,

Steve


On Sun, 2023-01-22 at 06:29 -0500, Ed Greenberg wrote:

I have a portfolio at Morgan Stanley which generates some dividends,
income, cap gains distribution, etc. All sorts of odd transactions.
MS
does not offer a QFX/OFX, but only an excel download which is
inadequate
for import. Near as I can tell.

Does anybody have suggestions for interacting with Morgan Stanley?

I'm considering writing a transformation program that will read the
csv
and rewrite it in a more importable set of csv columns. Or just
biting
the bullet and keying it all in manually.

On the other hand, what procedures have people developed to track
just
the asset value of the entire portfolio and update it each month?

Thanks,

Ed Greenberg


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF upload ends abruptly at import step, last message "Transaction with no or only one associated account"

[davidbrown.rdps]

A quick question regards "Save As"   I find that there is quite a delay
in the SaveAs dialog box appearing and the main window shows "Not
Responding".  Is that a normal delay all users find?

Regards

David


-- 
This email has been checked for viruses by AVG antivirus software.
www.avg.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.