


Ask the community...
Just wanted to share a simple spreadsheet approach I use for my small business that might help! I track inventory in Excel with these columns: Date | Item | Quantity Purchased | Cost | Running Average Cost Whenever I get new inventory, I update the running average cost. Then for sales tracking: Date | Item | Quantity Sold | Current Average Cost | COGS This gives me a rolling COGS that's more accurate than doing one big calculation at year-end. Saved me tons of headaches with my Schedule C!
Does your method work if you have hundreds of different products? I sell a ton of different items on my Etsy shop and this sounds really time-consuming to maintain.
You're right that it gets more complex with hundreds of products. I have about 65 products and it's manageable. For larger inventories, I'd recommend grouping similar products into categories with similar margin profiles. You could also look into inventory management software that integrates with Etsy. I've heard good things about Craftybase and Inventory Planner - both calculate COGS automatically and connect to sales platforms. Might be worth the investment if manual tracking is becoming too burdensome with your product volume.
Isn't it easier to just use the formula: Beginning Inventory + Purchases - Ending Inventory = COGS? That's what my accountant told me to do for my Shopify store. You just need to know your inventory value at the start of the year, add what you bought, and subtract what's left at the end.
What's your mortgage situation? If you refinanced or bought recently with a lower interest rate, you might be paying less in interest, which means less potential deduction. But honestly, with the standard deduction at $29,200 for married filing jointly, you'd need a LOT of itemized deductions to beat taking the standard.
If you're consistently owing now with your higher salaries, you should definitely adjust your W-4 withholdings. It's free and will prevent the shock next year. You can each submit a new W-4 to your employers asking for additional withholding - even just $50-100 extra per paycheck could prevent the big bill next April.
Everyone's making this more complicated than it needs to be. For cash basis, you record the expense when the check is written. Period. That means your Line 1 on Schedule L is your book balance, NOT your bank statement balance. And remember that Schedule L is just informational for most small S-Corps anyway - it doesn't affect your tax liability. The IRS mainly uses it to check for consistency in your reporting from year to year.
So what happens if the checks never get cashed? Do you have to add that back as income in the next year?
If checks never get cashed, it depends on your state's abandoned property laws and how long it's been. For tax purposes, if you determine a check will never be cashed (recipient lost it, company no longer exists, etc.), you should void the check in your accounting system. For the following year, this effectively increases your cash balance. It's not technically "income" - you're just reversing the previous expense. If it's material and from a prior year, you might need to file an amended return, but for small amounts many accountants just adjust it in the current year since Schedule L is informational only for most S-Corps.
Does anyone know if this is handled differently in QuickBooks? When I reconcile my bank account, QB keeps track of the outstanding checks separately, so my cash balance in QB already reflects that those checks are "paid" even though they haven't cleared the bank. Is the amount I should put on Line 1 just my QB cash balance then?
Yes, use your QuickBooks cash balance for Line 1. QB is already handling those outstanding checks correctly for cash basis accounting. When you wrote the checks in QB, it reduced your book cash balance immediately, regardless of when they clear the bank. That's why when you reconcile in QB, your starting point is the bank statement balance, and then you check off cleared checks to reach your book balance. Your QB cash balance (the book balance) is the correct amount to report on Line 1.
Just a heads up that different brokerages sometimes use different notations for losses. While brackets/parentheses are standard accounting practice, I've seen some statements that use a minus sign instead, or even color coding (red for losses). Always check your specific brokerage's statement guide usually found in fine print at the bottom or in a separate document.
Do you know if there's any standard way the IRS expects these to be reported? I'm using tax software and it keeps asking for positive numbers and then a separate indication of gain/loss.
The IRS forms themselves typically have separate columns or boxes for gains and losses, so you'd enter positive numbers in either the gain or loss section as appropriate. Most tax software is designed to match this approach, asking you to enter the amount as a positive number and then specify whether it's a gain or loss through a dropdown menu or checkbox. This is actually more foolproof than using negative numbers, as it prevents accidental reversals that could occur if you forgot to include the negative sign.
Does anyone know how wash sale rules apply to futures trading? I thought they were exempt but my accountant says otherwise.
Your accountant is likely mixing up different types of securities. Section 1256 contracts (which include regulated futures contracts) are generally NOT subject to wash sale rules. This is one of the tax advantages of trading futures versus stocks or options. Since futures are marked-to-market at year end and receive the 60/40 tax treatment, the wash sale restrictions that apply to stocks and securities don't apply. All gains and losses are recognized in the tax year they occur.
Liam McGuire
One approach I've seen work well is electing to have your LLC taxed as an S-Corporation instead of a sole proprietorship. This creates a separate tax entity where you can implement an accountable plan for vehicle reimbursement that can be more advantageous than the straight mileage deduction. The key is proper documentation and separation between business and personal use. No matter what approach you take, you NEED to keep detailed mileage logs. The IRS routinely disallows vehicle deductions during audits because of poor record keeping.
0 coins
Amara Eze
ā¢Can you explain more about this accountable plan thing? I've never heard of it but sounds like it might be useful for my situation. My LLC is taxed as an S-corp already.
0 coins
Liam McGuire
ā¢An accountable plan is an arrangement that allows your business to reimburse you for business expenses without those reimbursements being counted as taxable income to you. For it to qualify, you need three key elements: a business connection for the expense, adequate accounting within a reasonable time period, and returning excess reimbursements. For vehicles specifically, you can set up a plan where your S-Corp reimburses you at the standard IRS mileage rate for documented business miles. This creates a deductible business expense for the company while providing you tax-free reimbursement. It's often more advantageous than trying to deduct lease payments directly, especially for mixed-use vehicles.
0 coins
Giovanni Greco
Has anyone tried just buying the car personally and then just billing your LLC for mileage at the IRS rate? I think its like 67 cents per mile now? Seems way simpler than all this lease stuff.
0 coins
Fatima Al-Farsi
ā¢Thats what i do! way easier and no headaches about mixed use. I just keep track of business miles in an app and bill my LLC monthly. My accountant said its the cleanest way to do it for a small business owner.
0 coins