How to create report that lists all expenses and income for customer/job. (But not a profit/loss.) More like a check register that lists transactions chronologically.

Thank you so much for your help.  That got me pointed in the right direction.  Your instructions did not match the Quickbooks Online format exactly, but I got the general idea. 

After running the report, I noticed several of the transaction line items were duplicated so here’s some of the additional customizations I did to get the report to look right for our setup. (A simple check-register type list of expenses and payments listed chronologically with a running balance on the side)

1. In addition to the “Customer” filter, I added two more filters. First, the customer payments were showing up multiple times, so I removed the “Bank” transactions.  To do this, I added a filter (“Distribution Account Type” “not equal” “bank”)  Now my customer payments show up just once under Accounts Receivable,  Second, I did not want to see the invoice items and the payments applied to specific invoice items. To do this, I added a filter (“Transaction Type” “not equal” “Invoice”)
2. I clicked on the “Transaction Date” column to have the line items sorted chronologically.
3. I added two columns “debit” and “credit” and removed the column “amount”.  This allowed me to se the expenses and incomes in two different columns.
4. I reordered the columns so the “Transaction Date” was first and then the “Balance” column was last.
5.  I had to make sure the “Accounting Method” on top of the report was toggled to “Accrual” and NOT “Cash”
6.  And lastly, I changed the number format to show negative numbers in parentheses because when I printed the report, the negative signs were showing up below the number despite my attempts to widen the columns.

Thanks again for your help.  I was stuck and your suggestions were a great help!

Hi Rita4MRS, 

Until recently I would have suggested Projects, as I transitioned from Classes (clunky) to Projects (great with a bit of setup) recently and loved it. But QB in their usual idiotic way just made a change that rendered Projects useless. So if you have Classes enabled that’s the way to go, even if the reporting is not very elegant. 

We recommend using Classes for your non-profit committees. While Locations are meant for physical places and Projects are for short-term jobs, Classes serve as permanent categories. They allow you to compare ongoing income and expenses for all your committees side-by-side on a single report.
 

First, you'll want to ensure Class tracking is turned on. Here is how to set it up:
 

1. Go to the Gear icon, select Account and settings, and click the Advanced tab.
2. In the Categories section, select the Edit icon.
3. Toggle on Track classes, and click Save.
    

Next, create a Class for each committee.
 

1. Navigate to the Gear icon and select All lists.
2. Choose Classes, then click New.
3. Enter the fund's name and select Save.
    

Once enabled, a Class field will appear on your transaction forms, allowing you to categorize your entries. To see each committee's financial data side-by-side, simply go to the Reports menu and run a Profit and Loss by Class report.
 

You can visit this article for detailed guidance: Fund accounting for non-profits in QuickBooks.
 

For your memberships, avoid year-based customer profiles, as they create unnecessary duplicates. Instead, you can keep a single profile for each member and use Service items in the Product and Services list to track the payment year. This keeps your database clean and allows you to easily report on yearly totals.
 

If you have additional questions or concerns, you can leave a comment below.