nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Report Format Wrong! when exporting (BS,PL with Account Number) to Excel

EEAD

When exporting BS and PL with Account Number to Excel, a column pops out of the report frame and looks bad. (i.e. one column data is shown outside of the format frame.)

Exporting to PDF looks fine though.

It is appreciated if someone could tell me how to fix this.

I can edit excel file in cell formatting etc but it is time consuming and this must be casued by MYOB system setting bug.....

Picture2.jpg

Picture1.jpg

Find more posts tagged with

Accepted answers

Mike_James

Hi @EEAD , the template for the P&L with YTD report is plytd.xlt, and on my system is located at C:\Users\<windows user>\Documents\MYOB\AccountRight\Current\Reports\Spreadsheet. (Windows user is your windows login name). Make a copy of this file before you proceed.

The original template can be opened (from within Excel so as to edit the template, not create a new workbook) and can have a column added after column B. I also formatted columns B & C as text, although only the cells in row 12 need to be formatted, as that row expands as data rows are added.

Once you have displayed the report in MYOB, added account numbers, and re-displayed the report, export to Excel and the report then fits the amended template correctly. Save the report (in MYOB) as a custom report to avoid having to add the account number column each time.

All comments

Mike_James

Hi @EEAD , this happens because the Excel template is designed for a report that has no account numbers.

A possible solution is to locate that template, and insert a column at or near the front, then see how the export looks.

I'll test this on my system tomorrow.