Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
We use an ERP to integrate our invoices to QB, once we sync our ERP with QB sometimes the taxes do not follow. The taxes will need to be entered on a separate supplier invoice manually entered in QB. So here is our issue.
We enter in z on the amount line but still say yes to the tax on the zero line, then add the total mount of taxes missing from the original invoice.
We will not pay both invoice to equal to total amount, but once complete a marked as pay taxes will still show up in the A/P as unpaid. How do we fix this from continuing to happen, if taxes have been missed on future invoices.
Hi there, Jaime. QuickBooks Desktop can only record the information that ERP sends over during the sync. If the ERP sends the bills with zero tax, QuickBooks will import them exactly as provided.
If the tax amounts are missing or coming in incorrectly, the best way to handle this is to contact the ERP support team to review how taxes are being mapped and transmitted to QuickBooks. Once the ERP sends the correct tax values, QuickBooks will bring them in automatically, and you won't need to create manual adjustments.
If the ERP is designed to send the transactions with zero tax, then entering the tax manually in QuickBooks after the import is the correct approach.
If you have follow-up questions, please don't hesitate to click the Reply button.
The issues isn't the taxes not coming through, its the payment of the taxes. We pay the taxes as part of the total payment run, but once paid and reconciled it will still show up on the A/P report as unpaid, it there a way yo enter in the taxes in QB to avoid this?
We have tried a few different way to enter and it either ends up in error message, and your shouldn't do this message or still stays on A/P report.
Thank you for the clarification, Jaime. The tax payments that appear as unpaid were likely entered as standard bills or checks. QuickBooks tracks sales tax through a specialized liability account. If these payments were recorded as regular vendor bills, the system wouldn’t recognize that the specific tax obligation has been satisfied.
We can use the specialized sales tax feature by first deleting or voiding the previous payment. Go to your bank register, find the payment, and delete it to return the liability to the sales tax center. Before doing this, I recommend consulting with your accountant, as adjustments might affect your reconciled books, which can lead to discrepancies.
After that navigate to Vendors > Sales Tax > Pay Sales Tax, ensuring you select the correct bank account and the actual payment date. Set the Show sales tax due through date to the end of the tax period, check the box for the specific tax item, and click OK to record the transaction and clear it from your A/P report.
If you still need further assistance, please don't hesitate to leave a post below.
Thank you for this information. Yes that would be true if we were putting the amount in the body or amount line of the invoice but we are not doing this.
We are entering the taxes on the tax line, the amount line is zero but we manually change the tax to represent the correct taxes of the invoice if missed on the original invoice.
We find doing it this way the taxes show up in the appropriate account for payment, but will stay unpaid the in the A/P report.
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