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
Hi MG42,
Sure thing! You can easily change the look and content of existing reports. For example, you can filter the type of information that appears, add more columns and change the appearance. This way you can exclude the specific bank account you don't want to appear in the report and can generate reports separately for different entities. See this link for the complete guide.
Cheers,
Shella
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?
Hi MG42,
Yes, specific filters such as hiding or inserting columns in reports are available in the desktop version. However, when it comes to filtering out specific bank accounts directly within the report filter interface, that's a bit trickier and there isn't a built-in function for that. What you'll need to do is a bit of manual labor—export the report to a spreadsheet, and then you can filter out the unwanted bank accounts there.
Cheers,
Princess
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.
