DEV Community: Kajal Shah

Inventory Tracking & FIFO Costing in QuickBooks Online

Kajal Shah — Sat, 07 Nov 2026 06:25:45 +0000

QuickBooks Online (QBO) makes it easy to keep a real‑time picture of what you have on hand and how much it’s worth. By using the built‑in FIFO (first‑in, first‑out) engine, you can let the system automatically assign the correct cost to each sale, while still having the tools to correct shrinkage, spoilage, or counting errors. The following guide walks through the core concepts, the workflow you should follow, and the common pitfalls to avoid.

Inventory vs Non‑Inventory

Tracked inventory items – These are items whose quantity on hand (QOH) and balance‑sheet value are recorded in QBO. Every purchase adds to an inventory asset account; every sale reduces QOH and moves the cost into Cost of Goods Sold (COGS).
Non‑inventory items – These are treated as expenses the moment you purchase them. Use this type for drop‑shipped goods, office supplies, or any item you never store. The cost is posted directly to an expense account, bypassing the inventory asset.

Choosing the right item type prevents unnecessary complexity and keeps your balance sheet clean.

Automated FIFO Costing

QBO applies FIFO automatically: the oldest purchase cost is the first to be recognized as COGS when you sell a unit. The typical flow looks like this:

Purchase Order (PO) – Create a PO to reserve the quantity you intend to buy.
Bill – When the vendor invoice arrives, enter a bill. QBO posts the amount to the inventory asset account and updates QOH.
Sales Invoice – Create an invoice for the customer. QBO pulls the cost from the earliest available purchase layer and records it in COGS, while reducing QOH.

Because the costing is automatic, you don’t need to manually calculate unit costs for each sale; the system ensures that the oldest cost layer is consumed first.

Inventory Adjustments

Real‑world inventory rarely matches the system perfectly. Use the Quantity Adjustment screen whenever you discover:

Shrinkage (theft or loss)
Spoilage or damage
Count errors discovered during a physical count

When you submit an adjustment, QBO debits an Inventory Shrinkage expense account and credits the inventory asset account, keeping the balance sheet accurate without affecting COGS retroactively.

The Negative Inventory Bug

A common error occurs when a sales invoice is entered before the corresponding purchase bill. QBO will allow the sale, driving QOH into negative territory. Later, when you finally record the bill, QBO retroactively re‑costs the earlier sale using the newly entered purchase price. This creates two problems:

Fatal ledger error – Negative QOH is a red flag and can cause downstream reports to misbehave.
Distorted historical COGS – The system rewrites the cost of the earlier sale, making your profit margins appear inconsistent.

Avoid this scenario by always entering vendor bills first.

Do / Avoid

Conduct quarterly physical counts and post any discrepancies through the Quantity Adjustment screen.
Enter vendor purchase bills before issuing customer sales invoices to maintain correct FIFO costing.
Use non‑inventory item types for custom‑order, drop‑shipped, or low‑value items that you never store.

Avoid

Letting inventory quantities drop below zero; it signals a timing issue in the purchase‑sale cycle.
Adjusting inventory asset balances with manual journal entries; always use the built‑in adjustment feature.
Tracking low‑cost office supplies or packaging materials as inventory; treat them as expenses.

Keep the flow of purchases → bills → sales consistent, and let QBO handle FIFO costing while you focus on accurate counts and timely adjustments.

Accurate inventory tracking + automated FIFO = reliable financials.

Sales Tax Setup & Automation in QuickBooks Online

Kajal Shah — Thu, 05 Nov 2026 11:46:19 +0000

QuickBooks Online (QBO) now offers a built‑in automated sales tax engine that removes the guesswork from rate calculations, jurisdiction rules, and filing obligations. When you enable the feature and follow a disciplined setup process, the software does the heavy lifting while you stay compliant with state, county, city, and special‑district taxes. Below is a practical walk‑through of the four core areas you need to master to keep your sales tax liability accurate and audit‑ready.

Automated Sales Tax

The automated engine pulls the latest rates from each tax authority the moment you create an invoice or sales receipt. It determines the exact rate by looking at the shipping address (or the customer’s location if no shipment) and cross‑referencing it with the nexus you have declared for each state.

Real‑time rate calculation – No more manual look‑ups. When you select a customer in QBO, the tax line appears automatically with the correct combined rate for that jurisdiction.
Jurisdiction rules – The engine layers state, county, city, and special‑district taxes in the proper order. If a county imposes a 0.5 % surcharge on top of a 6 % state rate, QBO adds both and shows the breakdown in the invoice detail.

To activate, go to Taxes → Sales Tax → Settings, turn on “Automated Sales Tax,” and then add every state where you have a physical or economic nexus. The system will prompt you to confirm the nexus type (physical vs. economic) and will automatically apply the appropriate thresholds.

Product & Service Mapping

Even the smartest engine can’t guess whether a line item is taxable. You must tell QBO which items are subject to tax and which are exempt.

Taxable categories – Assign each product or service a tax category (e.g., “Taxable Goods,” “Taxable Services,” “Non‑Taxable”). QBO uses this classification to decide whether to apply tax on a per‑line basis.
Exempt services – Consulting, legal, and many digital services are non‑taxable in most jurisdictions. Tag these items with a “Non‑Taxable” category so the engine skips them entirely.

