Why We Did this
Our users kept telling us that they want to keep doing work inside of the spreadsheet. My advice was to quickly take it OUT of the spreadsheet and into your software of choice like Caseware or QB. That's terrible advice I've been giving. If most of the work is already done inside the spreadsheet we need a way to keep more of it inside of it.
Sometimes you just need a different set of accounts inside the spreadsheet, because not every client was the same, you needed a way to categorize into a new custom account without breaking the overall spreadsheet.
Then there are times that a new account wasn't quite enough or if you did a bunch of work you want to explain in plain words and the spreadsheet is so heavily locked down you didn't have a way to just "talk it out loud".
New Functionality in the ExcelBuilder:
- Custom Accounts creation area: At the bottom of the Trial Balance tab you can add up to 25 new account names as you choose: Custom Accounts
- All the Dropdowns: Once you create a Custom Account you will notice that it automatically becomes created inside of the Dropdown menu we all love. The workflow buckets, Missing Transactions, and the GL Override all have been upgraded to support custom accounts.
- Notes & References area: Anytime you just want to add your own notes you can now just type it out, or a working paper reference, or anything you want, it's an open ended area for anything work related. It's located on the side of each account (including new Custom Accounts).
- Trial balance SUM Totals This has been moved to the TOP of the Trial balance to make it easier for your to visualize. This new Debit Credit Summation factors in ALL of the new Custom Accounts so you never have to guess if your new accounts are working or not.
We have to listen to our users and we always appreciate your feedback. We're building this for you, to improve all professional's quality of life, and this is definitely a quality of life upgrade.