cancel
Showing results for 
Search instead for 
Did you mean: 
Sherene88
Level 1

QuickBooks Statement Writer - comparative trial balance multiple months

We have Enterprise 2021 (but can upgrade to 2022 or 2023, NP) and haven't used the statement writer.  We need to know if the statement writer will allow us to do a trial balance for multiple months, with only one column for each month (debits a + and credits a -).  Basically, like a balance sheet or income statement for a year or more and totals by month, but all in one with debits and credits plus and minus.  If so, how to install the statement write and how to created the trial balance we need?  Sherene at RCT

8 Comments 8
QueenC
Moderator

QuickBooks Statement Writer - comparative trial balance multiple months

Thank you for reaching out to us regarding QuickBooks Statement Writer and your specific requirements for creating a trial balance for multiple months, @Sherene88. I appreciate your interest in utilizing this feature to streamline your financial reporting. Allow me to share some information and be your assistance in achieving your goal.

 

In QuickBooks Desktop, we can always utilize the QuickBooks Statement Writer (QSW) which is an add-on package for creating professional financial statements that comply with Generally Accounting Principles (GAAP). And yes, we can create customized, professional financial statements from your QuickBooks company. 

 

Here's how:

 

  1. Go to the Accountant menu then select QuickBooks Statement Writer.
  2. Select Design New Report. In the first screen of the Report Designer, select the statements and documents you want for the report and arrange them in your preferred order. In screens 2 to 5, customize the content further. On screen 5, you can save a statement or the entire report as a reusable template. Finally, click the Create Report button when you're done.
  3. In Excel, review the report. Combine or separate any account rows, as needed. To restore the QSW Task Pane in Excel, click the Show Task Pane icon on the Statement Write toolbar.
  4. To modify a statement in the report according to your preferences, you can utilize the various choices available in the Row Properties or Column Properties within the Statement Writer pane.
  5. Customize the look of the report by modifying fonts, layouts, sizes, headers, and footers in the Report Properties. Additionally, include additional statements or supporting documents in the report if necessary.
  6. Save the report.
  7. To print the financial report, save it as a PDF using the Save As option in the Statement Writer menu, and then print the PDF.

 

You can always refer to this article for more information about the QuickBooks Statement Writer: Use and navigate QuickBooks Statement Writer (QSW).

 

Additionally, I'd like to include that we've been receiving significant reports about customers getting an error message about a revoked certificate when using the Statement Writer and other third-party actions. We're currently investigating this issue and have an article with instructions on how to fix it if you happen to experience the problem: How to fix the error QuickBooks- Application with Revoked Certificate.

 

If you encounter the same error after performing the troubleshooting steps provided in the article, I'd suggest getting in touch with our Customer Care Team so they'll include your account in the affected users' list. This way, you'll receive timely email updates on the investigation. You can use this INV number as your reference: INV-91854.

 

Furthermore, here are steps and solutions to fix QuickBooks Statement Writer (QSW) performance issues: Fix problems with Statement Writer.

 

Should you have any further questions or require additional assistance in navigating the Statement Writer, please don't hesitate to reach out to us. We're here to support you every step of the way.

Sherene88
Level 1

QuickBooks Statement Writer - comparative trial balance multiple months

Hi.  Thanks for the quick reply.

 

We don't have the Accountant Menu, as our version of Enterprise isn't the Accountant version.  Is QSW a paid add-on?  How do we get it?

 

Also, what we need is very specific, and not a standard GAAP type report.  We need to be sure it will really be flexible enough to create this trial balance - a single column for all the values for each month (instead of the usual dr & cr columns), and also able to do a time period by month (like the balance sheet or P&L). We really don't want to waste time trying something we know won't work.

 

Thanks!

ReymondO
Moderator

QuickBooks Statement Writer - comparative trial balance multiple months

Thank you for returning to the conversation, @Sherene88. I'm here to participate in this discussion and address your inquiries regarding QuickBooks Statement Writer.

 

The QuickBooks Statement Writer (QSW) is an add-on package for creating professional financial statements. That said, it's already part of the add-on features once you purchase the QuickBooks Desktop Enterprise version.

 

It's possible that your current usage is set to another edition, which is why you're unable to see the Accountant menu. 

 

To make the necessary edition change, you can follow these straightforward steps:

 

  1. Go to File, and select Toggle to Another Edition.
  2. Choose the edition, then click Next.
  3. Select Toggle.

 

