Import from Spreadsheet
Transactions can be periodically imported from a spreadsheet.
Note that when importing new transactions, you must ensure that your file does not contain any transactions that already exist in our system, otherwise this will create duplicates.
See below the file specifications needed in order to import a spreadsheet into the system.
Date (Required) - Must be entered in YYYY-MM-DD format
Description (Optional) - Used to describe the transaction
Account Type (Optional) - indicate under which account to classify the transaction:
Capital/Revenu (Canada)
Principal/Income (US)
Value (Required) - enter the value of the transaction. Note that formatting is ignored in this field. However, you must ensure that deposits have a positive value, and that withdrawals have a negative value.
Refer to our Sample Spreadsheet below
To upload the spreadsheet to the Estate Accounting section, follow the steps below.
In the Estate Accounting module, click the three-dot menu on the top-right corner of the page.
Choose Import in the drop-down menu.
Drag your CSV or Excel file into Estateably (or click Select File to locate the document on your computer.)
Choose the Estate Account that the transactions will go through, and select a default account type between Capital or Revenue. Click Next to move forward.
Map the field names to the appropriate file columns from your document.
Review the transactions, and make changes as you need. Click Save Transactions to finalize your import.