Re: [GNC] Data storage location for GnuCash 4.12

[fliegersonic.net]

Hi Jim from The Other Jim

Looks like I have to eat a bit of crow.  I did read that earlier but somehow 
when looking at the 'save as' menu item I 
managed to interpret it as being a tool to 'save as' individual accounts, not 
the entire database.  I'll give that a shot 
tomorrow morning and offer my thanks and a 'duh' with the presumption it will 
fix my issue if not my thinking.

A mind is a terrible thing to lose...

Much appreciated!!
Jim2

On 6 Oct 2022 at 17:23, Jim DeLaHunt wrote:

> Hello, Jim, this is Jim.
> 
> On 2022-10-06 16:36, fliegersonic.net wrote:
> > I just updated from 3.8 to 4.12  In the process, the install
> > indicated it would delete the existing GnuCash - which is ok as I
> > had full backups.  After the install, the data is being stored in
> > the same directory into which I downloaded the installer, not to the
> > directory indicated in the About dialog or the directory which was
> > used by the previous version.  I have been unable to change the data
> > storage directory and have even been unable to locate it in the
> > registry (using Win 8.1).
> >
> > How do I change the data directory to my preferred location?
> 
> Congratulations on your upgrade.
> 
> In order to change the data directory to your preferred location, this
> might be the time to give the GnuCash Guide documentation another
> read. Particularly section 2.4 *Storing your financial data*
> .
> 
> You will want to open the data file you were using with the previous
> version of GnuCash, from the new version of GnuCash, from the GnuCash
> menubar, choosing *File* -> *Open*. Then save the data file to the
> location you prefer, using *File* -> *Save As*.
> 
> > TIA
> > Jim
> 
> I hope this helps,
>   -Jim DeLaHunt
> 
> ___
> 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] CoGS on Income Statement

[Jared Squires]

I'm trying to find a way to implement the Cost of Goods Sold in the Income
Statement.  Right now I have it as it's own Expense Top Level Account but
it messes up my Income Statement for my actual Gross Profit.  I tried to
make CoGS as an "Income" but then when I enter bills from vendors, I can't
label the line item on the bill.  My current tree structure is like this:

Assets
-> Current Assets
->->General Checking
->Furniture and Equipment
->A/R
Income
->Fees and Revenue
CoGS
->Government Fees
->Search Fees
Expenses
Liabilities
Equity

I did a bunch of searches but didn't see anything since about 2015, and
nothing discussing how to get it to appear correctly on the Income
Statement.

Sincerely,
Jared Squires
___
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] Orphan- and Imbalance- splits created on stock transaction when closing & reopening GnuCash data file

[john]

I can reproduce this with your sample file, and I discovered another facet: If 
one does a File>Save As, either to XML or SQlite3, the new file doesn't exhibit 
the behavior.
I also found that if I remove the extra splits in the original file they don't 
come back. It's not a last-transaction issue, either: If one creates two 
transactions in a session they'll both get the Orphan and Imbalance splits 
created.

I''l try watching the program load in the debugger next.

Regards,
John Ralls

> On Oct 5, 2022, at 9:33 PM, Chris Grinton  wrote:
> 
> Good spotting on the share balance difference! I hadn't intended that in the 
> screenshots; it was just a side effect of me playing around trying to get it 
> to work between the first and 2nd screenshot - I had added some other 
> transactions for testing that did adjust the share balance.
> 
> Selecting "Edit Exchange Rate" on the CapitalLosses:CurrentYear:Realized 
> split in the CapitalLosses:CurrentYear:Realized account register shows an 
> error: "The two currencies involved equal each other".
> 
> I can reproduce the problem by creating a brand new (empty) GnuCash file and 
> then following the steps I described, and using only a single currency in 
> that file. So I don't think a multi-currency factor is at play here.
> 
> If it helps and I've inspired anybody to dig deeper, I've shared a .gnucash 
> file at https://app.box.com/s/xdrru5yr8gjm3r7ovatmsn92jcvme053 that can be 
> used to reproduce: simply create a new buy or sell transaction involving the 
> ACME security in the Assets:ACME Corp account, and new Orphan & Imbalance 
> splits will be created in your transaction the next time the file is opened.
> 
> Chris
> 
> On Thu, 6 Oct 2022 at 11:59, john  > wrote:
>> That looks like a proper cap gains transaction. It's odd that the share 
>> balance differs by 250 between the two screenshots: Is there some other 
>> transaction that might be affecting things?
>> 
>> The next thought is that there might be a non-AUD transaction currency 
>> involved. If you open the transaction in the 
>> CapitalLosses:CurrentYear:Realized account register, right-click on the 
>> split for that account, and select "Edit Exchange Rate" does it open the 
>> transfer dialog or pop an error box? If the former, what is the non-AUD 
>> currency/commodity it wants to price; if the latter,
>> what's the error?
>> 
>> Regards,
>> John Ralls
>> 
>> > On Oct 5, 2022, at 7:33 PM, Chris Grinton > > > wrote:
>> > 
>> > Good thought - but the problem still occurs even if the share count and
>> > price are non-0. (The example transaction I've described is a simple
>> > reduction in the cost base of the asset without changing the number of
>> > shares held. But I think that is not directly relevant to the problem and
>> > probably the example I described more complex than it needed to be.)
>> > 
>> > Chris
>> > 
>> > 
>> > On Thu, 6 Oct 2022 at 09:45, R Losey > > > wrote:
>> > 
>> >> Perhaps I'm missing something, but if there is a transaction that has a
>> >> cost of 5000, and you have shares with a price of 0, that may be causing 
>> >> it
>> >> to think there is an imbalance, and thus the transactions get added?
>> >> 
>> >> On Wed, Oct 5, 2022 at 7:09 AM Chris Grinton > >> > wrote:
>> >> 
>> >>> Hi GnuCashers,
>> >>> 
>> >>> I have a strange situation where a transaction is automagically (and
>> >>> unexpectedly) getting splits added to it against the "Orphan-"
>> >>> and "Imbalance-" accounts when my GnuCash data file is closed
>> >>> and
>> >>> reopened. I can't work out why these splits are getting added, and would
>> >>> love any insights that people might have on how to stop it from 
>> >>> happening.
>> >>> 
>> >>> The unexpected behavior here appears to be somehow related to having
>> >>> trading accounts enabled, and a consequence of changing the namespace of 
>> >>> a
>> >>> security.
>> >>> 
>> >>> Here are steps I do to reproduce this problem:
>> >>> 
>> >>> 1. Create a transaction as follows:
>> >>>Expenses:Realised capital losses DR 5000
>> >>>Assets:Stock account CR
>> >>> 5000 (with shares & price = 0)
>> >>> 
>> >>> This appears in GnuCash as per the following screenshot:
>> >>> 
>> >>> [image: image.png]
>> >>> 
>> >>> No change occurs to this transaction as long as I keep the GnuCash file
>> >>> open.
>> >>> 
>> >>> 2. Edit the UNLISTED:ACME security, and change its namespace. For 
>> >>> example,
>> >>> change the namespace from "UNLISTED" to "UNLISTED2".
>> >>> 
>> >>> 3. Open a different GnuCash file (or close GnuCash), and then open the
>> >>> original file again. The act of opening the file appears to cause the
>> >>> transaction to be updated with additional splits to read as follows:
>> >>> 
>> >>>Expenses:Realised capital losses DR 5000
>> >>> *Orphan-AUD

Re: [GNC] CSV transaction import settings

[Geoff]

Hi David

On Windows 10**, there is a directory called:

C:\Users\{YOUR_NAME}\AppData\Roaming\GnuCash\books\

Which contains a file for each set of books called:

