Use this guide to set up expenses that are calculated based on other items, like sales tax based on income.
Example: Monthly Sales Tax on Income
- Set Type to Expense
- Set Frequency to Monthly
- Set Date to when you want the tax to appear each month (e.g., the 15th)
- Select Calculated for the amount type
- Enter your tax rate in Calculate (e.g.,
6.25 for 6.25%)
- Set Based on to All items of type → All Income
- Set When to calculate to On my own schedule
- Set Aggregate from to Previous month
Result:
A monthly sales tax expense will appear on your chosen day, calculated as the percentage of the previous month's total income.
Timing Mode Options
- When source items occur – The calculated entry appears each time source items occur (e.g., daily processing fees on daily sales)
- On my own schedule – The calculated entry follows your frequency setting and aggregates from a lookback period (e.g., monthly tax on previous month's income)
Aggregate Period Options (Schedule Mode)
- Previous month – Sums all source items from the previous calendar month
- Previous week – Sums all source items from the previous calendar week
- Current month (to date) – Sums source items from the current month up to this date
- Rolling days – Sums source items from the past N days