On 1/12/26 12:58 PM, David Cousens wrote:
It is always recommended to import in relatively small batches i.e. a
month at a time rather than one huge import and to reconcile between
imports so you pick up any errors.
For many years now about this time of year I have made a New Years
resolution to do the .OFX imports and reconciliation monthly. So far
it's still an annual event. I've gone so far as making a recurring
calendar event... electing to feel guilty when I ignore it.
It pays to assign the second
accounts carefully during the import process as that trains the account
I've been moving many of the vendor like ebay and amazon transactions to
an 'UnAccounted for YYYY' account for further editing adding a memo of
what the transaction purchased was soap, transistors, hard drives...,
it's not possible (?yet? feature request) to add memo at import. Plus I
have a small business in my GNUCash memorized transactions won't be
accurate as many purchases from a single vendor can go to similar
accounts for personal or business. I have had best intentions to stop
using my custom UnAccounted YYYY approach in favor of training the
unknowns into Imbalance-USD which would save me some time in the importer.
I do have many repeatable matches trained for utilities, streaming,
movies and such that don't have duplicate business and personal accounts.
- Jeff
matching process. Import to the Imbalance account and then assigning
transactions to different accounts post import does not train the
system. I only have to assign a few transactions each monthby hand now
as the imort matching mechanism is well trained and recognizes what
account most transactions should be assigned to. It also pays to check
that any autoimatically assigned accounts are actually correct.
On Mon, 2026-01-12 at 09:30 -0800, Jeff Albrecht wrote:
I suspected as much. However in my attempt to keep the original
posting
short and concise I omitted the fact that there appears to be may
duplicate transactions perhaps from incomplete pattern matching
during
the import of the checking account and the newly created money market
account.
Can I delete the entire Money market account, re create and re import
the .OFX file? What effect will that have on matching transactions in
other existing accounts.
- Jeff
On 1/12/26 9:15 AM, John Ralls wrote:
Jeff,
Deposits to asset accounts *do* go in the debit column and
expenditures go to the credit column.. You’re confused by your
statements which report your account from the credit union’s point
of view where your account is a liability—they owe you the money.
Please study the first chapter of the Tutorial and Concept Guide to
get a basic understanding of the principles underlying GnuCash. We
always recommend supplementing that with a basic accounting text
for better depth.
Regards,
John Ralls
On Jan 12, 2026, at 08:55, Jeff Albrecht<[email protected]> wrote:
Hi GNUCash users,
(some list members may remember a recent question I had about
merging .OFX before import. All the .OFX files were created by
the cu. The merge experiment, tabled, never touched my books)
I opened a money market account at my Credit Union (cu) in 2025.
While importing the entire year of transactions for the new
account and others at that same cu via a .OFX import I have
mangled my books.
My cu accounts are Assets:CurrentAssets. I believe when asked
during the import I attached the transactions to a single
existing 0 transactions empty Assets:CurrentAssets emtpy Money
Market account created from my original import from Quicken or
from GNUCash..
A transaction report shows what appears to be many (?all?)
deposits in the Debit column while many expenditures appear in
the Credit column. Possibly wrong account type specified during
account creation? Unlikely but possible. I'm no GNUCash power
user but I have been using it for seven or more years. Can the
account type be changed one created and entries added?
Can I delete the entire Money market account, re create and re
import the .OFX file? What effect will that have on matching
transactions in other existing accounts.
Restoring a backup from prior to the input is possible but I
would loose hundreds of transactions memo details that are not
included in the .OFX entered painstakingly over the course of a
day of data entry (ebay amazon etc. item details)
Hoping for some insight and possible fix,,,
_______________________________________________
gnucash-user mailing list
[email protected]
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
[email protected]
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
[email protected]
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.