When you add a new item, open the Sales information tab and select the appropriate tax category. For existing items, run a bulk edit from the Products and Services list to ensure consistency across the board.

Resale & Exemption Certificates

B2B transactions often involve resale or exemption certificates that remove the tax obligation from the buyer. QBO stores these documents at the customer level, providing an audit trail that state auditors expect.

Documenting exempt sales – Upload a scanned copy of the buyer’s resale or exemption certificate to the customer’s profile under Attachments. Link the certificate to the specific transaction by checking the “Exempt” box when you create the invoice.
Audit defense – If a tax audit occurs, the presence of a valid certificate in QBO demonstrates that you collected tax correctly and that the buyer was legitimately exempt. Missing certificates are a common reason for disallowed exemptions and penalties.

Make it a habit to request the certificate before you mark a sale as exempt and to set a reminder to renew certificates before they expire (most are valid for one to three years).

Recording Tax Payments

Once the automated engine calculates your liability, you must record the payment in the Sales Tax Center. This step closes the liability loop and keeps your reports accurate.

Sales Tax Center workflow – From Taxes → Sales Tax, click Record Tax Payment. Choose the tax agency, the period, and the amount you actually paid. QBO then clears the liability from the appropriate tax payable account.
Never write a regular check – Writing a generic expense check for “State Tax” bypasses the Sales Tax Center, leaving the liability balance untouched. The next time you run a liability report, the unpaid amount will still appear, leading to double‑paying or missed filings.

Always reconcile the payment amount with the agency’s statement before you record it, and attach the payment receipt to the transaction for future reference.

Do / Avoid

Enable Automated Sales Tax and configure every state where you have nexus, including economic nexus thresholds.
Assign proper taxability categories to all products and services; review the list quarterly for new offerings.
Retain valid resale and exemption certificates on file for every B2B customer that claims an exemption.

Avoid

Creating manual sales tax line items on invoices; let the engine generate the tax automatically.
Paying state revenue departments using generic expense or check forms; always use the Sales Tax Center.
Ignoring out‑of‑state economic nexus thresholds (typically $100 k in sales or 200 transactions); set up alerts in QBO to flag when you approach a threshold.

Accurate sales tax in QBO is a blend of automation and disciplined data hygiene. By enabling the engine, mapping items correctly, safeguarding exemption documentation, and recording payments through the proper channel, you eliminate most of the manual work and reduce audit risk.

Takeaway: Set up the automated engine once, keep your item categories and certificates current, and always close the loop in the Sales Tax Center to stay compliant without extra effort.

Inventory Valuation: FIFO, LIFO & WAC – How Cost‑Flow Assumptions Shape Your Bottom Line

Kajal Shah — Mon, 02 Nov 2026 06:59:21 +0000

When you sell goods, the cost you assign to each unit determines both your gross margin and the value of inventory on the balance sheet. The three most common cost‑flow methods—FIFO, LIFO, and Weighted Average Cost (WAC)—handle the “oldest vs. newest” cost question differently, and each choice ripples through taxable income, GAAP compliance, and day‑to‑day accounting tasks. Below is a practical rundown of each method, followed by actionable “Do / Avoid” guidelines you can implement immediately in QuickBooks or any ERP system.

FIFO (First‑In, First‑Out)

Oldest costs to COGS – The units you purchased earliest are the first ones recognized as cost of goods sold.
Higher net income during inflation – Because the older, cheaper inventory is removed first, the remaining stock reflects more recent, higher purchase prices, inflating gross profit and net income.

Why it matters: In a rising‑price environment, FIFO boosts reported earnings, which can improve loan covenants or investor perception. However, the higher profit also raises taxable income, so expect a larger tax bill.

LIFO (Last‑In, First‑Out)

Newest costs to COGS – The most recent purchases are recognized as cost of goods sold first.
Higher tax savings during inflation – Recent, higher costs reduce taxable income, lowering the tax liability.
US GAAP only, banned by IFRS – LIFO is permissible under U.S. GAAP but prohibited under IFRS. If you elect LIFO for tax purposes, you must also use it for financial reporting (LIFO conformity).

Why it matters: LIFO can be a strategic tax‑deferral tool, but the method locks you into a specific accounting regime. Switching away requires IRS approval and can trigger a “LIFO recapture” tax.

Weighted Average Cost (WAC)

Blended cost per unit – Total cost of inventory available ÷ total units available yields a single average cost.
Smooths price volatility – Each sale draws from a blended cost, dampening the impact of sudden price swings. This is practical for bulk commodities, high‑volume items, or when tracking individual lot costs is impractical.

Why it matters: WAC simplifies bookkeeping and reduces the administrative burden of lot tracking. The trade‑off is less precision in matching specific costs to specific sales, which can affect margin analysis for price‑sensitive products.

Lower of Cost or NRV

Net Realizable Value (NRV) – Estimated selling price minus predictable completion and disposal costs.
Impairment write‑down – If market value falls below recorded cost, inventory must be written down to NRV, recognizing an expense.

