Hacker News new | past | comments | ask | show | jobs | submit login

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.




How 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.


Using 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.


Still 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-fro...

Apparently not all import assistants do this for some reason.


I 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.




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: