Kevin_C
Moderator

Payments

You're on the right track, @blambert5. I can see it's quite confusing, but I’m here to shed some light on handling your ACH payments in QuickBooks Online (QBO).

 

First off, it's correct to directly categorize the bank deposit transaction from the Banking page to the appropriate income account. Furthermore, you don't need to generate another bank deposit for it, as it will double your income. Other advice with handling your ACH payments in accounting would be best if you talked with your business accountant for accurate reporting.

 

Based on your statement, I take it that you're trying to run the Sales by Customer Summary or Sales by Customer Detail report, which allows you to view the total sales made for the specified period. However, it will only display specific sales transactions that affect product/service items. Sales transactions, namely invoices, sales receipts, and credit memos.

 

To get detailed information about your income for each of your customers, I suggest running the Transaction List by Customer or Profit and Loss by Customer reports. Here's how:

 

  1. Go to the Reports menu and look for the Transaction List by Customer report.
  2. Choose the Report period appropriately.
  3. Tap Filter and pick Customerequals your Client.
  4. This will display all of their related transactions, and you can click Save as for future use.
    c14f41a4-e529-47b9-ad4f-b264dcfbd79c.default.png

 

Another option you can utilize is to pull up the Profit and Loss by Customer report to see the detailed income and expense balances of a specific customer. You can click Customize and Filter it to view transactions for a specific customer.

d74e015e-3d57-4f86-95a3-b1f5d6b1f320.default.png

 

Moreover, you may also visit this article to learn more about tailoring your reports, displaying particular accounts or customers, and configuring the layout for precise data placement: Customize reports in QuickBooks Online.

 

Just get back to me if you need further assistance, as I want to make sure this is resolved for you. Have a wonderful day ahead!