How to separate debits and credits on Balance Sheet report

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.

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!

Thanks for your quick response and for the additional information. Very helpful.