Hi Paul, You're almost there :)
The gnucash importers are not aware of the business features of gnucash unfortunately. So for the importer there are only transactions. It won't be able to offer bills for transaction matching. So after the import (as you did correctly) you still have to manually tell gnucash which payment belongs to which bill. The way to do this is to right-click on the payment in the account register for your bank and then choose "Assign as payment...". This will open up the payment window with all the details gnucash can already extract from the payment transaction. Fill in the missing pieces (at a bare minimum the vendor and the bill you're about to pay) and hit Ok. This needs to be repeated for each imported payment. Regards, Geert Op dinsdag 19 december 2017 10:47:00 CET schreef Paul Neuwirth: > Hello list, > > I am not sure, if I understood everything about book keeping and > gnucash's functionalities. I asked previously on German language list, > and got the tip to ask here. > > What I already did: > > imported extended accounts (according to German standard SKR03) and > laboriously typed in all vendors and bills. But not the > according payments yet. > I hoped, I am able to import the bookings from my bank account > (aqbanking or csv import) und link it to the bills or reconcile. > > Doing this import gnucash does'nt find potential splits matching or > creates many balance splits. I also tried to process payments before > import but also these (same looking) splits cannot be reconciled by > import. > > What is the correct method? > > I would appreciate any help. > > Here I got some screenshots, how I proceed. (If German translation > matters, I can make new ones using English translation): > > > 1) https://www.swabian.net/extern/gncml/gnucash1.png > importing CSV, seperator, date, account etc. are ok. > amount marked as "Deposit" (minus signed ones are withdrawals) > 2) https://www.swabian.net/extern/gncml/gnucash2.png > account matching is also ok > 3) https://www.swabian.net/extern/gncml/gnucash3.png > from last tries gnucash learned to book to > "Verbindlichkeiten" (Account/Payable) > 3a) https://www.swabian.net/extern/gncml/gnucash4.png > If I try to "R+U" (reconcile + update?), gnucash doesn't find matching > splits. > 4) https://www.swabian.net/extern/gncml/gnucash5.png > if I import the bookings as "new", Gnucash correctly books from > e.g. credit card to payable account > > actually ok.. but: > > my basic question > 6) https://www.swabian.net/extern/gncml/gnucash6.png > How do I link the bookings to the bills/payments? > The bills stay due, if I click "process payment" I only can create a > new split, which would look identical to imported ones. > > > regards > > Paul Neuwirth > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > 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@gnucash.org 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.
