[GNC] Help with downloading transactions.
George Riner
georgeriner at mycogeo.com
Fri Mar 17 20:51:22 EDT 2023
I am completely aware of that. But I have to correct business names, and
the noise that comes into the memo/notes fields, too. And sometimes
useless stuff shows up in the 'Num' field. After I've cleaned up all
those fields, then I set the transaction to the correct expense account,
which causes it to leave the 'Unspecified' account. I know when I'm
done cleaning up these transactions when the 'Unspecified' account is
empty of entries. I don't have to search through expense registers or
bank/credit registers to find them and clean them.
Transactions that match are set to 'P' and flow through without bringing
any of the stuff I would otherwise clean out. They go to their
designated expense account right away.
So, downloading is a subset of type 'M'?
:George
On 3/17/2023 5:10 PM, Gyle McCollam wrote:
> George,
> you are probably aware, but just in case, when you use the add you can
> actually designate the proper expense account within the matching
> window. That way you don't have to go back later to 'unspecified" and
> correct the entries.
> P.S. BTW, entering by hand is type "M".
>
> Thank You,
>
> *Gyle McCollam*
>
> Gyle McCollam
>
> 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
> George Riner <georgeriner at mycogeo.com>
> *Sent:* Friday, March 17, 2023 7:33 PM
> *To:* gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> *Subject:* Re: [GNC] Help with downloading transactions.
> I'm and 'M' and a 'K'. I download from banks and I reconcile. I'm also
> a enter-by-hand (I don't know what letter-type that would be).
>
> I like downloading because it catches things I don't get receipts for
> and that I forget to hand-enter. On-line purchases, gas pumps that run
> out of receipt paper, or the receipt didn't get out of my pocket and
> went through the laundry.
>
> I reconcile, because it catches when I enter the charge in the wrong
> credit card acct, and it informs me for when a check I wrote has not
> cleared the bank, or some charge is delayed, or for when I hand-enter
> something and I do a typo.
>
> When I download, I never use the 'U' option - there's too much useless
> noise in the downloaded transactions that gets into my registers that
> only serves to clutter up reports. I'm assuming these numbers are
> meaningful to someone at the bank/creditcard, or maybe the retailer, but
> I've yet to find anything they match. They aren't Amazon order numbers
> or Amazon receipt numbers, nor Amazon invoice numbers. Maybe some
> transaction number that only the bank knows about? Plus, names of
> businesses rarely match, and even when they do, they're often all UPPER
> CASE and often include misguided attempts by the retailer for Customer
> Relationship Management by adding in "THANK YOU FOR YOUR PURCHASE!!"
> which is totally useless in my accounts & reports.
>
> I wish there was a way to turn off the 'Bayesian" amount matching.
> Because I don't want to be close, I want to be exact. So when
> reconciling I have to carefully watch the matching transactions to make
> sure they're aren't off by $0.02 or some tiny amount.
>
> For downloaded transactions that have to be added, I use the 'A' option,
> but I force all those transactions to go into a special account - I name
> it 'Unspecified' (under Expenses). I then apply the downloaded
> transaction and then go through all the 'Unspecified' entries in Journal
> view and clean them up and correct the expense account to apply them to.
>
> The Reconcile function also has a really useful way of creating the
> payment transaction and giving it a future date (the payment due date,
> for example), and posting it to my bank acct.
>
> :George
> Windows 10 build 19045.2604
> Gnucash Build ID: 4.11+(2022-06-25)
>
>
>
> On 3/17/2023 1:57 AM, edodd at billiau.net wrote:
> > On Thu, 16 Mar 2023 15:38:25 +0000
> > Gyle McCollam <gmccollam at live.com> wrote:
> >
> >> You really should try to download and import transactions.
> > This is a philosophical point.
> > There is group "M" who always enter every transaction first in their
> > books and then use the bank documents to reconcile
> >
> > and
> >
> > There is group "K" who enter some things and use the bank download to
> > keep their accounts.
> >
> > There are pros and cons to each method. Gnucash allows you to make your
> > own choice.
> >
> >
> > Liz
> > _______________________________________________
> > 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
> > -----
> > 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user
mailing list