Problem with Quickbooks reports


B

Bill L.

I give the board of a small non-profit a cash basis P&L monthly and a
year to date one, too. I selected the accounts I wanted but the
quickbooks report is leaving off the principal loan payment and
deductions in payroll checks.

Do I need to run a trial balance, move it to excel, then calculate the
number?

Also, is there a way to get QB to sub-total by income groups? I have
250+ in one income group and it's tough to get a sub-total in QB.
Note: These accounts were imported from Quicken so the account number
and description are in the description field together. Any insight
would be helpful. Thanks!
 
Ad

Advertisements

P

Paul A Thomas

Bill L. said:
I give the board of a small non-profit a cash basis P&L monthly and a
year to date one, too. I selected the accounts I wanted but the
quickbooks report is leaving off the principal loan payment and
deductions in payroll checks.

Both of those cash outlays are a reduction of liabilities, and as such
wouldn't appear on the P&L.

If QB has a cash flow report, it would be there, or the Balance Sheet would
show a reduction in the liabilities each month.
 
?

_

What version of QB?
Recent versions of QB Pro (and Premier) allow you to export to Excel where you could group and sub-total any way that you wish. Otherwise you can create sub-totals by creating additional accounts to use as group "headers' and make other accounts sub-accounts.
 
J

Jack

If you have a recent version there is a cash flow report where these
items can be seen.
Both of those cash outlays are a reduction of liabilities, and as such
wouldn't appear on the P&L.

If QB has a cash flow report, it would be there, or the Balance Sheet would
show a reduction in the liabilities each month.
--
Affordable Support Services ..
No waiting for help.

660-949-2416
Northeastern Missouri
 
B

Bill L.

said:
What version of QB?
Recent versions of QB Pro (and Premier) allow you to export to Excel
where you could group and sub-total any way that you wish. Otherwise
you can create sub-totals by creating additional accounts to use as
group "headers' and make other accounts sub-accounts.
I've been exporting into Excel for months. With this software, I
would think there's an easier way.

I could create a group account for this income but I would need to
check it on a regular basis to make sure any new accounts are checked,
right?
 
?

_

Are you referring to the Excel method? If you use a template with formulas, then "yes" you should check your formulas in Excel any time accounts are created, renamed, deleted, or moved in QB. Anyone using a "report writer" with any accounting program would have to do the same.

If you use groups of sub-accounts in QB then it should not be an issue.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top