Bulk Import Best Practices & FAQ
The Bulk Import Template in Crunchafi Lease Accounting is designed for importing large lease portfolios of over 30 leases at once, must be used without modification via the Add Leases > Manual entry > Bulk Import process, requires prior administrative setup, supports limited data fields (up to 5 payment streams, 2 cost center allocations, 3 existing balances, and 5 custom fields), does not allow partial imports if errors exist, and still adheres to the Review and Approve workflow unless disabled in Policies.
When should I use the bulk import template?
The Bulk Import Template can be used to import a large lease portfolio into Crunchafi Lease Accounting all at once. It is recommended to use bulk import if you have more than 30 leases.
Where do I start the bulk import process?
Click Add Leases > Manual entry, then navigate to the Bulk Import button at the top right.
On the import leases screen, read the Lease Import Instructions. The instructions will guide you on what Administration setup needs to occur before importing the template, and what the limitations are. The most up-to-date bulk import template is available on the left.
Can I modify the import template or create my own?
No. You must use the template provided in the software. If any changes are made to the template or if a different template is used, it will cause a template error and fail to import.
Does Review and Approve still apply to bulk import?
Yes! If you don't want to use the Review and Approve workflow when importing your leases through bulk import, you will first need to go to the Policies tab of Administration and uncheck Review and Approve.
Does Crunchafi Lease Accounting do a partial import of leases if there are errors in my file?
No, it will only import the leases once all errors have been cleared. Once the import is complete, the leases will appear in the grid on the My Leases screen.
For more information on troubleshooting import errors, please see the Troubleshooting Bulk Import Error Logs article.
Are there any limitations to bulk import?
Yes, bulk import can only be used for initially adding leases into LeaseCrunch. There are also limitations on the data that can be initially imported:
- Up to 5 payment streams
- Up to 2 cost center allocations for expenses
- Up to 3 existing balances from previous lease accounting guidance
- Up to 5 custom fields
After a successful bulk import, additional data can be added to a lease manually within the software.