What: A report that shows, for each day, the total inflows (cash, debit, Pix) and total outflows (expenses paid with these methods), resulting in a daily balance.
How: A backend query that combines data from the sales and expenses tables, grouped by day and paymentMethod.
Value: This is the purest view of the business's "lifeblood." It shows whether the company is generating more cash than it spends on a daily basis.
What: A report that shows, for each day, the total inflows (cash, debit, Pix) and total outflows (expenses paid with these methods), resulting in a daily balance.
How: A backend query that combines data from the sales and expenses tables, grouped by day and paymentMethod.
Value: This is the purest view of the business's "lifeblood." It shows whether the company is generating more cash than it spends on a daily basis.