Skip to Content

Opening Balances

Set your starting account balances when beginning with Rebased. Essential for accurate financial reporting and bank reconciliation.

Overview

Opening balances are the starting point for your accounts in Rebased. They represent the value of your assets, liabilities, and equity at the moment you begin using the platform.

Who needs opening balances:

  • Businesses migrating from another system
  • Businesses that have been trading before using Rebased
  • Any business with existing assets, liabilities, or equity

Who can skip this:

  • Brand new businesses starting from zero
  • If you applied the Fresh Start template and have no prior activity

When to Set Opening Balances

Fresh Start Path

After applying the template:

  1. Go to Settings → Accounting → Opening Balances
  2. Enter balances for accounts that have value
  3. Leave zero-balance accounts empty

Migration Path

Opening balances are imported automatically from your Trial Balance. You can review and adjust them after migration:

  1. Go to Settings → Accounting → Opening Balances
  2. Verify imported balances
  3. Make corrections if needed

Understanding Opening Balances

What Are Opening Balances?

They represent your financial position at a specific date:

Account TypeExample Opening Balances
AssetsBank accounts, equipment, inventory, amounts customers owe you
LiabilitiesLoans, amounts you owe suppliers, tax owing
EquityOwner investment, retained earnings from prior periods

The Accounting Equation

Opening balances must satisfy:

Assets = Liabilities + Equity

Or in journal entry terms:

Total Debits = Total Credits

Rebased validates this balance automatically.

Conversion Date

Your opening balances are as of your conversion date:

  • For Fresh Start: Usually business start date or today
  • For Migration: The date you chose to switch to Rebased

All transactions before this date are represented by these balances.

Setting Opening Balances

Step 1: Gather Information

From your previous system or records:

  • Bank statements (current balances)
  • Loan statements (outstanding amounts)
  • Asset register (equipment, vehicles value)
  • Customer list (amounts outstanding)
  • Supplier list (amounts owing)
  • Equity/owner investment records

Step 2: Navigate to Opening Balances

Go to: Settings → Accounting → Opening Balances

You’ll see a table with:

  • Account code and name
  • Account type
  • Current opening balance field (editable)
  • Running total of debits and credits

Step 3: Enter Balances

For each account with a non-zero balance:

  1. Find the account in the list
  2. Enter the balance amount
  3. Use positive for normal balance direction:
    • Assets: Positive = Debit balance
    • Liabilities: Positive = Credit balance
    • Equity: Positive = Credit balance
    • Revenue: Positive = Credit balance
    • Expenses: Positive = Debit balance

Example entries:

AccountTypeOpening Balance
Business Bank AccountAsset$15,000
Accounts ReceivableAsset$8,500
EquipmentAsset$25,000
Accounts PayableLiability$4,200
Bank LoanLiability$20,000
GST CollectedLiability$1,800
GST PaidAsset$650
Owner CapitalEquity$23,150

Step 4: Balance Validation

Rebased automatically checks:

Total Debits = Total Credits

If balanced: ✅ You can save

If not balanced: ❌ Review and correct

Common causes of imbalance:

  • Missing accounts
  • Transposed numbers
  • Wrong sign (debit vs credit)
  • Math errors

Step 5: Save

Once balanced, click Save Opening Balances.

The balances are recorded and will appear in:

  • Balance Sheet
  • Trial Balance
  • General Ledger
  • Bank reconciliation starting point

Account-Specific Guidance

Bank Accounts

Enter: Current bank balance as of conversion date

Verification:

  • Check against bank statement
  • Include all bank accounts (checking, savings, term deposits)
  • Exclude pending transactions not yet cleared

Note: This becomes your starting point for bank reconciliation.

Accounts Receivable

Enter: Total amount customers owe you

Verification:

  • Sum of outstanding invoices
  • Check Aged Receivables report from old system
  • Include partially paid invoices (balance only)

Link: AR opening balance should equal imported outstanding invoices (if migrating)

Accounts Payable

Enter: Total amount you owe suppliers

Verification:

  • Sum of unpaid bills
  • Check Aged Payables report from old system
  • Include partially paid bills (balance only)

GST/VAT Accounts

GST Collected (Liability):

  • GST you owe the tax authority
  • From prior period BAS/tax return
  • Net position if refund due

GST Paid (Asset):

  • GST you’re owed by tax authority
  • Input tax credits carried forward

Tip: These should reflect your last BAS position.

Fixed Assets

Enter: Current written-down value

Not original purchase price (unless newly bought)

Include accumulated depreciation already recorded in old system.

Example:

  • Equipment cost: $30,000
  • Accumulated depreciation: $5,000
  • Opening balance: $25,000

Loans and Liabilities

Enter: Outstanding principal amount

