Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

How can you print memo fields in split transactions?

Often our HOA makes deposits consisting of many checks from different individuals. We split the transactions and put the name of the check writer in the memo field along with the split value. I have found no way to show it in a report or export this information to another program such as excel. It's of little value if you have to physically open each split to see the data.

Best Answer

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Accepted Answer
    It is commonly recommended in your type of setup to maintain an "Undeposited Funds" account.  The actual checks from the individuals get recorded as received into that account.  Then deposit into the bank is a transfer from that "Undeposited Funds" account to the bank account. -- FWIW     

Answers

  • TateG
    TateG Member
    Often our HOA makes deposits consisting of many checks from different individuals. We split the transactions and put the name of the check writer in the memo field along with the split value. I have found no way to show it in a report or export this information to another program such as excel. It's of little value if you have to physically open each split to see the data.
  • Sherlock
    Sherlock SuperUser ✭✭✭✭✭
    To show the memo field of a split entry in a Transaction report, I suggest you select Reports > Banking> Transaction, press Alt + C, check Show splits, and select OK.

    To export the report for excel, press Alt + E and select Export to excel workbook (.xlsx).
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Accepted Answer
    It is commonly recommended in your type of setup to maintain an "Undeposited Funds" account.  The actual checks from the individuals get recorded as received into that account.  Then deposit into the bank is a transfer from that "Undeposited Funds" account to the bank account. -- FWIW     
  • TateG
    TateG Member
    Thanks. Worked like a charm.
Sign In or Register to comment.