For complete guidance, you can check this article: Toggle to another QuickBooks edition.

 

QuickBooks will take a brief moment to adjust and launch in the version you've chosen.


Should you encounter any issues in selecting an edition, or if it's unavailable you'll need, I'd suggest repairing QuickBooks. This will replace any damaged QuickBooks components along with their installation files.

 

If problems persist even after attempting the toggle, consider reinstalling QuickBooks Desktop.

 

Please inform me if these instructions prove helpful and if you have further questions. It's my foremost priority to ensure you receive accurate answers to your inquiries. Wishing you a fantastic day ahead!

Sherene88
Level 1

QuickBooks Statement Writer - comparative trial balance multiple months

Thank you.  We have QB Enterprise, currently 2021.  It is NOT the accountant version.  Toggle to another version isn't a menu option in this case.  

 

 

AlcaeusF
Moderator

QuickBooks Statement Writer - comparative trial balance multiple months

Hello Sherene,

 

I appreciate you for getting back to us here in the Community space. Allow me to chime in and share additional information about the QuickBooks Statement Writer (QSW) add-on.

 

Users using Enterprise Solutions can switch to an industry-specific edition like the Accountant version. You'll see the option by clicking the File tab at the top menu bar, then selecting the Toggle to Another Edition option (see screenshot below).

 

 

The QuickBooks Statement Writer (QSW) is an add-on package available in QuickBooks Premier Accountant, Enterprise Accountant, and Enterprise Solutions. For more information about the add-on, check out this article: Use and navigate QuickBooks Statement Writer (QSW).

 

Also, I have a link here about the steps and recommended solutions that'll help you fix performance issues when using QuickBooks Statement Writer (QSW). For additional reference, check out this link: Fix problems with Statement Writer.

 

You're welcome to post about your QuickBooks concerns in this space. If you have additional questions about QSW, let us know. We'll be here to lend a hand.

Sherene88
Level 1

QuickBooks Statement Writer - comparative trial balance multiple months

Thank you.  I totally get what you are saying.  I have QB Desktop accountant version at home and I can easily toggle.  But we do NOT see this option in the File menu in our Enterprise Solutions 2021.  I even tried single user mode.  See attached screen shot.

 

In any case, I still need to know if the report I need is even possible with QSW or if it isn't that customizable.  The predone documentation ya'll keep sending doesn't answer that question.

LollyNino_C
QuickBooks Team

QuickBooks Statement Writer - comparative trial balance multiple months

Thanks for taking the time to get back to us, and I appreciate you providing a screenshot, @Sherene88. Allow me to provide some insight into your concern.

 

We can utilize the Toggle feature to change the industry type. However, please know that this feature is exclusive to QuickBooks Desktop Premier, QuickBooks Accountant (QBA), Enterprise Solutions Accountant (QBESA), and QuickBooks Enterprise Solutions (QBES) versions.

 

This feature enables you to change your QuickBooks Desktop edition from one specific industry to another. See the list below for the Industry-specific Editions you can toggle from and to:

 

  • General
  • Accountant
  • Contractor
  • Manufacturing & Wholesale
  • Nonprofit
  • Professional Services
  • Retail
  • Pro (not available in QBESA/QBES)

 

For more details about switching to another edition, we can take a look at this article: Toggle to another QuickBooks edition. The same article will give you a reference if you encounter the same issue.

 

Furthermore, here are steps and solutions to fix QuickBooks Statement Writer (QSW) performance issues: Fix problems with Statement Writer.

 

You may be confident that we appreciate your input and are continuously working to improve the program features that our customers can use with QuickBooks. Having stated that, I suggest sending this feedback straight away to our product development team. As a result, they can evaluate and select the features to include for additional product advancements. Here's how:

 

  1. In your QuickBooks account, click the Help option.
  2. Select the Send Feedback Online option.
  3. Choose Product Suggestion.
  4. Enter your feedback.
  5. Click the Send Feedback button.

 

Also, feel free to visit our Feedback forum page to see a list of other QuickBooks users who have already suggested this feature and for the recent updates in QuickBooks.

 

 Drop a comment below if you have any other questions about changing the industry edition of your QuickBooks. I'll be happy to help you out.

SARAASB
Level 3

QuickBooks Statement Writer - comparative trial balance multiple months


I wasn’t able to get the Report writer to do what I needed it to do, so I had a programmer write me a utility. It’s listed on Intuit’s 3rd party add-on site or just google TBX trial balance exporter. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us