Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there, @weberhvac13.
Welcome to the Community. I'm here to share some insights on why your income on your Profit & Loss doesn't match with your gross sales.
The total sales and total income will not always match because there are transactions that can appear in a data file that will make it unlikely for the Sales Tax Liability and Profit and Loss reports to match. You can compare the two reports to see which transactions are causing the discrepancies.
To fix the problem, compare the details of the totals by running the Sales Tax Liability report and the Profit & Loss report.
To do that:
Once done, run the Profit & Loss report and do the same process. If the issue persists, I'd suggest giving our Customer Care Team a call. They have necessary tools such as screen sharing that will help you figure this out.
To reach them:
This should get you on the right track. Please let me know if you have any other questions. I'd be happy to lend a hand.
I have my square synced to my QuickBooks. All the payments filter through that, is that a reason for my profit And loss and sales tax to be off?? My reports are not the same, as far as gross totals. Not sure what’s happening! Do these directions Apple to my situation?
I can only imagine the hurdle you've been through with your profit and loss report and sales tax concern, @Sweetlymade. I'll be here to help you resolve this calculation issue.
To address your sales tax concern, you can add up all of the sales that should have been subject to sales tax. After that, let’s do the math to figure out how much sales tax is due. Please take note that you’ll need to add your sales tax rate as a decimal to one.
Here’s a sample computation:
If your sales tax rate is 8.25%, that is .0825 plus one is 1.0825. Next, divide the amount of the sale by that amount and multiply it to 100 (i.e., $100/1.0825 x 100 = $92.16). Then, take the sale amount and subtract the answer to get the amount of sales tax included (100-92.16 = 7.84).
Once done, you’ll have to create a Sales Tax Due account in your journal. From there, you can move the amount from income to a liability by debiting the income and crediting the sales tax due.
When you pay sales tax, use the sales tax adjustment. You can set the adjusting account to the sales tax due liability account and enter the amount as an increase. Then, pay the total sales tax due.
I'm adding this guide to help you manage sales tax payments in QuickBooks Online. It includes the troubleshooting steps you can perform if you encounter sales tax payment issues.
I’m always here to back you up if you need further help on managing you profit and loss report, including your sales tax, or any QuickBooks-related in general. Just leave a reply to this thread and I’ll get back to you.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here