{BOOK_NAME}.gnucash.gcm

In that file, there are, inter alia, sections for your saved CSV Import 
configurations that look like this:


[Import csv,transaction - {BLAH BLAH}]
Name={BLAH BLAH}
SkipStartLines=1
SkipEndLines=0
SkipAltLines=false
CsvFormat=true
Separators=,
DateFormat=1
CurrencyFormat=0
Encoding=UTF-8
MultiSplit=true
ColumnTypes=Date;Num;Description;Transaction 
Commodity;Action;Account;Deposit;Price;



** So, on Linux you will need to find that file using something like this:

sudo find / -name {BOOK_NAME}.gnucash.gcm -print


Hope this helps.

Regards

Geoff
=

On 7/10/2022 12:49 am, David Carlson wrote:

Where are the settings stored?  I thought I copied all the GnuCash stuff
from one computer to another Ubuntu machine.  I got my memorized reports
but not the CSV Transactions import settings.


___
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] CSV transaction import settings

[fliegersonic.net]

Ack - newbie screwup.  Please disregard my last.  Sigh.
Ji

On 7 Oct 2022 at 8:04, Christopher Lam wrote:

> In release 4.12 - try Help > About
> 
> On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
> > David,
> >
> > It looks like you want the chart here:
> >
> > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux
> >
> > 1. /home//.local/share/gnucash
> > 2. /home//.local/share/gtk-3.0
> > 3. /home//.config/gnucash
> > 4. /home//.config/gtk-3.0
> >
> > One of those four directories should have the file you are looking
> > for.
> >
> > Based on the expected files listed in that chart, I'd hazard that
> > either
> > #1 or #3 is the proper location.
> >
> > Regards,
> > Adrien
> >
> > On 10/6/22 3:16 PM, David Carlson wrote:
> > > I went through that part of the FAQ  and I got lost with locations
> > >  and paths and relative paths but no hard filename to search for
> > > with my filemanager. If it is there I gave up in frustration
> > > before I found it.
> >
> >
> > ___
> > 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] CSV transaction import settings

[fliegersonic.net]

Thank you, I did (I actually read the faq before calling for help).  The data 
is not going to the location shown in 
'About', it's going to the directory from which the installer was run.  Very 
puzzling.  Thre were a couple of entries in 
the registry which had a '/' (forward slash) in the path - not a convention 
windoze uses.

Appreciated!
Jim

On 7 Oct 2022 at 8:04, Christopher Lam wrote:

> In release 4.12 - try Help > About
> 
> On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
> > David,
> >
> > It looks like you want the chart here:
> >
> > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux
> >
> > 1. /home//.local/share/gnucash
> > 2. /home//.local/share/gtk-3.0
> > 3. /home//.config/gnucash
> > 4. /home//.config/gtk-3.0
> >
> > One of those four directories should have the file you are looking
> > for.
> >
> > Based on the expected files listed in that chart, I'd hazard that
> > either
> > #1 or #3 is the proper location.
> >
> > Regards,
> > Adrien
> >
> > On 10/6/22 3:16 PM, David Carlson wrote:
> > > I went through that part of the FAQ  and I got lost with locations
> > >  and paths and relative paths but no hard filename to search for
> > > with my filemanager. If it is there I gave up in frustration
> > > before I found it.
> >
> >
> > ___
> > 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] Data storage location for GnuCash 4.12

[Jim DeLaHunt]

Hello, Jim, this is Jim.

On 2022-10-06 16:36, fliegersonic.net wrote:

I just updated from 3.8 to 4.12  In the process, the install indicated it would 
delete the existing GnuCash - which is
ok as I had full backups.  After the install, the data is being stored in the 
same directory into which I downloaded
the installer, not to the directory indicated in the About dialog or the 
directory which was used by the previous
version.  I have been unable to change the data storage directory and have even 
been unable to locate it in the
registry (using Win 8.1).

How do I change the data directory to my preferred location?


Congratulations on your upgrade.

In order to change the data directory to your preferred location, this 
might be the time to give the GnuCash Guide documentation another read. 
Particularly section 2.4 *Storing your financial data* 
.


You will want to open the data file you were using with the previous 
version of GnuCash, from the new version of GnuCash, from the GnuCash 
menubar, choosing *File* -> *Open*. Then save the data file to the 
location you prefer, using *File* -> *Save As*.



TIA
Jim


I hope this helps,
 —Jim DeLaHunt

___
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] CSV transaction import settings

[Christopher Lam]

In release 4.12 - try Help > About

On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> David,
>
> It looks like you want the chart here:
>
> https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux
>
> 1. /home//.local/share/gnucash
> 2. /home//.local/share/gtk-3.0
> 3. /home//.config/gnucash
> 4. /home//.config/gtk-3.0
>
> One of those four directories should have the file you are looking for.
>
> Based on the expected files listed in that chart, I'd hazard that either
> #1 or #3 is the proper location.
>
> Regards,
> Adrien
>
> On 10/6/22 3:16 PM, David Carlson wrote:
> > I went through that part of the FAQ  and I got lost with locations  and
> > paths and relative paths but no hard filename to search for with my
> > filemanager. If it is there I gave up in frustration before I found it.
>
>
> ___
> 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] Data storage location for GnuCash 4.12

[fliegersonic.net]

I just updated from 3.8 to 4.12  In the process, the install indicated it would 
delete the existing GnuCash - which is 
ok as I had full backups.  After the install, the data is being stored in the 
same directory into which I downloaded 
the installer, not to the directory indicated in the About dialog or the 
directory which was used by the previous 
version.  I have been unable to change the data storage directory and have even 
been unable to locate it in the 
registry (using Win 8.1).  

How do I change the data directory to my preferred location?

TIA
Jim
___
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] Gnucash invoicing and payment - questions on process

[Adrien Monteleone]

On 10/6/22 1:59 PM, Charles Vincent wrote:

Hello Gnucash users list members,
I come back on the issue of invoicing clients and payment by the clients or
a third party.

As background:
For info, I am keeping the accounts for a small not for profit school in
Cambodia.
I have done the 70 invoices, one for each child, using a standard
accounting layout: R1 income school fees, R2 income registration, R3 income
extracurricular, etc etc..
So far so good.
I post the invoices, still good.
The invoices show up in  an accounts receivable STUDENT INVOICES as I
believe they should. If so, so far so very good.


Just to be clear - GnuCash can have *only 1* account of 'type' Accounts 
Receivable (same for Payables) and that is the account used by the 
Business Features. (invoicing, payments, customers, vendors, etc.)


I don't know if you can rename that account.

You *might* be able to keep the default, and create another, but you'd 
have to change the default account's type to generic the Asset type.


You can have all the AR accounts you want, even as sub-accounts of the 
original default AR account, but there can be only 1 of 'type' 
A/Receivable. I don't think the other accounts are 'seen' by the 
business features but I could be mistaken.


If this is not your setup, you may run into problems.


The problem comes up with the management of the accounts when I receive
funds
I have two cases which are giving me problems related to the income that we
receive for which I am consulting this group:

Case 1:  The parents have anticipated some expenses from trimester 2 and 3
and hence have paid more than the posted invoice. Let us say the invoice is
for USD 2,000 and the payment received in the bank is USD 2,500.
When I use the payment option, I do not see the 500 extra payment when I
print the invoice (which I would consider by this time as a Statement of
Account)
Advice appreciated on how to enter the amount and that the printed invoice
shows the overpayment.


The closest thing GnuCash has to a 'Statement of Account' is the 
"Customer Report". (and "Vendor Report" for you for Payables)


You can run this directly, having to choose a customer/vendor each time, 
but I prefer to always keep a Receivables & Payables Aging Report tabs 
open at all times, then simply clicking the *amount* owed by/to each 
entity will run their report.


