cancel
Showing results for 
Search instead for 
Did you mean: 
coppens1
Level 3

Accounting for Estates and Trusts

I have searched here for how to set up QB for an Estates and Trusts General Ledger (not Law firm Trust Accounts).  The only relevant postings were under 'Quickbooks for fiduciary accounting'.

But they don't solve the problem, and the solutions proposed are for QB online only.  

 

To restate the problem, how do I set up an 'Estate or Trust' Chart of accounts in QB, including Principal Accounts and Income Accounts?  Both Principal and Income Accounts need sub accounts for assets, liabiltiies, income, and expense.  Both Principal and Income Accounts are in the same set of books.  

Reference:  Google  'Bloomberg.com, accounting for trusts and estates'.

 

 

Solved
Best answer March 25, 2022

Best Answers
coppens1
Level 3

Accounting for Estates and Trusts

Dear JamesPaul, Thank you very much. It worked. I set up the trust principal and income accounts under Other Assets and Other Liabilities, and was able to get it to work.

Now the only problem is that I selected 'accrual basis' when I set up the trust, and I need to change that to 'cash basis'. I could not find it in 'help'. How do I do that? JC

 

View solution in original post

Rasa-LilaM
QuickBooks Team

Accounting for Estates and Trusts

I’m glad to know you’re able to create the account, coppens1.


We’ll have to configure the setup in your Preferences to change the accounting method. Let me help show you the steps.


Before proceeding, make sure you’re the administrator in the company file. This is the user type that has permission to update the reporting preferences.


To set the reporting method:

 

  1. In QuickBooks Desktop (QBDT), head to the Edit menu at the top bar to select Preferences.
  2. Navigate to the Reports & Graphs menu on the left panel and choose the Company Preferences tab.dt report method.png
  3. In the SUMMARY REPORT BASIS section, tick the box for Cash and click OK.dt report method.png


This reference provides more in-depth information into this process: Differentiate Cash and Accrual basis.


Additionally, this resource covers basic information about reports in QuickBooks Desktop: Understand reports. From there, you’ll learn about customizing your statements, memorizing one, setting up a schedule, etc.


Keep in touch if you have other questions on how to set your accounting method. I’ll be around to assist further. Have a great rest of the day.

View solution in original post

13 Comments 13
jamespaul
Moderator

Accounting for Estates and Trusts

 Hello, Coppens. 

 

I'd like to share a general idea on how you can set up your estate or trust Chart of Accounts in QuickBooks Desktop. 

 

Generally, you can select a specific account type as you manually create an account in QuickBooks Desktop. You can use Other Asset, Other Current Liability and whatnot for your estate or trust Chart of Accounts accounting setup. 

 

To create an account: 

 

  1. Go to Lists, then select Chart of Accounts
  2. Right-click on the window, then select New.
  3. Select a specific account type needed for your trust or estate accounting. 
  4. Hit Continue.
  5. Enter a name for the account.
  6. If you're creating a subaccount, you can check the Subaccount of box and attach it to a parent account. 
  7. Enter a description and set a tax mapping if needed.
  8. Hit Save & Close

 

This is just a general way of creating your accounts in QuickBooks Desktop. I would still recommend reaching out to an accountant well-versed in the Desktop version.

 

They'll guide you on how to properly set up the transactions forms to record your entries and help you track your balances. 

 

Since you've already tried Google, you can look for a ProAdvisor near your area: https://quickbooks.intuit.com/find-an-accountant/.

 

If you need to see those entries and how they are tracked through reports, you can check this article for a guide: Understand reports,

 

Do you need help recording your transactions or do you have any other concerns regarding your Chart of Accounts? Please let me know and I'll share some details and guides with you. 

coppens1
Level 3

Accounting for Estates and Trusts

Dear JamesPaul, That sounds like a good idea.  I will give it a try and get back to you.  JC

coppens1
Level 3

Accounting for Estates and Trusts

Dear JamesPaul, Thank you very much. It worked. I set up the trust principal and income accounts under Other Assets and Other Liabilities, and was able to get it to work.

Now the only problem is that I selected 'accrual basis' when I set up the trust, and I need to change that to 'cash basis'. I could not find it in 'help'. How do I do that? JC

 

Rasa-LilaM
QuickBooks Team

Accounting for Estates and Trusts

I’m glad to know you’re able to create the account, coppens1.


We’ll have to configure the setup in your Preferences to change the accounting method. Let me help show you the steps.


Before proceeding, make sure you’re the administrator in the company file. This is the user type that has permission to update the reporting preferences.


To set the reporting method:

 

  1. In QuickBooks Desktop (QBDT), head to the Edit menu at the top bar to select Preferences.
  2. Navigate to the Reports & Graphs menu on the left panel and choose the Company Preferences tab.dt report method.png
  3. In the SUMMARY REPORT BASIS section, tick the box for Cash and click OK.dt report method.png


This reference provides more in-depth information into this process: Differentiate Cash and Accrual basis.


Additionally, this resource covers basic information about reports in QuickBooks Desktop: Understand reports. From there, you’ll learn about customizing your statements, memorizing one, setting up a schedule, etc.


