Finance

Opening Balances

Start your books at the right position — every customer, every vendor, every ledger account.

Opening balances are the starting position of your books. Get them right and every report from day one is accurate; get them wrong and errors compound across every period. In Trabalance they come in two ways: customer and vendor balances as Opening Balance documents, one per party, and the rest of the balance sheet as a manual journal. Both offset to the system account Opening Balance Equity, which nets to zero once everything is in.

A customer Opening Balance document, what it posts, the manual journal for ledger accounts, and the equity account that should net to zero.

When Opening Balances Are Needed

ScenarioWhat You Are EnteringExpected Outcome
Migrating from another systemClosing balances from the old system: every customer and vendor with a balance, then the balance-sheet accountsTrabalance matches the old system's closing trial balance; aged receivables and payables match its aging reports
A new entity in a groupThe starting position of the new company before current-year activityConsolidated reports include the correct opening position
A new fiscal yearNothing — balances carry forward automaticallyRetained Earnings is derived by the reports; income and expense start from the new year's first date

The Opening Balance Equity Account

A core system account that exists solely to absorb the other side of every opening entry. When every customer, vendor and ledger account has been entered, it should carry a zero balance — the debits entered (assets, receivables) equal the credits entered (liabilities, payables, equity).

How Opening Balance Equity absorbs each entry
AccountDebitCreditDescription
Example Bank — Operating45,000.00—Bank balance as at the migration date
Opening Balance Equity—45,000.00Offset — absorbed here during migration

The Migration Process

1
Choose the opening date

The last day of your previous period — the day before you start transacting in Trabalance. If your first transaction is on 1 April, every opening balance is dated 31 March.

2
Enter customer opening balances

Navigate to: Finance → Opening Balances → New (the customer side). One Opening Balance document per customer:

FieldDetails
CustomerRequired
DateThe opening date
ItemsOne line per outstanding invoice, so receipts can be applied to each and aging is right from day one — or a single line for the total
Center, tags, project, memo, attachmentsOptional

Post it. The document posts DR Accounts Receivable for that customer, CR Opening Balance Equity.

Customer Opening Balance — Acme Corp, 8,500.00 outstanding
AccountDebitCreditDescription
Accounts Receivable · Acme Corp8,500.00—Outstanding as at the opening date
Opening Balance Equity—8,500.00Offset
💡TIP

Export the aged receivables report from the old system first and enter from it — name, invoice, amount — so the aged AR report in Trabalance matches from the first day.

3
Enter vendor opening balances

Navigate to: Finance → Opening Balances → New on the vendor side (the same page with ?match=vendor). One document per vendor; it posts CR Accounts Payable for that vendor, DR Opening Balance Equity.

Vendor Opening Balance — Global Trading Ltd, 12,000.00 outstanding
AccountDebitCreditDescription
Opening Balance Equity12,000.00—Offset
Accounts Payable · Global Trading Ltd—12,000.00Outstanding as at the opening date
4
Post the ledger account balances as a manual journal

There is no separate screen for ledger-account opening balances — they are a journal. Navigate to: Finance → Journals → New, dated the opening date, with one line per balance-sheet account and Opening Balance Equity as the balancing line.

AccountEnter?Notes
Bank and cash accountsYesThe statement balance at the opening date
Accounts Receivable / Accounts PayableNoAlready posted per party by the documents above
InventoryYesTotal stock value; set quantities in Operations as well
PrepaymentsYesUnexpired prepayments
Fixed assets and accumulated depreciationYesCost as a debit, accumulated depreciation as a credit
Loans and other liabilitiesYesOutstanding principal, tax liabilities, accruals
Share capital, reservesYesAs at the opening date
Retained earningsUsually noPost the prior-period profit only if the old system carried it as a balance; otherwise leave Opening Balance Equity to hold it
Income and expense accountsNoP&L accounts do not carry forward
Ledger opening balances — one journal
AccountDebitCreditDescription
Example Bank — Operating45,000.00—Bank statement balance
Inventory Asset12,400.00—Stock at cost
Bank loan—20,000.00Outstanding principal
Opening Balance Equity—37,400.00Balancing line
5
Check Opening Balance Equity

Finance → Chart of Accounts → Opening Balance Equity → its ledger. Once every balance is in, total debits should equal total credits and the closing balance should be zero.

BalanceWhat It MeansAction
ZeroDebits entered equal credits entered — the opening trial balance balancesDone
Credit balanceMore assets and receivables than liabilities, payables and equityA liability, an equity account or a vendor balance is missing
Debit balanceMore liabilities and payables than assetsAn asset or a customer balance is missing, or a liability was entered twice
OrderCategoryReason
1Customers (per party)Cross-check against the old aged AR before moving on
2Vendors (per party)Cross-check against the old aged AP
3Bank accountsEasiest to verify against statements
4Inventory, prepayments, fixed assetsFrom count sheets and the asset register
5Loans, tax and other liabilities
6EquityShould bring Opening Balance Equity to zero if everything else is right

Sub-Ledger Reconciliation

Because customer and vendor balances are entered as documents, the Accounts Receivable and Accounts Payable control accounts are built from the party lines beneath them — never posted to directly. The AR balance equals the sum of the customer documents; the AP balance equals the sum of the vendor documents. If the old trial balance showed 80,000.00 of receivables and your documents total 80,000.00, the sub-ledger is reconciled.

After Posting

ActionAllowed?Notes
View the documentsYesFinance → Opening Balances lists them; each opens like any document, with its journal
Apply receipts and payments to themYesSettlement exhausts the Opening Balance (Statement) first, then invoices and bills by their own dates
Add more opening balances laterYesEach new document or journal still offsets to Opening Balance Equity — check it returns to zero
Edit a posted Opening Balance documentYesLike any document, editing re-posts its journal
Void oneYesVoiding retires its journal
Write off at period closeYesThe AR / AP adjustment in the close wizard lists opening balances among the party's documents