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.
Money Received is a financial metric in QuickBooks that represents the total amount of money received from customers or clients for goods or services sold within a given period of time. It helps businesses to track their sales revenue and cash flow accurately.
The Paid Invoices metric in QuickBooks tracks the total amount of money received from customers against the invoices that you have marked as paid.
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.
The Income (Accrual) by Category metric shows the total amount of revenue earned in a given period, categorized by various income sources such as sales, services, or fees. This metric uses accrual accounting, which records revenue when it's earned, regardless of when payment is actually received.
Assets in QuickBooks refer to the resources that a company owns and can use to generate revenue. These include cash, accounts receivable, inventory, and property. Assets are important because they show a company's financial strength and ability to generate income.
COGS (Cash) 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.