Excluding bank accounts from reports
Client has years worth of data in a single MYOB file with separate entities which are differentiated by different bank accounts. Is there ANY way of excluding a bank account from a report so I can do...
Forum Discussion
Thanks Shella,
I'm not seeing any way to filter or any addable columns to do with bank accounts. Is that perhaps a feature available only in the desktop version?
MYOB reporting functionality isn't very good - best to download everything into Excel and create your reports from there. Extract the data using a trial balance report, and then create your desired report that pulls the required data from the trial balance. It can be quite complicated as often MYOB won't put the GL Account Codes into a separate column, but combine them with the GL Account Name, which is a pain, as you need to use a TRUNC formula to separate out the GL Account Code as a first step. Then you can create reports using the VLOOKUP function, using the GL Account Code as your item to search & match on.
