How to record sales tax refund check from Tax Agency in QuickBooks Online

I’ve not seen a single article from QuickBooks Help related to this subject on how to record Sales Tax refund check in QuickBooks Online. Most of the answers found don’t work or whoever answered the questions does not fully understand how Sales Tax Center is so limited to making any credit/refund adjustments. It’s not clear this functionality is even available in QBO.

What I found as a workaround is to create a Sales Receipt in QBO. Ths assumes negative balance is already shown in Sales Tax Center. In other words, you’re expecting this refund from the Tax Agency.

These are the steps to follow in creating a Sales Receipt:

  1. For Customer field, create a new one (example zSales Tax Adjustment) or leave it blank still works.
  2. Select deposit to bank account.
  3. Select same Products/Services items, one as a taxable item and another one non-taxable item.
  4. With taxable sales item, it should compute sales tax refund amount at the bottom. In this example shown in the screenshot below, taxable sales amount is $21,750, the tax rate is 8% and received $1,740 refund from Tax Agency.

How to change transaction numbers like invoice number sequence

Transaction reference numbers help you easily identify transactions. QBO will automatically assign transaction numbers in sequence. But if you want to change the starting custom transaction number of your own, you can do so. You would want to turn the company settings ON once, assign a custom number and turn it OFF again so that QBO can identify number sequence based on the last transaction number.

A separate number sequence appears on:

  • Invoices, sales receipts, refund receipts, and credit memos
  • Delayed charges and Delayed credits
  • Estimates
  • Purchase orders

For Statements, QBO will automatically control the numbers that reference identify so you can’t change it.

QBO lets you customize your transaction numbers.

How do custom transaction numbers work?
When you turn ON custom transaction numbers:

  • You can change transaction numbers when you create or modify a transaction.
  • Transaction numbers can include letters (such as 2017-1001).
  • New transactions get new numbers (such as 2017-1002), based on the last transaction. You’ll be warned if you try to enter a duplicate transaction number.

When you turn OFF custom transaction numbers:

  • Transaction numbers are never changeable, even numbers created with custom transaction numbers on.
  • Transaction numbers are assigned when transactions are created.
  • Transaction numbers are sequential, based on the last number, starting at 1.

To turn custom transaction numbers ON or OFF from the company settings:

Click the Gear icon at the upper right corner > Your Company > Account and Settings).

 

For customer transaction numbers on sales forms:

Click “Sales” on the left, and then click the edit icon for “Sales form content”. Select the “Custom transaction numbers” checkbox, and click Save.

 

For custom numbers on purchase orders:

Click Expenses on the left, and then click the edit icon for Purchase orders. Click the “Use purchase orders” checkbox. Select the “Custom transaction numbers” checkbox, and click Save.

 

To reset your transaction numbers again:

  • Select the Custom transaction numbers checkbox, and click Save
  • Create a transaction with a new starting number.
  • Clear the Custom transaction numbers checkbox, and click Save.

 





 





QuickBooks Online - Buy now and save 50%



FREE Trial
USA
CANADA

XERO - Alternative to QuickBooks

SAGE 50 Accounting

Limited Time Offer—Save Up To 37% On Sage 50 Accounting Software!

SOURCE

Click here for the blog article.

Step-by-Step Guidance: create sales receipt template with bundle and enter daily sales summary

In this free video tutorial, you will learn step-by-step instructions on how to create sales receipt template using bundle feature and also how to enter daily sales summary using that template. This video tutorial is specifically designed for retail, service and restaurant businesses. If you’re a bookkeeper or office staff whose job tasks include entering daily sales summary into QuickBooks, this is the video you must watch. Watch this video in its entirety and you will know how to handle daily sales summary the right away.









How to track donated inventory stock items by your business in QuickBooks

These are the specific steps you can follow in QuickBooks Online (available in plus plan only) if you are donating or giving away tracked quantity on hand inventory items.

Create ZERO Value Sales Receipt for Inventory Items:
1. From the Home Page screen > click Create (+) Sign (top middle bar) > Customers > Sales Receipt and create a Sales Receipt for the inventory item.
2. Choose a customer (name of donating company). Add new if needed.
3. Select Item Donation as your Payment Method. Add new if needed. Optional.
4. For “Deposit to” field, select Add new and create bank category type account. Name it clearing account. (This will create just a zero dollar transaction. You would not have any actual banking transactions in this bank register).

Screenshot 2016-07-17 16.03.31

 

5. In the Product/Service column, click the drop-down arrow to select the product/service you are donating.
6. Change the Rate of the selected product/service to zero so that the total of the sales receipt is zero.
7. Click Save.

Screenshot 2016-07-17 16.01.32

 

8. Click “More” at the bottom. Select Transaction Journal report. This will give you the original cost of the inventory items you are donating. Print as PDF or select export to excel. Do the same for the Sales Receipt.

Screenshot 2016-07-17 16.01.58

Screenshot 2016-07-17 16.02.07

 

Next, to account for the original cost of the product/service(s) selected, create a Journal Entry to move the cost out of the Cost of Goods Sold account and into the appropriate expense account (for example, Charitable Donations Expense).

To record this:
1. Click Create (+) sign > Other > Journal Entry.
2. In the Account section, choose the expense account used to track charitable contributions (for example, Charitable Donations Expense).

Screenshot 2016-07-17 16.03.09

 

3. Enter the cost of the product/service in the Debit field.
4. On the next line, click the drop-down arrow and select the Cost of Goods Sold (COGS) account for the donation.
5. The cost of the product/service entered in the field above will populate the Credit field.
6. Click Save.
7. Optional. Attachments (bottom left) for the record. Attach Transaction Journal (that gives you how you got the cost of the donated items) and Sales Receipt.

Screenshot 2016-07-17 16.00.01

Screenshot 2016-07-17 15.59.39
 

Our YouTube Tutorial Video: How to track donated inventory stock items by your business in QuickBooks

 

Is there a way to create a sales receipt from an estimate

QBO is not set up to go from Estimate to Sales Receipt at this time. Currently, you create Estimate and then “copy estimate to invoice” to create an Invoice. There is no partial copy so it’s done just one-time. You receive payment against that invoice.

Workaround steps from Estimate to Invoice may also work as faster as creating from Estimate to Sales Receipt approach. Follow these steps, it may work as an alternative to Estimate to Sales Receipt.

1. Create Estimate (create + sign > customers > estimate)
estimate1
 
2. Copy to Invoice (either directly from estimate or from invoice form by selecting a customer)
invoice1
 
3. Select “Save” (bottom right, blue bottom) Invoice
invoice2
 
4. Once saved the invoice, you will promptly notice “Receive Payment” button added at the upper right corner. Click “Receive Payment” link.
invoice3
 
5. Receive Payment against the invoice. Done.
invoice4
 

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!








2015 Laser 1099-MISC Income, Federal Copy A, Bulk

2015 Laser 1099-MISC Income, Federal Copy A, Bulk


Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada