You can configure CoreBridge to have your sales tax liability post to the default Sales Tax Payable account in QuickBooks. When you choose the default account, you must maintain the associated setting on the Sync Tool. If the vendor name changes in QuickBooks the associated field on the Sync Tool must be updated.
If you want to use the default Sales Tax Payable account in QuickBooks when importing IIF files, please reach out to firstname.lastname@example.org.
NOTE: This article only applies to users utilizing a Lump Sync to QuickBooks Desktop via the CoreBridge Desktop Sync tool. Before making any changes, if you have questions regarding general accounting practices or QuickBooks, you should consult with your accountant before proceeding.
When you use the default sales tax payable account with Lump Sync, the selected tax vendor will be associated with the tax line item on a journal entry. Only a single vendor can be used. If you pay tax to multiple agencies/vendors, you may not want to use this option.
- Identify your default Sales Tax Payable G/L account in QuickBooks
- The default account can be confirmed if the Account Type is grayed out.
- Identify your tax vendor in QuickBooks.
- In CoreBridge, go to Accounting > Accounting Export > Account Setup.
- In the section titled My Accounting Software Accounts, edit and save the GL Code and Account Names for each relevant tax agency, matching to your Sales Tax Payable account in QuickBooks (identified in Step 1).
- Open the CoreBridge Desktop Sync tool and go to Settings > Settings.
- Enter your tax vendor (from Step 2) in the "Vendor Name To Use" field. Click Save & Validate Settings.
- The next CoreBridge Reconciliation you sync to QuickBooks that contains sales tax liability will utilize the account you mapped in Step 4. If you receive errors when you sync, double-check that you properly matched up the accounts in Step 4 and the vendor name in Step 6.
- This is what the journal entry will look like.
If your Sales Tax Payable account has a balance from existing transactions, you may want to assign CoreBridge tax to a Vendor that is not currently the same Vendor used on existing transactions. That will help you distinguish CoreBridge tax from existing tax in QuickBooks when using the Sales Tax Liability Report and the Pay Sales Tax window. These are the results from using a vendor named "Tax Vendor Name".
- Pay Sales Tax window
- Sales Tax Liability Report
You will not be paying this fake vendor. This is just a means of separating your CoreBridge tax. When you pay your tax, you will remit the CoreBridge amount along with any other amounts to the proper taxing entity. In this example, you will have a line on your tax payment for $15.00 assigned to your Sales Tax Payable account.
On the Sales Tax Liability report, there are no sales because that report is designed to be used with individual invoices in QuickBooks. Since Lump Sync gives you journal entries and not individual invoices, that report cannot associate the tax to the related invoice to give you a sales amount.