Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Column Headings for Financial Summaries Spreadsheet Output

Datafile Software

Column Headings for Financial Summaries Spreadsheet Output

When you output a ‘full-mode’ financial summary to Excel/OpenOffice the system uses the balance item as the column heading. However, for special balance items 99, 100 and 101 the system uses a generic ‘User’ title as the column heading. New in Release 6.6 is the option to record a title to use for the column heading on spreadsheet output.


To set the title to be used you need to update the Financial Summary Definition. Select the Nominal Ledger option from your main menu followed by Financial Summaries and then press the <F7-Option> key to open the summary designer. Select the full-mode summary to update and then select the Parameters option from the main toolbar when the summary is displayed.

When you set/confirm balance item of 99/100/101 a pop-up is displayed asking for additional parameters and this pop-up includes the prompt ‘Col Heading for Excel’ which can be set as required.


Custom Fields
  • Release ID: 6.6
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
FULL – Maintain Accounts in Full - Nominal
Viewed 1272 times since Wed, Jun 27, 2012
Account Audit Trail, Account Audit Trail (Currency) - Cashbook
Viewed 1535 times since Wed, Jun 27, 2012
Audit Pointers - Nominal
Viewed 2676 times since Wed, Jun 27, 2012
Report Account Status - Nominal
Viewed 1563 times since Wed, Jun 27, 2012
VAT Form 100 - Cashbook
Viewed 2128 times since Wed, Jun 27, 2012
Journal Listing - Nomimal
Viewed 1563 times since Wed, Jun 27, 2012
Provisional Journals - Nominal
Viewed 1549 times since Wed, Jun 27, 2012
Full Mode Financial Summary Definition - Nominal
Viewed 14378 times since Wed, Jun 27, 2012
Commented Items Listing - Cashbook
Viewed 1587 times since Wed, Jun 27, 2012
VAT Adjustments - VAT on Imported Goods
Viewed 4716 times since Fri, Oct 12, 2018