Skip to content
  • There are no suggestions because the search field is empty.

Using Percent of Other Accounts Projection Method

The "% of other Accounts" method is perfect for forecasting revenue and expense categories that can be expressed as a % of some other line item.

 

 

The % of Other Accounts projection method allows you to forecast an account by making it a percentage of one or more other accounts.

This method is most commonly used for:

  • Cost of Sales

  • Variable expenses such as employee benefits or payroll taxes


1️⃣ Selecting the Method

  1. Double-click on the account, or right-click and select Edit.

  2. Choose % of Other Accounts.

Percent of Accounts


2️⃣ Linking to Accounts

  • Select one or more accounts that the chosen account will be based on.

  • These can be:

    • Individual accounts

    • Subtotal groupings

    • Section totals (e.g., Total Revenue)

Percent


3️⃣ Entering Percentages

  • In the grid, enter the percentage you want to apply.

  • Example: Set 25% of a revenue line item.

  • Right-click → Copy to Right to apply the same % to all months.

Copy


4️⃣ Reviewing Historical Relationships

The grid also displays:

  • Historical monthly percentages

  • Calculated averages across years

These insights help you choose a realistic rate based on actual past performance.

This method is especially powerful for seasonal businesses.

  • Instead of applying a flat annual % average,

  • You can replicate monthly percentage patterns from prior years.

  • This creates more precise forecasts that align with seasonal revenue fluctuations.

Example:

  • Historical data shows costs average 45% of revenue.

  • Use this as a guide for setting future projections.

Historical Seasonality



6️⃣ Month-to-Use Setting

At the top of the method window, choose which month’s values to base the calculation on:

  • Current Month

  • Prior Month

  • Subsequent Month

Month to Use


Applying the Method

  1. After linking accounts and setting percentages, click Update.

  2. The forecasted account will now move in sync with its linked accounts.

Example:

  • Revenue rises from March through June.

  • Cost account (25% of revenue) increases proportionally.

Calc