[GNC] How to handle multiple entries of multiply reconciled entries

[Jeff]

How I did this is beyond me, somehow I confused GNC to let it happen or 
had a data corruption when the journal was improperly saved (power 
outage, GNC lost a poker game, thought it was Quirken, etc).  I use 
uncompressed XML on Ubuntu 20.04LTS.


I have discovered multiple (dozens) of transactions that are duplicates 
in several registers but; reconciled to the wrong accounts.  I am not 
sure of the easiest and proper way to correct them.


Example of the simplest ones are:  using Check 101, Cash, salary.

01/01/10 chk 101 -> Cash -> chk 101 reconciled

01/01/10 chk 101 -> salary -> salary reconciled

These are posted as 2 entirely separate transactions, in the same 
register, but are supposed to be only one transaction:


01/01/10 chk 101 -> salary -> both reconciled

As a result my current balance is now off by off by over $4,000.

And the real kicker, is that these errors now go back 3 years in this 
journal.  I know these errors did not exist prior to FlatPak 4.9, not 
sure which version I upgraded from to 4.9.  Plus they would have shown 
up when I did reports for taxes and income expense statements last year.


Suggestions, besides burning more midnight oil than this old man has 
left, other than to delete all of them and enter all of them correctly 
as I find them.  I'm in tax time crunch here.


--
--JEffrey Black M.B.A.

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

Re: [GNC] Budgeting problem

[Paul Warthe]

Thank you very much Jim. There was something in the Groceries line which
was preventing the subtotal from being displayed.  I could not see anything
in the row, but after clearing it everything worked.

Paul


>
> Message: 2
> Date: Tue, 1 Feb 2022 23:18:40 -0500
> From: Jim Passmore 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Budgeting problem
> Message-ID:
> <
> camrw02mos_xoycyqrgdg4431zfpoo-n_nu0eggjjvv+p+4s...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Paul,
> Perhaps you have inadvertently entered a zero into the Groceries account?
> If you do, it overrides the summation of subaccounts.  You can simply
> highlight and hit delete to get rid of it.
>
> --
>
> *Jim Passmore*
>
>
>
>
> On Mon, Jan 31, 2022 at 10:01 PM Paul Warthe  wrote:
>
> > Hello All,
> >
> >
> >
> > I'm back to pick your brains on a problem I'm having with the budgeting
> > feature. First time I have used it, so here goes. (Windows 10, GC ver.
> 4.9)
> >
> >
> >
> > I have an account "Food" with 2 sub accounts "Groceries" and
> "Restaurants".
> > Each sub account has further sub accounts of the names of the stores and
> > restaurants we frequent. In the budget, the amounts I have entered for
> each
> > restaurant is rolling up into a subtotal under the Restaurants
> > subaccount/title. The amounts I have entered under the grocery stores do
> > not
> > roll up under the Groceries subaccount/title. The Food account/title only
> > shows the subtotal of the restaurants.
> >
> >
> >
> > I have checked the setup of each account and made sure they are setup the
> > same. What is happening in my budget that the Groceries won't roll up the
> > stores and is not being included in the Food total?
> >
> >
> >
> > PS. I love the ability to open the account to see the actual transactions
> > for the past year.
> >
> >
> >
> > Regards,
> >
> > Paul
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] No luck with OFX Direct AqBanking

[Bruce Trumbo]

I am trying to set up direct bank transaction downloads into GnuCash 4.9 
from several US banks.  All use the OFX connection method a la Quicken.


I have not been successful with any of the three banks I tried - Wells 
Fargo, PNC Bank and Chase Bank.  In several cases, the user definition 
dialog seemed to complete, but downloading accounts or defining an 
account connection fails.  The screen log of the dialog seemed to 
indicate that TLS 1.2 is being used.  Is this correct? Isn't this an 
old, deprecated protocol that up-to-date bank servers will likely reject?


Thanks - BLT

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

[GNC] PDF creation option

[Jed Taylor]

I've created some .pdfs of P reports, and set the report to use the
two-column layout.  I just discovered this option doesn't size the output to
the printed page, so the far right totals (the number I'm most interested in
- the net P/L for the period) are missing.

 

