I want to start using the AP Import Invoice task under Tools.

We have 300-400 CC transactions to enter and are hoping to use this tool.  Does any one use the feature "Import Invoices" under the AP-Tools?  I need a solution to import our credit card transactions from our bank website.   The bank can provide the output template.  I am just not sure what the import needs to look like and if it can be done in Excel?