How to record checking account interest in QuickBooks
QuickBooks does not automatically pull interest earnings from your bank and add them to your checking account balance. You record interest manually, either by entering it directly into the register or by importing it through a bank connection if your bank reports it as a separate transaction. The method depends on whether your bank feeds interest as its own line item or lumps it into your account balance without detail.
Most banks report interest monthly. If you use QuickBooks' bank connection feature, interest may appear as a separate deposit transaction that you can match to your records. If it does not, you will need to create the entry yourself using the information from your bank statement.
Key Takeaways
- Interest deposits appear on your bank statement as a separate line or rolled into your ending balance, and QuickBooks handles each differently.
- If your bank feeds interest as its own transaction, you match it in the bank reconciliation window; if not, you create a manual journal entry or deposit.
- You record interest as income to an account category like "Interest Income" so it flows into your profit and loss statement correctly.
- The entry must happen before you reconcile that month, or your bank balance in QuickBooks will not match your actual bank statement.
Recording interest when your bank feeds it as a separate transaction
If your bank connection shows interest as its own deposit line, QuickBooks will display it in the bank feed or in your checking account register as an unmatched transaction. Open your checking account register and look for a line labeled "Interest" or "Interest Paid" with the amount and the date it posted.
Click on that transaction to open it. QuickBooks will ask you to categorize it. Select or create an income account called "Interest Income" (or similar). This tells QuickBooks that the money is income, not a transfer or expense. Once you categorize it, the transaction moves from "unmatched" to "matched" and your checking account balance updates to include the interest.
If you are reconciling your account that month, this matched transaction will appear in the reconciliation window and you will check it off against your bank statement, just like any other deposit.
Creating a manual entry when interest is not itemized
Some banks do not break out interest as a separate line on their feed. Instead, they add it to your ending balance without showing it as a distinct transaction. In this case, you will notice the difference when you reconcile: your QuickBooks balance will be lower than your actual bank balance by the amount of interest earned.
To record it, open your checking account register and click the blank line at the bottom. Enter the date the interest posted (usually the last day of the month), leave the check number blank, and enter the interest amount in the "Deposit" column. In the "Category" field, select "Interest Income" or create that account if it does not exist.
Save the entry. Your checking account balance will now match your bank statement, and the interest will be recorded as income on your profit and loss statement.
Setting up an Interest Income account category
Before you record any interest, make sure you have an account to put it in. Go to your Chart of Accounts (usually under Settings or Lists, depending on your QuickBooks version). Look for an account called "Interest Income" or similar under the Income section.
If it does not exist, click "New" and create one. Choose "Income" as the account type and name it "Interest Income" or "Bank Interest Income" if you want to distinguish it from other income sources. Save it. Now when you record interest deposits, you can select this account and all your interest earnings will flow to one place on your income statement.
Reconciling your account after recording interest
Once you have recorded the interest, open your bank reconciliation window. In QuickBooks, this is usually under the Banking menu or Reconcile option. Select your checking account and the statement month. QuickBooks will show you all transactions — including the interest entry you just created — and ask you to check off the ones that appear on your bank statement.
Find the interest line on your bank statement and check the matching line in QuickBooks. If you recorded the amount correctly and on the right date, they will match. When all transactions are checked off and your QuickBooks balance matches your bank statement balance, the reconciliation is complete and the interest is locked in.
If the balances do not match, double-check the interest amount and date against your statement. A common mistake is entering the wrong amount or using the wrong date — banks often post interest on the last day of the month, not the day you notice it.
Interest recorded but not showing on your income statement
If you recorded interest but it is not appearing on your profit and loss statement, check that you used an Income account, not an Expense or Bank account. Open the transaction and look at the Category field. It should say "Interest Income" or whatever you named your income account.
If it says something else — like "Checking Account" or "Miscellaneous" — edit the transaction and change the category to Interest Income. Save it. The interest will then appear on your income statement under that category.
Another reason interest might not show is if you recorded it to a balance sheet account instead of an income account. Balance sheet accounts (like your checking account itself) do not flow to the income statement. Only income and expense accounts do.
Frequently Asked Questions
Why does my bank statement show interest but QuickBooks does not?
Your bank has posted the interest but QuickBooks has not received it yet through the bank feed, or it arrived without a label that identifies it as interest. Check your bank feed for an unmatched transaction, or create a manual entry using the amount and date from your statement.
Can I record interest retroactively for months I missed?
Yes. Open your checking account register, enter the date the interest posted, and record it the same way you would for the current month. If you have already reconciled that month, you will need to unreconile it first, add the interest, and then reconcile again.
What if my interest amount is different from what the bank shows?
Check that you entered the exact amount from your bank statement, including cents. If it still does not match, contact your bank to confirm the interest posted correctly. Once you have the right amount, edit your QuickBooks entry and save it.
Do I need to record interest every month?
Yes, if your account earns interest. Most banks post it monthly, usually on the last day of the month. Recording it each month keeps your QuickBooks balance accurate and your income statement complete.