Forum

First Previous - Page 1 of 1 - Next Last

Excel Report Help

  • Student
  • 59 posts
  • # 117743

I have a potential client who has a few properties rented out. They require a monthly report with a P&L for each property on a seperate page. Whenever an expense item is zero they would like the expense line omitted and all the other expense lined moved up so there is no gap. Is this possible in Excel? If not is there a report writing software that would do this with a feed in from Excel?

Thanks
accountsforme
  • Fellow PM.Dip
  • Practice Licence
  • 225 posts
  • # 117744

Rather than using Excel and wasting a ton of time. Use Xero. Use the Xero tracking to track the income and expense of each property. Then each month do a report on each property individually, based on tracking. Job done.

I do this with a client who has 100+ properties and we can give him a P&L for each property, every month.
First Previous - Page 1 of 1 - Next Last
loading