cancel
Showing results for 
Search instead for 
Did you mean: 
ErikDrakin
Level 1

Quickbooks for Fiduciary Accounting?

I am a professional fiduciary.  I serve as executor, trustee, and guardian in many cases.  When going to close out those cases, I need to submit a fiduciary accounting to the court for approval.  It has to show every receipt and expense, and it needs to distinguish between principal and income.  I currently use Lackner 6 in 1 for this, but the software is very clunky, largely because it does a lot more than just produce accounting.  There is also OneSource by Thomson Reuters, though it is very expensive (several thousands of dollars per year, depending on how many cases you have).  


A colleague has suggested using Quickbooks.  I already use it to keep the books for my own business, so I am somewhat familiar.  But now I will need the ability to create clients/cases and to input all transactions specific to that client and to produce acceptable fiduciary accountings for it.  The form of accounting required by the court is attached as a PDF to this message, in case you are curious about what I need to actually produce for the court. 

 

I am overwhelmed by the number of Quickbooks products and am having trouble determining which (if any) will meet my current need.  Any advice or insight would be greatly appreciated.  Thank you!

5 Comments 5
MaryAnn_E
QuickBooks Team

Quickbooks for Fiduciary Accounting?

Hi there, ErikDrakin.

 

QuickBooks versions allow you to track income and expenses. Also, organize receipts, invoices and run reports, such as your profit and loss statements and balance sheets. 

 

I suggest visiting our app center, where you can check our QuickBooks application collection to see if there’s one that suits your business needs.

 

To do that, click on the Apps tab in the left panel, and enter a keyword in the search field.

 

You can also click this link for any apps you can find that’s integrated with QuickBooks: https://apps.intuit.com/app/apps/home.

 

Keep me posted if you have any questions. I'll be here to help if you need more information about the conversion.

coppens1
Level 3

Quickbooks for Fiduciary Accounting?

Dear Erik Draken, and Mary Ann E.

 

I have a similar problem.  I am a CPA and I have to keep a set of books for a testamentary Trust.  Normally a Testamentary Trust needs to keep  two separate trial balances for two things:  Principal, and Income.

My questions are:  1.  Do you have a typical Chart of Accounts for a Testamentary trust?

2. Is it possible to use the Quickbooks Accounting Program to keep books for a Testamentary Trust?

 

 

 

 

jamespaul
Moderator

Quickbooks for Fiduciary Accounting?

Hello, coppens1.

 

I'll give some details in setting up testamentary trust in QuickBooks Online. 

 

QuickBooks Online creates a default Chart of Accounts by the time you're finished with the mini-interview after purchasing your plan. 

 

We're unable to provide a typical Chart of Accounts setup for a Testamentary trust standard. However, you can create liability or trust accounts might help you track books properly. 

 

You can learn more about the Chart of Accounts here: Learn about the chart of accounts in QuickBooks Online.

 

Also, QuickBooks offers a standard accounting package. You can use its functions to record income and expense transactions. 

 

I would suggest giving our test drive a shot. This will help you familiarize the functions available and can help you decide on what to do to keep the books for a Testamentary Trust standard. 

 

You can take a look at this article for the test drive links: Test drive QuickBooks Online.

 

Just to reiterate what my colleague mentioned, you can expand QuickBooks Online's function by adding third-party apps. They might have some features that'll help you track the transactions needed for a testamentary trust setup. 

 

We also have a bunch of articles to help you record your transactions and take care of your books. If you need help with reports, you can check this article: Run reports in QuickBooks Online.

 

I welcome any other questions you might have regarding the functions and features in QuickBooks Online. Just reply here and I'll be sure to lay down some helpful details. 

coppens1
Level 3

Quickbooks for Fiduciary Accounting?

By the way, Accounting for Estates and Trusts is different from a Law Firm setting up Trust accounts, which are essentially the same as escrow accounts.  JC

MadelynC
Moderator

Quickbooks for Fiduciary Accounting?

I’m here to help and provide information so you can manage your books for a testamentary trust, JC.


In QuickBooks Online, you can import an account for your testamentary trust. This way, you can track your books the way they should be and keep everything in order.


Here’s how:

 

  1. Log in to your QuickBooks account.
  2. Click on the Gear icon on the top right-hand corner of the page.
  3. Under the Tools heading, click on Import Data.
  4. Go to the Chart of Accounts.
  5. Click on the link that says, “Download a sample file.”


You can use this guide to make sure accounts are imported correctly: Import your chart of accounts to QuickBooks Online.


Once done, you can now categorize your transactions in the program. Then, use this reference to ensure your account are balanced and accurate: Reconcile an account in QuickBooks Online.


If you have any other questions or concerns besides accounts, just add them to your reply. I’ll be here anytime. Take care always!

Need to get in touch?

Contact us