Column headers
is there a way to change the column headers within Hosted or do you have to amend the Excel file every time. ie P&L budget VS Actual directors want the $ Over Budget to say Variance to Budget.
Best Answer
-
Hi @ShelleyG
The name of the column in the report preference settings is fixed as "% of Budget" and "$ Difference" and cannot be modified within the Reckon Accounts reporting screens.
Unfortunately, if you want "$ Over Budget" to show as "Variance to Budget" then you would need to export the report to Excel, and then modify it in Excel.
Depending on your level of familiarity with Excel, you could consider creating a macro to automate that task of changing the cell containing the text "$ Over Budget" to "Variance to Budget" by recording a text search and replace macro.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
2
Answers
-
This content has been removed.
-
Hi @ShelleyG
You can manage the changes within the Reports itself. As you create a report, clicking on Modify Report will give you an option to select the titles/headers that you want to reflect in the reports as in the screenshot provided below -
I hope this helps you. Thank you!
Regards
Tanvi
1 -
@Tanvi_kataria does your suggestion meet @ShelleyG 's request. It seems to me that you have shown her how to change titles etc rather than the actual column heading
2 -
@Tanvi_kataria thank you for your suggestion, however, I want to change the actual column heading from what Reckon has.
0 -
Column heading $ Over Budget - have been asked to change this to Variance to Budget. I can change it easily within Excel, just have to remember to do it.
1
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 📢 Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 35 📢 Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos 🎥
- 28 Reckon Mate App
- 2.6K Reckon One
- 11 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 22 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 74 About Reckon Community