What if a QuickBooks Vendor is also a QuickBooks Customer?

Confused about what to do when a vendor is also a customer?

Especially in small business, you may find that one of your vendors is also interested in becoming a customer. Then, inevitably, tells you to deduct what he owes you on the Invoice from what you owe him on the Bill. Now what?!

First, remember that in QuickBooks, you can’t have the same name on two different lists. To handle this, simply add a -C to the customer name and/or a –V to the end of the vendor name. So, ABC the vendor becomes ABC–V and the customer is ABC–C. Easy enough.

Let’s say your company owes the vendor ABC-V $150. Enter the Bill as usual.
And, as customer ABC-C, they owe the company $50. Enter the Invoice as usual.

Basic accounting states that a payable (the bill) is normally a credit balance and a receivable (the invoice/sales receipt) is normally a debit balance. (And no, there isn’t a quiz at the end of this.) :)

1. Create an expense account, if you haven’t already, and call it something like “clearing.”

2. Create General Journal entry #1
• Credit Accounts Receivable $50 and select customer ABC-C
• Debit the Clearing expense account $50

3. Create General Journal entry #2
• Debit Accounts Payable $50 and select vendor ABC-V
• Credit the Clearing expense account $50.

This dose require two separate Journal Entries as QuickBooks will not let you create a J/E with both A/R and A/P on it.

4. Bring up the Invoice you created for ABC-C and use the ‘Apply Credits’. Select the $50 credit and save the now paid invoice.

5. When it’s time to pay the Bill you entered earlier, go into Pay Bills. You will have an option to ‘Set Credits’ in the payment window and will see the $50 credit available. Select the credit and your Amount to Pay will now be $100.

Release 6 for QuickBooks 2011 & Enterprise Solutions 11.0 is now available

Enhancements Chart

Release 6 for QuickBooks 2011 and QuickBooks Enterprise Solutions 11.0 is now available via manual update. In addition to fixing some product defects, this release introduces significant new functionality.

For a complete list of enhancements and release notes or to download and install the manual update, click here, then select the appropriate product  and version.

Note: The automatic update in-product will be available on Tuesday, March 22, 2011. We encourage you to allow this automatic update and to accept the patch.

RELEASE 6 DETAILS

The chart below outlines what’s available with R6 for each product version.

 

 

 

 

 

 

Below are just a few of the enhancements:

1. Transactions in History Pane
2. Improved Memorized Transactions
3. Batch Invoice for Time and Expenses

 

TRANSACTIONS IN HISTORY PANE

Save valuable time when accessing important information related to transactions.

What Changed: The new right pane tab on the history window shows transaction specific information like the items above. In addition, you have the ability to create notes on supported transactions, saving you time when accessing.

 

IMPROVED MEMORIZED TRANSACTIONS

With this improvement, you’ll save time when entering the same transaction multiple times!

What Changed:

A new window displays a list of the memorized transactions that are due to be entered:
We also improved the wording of the scheduling options to reduce confusion.

 

BATCH INVOICE FOR TIME AND EXPENSES

With this new feature, you will reduce the time needed to invoice multiple customers for billable time and expenses.

What Changed: The previous workflow only allowed a single invoice to be generated.

NOW, you can view billable transactions for multiple customers and view the billable amounts for time, expenses, mileage and purchased items.

You select the customers to be invoiced, generate invoices and select delivery options (email or print).

 

 

QuickBooks Backup or Portable

QuickBooks Backup File or QuickBooks Portable File, What’s the Difference?

Backup Company File:

You should always make regular backups of your Company File to protect against accidental loss or damage. The backup contains everything you need to re-create your company file and QuickBooks environment, including all of the QuickBooks files (templates, letters, logos, images, and so on) related to your company file.

The creation of a backup file (.qbb file)from within QuickBooks will also reduce the transaction log. (.tlg file) Creating a backup is the only way to incorporate the two files into one. Unlike a portable file, a backup file is typically a large file and is not meant to email. Backup files are best used to safeguard you data or to move all of your QuickBooks data to a new computer.

It is suggested that, if your company file is synced using Intuit Sync Manager, you should use a backup company file rather than a portable.

Portable Company File:

