filtering by project with budget as comparison

treasurer
treasurer Member Posts: 12 Reckoner Reckoner
in Reckon One

I was having issue with P & L reports by project where it displayed results for all, not just selected project. That has been fixed but now if I try to select one project with a comparison set to budget (for the same project) The report shows data of other projects as well.

Is there a way to fix this ?

thanks

Comments

  • John Angelico
    John Angelico Member Posts: 23 Reckoner Reckoner

    That would require a new feature, afaik, for Budgets per Project.

    My current understanding is that budgets are per time period ie. months of the financial year

  • treasurer
    treasurer Member Posts: 12 Reckoner Reckoner

    I can select report for ytd for specific project & seem to have the option to compare by budget for the project for the same period so isn't that an existing feature? & that still doesn't explain why it then shows data for other projects.

  • John Angelico
    John Angelico Member Posts: 23 Reckoner Reckoner

    Yes, the report appears to allow for budgets by project, but the way you enter a budget is only for a time period.

    If you have two projects live, say from Feb to June, the budget to be entered against those months would include expenses for both projects plus your overheads, and project revenue of course, as well as income from other sources.

  • Rav
    Rav Administrator, Reckon Staff Posts: 14,052 Reckon Community Manager Community Manager

    Hi @treasurer

    We've run a quick test and in our case it seems to be working expected.

    For example, I created 2 new projects, added an invoice and a bill assigning values to them, created a new budget then ran the P&L.

    • Filtering by project 1 (no comparison) showed only project 1 values
    • Filtering by project 2 (no comparison) showed only project 2 values
    • Filtering by project 1 with budget comparison showed only project 1 actuals vs budget totals
    • Filtering by project 2 with budget showed only project 2 actuals vs budget totals

    If you're not experiencing the same behaviour as above, can you please provide more information on what you're seeing with a clear example.

  • treasurer
    treasurer Member Posts: 12 Reckoner Reckoner

    We have a project "youth" & a YTD report with no comparison period shows as follows:

    image.png

    if I go back & select comparison with budget, for same period, I get this:

    image.png

    As you see, I have expenses showing for items which are not part of the project selected.

  • John Angelico
    John Angelico Member Posts: 23 Reckoner Reckoner

    @Rav I believe this shows the point I was making that budgets are entered in R1 per period (ie. month by month) rather than per project. @treasurer is asking for a feature which doesn't appear to be available: budgets by period AND project.

  • treasurer
    treasurer Member Posts: 12 Reckoner Reckoner

    Yes that is what I was hoping for, it would seem like a useful feature.. I should add that I am engineer not an accountant

    Thanks

  • treasurer
    treasurer Member Posts: 12 Reckoner Reckoner

    I notice that classifications are now a feature, would "by classification" rather than "by project" be a better way of reporting ?

  • John Angelico
    John Angelico Member Posts: 23 Reckoner Reckoner

    The key question for you remains how are the budgets loaded?

    If there is no way to load a budget to match your project or classification reporting needs, using classification won't get you any closer to your desired report.

Categories