You will see all invoices and payments there.

With Options > Display Columns > Transaction Links you can see which 
payments apply to which invoices and vice versa.


You can also see payments on a particular Invoice Report by selecting 
Options > Display > Payments.


As for entering the payment - use the Process Payment function. (in the 
menu, or the toolbar button)


Select the invoice to which you want to apply the payment.

The extra will exist in the AR account linked to that 'customer' as a 
'pre-payment'


A subsequent Process Payment will show the pre-payment in the documents 
pane. When you are ready to apply it on a future invoice, simply select 
both the pre-payment and the invoice document to offset each other. If 
pre-payment remains still, it will show up as still existing but with 
the new balance. If it is fully used up for the exact amount of the 
invoice, both will be cleared. If the invoice still has a balance, you 
can also enter that amount paid, or else it will show as that amount 
only, still pending.


Case 2:  We received in the bank a donation of say USD 8,000 on say 1
September from a donor for a scholarship fund for 4 students.  I have
therefore credited the bank account on 1 Septemberr for 8,000$ and credited
the income account of the donor (let's call it R7) for the amount of
$8,000.
The issue becomes how I credit the 4 invoices which are dated 15 September
for the students as the funds are a. in the bank, b. credited to the income
account R7.  I could not "pay" the invoice from the R7 account (not
possible in the Gnucash setup it seems) so that the various amounts flow to
the various Rs, R1, R2, R3,... .  as per the invoice set up.  From my
perspective it is more of a Journal Voucher type transaction, moving funds
from R7 to R1, R2, R3,... so that the proper amounts are credited to the
proper income accounts, reducing the amount under R7, i.e. allocating the
donors funds to various activities.
I tried various ways but the PAY option in the invoice does not work.  Any
suggestions?


This might be a bit tricky, and there are likely several ways you can 
handle it.


First, I'd receive the donation between the payment method (Undeposited 
Funds most likely if in either the form of a check or pending credit 
card transaction, or the Bank Account if by ACH or other direct means) 
and a Liability:Donations account. (or whatever you'd like to name it, 
possibly with a separate account for each donor)


As you need to use those funds to pay invoices, Process Payment between 
that Donor account and AR using the beneficiary Student as the customer 
and apply it to the 

Re: [GNC] CSV transaction import settings

[David Carlson]

I didn't find that diagram. Thanks.  Maybe what I want is under

USER_CONFIG_HOME


On Thu, Oct 6, 2022 at 4:27 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> David,
>
> It looks like you want the chart here:
>
> https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux
>
> 1. /home//.local/share/gnucash
> 2. /home//.local/share/gtk-3.0
> 3. /home//.config/gnucash
> 4. /home//.config/gtk-3.0
>
> One of those four directories should have the file you are looking for.
>
> Based on the expected files listed in that chart, I'd hazard that either
> #1 or #3 is the proper location.
>
> Regards,
> Adrien
>
> On 10/6/22 3:16 PM, David Carlson wrote:
> > I went through that part of the FAQ  and I got lost with locations  and
> > paths and relative paths but no hard filename to search for with my
> > filemanager. If it is there I gave up in frustration before I found it.
>
>
> ___
> 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] Import Map Editor

[Liz Dodd]

On Thu, 6 Oct 2022 14:28:21 -0700
Jim DeLaHunt  wrote:

> On 2022-10-06 05:58, Carl S. wrote:
> 
> > I'm curious about the Import Map Editor and what it's for.  
> 
> Have you read the documentation about it, at 
> ,
>  
> yet?
> 
> 
> > It does say I've got something like 300 invalid mapping and asks if
> > I want to delete them.
> >
> > No idea what to do with itand certainly don't want to create a 
> > disaster.
> >  
> The documentation does not describe that message. Perhaps post a 
> screenshot of the message?  Does the dialogue indicate which entries
> are "invalid"?  Can you post a screenshot of those entries?
> 
> 
> > Thanks,
> >
> > Carl  
> Good luck,
>      —Jim DeLaHunt


May I suggest you make a copy of your file and experiment with the
copy? That would make a disaster less likely.

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

Re: [GNC] Import Map Editor

[Jim DeLaHunt]

On 2022-10-06 05:58, Carl S. wrote:


I'm curious about the Import Map Editor and what it's for.


Have you read the documentation about it, at 
, 
yet?



It does say I've got something like 300 invalid mapping and asks if I 
want to delete them.


No idea what to do with itand certainly don't want to create a 
disaster.


The documentation does not describe that message. Perhaps post a 
screenshot of the message?  Does the dialogue indicate which entries are 
"invalid"?  Can you post a screenshot of those entries?




Thanks,

Carl

Good luck,
    —Jim DeLaHunt

___
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] CSV transaction import settings

[Adrien Monteleone]

David,

It looks like you want the chart here:

https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux

1. /home//.local/share/gnucash
2. /home//.local/share/gtk-3.0
3. /home//.config/gnucash
4. /home//.config/gtk-3.0

One of those four directories should have the file you are looking for.

Based on the expected files listed in that chart, I'd hazard that either 
#1 or #3 is the proper location.


Regards,
Adrien

On 10/6/22 3:16 PM, David Carlson wrote:

I went through that part of the FAQ  and I got lost with locations  and
paths and relative paths but no hard filename to search for with my
filemanager. If it is there I gave up in frustration before I found it.



___
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] Chase OFXdirect connect - another one bites the dust

[Kalpesh Patel]

I wonder if OFX will die by thousand cuts. Slowly but surely large financial 
orgs are restricting direct retrieval of OFX formatted data or outright 
abandoning it.  

Web browser is a tool to just do that ... albeit not an efficient one for that 
specific purpose .

I was utilizing very old tool called PocketSense to do that but the population 
where it can be effective in downloading OFX is dwindling.   

--

Message: 4
Date: Thu, 6 Oct 2022 10:16:00 -0700
From: Glenn Serre 
To: Jean Laroche 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Chase OFXdirect connect - another one bites the
dust
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Good morning,

On Thu, Oct 6, 2022 at 9:53 AM Jean Laroche  wrote:
>
> Any of you know whether something else is in the works to replace direct
> connect? Manual downloading can be a pain when you have many accounts in
> different institutions...

I have the same issue.  I had some success searching out the new
settings for Bank of the West, but if ofx direct connect is going
away, maybe a different strategy is needed.  I was thinking maybe a
tool to extract ofx/qfx downloads from the various bank websites? I
haven't found an existing one.

-- Glenn S.

>
> J.
>
> On 10/6/22 9:46 AM, David Reiser via gnucash-user wrote:
> > As of today, aqbanking reports that ?ofx.chase.com? 
> > is an unknown host. Banktivity reports that today is the start of Chase 
> > enforcing data access only through Open Banking APIs.
> >
> > OFX data format transaction downloads are still available from the Chase 
> > online web accounts ? manual download followed by File>Import>Import 
> > OFX/QFX? in Gnucash.
> > --
> > Dave Reiser
> > dbrei...@icloud.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.

Re: [GNC] CSV transaction import settings

[David Carlson]

I went through that part of the FAQ  and I got lost with locations  and
paths and relative paths but no hard filename to search for with my
filemanager. If it is there I gave up in frustration before I found it.

On Thu, Oct 6, 2022 at 1:08 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> David,
>
> The Wiki FAQ has a section on file locations. I don't have the exact
> answer off-hand, but I'm sure one of those locations has what you are
> looking for. (allegedly, there are no other places used by GnuCash)
>
> Regards,
> Adrien
>
> On 10/6/22 8:49 AM, David Carlson wrote:
> > Where are the settings stored?  I thought I copied all the GnuCash stuff
> > from one computer to another Ubuntu machine.  I got my memorized reports
> > but not the CSV Transactions import settings.
> >
>
>
> ___
> 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] Chase OFXdirect connect - another one bites the dust

