You’re offline. This is a read only version of the page.
Announcements
303
Hi, I am not sure if this is possible, just wanted to get some ideas.
We have a few clients that have struggled with keeping their MR up to date as they enter new accounts.
For reports that pull a summary amount, this isn't a problem. Something like Cash will be a line that pulls in account 1000-1999.
But on a detail report, they will have cash and underneath it they will list each account out individually. They struggle to keep these updated as they are adding new accounts as they have several different types of reports and how they like to reflect the data, so each one has to be individually updated if it shows the accounts by line. Is there any way to have a line that pulls in a range of account like 1000-1999 but breaks it down in the report so that any account that appears shows as an individual line. I know that you can click on the cash line and see the detail but they want a full detail report, not to have to click into each line.
Just seeing if there is any way to make this easier on them.
For our clients we encourage them to include updating rows as part of their new account procedure. They have a matrix where if it is a Balance Sheet account they update their Balance Sheet, Cash Flow, and Trial Balance rows. If it is a P&L account, they update their P&L and Trial Balance rows. There are usually a subset of special accounts that are handled differently based on Cash Flow or other reporting.
As a double-check, at month-end we recommend they include reviewing new accounts as part of their close. SmartList > Financial > Accounts with a favorite that is sorted in descending order based on Created Date is very useful as they know they only have to review the accounts created that month.
What we do NOT recommend is waiting until an account has posting activity to deal with it. (We often see months separating when an account is created and when it is first used. Those are the hardest to track down.)
Finally, we build a reconciliation report in MR so that they have all their control totals (Total Assets, Total Liability, Total Equity, P&L by Department, etc.) that shows the Balance Sheet in balance and tied out to all departmental control totals. They use it to verify each and every report ties to that overall reconciliation report.
For a few clients who only use the Trial Balance reports for the auditors at year-end, we just build them a new row each year where we automatically add all accounts through the built-in MR Edit > Add feature in the row. Copying/Pasting between MR and Excel works great for adding needed subtotals if you want to get fancy.
Side note: There is a very funky default row titled Trial Balance - Default that has a single line (+Account = [*]) that can be used to view the detail (sans any totals). When you the top-level report appears useless but if you drill into it you'll see the account-level report is quite nice.
There's not a way to do this. If they want a line for each account, they'd need to manually add it to the row definition. You could do a range, like you mentioned, or use a wildcard but that would summarize the data on that line. They'd then need to drill down to see the account detail. If they want one line for each account, they'd have to manually add it. There's not a way for MR to automatically do that.
#1
André Arnaud de Cal...
293,302
Super User 2025 Season 1
#2
Martin Dráb
232,114
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
