Ledger formulas

Read balances, debits and credits of any account or group from your books for any period with ELLIBO.BALANCE, ELLIBO.DEBIT and ELLIBO.CREDIT, and exchange rates with ELLIBO.RATE.

What they do

Ledger formulas read your books in Ellibo Accounting directly:

• =ELLIBO.BALANCE(accounts, period, [offset]) - the balance
• =ELLIBO.DEBIT(accounts, period, [offset]) - the debits in the period
• =ELLIBO.CREDIT(accounts, period, [offset]) - the credits in the period
• =ELLIBO.RATE(from, to, [date]) - an exchange rate, like =ELLIBO.RATE("USD", "INR")

You need a role in Accounting to see the amounts; others see #ACCESS. Ledger formulas are on Standard and up.

Accounts

The first part says which accounts:

• an account code - "4000" - or the start of codes: "4" takes every account whose code starts with 4;
• several, with commas - "4000,4100,42";
• a whole group - "income", "expense", "asset", "liability" or "equity".

Account codes are in Accounting > Chart of accounts.

Periods

Financial years: "FY2026" or "2026-27" is the financial year 1 April 2026 to 31 March 2027.

The period can come from a cell: =ELLIBO.BALANCE("income", B1) with 2026-03 in B1, or built with a formula: =ELLIBO.BALANCE("income", $B$1&"-"&TEXT(C3,"00")).

Offset moves the period by its own size: =ELLIBO.BALANCE("income", "2026-03", -1) is February 2026, and with "2026" and -1 it is the year 2025. Handy for this month against last month or this year against last year.

How amounts are worked out

• Income and expense accounts: the movement within the period.
• Asset, liability and equity accounts: the balance at the end of the period, from the very start (with opening balances).
• Amounts are debits minus credits. Income and liabilities therefore show as minus numbers - put a minus in front for a positive figure: =-ELLIBO.BALANCE("income", "2026").

A profit and loss by month

The Profit and loss by month template does this for you: income, expenses, profit and margin for each month of a year, with a chart. Change the year in B2 and everything follows.