The Balance by Bank Accounts metric is a financial measure that displays the total amount of money available in each bank account in your QuickBooks software.
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 Balance by Bank Accounts (Cash) using Databox, follow these steps:
In order for a Bank Account from Quickbooks to be visible in metrics in Databox, the Bank Account must be visible in the Balance Sheet report in Quickbooks under the Assets > Current Assets > Bank Accounts tree.
The Open invoices by Customer metric shows the total amount of unpaid invoices for each customer, providing insight into accounts receivable and cash flow.
This metric shows the total amount of unpaid invoices that are past their due date for each customer in QuickBooks.
Net Other Income (Accrual) is a financial metric that represents the profit or loss generated through various non-operating activities, such as interest income, dividend income, rent income, and gains from the sale of assets.
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 Income (Cash) is a financial metric in QuickBooks that represents the money earned from sources other than the primary business operations, such as interest income, rental income, or gains from the sale of assets.
This metric segments cash-based short-term liabilities into subcategories (e.g., payables, accrued expenses), offering detailed insight into immediate obligations in QuickBooks.
Net cash provided by Financing activities is the total amount of cash received from or used in financing activities, including debt and equity transactions, during a specified period of time.
COGS (Accrual) by Product calculates the total cost of goods sold (COGS) for each product sold by a business. This metric helps to analyze profitability and optimize pricing strategies.