


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.
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.
The key thing nobody's mentioned yet is that you should consider setting up a Coogan account/blocked trust depending on your state laws. Many states require that 15-25% of a child performer's earnings be set aside in a protected account they can access when they turn 18. California, New York, Louisiana, and some other states have these laws. If you don't comply, you could face issues with future contracts or even penalties.
What happens if we're in a state without those specific laws? We're in Georgia, and I'm not sure if there are similar requirements here. Should we still set something aside for her?
Georgia doesn't have a specific Coogan Law requirement like California or New York. However, it's still a really good idea to set aside some of your child's earnings in a trust or protected account for their future. Even without legal requirements, many parents choose to save a portion of their child's earnings for college or to give them a financial head start when they reach adulthood. You could set up a 529 college savings plan, a custodial account (UTMA/UGMA), or even a standard savings account in your child's name with you as the custodian. Just be aware that if you're working across state lines or with companies based in Coogan Law states, you might still need to comply with their requirements.
Has anyone had to deal with the "kiddie tax" with child performers? I've heard it can apply to investment income if you put their earnings into savings accounts or investments.
Kiddie tax only applies to unearned income (investments, interest, etc), not to the modeling/acting earnings themselves. If you invest your child's earnings and those investments generate more than $2,300 in income (dividends, interest, capital gains), that's when kiddie tax might kick in. In that case, any unearned income over that threshold would be taxed at the parent's higher tax rate.
Don't forget to check if this is actually a legitimate notice from the IRS! There are tons of scams going around. A real notice of deficiency comes as a certified letter and is called a "90-day letter" or "statutory notice of deficiency." It will reference your right to petition the Tax Court. If it's real, you have 90 days to either: 1. File a petition with the Tax Court (don't need to pay first) 2. Pay the tax and file for a refund 3. Contact the IRS to resolve the issues as others have mentioned The RSU issue is super common - the IRS computer just matches what was reported without knowing the basis. For the unemployment, definitely sounds like identity theft.
Thanks for mentioning this! Yes, it is definitely a legitimate notice - came certified mail, has the official letterhead, and specifically mentions the 90-day period to petition the Tax Court. I wish it was a scam, honestly would be less stressful! Do you think I should go directly to Tax Court, or try to resolve it with the IRS first? The RSU issue seems straightforward once I provide the correct basis info, but the unemployment thing has me worried.
I'd definitely try to resolve it directly with the IRS first. Tax Court should be a last resort, especially since your issues seem correctable with proper documentation. The RSU basis correction is routine, and the IRS generally handles these well once you provide the proper information. For the unemployment issue, treat it as identity theft from the start. File the Identity Theft Affidavit (Form 14039) immediately. Also contact the state unemployment office where the benefits were supposedly paid - they may already have a fraud department investigating similar cases. Getting documentation from them stating you never received benefits will be extremely helpful for your IRS response.
When you're prepping your response, make sure your numbers are EXACT. The IRS matching system is very literal. If your 1099-B shows basis of $10,543.27, don't round to $10,543. I made this mistake and it caused my correction to be rejected because the numbers didn't match their records exactly. Also, call your brokerage directly and ask for a corrected/detailed 1099-B that clearly shows the cost basis. Sometimes the initial forms they send don't have all the details the IRS wants to see. Most brokerages deal with this RSU issue constantly and have special documentation they can provide specifically for responding to IRS notices.
That's such a good point about exact numbers! When I had a similar issue, I rounded on one form and it caused weeks of additional back-and-forth. Also worth noting that the broker's "supplemental information" often has basis details that aren't on the main 1099-B. Check all those extra pages they send!
Jungleboo Soletrain
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.
0 coins
Rajan Walker
ā¢So what happens if the checks never get cashed? Do you have to add that back as income in the next year?
0 coins
Jungleboo Soletrain
ā¢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.
0 coins
Nadia Zaldivar
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?
0 coins
Lukas Fitzgerald
ā¢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.
0 coins