Mixing manual entries and product sales on the same day is supported intentionally — but it's also where the only real "double-count risk" in nouz lives. Understanding the data model makes the safe pattern obvious.
01 Where does nouz store the two entry types?
Under the hood, nouz keeps two separate tables for revenue. Manual entries live in revenue_entries (cash + card columns, plus optional notes), and product sales live in revenue_product_entries (a snapshot of the product's price, COGS, and tax rate at the moment of the sale). Both tables are scoped per location and per date, so when the P&L computes a day it simply reads both and sums them.
revenue_entries— manual entries with cash + card columns, plus optional notes.revenue_product_entries— product sales with a snapshot of the product's price, COGS, and tax rate at the moment of the sale.
Both tables are scoped per location and per date. When the P&L computes a day, it reads both and sums them.
02 How does the P&L combine the two entry types?
It reads both tables and adds them, with no overlap risk because each row lives in exactly one table. Take a typical day of three product sales at €45 each plus one manual entry of €120: the product sales total €135 gross, the manual entries total €120 gross, and the day lands at €255 gross. A product sale is never also a manual entry, so nothing is counted twice. The breakdown is below.
- Product sales total: €135 gross.
- Manual entries total: €120 gross.
- Day total: €255 gross.
There's no overlap risk because the two tables hold genuinely different rows. A product sale is never also a manual entry — and vice versa.
03 How do I avoid double-counting?
The only failure mode: you log a manual entry for the day's total and log individual product sales that overlap with it. Then you're counting the same revenue twice. The fix is conceptual: pick one mode per "chunk" of revenue. Either log products and a manual entry for everything-else, or log one manual entry for the whole day — never both for the same money.
04 What's the one discipline rule that keeps it clean?
The cleanest pattern: think of each day's revenue as a pile of money. Every euro in the pile should be in exactly one entry — either a manual entry or a product sale, never both. The pile total = sum of entries. Anything else creates the double-count.
Was this article helpful?
Your vote helps us decide what to write next.