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.
This metric shows the total amount of overdue customer invoices categorized by their respective due dates.
The Cost of Goods Sold (Cash) by Category metric measures the amount of money spent on raw materials and production costs related to each category of goods sold, providing insight into profitability and spending patterns.
Other Expenses (Cash) represents any miscellaneous expenses that are not categorized under any specific category in the cash flow statement.
The Other Expenses (Accrual) by Category metric tracks the total amount of expenses incurred in non-standard categories that are not related to the daily operations of a company.
Gross Profit (Accrual) is a financial metric that calculates the profit a company earns after deducting the cost of goods sold and adjusting for accrued expenses and revenue, regardless of whether or not the money has exchanged hands.
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.
Liabilities are financial obligations or debts owed by a business to creditors, suppliers, or other entities. It includes short-term, long-term, and contingent liabilities and is a measure of a company's financial obligations that must be paid in the future.
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.