Displays current balances from linked bank and credit card accounts in QuickBooks, providing a complete snapshot of your financial position.
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 & Credit Cards (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) metric in QuickBooks shows the total amount of money owed to vendors or suppliers that have not yet been paid. It helps track outstanding payments and plan cash flow.
The Cost of Goods Sold (Accrual) by Subcategory metric tracks the total cost of producing or purchasing the goods sold in each subcategory during a specific period.
Other Expenses (Cash) by Category metric categorizes and tracks all cash outflows not included in other expense categories. It helps analyze and monitor miscellaneous expenses incurred by the business.
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.
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.
Current Liabilities measures the amount of money a company owes for debts that are due within a year, such as loans, accounts payable and taxes.
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.