Monday, October 20, 2014

Credit Card Setup and Use in QB

Set up the Credit Card by going to
1. List>Chart of Accounts>right click on any item and choose new>you can also set up sub accounts if needed.  Sub Accounts are used when there is 1 main account and numerous card holders.
2. Choose Credit Card for the Type of account and enter the information
3. To enter the credit card charges go to Banking>Enter Credit Card Charges and enter all of the information needed.  Choose the proper account such as office supplies, etc.
4. If you are paying a bill that you entered go to Pay Bills and at the bottom there is a drop down box for "Method">
5. Choose credit card and the proper credit card from the list. If you don't need to enter a bill you can enter charges directly by going to Banking>Enter credit card charges.

To set up for online services make sure you have online service with your credit card company
Add the online service(s) to your QuickBooks account: Go to the Banking menu and click Online Banking, and then click Set Up Account for Online Services.

Follow the instructions in the wizard. Click Next when you complete the step(s) on each wizard page.



To reconcile:
Go to Banking>Reconcile, choose your credit card account and reconcile. If you have sub accounts you will reconcile the main account.
When the reconciliation is complete you will be given the option of writing a check or saving the check to print later or entering a bill.  (I cancel out of these screens as I prefer the credit card balance be listed on the balance sheet, not lumped into Accounts Payable).
You can change the amount to pay as QB automatically enters the full amount due. If you enter a bill then the bill will be listed in the Vendor account and post to the credit card account to reduce the credit card balance.
You can also cancel and enter a check directly at a later date. (The method I prefer)
If you choose this method when you write the check, in the Account drop down, choose the Credit Card Account.

It is a matter of whether you want your credit card register to reflect the liability for the credit card or if you want it to be part of your accounts payable.

To Download:
You must have online access to the card and the Credit Card Company must allow QB downloads.
Then go to Banking>Use Register>choose the credit card account and click the download option in the upper right and follow the prompts.


ALWAYS make sure you have a good backup prior to making any changes.

Inventory Items - setup and use

1. Go to List>Item List>right click and New.

2. For "Type" choose Inventory Part .

3. Enter a name that is descriptive for this Item.

4. Check the box that says "this service is used in assemblies....." a box will then be available so you can choose an expense account or Cost of Goods Sold.

5. On the lower right is a drop down to choose an income account.

6. This is what is called a "2 sided Item".  You can now use this Item when entering expenses and the expense will post to the Expense or Cost of Goods Sold account that you entered for the Item and you can use this Item for Income and it will post to the Income account that you have chosen.




7. Be careful when  using Inventory Items.  Make sure you Purchase the Items before you sell the Items or you will have negative Inventory.
To setup your Non Inventory Items in QuickBooks (QB)

1. Go to List>Item List>right click and New.

2. For "Type" this is up to you.  Unless you are setting up Inventory Items, choose another Type.  I always use Service because on reports that use Items, the Items are grouped by Type.  This way all of your Non Inventory Items will be grouped together alphabetically.

3. Enter a name that is descriptive for this Item.

4. Check the box that says "this service is used in assemblies....." a box will then be available so you can choose an expense account or Cost of Goods Sold.

5. On the lower right is a drop down to choose an income account.

6. This is what is called a "2 sided Item".  You can now use this Item when entering expenses and the expense will post to the Expense or Cost of Goods Sold account that you entered for the Item and you can use this Item for Income and it will post to the Income account that you have chosen.