Question

Income on the Balance Sheet doesn't match the income on the P&L

Forum|Forum|5 years ago
August 8, 2020
1 reply
12 views

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?

QuickBooks Online

Angelyn_T

Moderator

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!

L

Lromoff

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?

J

JamaicaA

QuickBooks Team

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:

On the left pane, go to the Reports tab.
Enter Balance Sheet on the Search bar, then choose which report you’d like to run.
Set the report period from November 1st to October 31st.
Click Run report.

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:

Go to the Gear icon and select Accounts and Settings.
Select the Advanced tab and click on the Accounting section.
Choose November for the first month of fiscal year option.
Tap Save, and then Done.

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!

Sign up

Login with SSO

Let's get you signed in

Login with SSO