How to create a trial balance

User Talk Formulas
1

Hi there folks.
I have been using gsheets for a few years and have setup a trial balance.
I have a sheet with rows of transactions as below
Date Account Income Expense Description

I have another sheet with totals on it like a balance sheet like below
Account Income Expense
Electric £100
Subs £450
and so on>
is there any way of doing that with Seatable at all and create a report with all totals etc?
I can provide the sheet if required and the formulas used are below
=SUMIF(Ledger!F:F,“Fund Raising”,Ledger!E:E)
Thank you for any help>

2

Hi @Elgin,

Sorry I’m definitely not a trial balance specialist so I lacks few information/explanations to fully understand your case, but it seems definitely possible to do such a case with SeaTable:

  • you can create a first account table
  • your transactions table will have a link-type column towards the account table

Doing so, you’ll be able, in the account table, to display the global amount of Income and/or Expense using a rollup/sum formula

then, you can generate a report containing the info you need using, for example, the Page design plugin

Bests,
Benjamin

1 Like