Question

QB Desktop - P&L Report - showing a (\n) as part of the COA Description

Forum|Forum|6 years ago
April 9, 2020
1 reply
2 views

Hi all

I recently implemented a numbers for all my COA (stating as this may be part of the problem). Now, one of my accounts is showing an (\n) along with the account number - description for example

when I run a P&L - one of the sections Wages, for example, shows this 6650 - Wages (\n). instead of just 6650 - Wages..... Is anyone familiar with this. It also, looks like it is not calculating, totaling, the amounts correctly for Cash, but the total is fine on an accrual basis - so it's receiving all of the data.

regards

mary

QuickBooks Desktop

Lily_Kristine

Moderator

It's nice to see you again in the Community, Mary.

I've got some information I'm sure you'll find helpful regarding the data showing on your P&L report.

Your account list may be corrupted that's why you're seeing odd behavior in your Chart of Accounts list. You can easily fix this using the Re-sort lists feature in QuickBooks Desktop.

Here's how:

Go to Lists menu then click Chart of Accounts.
Be sure that all accounts are included by selecting the Show Inactive Accounts. Just click the drop-down arrow for Account to show this option.
Select Re-sort List.
Select OK on the Are you sure you want to return this list to its original order? prompt.

You can also do this to other lists such as customers, vendors, employees, and others. You can check this article for more information: Re-sort lists.

Doing this will restore the accounts to its proper order and show the correct amounts for wages.

Please feel free to reach out to us here with all of your questions and concerns, I'm determined to ensure your success. Thanks for coming to the Community, best wishes.

C

Ceasar66Author

Good morning and thanks for the reply!

I spent a good part of yesterday picking apart the data (fun :) ). It seems like my issue is the following when one compares a Cash versus and Accrual P&L report:
1) If you enter a bill, with multiple line items (different GL accounts), through invoices and pay it in FULL in the same month you will see no difference on line items in the P&L reports between a cash and accrual; However, if you do the same as 1) and only pay a PARTIAL amount of the invoice, the amount that wasn't paid will be deducted or allocated (I think pro-rata) among all of the GL accounts that were hit on the invoice. This leads to some visual inconsistencies on a cash P&L report - for example say you had:

a) an invoice for $100 that was split into 3 different GL accounts ($75 - wages, $20- health care, $5 -dental);

b) you paid $95 towards the invoice - the $5 that wasn't paid get's deducted across all GL accounts within the invoice - which make sense in the long run because you are not choosing which line items get paid.

So, it's the report isn't really totaling incorrectly. It's the way that some things, invoices with multiple GL accounts - w/o using classes, need to be entered differently so that that can't happen!

Mary

Sign up

Login with SSO

Let's get you signed in

Login with SSO