How do I enter a transaction with multiple accounts?

musicalSaranader
musicalSaranader Quicken Windows Subscription Member

Hi. I know how to split a transaction across multiple categories, but is there a way to split it across more than one account? I paid for some things at the pharmacy using my HSA card, but I didn't have enough on the card for the whole transaction, so I paid for the remainder with my regular credit card. I think I've looked into how to do this in the past but never figured it out. Is there an easy way to do it or do I really have to enter separate transactions in my register for each account I used? Thank you.

Answers

  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭

    In my way of thinking, it is two transactions against two different Quicken accounts, so it should be entered with one transaction in each account.

    Anything you do to combine the two transactions into a single entry, will take more time and make for a confusing mess using splits which won't properly categorize the purchase.

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • UKR
    UKR Quicken Windows Subscription SuperUser ✭✭✭✭✭

    Generally, I concur with @splasher 's statement to keep it simple and make 2 transactions, one in the HSA register, one in the credit card account.

    However, if you do want to create only one transaction, you can do so easily:

    Assume you have $50.00 available in the HSA card and the total purchase is $75.00
    Set up a charge transaction in the HSA account for $50 and open up a Split:
    Line 1 has the total purchase, categorized to your Medical expense category … $75.00
    Line 2 has the charge to your credit card (MyVISA) in this example … $-25.00

    Saving this transaction will make a charge transaction appear in your credit card register:

    Easy peasy.

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited October 19

    (I deleted my post since it is inaccurate.)

    Quicken Classic Premier (US) Subscription: R59.10 on Windows 11

  • UKR
    UKR Quicken Windows Subscription SuperUser ✭✭✭✭✭

    Huh?
    The total purchase amount, $75.00 in this example, is captured in Split Line 1 in the Medical category.
    Therefore, any tax reporting will be correct. The same applies to any other reports and views, e.g., the budget. It doesn't matter how many transfer splits were needed to pay the bill in full.

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭

    Oops! I misread your original post. I guess I shouldn't be posting things in Community while I'm multi-tasking with reviewing my 2025 Medicare plan options (my Part D plan is dropping coverage for my highest cost med….ugh!!!). I've deleted my post above because your suggestion is a very good one…similar in structure to how I manage my monthly SS deposits and IRA distributions.

    Sorry for the mess up on this one, folks.

    Quicken Classic Premier (US) Subscription: R59.10 on Windows 11

  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭

    I've never had an HSA so I'm treading in unknown territory here, but does it matter for the tax deductibility if the meds were paid for with HSA funds or personal funds?

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭

    I hadn't thought of that but, yes, there are some unique tax impacts here that Quicken is just not really set up to deal with properly.

    HSAs are tax advantaged accounts that are funded with pre-tax dollars and distributions are tax-free. So, it's kind of like a hybrid tax-deferred IRA and a tax-exempt Roth IRA account (for healthcare expenses instead of for retirement) all rolled into one. It blends the best of both the IRA and Roth IRA worlds.

    However, HSA medical expenses are not tax deductible so they cannot be included in Schedule A as such.

    Quicken does not have a HSA account type so I can understand why so many users are displeased about that.

    In light of all this, it would seem that the split categories option @UKR and I discussed above will likely cause tax data to be captured incorrectly. That is because the HSA expense side of the payment should not be captured at all as a tax deductible expense but assuming that the category used is the default category for a medical expense it will be doing just that. And if it is not using the default medical expense category, then the credit card side of the expense would not be capturing the tax deduction since it is a transfer category instead of the default medical expense category.

    To better capture the dollars in the tax reports and tax planner, then I think your suggestion (one transaction in the HSA account and one transaction in the credit card account) might be the better option. But that assumes that the HSA expense category is not associated with the tax line item for medical expenses and the credit card expense category is associated with the correct tax line item for medical expense(s).

    Then it begs the question: What is the best workaround way to set up a HSA account in Quicken so that it properly captures the HSA tax advantages? My initial thought is to set up the account as an IRA account or a Roth IRA account, set it to "Tax Deferred" and give it a HSA account name. Then change the Tax Schedule for transfers in to "Form 1040:IRA contribution, self (or spouse)" and change transfers out to "1099-R:Total IRA Gross distrib." It's not perfect but Quicken should then capture HSA account contributions as pre-tax deductions so it will reduce taxable income. And Quicken should then capture the HSA distributions as tax-free.

    But this is all moot if @musicalSaranader is not using Quicken to capture, report and plan taxes. If they are using Quicken simply as an income/expense and budgeting tool then the split categories option might be best because it is so easy to use.

    Quicken Classic Premier (US) Subscription: R59.10 on Windows 11