Xero – Add Opening Balance to Bank Account, Credit Card, PayPal

After setting up a bank account, credit card or PayPal account in Xero, you may need to add the opening balance of the account before importing the transactions. This is done through Xero’s conversion balance settings. In this tutorial, we will add opening balances for a newly set up bank account, credit card and PayPal account in Xero’s demo company.

Set Up the New Accounts

So you can follow the steps in this lesson properly, please set up a bank account and set up a PayPal account in Xero’s demo company. You can also set up a credit card account by using the information in our tutorial on adding a bank account in Xero.

Once you have finished, you should see all three accounts listed in the Bank Accounts section of Xero. To see this, go to Accounts → Bank Accounts from the main menu. All three accounts should have a nil opening balance and no transactions.

Conversion Balances in Xero

Next, we need to go the conversion balances section in Xero. Click on Accounting → Advanced from the main menu to get there.

Then, click on the Conversion Balances link in the Organisation section.

You should now see a list of general ledger accounts and their debit or credit conversion balances. If you cannot see your new bank account, credit card or PayPal account on the list, click on the Show all accounts hyperlink.

Now you should see all three of your new accounts near the top of the list. Here, you can add the opening balances of each account. For this exercise, let’s add the following opening balances:

  • Business Offset Account: type 10,000.00 in the debit column.
  • Company Credit Card: type 1,567.00 in the credit column.
  • PayPal: type 275.14 in the debit column.

Scroll down to the bottom of the page and click on Save to lock in the opening balances.

Check the Results

Navigate back to the main Bank Accounts screen by going to Accounts → Bank Accounts. Now you should see the opening balances you typed in for your new bank account, credit card and PayPal account.

That’s all you need to do to add an opening balance to a bank account, credit card or PayPal account in Xero.

Disclaimer: Our articles and videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and should not be relied upon as such. See our full disclaimer here.

Similar Posts