Exclude interest not yet accrued — this will be recorded as it occurs in Rebased.

Equity Accounts

Retained Earnings:

  • Profit/loss from prior years
  • From your old system’s balance sheet

Owner Capital/Drawings:

  • Money invested by owners
  • Less any drawings taken

Balancing Tips

Use Your Previous Balance Sheet

If migrating, your old system’s Balance Sheet as of the conversion date should match your opening balances entry.

The “Plug” Account

If you’re slightly out of balance and can’t find the error:

  1. Check for missing accounts
  2. Verify all amounts
  3. Small differences can go to a “Suspense” or “Opening Balance Adjustment” account
  4. Correct later when you find the source

Common Balancing Issues

IssueSolution
Off by small amountCheck rounding, GST cents
Off by large amountMissing account or transposed digits
Can’t balanceUse suspense account temporarily
Assets don’t matchCheck bank, AR, inventory
Liabilities don’t matchCheck AP, loans, tax

After Setting Opening Balances

Verification

Check these reports:

  1. Balance Sheet — Assets = Liabilities + Equity
  2. Trial Balance — Debits = Credits
  3. General Ledger — Individual accounts show opening balance

Bank Reconciliation

Your bank account opening balance becomes the starting point:

  1. Go to Bank → Reconciliation
  2. Opening balance should match bank statement at conversion date
  3. Reconcile transactions from conversion date onwards

First Reports

Run these to verify setup:

  • Balance Sheet — Should reflect your position
  • Trial Balance — Should show all opening balances
  • Aged Receivables/Payables — Should match opening AR/AP

AU-Specific Notes

BAS Considerations

Opening GST balances should reflect your last lodged BAS:

  • GST Collected: Any GST still owing from prior BAS
  • GST Paid: Any input credits being carried forward

Timing tip: If possible, set conversion date just after BAS lodgment for clean GST position.

EOFY Transitions

Converting at financial year end (June 30):

  • Cleanest opening balance
  • Prior year closed in old system
  • Full year ahead in Rebased
  • Retained earnings clear

Converting mid-year:

  • Current year earnings still accumulating
  • Partial year data in both systems
  • YTD reports need to combine both

Tax Code Considerations

Ensure opening balance accounts have correct tax codes:

  • Bank accounts: N/A (no GST on cash)
  • Receivables/payables: N/A (GST already separated)
  • GST accounts: N/A (these ARE the GST)

Migration vs Fresh Start

Migration Path

Opening balances imported from Trial Balance:

  • All accounts and balances transferred
  • System creates opening balance journal
  • You review and can adjust
  • Less manual entry needed

Fresh Start Path

You enter opening balances manually:

  • Only enter accounts with non-zero balances
  • Leave zero accounts empty
  • More control over setup
  • Takes longer if you have many accounts

Troubleshooting

”Out of Balance” error

Check:

  1. Did you enter all relevant accounts?
  2. Are debits and credits in correct direction?
  3. Any transposed numbers?
  4. Math errors in your source data?

Fix:

  • Review each entry
  • Check against source balance sheet
  • Use suspense account temporarily if needed

Opening balances not showing in reports

Causes:

  • Not saved properly
  • Wrong conversion date
  • Accounts archived or disabled

Fix:

  • Re-save opening balances
  • Check conversion date setting
  • Verify accounts are active

Bank reconciliation doesn’t match

Issue: Opening bank balance doesn’t match bank statement

Check:

  • Date alignment (opening balance date vs statement date)
  • Pending transactions
  • Unreconciled items in old system
  • Different account (checking vs savings)

AR/AP doesn’t match aged reports

After migration:

  • Opening AR should equal imported outstanding invoices
  • Opening AP should equal imported outstanding bills

If different:

  • Some invoices/bills may not have imported
  • Partial payments recorded differently
  • Credit notes applied in old system

Can’t edit opening balances

After transactions recorded:

  • Opening balances lock once you start transacting
  • Prevents changing historical position

If you need to change:

  • Make adjustment via journal entry
  • Or contact support for assistance

Best Practices

Document Your Sources

Keep records of:

  • Bank statements used
  • Aged receivables/payables reports
  • Previous system balance sheet
  • Any adjustments made

Verify Before First Transaction

Run reports and verify opening balances before:

  • Creating first invoice
  • Recording first bank transaction
  • First bank reconciliation

Reconcile Early

Do your first bank reconciliation soon after setup:

  • Confirms opening balance is correct
  • Establishes reconciliation baseline
  • Identifies any issues early

Keep Old System Access

Maintain access to your previous system for:

  • Historical reference
  • Audit trail
  • Verification of opening balances
  • Year-end reporting

Last updated: February 24, 2026

Last updated on