When converting a spreadsheet to import your company accounting records, be sure to include a column for the following as they are required to complete your trial balance import:

• Account name or description
• Debit 
• Credit

You will also want to adjust all accounts for tax purposes and ensure debit and credits are balanced prior to importing the trial balance report. Below is a sample trial balance report.

Spreadsheet to .CSV Conversion

To convert a Microsoft Excel file to .CSV format:

1. Go to File
2. Click on Save As
3. In the Save as type select CSV (comma delimited)

To convert an Open Office spreadsheet file to .CSV format:

1. Go to File
2. Click on Save As
3. In the Save as type select Text CSV (.CSV)