Why it matters: The lower‑of‑cost‑or‑NRV rule prevents overstating assets. Prompt write‑downs protect financial statements from hidden losses and keep tax reporting aligned with actual recoverable value.

Do / Avoid

Select one inventory valuation method and apply it consistently across all reporting periods.
Perform regular physical cycle counts (monthly or quarterly) to detect shrinkage, damage, or misplacements early.
Write down slow‑moving or obsolete inventory to NRV as soon as the decline is evident, rather than waiting for year‑end.

Avoid

Switching valuation methods without prior IRS approval; doing so can trigger audits and penalties.
Using LIFO for tax returns while reporting FIFO for audited financial statements; this violates LIFO conformity.
Ignoring inventory shrinkage until the annual physical count; undetected loss erodes gross margin and may lead to inaccurate tax filings.

Choose the method that aligns with your business’s pricing environment and reporting requirements, then enforce disciplined tracking. The right cost‑flow assumption not only shapes your profit numbers but also influences cash flow, tax liability, and compliance risk.

Bottom line: Consistency, regular verification, and timely write‑downs keep inventory valuation accurate and tax‑efficient.

Prepaids & Accruals: Month‑End Adjustments That Keep Your P&L Stable

Kajal Shah — Sat, 31 Oct 2026 08:18:59 +0000

Month‑end is the time to smooth out timing differences between cash flows and the period they belong to. Proper adjusting entries for prepaid expenses, accrued liabilities, and their reversals prevent wild swings in profit and loss and keep the balance sheet tidy. Below is a practical walk‑through of each adjustment type and the supporting schedules you should maintain in QuickBooks.

Prepaid Expenses

When a payment is made before the related benefit is consumed, the amount is recorded as an asset. Typical examples are annual insurance premiums or multi‑month software subscriptions.

Initial entry – Debit Prepaid Expense (asset) and credit Cash when the payment is made.
Monthly amortization – At each month‑end, debit the appropriate expense account (e.g., Insurance Expense or Software Subscription Expense) and credit Prepaid Expense for the portion that has been earned.
Result – The balance sheet shows the remaining unexpired portion, while the P&L reflects only the expense for the current period.

Accrued Liabilities

Accruals capture costs that have been incurred but not yet invoiced or paid, such as wages, interest, or taxes.

Month‑end booking – Debit the relevant expense (e.g., Wages Expense) and credit an accrued liability account (e.g., Accrued Wages).
Liability presentation – The accrued amount sits on the balance sheet until the vendor bill or payroll run clears it, at which point you debit the liability and credit cash.
Timing – This ensures the expense appears in the period it was earned, not when cash leaves the bank.

Reversing Entries

Reversals are a clean‑up step performed on the first day of the new period. They eliminate the risk of double‑counting when the actual bill arrives.

Create reversal – Replicate the accrual entry but with opposite debits and credits (e.g., debit Accrued Wages and credit Wages Expense).
Standard practice – After reversal, you can record the real vendor invoice normally without checking whether an accrual already exists.
Benefit – This habit keeps the trial balance accurate and reduces month‑end stress.

Support Schedules

A supporting schedule documents the movement of each prepaid or accrued balance.

Prepaid roll‑forward – Beginning balance + new prepaid additions – monthly amortization = ending balance.
Accrual roll‑forward – Beginning balance + new accruals – reversals/payments = ending balance.

Maintaining these schedules provides an audit trail and makes it easy to reconcile the GL to the schedule each month.

Do / Avoid

Amortize multi‑month software and insurance premiums monthly, matching expense to benefit.
Accrue unbilled contractor hours and payroll at month‑end to reflect work performed.
Reconcile prepaid and accrual schedules to the general ledger every month.

Avoid

Don’t expense a 12‑month policy entirely in month one; it inflates expenses and understates assets.
Don’t leave stale accruals on the balance sheet without review; they distort liabilities.
Don’t forget to reverse accruals when the actual vendor bills arrive; otherwise you’ll double‑count expenses.

Keep these adjustments disciplined and your financial statements will tell a consistent, accurate story month after month.

Classes, Locations, & Projects: How to Track Profitability Without Messing Up Your Chart of Accounts

Kajal Shah — Thu, 29 Oct 2026 05:07:25 +0000

QuickBooks offers three lightweight dimensions—Classes, Locations, and Projects—that let you slice your financial data by department, branch, or job without creating a maze of accounts. Below is a practical guide to using each feature effectively and the common pitfalls to avoid.

Class Tracking

Classes are internal labels that let you group transactions by business unit, product line, or any other logical division. When you enable “Class tracking” and set it to require a class on every transaction line, QuickBooks forces you to tag each entry, guaranteeing complete data for reporting.

Departmental reporting – Assign a class such as “Manufacturing”, “Wholesale”, or “Online Sales” to every invoice, bill, or journal line. The P&L by Class report then shows the revenue, expenses, and net profit for each division, making it easy to spot under‑performing areas.
P&L by Class report – Run this report monthly to see a clean profit and loss statement for each class. Any line that appears without a class indicates a missed entry, prompting a quick cleanup before the numbers are used for decision‑making.

Location Tracking

Locations work best for physical segmentation—offices, retail stores, or regional branches. Unlike classes, locations affect the address fields on forms, allowing each location to display its own company header on sales invoices and purchase orders.

