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.
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.
<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>
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 may want to also move those transactions in Clubspot as well. If you choose to do this make sure that you back date your journal entry so that it does not sync to Quickbooks on the next nightly sync as you would have already made the correction there.