ToeC's avatar
ToeC
Trusted User
12 years ago
Status:
Done

Report: Balance Sheet - Removal of indentations

The balance sheet reports in AccountRight 2012 have been re-formatted, inserting leading spaces into the account name fields so the fields appear indented when the report is printed.

 

I would like to suggest that there is an option to remove this formatting - in particular when exporting to excel.  I have a number of spreadsheets set up which use lookup functions on the balance sheet to drive reconciliation programs.  I have had to add in formulae to strip out the spaces - which is making the workbooks inelegant and prone to errors.

 

(If this feature is already there could someone let me know where it is - I spoke to someone on the online chat and she didn't know of a work-around.)

 

"Format of Balance Sheet reports"

Accounts
Reporting
  • Dan_Moulton's avatar
    Dan_Moulton
    Former Staff
    12 years ago
    Status changed:
    New
    to
    Open
    Hi, thanks for the feedback, I can see how that formatting is affecting you. I'm interested to hear more from yourself and others about how we format reports in Excel - currently they inherit the formatting of the parent report. Would it be better for Excel purposes if the Excel reports were always in a simple format so that the data could be manipulated more easily?
  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    12 years ago

    Maybe what would work best is to have two "export to excel" options, one for a fully formatted report and one for the raw data, which would probably give you the same as exporting to a tab delimited file then opening that with Excel.

  • ToeC's avatar
    ToeC
    Trusted User
    12 years ago

    I think I would be unlikely to use the 'formatted' excel report - if I wanted to pass somebody a formatted report I would be more likely to export to pdf.  For me the most important change would be to simply remove the leading spaces from the field names.   However, I'm sure that if you were able to provide two excel report options, a fully formatted one and a simple format then that would keep everyone happy.

     

    thanks

    Antonia

  • Steven_M's avatar
    Steven_M
    Former Staff
    7 years ago
    Status changed:
    Open
    to
    Done

    Hi Everyone

    With the release of AccountRight 2017.2 the account number and name indentation on reports sent to Excel have been removed.

    You can find out more information about this and other changes, including information on obtaining AccountRight 2017.2 from AccountRight 2017.2 now available