Question

Statement Writer

Forum|Forum|5 years ago
February 22, 2021
3 replies
55 views

Chart of account in QB is setup with Sub accounts. When pulled to Statement Writer, they are rolled up (combined). When you separate, they become parent accounts and no longer sub accounts with sub totals.

How to fix??

Been on the phone with support over an hour. Still no answer.

QuickBooks Desktop

JenoP

QuickBooks Team

Hi there, azffs_jc.

There's a reporting setting or preferences within the QuickBooks Statement Writer where you can roll up or separate accounts. Go to the The Report Properties pane and click the following options to customize the report:

Roll up accounts: In the statement, press CTRL while selecting the rows you want to combine, right-click to display the menu, then select Roll up Selected Accounts. A small, red Roll up indicator quickly appears for the combined account.
Roll up missing accounts: In the Accounts toolbox, select the missing account you want to add, then drag-and-drop it directly onto the desired row in the statement. The small, red Roll up indicator will also appear for this type of combined account.
Separate accounts: In the statement, pointing to a row with a Roll up indicator will show a list of accounts in the row. To separate them, just right-click the row, then click Separate Accounts.

Let me also share this article with you for more details: Use And Navigate QuickBooks Statement Writer (QSW).

The Community is always here if you need anything else.

A

azffs_jcAuthor

The issue is not that I don't know how to rollup or separate rows, but that when you pull initially, sub accounts are automatically rolled up. When you then separate they do not stay as sub accounts with sub totals, but separate as parent accounts.

I want to keep the format from QB with sub accounts as sub accounts and not rolled up without sub totals.

MarsStephanieL

Level 6

Hi there, @azffs_jc.

Currently, the option for the sub-accounts to show and not to automatically roll up is unavailable. As a workaround, you can separate the accounts in the statement as a primary account.

To do that, you can check it in the Roll up indicator to see the accounts in the row. Then, separate them by right-clicking the row and click Separate Accounts.

If you're not able to separate the accounts, you can check out this article to know the applicable troubleshooting method: Fix problems with Statement Writer.

I'll be around if you have other questions. Don't hesitate to let me know in the comment section. Take care.

Sign up

Login with SSO

Let's get you signed in

Login with SSO