If you want to email or move your data between computers that are not networked together, then a portable file is recommended. A portable company file is a compact version of your company file and usually small enough to be sent by email or saved to portable media.

A portable file only contains a compressed version of the company financial data. Any images you use on templates, custom templates or custom letters that were created are not included in a portable file. (.qbm file)

Regardless of which file you need to create, if another person makes changes in the backup or portable company file, you cannot merge the information into the original file without the use of 3rd party software.

If you have any questions or want more information on the differences between the two file types, contact Dynamic QB Solutions.

Call (520) 762-7577 or email us at  info@DynamicQB.com.

QuickBooks Payroll Update 21208 – Includes modifications to Arizona payroll forms

Summary of Payroll Update 21208:

Tax Table Update

  • For the following state an action is required in Payroll Update 21208: New York.

Forms Update:

  • For Enhanced payroll subscribers, this Payroll Update includes state forms that were updated for the following states: Alaska, Arizona, Colorado, Connecticut, District of Columbia, Florida, Georgia, Illinois, Louisiana, Maine, Michigan, Montana, Nebraska, North Dakota, Oregon, Rhode Island, South Carolina, Vermont, Virginia, and Wisconsin.
  • For Enhanced payroll subscribers, this Payroll Update includes state forms that were removed for the following state: Colorado.
  • For Standard and Enhanced payroll subscribers this Payroll Update contains federal forms that were updated: Form 941.

E-File & Pay Update:

  • For E-File & Pay, this update includes new e-filing options for the following: Arizona and Montana.
  • For E-File & Pay, this update includes updated e-filing options for the following: Connecticut, Illinois, and Indiana.
  • For Enhanced Payroll for Accountants payroll subscribers E-File & Pay, this Payroll Update includes e-filing options that were updated for the following: Form 941/Schedule B for Reporting Agents.

How do I get the Payroll Update?


It’s important that you receive everything in the Payroll Update to make sure that you are in compliance with legislation that affects your payroll. Just follow these three simple steps:

  1. Check to see if you have Automatic Updates turned on.
    Choose Help > Update QuickBooks.
    – On the Options tab, you will see either Yes or No selected for Automatic Update.
  2. If Yes is selected, verify that you received Payroll Update 21208 from within QuickBooks. Go to Employees > Get Payroll Updates. You should see a message that says, “You are using tax table version 21208.”If you do not have version 21208, you need to download the update manually. Click here for instructions.

If No is selected for Automatic Update, you need to download the update manually per the instructions in step 2 above.

How do I move my QuickBooks to a new computer?

How do I move my existing QuickBooks file to a new computer? This question comes up quite a bit, actually. I’m sure there are many thoughts and opinions on how to do this, but here are the steps I recommend.

- First, if you still have access to the original computer, make sure QuickBooks is on the most current maintenance release for your version. Going to Help>Update QuickBooks and clicking Update Now, will download the current update if not already installed.

- If you haven’t already, open the QuickBooks company file you want to move. (If you have more than one company, you will need to follow these same steps for each one.) Create a Backup of the company file. It will have the file extension .qbb. Pay attention to where you save this backup and its name. I suggest saving to your desktop as it’s easy to find later. If you have more than one backup file in your save location, make sure the date and time are included in the backup file name.

- Once you have successfully created a backup, you will need to move this to your new computer. Using a thumb-drive or a shared network drive is easiest, but you could also create a disk with the backup file. It is not recommended that you email the file do to security and file size. Place the backup file on the desktop or in ‘your documents’ of the new computer.

- QuickBooks needs to be installed on the new computer. Once QuickBooks is installed, make sure to get the most current maintenance release as before.

- Open QuickBooks on the new computer. From the file menu, select File>Open or Restore Company… (Depending on version this may be slightly different but you are looking for a restore feature.) Browse out to the QuickBooks company backup file that you placed on your desktop on in ‘your documents’ and select it. You will need to select a location for the file to be restored to. You can use the default, or browse to any other location you’d like on your system or network.

- The restore procedure may take a few minutes depending on the size of the file, but that’s it. You should now have your QuickBooks data on a new computer. If you will no longer be using QuickBooks on the original system, feel free to un-install the program.