Physical offices & stores – Create a location for each storefront or warehouse (e.g., “Chicago Store”, “East Coast Warehouse”). Transactions posted to a location automatically pull the correct address onto the document, keeping customer‑facing paperwork consistent.
Form headers – When you generate an invoice from the Chicago Store location, the header shows that store’s address, phone number, and branding without any manual changes.

Project Tracking

Projects are the go‑to tool for job costing. Rather than creating a separate customer or sub‑customer for every job, you attach a project to the relevant transactions. QuickBooks then aggregates income, material costs, labor hours, and other expenses for that project.

Job costing center – Set up a project called “Website Redesign – Acme Corp”. Tag all time entries, purchase orders, and invoices related to that job with the project. The system calculates total cost and revenue in real time.
Real‑time project margin – The Project Profitability report shows the margin as soon as a bill is entered, letting you intervene early if a job starts to run over budget.

Tags (Non‑Accounting)

Tags are a flexible, non‑financial categorization layer. They do not affect the General Ledger, tax reporting, or any accounting balances, but they are invaluable for ad‑hoc analysis.

Ad‑hoc categorization – Tag transactions with “Summer Campaign”, “John Doe – Sales Rep”, or “Industry Conference”. Later you can filter reports to see the impact of a specific marketing effort or salesperson.
Zero ledger impact – Because tags live outside the accounting engine, they can be added or removed without risking compliance or audit issues.

Do / Avoid

Set Class tracking to require a class on each transaction row.
Use Projects for job costing instead of cluttering the customer list with sub‑customers.
Run the Profit and Loss by Class report monthly to catch unclassified lines.

Avoid

Creating separate Chart of Accounts entries for offices or branches.
Leaving transactions without assigned classes on financial statements.
Confusing Locations (which affect form addresses) with Classes (which drive internal P&L).

Keep your accounting structure lean and let Classes, Locations, and Projects do the heavy lifting for profitability insight.

Fixed Assets & Depreciation: Book Straight‑Line vs. IRS MACRS & Section 179

Kajal Shah — Wed, 28 Oct 2026 04:40:59 +0000

When a growing business acquires equipment, furniture, or software, the decision of how to record and deduct the cost can feel like a maze. GAAP requires a systematic allocation of expense over an asset’s useful life, while the IRS offers accelerated methods that front‑load deductions. Understanding the difference, documenting a clear policy, and keeping two parallel schedules—one for book, one for tax—prevents errors, audit flags, and misstated financials.

Capitalization Policy

A formal capitalization threshold determines which purchases become fixed assets.

Threshold (e.g., $2,500) – Any item whose cost exceeds the threshold and whose useful life is longer than one year is capitalized. For example, a $3,200 desktop computer would be recorded as a fixed asset, not expensed immediately.
De minimis safe harbor – The IRS allows small‑tool and routine‑electronics expenses to be deducted outright if they fall below the threshold. This prevents the accounting team from tracking insignificant items and keeps the asset register manageable.

Document the threshold in the accounting manual, obtain management approval, and apply it consistently across all departments.

GAAP Book Depreciation

Financial statements must reflect the economic consumption of assets using a systematic method.

Straight‑line method – The simplest approach: (Asset Cost – Salvage Value) ÷ Useful Economic Life. A $12,000 office printer with a $2,000 salvage value and a five‑year life yields an annual depreciation expense of ($12,000‑$2,000)/5 = $2,000.
Accumulated depreciation – A contra‑asset account that aggregates yearly depreciation. After three years, the printer’s accumulated depreciation would be $6,000, reducing its net book value on the balance sheet.

Straight‑line provides predictable expense patterns, which investors and lenders expect in GAAP reporting.

Tax Depreciation (IRS)

The tax code encourages capital investment by allowing faster cost recovery.

Section 179 expensing – Qualifying equipment can be expensed 100 % in the year of purchase, subject to annual limits (e.g., $1,160,000 in 2024). If a business buys a $30,000 CNC machine and elects Section 179, the entire cost reduces taxable income immediately.
MACRS & Bonus depreciation – The Modified Accelerated Cost Recovery System spreads depreciation over predefined recovery periods (typically 3‑7 years for equipment) with larger deductions in the early years. Bonus depreciation (100 % for qualified property placed in service before 2027) can be combined with MACRS to front‑load deductions even further.

Tax depreciation schedules are separate from book schedules; they must never be used to calculate GAAP expense.

Disposals & Net Book Value

When an asset leaves service, the accounting treatment hinges on its net book value (NBV).

Net Book Value (NBV) – Original cost minus accumulated depreciation. Using the printer example, after three years the NBV is $12,000 – $6,000 = $6,000.
Gain or loss on disposal – Compare cash received (or fair market value) to NBV. If the printer is sold for $4,000, the company records a loss of $2,000 ($4,000 – $6,000). A gain occurs when proceeds exceed NBV.

Remove the asset from the register promptly, record the disposal entry, and adjust accumulated depreciation to zero.

Do / Avoid

Adopt and document a formal capitalization threshold policy.
Maintain a detailed asset register with serial numbers, locations, acquisition dates, and cost.
Track book and tax depreciation schedules separately to avoid cross‑contamination.

