Is there any way to compare suppliers across a number of entities?

Alex Jeffries
Alex Jeffries Member Posts: 20
edited April 2020 in Accounts Hosted
I have a large number of entities that I run through reckon hosted, they are all similar and have similar suppliers.
Is there any way I can get some sort of report listing supplier expenses across all the entities? Or do I have to open each individual entity and do the report? 
Thanks

Comments

  • Shannon Sciuto
    Shannon Sciuto Member Posts: 98
    edited February 2018
    Hi Alex, 

    Not exactly sure what you mean by supplier expenses - are you referring to your cost of goods sold? 

    You can combine reports from multiple company files to generate a P&L, Balance Sheet or Trial Balance.  If the transactions you're referring to are listed as separate accounts then this might be the way to go. 

    Go to Report > Combine Reports from multiple entites. 

    Choose the report and date range and then combine in excel. 

    I hope this helps!! 

    Shannon. 
  • Kwikbooks (Professional Partner)
    Kwikbooks (Professional Partner) Member Posts: 824 ✭✭✭
    edited April 2020
    Are you talking entities as in businesses, and are the run in separate reckon files or are they run through one file with classes for each
  • Alex Jeffries
    Alex Jeffries Member Posts: 20
    edited January 2016
    They are run in separate reckon files
  • Kwikbooks (Professional Partner)
    Kwikbooks (Professional Partner) Member Posts: 824 ✭✭✭
    edited December 2016
    ok you will have to open each entity and produce a report - but, if you export the report to spreadsheet, you will be able to cut & paste columns from each report to make one multi column (multi entity) report to compare each entity.

    obviously you would have to run the identical report from each entity once you have  the reports the way you need them by filtering, then memorise the report for future reference.
  • Alex Jeffries
    Alex Jeffries Member Posts: 20
    edited February 2016
    Thank you