--- title: Days Cost of Sales description:   --- [Skip to content](https://help.planguru.com/knowledge/planguru-app-online/days-cost-of-sales#main-content) [![PlanGuru Help Center](https://help.planguru.com/hs-fs/hubfs/logo_PlanGuru_helpcenter.png?width=360&height=50&name=logo_PlanGuru_helpcenter.png)](https://help.planguru.com/knowledge?hsLang=en) - [Your Tickets](https://help.planguru.com/tickets-view) - [Sign out](https://help.planguru.com/_hcms/mem/logout) Open main navigation Close main navigation - [Your Tickets](https://help.planguru.com/tickets-view) - [Sign out](https://help.planguru.com/_hcms/mem/logout) - [Submit a Ticket](https://help.planguru.com/tickets-view/new) [Submit a Ticket](https://help.planguru.com/tickets-view/new?hsLang=en) Hello. What do you need help with? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.planguru.com/knowledge?hsLang=en) 2. [PlanGuru App (Online)](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en) 3. [Forecasting & Modeling](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#forecasting-modeling) # Days Cost of Sales ## The Days Cost of Sales projection method provides a quick and reliable way to forecast Inventory balances based on your expected Cost of Sales activity and the number of days of inventory you plan to keep on hand.   This method is available for **Inventory accounts** under the **Current Assets** section of your Balance Sheet. It calculates future inventory levels by referencing **Cost of Sales accounts** within your **Income Statement** and applying a **Days Cost of Sales** metric to determine how much inventory should be held to support sales demand. --- ### When to Use This Method Use the **Days Cost of Sales** projection method when: - You want a **fast, straightforward** way to forecast inventory balances. - Your inventory levels are tied closely to **sales volume** and **cost of goods sold**. - You prefer to maintain a consistent **days-on-hand** inventory target rather than detailed SKU-level modeling. --- ### How It Works The Days Cost of Sales method works by solving for the inventory balance that will satisfy *X number of days* of your projected **Cost of Sales**. In other words, it answers: > “How much inventory should we hold to meet *X days* of expected sales activity?” --- ### Applying the Method #### **Step 1 – Open the Inventory Account** Go to your Balance Sheet → **Current Assets** → **Inventory**. Double-click or right-click and select **Edit**. --- #### **Step 2 – Select the Projection Method** Choose **Days Cost of Sales** from the list of available projection methods. ![Days Cost of Sales](https://help.planguru.com/hs-fs/hubfs/Days%20Cost%20of%20Sales.png?width=670&height=423&name=Days%20Cost%20of%20Sales.png) --- #### **Step 3 – Reference Cost of Sales Accounts** Select which **Cost of Sales** accounts from your Income Statement you want to reference. These are the accounts that reflect the expected flow of goods out of inventory as sales occur. --- #### **Step 4 – Enter the Number of Days** Input the number of **Days of Inventory on Hand** you plan to maintain (e.g., 45 days). PlanGuru will calculate your projected inventory balance based on your chosen days and Cost of Sales activity. --- ### Historical Insights The grid also displays **historical days of cost of sales** by month, calculated from prior-year data, along with an **average**. This allows you to see past performance and choose realistic inventory day targets.   ![Enter Days](https://help.planguru.com/hs-fs/hubfs/Enter%20Days.png?width=670&height=208&name=Enter%20Days.png) --- ### Results The result is a **dynamic, automatically calculated** inventory balance that reflects: - Real-time updates from Cost of Sales forecasts. - Proportional changes in sales volume. - A rolling target based on the number of days selected. This ensures your **Balance Sheet** inventory levels align with your **Income Statement** activity for accurate **cash flow forecasting**. ![Inventory-result](https://help.planguru.com/hs-fs/hubfs/Inventory-result.png?width=670&height=104&name=Inventory-result.png) --- ### Advanced Inventory Forecasting While the Days Cost of Sales method is simple and effective, some users may need **more granular control** over inventory projections. For advanced modeling, use the [**Assumptions & KPIs** tab to create **custom inventory formulas**](https://help.planguru.com/knowledge/planguru-app-online/building-a-formula-with-assumptions-kpis?hsLang=en) — such as inventory by SKU, product class, or purchase cycle. - [PlanGuru App (Online)](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#main-content) - [Getting Started](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#getting-started) - [Setup & Import](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#setup-import) - [Company Management](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#company-management) - [Forecasting & Modeling](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#forecasting-modeling) - [PlanGuru Analytics (powered by Reach Reporting)](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#planguru-analytics-powered-by-reach-reporting) - [Standard Reports](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#standard-reports) - [Updates](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#updates) - [PlanGuru Desktop (Windows)](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#main-content) - [Updates](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#updates) - [Getting Started](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#getting-started) - [Navigating PlanGuru Desktop](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#navigating-planguru-desktop) - [Setup & Maintenance](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#setup-maintenance) - [QuickBooks Online Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#quickbooks-online-import) - [QuickBooks Desktop Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#quickbooks-desktop-import) - [Excel Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#excel-import) - [Analysis Setup](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#analysis-setup) - [Forecasting & Modeling](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#forecasting-modeling) - [Installation](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#installation) - [Licensing](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#licensing) - [Managing your PlanGuru Files](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#managing-your-planguru-files) - [Reporting](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#reporting) - [PlanGuru Analytics](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#planguru-analytics) - [Technical Inquiries](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#technical-inquiries) - [PlanGuru Desktop in Cloud Hosting](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#planguru-desktop-in-cloud-hosting) - [Advanced Reporting Excel Add-in](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#advanced-reporting-excel-add-in) - [PlanGuru University](https://help.planguru.com/knowledge/planguru-university?hsLang=en) - [PRODUCTS & PRICING](https://www.planguru.com/products/) - CUSTOMERS - [Small Businesses](https://www.planguru.com/users/small-business/) - [Nonprofits](https://www.planguru.com/users/nonprofit/) - [Accountants / Advisors](https://www.planguru.com/users/accountants-business-advisors/) - LEARNING - [Attend a Live Demo](https://www.planguru.com/products/planguru-webinar-signup/) - [PlanGuru University](https://www.planguru.com/planguru-university/) - [Sign Up for PGU](https://www.planguru.com/planguru-university/) - [PGU Class Materials & Recordings](https://www.planguru.com/planguru-university/class-materials/) - [Video Tutorials](https://www.planguru.com/learning-resources/learning-center/) - [Help Center](https://help.planguru.com/knowledge) - SUPPORT - [Help Center/ Submit a Ticket](https://help.planguru.com/knowledge) - [Downloads / Updates](https://www.planguru.com/support/downloads/) - [Try it FREE](https://www.planguru.com/products/trial/) [![logo\_PlanGuru\_190-1](https://help.planguru.com/hs-fs/hubfs/logo_PlanGuru_190-1.png?width=190&height=55&name=logo_PlanGuru_190-1.png "logo_PlanGuru_190-1")](https://www.planguru.com/) Copyright © 2025, PlanGuru