Avoid

Capitalizing routine maintenance and repair costs; they belong to expense.
Using MACRS schedules for GAAP financial statements.
Leaving sold, scrapped, or otherwise retired assets active on the fixed‑asset register.

A disciplined approach to fixed assets keeps financial statements accurate, tax filings compliant, and audit trails clear.

Consistently separate book and tax depreciation, and your asset management will stay both compliant and insightful.

Revenue Recognition under ASC 606: A Practical Five‑Step Cheat Sheet

Kajal Shah — Sat, 24 Oct 2026 11:48:38 +0000

Revenue recognition under ASC 606 can feel like a maze, but breaking it down into five clear steps makes it manageable for any accountant handling contracts in QuickBooks. Below is a concise walk‑through of each step, plus quick do’s and avoid‑list items you can apply today.

Steps 1 & 2: Contracts & Obligations

Identify the customer contract – Ensure the agreement is enforceable, has defined payment terms, and possesses commercial substance. In QuickBooks, record the contract as a sales receipt or invoice with a clear reference number, and attach any supporting documents to the transaction.

Identify performance obligations – List every distinct good or service promised. A “distinct” obligation is one the customer could obtain separately or that is not interdependent with other promises. For a software‑as‑a‑service (SaaS) deal, the obligations might include: (1) access to the platform, (2) implementation consulting, and (3) ongoing support. Tag each obligation in your internal checklist so you can later allocate price and track completion.

Steps 3 & 4: Pricing & Allocation

Determine the transaction price – Start with the fixed fee stated in the contract, then adjust for any variable consideration (e.g., usage‑based fees, performance bonuses) and expected refunds. In QuickBooks, you can create a “Revenue Estimate” account to hold the total transaction price before allocation.

Allocate across obligations – Apportion the total price to each performance obligation based on its standalone selling price (SSP). If the SSP for implementation is $2,000 and the SSP for the subscription is $8,000, allocate 20 % of the transaction price to implementation and 80 % to the subscription. Use QuickBooks’ “Classes” or “Locations” feature to track these allocations on a per‑obligation basis.

Step 5: Revenue Timing

Over time vs. point in time – Recognize revenue over time when the customer consumes the service (e.g., monthly SaaS access) or at a point in time when control transfers (e.g., delivery of a hardware device).

Milestones and percentage of completion – For long‑term projects, recognize revenue as performance milestones are achieved or using the percentage‑of‑completion method. Record each milestone as a separate line item in QuickBooks, moving the allocated amount from Deferred Revenue to Earned Revenue as the milestone is satisfied.

Deferred Revenue Liability

Cash before delivery – When a customer pays in advance, the cash sits on the balance sheet as a liability called Deferred Revenue. In QuickBooks, post the receipt to a “Deferred Revenue” liability account.

Monthly amortization – As the service is delivered, amortize the liability into earned revenue each month. Set up a recurring journal entry that debits Deferred Revenue and credits the appropriate revenue account, matching the allocation determined in Step 4.

Do / Avoid

Document distinct performance obligations in service contracts and reference them in QuickBooks.
Record advance customer billings to the Deferred Revenue liability account immediately upon receipt.
Allocate bundled pricing using standalone selling prices and reflect the allocation in your chart of accounts.

Avoid

Recognizing 100 % of revenue upfront on annual subscription contracts.
Booking revenue before the related performance obligations are satisfied.
Ignoring variable consideration and refund clauses when calculating the transaction price.

Revenue recognition under ASC 606 is systematic: identify the contract, pinpoint obligations, price and allocate, then recognize revenue as you fulfill each promise. Applying these steps in QuickBooks keeps your books compliant and your financial statements reliable.

Undeposited Funds in QuickBooks: Turning a Holding Account into a Time‑Saver

Kajal Shah — Thu, 22 Oct 2026 13:25:19 +0000

QuickBooks Online (QBO) creates an “Undeposited Funds” account by default. Think of it as a virtual holding pen for customer payments that haven’t yet been batched into a real bank deposit. When used correctly, it prevents timing gaps between when you receive a check or card payment and when the money actually lands in your bank. Misuse, however, quickly inflates the balance, creates duplicate income, and turns a simple bookkeeping task into a nightmare.

The Holding Pen Concept

Undeposited Funds acts as a bridge account. Every time you record a payment—whether it’s a paper check, a credit‑card swipe, or an ACH transfer—the amount lands here first. The account holds the cash until you physically gather the slips and create a single “Bank Deposit” transaction in QBO. This mirrors the real‑world practice of bundling several customer checks into one deposit, keeping your books aligned with the actual deposit you’ll make at the bank.

Batching Power

When you deposit five checks together, the bank feed will show one line: “Deposit – 5 checks – $2,350.” QBO can match that single line to the total of the five individual payments sitting in Undeposited Funds. The match is instant, eliminating the need to reconcile each check separately. This batching saves time and reduces the chance of mismatched amounts, because the sum of the payments is compared directly to the bank’s deposit total.

The Red Flag: Giant Balance

