How do I run an EBITDA report out of Reckon Hosted
I have been asked for an EBITDA report to give someone for the possible sale of a business. Our accountant cant do it (dont ask why not), he has no access to reckon (again dont ask why not) so it has been left to me to figure it out.
I have done a google search and found the following:
Steps to Create a Custom or Standard Report in Reckon Hosted
- Access the Reports Menu: From the vertical navigation menu in Reckon Hosted, click on the Reports menu.
- Go to the Reports Centre: Select Reports Centre from the menu.
- Find a Relevant Report: Browse the available categories to find an income-based report, such as an Income Statement or Profit & Loss report.
- Customize or Create a Custom Report:
- For Existing Reports: Select an income statement report that shows your revenue and expenses.
- For a Custom Report: If you need to build an EBITDA report from scratch, you may need to use the custom report builder to add specific accounts and line items, though this is more complex and often easier to do in Reckon Accounts Desktop.
- Export the Report: Once you have an income statement, you can export it to a spreadsheet file (e.g., Excel).
- Calculate EBITDA in the Spreadsheet:
- Open the exported spreadsheet.
- Find your Net Income (or Profit After Tax).
- Add back your Interest Expense, Tax Expense, Depreciation, and Amortization expenses to the Net Income to get your EBITDA.
But I dont know if this is correct and what it has given me isn't quite right.
Any help would be greatly appreciated.
TIA
Answers
-
Wow … That sounds very (unnecessarily) complicated ! 😯
You can just generate your normal Profit & Loss & Modify Report … on the Filters tab, to include all Accounts aside from Interest, Taxes, Depreciation/Amortization:
Start by ticking all the Accounts (by just clicking the first account at the top, then dragging your mouse down to the end of the list)… then just untick those specific ones you want to eliminate :
TIP: Generate & print your standard Profit & Loss version first, so you can cross-check to ensure you're not missing any accounts (like inactive ones).
Once you have the report configured how you want it, rename it on the Header/Footer tab (under Report Title):
… & Memorise it (so you don't have to configure it again from scratch) ! 😊
2 -
THANK YOU!!!!!! I would never have gotten there. Fingers crossed that they are happy with this otherwise I think I will lose my mind! I will let you know if I need any more help.
Thank you again! Much appreciated
1 -
No problem @Capricorn Stages 👌🏻😊
Yes, let us know how it goes! 🤞🏻
1





