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 (Accrual) 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 Total Expenses (Cash) by Subcategory metric calculates the sum of all cash expenditures within each subcategory, providing a breakdown of how expenses are allocated across different expense types.
The Unpaid Expenses (Bills) Amount by Vendor metric displays the total amount of outstanding bills owed to specific vendors in QuickBooks.
The Other Income (Cash) by Category metric shows the amount of cash received from sources other than core business activities, categorized by type.
Gross Profit Margin (Cash) is a financial metric that measures how much money a company is earning from its sales after accounting for the cost of goods sold, taking into account cash transactions.
The Balance metric refers to the difference between the total assets and total liabilities of a company at a given point in time. It indicates the financial position of the company and its ability to meet its financial obligations.
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.
EBIT (Accrual) reflects a company's earnings before interest and taxes, derived from cash transactions. It's determined by subtracting operating expenses from gross profit.
The Average Sales by Product metric displays the mean selling price for each product in the Product Service Summary report of QuickBooks, facilitating clear and direct pricing insights.