Problems arise when users add a deposit directly from the bank feed instead of matching the existing Undeposited Funds balance. QBO then records a new deposit and leaves the original payments untouched, doubling the revenue. The Undeposited Funds balance balloons, and the bank feed shows an “unmatched” deposit line. That giant balance is the first warning sign that payments are being double‑counted.

Clean‑Up Best Practice

Treat the “Payments to Deposit” report as a weekly health check. Open the Bank Deposit screen, locate any orphaned entries, and either match them to the feed or delete the duplicate deposit. The goal is a zero balance in Undeposited Funds at the end of each week—every payment you’ve recorded should have cleared to a real bank account. When merchant processing fees apply, enter them as negative lines on the same Bank Deposit transaction; this keeps fees linked to the correct batch and avoids separate journal entries.

Do

Bundle checks and merchant batches in a single Bank Deposit to match the feed line.
Review the Payments to Deposit report weekly to ensure the holding account clears.
Record merchant processing fees as negative lines on the bank deposit transaction.

Avoid

Clicking “Add” on a bank‑feed deposit while payments still sit in Undeposited Funds.
Leaving customer payments in Undeposited Funds for months.
Writing journal entries directly against the Undeposited Funds account.

Keep the holding pen tidy, and Undeposited Funds will work for you, not against you.

Invoicing & Receiving Payments: A Clean Three‑Step Workflow for QuickBooks Users

Kajal Shah — Tue, 20 Oct 2026 14:28:15 +0000

A tidy Accounts Receivable process saves time, prevents phantom income, and keeps your audit trail intact. Below is a practical, step‑by‑step guide that works in any QuickBooks environment, from Desktop to Online.

Step 1: Create Invoice

Select customer and terms – Choose the right customer record and apply the agreed payment terms (Net 30, Due on receipt, etc.).
Itemize products/services, quantities, and sales tax codes – Add each line item with its quantity, rate, and the appropriate sales‑tax code. QuickBooks will calculate tax automatically.

General Ledger impact

Debit Accounts Receivable (A/R) for the total invoice amount (including tax).
Credit the appropriate Income accounts for each product or service.

This entry records revenue when the invoice is sent, not when cash arrives, which is the cornerstone of accrual accounting.

Step 2: Receive Payment

Apply to specific invoice – When a payment arrives, open the Receive Payment window, select the customer, and tick the exact invoice(s) being settled. QuickBooks links the payment to the outstanding invoice number, preserving traceability.
Avoid duplicate income – The system automatically debits Undeposited Funds and credits Accounts Receivable. No income is recognized again because the revenue was already recorded at invoicing.

If a payment only covers part of an invoice, QuickBooks leaves the remainder open, ready for future payments.

Step 3: Bank Deposit

Group related payments – In the Bank Deposit screen, select all payments that will be deposited together (e.g., the batch that appears on your bank statement).
Match bank feed line – Choose the corresponding bank‑feed line, then debit the Bank Account and credit Undeposited Funds.

This step moves money from the holding account (Undeposited Funds) to the real bank account, completing the cash‑flow cycle without affecting Income.

Credit Memos & Refunds

Proper dispute handling – If a customer disputes an invoice, issue a Credit Memo. The memo reduces the customer’s A/R balance cleanly and creates a corresponding credit in the Income account.
Never delete sent invoices – Deleting an invoice erases the audit trail and can create gaps in sequential invoice numbering. Instead, void or credit the invoice to keep the history intact.

Do / Avoid

Follow the Invoice → Receive Payment → Bank Deposit sequence strictly.
Verify payment terms and sales‑tax codes before sending invoices.
Apply payments directly to the specific invoices being settled.

Avoid

Recording bank deposits directly to Income when an invoice already exists.
Marking invoices paid using manual journal entries.
Editing or deleting sent invoices after the accounting period has closed.

A disciplined three‑step workflow eliminates phantom income, keeps A/R tidy, and ensures your books are audit‑ready.

Accounts Receivable & Aging (ASC 326): Practical Steps for Managing Credit Risk

Kajal Shah — Mon, 19 Oct 2026 08:20:19 +0000

Managing accounts receivable (AR) is a balancing act between keeping cash flowing and protecting the bottom line. The ASC 326 “Current Expected Credit Losses” (CECL) model forces companies to look ahead, estimating losses over the life of a receivable rather than waiting for a default. Below is a concise guide that walks through the invoicing cycle, aging buckets, the allowance for doubtful accounts, and the distinction between GAAP and tax treatments. The focus is on actions you can take today in QuickBooks or any ERP system.

The Invoicing Cycle

The cash conversion process starts with a clear customer agreement. Once goods or services are delivered, an invoice is generated that reflects the agreed‑upon payment terms—commonly Net 30, Net 45, or Net 60. Including early‑payment discounts (e.g., 2 % if paid within 10 days) gives customers an incentive to settle early and improves days sales outstanding (DSO). In QuickBooks, set up recurring invoice templates that automatically embed these terms, so every transaction follows the same timeline.

Aging Buckets

After an invoice is posted, it falls into one of several aging categories: Current, 1‑30 days, 31‑60 days, 61‑90 days, and 90+ days. Segmenting AR this way highlights where collection effort should be focused. For example, a surge in the 61‑90 bucket often signals a bottleneck in the follow‑up process. Automation tools can trigger reminder emails before an invoice hits 60 days, and schedule a phone call or escalation after that point. Configuring these rules in QuickBooks ensures consistency without manual tracking.