Changing the report layout to a single column so that the expenses are under
the income rather than beside them solves this issue, although there's
next-to-no margins on the page.

 

Any suggestions as to how to produce good-looking reports from GnuCash?

 

Thanks.

 

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

Re: [GNC] How to properly import a csv with the correct settings.

[Adrien Monteleone]

And then you can create a special folder for messages from this list, 
and setup a filter to put them there automatically so from then on, you 
don't have to hunt through Allmail.


There is also an option in Mailman preferences to not receive copies of 
your own messages. If you turn this off, they'll be sent back to you. 
(and not just stored in your Sent folder)


Regards,
Adrien

On 1/29/22 2:46 AM, Liz wrote:

The disconnect here is seen by all users of gmail.
Gmail decides, on your behalf, that you don't need to see your posts to
a mailing list. Gmail just puts them in "Allmail".
You can either check the Allmail directory, or the Gnucash archives to
find your post.


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

Re: [GNC] File Locations

[Tommy Trussell]

On Mon, Jan 31, 2022 at 5:09 AM Jan Herdsman  wrote:

> I am using an iMac, I would like to be able to save my GNU file in a cloud
> or other location than my hard drive, Also don't know where the location or
> name of any backup files are,
> All I can see is log files and one LCK file and the gnucash file, all in My
> Documents.
> If possible I would also like to be able to open the main file on a windows
> computer sometimes.
>

If you have your data stored as SQL (instead of the default XML file
format) you won't have any backup files, just the log files. The log files,
and backup files, if any can automatically be deleted after a certain time
according to the preferences in GnuCash.

HOWEVER since you aren't certain where all your files are and want to move
and/or sync them, I checked the FAQ:

https://wiki.gnucash.org/wiki/FAQ

which links to the Backup entry:

https://wiki.gnucash.org/wiki/Backup

Have a look at the Backup information and see if that helps you A) make a
backup of your valuable data NOW before something goes wrong and B) know
what files you might want to move or mark to sync with your iCloud (or
DropBox, Google Drive, etc.).

(Generally it's a lot easier to keep each data file in its own directory
because of the log files and backup files that clutter it, so a separate
directory is recommended. When you move the GnuCash files to a new
location, unfortunately the Mac version keeps looking for the data file in
the old location UNTIL you explicitly Open the newly positioned data file
from within the application.)

Once your data file has been located where another computer syncs with it,
you can open the file from that computer, too. Just be sure to use the same
version number GnuCash on that computer, and don't expect to be able to
open the data from more than one computer at the same time.


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

Re: [GNC] Bayesian Matching is not working very well

[john]

> On Feb 1, 2022, at 10:44 PM, David Carlson  
> wrote:
> 
> I am currently running GnuCash 3.8 in Ubuntu 20.04.  This release has the
> 'New' generic importer with the revised Bayesian matching.  I have found
> that sometimes it is good at assigning accounts to incoming transactions
> and other times it is awful.  One example is transactions where Starbucks
> recharges my wife's online app with $25.00 two or three times a month,
> GnuCash has seen this transaction 130 times according to the Import Map
> Editor, yet it cannot assign this transaction to the correct expense
> account.  There are several other common transactions at certain businesses
> that do not get assigned even though they have appeared many times.  It
> used to work better in the old version that was in the 2.6.x releases. Is
> this a bug?

Maybe, depending on why the matcher gets it wrong. The matcher uses space as a 
separator to break up the description into tokens. Every time you match a 
transfer account to a transaction the tokens in the transaction are added or 
incremented on the account. The import map editor shows those pairings with the 
scores.

The match algorithm is a variation on a "naive Bayes filter" commonly used in 
spam detectors like SpamAssassin, see 
https://en.wikipedia.org/wiki/Naive_Bayes_spam_filtering 
 for an explanation. 
The modification is that a spam filter makes a single yes-no decision while the 
match algorithm needs to make a most likely decision among two or more possible 
accounts.

Now that you know what to look for you can analyze the tokens in your Starbucks 
recharge transactions using the counts in the import map editor to figure out 
why the matching algorithm might be getting it wrong.

Regards,
John Ralls

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