Overview
You’ve decided on an accounting start date for your bank account, and now it’s time to implement that date in DoorLoop. Whether the date is now, in the future, or the past, you will need the following information:
Bank account opening balances: from your bank statement
Uncleared bank transactions: undeposited payments, both incoming and outgoing
Tenant carry-forward lease balances: what your tenants owe
Bank account opening balances
To accurately track a bank account balance, DoorLoop needs an opening balance amount. All revenue to this bank account is added to—and paid expenses get subtracted from—this opening balance amount.
The opening balance is the amount in the bank account at the end of the day prior to your accounting start date. For examples:
If you are starting on the 1st of a month, enter the ending balance from the last day of the previous month.
If you are starting at the beginning of this year, enter the balance on Dec. 31 of last year.
As you use DoorLoop, if you’ve entered your opening balance and all transactions correctly, the resulting DoorLoop Balance will match your real-world bank balance.
Uncleared bank transactions
When you set an opening balance, there may be uncleared or pending transactions for this bank account. It is important to note these transactions, because they will not be included in the opening balance amount.
In order for your DoorLoop Balance to accurately reflect your real-world bank balance, these pending transactions need to be created in DoorLoop because they were not included in the opening balance amount.
It's ok if the payment or expense dates you enter in DoorLoop are before your accounting start date, they will still add to or subtract from the opening balance. This is also why it is important not to create payments and expenses already included in your opening balance—they will essentially be counted twice in your DoorLoop balance!
To create lease charges and payments for pending rent deposits not included in your opening balance, use this Lease Transactions Overview guide.
For uncleared expense payments, use these instructions to create expenses.
Alternate advanced method: Edit your bank account opening balance to include the uncleared transactions.
Tenant balances
When you choose an accounting start date, your tenants may either owe money or have lease credit from early or overpayments as of that date. If so, this needs to be reflected on their leases so future lease transactions reflect the true running balance.
To enter a beginning balance owed on a lease:
To enter a beginning balance owned on a lease, click Leasing on the main menu and then click Active Leases. Find the lease you need to enter a balance for and click on it.
Click the Transactions tab and click on the Post Charge button.
For the Due Date, enter the accounting start date.
For Category, pick the revenue account of the charge still owed.
For the optional Description, enter something like “Carry-forward balance” to help you remember why you created this charge.
Enter the Amount.
Add additional charges to other revenue accounts using the Add Line Item link as needed.
Click Save when you are finished.
To enter a starting credit balance for a lease:
To enter a starting credit balance for the lease, click Leasing on the main menu and then click Active Lease. Find the lease for which you need to enter a balance and click on it.
Click the Transactions tab and click on the Issue Credit button.
For the Date Issued, enter the accounting start date.
For Category, pick “Opening Balance” because this money is already reflected in the opening balance of one of your bank accounts.
For the optional Description, enter something like “Carry-forward balance” to help you remember why you created this credit.
Enter the Amount.
Click Save when you are finished.
That’s it! With your accounting start date set, opening balances entered, and pending transactions accounted for, you are set to track all future transactions in DoorLoop.