1. Home
  2. QuickBooks Discussions
  3. Subtotal on Income Account

Subtotal on Income Account

We have an "Other Income" account that holds interest paid by banks in each of our checking accounts. We implement these as deposits in each bank account. We run profit & loss report and bring up the transaction detail for that account. How can we force a subtotal by the asset account? The goal is to get a single summary number for each bank account of the interest paid during the report period.

In Transaction Detail, I can bring up Modify Report, and I am able to "Sort by" the field named Split, and this at least organizes the interest payments by the bank account, but amazingly I don't see a way to force a subtotal. The "Total by" field doesn't contain "Split" as a possible option.

Is there a way to get what I want here?

Reply to
W
Loading thread data ...

You are correct that totalling by split (bank account) is not possible.

Do you use unique vendor names for each bank? If you do then totaling by Vendor name would give you the subtotals you want.

An alternative would be to create sub-accounts under Other Income representing each bank account. Then you will get your totals by bank directly off of the P&L report.

Reply to
Laura

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.