[Gyle McCollam]

I stopped using aqbanking because only a handful of my financial intuitions 
seemed to work with aqbanking.  I also didn't like that my password information 
was stored in gnucash.  I know you can elect not to store, but that renders it 
less useful.  I have chosen to download from each of my institutions manually.  
I was sadden to see that Discover stopped offering QFX/OFX downloads.  
Hopefully, the others will not follow suit.  As long as they offer CSV, it 
should be OK.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Glenn Serre 
Sent: Thursday, October 6, 2022 1:16 PM
To: Jean Laroche 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Chase OFXdirect connect - another one bites the dust

Good morning,

On Thu, Oct 6, 2022 at 9:53 AM Jean Laroche  wrote:
>
> Any of you know whether something else is in the works to replace direct
> connect? Manual downloading can be a pain when you have many accounts in
> different institutions...

I have the same issue.  I had some success searching out the new
settings for Bank of the West, but if ofx direct connect is going
away, maybe a different strategy is needed.  I was thinking maybe a
tool to extract ofx/qfx downloads from the various bank websites? I
haven't found an existing one.

-- Glenn S.

>
> J.
>
> On 10/6/22 9:46 AM, David Reiser via gnucash-user wrote:
> > As of today, aqbanking reports that “ofx.chase.com” 
> > is an unknown host. Banktivity reports that today is the start of Chase 
> > enforcing data access only through Open Banking APIs.
> >
> > OFX data format transaction downloads are still available from the Chase 
> > online web accounts — manual download followed by File>Import>Import 
> > OFX/QFX… in Gnucash.
> > --
> > Dave Reiser
> > dbrei...@icloud.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.
> ___
> 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] Gnucash invoicing and payment - questions on process

[Charles Vincent]

Hello Gnucash users list members,
I come back on the issue of invoicing clients and payment by the clients or
a third party.

As background:
For info, I am keeping the accounts for a small not for profit school in
Cambodia.
I have done the 70 invoices, one for each child, using a standard
accounting layout: R1 income school fees, R2 income registration, R3 income
extracurricular, etc etc..
So far so good.
I post the invoices, still good.
The invoices show up in  an accounts receivable STUDENT INVOICES as I
believe they should. If so, so far so very good.

The problem comes up with the management of the accounts when I receive
funds
I have two cases which are giving me problems related to the income that we
receive for which I am consulting this group:

Case 1:  The parents have anticipated some expenses from trimester 2 and 3
and hence have paid more than the posted invoice. Let us say the invoice is
for USD 2,000 and the payment received in the bank is USD 2,500.
When I use the payment option, I do not see the 500 extra payment when I
print the invoice (which I would consider by this time as a Statement of
Account)
Advice appreciated on how to enter the amount and that the printed invoice
shows the overpayment.

Case 2:  We received in the bank a donation of say USD 8,000 on say 1
September from a donor for a scholarship fund for 4 students.  I have
therefore credited the bank account on 1 Septemberr for 8,000$ and credited
the income account of the donor (let's call it R7) for the amount of
$8,000.
The issue becomes how I credit the 4 invoices which are dated 15 September
for the students as the funds are a. in the bank, b. credited to the income
account R7.  I could not "pay" the invoice from the R7 account (not
possible in the Gnucash setup it seems) so that the various amounts flow to
the various Rs, R1, R2, R3,... .  as per the invoice set up.  From my
perspective it is more of a Journal Voucher type transaction, moving funds
from R7 to R1, R2, R3,... so that the proper amounts are credited to the
proper income accounts, reducing the amount under R7, i.e. allocating the
donors funds to various activities.
I tried various ways but the PAY option in the invoice does not work.  Any
suggestions?

Thank you


*Charles Vincent*

Trésorier et ancien président du Conseil d'Administration

EFB - Ecole *Française* de Battambang

www.ecolefrancaisedebattambang.org


Tel:  +33 6 7082 0475

+855 12 635612 (Telegram)
___
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] Troubleshooting and/or database repair

[Adrien Monteleone]

Glad to hear you don't need to reinstall the entire system!

Now, to troubleshoot the OneDrive problem...

I don't use it, so sorry if I can't be of further help, but I'm sure 
others here on the list do and might be able to assist.


Search the list archives for 'OneDrive' and you might find some threads 
that could shed light on the issue.


Regards,
Adrien

On 10/6/22 1:51 PM, Jim Kolodziej wrote:

Okay based on your question I copied the database to a thumb drive (was on
OneDrive). Problem disappeared.



___
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] Troubleshooting and/or database repair

[Jim Kolodziej]

Okay based on your question I copied the database to a thumb drive (was on
OneDrive). Problem disappeared.

Thanks.


On Thu, Oct 6, 2022 at 2:18 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> If you try to add a transaction with a split to a non-existent account,
> do you get the option to create that account?
>
> If so, and you choose to create it, does the new-account window show up?
>
> And one additional 'environment' question:
>
> Is this a local file, or stored on an external/network/cloud drive? (and
> if 'cloud' is this via Dropbox or some other service? or your own direct
> connection with no intervening apps?)
>
> Regards,
> Adrien
>
> On 10/5/22 5:51 PM, Jim Kolodziej wrote:
> > No I can add transactions to existing accounts etc but can’t add a new
> > account or edit an existing account
>
>
> ___
> 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] HELP!!! How to purge everything from my windows pc before attempting a new re-install

[Murugan Muruganandam]

gnucash stores the file location in a registry
Computer\HKEY_CURRENT_USER\Software\GSettings\org\gnucash\GnuCash\history




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
jmy...@gmail.com 
Sent: Thursday, October 6, 2022 11:31 AM
To: gnucash-user@gnucash.org 
Subject: [GNC] HELP!!! How to purge everything from my windows pc before 
attempting a new re-install

Somehow my gnucash is behaving very badly. a lot of the functionality from
the main menu does not work.  For example, if I select export the account
tree - nothing happens.

If I selected add an account or edit an account nothing happens.



I tried to uninstall and reinstall everything I could think of.  I did a
search throughout my file system for any gnu-related files and removed them
etc.  then did a re-install.



I was surprised that gnucash actually remembered my recent files that were
open, so I must be missing something when I tried to delete gnucash from my
system before doing a reinstall .



Can someone tell me how to remove EVERYTHING like all the configuration
files, the ini files, registry entries etc?



Or if you have a quick solution that would work???



Installed gnucash 4.12, Windows 11 Home version 22H2



Thank you

___
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] Saved report configurations

[Adrien Monteleone]

It looks like you were putting screenshots inline rather than as 
attachments.


Those images did not come through, so we can't see what you are 
referring to.


Your saved configuration should be under: Reports > Saved Report 
Configurations. You'll then get a pop-up with a list of your saved 
configurations. Select the one you want, but you might still have to 
adjust some options properly.


Regards,
Adrien

On 10/6/22 1:03 PM, Mahon Finbar wrote:

Hello,

I have saved the report configurations for my annual P over the years, 
or I thought I had.


It being the time I should make my annual tax return I went looking for 
the configuration for 2021 that I had started and found -


but when I selected and clicked the 2021 one I get -

Etc, which I had started a while back, but not the 2021 version.

Did I make an error somewhere and/or is it possible to find the 2021 one??



___
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] Saved report configurations

[Murugan Muruganandam]

Not to be overt, did you check the start and end date in the report options.




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Mahon Finbar 
Sent: Thursday, October 6, 2022 3:03 PM
To: Gnucash Users 
Subject: [GNC] Saved report configurations

