|
| Use QB For A Business Plan Pro Forma? |
Question:
I am a non-accountant, helping a friend
prepare a business
plan for a startup small business
(food supplements.) Using Excel, we've
done manual projections for sales,
expenses, etc., on a quarterly basis
to produce projections of gross revenues
and pre-tax profits for the first
five years.
My question: can I enter this and
other relevant data into a "New
Company" in Quickbooks Pro
2003 to generate full financials (P&L,
Balance Sheet, Cash Flow, etc.)? I
use QB for my own business,
but at a very elementary level.
For the business
plan pro
formas, I'd want to enter sales in
batches or monthly/quarterly totals,
rather than as individual transactions
(of which there would be thousands
each month.) But I have no idea how
to do this. The same would be true
for expenses -- salaries, phone, shipping,
etc.
Answer:
Of course you <can-, but I'd think
it easier to simply do it by hand
- with the help of the Excel spreadsheet
you've already built. As for
- entering the data, you could simply
create a single lumped transaction
- for a month or week or whatever
period you wish. W/newer QB
much of - this could probably be semi-automated
with the new API interface but I -
doubt it would be worth the effort.
Some data could be imported
via if - files, but they're a pita
if you've not used them previously.
 |
|
|
|
|
