Key Financial Ratios - Assisted Formula Entry
As described on the
Defining Key Ratios page, there are a number of commands that you can use when defining Key Ratio formulae. You can type these commands directly into the Definition field in the 'Key Financial Ratios Report Definition' window, or you can use the Assisted Formula Entry feature to have the command constructed for you. This feature will be helpful when you don't remember a Key Ratio command or the correct syntax.
To use the Assisted Formula Entry feature, simply activate 'Paste Special' from the Definition field in the Key Ratio row:
Each of the radio button options on the left-hand side of the window represents one of the Key Ratio commands. When you choose one of these options, the equivalent Key Ratio command will be placed in the Formula field at the bottom of the window. Depending on the command, you should then specify additional details on the right-hand side of the window: these will be added to the formula in the Formula field. For example, if you select the Account Result option on the left, you should then specify an Account or Accounts on the right.
When the formula is complete, click the [Replace] or [Add] buttons as follows:
- Replace
- The new formula will be placed in the Definition field in the Key Ratio row, replacing what was previously there.
- Add
- The new formula will be placed in the Definition field in the Key Ratio row, in addition to what is already there. This will be useful if you are constructing a Definition that will contain more than one Key Ratio command.
The options on the left-hand side of the window are divided into sections as follows:
- Nominal Ledger
- Choose one of these options if you need the Key Ratio to print information from the Nominal Ledger.
- Account Result
- Prints the net change over the report period in the balance of a particular Account or Accounts.
- Additional details required:
- Specify an Account, range of Accounts separated by a colon or individual Accounts separated by commas in the Accounts field. Use 'Paste Special' to choose the Accounts if necessary.
- Select the Debit Only option if you only need the debit result to be printed.
- Select the Credit Only option if you only need the credit result to be printed.
Equivalent Key Ratio commands: Result, DebResult, CredResult
- Avg. Account Result
- Prints the prints the average monthly net change over the report period in the balance of a particular Account or Accounts.
- Additional details required:
- Specify an Account, range of Accounts separated by a colon or individual Accounts separated by commas in the Accounts field. Use 'Paste Special' to choose the Accounts if necessary.
Equivalent Key Ratio command: AvgResult
- Account Balance
- Prints the balance of a particular Account or Accounts on the last day of the report period.
- Additional details required:
- Specify an Account, range of Accounts separated by a colon or individual Accounts separated by commas in the Accounts field. Use 'Paste Special' to choose the Accounts if necessary.
- Select the Debit Only option if you only need the debit balance to be printed.
- Select the Credit Only option if you only need the credit balance to be printed.
Equivalent Key Ratio commands: Balance, DebBalance, CredBalance
- Account Result for VAT Code
- Prints the net change over the report period in the balance of a particular Account or Accounts, only taking postings with a particular VAT Code into account.
- Additional details required:
- Specify an Account, range of Accounts separated by a colon or individual Accounts separated by commas in the Accounts field. Use 'Paste Special' to choose the Accounts if necessary.
- Specify a VAT Code in the VAT Code field. Use 'Paste Special' to choose the VAT Code if necessary.
- Select the Debit Only option if you only need the debit result to be printed.
- Select the Credit Only option if you only need the credit result to be printed.
Equivalent Key Ratio commands: VATResult, VATDebResult, VATCredResult
- Avg. Account Result for VAT Code
- Prints the prints the average monthly net change over the report period in the balance of a particular Account or Accounts, only taking postings with a particular VAT Code into account.
- Additional details required:
- Specify an Account, range of Accounts separated by a colon or individual Accounts separated by commas in the Accounts field. Use 'Paste Special' to choose the Accounts if necessary.
- Specify a VAT Code in the VAT Code field. Use 'Paste Special' to choose the VAT Code if necessary.
Equivalent Key Ratio command: AvgVATResult
- Account Balance for VAT Code
- Prints the balance of a particular Account or Accounts on the last day of the report period, only taking postings with a particular VAT Code into account.
- Additional details required:
- Specify an Account, range of Accounts separated by a colon or individual Accounts separated by commas in the Accounts field. Use 'Paste Special' to choose the Accounts if necessary.
- Specify a VAT Code in the VAT Code field. Use 'Paste Special' to choose the VAT Code if necessary.
- Select the Debit Only option if you only need the debit balance to be printed.
- Select the Credit Only option if you only need the credit balance to be printed.
Equivalent Key Ratio commands: VATBalance, VATDebBalance, VATCredBalance
- Object Result
- Prints the net change over the report period in the balance of a particular Account or Accounts, only taking postings with a particular Object into account.
- Additional details required:
- Specify an Account, range of Accounts separated by a colon or individual Accounts separated by commas in the Accounts field. Use 'Paste Special' to choose the Accounts if necessary.
- Specify an Object in the Object field. Use 'Paste Special' to choose the Object if necessary.
- Select the Debit Only option if you only need the debit result to be printed.
- Select the Credit Only option if you only need the credit result to be printed.
Equivalent Key Ratio commands: ObjResult, ObjDebResult, ObjCredResult
- Avg. Object Result
- Prints the prints the average monthly net change over the report period in the balance of a particular Account or Accounts, only taking postings with a particular Object into account.
- Additional details required:
- Specify an Account, range of Accounts separated by a colon or individual Accounts separated by commas in the Accounts field. Use 'Paste Special' to choose the Accounts if necessary.
- Specify an Object in the Object field. Use 'Paste Special' to choose the Object if necessary.
Equivalent Key Ratio command: AvgObjResult
- Row Total
- Select this option to include the result of another Key Ratio calculation in the formula.
- Additional details required:
- Enter the Code of the other Key Ratio in the Row Code field.
Equivalent Key Ratio command: Key
- Purchase Ledger
- Choose one of these options if you need the Key Ratio to print information from the Purchase Ledger.
- Purchase Invoices Due
- Prints the total amount in the Purchase Ledger that is overdue for payment on the last day of the report period.
- Additional details required:
- If you need to see how much is overdue by more than a particular number of days on the last day of the report period, enter that number of days in the Days field.
- If you want to exclude Purchase Invoices that have been marked as On Hold, select the On Hold option.
- Equivalent Key Ratio commands: APDue, APOHDue
- Outstanding On Account P/L
- Prints the On Account balance in the Purchase Ledger on the last day of the report period (including open On Account Payments and Prepayments).
- Equivalent Key Ratio command: APOnAcc
- Sales Ledger
- Choose one of these options if you need the Key Ratio to print information from the Sales Ledger.
- Sales Invoices Due
- Prints the total amount in the Sales Ledger that is overdue for payment on the last day of the report period.
- Additional details required:
- If you need to see how much is overdue by more than a particular number of days on the last day of the report period, enter that number of days in the Days field.
- If you want to exclude Invoices that have been marked as Disputed, select the Disputed Only option.
- If you want to exclude Invoices that have been marked as No Reminders, select the No Reminders Only option.
- If you want to exclude Invoices that have been marked as Disputed, and Invoices that have been marked as No Reminders, select the No Reminders and Disputed option.
- Equivalent Key Ratio commands: ARDue, ARDPDue, ARNRDue, ARDPNRDue
- Outstanding On Account S/L
- Prints the On Account balance in the Sales Ledger on the last day of the report period (including open On Account Receipts and Prepayments).
- Equivalent Key Ratio command: AROnAcc
---
Pages describing the Key Financial Ratios report:
---
Reports in the Nominal Ledger:
---
Go back to: