The Income (Cash) by Subcategory metric shows the total cash received by subcategories of income, allowing you to understand the sources of your revenue.
With Databox you can track all your metrics from various data sources in one place.
Used to show comparisons between values.
Databox is a business analytics software that allows you to track and visualize your most important metrics from any data source in one centralized platform.
To track Income (Cash) by Subcategory using Databox, follow these steps:
Quickbooks Metric ‘Income’ might not return any values in Databox if its renamed in the connected Quickbooks account (for example to ‘Revenue’ or ‘Total Revenue’). The following setup should be applied in the Quickbooks account under ‘Account and Settings’: Company type should be set to Not sure/Other/None (Databox does not support syncing data for the Non-Profit Company type account setting), and industry should be left blank (this needs to be done at least for the non-profit entities). With these settings, the report subtitles will automatically be set as ‘Income’ and ‘Total Income’, and Databox will sync data for the metric as expected.
The Open invoices by Customer metric shows the total amount of unpaid invoices for each customer, providing insight into accounts receivable and cash flow.
The Open Balance by Vendor metric shows the total amount of unpaid invoices and bills for each vendor, which is essential for managing accounts payable and maintaining positive vendor relationships.
The Paid Sales Receipts Amount metric refers to the total amount of sales receipts that have been marked as paid in QuickBooks, indicating how much revenue has already been collected.
The Cost of Goods Sold (Cash) by Subcategory metric measures the total amount of cash spent on producing goods categorized by subcategories, helping track expenses and determine profitability for specific product lines.
Other Expenses (Accrual) is a financial metric that represents the sum of all non-operating expenses incurred by a business but not directly related to its core operations, such as interest expense, taxes, or litigation costs.
Net Cash Increase is a financial metric that demonstrates the amount by which cash and cash equivalents have increased during a given period. It is calculated by subtracting the cash outflows from the cash inflows.
Inventory metric refers to the amount of stock or products a business has on hand at any given time. It helps to track inventory levels and measure inventory turnover to optimize cash flow and profitability.
The Amount by Product metric refers to the total amount of revenue generated by each product sold in your business. It helps you identify your best-performing products and make data-driven decisions to optimize your sales strategy.