2026-11-13 · Accounting

How to Record Treasury Bills and Money Market Funds in QuickBooks (Without Doubling Your Income)

↓ Get the free Excel + PDF kit for this article

More small businesses now park spare cash in Treasury bills or a money market fund at a broker. The money is safe, but the bookkeeping often is not. A T-bill is bought at a discount and pays its full face value at maturity, so there is no interest check to copy into the books. The result we see again and again: the purchase is booked as an expense, the whole $10,000 maturity is booked as income, or a rollover's small net cash is booked as income. Then the profit and loss is wrong, the balance sheet does not match the broker statement, and the 1099s do not match the books.

This guide shows a simple method you can follow in QuickBooks Desktop or QuickBooks Online, plus a small Excel or Google Sheets tracker you can build yourself.

The three rules behind every T-bill entry

  1. Interest = face value − purchase cost. IRS Publication 550 treats the difference between the discounted price you pay and the face value you receive at maturity as interest income.
  2. Timing. Pub. 550 says you generally report this interest when the bill is paid at maturity. A bill bought in November 2026 that matures in January 2027 is generally 2027 interest.
  3. Buying a bill is not an expense. Cash simply moves into another asset. Only the discount becomes income.

Two tax notes to keep in mind: brokers report Treasury interest on Form 1099-INT, box 3, and that interest is subject to federal income tax but exempt from state and local income taxes (Pub. 550). Money market fund payouts are generally dividends, not interest (Pub. 550), so they usually appear on Form 1099-DIV.

Flow of one T-bill: buy entry, hold at cost, maturity entry with $180 interest
Figure 1. One bill from purchase to maturity (example values).

Step 1: Set up the accounts once

Account (suggested name)TypeUse it for
Brokerage CashBankCash or sweep balance at the broker
T-Bills at CostOther Current AssetBills you still hold, at purchase cost
Interest Income - US TreasuryOther IncomeThe discount when a bill matures
Dividend Income - MMFOther IncomeMoney market fund payouts

QuickBooks Online

  1. Go to All apps → Accounting → Chart of accounts → New account. (If your layout has no All apps, open Chart of accounts from the Accounting or Settings menu.)
  2. Type the Account name, choose the Account type first, then pick a Detail type from the list that appears. Click Save.

QuickBooks Desktop

  1. Lists → Chart of Accounts → Account → New. Use Bank, Other Current Asset and Other Income as in the table.

Step 2: Record the purchase and the maturity

Example: a 13-week bill with $25,000 face value bought for $24,770.

DateAccountDebitCredit
Buy dateT-Bills at Cost$24,770.00
Buy dateBrokerage Cash$24,770.00
Maturity dateBrokerage Cash$25,000.00
Maturity dateT-Bills at Cost$24,770.00
Maturity dateInterest Income - US Treasury$230.00

Example values only.

If the broker or bank account is connected to a bank feed, match the downloaded line to the entry or transfer you already made. Adding it again doubles the cash.

Step 3: Handle rollovers correctly

When a bill matures and a new one is bought the same day, the statement may show one small net amount. Record two entries anyway: the maturity of the old bill and the purchase of the new one.

Before and after table for a rollover: net cash $100 versus real interest $180
Figure 2. A rollover recorded the wrong way and the right way (example values).

Step 4: Build a small tracker in Excel or Google Sheets

Put one bill per row. Columns: A Bill name, B Buy date, C Maturity date, D Face value, E Purchase cost. Put your as-of date (for example 12/31/2026) in cell J1 and the tax year in J2.

BillBuyMaturityFaceCostInterestYearOpen at 12/31
26W Jan01/08/202607/09/2026$50,000$49,040$9602026-
17W Sep09/03/202612/31/2026$30,000$29,650$3502026-
8W Nov11/19/202601/14/2027$40,000$39,770$2302027$39,770

Example values only.

Step 5: Tie out every month

Each month-end, compare two pairs of numbers: the statement cash balance with your Brokerage Cash account, and the cost of open bills from your tracker with your T-Bills at Cost account. If the T-bill account is higher than the tracker, interest was probably left inside the asset. If cash is off, look for a fee, a transfer or a bank-feed line entered twice. Market value on the statement will differ from cost; most small businesses simply keep T-bills at cost and treat the gap as information.

Step 6: Year-end and the 1099s

Timeline showing bills that mature before and after December 31 and which year their interest belongs to
Figure 3. Which year each bill's interest belongs to (example bills).
IncomeYour books1099 box1099 amountDifference
Treasury bill interest$1,765.001099-INT box 3$1,765.00-
Bank / CD interest$118.401099-INT box 1$121.07($2.67)
Money market fund dividends$642.181099-DIV box 1a$642.18-

Example values only. A difference is a clue: interest credited on December 31 that was never posted, dividends posted as interest, or a bill that matures in early January. If your books are on the accrual basis, you may also accrue the discount earned so far on open bills and reverse it on January 1; that is a book entry and does not decide tax timing. Accrual-method businesses and corporations should ask their tax preparer about the short-term obligation rules.

Common mistakes

FAQ

Do I need to mark T-bills to market each month?

Most small businesses keep them at cost and show the market value as information. If your lender or accountant wants fair value, ask them how they want unrealized gains shown.

The broker shows "accrued interest" on the statement. Do I book it?

Not on cash-basis books. For accrual-basis books you can post a year-end accrual and reverse it on January 1.

Why is my state return different from my federal return?

Treasury interest is exempt from state and local income taxes (Pub. 550). Tell your preparer which interest is Treasury interest so it is handled correctly.

What if I sold a bill before it matured?

That can create a gain or loss and has its own rules. Give the trade confirmation to your tax preparer.

Checklist

You can download the ready-made T-Bill & Money Market Recording Kit 2026 for free in the Free kit download box below (Excel + PDF guide, no sign-up).

This article is for educational purposes only and is not tax, legal or investment advice. Examples are illustrations; check your own situation with a qualified tax professional. QuickBooks is a registered trademark of Intuit Inc.; not affiliated with or endorsed by Intuit.

Free kit download

Tools to follow this article step by step. No sign-up needed.

Free to use for yourself and your own business; please do not resell or redistribute. General information, not tax, legal or accounting advice; check every figure against your own records. QuickBooks is a trademark of Intuit Inc.; BIZLEX is not affiliated with Intuit.

Sources

← All articles Privacy