Forum Discussion

P-M's avatar
P-M
Contributing User
2 years ago
Solved

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

  • Tracey_H's avatar
    Tracey_H
    2 years ago

    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.

4 Replies

Sort By
Replies have been turned off for this discussion
  • Tracey_H's avatar
    Tracey_H
    Former Staff
    2 years ago

    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's avatar
      P-M
      Contributing User
      2 years ago

      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's avatar
        Tracey_H
        Former Staff
        2 years ago

        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.