Update to Excel Macro to import IIF transactions

 

A while back I wrote a new macro to import IIF transactions, New Excel Macro to import IIF transactions. Last week I put it to the test and found several bugs. All of the bugs were minor but annoying. They created a lot more work for me but I am hopeful the next time I test this macro, it will save me time. Most of my bugs were spelling issues. I used different spellings on one customer and I forgot to include the group item. Naturally the spellings are very important if you want the invoices to end up with the right customer and account. The sneakiest bug was the one I got when I started a row with TRN rather than TRNS. QuickBooks complained about an out of place SPL row rather than pointing out my transaction should have started with TRNS rather than TRN.