When you're creating an import file to import data into your software, use our Excel templates. They give tips for each column, with required fields in blue and optional fields in yellow. 

To access the templates: 

1. In Sage 50 Accounts, go to File, then select Import.  
2. Select 'here' on the Welcome window.

Use our import templates and their format rules article for more information.