Report filter for Profit and Loss Reports

[P-M]

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

[Tracey_H · Accepted solution]

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.

[P-M]

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.

[Tracey_H]

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.

[P-M]

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.