Issue: 

Difficulty importing Excel files, resulting in errors such as "unbalanced transaction" and other unspecified errors.


Summary: 

Import errors often stem from hidden formatting issues in Excel files. Converting the file to CSV and checking its format can help identify and resolve these issues.


Steps to Troubleshoot Importing Issues:

  • Initial Review:
    • Check the Excel file for obvious errors (e.g., incorrect data types, missing values).
  • Save as CSV:
    • Save the file as CSV (File > Save As > CSV (Comma delimited) (*.csv)).
  • Review CSV:
    • Open the CSV in a text editor (e.g., Notepad).
  • Ensure:
    • Decimal places: Numeric values have the correct precision.
    • Date format: Dates are in the correct format (e.g., YYYY-MM-DD).
    • No extra rows: Ensure no additional rows are present.
    • Consistency: Data appears consistent without misplaced commas or quotes.
  • Import CSV:
    • Attempt to import the CSV file.
    • If successful, the issue was with the Excel formatting. If not, recheck the CSV.
  • Common Formatting Issues:
    • Date format: Ensure dates are consistently formatted (e.g., YYYY-MM-DD).
    • Decimal precision: Check numeric fields for correct decimal places.
    • Hidden characters/spaces: Remove hidden characters or extra spaces.

Conclusion:

By following these steps, you can resolve formatting issues in Excel files causing import errors. If issues persist, contact support with the original Excel and CSV files for further assistance.