Spending report in 2013 Personal that includes categories with zero spending.
John_S
Member Posts: 4 ✭
I want a spending report, by category, that includes categories without any spending. i.e. a zero amount. I cannot find a check-box or option to turn this on. Currently, it only shows categories if there has been a 'spend' in that category. I need this function for when I export to Excel and the number of categories have to be in the list whether zero or not.
0
Comments
-
I don't know of a way of including zero values.
You could try reporting for multiple time periods, this way you will include more items, if they are non-zero for other time periods.
The alternative is to import the reduced table from RPP into excel and use this table as the source of a vlookup into the complete list of items, ie solve the problem in Excel.
John
0 -
Thanks John, I am using the vlookup function to do this in Excel, but it includes an unsatisfactory additional number of steps. With a report against budget it would be good to know where spending has not occurred at a glance, not to mention making it more useful when exporting. Is this just a failing of the 'Personal' edition?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