Solution Properties
Solution ID:
240304191309360
Last Modified Date:
Sat Feb 07 00:06:52 UTC 2026
Taxonomy Path:
Case category//How do I...//processing
Author:
sageadmin
How to enter, edit or delete opening balances
Description
Opening balances show your company’s financial position the day before you start using Accounting. Without accurate opening balances, reports won’t reflect the actual financial position.

 

You can enter opening balances for:

  • Outstanding customer transactions
  • Outstanding supplier transactions
  • Bank account balances
  • General ledger trial balance values

To enter your opening balances, you’ll need:

  • A list of unpaid invoices and credit notes from your customers and suppliers
  • Your trial balance after closing your previous accounting period
  • Your bank statements
  • A list of unreconciled bank items from your previous accounting system (For example, uncashed checks)

It’s recommended to start using Accounting at the beginning of a new accounting period (month, quarter, or fiscal year). You can then generate your final trial balance from your previous system and use it when entering opening balances to ensure accuracy and reconciliation.

You can enter all your opening balances at once or at different times. Enter customer, supplier, and bank balances now, and the rest later.

If you used another system before, you can import customer and supplier opening balances.

Cause
Resolution

Verify your start date

Before you enter opening balances, make sure you’ve entered the start date for your transactions.

  1. Click Settings, Business settings.
  2. Select Financial Settings.
  3. In the Accounts Start Date field, enter the day that you’ll start using Accounting.

     

    EXAMPLE:

    If you stopped using your previous accounting system on September 30, enter October 1.

     

  4. Click Save.

 NOTE: You can’t enter any transactions before this date, only opening balances. 

▼Enter the general ledger account opening balances

  1. Under Opening Balances, click General Ledger.
  2. Verify that the date is correct.
     NOTE: The default date is the day before the Accounts Start Date. Don’t change this.
  3. Enter a reference for your opening balances.
  4. Enter the remainder of your trial balance:
    • Category: Select an account
    • Details: Enter other details if needed
    • Debit: Enter the debit value from the trial balance
    • Credit: Enter the credit value from the trial balance
  5. Enter all values from your trial balance by repeating these steps. The opposite entry posts to the Opening Balances account. Ensure this account has a zero balance after all entries.
  6. Verify the entered balances match your trial balance.
  7. Click Save. Your opening balances will be displayed in the relevant ledger accounts.

 NOTE: You can save your opening balances without entering the full trial balance. A value remains in the Opening Balances account until you enter the full trial balance.

What account types normally hold a debit or credit balance?

  • Assets - Debit
  • Liabilities - Credit
  • Revenue - Credit
  • Expenses - Debit
  • Owners/Shareholders Equity/Capital - Credit

If the Asset balance is negative, enter the opening balance on the Credit side instead of the Debit side. For a positive opening balance, enter the value on the Debit side.

▼Enter your bank account opening balances

 NOTE: You can also enter opening balances for your bank accounts when creating new accounts or from within the bank account record.  

  1. Under Opening Balances, click Bank.
  2. Select the appropriate Bank Account. To change the branch or account numbers, go to Banking.
  3. Enter a Date that is before the Accounts Start Date.

    EXAMPLE:

     If the start date is October 1, use September 30

     

  4. Select the Type to indicate whether the balance is a debit or a credit.
  5. Enter the Opening Balance based on your bank statement as of the opening balance date.
  6. Repeat these steps for each bank account.
  7. Record any uncleared bank items from your previous system on separate lines using the original transaction dates.
  8. Reconcile these items once they appear on your bank statement.
  9. Click Save.

The bank opening balances will be displayed in your bank records and the relevant ledger accounts.

 NOTE: For reconciled balances, post the opposite entry for the difference. Example: Enter a $1000 credit if the balance needs to be $4000 instead of a $5000 debit.

To edit or delete an opening balance

  1. Under Opening Balances, click the type of opening balance you want to edit or delete.
  2. Do one of the following:
    • Click Delete next to an account to delete it
    • To edit an opening balance, change the applicable line and click Save

 CAUTION: Changing your opening balances can create a difference between Debits and Credits on the General Ledger Opening Balances page. The difference posts to the Opening Balances account (9100). Ensure the values match your trial balance. Update as needed and verify the balance for ledger account 9100 is zero before saving.

Optional steps

If you track customers (AR) or suppliers (AP), follow these steps:

Create a new customer or vendor record by following the article How to add and manage contacts.

▼Enter customer opening balances

  1. Under Opening Balances, click Customer.
  2. Click New Opening Balance, then enter:
    • Customer: Select the customer
    • Date: The date of the invoice or credit note (must be before your start date)
    • Type: Select Bill or Credit Note
    • Reference: Enter a reference (for example, invoice number)
    • Details: Add any relevant details
    • Total: Enter the amount
    • Tax Rate: Select if applicable

For unpaid deposits, enter them as credit notes. If using foreign currencies:

  • Total (currency symbol): Enter the amount in the customer’s base currency (for example, CAD)
  • Exchange Rate: Use the latest or original rate

Click Save and repeat for each customer. Totals appear in the Sales Control Account, with the offset in the Opening Balances Control Account.

▼Enter supplier opening balances

  1. Under Opening Balances, click Supplier.
  2. Click New Opening Balance, then enter:
    • Supplier: Select the supplier
    • Date: Enter a date before your start date
    • Type: Select Bill or Credit Note
    • Reference, Details, Total: As above

For unpaid deposits, enter them as credit notes. For foreign currencies:

  • Total (currency symbol): Enter in the supplier’s base currency (for example, USD)
  • Exchange Rate: Use the latest or original rate

Click Save and repeat. Totals appear in the Accounts Payable Control Account, with the offset in the Opening Balances Control Account.

 

 

Steps to duplicate
Related Solutions