Allowance for Doubtful Accounts

Under ASC 326, companies must maintain a contra‑asset allowance that reduces the gross AR balance to its estimated collectible amount. The allowance is calculated using historical loss rates, adjusted for current economic conditions and specific customer risk factors. In practice, you would pull a report of past write‑offs, apply a weighted loss percentage to each aging bucket, and record the resulting figure in a “Allowance for Doubtful Accounts” account. This entry aligns the expense with the period in which the related sales occurred, satisfying GAAP matching requirements.

Allowance vs Direct Write‑Off

GAAP obligates the use of an allowance method, because it matches bad‑debt expense to revenue. The tax code, however, permits the direct write‑off method: you can deduct a specific bad debt only when it becomes wholly uncollectible. The practical impact is that financial statements will show a net AR figure after the allowance, while the tax return may reflect a higher expense in the year the write‑off occurs. Keep separate journal entries for each method to avoid confusion during year‑end closing.

Do / Avoid

Review the AR aging summary weekly and flag any account that has lingered in the 60‑day bucket or beyond.
Establish a formal credit‑check policy before extending terms; use credit bureau scores or trade references as a baseline.
Reconcile the AR subledger to the general‑ledger balance monthly to catch posting errors early.

Avoid

Do not use the direct write‑off method for GAAP financial reporting; it violates ASC 326.
Do not let disputed invoices sit in the aging report without active resolution; they distort collection metrics.
Do not write off an uncollectible balance without documented management sign‑off; this creates audit risk.

A disciplined AR process—paired with a CECL‑compliant allowance—protects cash flow while keeping financial statements accurate.

Mastering the QBO Bank Feed: Rules, Matching, and Safe Automation

Kajal Shah — Sun, 18 Oct 2026 05:05:10 +0000

QuickBooks Online’s bank feed is a powerful shortcut for getting transactions into the books, but it can also become a source of errors if you treat it like a magic button. Understanding the difference between matching and adding, building reliable bank rules, and knowing when to let the system auto‑add versus when to intervene can keep your ledger clean and your reconciliations painless.

Match vs Add (Crucial)

When a transaction lands in the feed, QBO first tries to Match it to an existing invoice, bill, or payment. A green “Match” suggestion means the system has found a record with the same amount, date, and vendor/customer reference. Clicking Match links the feed line to that record, marks it as cleared, and prevents a duplicate entry.

If you click Add instead, QBO creates a brand‑new transaction. This is appropriate only when the feed line truly represents something that has not been recorded yet—such as a new expense that has no bill in the system. Adding on top of an already‑entered bill or invoice will generate a duplicate, inflating expenses or revenue and breaking downstream reports. As a rule of thumb, always verify the green match suggestion before you consider adding anything manually.

Building Bank Rules

Bank rules automate categorization, but the rule’s criteria must be precise. The Bank Text field (the raw text that appears in the feed) is far more reliable than the generic “Description” field, which can be truncated or altered by the bank. Use the “Bank Text contains” condition with a distinctive keyword—e.g., “ADOBE.COM” for a recurring Adobe subscription—so the rule fires only on the intended transaction.

A well‑crafted rule can set the vendor, account, class, and even the tax code automatically, eliminating manual entry. However, test each rule on a few transactions before enabling it for the entire feed. If the rule misfires, it can misclassify expenses across categories, leading to inaccurate profit‑and‑loss statements.

Auto‑Add: Proceed With Care

The Auto‑Add option tells QBO to create a transaction the moment a rule matches a feed line, without any human review. This works well for fixed recurring charges—for example, a $49.99 monthly SaaS subscription that never changes.

Avoid auto‑add for variable or multi‑category expenses such as office supplies, travel, or utilities where the amount or vendor may shift month to month. Blind auto‑add can assign the wrong account or tax code, and you may not notice the mistake until the next reconciliation. When in doubt, keep auto‑add off and let the rule suggest a match that you can manually confirm.

Exclude vs Delete

Sometimes the feed contains duplicate lines (often due to a bank’s processing delay) or personal transactions that belong elsewhere. Use the Exclude function to hide these lines from the feed without removing them from the reconciliation history. Excluding keeps the transaction in the audit trail, preserving the integrity of past reconciliations.

Never Delete a cleared item. Deleting removes the transaction from QBO entirely, which instantly breaks any previous bank reconciliation that referenced it. The result is a mismatch between your bank statement and the cleared balance, forcing you to redo months of work.

Do / Avoid

Verify and click Match whenever a green match suggestion appears.
Create bank rules using Bank Text contains rather than the generic description field.
Clear and review the bank feed queue at least twice a week to catch anomalies early.

Avoid

Clicking Add on customer payments that were already invoiced.
Enabling Auto‑Add rules on variable or multi‑category expenses.
Leaving transfers between accounts unmatched on either side; reconcile both ends.

Keep the bank feed as a reliable assistant, not a replacement for review.

A disciplined approach to matching, rule creation, and cautious automation ensures your QuickBooks Online books stay accurate and audit‑ready.

