Step 5 — Opening balances and trial balance validation

What this step does

Step 5 lets you enter your company's opening (starting) balances—the account balances from your prior accounting system or business as of your go-live date. These balances ensure that your financial history is continuous and that your reports show the correct cumulative position. The wizard also validates that debits equal credits (the fundamental accounting equation), preventing errors that would corrupt your entire system.

Before you start

• Identify your go-live date: the date you will start using Usystems (e.g., July 1, 2026). Any transactions before this date must be entered as opening balances here, not as individual documents.
• Gather your prior trial balance. If you have historical accounting records (spreadsheet, prior software, manual ledger), extract a trial balance as of the day before your go-live date. This should list every account and its debit or credit balance.
• Understand the accounting equation: Assets = Liabilities + Equity. In double-entry bookkeeping, total debits must equal total credits. The system will not let you proceed if they do not balance.
• Know your currency: if you operate in multiple currencies, confirm which is your base currency for opening balances.

Steps

1. Set the go-live date. Enter the date when you will begin using Usystems (e.g., "2026-07-01"). This date marks the boundary between your prior accounting and Usystems data.

2. Open the opening balance form. The wizard displays a table with all accounts created in Step 3. For each account, you can enter:

   • Debit balance (if the account is normally a debit balance, e.g., assets, expenses)
   • Credit balance (if the account is normally a credit balance, e.g., liabilities, equity, revenue)

3. Fill in account balances. For each account with a non-zero balance in your prior system, enter the amount in the appropriate column (debit or credit). Leave blank or enter 0 for accounts with no opening balance.

4. Watch the trial balance validation. As you enter amounts, the wizard shows:

   • Total Debits: sum of all debit-side amounts
   • Total Credits: sum of all credit-side amounts
   • Balance status: "In Balance" (green) or "Out of Balance" (red)

5. Correct any imbalances. If totals do not match, review your entries for typos. Common issues:

   • Entering an amount in the wrong column (debit vs. credit)
   • Forgetting to enter a balance for a key account (e.g., equity or retained earnings)
   • Entering only partial balances from a multi-currency period

6. Verify the balance is green. Only when Total Debits = Total Credits can you proceed.

7. Select Continue once the trial balance is in balance and you are confident in your entries.

Accounting impact

Opening balances are a special journal entry—they are recorded as a single entry dated on your go-live date and establish the starting point for all future reports. For example:

Journal Entry (Opening Balance):

• Debit: Accounts Receivable $10,000
• Debit: Inventory $50,000
• Debit: Equipment $100,000
• Credit: Accounts Payable $20,000
• Credit: Bank Loan $80,000
• Credit: Equity (Contributed Capital) $60,000

Once posted, your trial balance and balance sheet will reflect these starting positions. All subsequent transactions build on this foundation.

Tips & common mistakes

• Use your prior trial balance: if you have it, copy balances directly from your previous system or spreadsheet. This is faster and less error-prone than memory.
• Do not enter individual prior transactions: opening balances are summary entries only. If you need to track individual invoices or purchases from before go-live, enter them as separate documents after setup (not as opening balances).
• Multi-currency: if you have assets or liabilities in multiple currencies, the system may create separate accounts per currency. Fill in balances for each currency account separately.
• Retained earnings: if this is the first year of operation, retained earnings will be zero. If you have prior years' profits or losses, they belong in retained earnings, not in current-year revenue or expense.
• Bank reconciliation: if you are migrating from another system, your opening bank balance should match the prior system's closing balance. Do not round; use exact amounts.
• Verification: after setup is complete, you can run a trial balance report from Reports → Trial Balance to double-check that opening balances were correctly recorded.