How do I correct AP Invoice import batch error. The document total amount does not match payment schedule amount.

SOLVED

I keep getting error which prevent importing of Invoice Batch created using in Excel 2007 template. "The document total amount does not match payment schedule amount. Correct            05:15:30 payment amounts in the schedule". I have populated all necessary columns exactly as in the original template.