Skip to main content

Opening Balance Wizard - How to Set Your Opening Balances

Use DoorLoop's Opening Balance Wizard to decide how to split a bank account's opening balance across your properties.

Written by Samuel

Overview

For each bank account, be sure to add an accounting start date and opening balance. See Set Up the Opening Balance and Accounting Start Date of a Bank Account for the full setup steps.

Note: Before starting the Opening Balance Wizard, you need to enter all the properties you'll be managing first, prior to your Accounting Start Date. This can be done manually or via data entry on our end.

How should you set your Opening Balance?

Step 1 - Do you know the balance of each property?

If you know the balance of each property associated with this bank account and all the available funds are tied to those properties, great! That means you can set the balances for each property, and you're done. Note that the amounts set for each property must equal the total amount of the opening balance.

However, if you don't know the balance of each property or if there are other funds included that are not part of your properties, move to Step 2.

Step 2 - Is all the cash in the account related to your properties?

If all the cash in your bank account is related to your properties, then what you can do first is record what you're holding in security deposits for each property. For example, you have $15,000 in your bank account, but while you only know that $10,000 is from security deposits, you don't quite know what the other $5,000 is from.

In this case, we would enter $15,000 as your opening balance and set the balances for each property based on the $10,000 in security deposits. For the remaining $5,000, you have a few options:

  • Add the remaining funds to one property.

  • Distribute the funds equally to each property.

  • Add the funds to a Business Property temporarily until you figure out where the extra funds should go.

At this point, you are done.

However, if the bank account has funds that are not associated with your properties and you want to record those funds, move to Step 3.

What is a Business Property?

A Business Property in DoorLoop refers to a non-existent property in DoorLoop that is used to represent your actual business so you can record business expenses that normally don't fit in with your other properties. For instance, if you're recording the purchase of day-to-day business supplies or other office expenses. You can use the business property to represent any expenses and transactions that are not tied to any specific property.

Step 3 - Do you want to account for funds not related to your properties? (Not Recommended)

Like the previous steps, you'll want to associate the funds that belong to your properties with those properties. At a minimum, you want to take into account all the security deposits first for each property, followed by whatever other funds are associated with those properties.

Whatever is left that still has to do with your business, but not your properties, add those funds to a Business Property. This is a property that represents your business where you record income or expenses that are not associated with your properties in general.

However, if you prefer not to account for funds that are not related to your properties, simply record the security deposits for each property and set your opening balance based on that.

Note that if you don't account for these funds, your DoorLoop Balance will never match your actual bank account.

Did this answer your question?