by XpertBooks Pro Team | Last updated Sep 30, 2026 | QuickBooks
To set up items in QuickBooks Desktop, go to Lists > Item List, click Item > New, choose the item type (Inventory Part, Non-Inventory Part, or Service), and link each item to the right income and expense/COGS accounts. Good item setup is what makes invoices, sales receipts, and inventory reports work correctly.
Here's a mistake that haunts QuickBooks files for years: someone sets up items in a hurry — wrong type, wrong accounts, names that made sense for exactly one afternoon — and the business spends the next three years working around the mess.
Items are the backbone of QuickBooks Desktop. Every invoice, sales receipt, bill, and purchase order pulls from your Item List. When items are set up right, your income lands in the right accounts, your inventory stays accurate, and your reports actually mean something. When they're not, you get mystery balances, wrong COGS, and inventory numbers nobody trusts.
So let's set them up properly the first time. It's maybe fifteen minutes of work that pays off every single day after.
The three item types you'll use most
QuickBooks Desktop offers a whole menu of item types, but 90% of businesses live on three:
- Inventory Part: Physical goods you buy, stock, and sell. QuickBooks tracks quantity on hand and average cost for these. (Example: a plumbing supply store's pipe fittings.)
- Non-inventory Part: Physical goods you sell but don't stock — you buy them specifically for a job or order. QuickBooks doesn't track quantity for these. (Example: a contractor ordering a specialty fixture for one project.)
- Service: Anything you do rather than sell. Labor, consulting, installation, maintenance. No quantity tracking, just a rate. (Example: an HVAC company's diagnostic visit.)
There are others — Other Charge (shipping, restocking fees), Group (a bundle sold as one line), Discount, Subtotal, Payment, Sales Tax items — and you'll meet them eventually. But master the big three first; they're the foundation everything else sits on.
Before you start: get your accounts ready
Each item needs to point at accounts in your chart of accounts, so check these exist first:
- An income account for what you sell (e.g., Sales Income, Service Income)
- A COGS account for inventory parts (e.g., Cost of Goods Sold)
- An expense account for non-inventory parts and services you purchase for resale
If you're not sure which accounts to use, ask your accountant before creating dozens of items — changing the account on fifty items later is nobody's idea of fun.
How to set up items, step by step
Step 1: Open the Item List
- Go to Lists > Item List at the top menu.
- Click the Item button at the bottom-left of the Item List window.
- Select New (or press Ctrl + N).
Step 2: Choose the right item type
- In the Type dropdown, select the item type.
- Inventory Part if you stock it and want QuickBooks to track quantities and cost.
- Non-inventory Part if you buy it as needed for specific jobs.
- Service if it's labor or a service you perform.
- Picking the wrong type here is the #1 item setup mistake. If you stock it, it's an Inventory Part. No exceptions, no "I'll track it in a spreadsheet instead."
Step 3: Name the item clearly
- Give the item a name or number your team will actually recognize on invoices and purchase orders.
- Be consistent: if you use manufacturer part numbers, use them for everything. If you use descriptive names, keep the format the same ("Widget, 2-inch, brass" not "brass 2in widget" on one item and something else on the next).
- You can add a longer Description on Purchase Transactions and Description on Sales Transactions — these print on forms, so write them for the customer, not for yourself.
Step 4: Set the cost and price (inventory parts)
- Enter the Cost — what you pay your vendor for one unit.
- Enter the Sales Price — what you charge the customer.
- Select the COGS Account, Income Account, and Asset Account (usually Inventory Asset).
- Set the Reorder Point — the quantity at which QuickBooks warns you to reorder. Set it to something realistic, not zero.
Step 5: Set the rate (service and non-inventory items)
- For a Service item: enter your hourly or flat Rate and pick the income account (or two accounts if you both sell and purchase the service — for example, subcontracted labor).
- For a Non-inventory Part: enter the cost, the sales price, and link the expense account and income account.
- Subitems are your friend here: create a parent item like "Labor" with subitems "Labor – Standard" and "Labor – Overtime" for cleaner reporting.
Step 6: Save and keep going
- Click OK to save, or Next to immediately create another item.
- Work through your list methodically. Boring? Yes. Worth it? Completely.
Setting up inventory parts: a quick example
Say you run an electrical supply shop and stock 12-gauge wire spools:
- Type: Inventory Part
- Item Name: WIRE-12G-500
- Description: 12-gauge copper wire, 500 ft spool
- Cost: $68.00, Sales Price: $119.99
- COGS Account: Cost of Goods Sold, Income Account: Product Sales, Asset Account: Inventory Asset
- Reorder Point: 10
Now every purchase of that wire updates your quantity and average cost, and every sale reduces quantity and records COGS automatically. That's the whole point — set it up once, and QuickBooks does the tracking forever.
Common mistakes to avoid
- Using Service items for things you stock. Then QuickBooks never tracks quantity, your inventory asset account is wrong, and COGS is a guess. If it sits on a shelf, it's an Inventory Part.
- Creating duplicate items. "Wire 12g", "WIRE-12G", "12 gauge wire" — three items for one product means three sets of numbers that never agree. Search the Item List before creating anything new.
- Linking items to the wrong accounts. An inventory part pointing at an expense account instead of COGS silently misstates your financials. Double-check the account fields when creating each item.
- Skipping the reorder point. Then nobody gets warned before you run out. Set it when you create the item, not "later."
- Using vague item names. "Misc part" and "Service" tell you nothing six months from now. Name items like someone else has to understand them — because eventually, someone else will.
Conclusion!
That brings us to the end of this guide on setting up items in QuickBooks Desktop. We hope the steps explained above helped you create inventory, non-inventory, and service items with the right types and accounts from the start. If you run into any difficulty while following the steps, consider consulting a qualified and experienced QuickBooks professional for further assistance.
FAQs
What's the difference between an Inventory Part and a Non-inventory Part?
An Inventory Part is stock you keep on hand — QuickBooks tracks its quantity and average cost. A Non-inventory Part is something you buy for a specific sale or job without stocking it, so no quantity is tracked. Choose based on whether the item lives on your shelf.
Can I change an item's type after creating it?
No — QuickBooks doesn't let you change an item's type once it's created. You'd need to make the item inactive and create a new one with the correct type. That's why getting the type right the first time matters so much.
Do I need items for everything I sell?
Yes, if you want QuickBooks to work properly. Invoices, sales receipts, and purchase orders all require items. Every line on a sales form must reference an item from your Item List.
How many items can QuickBooks Desktop handle?
QuickBooks Desktop Pro and Premier support up to 14,500 items (including inactive ones); Enterprise supports up to 1 million. Most small businesses never come close to the limit — but if you do, that's a sign to move to Enterprise.
You may also like:
adjust inventory in QuickBooks Desktop
price levels in QuickBooks Desktop
QuickBooks unable to add item to list
merge list entries in QuickBooks
How to Fix Negative Inventory Issues in QuickBooks
by XpertBooks Pro Team | Last updated Sep 30, 2026 | Accounting & Bookkeeping
Law firm bookkeeping means tracking two separate pools of money: the firm's operating funds and client funds held in trust (IOLTA accounts). Client funds can never be mixed with firm money, every dollar must be traceable to a client, and most states require regular three-way reconciliations of trust accounts.
Most businesses get to do the simple thing: money comes in, money goes out, and it's all theirs. Law firms don't get that luxury.
The moment a client hands you a retainer or settlement funds pass through your hands, you're holding someone else's money — and the rules for that money are strict, unforgiving, and enforced by your state bar. Mix client funds with operating funds, even accidentally, and you're not just looking at a bookkeeping error. You're looking at a potential ethics violation.
The good news? Trust accounting isn't complicated once you understand the handful of principles behind it. It's just different from normal bookkeeping, and it punishes sloppiness fast. Here's what you need to know.
Operating funds vs. client funds: the wall between them
Every law firm needs at least two accounts:
- Operating account: Your firm's money. Fees you've earned, expenses, payroll — normal business stuff.
- Trust account (IOLTA): Client money you're holding but haven't earned. Retainers, settlement proceeds, advanced costs. IOLTA stands for Interest on Lawyers Trust Accounts, and the interest typically goes to legal aid programs in your state.
The wall between these two is absolute. You can't borrow from the trust account to cover payroll and "pay it back later." You can't let a client payment land in the operating account and sort it out at month-end. Commingling — mixing the two — is one of the fastest ways to get into disciplinary trouble.
Practical setup in QuickBooks: create separate bank accounts in your chart of accounts for each trust account, and keep client ledger detail — every transaction tagged to the specific client or matter it belongs to. QuickBooks Desktop can track this with classes or jobs per client, so you always know exactly whose money is sitting where.
The core rules of trust accounting
The details vary by state, but the principles are nearly universal:
Never spend money you don't have for that specific client. This is the big one. It's not enough for the trust account as a whole to have a positive balance — every individual client's ledger must stay positive. If Client A's retainer is $5,000 and you've billed $5,000 against it, you cannot touch that account for Client A's expenses even if the account overall holds $200,000 of other clients' money. One client can never fund another.
Record everything the day it happens. Trust transactions get recorded immediately — the day money comes in or goes out. No batching at month-end, no "I'll enter it when I get around to it." Delays create exactly the kind of fog where errors hide.
Keep a client ledger for every client. For each client or matter, maintain a running record: deposits in, disbursements out, current balance. This is your proof that every dollar is accounted for, and your state bar can ask to see it.
Reconcile monthly — the three-way reconciliation. Trust accounts typically require a three-way reconciliation: (1) the bank statement balance, (2) the trust account balance in your books, and (3) the sum of all individual client ledger balances. All three must match. If they don't, something's wrong and you need to find it before the month closes.
Earned fees move to operating promptly. When you've earned a fee (work performed, invoice sent per your fee agreement), transfer that amount from trust to operating. Don't let earned money sit in trust indefinitely, and don't transfer fees before they're actually earned.
Common trust accounting mistakes (and how they happen)
These aren't exotic scenarios. They happen in ordinary busy practices all the time:
- The negative client ledger. You pay a filing fee for Client B before Client B's retainer clears. Now Client B's ledger is negative, and you've technically used someone else's money. Fix: verify the client's available balance before every disbursement. Every single one.
- The sloppy transfer. You earned a $3,000 fee, but you transfer $3,500 to operating because you misread the invoice. Now the operating account holds client money. Fix: tie every transfer to a specific invoice or billing entry, and reconcile the transfer amount before it moves.
- The forgotten deposit. A check arrives, sits on someone's desk for two weeks, and never gets entered. The client ledger is wrong, the bank rec is wrong, and nobody knows. Fix: same-day recording, no exceptions. A simple log at the front desk for incoming trust funds goes a long way.
- The "I'll fix it in the books" disbursement. Writing a trust check to a vendor for a client expense but entering it against the wrong client. Now two ledgers are wrong. Fix: double-check the client/matter on every trust disbursement before it goes out.
- Record-keeping gaps. Most states require trust records to be kept for five to seven years. Shredding old records or losing them in a software migration is a compliance failure on its own.
Bookkeeping practices that keep a law firm healthy
Beyond the trust account rules, a few habits separate well-run firms from chaotic ones:
Bill promptly and consistently. Firms that bill late get paid late. Set a billing cycle — monthly is standard — and stick to it. Unbilled time is the silent profit killer in law practices.
Track time even for flat-fee work. You might not bill by the hour, but knowing how much time flat-fee matters actually take tells you whether your pricing works. Data beats gut feeling.
Separate client costs from firm expenses. Advanced costs (filing fees, expert witnesses, deposition transcripts) paid from trust are not firm expenses — they're client funds being spent on the client's behalf. Record them as such, with the client detail attached, so reimbursement and billing stay clean.
Review trust reports monthly. Don't just reconcile — look. Scan client ledgers for stale balances (money sitting untouched for months), negative balances, and clients with no recent activity. Stale funds may need to be returned to the client or escheated to the state under unclaimed property laws.
Keep the books owner-ready. Partners should be able to see, at a glance, the firm's cash position, outstanding receivables, and work in progress. If your books can't produce that, they're not serving the business.
Conclusion!
That brings us to the end of this guide on law firm bookkeeping and trust accounting basics. We hope the tips explained above helped you understand how to keep client funds properly separated, tracked, and reconciled. If you run into any difficulty applying them, consider consulting a qualified and experienced QuickBooks professional for further assistance.
FAQs
What is an IOLTA account?
An IOLTA (Interest on Lawyers Trust Accounts) account is a pooled trust account where a law firm holds client funds. The interest earned goes to fund legal aid and related programs in the state, not to the firm or the clients. Almost every state requires lawyers to use IOLTA accounts for client funds.
Can a law firm use QuickBooks for trust accounting?
Yes, many firms do — but it requires careful setup: separate trust bank accounts in the chart of accounts, client-level tracking (via jobs or classes), and disciplined monthly three-way reconciliations. QuickBooks won't enforce trust rules for you, so the procedures around it matter as much as the software.
What happens if a client ledger goes negative?
A negative client ledger means the firm has spent more of a client's money than it holds — which means another client's (or the firm's) money covered the gap. That's commingling, and it's a serious ethics issue in every state. Find it fast, fix it fast, and put a check in place so it can't happen again.
How long must law firms keep trust accounting records?
It depends on the state, but five to seven years is typical. Keep bank statements, client ledgers, reconciliation reports, and records of every receipt and disbursement. When in doubt, keep them longer.
You may also like:
real estate bookkeeping
medical practice bookkeeping
essential bookkeeping practices for contractors and construction
remote bookkeeping how businesses are cutting costs
Nonprofit Accounting Best Practices: Compliance, Grants & Fund Tracking
How to Use Accounts Payable Workflows in QuickBooks
by XpertBooks Pro Team | Last updated Sep 30, 2026 | QuickBooks
To use the audit trail in QuickBooks Desktop, go to Reports > Accountant & Taxes > Audit Trail. It shows every transaction that was created, modified, or deleted — along with who did it and when. Use filters to narrow the report by date, user, or transaction type.
Picture this: you reconcile your bank account on Friday and everything balances. Monday morning, the same account is off by $340 and nobody can explain why.
Someone edited something. Or deleted something. And without a way to see what changed, you're left playing detective with no clues — reopening transactions one by one, hoping you'll spot the difference.
That's exactly the problem the audit trail solves. Think of it as a security camera for your books: it quietly records every transaction that's added, changed, or deleted, along with who made the change and when. And here's the thing most people don't realize — it's already on. You've been recording this whole time. You just need to know where to look.
What is the audit trail in QuickBooks Desktop?
The Audit Trail is a report that lists every transaction in your company file that was created, modified, or deleted during a given period. Each entry shows:
- The transaction type (invoice, bill, journal entry, and so on)
- The date the change happened
- The user who made the change
- The original version and the revised version of the transaction
For changed or deleted transactions, QuickBooks shows both versions — the old one underneath, the new one on top — so you can compare exactly what was different. Did the amount change? Was a date moved? Was the whole transaction deleted? It's all right there.
One thing to know upfront: the audit trail doesn't log every single thing. Simple list changes (like editing a customer name or account name) don't always appear here. But every financial transaction change does, and that's where discrepancies almost always come from.
How to open the audit trail, step by step
Step 1: Open the report
- Go to the Reports menu at the top.
- Select Accountant & Taxes.
- Click Audit Trail.
That's it — the report opens with the default date range.
Step 2: Set the right date range
- At the top of the report, set the From and To dates to the period you want to investigate.
- If your reconciliation broke between Friday and Monday, cover that window (plus a little margin on each side — changes sometimes sneak in earlier than you'd think).
- Click Refresh.
Step 3: Read what it's telling you
- Scan the transaction types. Look for entries marked as modified or deleted — new entries are normal day-to-day work.
- For each modified transaction, compare the old and new versions. QuickBooks stacks the latest version on top.
- Note the User column. If multiple people touch the books, this tells you exactly whose login made each change.
- Double-click any transaction to open it and see the full details.
Step 4: Customize it when the list is too long
- Click Customize Report at the top of the audit trail window.
- On the Filters tab, narrow things down — by transaction type, account, or user.
- Chasing a deleted invoice? Filter by transaction type "Invoice" and look for deleted entries.
- Wondering what your bookkeeper did last week? Filter by their username.
- On the Display tab, you can add or remove columns to keep the report readable.
- Click OK to apply.
Step 5: Save it for later
- If this is something you review regularly, memorize the report: click Memorize at the top.
- You can also export it to Excel for a deeper dig or to send to your accountant.
Practical ways to use the audit trail
So you've got the report open. When does it actually earn its keep?
When a reconciliation suddenly won't balance. Before you start re-reconciling everything, run the audit trail for the period since the last clean reconciliation. Deleted or modified transactions jump right out.
When you're not sure who did what. Multi-user office? The user column settles it. This isn't about blame — it's about knowing who to ask for context on a change.
Before year-end or an accountant review. A quick scan of the audit trail for the year tells you (and your accountant) whether the books have been stable or constantly reworked. Heavy modification activity is worth a conversation, not a panic.
When money looks off. Vendor says you short-paid them? Client says their invoice changed? The audit trail shows whether the transaction was edited after the fact — and by whom.
Common mistakes to avoid
- Assuming deletions are the only problem. Edits cause more headaches than deletions. A changed date or amount on an old transaction can ripple through reconciliations and reports. Read the modified entries too, not just the deleted ones.
- Checking too narrow a date range. If you only look at last week, you'll miss the edit someone made three weeks ago that only just surfaced. Pad the range.
- Forgetting that users matter. If everyone shares one login, the audit trail can't tell you who did what. Give each person their own QuickBooks user login — it's free and it makes the audit trail ten times more useful.
- Never looking at it at all. The audit trail is passive; it records whether you check it or not. A five-minute monthly review catches small problems while they're still small.
Conclusion!
That brings us to the end of this guide on using the audit trail in QuickBooks Desktop. We hope the steps explained above helped you find your way around this underused report and start tracking changes in your books with confidence. If you run into any difficulty while following the steps, consider consulting a qualified and experienced QuickBooks professional for further assistance.
FAQs
Can I turn the audit trail off in QuickBooks Desktop?
No — and that's by design. The audit trail in QuickBooks Desktop is always on and can't be disabled. It protects the integrity of your financial data by keeping a permanent record of transaction changes.
Does the audit trail show who logged in?
It shows which user made each transaction change, which amounts to the same thing for tracking purposes. If you need login history specifically, that's a different report — but for "who changed what," the audit trail has you covered.
Can I see transactions deleted a long time ago?
Yes, as long as they're within the date range you select and the company file hasn't been condensed or rebuilt in a way that purged history. The audit trail reaches back as far as your file's data does.
Will the audit trail slow down QuickBooks?
Not noticeably. It's a built-in feature that records lightweight entries as transactions change. Running the report itself on a very large date range in a very large file can take a moment — filter it down and it'll be quick.
You may also like:
enter opening balances in QuickBooks
how to prepare for a business audit
close your books in QuickBooks desktop
Identify, Prevent, and Fix a Corrupted QuickBooks Company File
by XpertBooks Pro Team | Last updated Sep 30, 2026 | Accounting & Bookkeeping
Real estate bookkeeping means tracking commissions correctly, keeping client trust funds completely separate from your operating money, treating security deposits as liabilities (not income), and reporting income and expenses property by property. Agents and property managers who do this stay compliant and actually know which properties make money.
You close a $12,000 commission. Great month, right? Except $3,600 goes to your brokerage split, $1,800 to taxes you'll owe later, $400 to the photographer and staging you paid out of pocket, and the client's earnest money deposit is sitting in your account — money that isn't yours and never will be.
Real estate money is messy by nature. Big irregular payments, money that belongs to other people passing through your hands, expenses spread across properties and months. Without a solid bookkeeping system, it's dangerously easy to spend money that isn't yours or miss deductions you're entitled to.
Whether you're an agent or managing properties for owners, here's what good real estate bookkeeping actually looks like.
Keep trust money sacred (and separate)
This is the big one — and the one with legal consequences.
Earnest money deposits, tenant security deposits, and rents you're holding for owners are not your money. They belong in a separate trust or escrow account, completely apart from your operating funds. Commingling client funds with your own isn't just sloppy bookkeeping — in most states it's a license-threatening violation.
Practical rules:
- Separate bank accounts. Operating account for your business, trust account for client funds. No exceptions, no "just this once."
- Reconcile the trust account monthly and keep a ledger showing whose money is whose. If three tenants' deposits sit in one trust account, your books need to show exactly how much belongs to each tenant.
- Never use trust funds to cover operating expenses. Even if you'll "put it right back." That's the fastest way to lose a license.
For agents: track every commission to the penny
Commission income doesn't arrive clean. A $12,000 gross commission might split three ways before it reaches you. Your books need to reflect what actually happened:
- Record the gross commission as income, then record the brokerage split as an expense (or whatever arrangement your brokerage uses). Don't just record the net deposit — you'll understate both income and expenses, and your tax return won't match your 1099.
- Set aside taxes immediately. As an independent contractor, nobody withholds for you. A common rule of thumb: move 25–30% of each commission into a separate tax savings account the day it clears. Future-you, staring down quarterly estimates, will be relieved.
- Track deal expenses per transaction. Photography, staging, lockboxes, signage, MLS fees, marketing — these add up to thousands per listing. If you're not tagging expenses to specific deals, you have no idea which listings were actually profitable.
For property managers: report property by property
Your owners don't care about your overall business numbers. They care about *their* property. That means your books need to answer, for every property, every month: what came in, what went out, and what's the net?
The tool for this in QuickBooks Desktop is class tracking — assign each property (or each owner) a class, and tag every income and expense transaction with it. Then you can run a P&L by class and hand each owner a clean statement for their property.
Monthly owner statements should show: rent collected, each expense with its category, management fees charged, and the net disbursement to the owner. Owners who get clear statements don't call you with questions. Owners who don't, do.
Security deposits are liabilities, not income
This trips up new property managers constantly. A $1,500 security deposit hits your bank account and feels like money in. It's not. It's money you owe back — a liability — sitting on your balance sheet until the tenant moves out.
Record it as a liability (Security Deposits Held) when received. When the tenant leaves, apply legitimate deductions (documented damages beyond normal wear and tear), refund the rest, and only then does any forfeited portion become income. And know your state's deadline for returning deposits — many states require it within 14–30 days, with penalties for being late.
Repairs vs. improvements: know the difference
A $300 faucet repair and a $15,000 roof replacement are not the same thing in your books:
- Repairs and maintenance (fixing the faucet, patching drywall, servicing the HVAC) are expensed in the year they happen. They keep the property in its current condition.
- Improvements (new roof, new HVAC system, a full kitchen remodel) get capitalized — added to the property's basis and depreciated over time. They make the property better than it was.
Getting this wrong in either direction costs you: expensing an improvement overstates this year's deductions and understates future ones; capitalizing a repair defers a deduction you could take now. When the amounts get significant, this is a conversation to have with your accountant, not a guess to make alone.
Expenses agents always forget to deduct
Real estate agents leave money on the table every tax season. The commonly missed ones:
- Mileage. Showings, inspections, closings, office supply runs — it all counts. At the IRS standard rate, 15,000 business miles is a serious deduction. Track it with an app; reconstructing it in April never works.
- Home office. If you genuinely work from home, the simplified or actual-expense method both beat taking nothing.
- Professional development. Licensing courses, continuing education, conferences, coaching programs.
- Marketing beyond the obvious. Website hosting, CRM subscriptions, professional photography for your own brand, client closing gifts.
- Phone and internet. The business-use percentage of both.
The pattern: if you spent it to earn commissions, it probably belongs on your books. When in doubt, record it and let your accountant decide at tax time. Unrecorded expenses are deductions lost forever.
Reconcile like clockwork
Real estate has more moving money than most small businesses — commissions in, splits out, rents in, owner disbursements out, deposits held. Monthly reconciliation of every account (operating and trust) isn't optional; it's the only way to catch the $2,000 owner disbursement that went to the wrong owner before it becomes a real problem.
The same discipline around tracking restricted funds that nonprofits use applies surprisingly well to property management — money held for others needs the same rigor.
Conclusion!
That brings us to the end of this guide on real estate bookkeeping for agents and property managers. We hope the tips explained above helped you handle commissions, trust funds, and property-level reporting with confidence. If you run into any difficulty applying them, consider consulting a qualified and experienced QuickBooks professional for further assistance.
FAQs
Should I use QuickBooks Desktop for real estate bookkeeping?
Yes, it handles the essentials well: class tracking for per-property reporting, trust account reconciliation, and commission income tracking. Property managers with large portfolios (50+ doors) sometimes outgrow it and move to dedicated property management software — but for agents and small-to-mid-size managers, it's plenty.
How do I record a commission split with my brokerage?
Record the full gross commission as income and the brokerage's share as an expense (often "Commission Expense" or "Brokerage Split"). This keeps your income matching the 1099 you'll receive and properly documents the expense.
Are security deposits taxable income?
No — not when received. They're a liability (money you owe back). They only become income if a portion is legitimately forfeited under the lease terms, such as keeping part of the deposit for documented damages.
What's the best way to track expenses across multiple properties?
Use class tracking in QuickBooks Desktop — one class per property (or per owner). Tag every transaction, then run profit-and-loss reports by class. It takes an extra few seconds per entry and saves hours at month-end.
You may also like:
law firm bookkeeping
accounting for wholesalers
essential bookkeeping practices for contractors and construction
remote bookkeeping how businesses are cutting costs
Set Up and Use Class Tracking in QuickBooks Desktop
Nonprofit Accounting Best Practices Compliance Grants Fund Tracking
by XpertBooks Pro Team | Last updated Sep 30, 2026 | QuickBooks
To apply a customer payment to an invoice in QuickBooks Desktop, go to Customers > Receive Payments, select the customer, enter the amount, and check the invoices the payment should cover. QuickBooks auto-applies payments oldest-first, but you can uncheck and reapply manually for full control.
A customer sends you a $5,000 check. They owe you $3,000 on one invoice and $2,500 on another. Simple, right?
Except the check memo just says "payment." Which invoice does it cover? All of one and part of the other? Split evenly? And what if they also have a $200 credit memo floating around from last month?
This is the moment where sloppy payment application starts corrupting your books. Apply it wrong and your aging report lies to you, your customer gets a statement showing the wrong balance, and collections calls get awkward. Apply it right and everything just... balances.
Here's how to do it properly in QuickBooks Desktop.
Receive Payments vs. sales receipt — don't mix these up
Quick but critical distinction:
- Invoice exists, customer pays later → Customers > Receive Payments. This is you collecting on money already owed. It reduces Accounts Receivable.
- Customer pays at the time of sale → Customers > Enter Sales Receipts. No invoice involved, no receivable created.
If you record a payment on an open invoice as a sales receipt instead, you'll double-count your income — the invoice recorded it once, and the sales receipt records it again. One of the most common QuickBooks mistakes out there.
How to apply a customer payment, step by step
Step 1: Open Receive Payments
- Go to the Customers menu at the top.
- Click Receive Payments.
- The Customer Payment window opens.
Step 2: Select the customer and enter the payment details
- In the Received From dropdown, pick the customer who paid you.
- QuickBooks immediately lists their open invoices below, oldest first.
- Enter the Amount received and the Date of the payment.
- Choose the Pmt. Method — check, cash, credit card, whatever they actually used. If it's a check, enter the check number. Future-you will be grateful during reconciliation.
Step 3: Tell QuickBooks where to put the money
- In the Deposit To field, you have two choices:
- Undeposited Funds (recommended): The payment waits here until you bundle it into a bank deposit via Banking > Make Deposits. This matches reality — you don't run to the bank after every single check.
- Directly to a bank account: The payment lands in your register immediately. Fine if you deposit each payment individually.
- If you recorded the payment as already deposited (say, it came through a bank feed), make sure you're not double-counting it. More on that below.
Step 4: Apply the payment to the right invoices
Here's where the actual "applying" happens:
- QuickBooks automatically applies the payment to the oldest invoices first. You'll see checkmarks appear next to invoices and amounts fill in the Payment column.
- To change the application: Click Un-Apply Payment to clear all the checkmarks, then manually check the invoices this payment should cover. Click in the leftmost checkmark column next to each invoice.
- For partial payments: Edit the amount in the Payment column for an invoice. If the customer paid $3,000 toward a $5,000 invoice, change that line's payment amount to $3,000. The remaining $2,000 stays open.
- One payment, multiple invoices: Just check multiple invoices — QuickBooks spreads the amount across them. Adjust individual line amounts if the customer specified how to split it.
The golden rule: apply the payment the way the *customer* intended, if they told you. Their remittance advice beats QuickBooks' oldest-first default.
Step 5: Apply any credits or discounts
- If the customer has an available credit memo or overpayment, click Discounts & Credits at the bottom of the window.
- In the Credits tab, check the credits you want to apply to these invoices, then click Done.
- There's also a Discounts tab if you offered early-payment terms (like 2/10 net 30) and the customer paid in time.
Step 6: Save it
- Click Save & Close (or Save & New for the next payment).
- If you used Undeposited Funds, don't forget the second half: Banking > Make Deposits, select the payments, and record the actual bank deposit.
What about overpayments?
If the customer paid *more* than they owe, QuickBooks shows the excess as an unapplied amount (a customer credit). You have three options: leave it as a credit toward future invoices, refund it, or apply it later. Don't just let unapplied credits pile up silently — review them monthly, or customers start asking why their balance never goes down.
Common mistakes to avoid
- Recording an invoice payment as a sales receipt. Said it above, saying it again — this double-counts income. Invoice payments go through Receive Payments. Always.
- Letting QuickBooks auto-apply without checking. Oldest-first is a guess, not a decision. If the customer earmarked the payment for a specific invoice, apply it there.
- Double-counting bank feed deposits. If the payment downloaded through bank feeds *and* you recorded it in Receive Payments, you've recorded it twice. When you see the deposit in your bank feed, match it to the existing Receive Payments entry instead of adding a new one.
- Forgetting the bank deposit step. Payments sitting in Undeposited Funds forever mean your QuickBooks bank balance never matches the real one. Make deposits regularly.
- Applying payments to the wrong customer. Similar customer names, rushed data entry — it happens. A quick glance at the invoice list before saving catches most of these.
Need to fix a payment that was already applied to the wrong invoice? The fix is straightforward.
Conclusion!
That brings us to the end of this guide on how to apply customer payments to invoices in QuickBooks Desktop. We hope the steps explained above helped you record payments accurately and keep your receivables clean. If you run into any difficulty while following the steps, consider consulting a qualified and experienced QuickBooks professional for further assistance.
FAQs
Why is there an unapplied amount left after I save the payment?
The customer paid more than the total of the invoices you applied it to. The excess sits as a customer credit. You can apply it to another invoice later, leave it for future bills, or refund it.
Can I apply one payment across multiple invoices?
Yes — that's exactly what Receive Payments is built for. Check each invoice the payment covers and adjust the Payment column amounts so the total matches what the customer sent.
What's the difference between applying a payment and applying a credit?
Applying a *payment* records new money received from the customer. Applying a *credit* uses an existing credit memo or overpayment already on their account. Both reduce what the customer owes, but they start from different places.
The payment is in my bank account but the invoice still shows as unpaid. Why?
The deposit was recorded without linking it to the customer — probably entered directly in the bank register or through an unmatched bank feed transaction. The money is there, but QuickBooks doesn't know which invoice it belongs to. Record it through Customers > Receive Payments (or match the bank feed entry to the payment) so it applies to the invoice.
You may also like:
create customer statements in QuickBooks
credit memo in QuickBooks Desktop
give your customer a credit or refund
deposit QuickBooks payments into the undeposited funds
Un Apply a Payments in QuickBooks
Record and Make Bank Deposits in QuickBooks
