The transactions are from my Chase bank account which has the fields Date, Payee and Amount.

I am going through and organizing this data and would like to assign an account to each transaction the import it.  That is I would like to map account in Excel to account in Quickbooks and them import the data and be done.  Going though and setting up a couple of hundred import "rules" is something I would have to do if I convert to a QBO file then import that.

Thanks,

Matt