[GNC] what is best reconcile/update procedure?

[arthur brogard]

i just keep personal books for the family.
my update and reconcile procedure works but is a bit tedious.  I can't think of any better way and I doubt there is one but i thought it might be good to ask.
At sort of almost random times I decide to update the books.  So I download from CBA transactions from the bank accounts.
then I put them in a spreadsheet.  in date order.
then I inspect and compare with a transaction report from gnu cash - one for each account - and identify transactions not yet in gnu cash.
delete all but those from the spreadsheet.
sort on description.
attach a fourth column for target account.
import to gnu cash.
that's the update
balances should agree.  that's the reconcile.
all that downloading, spreadsheeting, sorting blah, blah.....  any better way or that's just it?