Formatting of exported payroll detail report

Jennie Kemp
Jennie Kemp Member Posts: 35 Reckoner Reckoner
edited July 29 in Reckon One - Payroll Ideas

The formatting for the excel spreadsheet has changed recently.

Column A has been narrowed when downloading, and when expanded, there are too many large and empty rows.

Please correct formatting

1
1 votes

Already Offered ยท Last Updated

Reports can be generated in Portrait or Landscape orientation which can alter the display of reports based on the selection.

Comments

  • Rav
    Rav Administrator, Reckon Staff Posts: 14,208 Reckon Community Manager Community Manager

    Hi @Jennie Kemp

    Can I just confirm, was your report exported in .CSV or .XLSX format?

    The only reason I ask is, when it comes to CSV there haven't been any changes made to formatting recently. The worksheet can be resized by clicking the full sheet then double clicking in between any of the columns. I've put together a quick screen reocrding as an example below ๐Ÿ‘‡

    CSV - Resize.gif
  • Jennie Kemp
    Jennie Kemp Member Posts: 35 Reckoner Reckoner

    Hi Rav,

    Thanks for your response.

    The report was exported as XLSX. When the Pay Detail Report is downloaded, the Pay Item column, column A, is now very narrow. To correct, the column must be widened just to read the Pay Item title, as it is truncated in the narrow column. Each Pay Item is now also merged into two rows. When correcting this format to view the Pay Item, I can hardly fit two employees on one page.

    If you refer to the new report, Employee Earning Summary, it shows the format of the previous Pay Detail Report. One row for each Pay Item, and the Pay Item Column is wide when downloaded in XLSX.

    The example above is for the CSV download, it is the XLSX download I have a problem with.

  • Jennie Kemp
    Jennie Kemp Member Posts: 35 Reckoner Reckoner

    Hi Rav,

    I can see what has happened, it was in Portrait mode, not Landscape.

    It appears OK in Landscape mode.

  • Rav
    Rav Administrator, Reckon Staff Posts: 14,208 Reckon Community Manager Community Manager

    Nice one, good observation thanks for letting me know @Jennie Kemp ๐Ÿ™‚

    I'll update the status of this idea

Categories