4 ms·
Importing records in GnuCash is a pain. Credit card payments end up with two records of the payment, one from the credit card and another from your bank. Ther
by pstrateman 6y ago
Importing records in GnuCash is a pain.
Credit card payments end up with two records of the payment, one from the credit card and another from your bank.
There's no way to merge records in GnuCash, ideally you would be able to mark them as the same record, but keep them both to keep the import logic happy.
- jldugger 6y agoHow are you doing this? The OFX import tool has a bayesian matcher that will update and reconcile existing records, and classify them based on past behavior. The big challenge IMO is that each transaction has a date, but sometimes the ends disagree on when it happened. E.g. you transfer money from checking to a brokerage, it takes multiple days but you have to choose one date for that transaction.
- pstrateman 6y agoUsing the import tool it identified them as separate transactions... which they kind of are. They're separate records whichiwould like to keep... but as a single merged ledger entry.
- jldugger 6y agoStill not sure I follow. If I make a payment on a credit card, it shows up as a transaction from asset checking account to the liability credit card. It shows up on both accounts already. When I later import OFX transaction files, it sees the payment in the OFX and matches it up to the existing transaction: https://lists.gnucash.org/docs/C/gnucash-guide/importing-from-files.html#importing-matcher https://lists.gnucash.org/docs/C/gnucash-guide/importing-fro... Apparently not all import assistants do this for some reason.
- brewdad 6y agoI manually input my checking account since it is almost entirely payments towards other GnuCash accounts. When I import the credit card payment from my CC company, GnuCash matches the OFX payment record with the existing entry and automatically reconciles it. So I don't get double payments.