Hello,

I have saved the report configurations for my annual P over the years,
or I thought I had.

It being the time I should make my annual tax return I went looking for
the configuration for 2021 that I had started and found -

but when I selected and clicked the 2021 one I get -

Etc, which I had started a while back, but not the 2021 version.

Did I make an error somewhere and/or is it possible to find the 2021 one??

TIA, Finbar
___
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] Reconciling subaccounts

[Adrien Monteleone]

Thanks for the details.

I'd say this is a bug, as the expected result would be to have the 
reconcile status of sub-accounts updated.


You should file that on bugs.gnucash.org

It *might* be designed that way however. I could be wrong, but I think 
the idea for this feature is to be used for 'virtual' sub-accounts that 
are used for segregating funds in your own books, but not actual 
multiple real-world accounts with an institution.


The parent is the real account in such a case, so that might be why it 
is the only one marked reconciled with a date. (it is the only one with 
a statement to reconcile against)


In your case, you seem to be trying to reconcile multiple real accounts 
through a placeholder parent. But GnuCash doesn't know that. (or 
'reconciling' non-institution accounts, such as Expenses.)


Until it is 'fixed' or changed, I guess your option is to continue to 
reconcile-finish the sub-accounts to update them, or else just reconcile 
them all individually rather than together as sub-accounts.


Regards,
Adrien

On 10/3/22 4:56 PM, Uttam Chakravorty wrote:


My apologies Adrien, I will be more specific.  Line 2 - >Sales -> A/c No 01: 
all the subsequent lines starting '01-' are the subaccounts.  Reconciling 01 with 
subaccounts ticked will reconcile all of them, but only update 01's date field.  I 
then step through the subaccounts and as they are all already reconciled I just press 
'Finish' to update their date.


Line 11 is a single entry with no subaccounts.


Line 12 is similar to Line 2, a Placeholder with three subaccounts.


I have tried to indicate the above in Column E, however I have made a mistake 
with Lines 64, 71 and 77.  They have no subaccounts, I annotated them in error 
as all the top level accounts are reconciled.  In terms of consistency I failed 
to annotate Lines 12, 17 and 59.  Looking back this is a scrappy piece of work 
put together in haste.  I hope you will be able to extract something useful, or 
I will happily do it again.  Please advise.



Line 18 (A/c code 5 (should be 05)) is particularly interesting.  This has 
subaccounts and they have Placeholders which have subaccounts i.e. three levels 
deep.  Reconciling the top level reconciles all the other levels, however once 
more it only updates the date at the top level.


I do not find it too onerous to live with this little extra keyboard activity.  
I just wondered if I was doing something wrong again.



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

Re: [GNC] Troubleshooting and/or database repair

[Adrien Monteleone]

If you try to add a transaction with a split to a non-existent account, 
do you get the option to create that account?


If so, and you choose to create it, does the new-account window show up?

And one additional 'environment' question:

Is this a local file, or stored on an external/network/cloud drive? (and 
if 'cloud' is this via Dropbox or some other service? or your own direct 
connection with no intervening apps?)


Regards,
Adrien

On 10/5/22 5:51 PM, Jim Kolodziej wrote:

No I can add transactions to existing accounts etc but can’t add a new
account or edit an existing account



___
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] Import CSV transactions into GC

[Carl S.]

What got me to use Linux (Ubuntu and now Debian) was back in 2008 
bankety-blank Intuit/Quacken (sic) began allowing only a two year direct 
connect from Quicken to download transactions before you had to purchase 
another license (or whatever it's called)  to get the same direct connect.


Presently, Intuit/Quicken, etc, are in cahoots with Discover to prevent 
us unwashed mortals from getting proprietary QFX from Discover.  So now 
I'm downloading csv from Discover and have learned, through your efforts 
and assistance, how to import a csv file into GC.


At this point all is well.

Thank you, all

Carl Smith



*From:* David Carlson [mailto:david.carlson@gmail.com]
*Subject:* [GNC] Import CSV transactions into GC
*Date:* Thursday, October 6, 2022 at 9:10 AM
*To:* Carl S.
*Cc:* gnucash-user@gnucash.org

OK.  I just checked and now they only offer PDF, Spreadsheet(whatever 
that means) and CSV download formats for my account.  I guess they 
don't need our business.


On Thu, Oct 6, 2022 at 7:51 AM Carl S.  wrote:

Whooops.you're right  QFX and not QDF

*From:* David Carlson [mailto:david.carlson@gmail.com
]
*Subject:* [GNC] Import CSV transactions into GC
*Date:* Thursday, October 6, 2022 at 12:17 AM
*To:* Carl S.
*Cc:* gnucash-user@gnucash.org


What is QDF format?  That would not be the same as QFX.

On Wed, Oct 5, 2022 at 10:57 PM Carl S.  wrote:

David,

Thanks for the recommendations.  I've been working on this
way too long
but think that I figured out some of the difficulties.  'Just
reconciled
a credit card statement and got all of the old mess behind so
that I can
begin anew by downloading csv transactions every few days or so.

I think I figured out why and how I got duplicates- in the Match
Transactions window there were several transactions that had
the A box
checked and in the Additional Comments column area there were
the words,
New, transfer $25.75 to (auto) "E:Food"  My guess is that
GC was
telling me, "you already have this transaction in the
register and
here's the amount and the account name".  So the solution was
to tell GC
to NOT import the transaction by unchecking the A box which
would turn
the line color red.  You're correct also that if the C box is
checked
that particular transaction wont be imported.

Thank you for the help...

Carl Smith

On 10/5/22 22:17, David Cousens wrote:
> Carl
>
> If you had previously imported the September transactions,
then the Import
> Matcher should recognize all of them as duplicates and not
import them. In this
> case the A checkbox and U+C checkbox should both be
unchecked and the 'C'
> checkbox set to indicate that the transactions match
existing transactions and
> won't be imported, but the existing transactions will be
marked as cleared (not
> reconciled).
>
> If the CSV file contained some data which differed from
that which was in the
> in the QFX files, the U+C checkbox may be checked instead
of the  C checkbox
> which indicates that the transaction matches an existing
transaction and won't
> be imported again but the data which is different will be
updated form the CSV
> import file.  The A checkbox should not be checked if the
transactions already
> exist in your data file, only if they are new transactions.
>
> It is deliberately designed so as to not allow importing
duplicate transactions
> as transactions can only be deleted individually from the
account register.
>
> If you are experimenting with the import, a good idea is to
create a dummy test
> set of books and experiment with importing into that
firstrather than your main
> set of books. The dummy doesn't have to have your full
account tree, just the
> accounts you will use during the import process. Once you
have the import
> working as you want then import to your main set of books.
It also helps to
> create a dummy CSV file which only has a few typical
transactions in it to get
> the setup right. Avoids having to delete large numbers of
transaction while you
> are experimenting if you don't get it right first time round.
>
> David Cousens
>
> On Wed, 2022-10-05 at 21:01 -0400, Carl S. wrote:
>> Discover Card (a credit card) as of 

Re: [GNC] CSV transaction import settings

[Adrien Monteleone]

David,

The Wiki FAQ has a section on file locations. I don't have the exact 
answer off-hand, but I'm sure one of those locations has what you are 
looking for. (allegedly, there are no other places used by GnuCash)


Regards,
Adrien

On 10/6/22 8:49 AM, David Carlson wrote:

Where are the settings stored?  I thought I copied all the GnuCash stuff
from one computer to another Ubuntu machine.  I got my memorized reports
but not the CSV Transactions import settings.




___
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] Saved report configurations

[Mahon Finbar]

Hello,

