How to manually record treasury bills & notes in quicken premier for windows 11

mwoodpatrick
mwoodpatrick Quicken Windows Other Member ✭✭

I would appreciate any pointers on the best practices for the detailed steps on manually recording treasury bills & notes in quicken premier for windows 11

Comments

  • @mwoodpatrick I was curious to how Copilot would answer your question so I asked your exact question (copied and pasted) and this is what it came up with. I am not sure this answers your question or is what you were looking for, but here it is -

    🏛️ Step-by-Step: Recording Treasury Bills and Notes in Quicken

    🔹 1. Set Up the Investment Account

    • Go to Tools > Add Account > Investing.
    • Choose Brokerage or Other (for manual tracking).
    • Name the account something clear like “Treasury Securities” and complete setup without connecting to a financial institution.

    🔹 2. Add the Security

    • Open the new account and click Add Security manually.
    • Enter details like:
      • Name: “U.S. Treasury Bill – [Maturity Date]” or “U.S. Treasury Note – [Coupon % / Maturity Date]”
      • Type: Bond
      • Symbol: Use a placeholder (e.g., T-BILL20250815 or T-NOTE4.25%)
      • Asset Class: US Bond
    • Save and close.

    🔹 3. Record the Purchase

    • Select Enter Transactions > Buy – Bonds Bought.
    • Fill out:
    • Date of purchase
    • Quantity (face value, e.g., $10,000)
    • Price (usually at a discount for T-bills; actual price paid for notes)
    • Commission (if any)
    • Total cost: principal + commission

    🔸 For Treasury Bills: Since they are zero-coupon, set the price below face value and set the maturity date separately if needed.

    🔸 For Treasury Notes: Include the coupon rate in the security name and record actual cost.

    🔹 4. Record Interest Income (T-Notes only)

    • As interest payments come in:
    • Choose Enter Transactions > Income – Income Received.
    • Category: Interest Income
    • Attach to the correct security and account.

    🔹 5. Record Redemption or Maturity

    • When the security matures:
    • Go to Enter Transactions > Sold – Bonds Sold.
    • Date: Maturity date
    • Price: Full face value ($10,000 for example)
    • Commission: $0
    • This realizes the gain for a T-bill (difference between purchase and redemption), and returns principal for a note.

    ⚙️ Best Practices and Tips

    • Use clear naming conventions to distinguish between bills and notes.
    • Use memo fields for details like purchase discount, interest rates, or auction dates.
    • Avoid reinvest options unless you're manually rolling over securities.
    • For Schedule B or tax reporting, categorize interest correctly and generate reports via Reports > Tax > Tax Schedule.
  • mwoodpatrick
    mwoodpatrick Quicken Windows Other Member ✭✭

    Many thanks for the reply, much appreciated.

    I did a similar query with Gemini unfortunately both responses do not seen to match the UI and functionality provided by Quicken

This discussion has been closed.