Total Expenses (Accrual) metric represents the total expenses recorded by a company during a specific period, including incurred expenses that have not yet been paid. It is an important measure of a company's profitability and financial health.
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 Total Expenses (Accrual) using Databox, follow these steps:
Databox pulls values for ‘Total Expenses’ metric from the Profit and Loss report and Vendor Expenses report, which are accessible in QuickBooks under Reports.
Users might notice discrepancies if they are comparing values for the ‘Total Expenses’ metric with values in QuickBooks under Dashboard → Business Overview (sum of expenses and costs). This is because the Business Overview Dashboard in QuickBooks aggregates both the Cost of Goods Sold and Expenses into the Total Expenses amount without a detailed breakdown. To see this value in Databox, users should create a Calculated metric that sums the values of ‘Total Expenses’ and ‘Cost of Goods Sold’ metrics.
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.
Gross Profit Margin (Accrual) is a metric that shows the amount of revenue left over after deducting the direct cost of goods sold, and it's calculated by dividing the gross profit by total revenue.
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.
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.
This metric records long-term debt on an accrual basis, capturing incurred obligations and interest in QuickBooks regardless of cash movement.
This metric shows the total cash balance on business credit cards, reflecting all cash transactions to help reconcile statements and manage credit liabilities in QuickBooks.
Cash Inflow shows the total cash received from operations, reflecting actual revenue generation and providing insight into a business's liquidity in QuickBooks.
Cash Outflow shows the total cash spent on expenses, investments, and repayments, helping a business track spending and manage liquidity in QuickBooks.