I have saved the report configurations for my annual P over the years, 
or I thought I had.


It being the time I should make my annual tax return I went looking for 
the configuration for 2021 that I had started and found -


but when I selected and clicked the 2021 one I get -

Etc, which I had started a while back, but not the 2021 version.

Did I make an error somewhere and/or is it possible to find the 2021 one??

TIA, Finbar
___
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] Bulk check box A U+C C

[Carl S.]

In the screen Match Transactions screen is there a quick way to check 
off all of the boxes in column A or U+C or C all at once?


Thanks,

Carl S.



OpenPGP_0x19B6B68457884FFB.asc
Description: OpenPGP public key


OpenPGP_signature
Description: OpenPGP digital signature
___
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] Chase OFXdirect connect - another one bites the dust

[Glenn Serre]

Good morning,

On Thu, Oct 6, 2022 at 9:53 AM Jean Laroche  wrote:
>
> Any of you know whether something else is in the works to replace direct
> connect? Manual downloading can be a pain when you have many accounts in
> different institutions...

I have the same issue.  I had some success searching out the new
settings for Bank of the West, but if ofx direct connect is going
away, maybe a different strategy is needed.  I was thinking maybe a
tool to extract ofx/qfx downloads from the various bank websites? I
haven't found an existing one.

-- Glenn S.

>
> J.
>
> On 10/6/22 9:46 AM, David Reiser via gnucash-user wrote:
> > As of today, aqbanking reports that “ofx.chase.com” 
> > is an unknown host. Banktivity reports that today is the start of Chase 
> > enforcing data access only through Open Banking APIs.
> >
> > OFX data format transaction downloads are still available from the Chase 
> > online web accounts — manual download followed by File>Import>Import 
> > OFX/QFX… in Gnucash.
> > --
> > Dave Reiser
> > dbrei...@icloud.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.
> ___
> 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] Chase OFXdirect connect - another one bites the dust

[Jean Laroche]

Any of you know whether something else is in the works to replace direct 
connect? Manual downloading can be a pain when you have many accounts in 
different institutions...


J.

On 10/6/22 9:46 AM, David Reiser via gnucash-user wrote:

As of today, aqbanking reports that “ofx.chase.com” is 
an unknown host. Banktivity reports that today is the start of Chase enforcing data 
access only through Open Banking APIs.

OFX data format transaction downloads are still available from the Chase online web 
accounts — manual download followed by File>Import>Import OFX/QFX… in Gnucash.
--
Dave Reiser
dbrei...@icloud.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.

___
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] Chase OFXdirect connect - another one bites the dust

[David Reiser via gnucash-user]

As of today, aqbanking reports that “ofx.chase.com ” is 
an unknown host. Banktivity reports that today is the start of Chase enforcing 
data access only through Open Banking APIs. 

OFX data format transaction downloads are still available from the Chase online 
web accounts — manual download followed by File>Import>Import OFX/QFX… in 
Gnucash. 
--
Dave Reiser
dbrei...@icloud.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.

Re: [GNC] Import CSV transactions into GC

[R Losey]

While the convenience of importing transactions is nice, I've been doing
manual reconciliation and entry -- it's fast enough, providing that I
haven't missed a transaction.

On Thu, Oct 6, 2022 at 8:11 AM David Carlson 
wrote:

> OK.  I just checked and now they only offer PDF, Spreadsheet(whatever that
> means) and CSV download formats for my account.  I guess they don't need
> our business.
>
> On Thu, Oct 6, 2022 at 7:51 AM Carl S.  wrote:
>
> > Whooops.you're right  QFX and not QDF
> > --
> > *From:* David Carlson [mailto:david.carlson@gmail.com
> > ]
> > *Subject:* [GNC] Import CSV transactions into GC
> > *Date:* Thursday, October 6, 2022 at 12:17 AM
> > *To:* Carl S.
> > *Cc:* gnucash-user@gnucash.org
> >
> > What is QDF format?  That would not be the same as QFX.
> >
> > On Wed, Oct 5, 2022 at 10:57 PM Carl S.  wrote:
> >
> >> David,
> >>
> >> Thanks for the recommendations.  I've been working on this way too long
> >> but think that I figured out some of the difficulties.  'Just reconciled
> >> a credit card statement and got all of the old mess behind so that I can
> >> begin anew by downloading csv transactions every few days or so.
> >>
> >> I think I figured out why and how I got duplicates-  in the Match
> >> Transactions window there were several transactions that had the A box
> >> checked and in the Additional Comments column area there were the words,
> >> New, transfer $25.75 to (auto) "E:Food"  My guess is that GC was
> >> telling me, "you already have this transaction in the register and
> >> here's the amount and the account name".  So the solution was to tell GC
> >> to NOT import the transaction by unchecking the A box which would turn
> >> the line color red.  You're correct also that if the C box is checked
> >> that particular transaction wont be imported.
> >>
> >> Thank you for the help...
> >>
> >> Carl Smith
> >>
> >> On 10/5/22 22:17, David Cousens wrote:
> >> > Carl
> >> >
> >> > If you had previously imported the September transactions, then the
> >> Import
> >> > Matcher should recognize all of them as duplicates and not import
> them.
> >> In this
> >> > case the A checkbox and U+C checkbox should both be unchecked and the
> >> 'C'
> >> > checkbox set to indicate that the transactions match existing
> >> transactions and
> >> > won't be imported, but the existing transactions will be marked as
> >> cleared (not
> >> > reconciled).
> >> >
> >> > If the CSV file contained some data which differed from that which was
> >> in the
> >> > in the QFX files, the U+C checkbox may be checked instead of the  C
> >> checkbox
> >> > which indicates that the transaction matches an existing transaction
> >> and won't
> >> > be imported again but the data which is different will be updated form
> >> the CSV
> >> > import file.  The A checkbox should not be checked if the transactions
> >> already
> >> > exist in your data file, only if they are new transactions.
> >> >
> >> > It is deliberately designed so as to not allow importing duplicate
> >> transactions
> >> > as transactions can only be deleted individually from the account
> >> register.
> >> >
> >> > If you are experimenting with the import, a good idea is to create a
> >> dummy test
> >> > set of books and experiment with importing into that firstrather than
> >> your main
> >> > set of books. The dummy doesn't have to have your full account tree,
> >> just the
> >> > accounts you will use during the import process. Once you have the
> >> import
> >> > working as you want then import to your main set of books. It also
> >> helps to
> >> > create a dummy CSV file which only has a few typical transactions in
> it
> >> to get
> >> > the setup right. Avoids having to delete large numbers of transaction
> >> while you
> >> > are experimenting if you don't get it right first time round.
> >> >
> >> > David Cousens
> >> >
> >> > On Wed, 2022-10-05 at 21:01 -0400, Carl S. wrote:
> >> >> Discover Card (a credit card) as of last week stopped providing the
> >> >> download of Discover card transactions in QDFmuch to my
> >> displeasure.
> >> >>
> >> >> They do provide a download of transactions in CSV format.
> >> >>
> >> >> I'm trying to figure out how to do a reliable importation of my
> credit
> >> >> card transactions into GC in my Discover Card acct in GC.  This all
> >> >> assumes I'll have to work with the downloaded CSV files now.
> >> >>
> >> >> For experimentation reasons I'm working on importing in csv format
> the
> >> >> transactions for the entire month of September just to see how the
> >> >> actual process is done.  Previously, I had already imported the
> >> Discover
> >> >> card transactions in QDF for September (before Discover Card ended
> the
> >> >> QDF download).  Next I'm importing the CSV transactions to see how
> they
> >> >> are recognized and matched by GC.
> >> >>
> >> >> I've been somewhat successful in using  the
> >> >> FileImport-Transactions from CSV 

