To explain how to use calculations in Magnifi to automatically derive account balances as percentages of other accounts. This feature simplifies projecting costs or revenue that move in line with other accounts.
When you want to calculate an account balance as a percentage of multiple accounts.
When you want to quickly project an account as a percentage of a single account using the shortcut.
Go to Chart of Accounts and open the Calculations tab.
Click Add and enter a description for the formula (e.g., Widget Costs).
Select the account you want to calculate (e.g., Widget Purchases).
Enter the percentage and choose the base account to calculate from (e.g., 5% of Widget A Sales).
If required, set a From/To date to control when the calculation applies.
Add more accounts as needed (e.g., 10% of Widget B Sales).
Magnifi will now automatically calculate the account balance:
Widget Purchases = 5% of Widget A Sales + 10% of Widget B Sales.
You can quickly calculate an account as a percentage of one account only:
Go to Profit & Loss and either double-click the account name or hover over it to reveal the % icon.
Enter the percentage of the related account.
Example: Purchases= 20% of Sales.
Select the Effective From month if the % should start from a certain point in time.
If the rate changes later, update the % and choose a new Effective From month.
To stop using the calculation, clear the % field (leave it blank, not 0%) and set the Effective From month.
Calculations update automatically — if the base account changes, the linked account updates too.
If you change the %, it will apply to all months unless you set From/To dates.
Best practice: close off the old formula with a To date, then add a new formula with a From date.
Use the shortcut for quick, single-account links; use calculations for more complex multi-account formulas.