Forum Discussion

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

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
Contributing User
8 months ago
Hi Doreen,

Thanks for reply.

What if I export it in desktop version, is it the same?
- 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