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.
With Databox you can track all your metrics from various data sources in one place.
Used to show a simple Metric or to draw attention to one key number.
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 (Cash) using Databox, follow these steps:
The QuickBooks Cash Flow Overview dashboard provides a snapshot of net cash flow, bank balance, open and overdue invoices, and cash flow from operating, financing, and investing activities. It helps track financial health and cash movements.
This report gives a snapshot of financial results using QuickBooks data on income, expenses, cash flow, balance sheet, and overall financials, supporting informed financial decisions.
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 Paid Invoices Amount by Customer metric shows the total amount paid by each customer for the selected time period in QuickBooks. It helps track customer payments, inform future invoicing, and enables business owners to judge customer value.
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 Unpaid Expenses (Bills) by Vendor metric provides a snapshot of the outstanding bills owed to each vendor. This helps track payment obligations and ensure timely vendor payments.
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.
Net Income (Cash) is the total profit earned by a business after deducting all expenses that have been paid in cash.
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.
Gross Profit Growth (Accrual) measures the change in cash-based gross profit from one period to the next. It is found by subtracting the cost of goods sold (COGS) from total revenue and then comparing this figure between two periods.
This metric aggregates bank account balances using accrual accounting, factoring in outstanding transactions to give a comprehensive financial view in QuickBooks.