Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I understand from what I've read that QBO does not show inventory on cash basis reports. That makes absolutely no sense to me, but okay. But then when I run an accrual P&L no COGS show up. And these aren't coming from the sale of inventory. They were posted here directly with a bill. So then I wondered if inventory is missing on cash basis and COGS is missing on accrual basis, how is net income going to match on the Balance Sheet. And guess what? It doesn't. I ran a cash basis P&L and a cash basis BS and they don't match. I did the same for accrual basis and they don't match either. Can someone make sense of this? And more importantly, how do I fix it?
Hello, @jantco.
Allow me to share some information about running reports in QuickBooks Online (QBO).
The Cost of Good Sold (COGS) is only affected when you sell inventory items on invoices or sales receipts. It'll also show up on the Profit and Loss report either on the Accrual or Cash basis depending on how you record the transaction when the item is sold out.
Also, the Profit and Loss and Balance Sheet are two different reports. Each report has designated accounts to reason why they don't match. The profit and loss report shows your income and expenses while the balance sheet displays your assets, liabilities, and equity.
To learn more about inventory tracking and COGS, check out this article.
Also, read the details from this link for your reference about running and customizing reports in QBO.
If you have any other questions, mention my name in the comment section below. I'm always here to help as quickly as I can. Have a good day!
My fiscal year is November 1st to October 31st and I need the net income on my balance sheet to reflect that. How can I do that?
Good day and congratulations on making your first post here, @Lromoff. It's my priority to help you pull up a balance sheet report according to your preferred fiscal year.
The Balance Sheet report shows net income for the current fiscal year. You'll need to set your report period to view it. I’ll show you how:
For your reference, I've added some snapshots below:
Here’s an article you can read about how this report works in the program: What is a Balance Sheet report in QuickBooks Online? This includes the difference of it among others and the steps to compare the Balance Sheet to A/R Aging Summary or A/R Aging Detail reports.
Furthermore, you can also change your fiscal year or the start of your financial year in QuickBooks. This way, you won’t have to customize the dates in your report again.
Here’s how:
I’ve added these resources to guide you with filtering to get the data you need and saving it with its current customization settings:
Feel free to leave a reply in the comment section if you need further help with managing reports or anything else related to QuickBooks. I'll always be here to assist you. Wishing you all the best!
I am on Accrual Basic and this is the first Month (February) which I can't understand why income on both reports does not match...
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here