{"id":3141,"date":"2015-07-29T21:35:30","date_gmt":"2015-07-30T01:35:30","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3141\/why-doesnt-the-information-on-my-dashboard-match-my-reports\/"},"modified":"2018-10-01T16:09:11","modified_gmt":"2018-10-01T20:09:11","slug":"why-doesnt-the-information-on-my-dashboard-match-my-reports","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/70545830\/why-doesnt-the-information-on-my-dashboard-match-my-reports\/","title":{"rendered":"Why doesn&#8217;t the information on my dashboard match my reports?"},"content":{"rendered":"<p>Don&#8217;t panic! inFlow On-Premise&#8217;s reports allow you to change settings like specific customers\/products, date ranges, and inventory + payment statuses. The Dashboard allows you to change the date range, but the parameters are always set. With this in mind, sometimes you&#8217;ll run into different numbers. This doesn&#8217;t mean your inventory \/ information is incorrect, as you should be able to generate reports using the dashboard parameters that will show you the information used to come to those totals.<\/p>\n\n<p>The Dashboard&#8217;s parameters and the report you can generate are listed below.<\/p>\n<p>Note:<\/p>\n<ul>\n<li>your time ranges should always match; for example if you&#8217;re showing information for &#8220;Last Month&#8221; in the dashboard, you should always use the same &#8220;Last Month&#8221; setting on your reports.<\/li>\n<li>the Dashboard grouped by &#8220;Months&#8221; or &#8220;Weeks&#8221; will only show an average across the time range. You might want to switch to group by &#8220;Days&#8221; and it will match up with your reports.<\/li>\n<\/ul>\n\n<table border=\"1\" cellpadding=\"5\" align=\"center\">\n<tbody>\n<tr>\n<th style=\"text-align: center;\" width=\"40%\">Dashboard + Reports to run<\/th>\n<th width=\"60%\"><strong>Notes<\/strong><\/th>\n<\/tr>\n<tr>\n<th colspan=\"2\"><strong>SALES \/ PURCHASE ORDER FIGURES<\/strong><\/th>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\n<p style=\"text-align: center;\"><strong>Dashboard shows<\/strong>: Purchase Orders<\/p>\n<p>Run: Purchase Order Details report<\/p>\n<p><strong>PO Date:<\/strong> \u00a0match Dashboard\u00a0setting<br \/>\n<strong>Payment Status:<\/strong> All<br \/>\n<strong>Inventory Status:<\/strong> All<\/p>\n<p>Matching result is in the\u00a0<strong>Subtotal<\/strong> column.<\/td>\n<td style=\"text-align: left;\">This information is taken from all Purchase Orders (except Cancelled orders), for any inventory and payment status.<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"><strong>Dashboard shows<\/strong>: Sales Orders<\/p>\n<p style=\"text-align: left;\">Run: Sales Order Summary report<\/p>\n<p style=\"text-align: left;\"><strong>Order Date:<\/strong> match Dashboard\u00a0setting<br \/>\n<strong>Payment Status:<\/strong> All<br \/>\n<strong>Inventory Status:<\/strong> All<\/p>\n<p style=\"text-align: left;\">Matching result is in the\u00a0<strong>Subtotal<\/strong> column.<\/p>\n<\/td>\n<td style=\"text-align: left;\">This information is taken from all Sales Orders (except Cancelled) for any inventory and payment status.<\/p>\n<p>Make sure the setting is <strong>Order Date<\/strong> and not Invoiced Date.<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\n<p style=\"text-align: center;\"><strong>Dashboard shows<\/strong>: Sales Completed<\/p>\n<p>Run: Sales Order Profit report<\/p>\n<p><strong>Invoiced Date:<\/strong> match Dashboard\u00a0setting<br \/>\n<strong>Inventory Status:<\/strong> Started, Fulfilled<br \/>\n<strong>Payment Status:<\/strong>\u00a0Uninvoiced, Invoiced, Paid, Partial, Owing<\/p>\n<p>Matching result is in the\u00a0<strong>Sales Amount<\/strong> column.<\/td>\n<td style=\"text-align: left;\">inFlow counts a sale as \u201ccompleted\u201d if all the items on the order have left your inventory (Fulfilled status). It will go by the Order Date if the order has not been invoiced, or by Invoice Date if the order has been invoiced.<\/p>\n<p>If this isn&#8217;t what you&#8217;d like to see (for example if you only want to see all fulfilled and paid orders) then please run\u00a0the sales report with the statuses you want and ignore the dashboard figure.<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><strong>Dashboard shows<\/strong>: Sales\u00a0Profit<\/p>\n<p style=\"text-align: left;\">Run: Sales Order Profit Report<\/p>\n<p><strong>Invoiced Date:<\/strong> match Dashboard\u00a0setting<br \/>\n<strong>Inventory Status:<\/strong> Fulfilled<br \/>\n<strong>Payment Status:<\/strong> All<\/p>\n<p>Matching result is in the\u00a0<strong>Gross Profit\u00a0<\/strong>column.<\/p>\n<p>Result also calculated using Sales Completed minus Cost of Goods Sold.<\/td>\n<td style=\"text-align: left;\">inFlow calculates your profit at the time of the sale. When you click the Fulfill button in inFlow, it looks at the cost info in the product record to calculate your profit (sales &#8211; cost).<\/p>\n<p>It&#8217;s important to make sure your items have cost in them before starting any sales orders, so if you&#8217;re seeing hundred percent profit where it shouldn&#8217;t be, please see <a href=\"https:\/\/inflowinventory.com\/support\/article\/35366384\/my-profit-report-shows-no-cost-of-goods-sold-wrong-cost-of-goods-sold-help\">this article<\/a> for troubleshooting.<\/td>\n<\/tr>\n<tr>\n<th colspan=\"2\"><strong>INVENTORY\u00a0FIGURES<\/strong><\/th>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\n<p style=\"text-align: center;\"><strong>Dashboard shows<\/strong>: Cost of Goods Sold<\/p>\n<p>Run: Sales Order Profit Report<\/p>\n<p><strong>Invoiced Date:<\/strong> match Dashboard\u00a0setting<br \/>\n<strong>Inventory status:<\/strong> Fulfilled<br \/>\nClick the <em>More<\/em>\u00a0button beside <em>Generate Report, <\/em>then\u00a0click on the display columns to show the <em>Cost of Goods Sold<\/em>\u00a0column.<\/p>\n<p>Matching result is in the\u00a0<strong>Cost of Goods Sold<\/strong> column.<\/p>\n<p style=\"text-align: center;\">&#8211; or &#8211;<\/p>\n<p>Run: Sales by Product Summary report<\/p>\n<p><strong>Invoiced Date:<\/strong> match Dashboard\u00a0setting<br \/>\n<strong>Inventory status:<\/strong> Fulfilled<\/p>\n<p>Matching result is in the\u00a0<strong>Cost of Goods Sold<\/strong> column.<\/td>\n<td style=\"text-align: left;\">If you&#8217;re not seeing any cost of goods sold at all on your sales, <a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/35366384\/my-profit-report-shows-no-cost-of-goods-sold-wrong-cost-of-goods-sold-help\/\">please see here for how to correct this<\/a>.<\/p>\n<p>Cost of Goods Sold on the dashboard does not include non-customer costs that are on a sales order.<\/td>\n<\/tr>\n<tr>\n<td>\n<p style=\"text-align: center;\"><strong>Dashboard shows<\/strong>: Cost Value of Inventory, Ending<\/p>\n<p><strong>Set Dashboard to group by days.<\/strong><\/p>\n<p>For current inventory, run Inventory Summary or Inventory Details report.<\/p>\n<p>Matching result\u00a0is in the <strong>Total Cost Value<\/strong> column.<\/p>\n<p>For historical inventory, run Historical Inventory Report.<\/td>\n<td style=\"text-align: left;\">This shows you the cost value of your inventory. Please note: the dashboard includes deactivated items that are still in stock, whereas the report will not include any deactivated items.<\/td>\n<\/tr>\n<tr>\n<th colspan=\"2\"><strong>PAYMENT\u00a0FIGURES<\/strong><\/th>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\n<p style=\"text-align: center;\"><strong>Dashboard shows:<\/strong> Vendor Payments Due<\/p>\n<p>There is no report for this currently.<\/p>\n<p>The closest report you can try is a Purchase Order Summary report, Payment status set to &#8220;Unpaid, Partial, and Owing&#8221;, however the report will include payments that <strong>aren&#8217;t<\/strong> due yet.<\/td>\n<td style=\"text-align: left;\">This information is taken directly from any unpaid, partial, or owing purchase orders that are at or over the due date. This is how much you still need to pay your vendors. cThere currently isn&#8217;t a report you can pull for this number, as the vendor payment report only shows payments already made.<\/p>\n\n\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\n<p style=\"text-align: center;\"><strong>Dashboard shows:<\/strong>\u00a0Customer Payments Due<\/p>\n<p>There is no report for this currently.<\/p>\n<p>In the Sales Order List, <a href=\"https:\/\/inflowinventory.com\/support\/article\/41122424\/how-do-i-search-for-something\">change one of the search filters<\/a> to show &#8220;Due Date&#8221;. Set the Due Date to\u00a0match your Dashboard setting.<\/p>\n<p>Set the Payment Status to &#8220;Invoiced&#8221; and &#8220;Partial&#8221;.<\/p>\n<p>The total balance should add up to the dashboard&#8217;s numbers.<\/td>\n<td style=\"text-align: left;\">This shows you a total of all payments still needed to be paid by your customers within the time range matching your dashboard (for example, if you set it to &#8220;Last Month&#8221;, it&#8217;ll show you all payments that were due last month and still not paid currently).<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<th colspan=\"2\"><strong>CASHFLOW FIGURES<\/strong><\/th>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\n<p style=\"text-align: center;\"><strong>Dashboard shows:<\/strong>\u00a0Cash In<\/p>\n<p>Run: Customer Payment Details<\/p>\n<p><strong>Payment Type:<\/strong>\u00a0Payment and Batch Payment<br \/>\n<strong>Payment Date:<\/strong>\u00a0match Dashboard setting<\/p>\n<p style=\"text-align: center;\">+<\/p>\n<p>Run: Vendor Payment Details<\/p>\n<p><strong>Payment Type:\u00a0<\/strong>Refund<br \/>\n<strong>Payment Date:<\/strong> match Dashboard setting<\/p>\n<p>The two figures total-ed together should equal the figure shown on the dashboard for &#8220;Cash In&#8221;.<\/td>\n<td style=\"text-align: left;\"><em>Cash In<\/em> can come from two places: customer payments and vendor refunds. Therefore you&#8217;ll need to run the two reports <strong>together<\/strong>.<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\n<p style=\"text-align: center;\"><strong>Dashboard shows:<\/strong>\u00a0Cash Out<\/p>\n<p>Run: Customer Payment Details<br \/>\n<strong>Payment Type:<\/strong> Refund to Customer<br \/>\n<strong>Payment Date:<\/strong> match Dashboard setting<\/p>\n<p style=\"text-align: center;\">+<\/p>\n<p>Run: Vendor Payment Details<br \/>\n<strong>Payment Type:<\/strong>\u00a0Payment and Batch Payment<br \/>\n<strong>Payment Date:<\/strong> match Dashboard setting<\/p>\n<p style=\"text-align: center;\">+<\/p>\n<p>Run: Sales Order Profit Report<br \/>\n<strong>Invoiced Date:<\/strong> match Dashboard setting<\/p>\n<p>Click the &#8220;More&#8221; button to show the display column for &#8220;Non-Customer Costs&#8221;.<\/p>\n<p>In total, all three figures should give you the <em>Cash Out<\/em>\u00a0number.<\/td>\n<td style=\"text-align: left;\">Similar to <em>Cash In<\/em>, this number can be obtained by adding together multiple reports. <em>Cash Out<\/em>\u00a0covers: vendor payments, customer refunds, and any non-customer costs (these are costs you pay on behalf of your customer, for example shipping costs from providing &#8216;free shipping&#8217;)<\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">\n<p style=\"text-align: center;\"><strong>Dashboard shows:<\/strong>\u00a0Net Cashflow<\/p>\n<p>No reports\u00a0to run.<\/td>\n<td style=\"text-align: left;\">There isn&#8217;t a report for this, it&#8217;s just Cash In minus Cash Out.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Don&#8217;t panic! inFlow On-Premise&#8217;s reports allow you to change settings like specific customers\/products, date ranges, and inventory + payment statuses. The Dashboard allows you to change the date range, but the parameters are always set. With this in mind, sometimes you&#8217;ll run into different numbers. This doesn&#8217;t mean your inventory \/ information is incorrect, as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":""},"categories":[20,25],"tags":[46,49],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3141"}],"collection":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=3141"}],"version-history":[{"count":10,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3141\/revisions"}],"predecessor-version":[{"id":26552,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3141\/revisions\/26552"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}