Accountants Community Home Page

Creating Aging Reports of Inventory in POS

We have POS in 4 toy stores here in Tampa Bay. We'd like to run an aging report regularly in each location so we can see what products are still here after 90 days / 120 days etc so we can put those items on clearance to make room for new merchandise.First, when you input a new item, does the inventory system somehow stamp the input date on the data file? - then, what are the steps to run this report we're referring to above?Thanks very much,Chad


    Stamps dates, etc, may not easily give how well inventory is selling.

    Usually, the inventory turnover, in number of days, shows how well inventory is selling. The inventory turnover should be compared to an ?expected? value. (House builders have a very different inventory turnover than supermarkets.)

    From QB POS reports, inventory turnover in days for each item should be fairly easily determined. The item summary report should give the total sales for an item over a period, e.g. 90 days. Divide this number (sales) by the average item inventory during the period to determine the item inventory turnover number.

    The average inventory for an item during a period can be determined from the item inventory valuation report. Determine the item?s value at the beginning of the period, and at the end of the period, and then divide the sum of these two numbers by 2 to get the average inventory for the item during the period.

    Then, divide the average inventory value into the inventory item sales to get the inventory turnover number. Divide this number into 360 days to get the inventory turnover in days number for the period selected.

    Compare the average turnover in days to an ?expected? value, to decide how well your inventory is selling.

    Government, and other databases, provide national averages (a good expected turnover number to compare to) for various retail sectors. Richard

      Contribute an answer

      People come to Accountants Community for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

      1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
      2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
      3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
      4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
      5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

      Similar questions other people found helpful: