From time to time, sales for new or custom products may end up in the generic 4000 sales income account. This article walks through the steps to correct this.
Article Navigation:
In Reporting —> Chart of Accounts, navigate to the 4000 sales account. Click into the account and then select the time period in question. Select export and choose the transactions with line items export.
This will produce a report showing all of the sale descriptions that ended up in 4000 sales bucket. From the interface you can also open up any transaction and see the line item descriptions for each one.
It is important to make sure that any unmapped products are mapped so that the same items do not continue to be credited to 4000 sales. To help with this you will see both a product ID and url to identify and map the products for each line of this export. If it does not have a product ID, that means that it was rung up as a custom item.
Select the url for the given products to ensure that you can apply the appropriate income accounts on those items going forward.
You will need to create a correcting journal entry to move any funds from 4000 sales to the appropriate income account. Using the data from the export, enter a journal entry into Quickbooks to move the sales in the 4000 sales account to the desired income account.
Though not required, you can also create the correcting journal entry in Clubspot. If you do, please note that it will sync that entry to quickbooks if using quickbooks online. If using quickbooks desktop we would recommend only making this correction in your QBD account.
<aside> 💡 If you have a large number of line items falling into the 4000 sales account it might make sense to consolidate these using a pivot table. Start by sorting the data to only include the line item names, then insert a pivot table with the product id or description as the columns and the credit amount (if there are credits and debits you may want to sum these) as the values.
</aside>