QuickBooks & FreshBooks – Part 3 – Sales Tax

Part 3: Handling Sales Tax

QuickBooks is an accounting application and FreshBooks is an invoicing application. They are two different things, but in the end to have your data matching in both, there could be a ton of double entry resulting in valuable time consumed and strenuous effort.

You can have your data accurate in both, while not matching in both. Matching and accuracy are two different things. For all of the numbers to match up, it is a matter of accuracy. To have all of the details such as sales items etc. it would be a matter of matching.

In this blog post, I will begin to show you ways to get accurate data from FreshBooks into QuickBooks.

This blog post is Part 3, if you have not read the previous posts, I suggest that you do:

Part 1: Methods 1 & 2 to getting FreshBooks Income into QuickBooks

Part 2: Method 3 to getting FreshBooks Income into QuickBooks

Also useful, is my post: Handling Credit Card and PayPal Processing Fees in QuickBooks, which has a short segment relating to FreshBooks as well.

On to the good stuff!

So, you have your income or receivables in QuickBooks, you may have even taken out your PayPal or Merchant Processing Fees. However, you don’t have your sales tax anywhere, as a matter of fact, it is showing as an Income and we all know your Sales Tax is NOT an income.

Well let’s correct that, shall we?

Just to recap… if you charge sales tax, your sales tax is included in the numbers that you entered from FreshBooks, so it is very important that you remove your sales tax from your revenue/income accounts and allocate it to your sales tax payable account.

1. Go into your FreshBooks Account

2. Click on the Reports Tab

3. Click on the Tax Summary Report in the first column

4. Select the month in Question that you want to enter.

5. In the Revenue section, you have to pick either Billed (Accrual) or Collected (Cash Based) – the choice you pick will be determined by the income entering method you have elected to use (based on previous posts). If you selected Methods 1 or 2 where you are accounting for your receivables you will select the Billed (Accrual) method. If you selected Method 3 where you are only accounting for your payments received you will select the Collected (Cash Based) method.

6. Once you have the amount/totals from your report (sorry I can’t give you a screen shot, I don’t have sales tax inside of my company) go into QuickBooks, select Company from the file menu and Make Journal Entries.

7. Enter the end date of the month you have pulled your sales tax details for.

8. In the first row from the account drop down box, pick your Income Account (mine is IAC Professionals Service Revenue), tab over to the debit column and enter the total of your sales tax from your sales tax report.

9. In the second row from the account drop down box, pick your Sales Tax Payable account (this should always be Sales Tax Payable) and in the credit column enter the total of your sales tax from your sales tax report. In this row you will also need to enter the name of your Taxing Agency in the Name Column. If it is not yet in your Vendor List, click Add New and create it. For example, mine would be State of Florida Sales Tax Department.

10. Press Save and Close

This has removed the actual sales tax portion of your revenue, out of your revenue and into your sales tax liability account, enabling you to use the ‘Pay Sales Tax’ feature inside of QuickBooks.

Do you have any questions or specific circumstances that I did not help you with? Feel free to comment on the post with your question(s) and I will respond personally!