thinkQuickBooks

helping right brain professionals navigate the left brain world of accounting

Archive for the tag “Customers”

How to change product and service prices in QBO

Question: I recently increased my prices. Right now, I have to remember to change them every time I create an invoice. Is there a way to make the new prices stick?

Answer: There is, and it can be done in three simple steps. Here’s what to do:

1. Click on the gear menu in the upper right hand corner. Then choose Products and Services from the Lists column.How_to_update_prices

2. Click on Edit to the far right of the item you’d like to update.Edit_button

3. Enter your new Sales price/rate. This does not affect any existing transactions, only new ones. Click Save and close.Update_price

Now when you create an invoice or other sales transaction, the new price will show up on your form.

How the Print later feature works in QBO

Today I searched like crazy for the Print later box while creating an invoice in QBO. I double checked my Company Settings to make sure that my preferred delivery method was Print later. It was. But all I could see was the Send later box at the top of the invoice. After some exploring, I finally found the Print later box. Click on the Print or Preview option at the bottom of the invoice, and you’ll see a check mark box:

Blog_post_capture_II

HOW TO BATCH PRINT IN QBO

Once I had confirmed that my invoices were selected to be printed later, I went to find the print queue. But there isn’t one! Well, at least not like there is in desktop. Here’s how this functions in QBO. I’m using Chrome which is the preferred QBO browser.

First, go to Transactions on the left hand navigation bar. From the drop down menu, choose Sales. Click Filter. Choose Invoices for Type and Print later for Delivery Method. Click Apply.

Blog_post_capture_V

This will show you all the invoices in your print queue. Simply choose the invoices you’d like to print by checking them off and selecting Print transactions from the Batch actions drop down menu.

Blog_post_capture_VII

Your invoices will open in another Google tab (all of them in the one tab – scroll down to view). Right click to select Print, choose your printer, then click on Print. When you click back over to QBO, notice the following screen. If everything has printed correctly, select Yes. To leave them in the queue, select No.

Blog post capture

HOW TO GET RID OF INVOICES YOU DON’T WANT TO PRINT

Use this same method to remove invoices from the queue you don’t intend to print. Choose the invoices you want removed from the queue by checking them off. Choose Print transactions from the Batch actions. The invoices will open in another Google tab, just like in the previous example. Instead of printing, you’re going to close the tab that just opened. This takes you back to QBO and the message that appears in the screenshot above. You will be asked if you want to mark the selected transactions as printed. Say Yes. Your print queue should now be empty.

The nice thing about doing this in QBO (as opposed to desktop) is that you don’t have to ‘cheat’ printing the invoices to a PDF file. Note that this also works with sales receipts and expense transactions.

QuickBooks and the Case of the Disappearing Penny!

When I was a little girl, my dad used to buy a bag of uncirculated pennies every year and stow them in a secret hiding place in our home. Not sure what ever became of those pennies, but he sure collected a lot of them. This likely inspired my fondness for coins. I have a tiny collection of my own, and to this day, I’m often treasure hunting my loose change. Also when I was little, I couldn’t get enough of the Encyclopedia Brown novels. Solving those tricky mysteries kept me busy on many a dreary winter day. For Leroy Brown, no case was too small, and so, I’d like to offer you my rounding workarounds in QuickBooks and the Case of the Disappearing Penny!

On February 4th, the Royal Canadian Mint will stop distributing the one-cent coin to Canadian banks, and Canadian businesses will be “encouraged” to begin rounding cash transactions to the nearest nickel.  Apparently, “encouraged” means when “pennies aren’t available.” We’ll soon see how business will interpret this change. In any case, all debit card, cheque, and credit card transactions will continue to be processed at their exact amount. No rounding here. It’s when cold, hard CASH is involved that things will be different. If your cash transaction ends in one, two, six, or seven cents, you round down. If your cash transaction ends in three, four, eight or nine cents, you round up. Fear not…the government isn’t trying to scam you and there’s no effect on GST/HST. It’s simply a rounding issue. Check out this informative article from the Department of Finance for more information: http://www.fin.gc.ca/1cent/index-eng.asp

PennyGraph01_e

So – does your POS provider have this all figured out? What about your financial software? I personally don’t have a lot of clients that deal in cash outside of a POS system, so I’m counting on those POS guys to figure this out! But for those of you who use QuickBooks and need to know what to do, here are some ideas that I’ve come up with. I welcome your comments and other workarounds. (Just don’t be all Bugs Meany about it!)

But first, a humble plea to the Intuit programmers. Someone at Intuit needs to implement a ROUNDING button so I don’t have to work so hard! LOL! However, I don’t think that’s in the cards just yet. Perhaps one day. In the meantime, here are my:

DISAPPEARING PENNY WORKAROUNDS

Complete these two simple steps and you’ll be all set up for rounding, up and down, on sales and purchases.

STEP ONE

You’re going to need a new EXPENSE ACCOUNT on your chart of accounts. Go ahead and set up an “Other Expense” account called ROUNDING.

Rounding Other Expense

STEP TWO

You’re going to need a new two-sided ITEM called ROUNDING. Set it up as an “Other Charge” item and point it to the ROUNDING expense account on both sides.

Rounding Item

PART I. SALES

OPTION ONE – ROUNDING AT THE BANKING LEVEL

Whether you issue an INVOICE or a SALES RECEIPT, rounding will always be done    in the MAKE DEPOSITS window. Do not adjust for rounding on the sales forms themselves, only in the MAKE DEPOSITS window. Here are the examples:

INVOICE

To receive payment on an Invoice and account for rounding, create Invoice and Receive Payment as you normally would. Make sure you ‘DEPOSIT TO’ the UNDEPOSITED FUNDS account (if you deposit straight to the CASH account, you won’t be able to adjust for rounding).

Inv to UFpng

Choose “MAKE DEPOSITS” from the Banking menu, select the correct payment(s), and adjust for rounding:

Make Deposit Round Down Invoice

SALES RECEIPT

To adjust for rounding on a Sales Receipt, create Sales Receipt as you normally would. In the DEPOSIT TO window, you can choose either the CASH account or UNDEPOSITED FUNDS. I will use the UNDEPOSITED FUNDS account for this example, to be consistent:

Bobby Jones Cash SR

Choose “MAKE DEPOSITS” from the Banking menu, select the correct payment(s), and adjust for rounding:

Bobby Jones Dep round up

NOTE: For Sales Receipts only, you can choose to DEPOSIT TO your CASH account. The only difference here is that next step won’t be to MAKE DEPOSITS, as the deposit is already entered. Find the deposit and edit for rounding.

What is key to remember is that you will always adjust for rounding in the MAKE DEPOSITS window.

PROS: The above method of rounding is easily handled at the banking level. You can combine several customer payments into one deposit. Does NOT affect Line 101 of your sales tax return.

CONS: The Invoices and Sales Receipts you give to your customers do not show the rounding. Could be easy to lose track of what’s been rounded.

OPTION TWO – ROUNDING AT THE SALES FORM LEVEL

Use the ROUNDING item you set up in step two to adjust for rounding directly on your Invoices and Sales Receipts. Although it affects Line 101 of a Sales Tax Return, I prefer this method. Here’s what an Invoice rounded up will look like:

Rounding Up on Invoice

And here’s what a Sales Receipt rounded down will look like:

Rounding Down Sales Receipt ii

What is key to remember is that you will always adjust for rounding directly on the SALES RECEIPT or INVOICE.

PROS: The above method of rounding is easily handled at the sales form level. You’ll never forget if you’ve rounded or not. Most importantly, the customers gets a form that shows the rounding.

CONS: This method will change Line 101 of your sales tax return by the total amount of all rounding done on sales forms for the period. For some businesses, this will be only a few pennies and hence, immaterial. Despite this hitch, there’s no effect on Line 109 Net Tax – the amount owing for GST/HST remains correct.

PART II. PURCHASES

If you receive a receipt from a vendor that’s been adjusted for rounding, here’s a way to enter that cash purchase into QuickBooks using a cheque. You can use a bill in the same manner. Let’s say you buy some office supplies for $32.97. You pay the rounded amount of $32.95. Enter the cheque as you normally would, selecting the correct CASH account, DATE, and VENDOR. In the AMOUNT box, record the rounded amount. Tab down to your expense area. On the first line, select the ROUNDING Expense account. Then enter the amount of the rounding. In this example, we’re rounding down. Enter -.02 and use the Z tax item. Then, if you simply tab to the next line, QuickBooks will automatically fill in the rest of your numbers including GST/HST.

Rounding Down on Cheque w exp tab

You can also use the ITEM tab to enter the expense. You’ll use the ROUNDING item you set up earlier which points to the ROUNDING expense account. The only drawback to using this method is that the second line doesn’t automatically calculate. You’ll have to manually enter the subtotal of your receipt and confirm that the GST/HST amount is correct.

Write Checks w item Rounding Down

Of course, if the vendor issues a receipt for the pre-adjusted amount and the rounding happens “off” the receipt, here’s a super easy way to handle it: adjust your CASH account via journal entry to the ROUNDING Expense account to address the missing/extra pennies.

These are not perfect workarounds, but they’ll do until we get that awesome ROUNDING button I’m hoping for! What will you do with your extra pennies? Save, spend, or donate to charity?

Clever trick to unapply a customer credit in QuickBooks

CUSTOMERS & CREDIT MEMOS:

Open the CREDIT MEMO you wish to unapply, and temporarily change the name of the CUSTOMER:JOB – any name will do. SAVE. This will unapply the credit. Then, change the name on the CREDIT MEMO back to the correct CUSTOMER:JOB. The credit memo is once again fully available and you can apply as you’d like.

Post Navigation