I need help creating an income statement that shows a separate column for each different company file we have set up in Sage 50 Accountant US. I have tried setting up a Consolidated Company, but that did not keep data separate for the individual companies. Is there a way to use Intelligence Reporting to create just a report?
There are several ways to accomplish this with Sage Intelligence.
First, watch this short video on how to quickly consolidate companies with Sage 50 US.
Second, watch this short video on how to make simple financial statements in Excel with Sage Intelligence.
Finally, using your Excel knowledge and the tips in the second video, you should be able to create a report with income statements for multiple companies.
If you're not sure how to put it all together, feel free to email me at firstname.lastname@example.org.