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 expenses (accrued) paid to each vendor within a specific period.
Expenses (Accrual) metric tracks all expenses incurred by the company, regardless of whether the payment has been made or not. It includes the expenses that are due but not yet paid, allowing businesses to accurately record their financial obligations and track their cash flow.
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.
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.
The Income (Accrual) metric in QuickBooks refers to the amount of revenue earned by a business through the accrual accounting method, which recognizes revenue when it is earned but not yet received.
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.
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.