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
Bank Reconciliation – Default Date for New Transactions
Viewed 1091 times since Wed, Jun 13, 2012
Postponed VAT Accounting
Viewed 114 times since Tue, Oct 15, 2024
Warn if Sales/Purchase Account On-Stop
Viewed 1431 times since Tue, Jun 12, 2012
Nom/CB Accounts File – Item Screen Design - Cashbook
Viewed 955 times since Thu, Jun 28, 2012
Transaction Currency - Nominal - Database Profiles
Viewed 1426 times since Thu, Jun 28, 2012
Reverse Provisionals - Nominal
Viewed 1527 times since Wed, Jun 27, 2012
Multiple Updating – Payroll Update - Nominal
Viewed 1496 times since Thu, Jun 28, 2012
Bank Statement Report, Bank Statement Report (FC) - Cashbook
Viewed 1355 times since Wed, Jun 27, 2012
System Status - Cashbook
Viewed 1382 times since Wed, Jun 27, 2012
Receipt Posting – Advanced Search Options for Sales A/C’s
Viewed 1206 times since Wed, Jun 13, 2012