Report filter for Profit and Loss Reports

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
P-M
Contributing User
6 Posts
Contributing User
Contributing User

6Posts

3Kudos

0Solutions

Solved: Go to Solution

Report filter for Profit and Loss Reports

Hi

 

Can I please request that the report filter for all the Profit & Loss reports allow you to put a date range in for the report.  Only one of the reports allow you to do this which is the Profit & Loss Statement report.  All the others you just nominate the month.  My company does not run on a calendar month for reporting and therefore I cannot run Actual vs Budget Reports.

 

Thank you

P-M

4 REPLIES 4
Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Accepted Solution Solved

Re: Report filter for Profit and Loss Reports

Hi @P-M 

 

Sorry to see that no one has replied to you yet. Accessing AccountRight in a browser will allow you to filter the P&L by a date range and run Actual vs Budget by clicking on Report options.

 

Please don't hesitate to post again if you need help in the future.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

P-M
Contributing User
6 Posts
Contributing User
Contributing User

6Posts

3Kudos

0Solutions

Re: Report filter for Profit and Loss Reports

Thanks Tracey_H, this is really helpful.  One thing though, I can't seem to select a budget in the Report Options.  I'm able to tick the box for it to be included but there is no budget to select from the drop down.

 

 

Report Options.JPG
Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Re: Report filter for Profit and Loss Reports

Hi @P-M 

 

My apologies for the delay in getting back to you. The AccountRight browser interface does have a slightly different budget setup than the Desktop application. As such, if you have entered the budget data entered into the Desktop it will not flow through to the Browser and vice versa.

In theory, it is possible to export the budget out of the Desktop application in CSV so that it can be manipulated into the required file format for the browser. I've included the steps below:
Note: The below process is complex

  1. Within the AccountRight desktop copy of the file, go to File>>Import/Export Assistant
  2. Choose Export Data>>Accounts- Budgets
  3. Select to separate data using Commas
  4. Select the required fields you wish to export
  5. Once you have completed that export, you would open the file in the browser.
  6. Select to Reporting>>Reports>>Budget management.
  7. Choose Create Budget
  8. Enter the desired information.
  9. Select Export to CSV.
  10. Open both exports in Excel
  11. Manipulate the export data from the AccountRight file to populate the Browser export
  12. Once the data has been popluated, save the browser export.
  13. Navigate back to the browser and import back in using the Import>>CSV option.

Please let me know if you need further help.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

P-M
Contributing User
6 Posts
Contributing User
Contributing User

6Posts

3Kudos

0Solutions

Re: Report filter for Profit and Loss Reports

Thanks Tracey_H

 

I did end up working out that the budget needed to entered into the browers version as well.  I now done that and the reports are working as expected.

 

Thank you for your help.

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post