software

I have a small service business with a parts inventory of approximately 180
items. A typical business day involves the sale of 3 or 4 inventory items
and the associated installation labor. Purchases of replacement inventory
occur 3 or 4 times per month.

I am trying to build a sales worksheet and a purchases worksheet that would
automatically update the inventory worksheets. Can someone suggest how I can
accomplish this? Or, if there is a better way to go about this, please point
me in the right direction!


quot;benwmenquot; gt; wrote in message
...
gt;I have a small service business with a parts inventory of approximately 180
gt; items. A typical business day involves the sale of 3 or 4 inventory items
gt; and the associated installation labor. Purchases of replacement inventory
gt; occur 3 or 4 times per month.
gt;
gt; I am trying to build a sales worksheet and a purchases worksheet that
gt; would
gt; automatically update the inventory worksheets. Can someone suggest how I
gt; can
gt; accomplish this? Or, if there is a better way to go about this, please
gt; point
gt; me in the right direction!

I ***think*** (but not sure) one of the Quicken business products handles
inventory. You might want to poke around at www.quicken.com. Also,
www.peachtree.com. These programs include other accounting functions which,
even if not important now due to the size of your business, might be very
helpful later if you grow larger.
You are right about the Quickbooks solution, but I was hoping avoid the
expense and the oversophistication. I don't anticipate or want to get any
larger. I already have a very useful and inexpensive general ledger program
that meets my accounting needs. I do appreciate your help. Thanks, Ben

quot;Doug Kanterquot; wrote:

gt;
gt; quot;benwmenquot; gt; wrote in message
gt; ...
gt; gt;I have a small service business with a parts inventory of approximately 180
gt; gt; items. A typical business day involves the sale of 3 or 4 inventory items
gt; gt; and the associated installation labor. Purchases of replacement inventory
gt; gt; occur 3 or 4 times per month.
gt; gt;
gt; gt; I am trying to build a sales worksheet and a purchases worksheet that
gt; gt; would
gt; gt; automatically update the inventory worksheets. Can someone suggest how I
gt; gt; can
gt; gt; accomplish this? Or, if there is a better way to go about this, please
gt; gt; point
gt; gt; me in the right direction!
gt;
gt; I ***think*** (but not sure) one of the Quicken business products handles
gt; inventory. You might want to poke around at www.quicken.com. Also,
gt; www.peachtree.com. These programs include other accounting functions which,
gt; even if not important now due to the size of your business, might be very
gt; helpful later if you grow larger.
gt;
gt;
gt;

I think your first stop should be a site like Barnes amp; Noble (www.bn.com),
where a search for the words quot;microsoft excel accountingquot; just turned up at
least 9 pages of results. Next, the library. What you're trying to do is too
large for an easy answer, as I'm sure you're aware. On the other hand, some
of these might be all you need:
www.dotxls.com/free-templates...-and-inventoryquot;benwmenquot; gt; wrote in message
...
gt; You are right about the Quickbooks solution, but I was hoping avoid the
gt; expense and the oversophistication. I don't anticipate or want to get any
gt; larger. I already have a very useful and inexpensive general ledger
gt; program
gt; that meets my accounting needs. I do appreciate your help. Thanks, Ben
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt;
gt;gt; quot;benwmenquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a small service business with a parts inventory of approximately
gt;gt; gt;180
gt;gt; gt; items. A typical business day involves the sale of 3 or 4 inventory
gt;gt; gt; items
gt;gt; gt; and the associated installation labor. Purchases of replacement
gt;gt; gt; inventory
gt;gt; gt; occur 3 or 4 times per month.
gt;gt; gt;
gt;gt; gt; I am trying to build a sales worksheet and a purchases worksheet that
gt;gt; gt; would
gt;gt; gt; automatically update the inventory worksheets. Can someone suggest how
gt;gt; gt; I
gt;gt; gt; can
gt;gt; gt; accomplish this? Or, if there is a better way to go about this, please
gt;gt; gt; point
gt;gt; gt; me in the right direction!
gt;gt;
gt;gt; I ***think*** (but not sure) one of the Quicken business products handles
gt;gt; inventory. You might want to poke around at www.quicken.com. Also,
gt;gt; www.peachtree.com. These programs include other accounting functions
gt;gt; which,
gt;gt; even if not important now due to the size of your business, might be very
gt;gt; helpful later if you grow larger.
gt;gt;
gt;gt;
gt;gt;
Dear Ben,

With the $100.00 rebate and 12 month Free support, you could get the
Microsoft Office Small Business Accounting package, which would handle all
your needs. With the rebate, you are looking at about $50!! Funny, nobody
else thought of this!

quot;Doug Kanterquot; wrote:

gt; I think your first stop should be a site like Barnes amp; Noble (www.bn.com),
gt; where a search for the words quot;microsoft excel accountingquot; just turned up at
gt; least 9 pages of results. Next, the library. What you're trying to do is too
gt; large for an easy answer, as I'm sure you're aware. On the other hand, some
gt; of these might be all you need:
gt; www.dotxls.com/free-templates...-and-inventory
gt;
gt;
gt; quot;benwmenquot; gt; wrote in message
gt; ...
gt; gt; You are right about the Quickbooks solution, but I was hoping avoid the
gt; gt; expense and the oversophistication. I don't anticipate or want to get any
gt; gt; larger. I already have a very useful and inexpensive general ledger
gt; gt; program
gt; gt; that meets my accounting needs. I do appreciate your help. Thanks, Ben
gt; gt;
gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; quot;benwmenquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have a small service business with a parts inventory of approximately
gt; gt;gt; gt;180
gt; gt;gt; gt; items. A typical business day involves the sale of 3 or 4 inventory
gt; gt;gt; gt; items
gt; gt;gt; gt; and the associated installation labor. Purchases of replacement
gt; gt;gt; gt; inventory
gt; gt;gt; gt; occur 3 or 4 times per month.
gt; gt;gt; gt;
gt; gt;gt; gt; I am trying to build a sales worksheet and a purchases worksheet that
gt; gt;gt; gt; would
gt; gt;gt; gt; automatically update the inventory worksheets. Can someone suggest how
gt; gt;gt; gt; I
gt; gt;gt; gt; can
gt; gt;gt; gt; accomplish this? Or, if there is a better way to go about this, please
gt; gt;gt; gt; point
gt; gt;gt; gt; me in the right direction!
gt; gt;gt;
gt; gt;gt; I ***think*** (but not sure) one of the Quicken business products handles
gt; gt;gt; inventory. You might want to poke around at www.quicken.com. Also,
gt; gt;gt; www.peachtree.com. These programs include other accounting functions
gt; gt;gt; which,
gt; gt;gt; even if not important now due to the size of your business, might be very
gt; gt;gt; helpful later if you grow larger.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;