Re: [GNC] HELP!!! How to purge everything from my windows pc before attempting a new re-install

[David Carlson]

Before resorting to such invasive surgery, have you used Task Manager to
verify that "Nothing happens" or is Gnucash doing something in the
background?

On Thu, Oct 6, 2022 at 9:32 AM  wrote:

> Somehow my gnucash is behaving very badly. a lot of the functionality from
> the main menu does not work.  For example, if I select export the account
> tree - nothing happens.
>
> If I selected add an account or edit an account nothing happens.
>
>
>
> I tried to uninstall and reinstall everything I could think of.  I did a
> search throughout my file system for any gnu-related files and removed them
> etc.  then did a re-install.
>
>
>
> I was surprised that gnucash actually remembered my recent files that were
> open, so I must be missing something when I tried to delete gnucash from my
> system before doing a reinstall .
>
>
>
> Can someone tell me how to remove EVERYTHING like all the configuration
> files, the ini files, registry entries etc?
>
>
>
> Or if you have a quick solution that would work???
>
>
>
> Installed gnucash 4.12, Windows 11 Home version 22H2
>
>
>
> Thank you
>
> ___
> 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.

[GNC] HELP!!! How to purge everything from my windows pc before attempting a new re-install

[jmybal]

Somehow my gnucash is behaving very badly. a lot of the functionality from
the main menu does not work.  For example, if I select export the account
tree - nothing happens.

If I selected add an account or edit an account nothing happens.

 

I tried to uninstall and reinstall everything I could think of.  I did a
search throughout my file system for any gnu-related files and removed them
etc.  then did a re-install.

 

I was surprised that gnucash actually remembered my recent files that were
open, so I must be missing something when I tried to delete gnucash from my
system before doing a reinstall .

 

Can someone tell me how to remove EVERYTHING like all the configuration
files, the ini files, registry entries etc?

 

Or if you have a quick solution that would work???

 

Installed gnucash 4.12, Windows 11 Home version 22H2

 

Thank you

___
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] CSV transaction import settings

[David Carlson]

Where are the settings stored?  I thought I copied all the GnuCash stuff
from one computer to another Ubuntu machine.  I got my memorized reports
but not the CSV Transactions import settings.

-- 
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] Import CSV transactions into GC

[David Carlson]

OK.  I just checked and now they only offer PDF, Spreadsheet(whatever that
means) and CSV download formats for my account.  I guess they don't need
our business.

On Thu, Oct 6, 2022 at 7:51 AM Carl S.  wrote:

> Whooops.you're right  QFX and not QDF
> --
> *From:* David Carlson [mailto:david.carlson@gmail.com
> ]
> *Subject:* [GNC] Import CSV transactions into GC
> *Date:* Thursday, October 6, 2022 at 12:17 AM
> *To:* Carl S.
> *Cc:* gnucash-user@gnucash.org
>
> What is QDF format?  That would not be the same as QFX.
>
> On Wed, Oct 5, 2022 at 10:57 PM Carl S.  wrote:
>
>> David,
>>
>> Thanks for the recommendations.  I've been working on this way too long
>> but think that I figured out some of the difficulties.  'Just reconciled
>> a credit card statement and got all of the old mess behind so that I can
>> begin anew by downloading csv transactions every few days or so.
>>
>> I think I figured out why and how I got duplicates-  in the Match
>> Transactions window there were several transactions that had the A box
>> checked and in the Additional Comments column area there were the words,
>> New, transfer $25.75 to (auto) "E:Food"  My guess is that GC was
>> telling me, "you already have this transaction in the register and
>> here's the amount and the account name".  So the solution was to tell GC
>> to NOT import the transaction by unchecking the A box which would turn
>> the line color red.  You're correct also that if the C box is checked
>> that particular transaction wont be imported.
>>
>> Thank you for the help...
>>
>> Carl Smith
>>
>> On 10/5/22 22:17, David Cousens wrote:
>> > Carl
>> >
>> > If you had previously imported the September transactions, then the
>> Import
>> > Matcher should recognize all of them as duplicates and not import them.
>> In this
>> > case the A checkbox and U+C checkbox should both be unchecked and the
>> 'C'
>> > checkbox set to indicate that the transactions match existing
>> transactions and
>> > won't be imported, but the existing transactions will be marked as
>> cleared (not
>> > reconciled).
>> >
>> > If the CSV file contained some data which differed from that which was
>> in the
>> > in the QFX files, the U+C checkbox may be checked instead of the  C
>> checkbox
>> > which indicates that the transaction matches an existing transaction
>> and won't
>> > be imported again but the data which is different will be updated form
>> the CSV
>> > import file.  The A checkbox should not be checked if the transactions
>> already
>> > exist in your data file, only if they are new transactions.
>> >
>> > It is deliberately designed so as to not allow importing duplicate
>> transactions
>> > as transactions can only be deleted individually from the account
>> register.
>> >
>> > If you are experimenting with the import, a good idea is to create a
>> dummy test
>> > set of books and experiment with importing into that firstrather than
>> your main
>> > set of books. The dummy doesn't have to have your full account tree,
>> just the
>> > accounts you will use during the import process. Once you have the
>> import
>> > working as you want then import to your main set of books. It also
>> helps to
>> > create a dummy CSV file which only has a few typical transactions in it
>> to get
>> > the setup right. Avoids having to delete large numbers of transaction
>> while you
>> > are experimenting if you don't get it right first time round.
>> >
>> > David Cousens
>> >
>> > On Wed, 2022-10-05 at 21:01 -0400, Carl S. wrote:
>> >> Discover Card (a credit card) as of last week stopped providing the
>> >> download of Discover card transactions in QDFmuch to my
>> displeasure.
>> >>
>> >> They do provide a download of transactions in CSV format.
>> >>
>> >> I'm trying to figure out how to do a reliable importation of my credit
>> >> card transactions into GC in my Discover Card acct in GC.  This all
>> >> assumes I'll have to work with the downloaded CSV files now.
>> >>
>> >> For experimentation reasons I'm working on importing in csv format the
>> >> transactions for the entire month of September just to see how the
>> >> actual process is done.  Previously, I had already imported the
>> Discover
>> >> card transactions in QDF for September (before Discover Card ended the
>> >> QDF download).  Next I'm importing the CSV transactions to see how they
>> >> are recognized and matched by GC.
>> >>
>> >> I've been somewhat successful in using  the
>> >> FileImport-Transactions from CSV and getting to the Match
>> >> Transactions screen which presents the transactions to be imported.  I
>> >> understand what the Reconcile (auto match) transactions are but many of
>> >> the transactions when imported to the account end up as duplicates
>> since
>> >> previously they had been added in QDF.
>> >>
>> >> So, I'm confused and want to make the importation process as easy as
>> >> possible.  The A  U+C  C options make matters worsefor me.
>> 

[GNC] Import Map Editor

[Carl S.]

I'm curious about the Import Map Editor and what it's for.  It does say 
I've got something like 300 invalid mapping and asks if I want to delete 
them.


No idea what to do with itand certainly don't want to create a disaster.

Thanks,

Carl



OpenPGP_0x19B6B68457884FFB.asc
Description: OpenPGP public key


OpenPGP_signature
Description: OpenPGP digital signature
___
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] Import CSV transactions into GC

[Carl S.]

Whooops.you're right  QFX and not QDF

*From:* David Carlson [mailto:david.carlson@gmail.com]
*Subject:* [GNC] Import CSV transactions into GC
*Date:* Thursday, October 6, 2022 at 12:17 AM
*To:* Carl S.
*Cc:* gnucash-user@gnucash.org


What is QDF format?  That would not be the same as QFX.

