How do I split the account number and account description in a leadsheet?

By default, the account number and account description are grouped together in a single column in your leadsheet. However, you may choose to split these up. To do so, right click on the column heading in your leadsheet and select Reorder Columns. In the Reorder Table Columns dialogue, select Account No (Account) and Description (Account) from the Hidden Columns section and move to the Active Columns section by clicking on the left pointing triangle. You can choose to reorder the positioning of each column in the Active Column section.

Then move Account (Account) to the Hidden Columns section.
Click OK to confirm your column ordering.
Once this is done, the Account Number and Account Description information will be separated into 2 columns when saved as an external file (e.g. selecting Save As | Excel File... to save the Leadsheet as an Excel file).

Attached Files
There are no attachments for this article.
Related Articles
Applying Foreign Exchange in Financial Statements
Viewed 6110 times since Thu, Jun 12, 2014
How to add Decimals into Financial Balances?
Viewed 1351 times since Thu, Jul 27, 2017
How do I add a note reference on a subtotal row?
Viewed 1795 times since Thu, Sep 24, 2015
How to Manually insert Map Numbers for a Mapped Line Item in Tables
Viewed 2912 times since Fri, Jun 13, 2014
What is the Context Sensitive Tab?
Viewed 4223 times since Tue, Jun 17, 2014
MENU