cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
Level 2

I can't find a report that shows a summary of all account activity, income/expense and transfers

To clarify, I have 4 bank accounts.  My predecessor created 4 "companies" and therefore I am having to logout/login between each bank account separately, very annoying.  I couldn't get the transaction copier to work, I just tested the trial, so i am going about starting the bank accounts fresh on the "company" file that is the largest, if this makes any sense to you.  That being said, now for my question.  I work at a church/school.  My pastor has me print off the Custom Summary Report, which I found out is pretty similar, if not the same as the Profit/Loss Report, for each "Company" or bank account.  When i had all 4 accounts listed as companies, I could do this easily.  The biggest thing I had to do, which was the most annoying aspect of it all, is when I transferred money between accounts, I had to record the deposit in the School account, then logout, and into the Church account, and then record the withdrawal.  Both, of course, were listed as "income" and "expense", thus it showed up on the Custom Summary or the P/L Reports.  

 

Now, my dilemma.  I have moved the bank accounts all under one "company" file, and can easily record the bank transfer between accounts, that's so much easier to do than I had before.  Problem is, my pastor wants that Custom Summary Report for each account separately.  I can run the report, but now, the transfer isn't listed as "income" or an "expense", thus, it doesn't show up on the report.  My P/L report, or whichever report I end up using has to match the Ledger, or they won't balance.  Does this make any sense to any of you?  

 

I say all of this, to ask, is there a report that can show the summary of accounts, showing income and expenses, but also records the bank transfers?  So, at the bottom it shows Net Income, but also shows if I transferred $1000 between accounts, it'll show a +$1000 or a -$1000 on the other account?


If not, I'm at a loss, there has to be a way to give my pastor a summary of the accounts, that shows all money in and out of the bank account, whether it's income/expense, or otherwise.

5 Comments
Highlighted
Moderator

I can't find a report that shows a summary of all account activity, income/expense and transfers

Hi, Chadster. 

 

You may consider running a Transaction Detail by Account report. It'll show all the expense/income accounts.

 

Let's customize this report, please follow these steps:

 

  1. Click the Customize Report button.
  2. Select Filters.
  3. Click the drop-down arrow from the Account field to select All bank and u/f.
  4. Click OK.

 

 Please take note that this is a detail report which shows all the account transaction by company. You can take a look at the screenshot below:

000.PNG

 

Please let me know how this report works for you. I'm always free to help you.

Highlighted
Level 2

I can't find a report that shows a summary of all account activity, income/expense and transfers

I tried that one before as well, that basically is another way of looking at the bank ledger, really.  It gives much of the same detail.  My pastor enjoys the layout of the custom summary.  See screenshots below.  It shows the accounts in detail and is much easier to decipher than just a simple transaction report.  

 

I just saw online that there is a QB Premier that has a nonprofit section.  Do you think this would be advantageous to my situation?  It says they have reports directed at nonprofit specifically, was wondering if that might be an option as well.

Highlighted
Level 2

I can't find a report that shows a summary of all account activity, income/expense and transfers

Not sure if that link above is working, I cant figure out how to do the screenshot from my pc.  I used snipping tool, and saved it then used the browse below to insert, but it's not opening up right now.  Anyways, I guess I can't post a screenshot like you did above.  But, I'm sure you get the idea.

Highlighted
Moderator

I can't find a report that shows a summary of all account activity, income/expense and transfers

Thanks for getting back to us, Chadster.

Allow me to take over and help you with generating a report that shows all the account activities via QuickBooks Desktop.

 

I appreciate the screenshot you've provided. If you're using QuickBooks Premier Nonprofit Edition, you should have the option for Nonprofit Reports on your QuickBooks. You can pull up and run the Statement of Financial Income and Expense report.

 

Here are the lists of reports for QuickBooks Nonprofit:

 

z.PNG

 

You may find these articles helpful:

 

For additional help, you can also reach out to our QuickBooks Desktop Support.

 

  1. Within your QuickBooks Desktop, click Help at the top menu bar.
  2. Click Contact us.
  3. To route you to the correct support expert, we need to know what type of question you have. Give a brief description of your issue and click Continue.
  4. We’ll provide you a few options. You choose which one is best for you.

Should need more help in generating QuickBooks reports, don't hesitate to let me know. Have a good one.

Highlighted
Level 2

I can't find a report that shows a summary of all account activity, income/expense and transfers

I actually don't have nonprofit version right now, but was wondering if it might be better for my situation.  But thanks.

Need to get in touch?

Contact us