Reports from multiple bank accounts

Running QB Premier Accountant Edition 2007. We have a QB file with five bank accounts. We need to run some reprots (principally a cash flow report) with the activity from just three of the accounts. I can find a way of running a report with any one bank account, but not from multiple bank accounts.

Anyone know how this can be done, or alternatively, of a thrid party report writer solution?

Reply to
Ted Edwards
Loading thread data ...

Apply filters to the base report--they have the ability to multi-select individual accounts. Once you get what you want, you can memorize it for posterity.

--

Reply to
dpb

Ted Edwards wrote: ...

I guess I don't understand the definition of "originating", then.

If you're looking for other transactions somehow related to the business activity, there's got to be an identifier attached for lookup -- perhaps these business activities in/from multiple bank accounts should be coded in a class is one thought but that's a wag owing to the initial condition laid out above.

Reply to
dpb

The Cash Flow statement is a P&L type of statement. Apply the same filters to it as you do to the P&L statement to separate his personal and business things.

On a P&L type statement you can't filter on balance sheet accounts, which is why the filter on the bank accounts didn't work. You will need to filter on income and expense accounts. If god forbid he mixed those you are at the headwaters of perfume creek and the paddle shop is on another continent.

Reply to
Golden California Girls

I cannot get it to take two cash accounts and give me the full detail. I don't think I correctly explained the issue. My client has three cash accounts. #1 is used for his personal transactions (groceries, entertainment, etc) and #2 and #3 are used for a rental real estate business he owns jointly with another person. He has to report on the joint business, which mean capturing all the transactions that originate from bank account #2 amd #3. When I try to do a cash flow and use a filter, I get just the activity in the actual cash acccounts, not all activity ORIGINATING from the two business cash accounts.

I get the feeling that the solution is readily available, but I am not seeing it. Can you help me solve that problem?

Distinguishing expenditures that are personal from those that are business related should be dependent on how the transactions were coded to the chart of accounts and not which checking account they were paid from.

Reply to
Haskel LaPort

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.