Overview
Historical security deposits are imported through Company > Import Data.
This process is intended for importing historical lease deposit records. It is typically completed with guidance from the SIRE team rather than independently by end users.
Open The Historical Deposits Import
Navigate to Company > Import Data.
Expand Leases and locate Historical Deposits.
You can either:
-
Select Import to open the FlatFile window and complete the import there.
-
Select Template to download the Historical Deposits template.
After the import is submitted, SIRE processes the records asynchronously.
Information Included In The Import
The historical deposit import supports the following information:
-
Lease
-
Tenant ID
-
Unit ID
-
Deposit Type
-
Refundable
-
Amount
-
Invoice Number
-
Item ID
-
Item ID GL Account Number
-
GL Account Number
-
Bank ID
-
Letter of Credit Bank, when applicable
-
Letter of Credit Amount, when applicable
-
Letter of Credit Expiration Date, when applicable
Validation
Before saving the records, SIRE verifies that:
-
The lease exists in the company.
-
The tenant is associated with the lease.
-
The unit is associated with the lease.
-
The deposit type exists in Company > My Preferences.
-
The Item ID GL account exists and is active in the General Ledger.
-
The GL account exists and is active in the General Ledger.
-
The bank account exists and is active for the entity associated with the property.
Records that fail validation are not saved. The processing notification identifies the affected records and the validation issue.
Records Created During Processing
For each successfully processed historical deposit, SIRE:
-
Creates the deposit record in SIRE.
-
Creates an invoice in Sage Intacct using the imported invoice number, amount, and item ID.
-
Creates a historical journal entry using the imported GL account information.
-
Creates a payment for the imported amount and applies it to the invoice using the imported bank account.
The imported deposit record is stored with its related lease, tenant, unit, and accounting information.
Processing Notification
Historical deposit imports are processed in the background.
SIRE sends a notification indicating whether the import was successful and identifying any records that could not be processed.
Frequently Asked Questions
Where Do I Start The Historical Deposit Import?
Navigate to Company > Import Data, expand Leases, and locate Historical Deposits.
Can I Use The Import Option Or A Template?
Yes. Select Import to open the FlatFile window, or select Template to download the available template.
Do Leases, Tenants, And Units Need To Exist Before Importing?
Yes. The import validates that the lease exists and that the tenant and unit are associated with that lease.
Where Are Deposit Types Obtained?
Deposit types come from Company > My Preferences.
What Happens When A Record Fails Validation?
The record is not saved, and the processing notification identifies the validation issue.
What Does SIRE Create For A Successful Import?
SIRE creates the deposit record, the related Sage Intacct invoice, a historical journal entry, and a payment applied to the invoice.