An unreadable journal file may have an unsupported extension, incompatible text encoding or no usable rows. The importer accepts nonempty UTF-8 CSV and TSV files. Renaming an Excel workbook to end in .csv does not convert its contents.
Open the original spreadsheet in your spreadsheet application and use its export or save-as function to create a UTF-8 CSV or TSV. Include the four supported journal columns. Then return to Import journal lines and choose the newly exported file.
If the message says the file changed while reading, select the completed file again after saving it. Avoid exporting over the same file at the same moment the browser is reading it. Keep a stable copy for the validation step.
When the file loads, inspect any descriptions with accented characters and verify that account codes remain intact. A successful decoding result only establishes that the text can be read. Account matching, line structure and exact debit-credit balance are checked separately before the rows can be applied.
Was this article helpful?
Tell us whether this answered the question you came with.