Keep in touch if you have other questions on how to set your accounting method. I’ll be around to assist further. Have a great rest of the day.

coppens1
Level 3

Accounting for Estates and Trusts

Rasa-LilaM QBTeam 270322 Chg to CashBasis worked

Thanks, it worked. JC

SashaMC
Moderator

Accounting for Estates and Trusts

Hello coppens1,

 

I am so happy our Community was able to help!  If you have any questions in the future, don't hesitate to let us know. We will be here to assist! 

coppens1
Level 3

Accounting for Estates and Trusts

Dear James Paul, We communicated earlier this year about Trust accounting, and you helped me set up my Chart of Accounts.  

 

I have been successfully recording the transactions for a trust for about 18 months of transactions.  But I am not clear as to how to close the income and expense accounts at year end each year.  They are included in Other Current Liability accounts, and do not automatically close to retained earnings.   What do you suggest? 

 

Bear in mind I am using the regular Quickbooks program, which is normally intended for a 'for profit' enterprise.

coppens1
Level 3

Accounting for Estates and Trusts

No reply from James Paul.  How about someone else knowledgeable about  Estates and Trusts.  Hello, I know you are out there.  JC

JaeAnnC
QuickBooks Team

Accounting for Estates and Trusts

I've come to help, coppens.

 

Let me assist you further in closing your income and expense accounts in QuickBooks Desktop (QBDT) to ensure the accuracy of your books.

 

If you have to close your accounts, don't worry. QBDT performs certain year-end adjustments based on the start month of your fiscal year. Please refer to the following:

 

  • To begin your new fiscal year with zero net income, QBDT adjusts your Income and Expenses accounts at year-end.
  • QBDT performs an adjusting entry to your net income. For instance, if your profit for the year was $12,000, the equity portion of your Balance Sheets displays a line for a net income of $12,000 during the last day of your fiscal year.
  • QBDT increases your Retained Earnings equity account by the previous year's net income and decreases your net income by the same amount on the first day of the new fiscal year. 

 

I'd suggest reading this article for the full details: Close your books in QuickBooks Desktop.

 

For further assistance in closing your books, I recommend seeking advice from your accountant. If you're not associated with one, you can visit our Find a ProAdvisor page to find one in your area.

 

In addition, it's also advisable to reconcile your accounts each month to ensure they line up with your actual bank statements. 

 

Feel free to reach out back to us if you have any clarifications about the income and expense accounts in QBDT. We're always available in the Community to lend you a helping hand. Stay safe, and wishing you continued success!

Berry4Holiday
Level 1

Accounting for Estates and Trusts

I am also having an issue with Quickbooks Essentials online.  I only need to use this product for tracking the expenses, etc. in the probated estates I handle.  As you say, it is not an attorney trust account, but the Executor's bookkeeping that I track for reports to the Probate court.  I had a Desktop Account that is no longer supported and am a solo practice in my waning years.  Unfortunately, I still would like to use Quickbooks for this type of account tracking.  Your comments are the first that appeared to be directed at the same problem I'm experiencing.  Surely, there is a solution.  

I thought I would check out the desktop app for online products, not to be confused with the online desktop product which is much more than I would need.  This app that would mimic the Desktop account map that I was used to and keep me connected so that I don't have to sign in at every instance.  The directions say to go to my Settings and select "Get the desktop app".  When I open settings there is no such selection before me.

CamelleT
QuickBooks Team

Accounting for Estates and Trusts

Allow me to address your two concerns, Berry4Holiday.

 

First, you mentioned that the "Get the desktop app" selection is unavailable on your end. The main reason is that this feature is only available for QuickBooks Online (QBO)Advanced and QuickBooks Online Accountant (QBOA) version. If you want to utilize this feature, you can upgrade your plan. 

When you plan to upgrade, here's how:

  1. Sign in to QuickBooks Online as a primary or company admin.
  2. Go to Settings ⚙ and select Subscriptions and billing.
  3. Make sure your payment info is up to date.
  4. In the QuickBooks Online section, select Upgrade your plan.
  5. Review the available plans and then select Choose plan.
  6. Follow the on-screen steps to upgrade your plan.

 

Second, may I know what you meant by the account tracking you wanted to do in QBO? This way, I'll be able to provide appropriate steps on how you can do this.


I'll also share an article to help prevent unwanted changes before filing your taxes: Close your books in QuickBooks Online (intuit.com).

If you need further assistance, drop a reply below. I'll be here to assist you. Take care!

meh2024
Level 1

Accounting for Estates and Trusts

I am just starting to set up an estate in QB.  I have been researching the recommended chart of accounts and related entries for typical opening of estate and transactions.  I am very curious what account set up you finally used.  One of my concerns is the auto period closing entries and how to force that into the proper equity accounts (e.g. equity principal vs equity income).  Would you be willing to share via email?  As you know, accurate and streamlined tax reporting/K1s are my goal.  Wanting to make is simple by setting up the proper chart of accounts etc.

jdyspirit
Level 1

Accounting for Estates and Trusts

I am also in the same boat.  Did you ever get an answer to this problem?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us