Skip to main content

Troubleshooting Failed Journal Entry Postings Due to Unmapped Tax Rates – for Canadian QuickBooks Online Users

Bookkeep posts automated journal entries to your accounting platform daily when you have the journal entries template turned ON.

For select connectors (Shopify, Square, Squarespace), we allow users to map individual tax rates to match the tax rates in QuickBooks Online so filing for sales tax can be done accurately. This means that each individual tax rate will need to be fully mapped in your Sales Summary template for the journal entry to successfully post. As these tax rates can be added at any time based on your tax nexus (i.e., you might sell today to a brand-new jurisdiction you had no sales before), you will need to actively monitor this and add all new tax rates captured in your ecommerce app to your QuickBooks Online tax rates.

Common Issues and Fixes​

Unmapped Tax Rates​

Issue​

Any days where your system captured a new, unmapped tax rate will show as "FAILED" in your activity log and will display an error message stating "Please balance debits and credits," as seen below:

Screenshot showing a failed entry due to unmapped tax rates

Fix​

Go to Connections -- Apps -- Setup (for the relevant connected App) -- then click Map for the Sales Summary template to open the mapping view.

Screenshot showing the mapping view for the Sales Summary template

Click on the blue down arrow on the right-hand side of the "Sales Tax Collected" field to expand the view, revealing the different tax rates captured. Map any new un-mapped tax rates from the drop-down menu for each tax rate

Screenshot showing the expanded view for mapping tax rates

note

If your tax rate does not display in the drop-down menu for mapping, you will need to go to QuickBooks Online and create the correct tax rate there first. Then, return to your Bookkeep dashboard, go to Connections -- Accounting and click "Refresh" to update your Bookkeep connection with the new changes (see below). After refreshing, you can head back to the App mapping and complete the process for any missing, newly created tax rates.

Screenshot showing the refresh process in Bookkeep

Once the mapping has been completed, these changes will apply to all journal entries posted moving forward. To post any failed entries, head over to the activity tab and click "Post" to correct any "Failed" entries that remain in the log.

If you need any help with completing your journal entry posting, please feel free to contact us!