Forum Discussion

JunP's avatar
JunP
Contributing User
8 months ago

Export Report to excel, total has no formula

Hi, I need help please. I’m trying to export P&L report from MYOB Cloud version to excel. However when I opened it, the total part has no formula. is there anyway I can export with formula? thank...
Doreen_P's avatar
Doreen_P
MYOB Moderator
8 months ago

Hey JunP,

 

You're right, when exporting reports like the Profit & Loss to Excel, the exported totals come through as static values, not formulas. There isn't a built-in option to export with Excel formulas included. Instead, you can manually add formula in Excel after exporting if you need calculations. It's a bit of extra work, but it gives you full control over how the data is calculated or presented.

 

Cheers,

Doreen

JunP's avatar
JunP
Contributing User
8 months ago

Hi Doreen,

 

Thanks for reply.

 

What if I export it in desktop version, is it the same?

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    8 months ago

    Hi JunP,

    If you export the P&L report using the desktop version, the result will be the same as with the Cloud version, formulas are not included in the exported file. However, once the file is in Excel, you can manually add formulas. 

    Regards,
    Earl

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.