Forum Discussion

Togotong's avatar
Togotong
Member
6 months ago
Solved

Can myob allow us to select several types of reports and export them to one excel file but display them one by one in separate worksheets?

For example, if I wanted to generate and export a balance sheet, profit and loss account, and trial balance 3 reports to excel, if I wanted to get a 3-sheet excel workbook outcome showing the above bs, pl, tb download version separately for my easy checking, how should I do❓

 

I think it would be very time consuming if i have a lots reports to insert into the workbook one by one.

 

Thank you

  • Hi @sasasasaT

     

    That certainly sounds like a handy feature, there isn't any feature right now that can export a bunch of different reports into one Excel file with separate sheets. Each report gets saved as its own file. There is a way to use Excel to pull info straight from MYOB, but it won’t pop all your different reports into a single workbook for you.

     

    If this is something you reckon would be handy, chuck it on our Ideas Exchange board. That way, others can vote for it, and it might get picked up in the future.

     

    Regards,

    Genreve 

1 Reply

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    6 months ago

    Hi @sasasasaT

     

    That certainly sounds like a handy feature, there isn't any feature right now that can export a bunch of different reports into one Excel file with separate sheets. Each report gets saved as its own file. There is a way to use Excel to pull info straight from MYOB, but it won’t pop all your different reports into a single workbook for you.

     

    If this is something you reckon would be handy, chuck it on our Ideas Exchange board. That way, others can vote for it, and it might get picked up in the future.

     

    Regards,

    Genreve