On Wed, Oct 5, 2022 at 10:57 PM Carl S.  wrote:

David,

Thanks for the recommendations.  I've been working on this way too
long
but think that I figured out some of the difficulties.  'Just
reconciled
a credit card statement and got all of the old mess behind so that
I can
begin anew by downloading csv transactions every few days or so.

I think I figured out why and how I got duplicates-  in the Match
Transactions window there were several transactions that had the A
box
checked and in the Additional Comments column area there were the
words,
New, transfer $25.75 to (auto) "E:Food"  My guess is that GC was
telling me, "you already have this transaction in the register and
here's the amount and the account name".  So the solution was to
tell GC
to NOT import the transaction by unchecking the A box which would
turn
the line color red.  You're correct also that if the C box is checked
that particular transaction wont be imported.

Thank you for the help...

Carl Smith

On 10/5/22 22:17, David Cousens wrote:
> Carl
>
> If you had previously imported the September transactions, then
the Import
> Matcher should recognize all of them as duplicates and not
import them. In this
> case the A checkbox and U+C checkbox should both be unchecked
and the 'C'
> checkbox set to indicate that the transactions match existing
transactions and
> won't be imported, but the existing transactions will be marked
as cleared (not
> reconciled).
>
> If the CSV file contained some data which differed from that
which was in the
> in the QFX files, the U+C checkbox may be checked instead of
the  C checkbox
> which indicates that the transaction matches an existing
transaction and won't
> be imported again but the data which is different will be
updated form the CSV
> import file.  The A checkbox should not be checked if the
transactions already
> exist in your data file, only if they are new transactions.
>
> It is deliberately designed so as to not allow importing
duplicate transactions
> as transactions can only be deleted individually from the
account register.
>
> If you are experimenting with the import, a good idea is to
create a dummy test
> set of books and experiment with importing into that firstrather
than your main
> set of books. The dummy doesn't have to have your full account
tree, just the
> accounts you will use during the import process. Once you have
the import
> working as you want then import to your main set of books. It
also helps to
> create a dummy CSV file which only has a few typical
transactions in it to get
> the setup right. Avoids having to delete large numbers of
transaction while you
> are experimenting if you don't get it right first time round.
>
> David Cousens
>
> On Wed, 2022-10-05 at 21:01 -0400, Carl S. wrote:
>> Discover Card (a credit card) as of last week stopped providing the
>> download of Discover card transactions in QDFmuch to my
displeasure.
>>
>> They do provide a download of transactions in CSV format.
>>
>> I'm trying to figure out how to do a reliable importation of my
credit
>> card transactions into GC in my Discover Card acct in GC.  This all
>> assumes I'll have to work with the downloaded CSV files now.
>>
>> For experimentation reasons I'm working on importing in csv
format the
>> transactions for the entire month of September just to see how the
>> actual process is done.  Previously, I had already imported the
Discover
>> card transactions in QDF for September (before Discover Card
ended the
>> QDF download).  Next I'm importing the CSV transactions to see
how they
>> are recognized and matched by GC.
>>
>> I've been somewhat successful in using  the
>> FileImport-Transactions from CSV and getting to the Match
>> Transactions screen which presents the transactions to be
imported.  I
>> understand what the Reconcile (auto match) transactions are but
many of
>> the transactions when imported to the account end up as
duplicates since
>> previously they had been added in QDF.
>>
>> So, I'm confused and want to make the importation process as
easy as
>> possible.  The A  U+C  C options make matters worsefor me.
>>
>> Also, I've tried, or rather, have 

Re: [GNC] Import CSV transactions into GC

[David Cousens]

Carl,

The A checkbox (Add) indicates that the transaction is to be imported as it
hasn't matched any existing transaction. If it was checked and that transaction
was previously imported, then for some reason the Import Matcher did not
automatically match the existing transaction. One possible reason might be for
example, if the QFX and CSV files both included a transaction ID but the
transaction ID was different in each file ( why it would be is an interesting
question), then GnuCash would flag it to be added as it would class it as a
separate transaction even if all the other data matched the existing
transaction.  It's been a while since I did any work on the importer code but
that is the only reason I can think of for it not matching the previously
imported transaction if the data was otherwise the same. Geert may be able to
correct me if i have that wrong.

David

On Wed, 2022-10-05 at 23:56 -0400, Carl S. wrote:
> David,
> 
> Thanks for the recommendations.  I've been working on this way too long 
> but think that I figured out some of the difficulties.  'Just reconciled 
> a credit card statement and got all of the old mess behind so that I can 
> begin anew by downloading csv transactions every few days or so.
> 
> I think I figured out why and how I got duplicates-  in the Match 
> Transactions window there were several transactions that had the A box 
> checked and in the Additional Comments column area there were the words, 
> New, transfer $25.75 to (auto) "E:Food"  My guess is that GC was 
> telling me, "you already have this transaction in the register and 
> here's the amount and the account name".  So the solution was to tell GC 
> to NOT import the transaction by unchecking the A box which would turn 
> the line color red.  You're correct also that if the C box is checked 
> that particular transaction wont be imported.
> 
> Thank you for the help...
> 
> Carl Smith
> 
> On 10/5/22 22:17, David Cousens wrote:
> > Carl
> > 
> > If you had previously imported the September transactions, then the Import
> > Matcher should recognize all of them as duplicates and not import them. In
> > this
> > case the A checkbox and U+C checkbox should both be unchecked and the 'C'
> > checkbox set to indicate that the transactions match existing transactions
> > and
> > won't be imported, but the existing transactions will be marked as cleared
> > (not
> > reconciled).
> >   
> > If the CSV file contained some data which differed from that which was in
> > the
> > in the QFX files, the U+C checkbox may be checked instead of the  C checkbox
> > which indicates that the transaction matches an existing transaction and
> > won't
> > be imported again but the data which is different will be updated form the
> > CSV
> > import file.  The A checkbox should not be checked if the transactions
> > already
> > exist in your data file, only if they are new transactions.
> > 
> > It is deliberately designed so as to not allow importing duplicate
> > transactions
> > as transactions can only be deleted individually from the account register.
> > 
> > If you are experimenting with the import, a good idea is to create a dummy
> > test
> > set of books and experiment with importing into that firstrather than your
> > main
> > set of books. The dummy doesn't have to have your full account tree, just
> > the
> > accounts you will use during the import process. Once you have the import
> > working as you want then import to your main set of books. It also helps to
> > create a dummy CSV file which only has a few typical transactions in it to
> > get
> > the setup right. Avoids having to delete large numbers of transaction while
> > you
> > are experimenting if you don't get it right first time round.
> > 
> > David Cousens
> > 
> > On Wed, 2022-10-05 at 21:01 -0400, Carl S. wrote:
> > > Discover Card (a credit card) as of last week stopped providing the
> > > download of Discover card transactions in QDFmuch to my displeasure.
> > > 
> > > They do provide a download of transactions in CSV format.
> > > 
> > > I'm trying to figure out how to do a reliable importation of my credit
> > > card transactions into GC in my Discover Card acct in GC.  This all
> > > assumes I'll have to work with the downloaded CSV files now.
> > > 
> > > For experimentation reasons I'm working on importing in csv format the
> > > transactions for the entire month of September just to see how the
> > > actual process is done.  Previously, I had already imported the Discover
> > > card transactions in QDF for September (before Discover Card ended the
> > > QDF download).  Next I'm importing the CSV transactions to see how they
> > > are recognized and matched by GC.
> > > 
> > > I've been somewhat successful in using  the
> > > FileImport-Transactions from CSV and getting to the Match
> > > Transactions screen which presents the transactions to be imported.  I
> > > understand what the Reconcile (auto match) transactions are but many of