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 youP-M

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.

Report filter for Profit and Loss Reports

Tracey_H
Former Staff
3 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
  Contributing User
  3 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
    Former Staff
    3 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
    
    Within the AccountRight desktop copy of the file, go to File>>Import/Export Assistant
    
    Choose Export Data>>Accounts- Budgets
    
    Select to separate data using Commas
    
    Select the required fields you wish to export
    
    Once you have completed that export, you would open the file in the browser.
    
    Select to Reporting>>Reports>>Budget management.
    
    Choose Create Budget
    
    Enter the desired information.
    
    Select Export to CSV.
    
    Open both exports in Excel
    
    Manipulate the export data from the AccountRight file to populate the Browser export
    
    Once the data has been popluated, save the browser export.
    
    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.

Forum Discussion

Report filter for Profit and Loss Reports

Looking for something else?

Related content

Reports Filtering in Excel

GST report

Custom reports

unpaid Bills / unpaid Invoice Report - Reporting error

Superannuation Reports

STP reporting

Customer transaction report

Filter a sales report by data entered into the Comment Field