Reports from multiple bank accounts

Posted by Ted Edwards on July 24, 2009, 5:35 pm

Please log in for more thread options

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?

Posted by dpb on July 24, 2009, 5:51 pm

Please log in for more thread options

Ted Edwards wrote:

> 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, ...

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.

--

Posted by Ted Edwards on July 25, 2009, 4:39 pm

Please log in for more thread options

> Ted Edwards wrote:

> > 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, ...

> Apply filters to the base report--they have the ability to multi-select

> individual accounts. =A0Once you get what you want, you can memorize it

> for posterity.

> --

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?

Posted by dpb on July 26, 2009, 11:30 am

Please log in for more thread options

Ted Edwards wrote:
...

> 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?

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.

--

Posted by Golden California Girls on July 26, 2009, 1:10 pm

Please log in for more thread options

Ted Edwards wrote:

>> Ted Edwards wrote:

>>> 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, ...

>> 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.

>> --

> 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?

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.