Why can't I import an older invoice?

If you tried to import historical invoices and got an error message like the one below, there is likely something wrong with your spreadsheet. 

Check for the following:

• Rate x Quantity is equal to or less than your Total Amount. 
• That you have a currency selected in the settings section of the app. 
• You are not using commas in your currency amounts. 
• If your invoice is not paid and you have selected N in the Paid Y/N column, make sure there is no paid date populated in the file. 
• If the invoice is marked as paid and you have selected Y in the Paid Y/N column, make sure you have a paid date populated.