Text files

Printing to file as an Ascii (Text) file



will result in the following file




To convert the .TXT file into an Excel file:
run Excel,
click File > Open,
select the file type,
select the file.



This starts the Text Import Wizard


Select 'Fixed width'



Scroll the trial balance to display the Total row to help you specify the column breaks.
Move the break lines
at the end of the account numbers,
at the beginning of the account titles,
before the first digit of the Debit Total, and
at the end of the last digit of the Debit total.



Use the default general data format and click Finish




The following excel sheet is generated




Edit the sheet to remove extraneous rows (headers, footers, titles, page numbers, etc.) and extraneous columns, and to fix columns width.




When you're done editing the sheet,
click File > Save As
select the .xlsx file type
click Save.