Why doesn’t the information on my dashboard match my reports?

Don’t panic! inFlow On-Premise’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’ll run into different numbers. This doesn’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.

The Dashboard’s parameters and the report you can generate are listed below.

Note:

your time ranges should always match; for example if you’re showing information for “Last Month” in the dashboard, you should always use the same “Last Month” setting on your reports.

the Dashboard grouped by “Months” or “Weeks” will only show an average across the time range. You might want to switch to group by “Days” and it will match up with your reports.

inFlow counts a sale as “completed” 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.

If this isn’t what you’d like to see (for example if you only want to see all fulfilled and paid orders) then please run the sales report with the statuses you want and ignore the dashboard figure.

Result also calculated using Sales Completed minus Cost of Goods Sold.

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 – cost).

It’s important to make sure your items have cost in them before starting any sales orders, so if you’re seeing hundred percent profit where it shouldn’t be, please see this article for troubleshooting.

INVENTORY FIGURES

Dashboard shows: Cost of Goods Sold

Run: Sales Order Profit Report

Invoiced Date: match Dashboard settingInventory status: Fulfilled
Click the More button beside Generate Report, then click on the display columns to show the Cost of Goods Sold column.

Cost of Goods Sold on the dashboard does not include non-customer costs that are on a sales order.

Dashboard shows: Cost Value of Inventory, Ending

Set Dashboard to group by days.

For current inventory, run Inventory Summary or Inventory Details report.

Matching result is in the Total Cost Value column.

For historical inventory, run Historical Inventory Report.

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.

PAYMENT FIGURES

Dashboard shows: Vendor Payments Due

There is no report for this currently.

The closest report you can try is a Purchase Order Summary report, Payment status set to “Unpaid, Partial, and Owing”, however the report will include payments that aren’t due yet.

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’t a report you can pull for this number, as the vendor payment report only shows payments already made.

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 “Last Month”, it’ll show you all payments that were due last month and still not paid currently).

Click the “More” button to show the display column for “Non-Customer Costs”.

In total, all three figures should give you the Cash Out number.

Similar to Cash In, this number can be obtained by adding together multiple reports. Cash Out covers: 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 ‘free shipping’)