The Accounting Equation & Double‑Entry: A Practical Cheat Sheet

Kajal Shah — Fri, 16 Oct 2026 05:22:18 +0000

Understanding the backbone of every transaction starts with the accounting equation: Assets = Liabilities + Equity. This simple formula guarantees that every debit has a matching credit, keeping the books balanced. Below we unpack the core concepts, show how they tie into the balance sheet, and list the essential do’s and don’ts for clean, error‑free bookkeeping.

The Fundamental Equation

Assets = Liabilities + Equity – What you own equals what you owe plus the owner’s stake.
Self‑balancing ledger – For every debit entered, an equal and opposite credit must be recorded. This duality ensures that the equation never tilts.

Debits & Credits (DC ADE LER)

Debits increase ADE – Assets, Drawings/Dividends, and Expenses grow on the debit side.
Credits increase LER – Liabilities, Equity, and Revenue expand on the credit side. Remember the mnemonic “ADE = Debit, LER = Credit” to quickly determine which side a transaction belongs to.

Balance Sheet Connection

Point‑in‑time snapshot – The balance sheet captures the cumulative position of assets, debts, and retained equity at a specific date.
Trial balance verification – Before the books close, total debits must equal total credits across all accounts. A balanced trial balance is the first sanity check that the underlying equation holds.

P&L to Retained Earnings

Net income closes to equity – Revenue and expense accounts from the profit‑and‑loss (P&L) statement roll into retained earnings, increasing equity when net income is positive.
Permanent vs temporary accounts – P&L accounts are temporary; they reset to zero at fiscal year‑end, while balance‑sheet accounts (assets, liabilities, equity) carry forward.

Do / Avoid

Verify that every journal entry balances before posting.
Confirm trial balance debits equal credits before month‑end close.
Classify balance‑sheet vs income‑statement accounts correctly.

Avoid

Don’t memorize debits as “good” and credits as “bad.”
Don’t post out‑of‑balance entries into suspense accounts as a shortcut.
Don’t adjust retained earnings directly without CPA guidance.

Keep the equation front and center, and every ledger will stay in harmony.

DEV Community: Kajal Shah

Inventory Tracking & FIFO Costing in QuickBooks Online

Inventory vs Non‑Inventory

Automated FIFO Costing

Inventory Adjustments

The Negative Inventory Bug

Do / Avoid

Sales Tax Setup & Automation in QuickBooks Online

Automated Sales Tax

Product & Service Mapping

Resale & Exemption Certificates

Recording Tax Payments

Do / Avoid

Inventory Valuation: FIFO, LIFO & WAC – How Cost‑Flow Assumptions Shape Your Bottom Line

FIFO (First‑In, First‑Out)

LIFO (Last‑In, First‑Out)

Weighted Average Cost (WAC)

Lower of Cost or NRV

Do / Avoid

Prepaids & Accruals: Month‑End Adjustments That Keep Your P&L Stable

Prepaid Expenses

Accrued Liabilities

Reversing Entries

Support Schedules

Do / Avoid

Classes, Locations, & Projects: How to Track Profitability Without Messing Up Your Chart of Accounts

Class Tracking

Location Tracking

Project Tracking

Tags (Non‑Accounting)

Do / Avoid

Fixed Assets & Depreciation: Book Straight‑Line vs. IRS MACRS & Section 179

Capitalization Policy

GAAP Book Depreciation

Tax Depreciation (IRS)

Disposals & Net Book Value

Do / Avoid

Revenue Recognition under ASC 606: A Practical Five‑Step Cheat Sheet

Steps 1 & 2: Contracts & Obligations

Steps 3 & 4: Pricing & Allocation

Step 5: Revenue Timing

Deferred Revenue Liability

Do / Avoid

Undeposited Funds in QuickBooks: Turning a Holding Account into a Time‑Saver

The Holding Pen Concept

Batching Power

The Red Flag: Giant Balance

Clean‑Up Best Practice

Do

Avoid

Invoicing & Receiving Payments: A Clean Three‑Step Workflow for QuickBooks Users

Step 1: Create Invoice

Step 2: Receive Payment

Step 3: Bank Deposit

Credit Memos & Refunds

Do / Avoid

Accounts Receivable & Aging (ASC 326): Practical Steps for Managing Credit Risk

The Invoicing Cycle

Aging Buckets

Allowance for Doubtful Accounts

Allowance vs Direct Write‑Off

Do / Avoid

Mastering the QBO Bank Feed: Rules, Matching, and Safe Automation

Match vs Add (Crucial)

Building Bank Rules

Auto‑Add: Proceed With Care

Exclude vs Delete

Do / Avoid

The Accounting Equation & Double‑Entry: A Practical Cheat Sheet

The Fundamental Equation

Debits & Credits (DC ADE LER)

Balance Sheet Connection

P&L to Retained Earnings

Do / Avoid

Fixed Assets & Depreciation: Book Straight‑Line vs. IRS MACRS & Section 179

Revenue Recognition under ASC 606: A Practical Five‑Step Cheat Sheet

Accounts Receivable & Aging (ASC 326): Practical Steps for Managing Credit Risk

Debits & Credits (DC ADE LER)