how do I turn P&L Budget Performance data into line graphs?
Meaghan_9243131
Member Posts: 1 ✭
I'm using Reckon Hosted.
After reconciling at the end of each month, I need to report graphically on our budgeted Vs actual income and expenses for the year (each month the ‘actual’ line will creep further along the graph).
I can export the P&L Budget Performance report as an Excel spreadsheet, however I'm not sure how to then convert this data into graphs for each of the major budget categories.
Any ideas?
After reconciling at the end of each month, I need to report graphically on our budgeted Vs actual income and expenses for the year (each month the ‘actual’ line will creep further along the graph).
I can export the P&L Budget Performance report as an Excel spreadsheet, however I'm not sure how to then convert this data into graphs for each of the major budget categories.
Any ideas?
0
Comments
-
Hi Meaghan,
You will need to export you reports to Excel and create your graphs in Excel as Reckon Accounts doesn't have this feature in reports.
You can find some graphs in the company snapshot, but for ones other than this, the only way is in Excel.
Regards,
Shane.0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community