bvstone

QuickBooks Online - Subtotals and Discounts Frustration

Posted:

QuickBooks Online - Subtotals and Discounts Frustration

One issue that really has me frustrated is how QuickBooks Online (QBO) treats discounts and subtotals when compared to QuickBooks Desktop (QBD), or really any accounting software I have found.

The first issue is how discounts are applied.  This is discussed in a previous article, but the main point is instead of percentages, you have to use what seems like a "quick and dirty" fix of using a negative decimal for a discount percentage.

And that leads us to what appears to be an unintended consequence of this... how subtotals, especially subtotal groups that follow a discount (or discount group).  Let's take a look:

Product Description Qty Rate Amount
ItemA Item A 1 50 50
ItemB Item B 50

50

  Subtotal     100
  Discount 100 -0.10 -10
         
ItemA Item A  50 50
ItemB Item B 1 50 50
  Subtotal     90

A quick looks appears to be ok, but if we look at the second subtotal it's obvious that it's including the 10 discount from the previous subtotal group.  I've never seen accounting software be this "basic" and not treat the second subtotal group as it's own, ignoring any previous subtotals and/or discounts.

So, if you were to issue a discount for the second group you would need to make sure you entered "100" for the Qty and not "90", which is what it says the subtotal is.  To me, this is completely ridiculous.  I doubt there will ever be a fix because when I actually got to speak to someone (in a chat and sharing my QBO session) they were saying that the subtotal IS correct.  Well, maybe mathematically going down the column it is, but in the accounting world I am betting that this would be a big issue for most.  If not, I am happy to hear arguments as to why not.

What I would like is not a change in how it works, but a setting that says "include discounts in subsequent subtotals" or not.  It can be turned on by default so the behavior is the how it is now, but for those of us that have for years expected discounts are NOT included in any following subtotals, that would be great.

The only other way I've found to stop this from happening is putting another subtotal line after the first discount.  That seems to fix it, but again, it looks weird to myself and the customer as well.

I guess what I am asking is that if Inuit is forcing us to QBO, at least make if function like QBD did.

 


Last edited 03/16/2023 at 09:01:13



Latest Posts:

QuickBooks Online - Subtotals and Discounts Frustration QuickBooks Online - Subtotals and Discounts Frustration
Posted by March 16, 2023
QuickBooks >> QuickBooks Online
Making the Switch From QuickBooks Desktop to QuickBooks Online - No Picnic Making the Switch From QuickBooks Desktop to QuickBooks Online - No Picnic
Posted by March 16, 2023
QuickBooks >> QuickBooks Online
BVSTools Software Verified on V7R5 and Power10 BVSTools Software Verified on V7R5 and Power10
Posted by December 9, 2022
BVSTools >> BVSTools Announcements
Microsoft Office 365 Servers and Random Errors Issue Microsoft Office 365 Servers and Random Errors Issue
Posted by November 14, 2022
BVSTools >> BVSTools Software Discussion >> Email Tools (MAILTOOL) Specific Discussion
Sending/Resending Emails Using a MIME File with MAILTOOL Sending/Resending Emails Using a MIME File with MAILTOOL
Posted by November 8, 2022
BVSTools >> BVSTools Software Discussion >> Email Tools (MAILTOOL) Specific Discussion
Sending an HTML Email on Your IBM i Using MAILTOOL Sending an HTML Email on Your IBM i Using MAILTOOL
Posted by November 1, 2022
BVSTools >> BVSTools Software Discussion >> Email Tools (MAILTOOL) Specific Discussion
Transferring License Keys from One System to Another Transferring License Keys from One System to Another
Posted by October 31, 2022
BVSTools >> BVSTools Software Discussion
Calculating the Size of a File Before Base64 Encoding Calculating the Size of a File Before Base64 Encoding
Posted by August 13, 2022
Programming >> RPG Programming
GreenTools for Microsoft Apps (G4MS) v9.12 Now Includes Function to Send Emails using MIME File GreenTools for Microsoft Apps (G4MS) v9.12 Now Includes Function to Send Emails using MIME File
Posted by August 11, 2022
BVSTools >> BVSTools Announcements >> GreenTools for Microsoft Apps (G4MS) Specific Announcements
GreenTools for Google Apps (G4G) v15.20 Now Supports Shortcuts GreenTools for Google Apps (G4G) v15.20 Now Supports Shortcuts
Posted by August 6, 2022
BVSTools >> BVSTools Announcements >> GreenTools for G Suite (Google Apps) (G4G) Specific Announcements
GreenTools for Microsoft Apps (G4MS) Groups Admin Authority Instructions GreenTools for Microsoft Apps (G4MS) Groups Admin Authority Instructions
Posted by July 26, 2022
BVSTools >> BVSTools Software Discussion >> GreenTools for Microsoft Apps (G4MS) Specific Discussion
GreenTools for Microsoft Apps (G4MS) v9.10 Now Includes OneDrive Functions that Work With Groups/Shared Drives GreenTools for Microsoft Apps (G4MS) v9.10 Now Includes OneDrive Functions that Work With Groups/Shared Drives
Posted by July 19, 2022
BVSTools >> BVSTools Announcements >> GreenTools for Microsoft Apps (G4MS) Specific Announcements
GreenTools for Google Apps (G4G) v15.10 Now Includes Drive Functions that Work With Shared Drives GreenTools for Google Apps (G4G) v15.10 Now Includes Drive Functions that Work With Shared Drives
Posted by July 15, 2022
BVSTools >> BVSTools Announcements >> GreenTools for G Suite (Google Apps) (G4G) Specific Announcements
GreenTools for Microsoft Apps (G4MS) v9.00 Now Offers Functions to Bypass Registration Command and BVSTools Landing Page GreenTools for Microsoft Apps (G4MS) v9.00 Now Offers Functions to Bypass Registration Command and BVSTools Landing Page
Posted by July 4, 2022
BVSTools >> BVSTools Announcements >> GreenTools for Microsoft Apps (G4MS) Specific Announcements
What Objects Should I Omit from Replication to Ensure My License Keys Work on my HA/DR System? What Objects Should I Omit from Replication to Ensure My License Keys Work on my HA/DR System?
Posted by June 27, 2022
BVSTools >> BVSTools Software Discussion

Reply




Copyright 1983-2020 BVSTools
GreenBoard(v3) Powered by the eRPG SDK, MAILTOOL Plus!, GreenTools for Google Apps, jQuery, jQuery UI, BlockUI, CKEditor and running on the IBM i (AKA AS/400, iSeries, System i).