[GNC] Import is finding no matching transactions

[Gyle McCollam]

Aaron,
1st David is correct, you don't set up the expense account as subaccounts of your checking account.  They are Expenses and you debit the expense account and credit the bank account.  By looking at the expense account you get the "running total" of the expense.

2ndly, Budgets are set up for expected expenses for you to track what you thought you were going to spend versus what you actually spent.  "Budget" accounts never show you an "active" or current balance in an account, the actual expense account shows you the running total or active balance.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326                     Mobile

gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email

________________________________
From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on behalf of davidcousens49 at gmail.com <davidcousens49 at gmail.com>
Sent: Tuesday, May 31, 2022 6:27 PM
To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: Re: [GNC] Import is finding no matching transactions

Aaron,

>From your description it sounds as though you have created sub-accounts of your
checking account to implement a budget process. If this is the case, it is the
opposite of normal accounting proceduress. To account for expenditure in a
specific category the generally accepted procedure is to create sub accounts of
Expenses for specific expense categories. You can get information on the
Budgeting features in the Tutorial and Concepts Guide
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_budgets.html and from
the wiki https://wiki.gnucash.org/wiki/Budget_Requirements detailing a bit more
of the background.

David Cousens


On Tue, 2022-05-31 at 15:17 +0000, Thepwnd via gnucash-user wrote:
> Hi all,
>
> I wanted to circle back on this issue that I opened a couple weeks ago.  I
> came down with the flu, as did the rest of my family, so I haven't had a
> chance to look at this again until this weekend.  Also, I'm not sure if I'm
> creating the response to the mailing list in the most optimal way, but I can't
> find any specific instructions other than to change the subject line when
> replying, so please let me know if there's something else I should be doing.
>
> With that out of the way, I was able to figure out what the problem
> was.  Apparently my importer tool wasn't able to find any matches because the
> source account is locked as my "Checking Account," but when I setup my
> accounts initially - and I'm not sure this was the correct way to do it - I
> ended up creating a bunch of subaccounts for all of my expense categories.  My
> intention was to be able to see a running balance in each category, but I also
> don't think I understand how to fully utilize the budget feature in
> GnuCash.  At any rate, I updated one of my transactions to set the source
> account to the main/root checking account, rather than the subaccount, and now
> the importer is able to find a match for it.
>
> So I guess I have a few follow-up questions: 1) Can I use the budget feature
> in GnuCash to see an active balance for a given expense category, or does the
> budget only tell me how much money I've spent in that category for the given
> time period? 2) Is there a way to either change the source account on an
> import (I'm not sure how it automatically detected the Checking Account in the
> first place) or to perform a mass update to the source account on my
> transactions?
>
> Thanks,
> -Aaron
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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 at 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.