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.
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:
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:
Please let me know how this report works for you. I'm always free to help you.
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.
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.
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:
You may find these articles helpful:
For additional help, you can also reach out to our QuickBooks Desktop Support.
Should need more help in generating QuickBooks reports, don't hesitate to let me know. Have a good one.