Estate Accounting

This section is used to record all of the transactions made by the estate. This Accounting will be necessary to wind up the estate, as it will be used to generate the Final Account the executor must provide to the heirs. 

It can also be used to provide regular updates to the heirs on the status of the estate.

Recording all of the estate's transactions can be done in one of three ways: by importing a spreadsheet, a PDF, or adding the transactions manually. All inputs roll up into transaction reports and Passing of Accounts reports.

Estate_Accounting.png

1. 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
  • Category (Optional) - the following categories are available in the import file. If you leave this field blank, you will need to categorize the transaction later in the app. Likewise, if you enter an invalid category name, the transaction will need to be categorized in the app later.
    • Valid deposit categories:
      • Income
      • Interest
      • Loan Repayment
      • Other Deposit
    • Valid withdrawal categories:
      • Estate Expense
      • Executor Loan Interest
      • Executor Loan Repayment
      • Executor Reimbursement
      • Interest Charge
      • Other Withdrawal
  • Account Type (Required) - indicate under which account to classify the transaction:
    • Capital
    • Revenue
  • Quantity (Optional) - if buying or liquidating multiple units (such as shares), you can indicate the quantity. Otherwise, leave this blank or enter 1
  • 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 import spreadsheet.

To upload the spreadsheet to the Estate Accounting section, follow the steps below.

  1. In the Estate Accounting module, click the three-dot menu on the top-right corner of the page.
  2. Choose Import in the drop-down menu.
  3. Drag your CSV or Excel file into Estateably (or click Select File to locate the document on your computer.)
  4. 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.
  5. Map the field names to the appropriate file columns from your document.
  6. Review the transactions, and make changes as you need. Click Save Transactions to finalize your import.

2. Import PDF bank statements

Transactions can be imported from a monthly bank statement in PDF format using DocuVision, our AI document parser.

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.

To upload the PDF to the Estate Accounting section, follow the steps below.

  1. In the Estate Accounting module, click the three-dot menu on the top-right corner of the page.
  2. Choose Import in the drop-down menu.
  3. Drag your bank statement into Estateably (or click Select File to locate the document on your computer.)
  4. The import can take anywhere between 30 seconds to a few minutes to be parsed, depending on the size of your file. You can close the pop-up window in the meanwhile.
  5. Once your import is complete, you will see a red dot next to the bell icon in the top-right corner. Click on the bell to open the Notifications window, and choose the notification that indicates the extract is completed.
  6. 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.
  7. Review the transactions, and make changes as you need. Click Save Transactions to finalize your import.

3. Add Transactions Manually

Lastly, transactions can be recorded manually by selecting Add Transaction, and entering the details of the transaction.

Below are the steps to adding a transaction:

  1. Click Add Transaction in the top-right hand side.
  2. Select the Estate Bank Account, and the date of the transaction.
  3. Indicate whether the transaction was a deposit or withdrawal, and choose an appropriate category for it.
  4. Enter a value and name for the transaction.
  5. If needed, change the suggested Account Type.
  6. Optional: add notes related to the transaction, and check the box to exclude the transaction from the executor compensation if relevant.
  7. Click Save to finalize the entry.

Note: if you create a transaction of the categories "Asset sale / Bank transfer / Deposit" or "Debt payment", these will associate the transaction to an Inventory asset or liability item respectively. 

You will need to select the associated items/bank accounts that are being liquidated, repatriated, or paid from a drop-down list. Once you do, a suggested transaction value, name, and account type will populate for you to edit as necessary.

For more information on recording transactions to the Capital or Revenue Accounts, see here.

Note: Transactions can also be generated via selling assets or paying liabilities in the current inventory, as well as through logged distributions to beneficiaries.

View the article on Adding Transactions Manually for a more detailed runthrough.

Accounting reports

Throughout the process, accounting reports can be created by selecting Reports in the top-right corner. The following documents can be leveraged:

  1. Transaction report
  2. Holdings report
  3. Informal accounting report (highlights amount available for distribution, proposed distribution schedule, and list of receipts and disbursements)
  4. Formal accounting report (highlights reconciliation report; transactions passing through both Capital and Income accounts. Can customize what sections are added to the final reporting.)

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Articles in this section