One Column Account Code

What belongs in each column?

  1. The first column is account number. 
  2. The second column is account description. 
  3. The third column is numerical data.

Note: As there are no separate columns for MTD data and YTD data, any YTD data will have to be pasted into the data column. The YTD data required generally includes balance sheet items and the stock on hand info. If you have two separate MTD and YTD data columns, consider using the Four Column Format.


Saving requirements

This is to be saved as an Excel Workbook file – either xls or xlsx.