Template · Finance close · Opening soon

Trial balance template

Build a trial balance straight from your general ledger entries: each account's debit or credit balance at the period end, always in balance with the ledger.

Book a demo

You bring

Ledger entries180 rows

AccountDateAmount

Mammoth does the work

You get

One table6 rows

Every account's debit or credit balance at the period end.

AccountAccount nameDebitCreditBalanceEntries

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Trial balance: the resultSample data6 rows

Account	Account name	Debit	Credit	Balance	Entries
1000	Cash	9,591.77	0	9,591.77	31
1200	Receivables	14,410.43	0	14,410.43	31
2100	Payables	0	26,526.33	-26,526.33	29
3000	Equity	0	7,057.26	-7,057.26	26
4000	Revenue	3,650.12	0	3,650.12	39
6000	Expenses	5,931.27	0	5,931.27	24

6 rows in the result · made from 180 input rows. Sample data: illustrative figures, not business results.

What is a trial balance?

A trial balance lists every account's closing balance in debit and credit columns. The two columns total the same; if they don't, an entry is wrong.

How it works

How to use the trial balance template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

General ledger entries: account, date, amount (or debit and credit)

Ledger entries

Account
Date
AmountDebits positive. Debit and credit columns work too.
Account name(optional)

The steps it runs

1Match columns
2Entries up to the period end
3Balance by account

Every step is an ordinary Mammoth step you can open and change.

Trial balance: questions

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.