Skip to main content
Barbie7
Mar 14, 2022 3:57 PM UTC
Solved

How to separate debits and credits on Balance Sheet report

Original commenter did not share additional details
BigRedConsulting
BigRedConsultingAnswer
Mar 14, 2022 4:13 PM UTC

There isn't a way. Balance sheets don't do that.

View in thread

5 replies

BigRedConsulting
BigRedConsultingAnswer
Mar 14, 2022 4:13 PM UTC

There isn't a way. Balance sheets don't do that.

    mv32
    Mar 14, 2022 6:46 PM UTC

    Hi @Barbie7.

     

    I also agree with BigRedConsulting's answer. In the meantime, I suggest running the Balance Sheet Detail report, then remove the column for debit and exporting it to Excel.

     

    Then go back to the Balance Sheet Detail report and customize it again to remove the credit column, then export it to Excel.

     

    Here's how:

     

    1. Go to the Reports menu and then select Company & Financial.
    2. Choose Balance Sheet Detail report.
    3. Click Customize Report.
    4. Under Display, enter debit or credit in the Search Columns box.
    5. Uncheck Credit or Debit.




       
    6. Click OK.
    7. Once done, click the Excel button.

     

    I've added some screenshots for visual reference:



     

    For your reference about filtering and removing columns from your report, feel free to read this article: Customize reports in QuickBooks Desktop. This covers guides for running reports like combining them from two or more company files.

     

    In addition, you might want to filter, sort, or total reports by class in the future.

     

    Please feel free to reply to this post if you need anything. I'm here eager to help you! Keep safe.

    Barbie7Author
    Mar 14, 2022 7:42 PM UTC

    Thank you for your reply. So when all that is done that you suggested will it show as follows: The following is an example how it is shown at another computer that I saw - the last 3 columns:

     

                                                                                                                               Debit     Credit      Balance

                         Deposit                                                                                                       200.00      200.00

                          Payment                                                                                    200.00                          0.00

     

    Usually it is shown as                                                                                                                            0.00

                          Deposit                                                                                                                        200.00

                          Payment                                                                                                                     -200.00

                                                                                                                                                                     .00

     

    These are current liabilities for a non-profit organization where money comes in for projects and then it is disbursed accordingly.

     

    Thanks!

     

     

     

     

     

     

     

    Terms & ConditionsAccessibility statement