Excluding bank accounts from financial reports
I have 4 bank accounts in the same company, How can I run a financial report on selected bank accounts?
70
294
az4A-G5iKr4kKlacwZ5xHE
09/21/11 12:43pm PDT
Viewed by asker 09/21/11 1:44pm PDT
Viewed by asker 09/21/11 1:44pm PDT
7 Replies
09/21/11 12:59pm PDT
You can run a quick report on any account by right clicking and selecting "Quick Report:________". That report lists the different transactions that affect that account.
09/21/11 1:14pm PDT
I want to run balance and P&L's for two of the four checking accounts.
09/21/11 1:21pm PDT
A P&L only looks at income and expense accounts so you can't limit it to which account the transactions were written out of. You can select which accounts to include on the balance sheet; however, excluding specific accounts from the balance sheet will likely make the balance sheet and P&L not match.
09/21/11 1:22pm PDT
Since most account is generate through an accrual basis, a P & L will tell you the income and expenses that incurred and would not be able to show you what was P & L went into the different accounts. You would have to do a quick report on each account and then you could export it to excel to manipulate it. I would be curious to see if there was another way.
09/22/11 5:41am PDT
It sounds like you are processing different areas of the same company and you have certain banking accounts for each. You might consider class tracking. But otherwise, mwebb123 is right, you won't get an accurate picture just picking and choosing transactions out of accounts.
09/22/11 6:06am PDT
Class tracking is a great idea. It will be time consuming to change past entries, but on a goforward basis that is probably the best bet.
KarenLV
Questions asked: 4
Questions answered: 8
Points earned: 18
Questions answered: 8
Points earned: 18
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
ProAdvisor
Members of the QuickBooks ProAdvisor Program
09/22/11 7:23am PDT
Latest post
marc1222, have you tried Modify/Filters/Multiple Accounts? Where you would select only the 2 you need? as mentioned earlier, this might not give perfectly accurate data but you can run the standard and then the modified reports and compare. you can also modify the report basis, if needed.
