When manually entering sales transactions such as Invoices, Sales Orders or Sales Receipts into QuickBooks we let QuickBooks calculate the total amount of the sales tax based upon the taxable status of the item and customer and the sales tax item. QuickBooks calculates the amount on the sales transaction behind the scenes and then posts this amount in the footer of the transaction. However, often items when importing sales transactions from e-commerce platforms or shopping carts the sales tax … [Read more...]
It’s The Time of Year to Change Sales Tax Rates in QuickBooks
I have seen many articles and posts on social media on how to most effectively handle changes in sales tax rates in QuickBooks. I am not a sales tax expert but based on this article on AccountingWeb site by Jody Linick it looks like you are safer replacing the sales tax rates in QuickBooks and not editing them. Since it appears that quite a few states are changing their sales tax rates effecting January 1, I just wanted to let user of QuickBooks Desktop (Pro, Premier or … [Read more...]
How to Import Sales Tax on your Sales and Purchase Transaction in QuickBooks Online
If you are using QuickBooks Online and our Transaction Pro Importer you can easily include sales tax on your sales and purchase transactions. We have a free thirty day trial available here. The fields are a little different depending on if your QuickBooks Online company is a US based business or not so please be sure to review the appropriate screen shots below. The sales tax fields are available on the following transaction types: Bills (non US companies only) Checks (non US … [Read more...]
How to import Sales Tax into QuickBooks on your transaction imports
Tracking sales tax in QuickBooks can be cumbersome so that is why we have at least three ways that you can use Transaction Pro Importer 5.0 to accurately reflect your sales tax. Below we will discuss the various options. Option 1: Let QuickBooks calculate the tax for you. If you already have the customers and items set up in your QuickBooks company file no need to map any data to the QuickBooks fields, Sales Tax Item and Sales Tax Code, as Transaction Pro Importer 5.o will record the … [Read more...]
Invoice, Sales Orders and Sales Receipt Imports into QuickBooks eCommerce Features
Newer article can be found here. On the options screen within Transaction Pro Importer for QuickBooks you will see an e-Commerce tab. This blog post will address what this option can be used for. When importing invoices, sales orders or sales receipt transactions, often times shopping carts will create an export that has the amounts for shipping, handling, discounts and sales tax in separate columns instead of its own line item. Please refer to the sample import file below. If … [Read more...]
Transaction Pro Importer – Upgrading from QuickBooks UK 2005 / 2006 to 2008 / 2010
Intuit has sent out a final reminder that all services and support for QuickBooks 2006 (United Kingdom Edition) will be discontinued as of September 30, 2010. If you are a current user of Transaction Pro Importer from Baystate Consulting, you may benefit from these upgrade tips: Transaction Pro Importer 4.0 Required Be sure you are running the latest release of Transaction Pro Importer 4.0. You can do this by clicking About/Check for Updates. If you are on an earlier major version … [Read more...]
Importing Sales Tax Totals on Invoices and Sales Receipts using Transaction Pro Importer for QuickBooks
Importing sales tax entries into QuickBooks on invoices and sales receipts can be a challenge. This can be even more difficult if your import file does not contain the sales tax code and the sales tax item. So what do you do if you import file only has the total sales tax amount in its own column? If you follow the steps below you can import your transactions with Transaction Pro Importer 4.0 with no changes needed to your import file. How to map total sales tax in TPI 4.0/5.0 … [Read more...]