I'm using Gnucash. I'd like to create "virtual subaccounts" for my debit account to keep track of expenses.
E.g: debit account --> groceries
Regular "virtual payment" to groceries every month
Automatically assign new transactions with e.g. the word "Walmart" in the Description to groceries and subtract the amount from the "groceries"-account.
What I've tried in GnuCash:
I successfully imported csv transactions from csv
I assigned the bulk to the debit account
I assigned individual transactions to liability accounts in expenses during import
GnuCash seems to do what I want, but it always wants to reconcile payments and mixes up new transactions with old ones randomly during import. Also I have to delete transactions one at a time, when I've made a mistake during CSV-importing.
Is there a way to get Gnucash to do what I want?